Service: Implementation Consulting
Industry: Government; Transportation
BUSINESS CASE
This Federal Transportation Agency suffered from legacy systems that created redundancies and inaccuracies of data relating to employee benefits. Ineffective data management left the agency unable to create an integrated view of corresponding data. The need to switch to a modern application environment had become inevitable and hence, the Database Optimization Project was initiated. The main goals of this effort included:
- Re-architecting the agency’s data structures to eliminate redundancies across multiple systems
- Creating consolidated master data
- Integrating previously disparate databases in order to dramatically enhance reporting capabilities
SOLUTION
Data Blueprint provided third party oversight (implementation consulting) as well as data model review on this project. Our team conducted initial assessments and created the Statement of Work (SOW), which defined the requirements, identified possible project risks along with mitigation plans and specified vendor selection criteria. During the next phase of the project, Data Blueprint was part of the source selection committee to choose suitable vendors.
TECHNICAL ENVIRONMENT
- ERWin
- IBM DB2
RESULTS
Data Blueprint’s team of experienced IT professionals successfully directed the implementation of a modern application system at this Federal Transportation Agency. They served as consultants throughout the entire project (October 2007 to July 2009) and ensured that redundancies and discrepancies of the old systems were finally eliminated.