Assessment & Optimization of a Data Warehouse; Design & Development of a Customer-Facing BI Application
A leading healthcare solutions provider was experiencing severe performance problems with its legacy DW/ BI environment as it embarked on a program to implement a new enterprise-wide data warehouse and multiple customer-facing business intelligence applications.
The client’s legacy DW/ BI environment was experiencing severe performance problems as it embarked on a program to implement a new enterprise-wide data warehouse and multiple customer-facing business intelligence applications. To successfully implement new DW and BI products, the entire environment required a detailed tuning and optimization program to ensure the performance meets industry service level agreements and customer expectations.
Oracle Database 10g, Informatica, Cognos, Java, Perl and UNIX Scripts
Trianz assessed and redesigned the backend data factory that was planned to process daily records from hospitals across the US. This information factory would then feed all of the client’s data marts and customer-facing BI products
Executed a performance and optimization assessment of the environment, reviewed the DW/ BI architectures and application components including Oracle, Informatica, UNIX, Perl, San, server configurations, and processing procedures
In addition, Trianz documented the most critical issues which needed improvement, designed and implemented changes based on the assessment. This involved a systematic approach to tuning their system, including:
Tuning the poorest performing components first to provide maximum benefit
In-depth Oracle query tuning including Informatica routines and Oracle configuration changes
Implementation and optimization of a new SAN and backup procedures for the new Oracle DW
Implemented an approach for continual automated and incremental performance tuning
Assisted with the planning, design, development and implementation of a new customer-facing BI application using Cognos and Java
The application has become client’s primary brand recognition product and reaches thousands of users.