About
High-achieving CS graduate (CGPA: 9.62) with proven ability to build end-to-end data pipelines, dimensional models, and interactive BI dashboards using SQL, Python, and Power BI. Delivered 4 analytics projects from raw data ingestion to actionable business insight. Seeking Data Analyst / Business Analyst roles.
Skills & Expertise (26)
Work Experience
Data Analyst
E-Commerce Sales Performance Dashboard
Present - Present
Built end-to-end ETL pipeline on 100K+ orders across 9 tables using Python and SQLAlchemy, loading into MySQL for analysis. Implemented 3-layer medallion architecture (staging → silver → gold) with star schema across 8 dimension tables — reducing query complexity and enabling direct Power BI connection to clean gold layer data. Wrote 10+ advanced SQL queries (CTEs, window functions, JOINs) revealing top 3 categories drive 60%+ of revenue.
Data Analyst
HR Analytics — Employee Attrition Dashboard
Present - Present
Analyzed 1,470 records across 35 variables — found overtime employees leave at 3x the rate (30.5% vs 10.4%). Uncovered 18–25 age group has 34.8% attrition and Sales Reps earn ₹6,220 below dept average using CTEs and window functions. Delivered stakeholder dashboard with 3 KPI cards and 5 visuals — surfacing 3 critical HR findings including 34.8% attrition among youngest cohort and 3x overtime attrition risk for 237 at-risk employees.
Data Analyst
Interactive BI Dashboard — Spotify Global Charts
Present - Present
Analysed 50K+ streaming records, built multi-page dashboard with 15+ DAX measures deployed on Power BI Service. Dynamic slicers (year, artist, album type) — key finding: explicit tracks gain traction 2x faster, 25% accuracy boost.
Data Analyst
Uber Ride Analytics — EDA + SQLite Pipeline
Present - Present
Automated pipeline ingesting 500K+ ride records into SQLite with 30% data quality improvement via null handling and outlier removal. Identified top 10 pickup locations, peak demand hours, and high-surge weekdays from EDA using Matplotlib and Seaborn.
Education
B.E. in Computer Science Engineering - Chitkara University
2020 - 2024 · Afghanistan
Certifications
SQL Bootcamp
ITM Edutech Training Pvt. Ltd. in collaboration with National Skill Development Corporation (NSDC) · 2026
Excel Bootcamp
ITM Edutech Training Pvt. Ltd. in collaboration with NIESBUD · 2026
Introduction to Python
Coding Ninjas, Chitkara University · 2021
