Pip And Retail & Distribution Company Created Data Quality And Reporting Capabilities To Unlock 15% YOY Growth
Background
- Client is a PE-owned $4B+ company, with eight divisions of $400M+ revenue undergoing a business-led consolidation and transformation, on three different ERP systems (SAP, Sage, QuickBooks).
- Client-owned data resided within 12+ third-party customer and shipping tools, and data across divisions were inconsistent and had master data challenges.
- Client requested a solution to unify the data across businesses to integrate with their logistics provider and manufacturing hub on IFS
Approach
- Built a unified and consistent data model across eight companies to operate with logistics provider as one business leveraging Snowflake data warehouse
- Defined integration approach with middleware platform to communicate consistent, bi-directional data to logistics provider and manufacturing hub
- Gained direct access to source data in ERP and third-party systems and guided the business on both technical and operational improvements
- Performed data cleansing, mapping, and profiling on millions of records
Results
- Solution has created the operational capability to support 15% annual revenue growth while maintaining data quality
- Comprehensive reporting capability created based on new data model, and prepared for future ERP consolidation
- Created a data governance and business-led ownership model, facilitated by IT
