ARCHIVES

Significant challenges sit within manufacturing’s ability to manage increasing Customer Data volumes while being able to maintain System Performance and Cost Effectiveness. This paper will provide a comprehensive Case Study of Migrating the Customer Account Management Operational Data Store from a legacy silo data source working environment to an Microsoft SaaS platform working environment using power automate. Doing this helped overcome significant limitations with the existing infrastructure (high operations expenses, performance bottlenecks, and unreliability of SOAP-based web services). The implementation of ETL Pipelines utilizing Ab Initio, Change Data Capture mechanisms, and a well-planned transition to Microservices Architecture generated the following results: 300% improvement in processing capacity; 70% faster transaction times; 95% decrease in security incidents. The creation of a new customer account platform as part of a new customer engagement with a major manufacturer resulted in a 50% increase in customer base and 23% in revenue annually. This paper will provide insight into the methodology; challenges; architectural decisions; and outcomes from this extensive data migration. Organizations that will embark on similar modernization initiatives will find value in this paper.