Gupteswar Satapathy

Data Analyst

Infosys

Jan 2021 - Jul 2024

Successfully migrated enterprise SAP BusinessObjects environment (4.2 to 4.3) and modernized legacy reporting into Power BI with zero downtime and complete data integrity. Engineered scalable Tabular Data Models (Star Schema) in SSAS and Power BI Desktop connecting directly to enterprise SQL Data Warehouses via DirectQuery and Import modes, improving query execution speed by 35%. Authored complex DAX measures and applied analytical thinking to build executive KPI scorecards, reducing manual reporting overhead by 15+ hours per week. Implemented dynamic Row-Level Security models and managed Power BI Service administration for 200+ users, ensuring 100% data governance compliance. Built automated ETL pipelines using Power Query and SQL/PolyBase to transform warehouse data, eliminating repetitive manual data preparation and saving approximately 20 hours monthly. Developed Python scripts and advanced SQL queries to perform cell-by-cell regression testing, data cleaning, and UAT testing, replacing manual checks and reducing validation cycles from 3 days to under 2 hours. Supported report embedding via APIs into web portals while leading requirement analysis, project documentation, and stakeholder management, consistently delivering exceptional client service and accelerating project sign-offs by 25%. Utilized DAX Studio and Visual Studio to analyze query execution plans and optimize complex DAX measures, providing effective problem resolution that reduced report load times from 45 seconds to under 5 seconds. Led strategic planning and change management initiatives for enterprise BI platform migrations, achieving zero downtime and facilitating a seamless transition for 5+ cross-functional business units.