Industry: Insurance

---

Business Problem

• The client was spending an inordinate amount of time, effort and money on tracking project information across three different operational systems: financials, human resources, and a management information system. The two primary metrics in which they needed a deeper understanding were 1) financial costs associated with projects and 2) the allocation of project resources. Once this information was well understood, a trend analysis was performed against the best and worst project profiles for the purpose of learning from past successes and mistakes and incorporating this knowledge into practice using continuous process improvement methodologies.

Business Solutions

• The client commissioned RJC to undertake the entirety of the data warehouse project, from start to finish. Upon completion RJC trained client employees on the maintenance and operation of the system. RJC utilized Microsoft’s Solution Development Discipline along with the methodology outlined in this proposal to integrate the three operational systems into an Oracle data warehouse. Cognos Impromptu was used as a front end connectivity, ad-hoc query and reporting tool. Pine Cone Systems software was employed for warehouse monitoring and optimizing. The initial architecture was released to production and transitioned to client personnel in June of ’97.

Technology

• Oracle Data Warehouse
• Cognos Impromptu
• Pine Cone Systems