Madhavi M
Senior Data Analyst with 5+ years of experience delivering financial analysis, budget, forecast, and variance reporting, transforming complex datasets into actionable business insights using SQL, Python, and Power BI. Experienced in advanced SQL development including CTEs, window functions, and query optimization across enterprise databases, working with datasets of 10M+ records. Skilled in building ETL workflows, data validation frameworks, reconciliation processes, data models, and automated financial reporting using Python, Power BI, DAX, and cloud data platforms, reducing manual reporting effort by 40%. Hands-on experience analyzing transactional, financial, and operational datasets through exploratory data analysis, hypothesis testing, KPI development, anomaly detection, and trend identification, presenting findings to 10+ business stakeholders.
Work History
Sr. Data Analyst
1 Year 8 Months- Developed complex SQL queries using joins, CTEs, aggregations, and window functions to analyze customer, account, and transactional data, supporting financial performance, trend, and variance analysis; optimized queries to cut runtime by 40%.
- Designed and implemented data validation and reconciliation frameworks for T24 datasets covering 10M+ records, improving data accuracy to 99% for enterprise reporting.
- Built Python (Pandas, NumPy) transformation pipelines for data cleansing, normalization, and reporting preparation, saving 8+ hours per week of manual effort.
- Created 5 Power BI dashboards with DAX-driven analytics covering operational trends, transaction insights, and risk indicators for 4 business teams, and presented findings through narrative-driven presentations.
- Partnered with business and finance stakeholders to gather requirements and translate complex financial data into clear recommendations that supported decision-making.
Data Analyst
2 Years 2 Months- Developed Oracle SQL solutions with joins, subqueries, and analytical functions to analyze 5M+ financial records for budget, forecast, and variance reporting.
- Designed and maintained Snowflake data warehouse processes integrating 4 source systems, improving report turnaround time by 30%.
- Implemented ETL validation workflows with automated checks for completeness, duplicates, and inconsistencies across financial data transformation pipelines, reducing data errors by 30%.
- Performed exploratory data analysis and anomaly detection to identify 15+ reporting issues, data patterns, and quality gaps within enterprise datasets.
Data Analyst
1 Year 4 Months- Analyzed, cleaned, and integrated data from 4 internal systems to create structured datasets that enhanced business reporting and analytical capabilities.
- Established data validation and auditing processes for transactional datasets, reducing reconciliation discrepancies by 25% and maintaining consistent reporting standards.
- Developed SQL and Excel-based analytical reports using advanced functions and pivot tables, producing 8+ recurring reports monthly for 3 business teams to drive informed decision-making.
- Supported KPI development and dashboard reporting by preparing analytical datasets and monitoring 10+ performance indicators to guide operational decision-making.