Back to Developers
Amir Khan

Amir Khan

Data Analyst

Ponda, Goa, India 85 · Excellent

About

B.E. Computer Engineering graduate (Goa University, 2025) with strong hands-on expertise in Power BI, SQL, and Python. Built 5 end-to-end analytics projects covering Fintech, E-Commerce, HR, and Database domains — all published on GitHub. Achieved 97.73% R2 accuracy on a predictive ML model. Seeking an Associate Data Analyst role in Goa or remote/hybrid opportunities with companies in Mumbai or Bangalore.

Skills & Expertise (28)

Power BI Intermediate
7.5/10
1
Years Exp
DAX Intermediate
7.5/10
1
Years Exp
VLOOKUP Intermediate
7.0/10
1
Years Exp
SQL Intermediate
7.0/10
1
Years Exp
PivotTables Intermediate
7.0/10
1
Years Exp
Advanced Excel Intermediate
7.0/10
1
Years Exp
Python Intermediate
6.8/10
1
Years Exp
Random Forest Intermediate
6.5/10
1
Years Exp
Conditional Formatting Intermediate
6.5/10
1
Years Exp
Feature Engineering Intermediate
6.5/10
1
Years Exp
scikit-learn Intermediate
6.5/10
1
Years Exp
Statistical Modeling Intermediate
6.5/10
1
Years Exp
DBMS Intermediate
6.5/10
1
Years Exp
Complex Joins Intermediate
6.5/10
1
Years Exp
Aggregations Intermediate
6.5/10
1
Years Exp
Subqueries Intermediate
6.5/10
1
Years Exp
Jupyter Notebook Intermediate
6.5/10
1
Years Exp
Linear Regression Intermediate
6.5/10
1
Years Exp
Charts Intermediate
6.5/10
1
Years Exp
Data Modeling Intermediate
6.5/10
1
Years Exp
Power Query Intermediate
6.5/10
1
Years Exp
MySql Intermediate
6.5/10
1
Years Exp
NumPy Intermediate
6.5/10
1
Years Exp
Pandas Intermediate
6.5/10
1
Years Exp
Seaborn Intermediate
6.0/10
1
Years Exp
Matplotlib Intermediate
6.0/10
1
Years Exp
Git Intermediate
6.0/10
1
Years Exp
GitHub Intermediate
6.0/10
1
Years Exp

Work Experience

Data Analyst

PhonePe

Jan 2025 - Jan 2025

Analyzed 2+ years of UPI transaction data to track payment volume, success/failure rates, and state-level user growth across India. Built 8+ DAX measures including Transaction Success Rate, MoM Growth %, and Regional Market Share. Dark purple-themed dashboard with drill-through filters reduced manual reporting effort by ~40%.

Data Analyst

HDFC Bank

Jan 2025 - Jan 2025

Designed a banking dashboard tracking customer segments, loan performance, deposit trends, and revenue KPIs. Created 10+ DAX measures: YoY Revenue Growth, Loan Default Rate, Customer Retention Rate. Stakeholder-ready slicers by branch, product type, and quarter — supporting faster business review cycles.

Data Analyst

Flipkart

Jan 2025 - Jan 2025

Built a comprehensive E-Commerce analytics dashboard tracking Revenue, Average Order Value, Category-wise Sales, and Month-over-Month Growth to support business decision-making. Implemented drill-through filters and dynamic slicers for regional and product-level real-time analysis.

Data Analyst

HR Analytics

Jan 2025 - Jan 2025

Analyzed workforce data to identify attrition drivers — department, salary band, tenure, and job satisfaction. Built KPIs for Attrition Rate, Headcount by Department, and Avg Salary Distribution using DAX. Insights highlighted high-risk employee segments, simulating HR interventions to reduce attrition.

SQL Data Analyst

Hospital Management

Jan 2025 - Jan 2025

Wrote 10+ complex SQL queries including multi-table JOINs, GROUP BY aggregations, date functions, and subqueries. Extracted insights on patient admission trends, doctor performance, and department-wise revenue. Completed as part of 30-Days SQL Micro Course by Satish Dhawale (SkillCourse).

Data Scientist

Temperature Prediction ML Model

Jan 2024 - Jan 2024

Built a high-accuracy regression model using Scikit-learn Pipeline with Feature Engineering, achieving 97.73% R2 Score. End-to-end ML pipeline reduced manual preprocessing steps by 60%.

Education

Bachelor of Engineering (B.E.) in Computer Engineering - Goa University

2021 - 2025 · Afghanistan

Certifications

30-Days SQL Micro Course Certificate

SkillCourse · 2026

Microsoft Power BI Certificate

EduSkills · 2025

Data Science Professional Course

CodeWithHarry · 2025

IBM Certificate: AI in Practice

IBM · 2024

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 5/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceJul 2026