Badrish Shriniwas

Conducted comprehensive gap analysis of the existing ZAP BI solution (SQL-based), delivering strategic recommendations for future-state architecture.

Orchestrated the end-to-end data warehouse strategy and migration from ZAP BI to Microsoft Fabric, ensuring seamless transition and enhanced performance.

Developed and implemented a robust data extraction framework from Legacy Microsoft AX6, establishing a BI Conceptual Framework and Governance Model on Microsoft Fabric with Delta load capabilities.

Built a cutting-edge analytics foundation leveraging Microsoft Fabric components including Lakehouse, Warehouse, PySpark, SQL, Semantic Model, and Power BI for advanced reporting.

Managed successful production deployment, hyper care, and ongoing support for the new Microsoft Fabric platform, ensuring operational stability and user adoption.

Analyzed current ZAP BI solution capabilities, identifying critical gaps and delivering actionable recommendations for a comprehensive data strategy.

Spearheaded the data warehouse strategy and migration from ZAP BI to Microsoft Fabric, improving data processing efficiency and analytical depth.

Engineered a data extraction framework from Legacy Microsoft AX6, establishing a robust BI Conceptual Framework and Governance Model on Microsoft Fabric with Delta load.

Developed a scalable analytics foundation utilizing Microsoft Fabric (Lakehouse, Warehouse, PySpark, SQL, Semantic Model, Power BI) to drive integrated reporting.

Achieved key accomplishments including the successful integration of Margin Analysis, Sales & Distribution Reporting, Inventory Reporting, and Financial Reporting, enhancing business insights.

Evaluated existing SAP BW BI Solution capabilities, performing gap analysis and providing strategic recommendations for modernization.

Formulated and executed the data warehouse strategy, overseeing the migration from SAP BW to an Azure-based platform.

Provided strategic procurement guidance, evaluating Azure, AWS, and GCP platforms to select the optimal solution for scalability and cost-efficiency.

Designed and implemented a robust data extraction framework from Legacy SAP ECC 6.0, establishing a BI Conceptual Framework and Governance Model on Azure with Delta load capabilities.

Developed technical solutions for FP&A Planning processes, integrating them seamlessly with the Azure platform to enhance financial forecasting.

Built a comprehensive analytics foundation using Azure Synapse Analytics (Data Lake, Dedicated Synapse Pools) and Power BI Reporting, enabling advanced data insights.

Collaborated extensively with key stakeholders, including CXO, Business, IT Architect, and PMO, ensuring alignment and successful project delivery.

Successfully integrated data from SAP, delivering enhanced Sales & Distribution Reporting, Inventory Reporting, and Financial Reporting capabilities.

Finalized the Data Warehouse Strategy, clarifying the role of SAP BW (BW/4HANA) within the future solution landscape.

Conducted a thorough analysis of the current SAP BW and Azure landscape, identifying opportunities for optimization and integration.

Engaged extensively with key stakeholders, including Business, IT Architect, PMO, Azure, SAP, and Gartner, to align on strategic data initiatives.

Developed a clear distinction between operational and analytical reporting frameworks, optimizing data delivery for diverse business needs.

Created a detailed Data Warehouse Transition Roadmap, outlining phased implementation and migration strategies.

Defined the Reference Architecture, providing comprehensive recommendations and a robust Solution Architecture for data analytics.

Successfully implemented Power BI reporting for the Office of Finance, enabling detailed segment reporting and improved financial visibility.

Established a robust integration framework to extract critical data from the Data Warehouse to the Azure platform, enhancing data accessibility.

Designed and delivered a technical solution for the FP&A Planning process, leveraging Power BI and Azure to streamline financial planning.

Configured advanced row-level security and ragged hierarchy with Account intelligence, ensuring data confidentiality and integrity.

Collaborated with the Group Finance Controller and FP&A team, developing project proposals, ROI analyses, and board submissions to secure project approval and funding.

Established a scalable Microsoft-based planning and reporting architecture, significantly improving FP&A capabilities.

Implemented a comprehensive Corporate Performance Management (CPM) solution covering Financial Planning, Sales, and Workforce Planning.

Developed an analytics framework leveraging Azure platform components including ADF, Data Lake, and Power BI, enhancing data accessibility and insights.

Created and deployed pilot Power BI dashboards for executives, providing critical real-time financial insights and decision support.

Recommended and justified the optimal CPM solution based on comprehensive analysis of business needs and market offerings.

Established clear business requirements for Planning and Consolidation, ensuring the selected tool met strategic organizational goals.

Conducted a comparative solution study for tool selection, evaluating multiple options against defined criteria.

Delivered a successful Proof of Concept (PoC) for the selected CPM option, validating its technical feasibility and business value.

Performed a health check on the current solution, identifying areas for improvement and informing the new tool selection.

Developed the final solution architecture, outlining the blueprint for the successful implementation of the chosen CPM tool.

Recommended a robust Microsoft architecture for enterprise-wide reporting, optimizing data accessibility and performance.

Established a strategic BI solution roadmap by conducting thorough gap analysis and defining the target architecture.

Evolved Microsoft BI's integration approach to SAP, transitioning from ODATA to ODBC for enhanced data transfer efficiency.

Provided a framework for SAP CDS view-based embedded reporting, improving real-time data insights for business users.

