SreeMadhuri

Analyst with 2+ years of experience synthesizing client and stakeholder requirements into clear analytical approaches, using SQL, Python, and Advanced Excel to gather, model, and validate data for real-time business decision-making. Skilled in building and refining analytical models and KPI frameworks (Power BI/DAX), managing data migration and consolidation across ETL pipelines, and anticipating data or process roadblocks before they affect delivery. Strong business and domain knowledge from enterprise and US healthcare analytics engagements at Capgemini, with a track record of clear communication across global, cross-functional Agile teams.

Data Analyst / Software Engineer at Capgemini (2023-12 – 2026-04)

• Gathered and synthesized requirements from business stakeholders to design interactive Power BI dashboards tracking employee certification status, proficiency levels, and performance metrics, increasing visibility into skill gaps by 25% and reducing certification backlog by 15%.
• Built and iterated on analytical/statistical KPI models using advanced DAX measures and calculated columns, improving reporting accuracy by 20% and enabling faster, data-driven decisions.
• Executed data gathering, transformation, merging, and cleansing workflows using Power Query and SQL, ensuring data integrity and consolidation across multiple source systems.
• Anticipated and resolved data-model and performance bottlenecks in advance, optimizing relationships and query design to cut dashboard load time by 30 seconds and improve query efficiency by 25%; automated recurring reports.
• Understood client requirements from a US-based biopharmaceutical stakeholder group and translated them into Oracle SQL queries (joins, subqueries, CTEs, window functions) to validate and reconcile operational healthcare datasets, reducing query execution time by 40%.
• Performed cross-system data validation and consolidation between source databases and BI reporting layers, proactively identifying discrepancies and deadlocks before they reached production, improving data accuracy by 98% and reducing reporting errors by 10%.
• Developed Power BI dashboards and analytical models to monitor operational KPIs and data quality indicators, enabling proactive, real-time decision-making and contributing to a 10% improvement in operational efficiency.
• Ensured strict HIPAA compliance while handling sensitive patient and operational healthcare data, maintaining 100% compliance and mitigating 5 potential compliance risks.
• Designed and executed functional and regression test cases, collaborating with global cross-functional teams in Agile/Scrum sprints and achieving a 95% defect detection rate.

B.Tech in Engineering – Gokaraju Rangaraju Institute of Engineering & Technology (2019 – 2023)