Madhurima G

• Results-driven Data Analyst / Business Intelligence Analyst with 10 years of experience delivering data analytics, KPI reporting, dashboard development, process optimization, and business intelligence solutions across Banking, Consulting, Supply Chain, Manufacturing, Procurement, and Technology domains. • Strong expertise in SQL, T-SQL, complex queries, joins, aggregations, CTEs, window functions, and data extraction techniques to analyze enterprise datasets, validate information, and support business-critical reporting solutions. • Hands-on experience designing and developing interactive Power BI dashboards, DAX measures, Power Query transformations, data models, KPI scorecards, and executive reports to enable data-driven decision-making. • Skilled in performing Exploratory Data Analysis (EDA), descriptive analytics, diagnostic analytics, trend analysis, variance analysis, and root-cause analysis using SQL, Python, Power BI, Tableau, and Advanced Excel. • Strong experience utilizing Python libraries, including Pandas, NumPy, Matplotlib, and Seaborn, for data cleansing, transformation, visualization, pattern identification, and analytical insights generation. • Experienced in end-to-end Business Intelligence (BI) reporting lifecycle, including requirement gathering, data preparation, dashboard design, visualization development, testing, deployment, and stakeholder adoption. • Proven ability to build scalable KPI dashboards, operational reports, supplier analytics dashboards, workforce analytics models, and performance scorecards supporting leadership and business teams. • Extensive experience working with SQL Server, PostgreSQL, relational databases, OLTP/OLAP concepts, dimensional modeling, and data warehousing fundamentals to support enterprise reporting environments. • Skilled in ETL validation, data extraction, data transformation, data mapping, data profiling, data cleansing, reconciliation, and data quality management to maintain accurate and reliable analytical solutions. • Experience leveraging AWS cloud data ecosystem, including Amazon S3, Redshift, Athena, and RDS concepts to support cloud-based analytics, reporting, and data-driven business initiatives. • Strong background in procurement analytics, supplier performance analysis, spend analytics, sourcing optimization, and vendor benchmarking using structured data analysis and business intelligence techniques. • Experienced in operations analytics and workforce modeling, analyzing SLA metrics, productivity trends, utilization rates, process performance, and efficiency opportunities across global business environments. • Demonstrated expertise in pricing analytics, competitor benchmarking, market intelligence, and profitability analysis, delivering insights to optimize pricing strategies and improve business outcomes. • Successfully delivered measurable improvements, including 5–9% cost optimization, 13 FTE equivalent efficiency improvement, 10% process cycle reduction, and 60% classroom time reduction through analytics-driven initiatives. • Strong experience applying Lean Six Sigma DMAIC methodology, gap analysis, SWOT analysis, risk-impact assessment, KPI benchmarking, and continuous improvement frameworks for operational excellence. • Advanced proficiency in Microsoft Excel, Pivot Tables, Power Query, XLOOKUP, INDEX-MATCH, advanced formulas, reporting automation, and executive dashboard creation. • Skilled in creating compelling data visualization solutions using Power BI, Tableau Desktop, Tableau Server, interactive reports, drill-down analytics, and data storytelling techniques. • Experienced in business requirement gathering, stakeholder collaboration, user story documentation, UAT support, process mapping, and cross-functional communication within Agile environments. • Strong understanding of data governance principles, reporting standards, data documentation, metric definitions, and data lineage concepts to ensure consistency across analytics solutions. • Proven ability to translate complex datasets into meaningful business insights, executive recommendations, operational strategies, and measurable performance improvements. • Excellent analytical, problem-solving, and communication skills with the ability to bridge technical teams and business stakeholders while delivering high-impact Data Analytics and BI solutions.