Suwarnamala Wawhal
Senior Data Analyst | BI Reporting Specialist | Dashboard Developer
Aurangabad, IN.About
Highly accomplished Data Analyst with over 8 years of experience in building high-impact KPI dashboards, automating MIS, and optimizing reporting systems across retail, telecom, and operations. Expertly leverages Power BI, SQL, Tableau, and Excel/VBA to deliver 25+ interactive dashboards, saving 30+ hours/month, reducing decision lag by 20-40%, and improving payout accuracy by 80%. Proven ability in KPI governance, robust data modeling, and executive reporting to drive strategic decision-making and operational efficiency.
Work
Capita
|Data Analyst - WFM & MIS
Pune, Maharashtra, India
→
Summary
Led comprehensive data analysis and BI initiatives for WFM & MIS, driving operational efficiency and strategic decision-making across retail and telecom sectors.
Highlights
Pioneered the design and deployment of 25+ interactive KPI dashboards using Power BI, Excel/VBA, Looker Studio, and SAP BO, adopted by over 48 managers and leaders, reducing decision-making lag by 20%.
Automated critical MIS packs with Power Query and VBA, saving 30+ hours monthly and ensuring timely distribution before business hours.
Re-engineered the incentive system for 400-500 sellers, cutting cycle time from 8 hours to 3 hours and reducing errors by 80%, leading to accurate payouts.
Unified five disparate data sources (SQL, SAP BO, Excel, Sheets, CSV) into a governed reporting layer, increasing data accuracy by 15% and decreasing consolidation time by 40%.
Modeled over 1 million rows/month utilizing Power Pivot and SQL stored procedures, enhancing refresh speed by 50% and reducing data latency by 40%.
Developed executive scorecards for sales, budget, quality, and occupancy with Row-Level Security, empowering secure self-serve analytics for leadership.
Capita India
|Retail Support Associate
Pune, Maharashtra, India
→
Summary
Provided essential retail operations support, focusing on reporting, process automation, and data alignment for improved logistics visibility.
Highlights
Supported retail operations reporting for orders, fulfillment, and delivery using Excel/Sheets and SAP BO, ensuring data accuracy and accessibility.
Automated delivery and MIS routines, saving over 30 hours per month through the implementation of standardized reporting templates.
Enhanced logistics visibility by effectively aligning store, inventory, and delivery data, and establishing standardized SOPs with governed access controls.
Education
M.G.M's Jawaharlal Nehru College of Engineering, Dr. Babasaheb Ambedkar Marathwada University
→
Bachelor of Engineering
Electronics & Communication
Skills
BI & Visualization
Power BI, Tableau, Looker Studio, SAP BO, Executive Dashboards, Scorecards.
Data & Modeling
SQL Server, Power Query, Power Pivot, DAX, Data Modeling, Data Integration, ETL.
Programming
Python, VBA, Excel (Advanced), Google Sheets.
Reporting & Analytics
MIS Automation, KPI Governance, WFM Reporting, Operations Reporting, Self-Serve Analytics, Performance Optimization, Data Analysis.
Process Improvement
Incentive System Re-engineering, SOP Development, Workflow Optimization.