Carl Zeiss GmbH
Designed Customer 360 analytics platform integrating SAP CRM/ERP with Azure Synapse, achieving 40% faster reporting and 50% reduction in manual data reconciliation.
Carl Zeiss had customer data spread across SAP CRM, SAP ERP, and multiple regional systems. Generating a unified customer view required manual reconciliation that took the analytics team days. SSIS-based ETL was slow, fragile, and impossible to maintain.
Designed a Customer360 architecture in Azure Synapse with automated migration from SSIS to cloud-native pipelines. Implemented a Landing Zone using Azure Synapse Pipelines with a customizable framework for ingesting complex unstructured files from SAP CRM and ERP systems.
Mapped all SAP CRM and ERP data entities, relationships, and transformation rules for the Customer360 model.
Migrated legacy SSIS packages to Azure Synapse Pipelines with automated testing and validation.
Built customizable ingestion framework for complex SAP extracts with automated schema detection.
Designed star schema for unified customer view with SCD Type 2 for historical tracking.
Power BI dashboards for customer behavior, product trends, and regional performance analysis.
Mapped all SAP CRM and ERP data entities, relationships, and transformation rules for the Customer360 model.
Migrated legacy SSIS packages to Azure Synapse Pipelines with automated testing and validation.
Built customizable ingestion framework for complex SAP extracts with automated schema detection.
Designed star schema for unified customer view with SCD Type 2 for historical tracking.
Power BI dashboards for customer behavior, product trends, and regional performance analysis.
Cloud cost optimization and eliminated manual reconciliation
From multi-day to same-day customer analytics
Automated reconciliation replaced spreadsheet processes
Unified view across all SAP modules and regional systems
“The Customer360 platform has given us unprecedented insight into our customer relationships across all regions. The Azure migration was seamless.”
Foli Josee
Product Owner, Carl Zeiss
Let's discuss how we can deliver the same results for your business. Free consultation, no commitment.