Recommended and designed a solution for the Corporate Performance Management (CPM) tool, streamlining financial processes.

Established a Business Intelligence Centre of Excellence (BICC), fostering best practices and knowledge sharing.

Developed and deployed Power BI dashboards for executives, providing critical insights and supporting data-driven decision-making.

Facilitated comprehensive product evaluation, ensuring the selection of user-friendly, business and finance-owned solutions.

Developed a robust Proof of Concept (PoC) for CCH Tagetik, demonstrating its benefits and comparing functionalities against competing products.

Configured and detailed the benefits of the CCH Tagetik tool and solution, securing stakeholder buy-in.

Implemented and replicated existing system configurations and integrations into CCH Tagetik, encompassing SQL Server DWH integration, SAP ByDesign transaction loading via Salesforce, Statutory & Management Consolidation, IFRS reporting, and Dashboards.

Showcased a significant reduction in "off-system" time by leveraging CCH Tagetik, improving efficiency and data accuracy.

Conducted extensive training and demonstrations for key stakeholders, ensuring user adoption and proficiency.

Analyzed high-level BI requirements, performing gap analysis and delivering strategic recommendations for SAP S4 transformation.

Established a robust BI Conceptual Framework and Governance Model on Azure, integrating with SAP HANA DWH for enhanced data management.

Provided comprehensive solution architecture for Business Intelligence and Performance Management using SAP tool sets.

Designed technical solutions for EPM, including a cost allocation module (CAM), optimizing financial planning and control.

Developed a strategic BI roadmap incorporating Big Data (Hadoop) for archival, ensuring scalable and cost-effective data storage.

Provided technical leadership for the BPC-embedded planning and consolidation solution, ensuring robust financial processes.

Designed and developed Statutory and Management Consolidation, alongside planning solutions including allocation, R&O module, and Group Impact Model.

Integrated SAP BPC with SAP BW and Simple Finance, streamlining financial data flows and reporting.

Developed a portfolio valuation model using Monte Carlo Simulation with native HANA capabilities, delivering a critical proof of concept.

Designed and implemented an SAP BPC 10-based operational planning solution, seamlessly integrated with BW.

Served as the solution architect, overseeing the entire design and development lifecycle of the planning solution.

Created detailed technical designs for the operational plan, ensuring adherence to architectural standards and business requirements.

Executed BADI enhancements and designed comprehensive reports/forms, optimizing user experience and data accessibility.

Integrated SAP BPC 10 Consolidation with CRM and DWH, streamlining data flow for comprehensive financial reporting.

Designed and developed a Data Warehouse using SQL Server 2012, SSAS, SSRS, and SSIS, enhancing data storage and retrieval.

Implemented Concur and SAP ByDesign integration, facilitating seamless financial data consolidation.

Designed Salesforce integration with the Data Warehouse, improving sales data visibility and analysis.

Configured BO-BPC for statutory consolidation, including inter-company elimination, proportional, equity, and purchase methods, ensuring compliance.

Guided the BASIS team through the installation of BPC 10 and EPM 10 add-in, ensuring correct system setup.

Configured the consolidation environment for statutory and segmental consolidation, including the Matrix Ownership structure.

Developed BI process chains for master and transaction data load from ECC and BW, optimizing data integration.

Configured inter-company elimination, proportional, equity, and purchase methods of consolidation, ensuring accurate financial reporting.

Drove incremental development, process optimization, and periodic maintenance of the data warehouse and OLAP models for risk tracking and consolidation.

Managed code release and supported daily data load cycles for a nearly 1 TB database, ensuring data integrity and availability.

Implemented continuous performance improvements by tuning loading, reporting, and multi-dimensional data models, boosting system efficiency.

Managed global site implementations and security protocols, ensuring consistent and secure data access across regions.

Contributed significantly to the migration to SQL Server 2008, enhancing database performance and scalability.

Led the migration of dimensions, reports, input schedules, SSIS packages, logic, and security setup for BPC 7 forecasting and consolidation.

Developed SSIS packages to load data from the Financial Decision Support System, optimizing data integration processes.

Established data load processes for consolidating data from over 120 business entities across 40+ countries, managing fact table partitions.

Developed SSRS reports with dimension-level security, publishing data to end-users for enhanced financial insights.

Achieved Six Sigma Green Belt certification, applying methodologies to improve performance across BI projects.

Developed OLAP models for Sub Ledgers (ACP, ACR & APP), supporting working capital estimation, vendor maintenance, and inter-company reconciliation.

Managed weekly and monthly data load cycles, creating and scheduling loads via SSIS and Tivoli job scheduler, ensuring timely data availability.

Directed a team to on-time and on-budget completion for multiple BI projects, demonstrating strong project management and leadership.

Set up dimensions, Excel reports, SSIS packages, and RSS Scripts for forecasting product-level sales margin analysis, improving accuracy.

Designed, developed, and managed SSIS packages for data load from the Data Warehouse, streamlining data integration.

Created and maintained calculated members and fact table partitions, ensuring periodic updates and data integrity.

Managed the team to achieve on-time and on-budget completion for projects, demonstrating effective project management.

Created and managed flash reports in dashboards for sales, cost, margin, and planning, enhancing executive visibility.