Open to opportunities

Amir
Khan

B.E. Computer Engineering graduate turning raw data into clear business insights through Power BI, SQL, and Python.

Power BI SQL · MySQL Python · Pandas Advanced Excel DAX · Power Query Machine Learning

Data Analyst
Based in Goa

I'm a B.E. Computer Engineering graduate (Goa University, 2025) with a passion for transforming complex datasets into clear, actionable business insights.

I specialize in building interactive Power BI dashboards covering Fintech, E-Commerce, and HR domains. I've also built predictive ML models achieving 97.73% R² accuracy.

Currently seeking an Associate Data Analyst role — open to Goa-based positions and remote/hybrid opportunities with companies in Mumbai or Bangalore.

5+
Projects Built
97.7%
ML Accuracy
4+
Certifications
2025
Graduation Year

Core Proficiency

Power BI
90%
SQL
80%
Python
82%
Excel
85%
DAX
80%
ML / Scikit
72%

Featured Projects

Fintech · UPI Analytics

PhonePe Pulse Transaction Analytics Dashboard

Analyzed 2+ years of UPI transaction data to track payment volume, success/failure rates, and state-level user growth across India.

8+ DAX measures · Success Rate, MoM Growth, Regional Market Share · ~40% faster reporting

Power BIDAXPower QueryUPI Data
Fintech · Banking Analytics

HDFC Bank Analytics Dashboard

Banking dashboard tracking customer segments, loan performance, deposit trends, and revenue KPIs with stakeholder-ready slicers.

10+ DAX measures · YoY Growth, Loan Default Rate, Customer Retention · Slicer by branch & quarter

Power BIDAXBanking KPIsData Modeling
E-Commerce · Sales Analytics

Flipkart Sales Intelligence Dashboard

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.

Revenue & AOV tracked across categories · MoM Growth % via DAX · Dynamic slicers for regional + product-level analysis

Power BIDAXE-CommercePower Query
HR Analytics · People Data

HR Analytics — Employee Attrition Dashboard

Identified key attrition drivers — department, salary band, tenure, and job satisfaction — to simulate HR interventions.

Attrition Rate KPI · Headcount by Dept · High-risk segment identification using DAX

Power BIDAXHR AnalyticsAttrition
SQL · Database Analysis

SQL Data Analysis — Hospital Management Database

Wrote 10+ complex SQL queries on hospital data — multi-table JOINs, GROUP BY aggregations, date functions, and subqueries.

Admission trend analysis · Doctor performance · Department-wise revenue insights

MySQLJOINsAggregationsSubqueries
Machine Learning · Predictive Modeling

Temperature Prediction ML Model

High-accuracy regression model using Scikit-learn Pipeline with Feature Engineering — one of the top results in training cohort.

97.73% R² Score · Scikit-learn Pipeline · 60% reduction in preprocessing steps

PythonScikit-learnRegressionFeature Engineering

Technical Skills

📊

Business Intelligence

Building interactive dashboards that translate raw data into executive-ready insights.

Power BIDAXPower QueryData Modeling
🗄️

SQL & Databases

Writing complex queries for real-world relational database analysis and reporting.

MySQLJOINsAggregationsSubqueriesDBMS
🐍

Python & Analytics

Data manipulation, visualization, and predictive modeling for business problems.

PandasNumPyMatplotlibSeaborn
📈

Advanced Excel

PivotTables, VLOOKUP, Power Query, Conditional Formatting, and dynamic charting.

PivotTablesVLOOKUPPower QueryCharting
🤖

Machine Learning

Building and validating predictive models using industry-standard ML libraries.

Scikit-learnRegressionRandom ForestFeature Engineering
🛠️

Tools & Platforms

Version control, development environments, and data pipeline tooling.

GitGitHubJupyterStatsmodels

Certifications

Microsoft Power BI Certificate

EduSkills

Completed Nov 2025

🎯

Data Science Professional Course

CodeWithHarry

Completed Nov 2025

🧠

IBM AI in Practice Certificate

IBM

Completed Jan 2024

📝

30-Days SQL Micro Course Certificate

SkillCourse · Instructor: Satish Dhawale

✅ Completed · June 2, 2026

Open to
Opportunities

Looking for Associate Data Analyst roles in Goa or remote/hybrid. Available immediately.

📍 Ponda, Goa · Available for Goa / Remote / Hybrid roles