Rucha

Results-driven Data Analyst with 3+ years of experience translating complex datasets into actionable business insight across telecom, retail, and project operations. Proven track record of building end-to-end reporting solutions — from ETL pipelines processing 5–10 GB/day to executive dashboards that cut reporting turnaround by up to 40%. Skilled in Python, SQL, PySpark, and Azure/Databricks, with a strong foundation in consumer behavior analysis, statistical research, and data storytelling for senior stakeholders.

Data Analyst at Broadway (2026-01 – Present)

• Design and maintain leadership dashboards tracking project performance, improving visibility across the store rollout portfolio by 30% and cutting leadership reporting turnaround time by 40%.
• Consolidate and validate data across MS Project, Excel, SharePoint, and Dataverse, lifting reporting accuracy by 25% and eliminating 35% of manual data reconciliation effort.
• Conduct schedule variance and Earned Value Analysis (EVA) to monitor portfolio health, contributing to a 20% improvement in on-time project delivery and a 15% reduction in cost overruns.
• Partner with the PMO to evaluate store rollout performance, schedule adherence, and cost efficiency, surfacing risks before they impact delivery timelines.
• Collaborate cross-functionally with project managers, design, procurement, and finance teams to standardize data consolidation and reporting workflows.

Data Analyst at Musgrave (2025-01 – 2025-08)

• Built and maintained ETL pipelines in PySpark and Databricks, processing 5–10 GB of data daily to ensure uninterrupted data availability for enterprise reporting.
• Architected structured research databases in Excel and Databricks, ensuring high-quality, analysis-ready datasets for cross-functional teams.
• Analyzed category trends, consumer behavior patterns, and store-level KPIs, producing research summaries and insight decks for business stakeholders.
• Ran large-scale exploratory analysis in PySpark to uncover business trends, directly informing product and operational decisions.
• Presented data-backed recommendations to senior stakeholders in recurring business review meetings, driving adoption of insight-led decision-making.

Analyst at Capgemini (2021-06 – 2023-03)

• Delivered market and customer research for telecom and retail clients, performing exploratory data analysis using Python, SQL, and Excel.
• Analyzed customer churn indicators, usage patterns, and retail category trends using structured research methodologies to guide client strategy.
• Built KPI dashboards for telecom and retail accounts, translating findings into research briefs and PowerPoint insight reports for client leadership.
• Maintained research datasets and trend trackers supporting weekly and monthly client reporting cycles.
• Partnered with product, operations, and marketing teams to convert research findings into actionable business recommendations.

Master of Science in Business Analytics – Trinity College Dublin (2024-10)

Bachelor of Engineering in Information Technology – University of Mumbai (2021-05)