Problem: Ongoing maintenance of the core database was a constant need that was demanding ever increasing resources to meet the required quality and timeliness goals. As the source data originates from many different agencies and systems there was a wide variety of formats and data quality issues that needed to be managed. In addition, the format and content of this data is very dynamic and would change constantly without warning. The business objective was to implement a process and system that would make maintenance of this database more efficient, standardized, and cost-effective while maintaining the required timeliness and data quality.
Solution: The Digital Group engineers reviewed the existing load process to capture the rules and relationships in formal documentation. They then created a powerful data mapping tool to validate and cleanse the source data before it is loaded into the production environment through optimized loading procedures. After creating this optimized system, The Digital Group took responsibility for ongoing operational support and now performs this activity at their offshore facility on behalf of the client. Read more..
Related Case Studies:
- Case Study of Complete Production Services Context: Complete Production Services (CPX) is an oil and gas...
- Case Study about Production Planning System Abstract: This paper describes the evolution of a production planning...
- Case Study for Macmillan Cancer Support Macmillan Cancer Support is the largest cancer care and support...
- Case Study on Health Support As a major supplier to public and private hospitals in...
- Case Study about Toyota Production System Abstract: This article seeks to reconceptualize the relationship between flexibility...