Asmita Pahade Email & Phone Number

India

Data Monetization for Customer Service Dept of Auto Finance company- Data Solution and Automation: Streamlined reporting process by consolidating existing fragmented reports, identifying critical KPIs and designing SQL procedures for automated and efficient data loading in Tableau dashboards - Project Ownership & Delivery: Created agile project plans, maintained project progress with PMO, and resolved impediments through proactive client and team engagement - Delivering Actionable insights: Designed Tableau dashboard wireframes to enable data-driven decision-making across all customer levels, from executives to operational teams.Control Automation for Monitoring Platform- Data Gathering and Process Understanding: Led discussions with 5 process owners to understand their workflows and identify opportunities for automation- Optimized monitoring process: Transformed monitoring from limited sample checks to comprehensive, full population coverage, improving frequency from monthly reviews to daily tracking.- Team Leadership and Communication: Managed a team of 3 people to develop SQL procedures for automation and monitor progress to ensure alignment with project goals

Gurugram, Haryana, India

Data Quality Monitoring and High-Risk Remediation Framework- Business Solution Design: Partnered with stakeholders to define solution scope, streamline data requirements, and ensure accurate data flow through mapping sessions.- End-to-End Delivery: Developed optimized data models, created master Tableau datasets, implemented validation templates to ensure data integrity, and facilitated knowledge transfer sessions of the solution with detailed documentation.- Continuous Improvement: Identified solution limitations, recommended future enhancements, and introduced innovative methodologies to drive broader adoption of lifecycle analysis.

India

Expense Optimization: Capital Market Division of leading Canadian Bank- Developed strategy based on profile based segmentation for focused cost optimization solutions- Coordinated with 10+ Team Leaders and industry experts across multiple asset classes to identify demand based saving opportunities by market benchmarkingLocalization of Global Enterprise Methodology - Led discussions with 15 markets/countries to understand their local regulatory requirements and update existing enterprise methodologies to make them compliant with local authorities- Established end to end process to analyze impact of updated methodology on output numbers

Gurgaon, India

Productivity Analytics and Reporting in leading US Bank:- Devised methodology to track productivity of analysts and performed behavioral segmentation based on time utilization enabling targeted coaching- Designed Tableau dashboard views for executives and team managers for upfront identification ofproblem areas leading to efficient monitoring of multi stage processes and accelerated remediationBudgeting and Forecasting Solution Development: - Developed a 360° data sphere using advanced SQL, which served as data source for 5+Power BI dashboards, acting as one stop solution for providing visibility on banks performance- Built a time series forecasting model to estimate key financial indicators

New Delhi Area, India

Aurangabad Area, India