A major insurance organization wanted to better measure their performance and obtain the information needed to guide strategic decisions. Specifically, they sought to understand how their latest product offerings were impacting their core insurance products. In addition, they wanted analytic capabilities which would help isolate key characteristics and trends in their customer base to increase revenue opportunities. To quickly capitalize on these new insights, they required a robust, extensible, and scalable reporting framework that made key data and analyses more accessible to management.
Solution:
CapTech conducted a thorough assessment of the client’s current (and future) data and reporting requirements and developed a strategy to design, build, and deploy an enterprise-wide data mart. CapTech quickly implemented the technology stack to build the staging area, data mart, and maintenance plan. This included the RDBMS, data integration, and business intelligence software. Next, CapTech designed and built the data integration mappings and programs to move data from source systems into the data mart. CapTech subsequently replaced the existing paper-based reports with a robust and flexible web-based reporting framework that provided a depth and breadth of data not previously available. To ensure a seamless hand-off of operations CapTech conducted knowledge transfer activities that included hands-on training, coaching/mentoring sessions, and formal documentation reviews. These activities enhanced the client’s understanding of the solution, as well as the technologies and techniques required for the ongoing support and growth of the solution.
Tools:
CapTech Way Methodology
Microsoft® SQL Server 2005
Microsoft® SQL Server Reporting Services
Microsoft® SQL Server Integration Services
Microsoft® Office
Results:
Client enterprises remain strong and well capitalized in accordance with regulatory standards and have no debt service requirements.
Life insurance underwriting remains sound and highly rated. The company has negligible exposure to investments of high risk.
Improved accessibility to more comprehensive data and metrics for management decision-making.
Self sufficiency to maintain and further enhance capabilities well into the future.