ERP Consolidation
and Enterprise
Data Platform
SUMMARY
A mid-size consumer products and distribution company had grown with over 35 acquisitions over several years. Each acquired company had a system that was consolidated or retained, ending up with about 9 different platforms. An enterprise platform for transformation and reporting was architected to capture and standardize all data sources to produce consolidated reporting and to centralize all of their data sourcing and provisioning to improve the data quality and governance.
Problem Statement
- Ineffective ERP consolidation effort was causing financial and reporting issues
- Siloed data environments & manual data processing required laborious manual reporting efforts
-
Incomplete and not well-understood data resulted in inconsistencies and increased risk of leveraging reports to inconsistently provide
Quarterly Reporting
Exusia Solution
- Centralized data architecture and standardize technology by architectural component
- Built a re-usable Data Framework to standardize data sourcing and provisioning as well as to support automation to improve time to market
- Ensured Frameworks address reporting requirements including built-in data catalog and data lineage
Business Outcome
-
Consistent and accurate Quarterly Reporting - met requirements by allowing analysis to easily view/trace all data fields and logic back to the
source -
Foundational centralized data platform to support additional Lines of Business for their operational and analytical data needs and future
acquisitions - Improved data quality and time to market of onboarding/provisioning data requirements
