Carl Zeiss GmbH
0
Annual Savings
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.
The numbers that mattered.
0
Annual Savings
Cloud cost optimization and eliminated manual reconciliation
0
Faster Reporting
From multi-day to same-day customer analytics
0
Less Manual Work
Automated reconciliation replaced spreadsheet processes
0
Customer View
Unified view across all SAP modules and regional 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.
“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
Free consultation and project estimate within 24 hours.