About
Results-oriented Data Analyst with hands-on expertise in SQL, Power BI, Python, and Excel. Built end-to-end analytics pipelines uncovering actionable insights from 9,800+ transaction records. Skilled at translating complex datasets into business-ready KPIs, trend reports, and executive dashboards.
Skills & Expertise (32)
Work Experience
E-Commerce Sales Analytics Dashboard
Personal Portfolio Project
Present - Present
Cleaned and analyzed 9,800+ retail transactions in MySQL, resolving quality issues across 15+ fields with 100% import integrity. Revealed that the top 20% of customers drove ~48% of revenue; Technology/Machine lines had 23% higher AOV — surfaced via CTEs and window functions. Detected 30%+ seasonal revenue spikes in Q4 across 3 regions through time-series SQL analysis, enabling forecasting and inventory planning recommendations. Delivered a 5-page interactive Power BI dashboard (KPI cards, regional heat maps, product treemaps) and documented 20+ SQL queries on GitHub.
SQL Business Case Studies — Real-World Analytics
Self-Directed Portfolio
Present - Present
Solved 15+ business-oriented SQL problems spanning customer churn, revenue cohorts, and operational KPIs using Joins, CTEs, and Window Functions (RANK/DENSE_RANK). Refactored nested subqueries into CTEs; published structured solutions with business context and findings on GitHub.
Education
B.Tech – Computer Science & Engineering - Tula's Institute, Dehradun
- 2025 · Afghanistan
Diploma – Computer Science & Engineering - Government Polytechnic, Latehar
- 2022 · Afghanistan
Certifications
Cloud Computing
NPTEL / IIT Kharagpur · 2025
Artificial Intelligence Program
Infosys Foundation & ICT Academy · 2024
Python with Machine Learning
Briztech Infosystems · 2021
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Depends on Offer
Skills (32)
Click a skill to find developers with the same skill