Data Analyst with hands-on experience in retail and commercial analytics across a 470+ store network. I've worked across category analytics, pricing & margin, promotional analytics, and customer intelligence at Giant Eagle's Global Capability Center in Bengaluru.

I work primarily in SQL, Python, and Power BI — focused on turning business questions into structured analysis and clear, decision-ready insights.

35-question SQL case study on a real-world dataset of 980 smartphones across 46 brands. Covers market segmentation, brand positioning, pricing strategy, 5G adoption, feature analysis, and competitive intelligence. Demonstrates the full SQL spectrum from basic aggregations to window functions, CTEs, correlated subqueries, and statistical measures.

Key findings: Xiaomi dominates Budget and Mid-Range; Apple leads Flagship but rates below several Android competitors; only 4.18% of phones qualify as truly feature-complete; fast charging is a Chinese brand battleground.

SQL MySQL Window Functions CTEs Business Intelligence Market Analysis

End-to-end churn analysis on 7,043 telecom customers. Identified that the highest-risk segment (Month-to-Month contract + Fiber Optic) churns at 54.6%. Quantified ₹2.86M revenue at risk from churned customers and developed a high-risk customer persona to prioritise retention spend.

Python Pandas Seaborn Matplotlib EDA Churn Analysis Revenue Analysis

Customer segmentation and A/B test analysis on retail chip category sales. Applied control store selection methodology using correlation and magnitude distance scoring, ran t-tests to validate trial store impact, and delivered a consulting-style presentation with uplift measurement.

Python Pandas A/B Testing Statistical Analysis Retail Analytics

SQL case study covering revenue performance, customer acquisition channels, product trends, and business KPI analysis using joins, aggregations, window functions, and segmentation queries.

SQL KPI Analysis Revenue Reporting Business Intelligence

Advanced Excel case study covering market share analysis, CAGR calculations, growth segmentation, and anomaly detection using dynamic formulas and pivot analysis.

Excel Market Analysis CAGR Business Analysis

Core stack: SQL (Snowflake, Databricks, MySQL) · Python (Pandas, NumPy, Matplotlib, Seaborn) · Power BI (DAX, Data Modeling) · Advanced Excel · Tableau

What I do with them: Customer segmentation · Churn analysis · Pricing & margin analysis · Promotional analytics · Sales performance reporting · A/B testing · EDA · KPI dashboards · Market segmentation

Enterprise Insights Analyst — Giant Eagle GCC, Bengaluru (Rotational Program) Worked across four analytics functions over 9 months:

• Category Analytics — assortment performance and shelf productivity analysis
• Pricing & Margin — competitive pricing benchmarks across 470+ stores
• Promotional Analytics — campaign effectiveness and ROI measurement
• Customer & Market Intelligence — segment-level behaviour and retention analysis

Signature project: Automated weekly Smart Narrative reporting in Power BI, reducing a 3–4 day manual process to under 10 minutes.

• MSc — Big Data Analysis | St. Joseph's University, Bengaluru | 2025
• BCA | St. Joseph's College, Darjeeling

Certifications:

• SQL Advanced + SQL Intermediate — HackerRank (Apr 2026)
• Python Basic — Verified — HackerRank (Mar 2026)
• Mastering Data Analysis using Microsoft Excel (Formulas & Pivot Tables) — Alison (Mar 2026)
• VBA for Beginners — Alison (Apr 2026)
• Data Analytics Job Simulation (Python — EDA, A/B Testing, Statistical Reporting) — Quantium / Forage (Mar 2026)
• Tableau: Data Visualization and Analysis — Tableau (Aug 2024)
• Power BI: Introduction to Power BI — Microsoft (May 2024)