About
Data Analyst with hands-on experience building end-to-end BI dashboards and SQL-driven analyses across three independent projects (E-Commerce Customer Segmentation, Zomato Performance, EV Market Insights), turning raw datasets into stakeholder-ready insights using DAX, Python (Pandas, Seaborn, Matplotlib), and advanced Excel. Skilled in writing SQL queries with joins, CTEs, window functions, and subqueries to clean, model, and aggregate data, and in documenting analytical workflows for cross-functional teams. Seeking to bring hands-on analytics and dashboard-development skills to a Junior Data Analyst role.
Skills & Expertise (25)
Work Experience
Data Analyst
E-Commerce Customer Segmentation & Retention Analysis
Present - Present
Segmented 90,000+ customers into behavioral groups by performing RFM (Recency-Frequency-Monetary) analysis in Python, identifying an at-risk segment representing 18% of total revenue. Modeled and cleaned a multi-table e-commerce dataset of 100,000+ orders by writing SQL queries using joins, CTEs, and window functions to calculate cohort retention and repeat purchase rates. Built a Power BI dashboard with custom DAX measures for revenue per segment, repeat purchase rate, and customer lifetime value, translating findings into a retention-targeting recommendation for stakeholders.
Data Analyst
Zomato Performance & Sales Analysis
Present - Present
Uncovered a 15% increase in identifiable revenue opportunities by building an interactive Power BI dashboard with custom DAX measures, tracking KPIs across revenue, customer ratings, and city-wise market share for stakeholder review. Cleaned and structured 10,000+ rows of restaurant and order data by writing SQL queries using joins, group by, and subqueries to aggregate sales metrics and eliminate inconsistencies. Identified peak ordering windows and top-performing cuisines by analyzing customer ordering patterns across 3 cities, delivering insights that informed simulated menu and staffing decisions.
Data Analyst
Electric Vehicle (EV) Market Insights & Trend Analysis
Present - Present
Surfaced 5 key adoption trends across manufacturers and regions by performing exploratory data analysis on 5,000+ EV records using Python (Pandas, NumPy). Visualized battery efficiency and range patterns across 5 manufacturers by building comparative charts in Seaborn and Matplotlib, translating technical findings into a documented analytical workflow for non-technical stakeholders. Forecasted regional EV growth hotspots by evaluating manufacturer market share and adoption data, presenting findings through a cross-functional-ready Power BI report with clear written summaries for review.
Education
Bachelor of Arts (B.A.) - University of Delhi (DU SOL)
- · Afghanistan
Certifications
Data Analytics Master Program
Skill Circle · 2026
Interested in this developer?
Profile Score Breakdown
Profile Overview
Availability Details
Relocation
Depends on Offer
Skills (25)
Click a skill to find developers with the same skill
