Supriya Shiwdikar

Supriya Shiwdikar

MIS Analyst
India
Marathi, Hindi, English

About Me

Senior Data Analyst / MIS Analyst with 10+ years of experience in BFSI and financial services. Strong expertise in SQL, Power BI, Advanced Excel, and Python for data analysis, MIS reporting, dashboard development, and au…

Experience

Manager, Recovery MIS

Kotak Mahindra Bank

Analysed GNPA, overdue, and recovery datasets using SQL and Excel to deliver daily, weekly, and monthly MIS reports for senior leadership, Built automated Excel dashboards to track recovery KPIs, reducing manual reporting effort by ~30%, Performed data validation and reconciliation to ensure high data accuracy and reporting reliability, Prepared management presentations highlighting trends, risks, and actionable insights for review meetings, Supported Business Head with data-driven insights for monthly and quarterly performance reviews

Senior Executive, MIS

Motilal Oswal Financial Services

Generated and analyzed MIS and market share reports for business decisions, Prepared KPI and incentive analysis reports for management, Delivered ad-hoc analytical reports using Excel and SQL

MIS Executive

Andromeda BPO Pvt Ltd

Generated and maintained daily, weekly, and monthly MIS reports, Prepared operational performance reports for inbound and outbound processes, Managed shift schedules, weekly rosters, and workforce trackers

WFM Analyst

Axis Securities Ltd

Designed productivity and workforce performance dashboards using Advanced Excel, Analyzed agent utilization, productivity, and performance metrics, Automated recurring MIS reports to improve reporting efficiency, Prepared monthly business review (MBR) dashboards for leadership

Manager, Recovery MIS

Kotak Mahindra Bank | Mumbai

Analysed GNPA, overdue, and recovery datasets using SQL and Excel to deliver daily, weekly, and monthly MIS reports for senior leadership
Built automated Excel dashboards to track recovery KPIs, reducing manual reporting effort by ~30%
Performed data validation and reconciliation to ensure high data accuracy and reporting reliability
Prepared management presentations highlighting trends, risks, and actionable insights for review meetings
Supported Business Head with data-driven insights for monthly and quarterly performance reviews

Senior Executive, MIS

Motilal Oswal Financial Services | Mumbai

Generated and analyzed MIS and market share reports for business decisions
Prepared KPI and incentive analysis reports for management
Delivered ad-hoc analytical reports using Excel and SQL

WFM Analyst

Axis Securities Ltd | Mumbai

Designed productivity and workforce performance dashboards using Advanced Excel
Analyzed agent utilization, productivity, and performance metrics
Automated recurring MIS reports to improve reporting efficiency
Prepared monthly business review (MBR) dashboards for leadership

MIS Executive

Andromeda BPO Pvt Ltd | Mumbai

Generated and maintained daily, weekly, and monthly MIS reports
Prepared operational performance reports for inbound and outbound processes
Managed shift schedules, weekly rosters, and workforce trackers

Skills

Advanced Excel Data Analysis & Trend Analysis MIS & Management Reporting KPI & Performance Reporting Dashboard Development & Data Visualization Data Cleaning & Validation Automation & Process Improvement Python (Pandas – Basic/Intermediate) MySQL & Relational Databases BFSI & Operational Analytics Stakeholder & Leadership Reporting Pivot Tables XLOOKUP Dashboards Automation Data Analysis Trend Analysis MIS Reporting Management Reporting KPI Reporting Dashboard Development Data Visualization Data Cleaning Data Validation Process Improvement Python Pandas MySQL Relational Databases SQL Power BI BFSI Operational Analytics Stakeholder Reporting Leadership Reporting DAX Data Modeling
Report this Profile?