

Data Analyst with experience in management, reporting and analysis. Skilled in SQL, Python(Pandas, Numpy, Matplotlib) and Power BI, with expertise in data processing, visualization and automation. Proven ability to analyze large datasets to drive business insights and streamline workflows
Ghaziabad, Uttar Pradesh
201014
PhonePe Data Analysis | Python | July 2025
• Conducted a comprehensive analysis of transaction trends using Python libraries (Pandas, NumPy, Matplotlib, Seaborn, OS), uncovering key market behaviors and informing business strategy
• Identified peak transaction hours and top-performing states, aiding targeted marketing efforts.
• Automated data extraction and visualization workflows, reducing manual effort by 60%.
E-Commerce Analysis | SQL | April 2025
• Leveraged SQL to perform customer segmentation, sales trend analysis, and inventory optimization, resulting in reduction in stockouts and a 15% increase in sales forecasting accuracy.
• Built complex queries to analyze repeat customer behavior and high-margin product categories.
• Findings informed email retention campaigns that led to a 12% boost in returning customers within 3 months.
Retail Insights Dashboard | Power BI | Feb 2025
• Designed a Power BI dashboard analyzing 50 stores and 300+ SKUs, enabling leadership to view KPIs by category and region.
• Used DAX for profit margin analysis, stock turnover, and YoY trends, highlighting a 15% drop in specific product lines.
• Enabled stakeholders to identify slow-moving items and reduce excess stock by 22% within two quarters.
Sales Dashboard & Forecasting | Advanced Excel | Feb 2025
• Built a dynamic Excel dashboard to analyze 15K+ monthly sales records across 4 regions and 12 products.
• Used pivot tables, VLOOKUP, conditional formatting, and charts to visualize revenue, units sold, and growth trends.
• Applied linear regression to forecast next-quarter sales with 93% accuracy, helping reduce inventory gaps by 18%.