Prashant Brahmbhatt

Project type: SAP S/4HANA on RISE Greenfield Implementation.

Client: McKesson Pharmaceuticals and Healthcare Canada.

Role: SAP S/4 Reporting and Data Migration Lead.

• Led complex data migration from legacy systems and ECC to S/4HANA, leveraging SAP Data Migration Cockpit, BODS, Syniti ADMM, LSMW, and LTMOM.
• As the lead, I defined the data strategy and roadmap for a successful S/4 HANA implementation in coordination with business and IT SMEs.
• Led cross-functional teams to streamline project delivery and enhance client satisfaction.
• Hands-on experience with data migration objects, master and transactional data objects, business partners, products, conditions, GL accounts, banks, stock data, batch data, open deliveries, handling units in stock, and storage bins.
• Designed custom ETL workflows to handle high-volume master and transactional data, including G/L balances, contracts, and pricing, while enforcing robust audit and reconciliation controls.
• Conducted comprehensive data analysis to support decision-making and inform strategic recommendations.
• Responsible for initial data profiling, data extraction, data and mapping sheet preparation, and building the mapping.
• All data-related workstreams within the SAP program include data preparation, validation, mapping, cleansing, enrichment, cutover activities, and transformations.
• Develop, configure, and optimize ETL/ELT processes and workflows (extract, transform, load) for EWM modules (e.g. Migrate, Transform, Match, & Merge, Construct.
• Handles the pre-validation process and keeps business data ready for migration by minimizing errors.
• Created entity-relationship models after joining tables/nodes, maintaining associations.
• Architected end-to-end data migration strategies, including legacy system analysis, data profiling, transformation logic design, and validation matrices. Implemented risk-managed cutover processes to ensure zero data loss and minimal production downtime across modules such as MM, FI, SD, and EWM.
• Acted as the primary SME for data migration governance, coordinating across business SMEs, technical leads, and offshore teams. Translated business rules into executable logic, resolved data quality exceptions, and oversaw job scheduling, performance tuning, and issue remediation.
• LTMOM used to add an additional data field in the source structure for the Migration Cockpit template.
• Acted as the primary SME for data migration governance, coordinating across business SMEs, technical leads, and offshore teams. Translated business rules into executable logic, resolved data quality exceptions, and oversaw job scheduling, performance tuning, and issue remediation.

• Project type: SAP Reporting System upgrade and support.
• Domain: Brisbane City Council Government, Australia.
• Role: SAP Analytics Lead and Data Migration.

• Led enterprise-scale BI transformation by upgrading SAP BI, BW 7.5, BPC 10.1, and Lumira 2.4, integrating them into a robust SAP Analytics Cloud (SAC) ecosystem, with end-to-end project ownership from planning to deployment.
• Implemented a data governance framework that improved compliance with regulatory standards, and enhanced trust in enterprise reporting.
• Closely work with the customer and project team for data readiness checkpoints for key project phases—testing, training, and go-live—ensuring smooth adoption and business continuity.
• Proven ability to learn quickly and adapt to new situations.
• Architected complex SAC solutions featuring multi-model data architecture, advanced story design, KPI dashboards, and seamless integration across planning, reporting, and decision support systems—enabling cross-departmental analytics for government use cases.
• Designed and deployed semantic layers with customized dimension properties and calculated measures to optimize data wrangling, reporting flexibility, and model reuse across analytics streams.
• Implemented enterprise-grade security at the model, story, and dimension levels, aligning data access controls with government regulations and internal compliance frameworks.
• Acted as a strategic liaison between business units and technical teams, translating diverse planning methodologies into system logic, and delivering workshops to ensure the adoption of SAP best practices in analytics and reporting environments.
• Handling communications with clients, and debriefing the technical team about the requirements.

• Developed reports and multi-tab dynamic data visualization dashboard stories.
• I worked on the Information Design Tool and Universe Design Tool to connect SAP and non-SAP databases.
• Led the development of enterprise-grade dashboards and multi-tab SAC visualizations, integrating real-time data from SAP HANA and the Business Data Warehouse to support operational decision-making across transport networks.
• Defined and implemented the MDG strategy and governance framework, aligning with business, IT, and compliance requirements.
• Engineered data connectivity using the Information Design Tool and Universe Design Tool to unify SAP and non-SAP sources into a single, query-optimized semantic layer for cross-platform analytics.
• Optimized BO report performance and delivery, leveraging custom Excel add-ins (e.g., variance, threshold, and comparative reports), and account-based logic to enhance analytical flexibility across departments.

• Led the end-to-end delivery of SAP BO reporting solutions for a medical division, building reports over MS SQL using the Information Design Tool, and ensuring solution alignment through in-depth requirement analysis and technical blueprinting.
• Owned the full documentation lifecycle, including the creation of business blueprints, configuration specs, integration test documents, unit test scripts, and user manuals—ensuring audit readiness and solution transparency.
• Directed rigorous testing cycles and issue resolution, managing integration/unit testing and defect tracking, while coordinating across SAP and business teams to close gaps and deliver user training for seamless adoption.
• Collaborated with cross-functional teams to ensure alignment on reporting requirements.
• Provided training and mentorship to junior consultants on reporting best practices.

• Project type: Implementation – SAP BO Design Studio Dashboard on Native HANA.
• Domain: Dura-Fiber Manufacturing.
• Role: SAP Reporting Consultant.
• Delivered executive-level SAP Design Studio dashboards, integrating native HANA views with BW for high-performance analytics across finance, commercial, and operations—empowering global leadership with real-time decision-support tools.
• Led the project lifecycle across international stakeholders, managing requirements, documentation, UAT, rollout, and post-go-live adoption, with a focus on user enablement and long-term solution sustainability.
• Engineered web reporting and SAP mobility solutions for multi-device accessibility, ensuring scalable, high-availability dashboards aligned to global manufacturing KPIs and leadership reporting standards.
• Mentored junior analysts on best practices in data visualization and report generation techniques.
• Developed custom reports tailored to client needs, boosting overall project value.

• Delivered an end-to-end BI reporting system using SAP BO 4.0 over a BW backend, supporting critical pharmaceutical workflows, and aligning with GSK’s enterprise architecture standards.
• Managed legacy data ingestion from non-SAP sources through BODs pipelines, and executed seamless system testing via HP ALM, ensuring clean integration and high data fidelity.
• Collaborated across global teams to support the full reporting lifecycle, from business process mapping to UAT, within a regulated, data-sensitive environment.
• Evaluated client needs and expectations, establishing clear goals for each consulting engagement.

• Developed dynamic, sales-driven WebI reports and dashboards, leveraging SAP BEx queries, Crystal Reports, and BO functionalities, including DrillDowns, @Functions, and Cross Tabs for hierarchical reporting.
• Led the successful integration of SAP BW with BO 4.0, designing KPIs and reporting logic for finance, billing, and sales operations across multiple retail tiers.
• Authored end-user and IT documentation, bridging technical implementation with functional adoption for cross-functional teams in a global rollout.
• Increased client satisfaction by developing comprehensive consulting strategies tailored to each business's unique challenges and objectives.