Data Warehouse Implementation

Challenge

Our client is in the insurance industry and was being pressured by their global customer base for access to real-time data from their Artiva Agency system. While the company’s system refreshed daily, their customers needed more up-to-date information. The company’s highly customized version of Artiva Agency and web portal access application was unable to update quickly enough, restricting reporting options. The system was cumbersome, allowing for only a nightly data extract to a set of SQL tables, reducing the actionability of the data. While customized, ad-hoc reports were considered, naming conventions and insufficient data access represented significant shortcomings.

Solution

The Emprise solution was to develop a data management structure which included a central repository of integrated current and historical data that maintains and enhances existing storage and information updates while enabling access, via web portal from multiple platforms, to more current data.

We designed and developed a custom interface within the client’s existing Artiva Agency environment. This entailed aggregating and extracting all of their structural data, then leveraging SSIS (SQL Server Integration Services) packages to import the extracted data into a SQL data warehouse. Once in the data warehouse, the data is restructured and processed into tailored formats to provide more up-to-date information availability.

The data warehouse architecture and functionality enable hourly updates and, subsequently, access to virtually real-time data via the company’s web portal as well as additional ad-hoc reporting tools such as Crystal Reports.

Our client now has stronger command of their data, its availability and dissemination. They are pleased with the data flexibility and more importantly, are now able to access accurate, up-to-date information whenever they need it for more effective decision making to drive revenue.