BUSINESS OBJECTIVES
The customer was challenged with highly inefficient data collection and manual process across multiple systems to build daily, weekly finance and operational reports resulting in data inconsistency, inaccuracy, incompleteness and operational efficiency. Customer wanted to integrate their ERP, CRM, Supply Chain, Finance, manufacturing and planning application in real-time to begin with.
SOLUTION
Infometry was hired to conduct BI/Data Discovery, Data Architecture review and put together Enterprise Data Strategy and BI Roadmap. Infometry team started with 6 weeks engagement conducting executive management interviews to understand business goals, meeting enterprise application architects to understand business and data flows and performed data discovery using Infometry tools and processes. Infometry proposed the customer with Enterprise Data Integration and Orchestration strategy, ETL/DM vendor analysis and presented a short term and long term Data Warehouse, MDM and Analytics road-map to Customer Data and Analytics needs.
SUCCESS CRITERIA & BUSINESS VALUE
- Got a clarity on the data flow and data topology
- Gauge the magnitude of data consistency and data quality issues
- Identify critical data Integration points and delivery mechanism
- Create a business case to develop Enterprise Data Warehouse and Data Orchestration platform
- Scalable architecture for Cloud Data Integration, ETL, MDM and Enterprise Data Warehouse
- Create a business case for 3rd party data enrichment such as D&B, Address cleansing and Geocodes