Pharma

Global Pharmaceutical Leader Automates Data Maintenance Using SAP BTP Platform While Keeping the S/4HANA Core Clean

08 of May 2025

Streamlining Asset Data Management Through Intelligent Automation and Cloud-Native Architecture

A global pharmaceutical leader headquartered in Switzerland sought to automate data maintenance for company assets—including diagnostic devices and software solutions—to reduce manual effort and synchronize data across multiple systems. Fusion Consulting partnered with the organization to conceptualize, design, and implement a tailored automation solution, enabling full data synchronization across sources.

Global Pharmaceutical Leader Automates Data Maintenance Using SAP BTP Platform While Keeping the S/4HANA Core Clean

 

The Challenge

The company managed assets sold to customers (e.g., diagnostic devices and software licenses) as equipment and functional locations within the SAP S/4HANA system.

Key challenges included:

  • Data Inconsistency Across Systems
    Asset data was maintained inconsistently, often based on the device lifecycle, leading to conflicting records and no single source of truth.

  • Limited Integration
    Systems and platforms lacked strong integration, with information such as serial numbers and maintenance history scattered and often outdated.

  • Lack of Standardization
    Inconsistent naming conventions, classifications, and structures made global data analysis and scaling difficult.
    Each system had complex customizations and coding to support fragmented representations.

  • Compliance & Audit Risks
    Asset data needed to comply with regulatory requirements (e.g., GxP, FDA, ISO).
    Manual tracking increased the risk of non-compliance and audit issues.

Our Approach

Fusion Consulting worked closely with the client to define, design, and deploy a future-ready automation solution based on SAP BTP.

Automation Concept & Framework Design

  • Built an automation framework using BTP capabilities such as Event Mesh, Business Process Automation, Decision Tables, CAPM Services, and Process Visualization.

  • Replaced custom code with best practices and BTP-native features.

  • Enabled lifecycle-based automated maintenance of asset data, reducing manual intervention.

  • Designed for scalability to connect with other processes, systems, and platforms.

Seamless Connectivity

  • Integrated multiple data sources with real-time processing.

  • Leveraged existing middleware and mappings for optimized integration.

  • Developed interface concepts to ensure a fully interconnected system landscape.

  • Incorporated key aspects such as security, monitoring, and error handling.

Centralized Data Processing

  • Established a centralized data governance model aligned with the automation framework.

  • Implemented data ownership models and rulebooks to maintain high data quality.

  • Introduced backup MDG workflows to support manual intervention in case of system failure, ensuring consistency across the network.

The Results

Fully Automated Data Maintenance

  • Automated creation and updates of asset data with no human intervention, minimizing errors.

  • End-to-end lifecycle management of assets, including diagnostic instruments and software licenses.

Clean SAP S/4HANA Core

  • Avoided technical debt by eliminating 10+ custom tables and complex coding, ensuring a cloud-ready environment.

Improved Data Governance & Quality

  • Harmonized hierarchical structures across sources.

  • Defined ownership and centralized data management.

  • Stable data model supporting long-term reliability.

Interconnected Systems

  • Real-time synchronization across 7+ systems and data sources.

  • Visual dashboards and robust error-handling mechanisms.

Stronger Compliance & Audit Readiness

  • Full traceability of asset data ensured regulatory transparency and audit preparedness.

Scalability Across Business Units

  • The reusable automation framework enabled rapid onboarding of new regions, countries, and business teams.

 

Expert Insight

“Automation is the future—and this case demonstrates how Fusion Consulting helps organizations unlock new levels of efficiency, accuracy, and innovation through intelligent automation.”
— Neelam Daulat, Partner & Global Account Lead

 

Conclusion

Fusion Consulting played a pivotal role in developing and implementing a robust automation strategy—from solution architecture and automated workflows to scalable integration. The result: a future-proof, efficient, and compliant data environment that enables global consistency and operational excellence.