Suwarnamala Wawhal

Senior Data Analyst | BI Reporting Specialist | Dashboard Developer

LinkedIn

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 Experience

Data Analyst - WFM & MIS

Capita

Mar 2016 - Jan 2025

Pune, Maharashtra, IN

Led comprehensive data analysis and BI initiatives for WFM & MIS, driving operational efficiency and strategic decision-making across retail and telecom sectors.

  • 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.

Retail Support Associate

Capita India

Mar 2009 - Jan 2016

Pune, Maharashtra, IN

Provided essential retail operations support, focusing on reporting, process automation, and data alignment for improved logistics visibility.

  • 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

Electronics & Communication

M.G.M's Jawaharlal Nehru College of Engineering, Dr. Babasaheb Ambedkar Marathwada University

Jan 1996 - Jan 2000

Aurangabad, Maharashtra, IN

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

Pursuing Microsoft Fabric and Artificial Intelligence