About
MCA graduate with hands-on experience building end-to-end analytics and automated reporting solutions using Power BI, SQL, Python, and Excel VBA. Proficient in DAX (time intelligence, KPI measures), Power Query ETL pipelines, star schema data modeling, Power Pivot, and process automation to deliver actionable business insights. Completed 4 real-world projects covering sales analysis, data transformation, and customer segmentation. Seeking a fresher Data Analyst, Reporting Analyst, or MIS Analyst role.
Skills & Expertise (34)
Work Experience
Data Analyst
E-Commerce Sales Dashboard
Present - Present
Designed star schema data model with fact and date dimension tables for structured, scalable reporting. Created DAX measures using CALCULATE, FILTER, DIVIDE, SUMX — KPIs: Total Sales, Profit Margin %, Return Rate. Implemented time intelligence (SAMEPERIODLASTYEAR, TOTALYTD, PREVIOUSMONTH) for YoY and MoM growth tracking. Built interactive dashboard with slicers for region, date, and payment method — insights on sales trends, top products, and regional performance.
Data Analyst
Superstore Sales Automation Dashboard
Present - Present
Developed automated reporting tool by connecting Fact and Dimension tables in Power Pivot to create a relational data model. Authored DAX measures (Total Sales, Profit Margin %, Order Count) to provide real-time business performance metrics. Programmed VBA Macros to automate the Refresh & Format workflow, reducing manual report preparation time and ensuring UI consistency. Designed interactive interface with a custom macro trigger button for seamless one-click stakeholder reporting.
Data Analyst
Movie Data Cleaning & Transformation
Present - Present
Performed end-to-end ETL on a real-world messy movie dataset — cleaned inconsistent column names, removed duplicates, and fixed data types. Handled missing and null values; applied conditional logic to classify movies as Hit or Flop using Power Query. Created calculated columns (Profit, Popularity Score), used Group By aggregation, and applied Pivot/Unpivot to restructure data for analysis.
Data Analyst
E-Commerce Customer Behaviour Analysis
Present - Present
Performed data cleaning, EDA, and visualisation on customer transaction data using Pandas, NumPy, and Seaborn. Applied K-Means clustering to segment customers into high-value, low-value, and inactive groups. Delivered recommendations to optimise discount strategy and improve customer retention based on purchase pattern analysis.
Education
Master of Computer Applications (MCA) - CMR University
- 2025 · Afghanistan
Bachelor of Computer Applications (BCA) - Techno India
- 2019 · 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 (34)
Click a skill to find developers with the same skill
