About
Fresher Data Analyst skilled in SQL, Python, and Power BI, with hands-on experience turning raw data into actionable insights. Independently built three end-to-end analytics projects — including a 98K+ order e-commerce analysis that uncovered a 40% customer satisfaction drop linked to delivery delays. Strong in advanced SQL, data cleaning, and interactive dashboards that make findings clear for both technical and business audiences.
Skills & Expertise (32)
Work Experience
Data Analyst
E-Commerce Data Analytics System
Present - Present
Analyzed 98,666 e-commerce orders generating R$13.6M in revenue, identifying a 91.9% on-time delivery rate and an average order value of R$137.75. Identified that late deliveries reduced average customer review scores by 40% (4.29 to 2.57), highlighting delivery speed as the primary driver of customer satisfaction. Discovered that the top 10 of 71 product categories contributed 62% of total revenue, revealing significant revenue concentration within a limited product portfolio. Found São Paulo accounted for 38% of total revenue while maintaining the fastest average delivery time (8.3 days); northern states such as Roraima and Amapá experienced the slowest deliveries (26–28 days). Determined that the top 10 of 3,095 sellers generated only 13% of GMV, indicating a broadly distributed seller ecosystem rather than dependence on a few high-performing sellers. Identified a positive correlation (r = 0.33) between payment installments and order value, demonstrating that customers were more likely to finance higher-value purchases through installment plans.
Data Analyst
Netflix SQL Project
Present - Present
Conducted end-to-end SQL analysis on a large Netflix dataset to uncover data-driven insights for content strategy and audience targeting. Wrote advanced queries using CTEs, window functions, correlated subqueries, and aggregations to solve 15+ complex analytical problems. Performed data cleaning using string parsing and date functions to handle inconsistent formats, null values, and duplicate records for accurate analysis. Extracted insights on content distribution, genre trends, regional production patterns, and audience preferences across multiple dimensions. Applied ranking and trend analysis using window functions (RANK, DENSE_RANK, ROW_NUMBER) to identify top-performing categories and content patterns. Optimized query execution by restructuring joins and subqueries, improving data retrieval performance on large datasets.
Data Analyst
Dominos Store SQL Project
Present - Present
Designed and implemented a normalized relational database for a Domino's store system with structured tables for orders, customers, and products. Wrote complex SQL queries using multi-table JOINs, GROUP BY, and aggregations to analyse sales volumes, order patterns, and revenue trends. Identified top-selling menu items, peak order hours, and repeat customer behaviour through targeted aggregation and filtering queries. Performed data cleaning and filtering on transactional records to eliminate nulls, duplicates, and inconsistencies for reliable analysis. Applied PRIMARY KEY, FOREIGN KEY, and NOT NULL constraints with structured schema design to enforce data integrity across all tables. Optimized query performance by refining join logic and filtering conditions for efficient retrieval from high-volume transactional data.
Education
Master of Computer Application (MCA) - Institute of Management & Technology
- 2025 · Afghanistan
Bachelor of Computer Application (BCA) - Institute of Management & Technology
- 2023 · Afghanistan
Certifications
No certifications added yet
Interested in this developer?
Profile Score Breakdown
Profile Overview
Skills (32)
Click a skill to find developers with the same skill
