Our client is one of the world’s pre-eminent manufacturers of airplane engines and other aerospace related engineering
Boeing sought to integrate an SAP environment with a number of other systems into an Enterprise Data Warehouse. They had hired a large Systems Integrator to design and develop the EDW. The tools chosen were an Oracle database and Informatica PowerCenter and Informatica Data Quality. We were brought in to audit the EDW design, architecture and implementation and to provide any recommendations.
Tools
ExistBI’s Data Warehouse consulting divisions best practice methodology was utilized to analyze the EDW and provide a comprehensive review of the design, architecture and development efforts and techniques.
ExistBI analyzed the client requirements, EDW architecture, the data model, the Oracle and Informatica PowerCenter environments, the development and testing techniques, the deployment methodologies and the overall process. Most of the design was determined to be fit for purpose, however, there were a number of significant recommendations made which allowed for faster development and more efficient use of hardware, software, and human resources. Exist was able to offer a number of automation techniques as well as analysis and to alert the SI with regards to a potential process flaw.
Team Structure
A certified Senior Consultant was on site to analyze the requirements and implementation as well as to interview the key stakeholders in the project.
Conclusion
ExistBI was able to provide a quick and comprehensive audit of an EDW implementation providing the end client with necessary assurance and giving valuable advice to the implementing SI, keeping them on track, reducing overall development time, and keeping costs at the minimum.
