About
Results-driven Data Analyst with hands-on expertise in SQL, Power BI, and Excel, complemented by a strong analytical foundation from an M.A. in Economics. Proven ability to transform complex datasets into actionable business insights through interactive dashboards, trend analysis, and data-driven reporting. Adept at end-to-end data analysis workflows — from data extraction and cleaning to visualization and strategic recommendation — with a business-impact-first mindset.
Skills & Expertise (23)
Work Experience
Data Analyst
E-Commerce Sales Performance Dashboard
Jan 2024 - Jan 2024
Designed and deployed an end-to-end interactive sales analytics dashboard for a simulated e-commerce dataset comprising 50,000+ transaction records, enabling stakeholder-ready business intelligence reporting. Analyzed multi-dimensional sales data across product categories, regions, and time periods to uncover revenue trends and customer purchasing patterns. Built dynamic Power BI dashboards featuring 10+ visualization types — bar charts, donut charts, scatter plots, maps, and time-series line charts — with drill-down capabilities via slicers and filters. Engineered calculated columns and DAX measures to derive KPIs including Month-over-Month (MoM) revenue growth, Average Order Value (AOV), and customer retention rates. Integrated multiple data tables using Power Query joins and established data model relationships, enabling cross-dimensional analysis. Delivered insights that identified top-performing product segments contributing 38% of total revenue, reducing manual reporting effort by ~60% through dashboard automation.
Data Analyst
Pizza Hut
Jan 2024 - Jan 2024
Conducted a comprehensive SQL-driven sales analysis on a Pizza Hut transactional dataset to identify revenue drivers, optimize product strategy, and support data-backed operational decisions. Authored 20+ complex SQL queries using JOINs, CTEs, window functions, and aggregations to segment sales by product category, time period, store location, and order size. Identified that a specific product category was significantly underperforming relative to its inventory allocation; analysis directly informed a targeted promotion strategy that drove a 15% uplift in category sales. Performed Pareto analysis revealing that the top 3 pizza variants accounted for 62% of total revenue, enabling focused inventory and marketing prioritization. Supplemented SQL analysis with Python (Pandas, Matplotlib) for advanced EDA, trend visualization, and correlation analysis between order frequency and revenue contribution. Delivered a structured findings report with actionable recommendations, demonstrating the business impact of data-driven product and pricing decisions.
Education
Master of Arts — Economics - Dr. Ram Manohar Lohia Avadh University
2023 - 2025 · Afghanistan
Bachelor of Arts — Economics - KS Saket PG College
2020 - 2023 · Afghanistan
Class XII — CBSE (English Medium) - Kendriya Vidyalaya
- 2020 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Visa Status
Citizen
Relocation
Open to Relocation
Skills (23)
Click a skill to find developers with the same skill
