Sai Subham Patnaik

Data Analyst

Wipro

Nov 2024 - Present

Developed and maintained interactive Power BI dashboards to monitor business KPIs, operational performance, and executive level reporting. • Extracted, transformed, and analyzed data from multiple sources using advanced SQL queries, joins, CTEs, and aggregations. • Analyzed datasets containing over 1 million records to identify trends, business opportunities, and performance gaps. • Collaborated with business stakeholders to gather reporting requirements and convert them into analytical solutions. • Designed KPI scorecards and performance dashboards to support strategic business decisions. • Automated recurring reporting processes, reducing manual effort by 30% and improving reporting accuracy. • Performed data validation, cleansing, and transformation to ensure high-quality reporting. • Conducted trend analysis, variance analysis, and root cause analysis to identify operational improvement opportunities. • Developed optimized data models and DAX calculations for enhanced dashboard performance. • Delivered actionable insights that improved business visibility and decision-making.