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.

Business Challenge

  • 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.

Technology Components

  • Oracle Database 10g, Informatica, Cognos, Java, Perl and UNIX Scripts

Approach

  • 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

Transformational Effects

  • The application has become client’s primary brand recognition product and reaches thousands of users.

Contact Us Today

By submitting your information, you agree to our revised  Privacy Policy.

TESTIMONIALS

Get in Touch

Let us Help You in
Your Transformation
Journey


Would you like to speak with an expert?

x

Status message

We're eager to assist you! Please leave a message and we'll get back to you shortly.

By submitting your information, you agree to our revised  Privacy Policy.