Pratap Simha

• Developed and maintained PowerBI intuitive dashboards and Python-based reporting scripts to automate business reporting and enhance data-driven decision-making. • Designed and build automated ETL data pipelines using MS SQL Server and Python, streamlining data integration processes across multiple datasets ensuring data quality and auditability. • Built SQL-based data models to support ad-hoc analysis requests and improve the accuracy and accessibility of key business metrics. • Collaborated with cross-functional stakeholders to elicit reporting requirements, plan data pipeline enhancements, and deliver actionable insights aligned with business goals. • Built and deployed data pipelines using Azure Data Factory and integrated workflows across Blob Storage and SQL-based sources, supporting automated data refresh and reporting.

• Provided strategic insights on sales and order trends, improving decision-making efficiency and aligning technical solutions with business goals. • Collaborated with stakeholders across Sales, Finance, and Marketing, utilizing Power Query to optimize processes and convert user journeys into actionable requirements. • Developed and presented dynamic reporting templates and metrics, enabling executives to monitor performance and guide strategic decisions effectively. • Designed and built intuitive & interactive PowerBI dashboards, enhancing team alignment, communication, and data-driven decision-making while also coaching the users for effective usage. • Managed forecasting and risk assessments for sales and orders, improving accuracy and aligning outcomes with business roadmaps. • Supported Power BI deployment on Azure workspace, improving version control and collaborative dashboard development.

• Partnered with cross-functional teams to resolve technical data challenges, improving data infrastructure capabilities and supporting seamless analytics workflows. • Designed advanced data tools and solutions, enhancing analytics capabilities and driving product innovation, contributing to a 15% increase in operational efficiency. • Developed and optimized robust ETL pipelines using SSIS, streamlining data integration processes and reducing processing times while ensuring data quality and auditability.

• Developed and deployed end-to-end BI solutions using Power BI and SQL, increasing data accessibility by 35% and enabling faster, data-driven decision-making across teams. • Conducted impact analyses of source system changes and regulatory updates, ensuring 100% data warehouse integrity and reducing reporting errors. • Collaborated with stakeholders to define and prioritize BI initiatives, streamlining project delivery timelines and enhancing business alignment. • Partnered with cross-functional teams to resolve technical data challenges, improving data infrastructure capabilities and enabling seamless analytics workflows. • Designed advanced data tools and solutions, enhancing analytics capabilities and driving product innovation, resulting in a 15% increase in operational efficiency. Developed and optimized robust ETL pipelines using SSIS, streamlining data integration processes and reducing processing times by 25%.

• Designed KPIs and scorecards in Power BI to track profitability and enhance reporting efficiency, enabling faster, data-driven decision-making. • Extracted, modeled, and analyzed datasets, creating customized reports aligned with business goals and project delivery roadmaps. • Built interactive dashboards in Power BI, allowing stakeholders to interpret trends, identify opportunities, and make informed decisions. • Collaborated with development and QA teams to optimize workflows, aligning project planning with delivery cycles for on-time and efficient outcomes. • Identified operational gaps, enhancing performance and mitigating risks through data-driven insights and process improvements. • Acted as a bridge between technical teams and business units, ensuring clear, actionable requirements and seamless project execution. • Translated business needs into IT solutions, preparing comprehensive use cases to capture functional and non-functional requirements, ensuring alignment between business objectives and technical deliverables.