The company’s life insurance division was comprised of a dependency between business and IT staff. Executives, business analysts, finance personnel and customer service groups lacked efficient access to vital corporate data due to Pacific Life’s complex data infrastructure.
We needed a robust, standardized, easy-to-use solution that would enable our various business factions to be more self-sufficient and free our IT groups to focus on infrastructure improvement projects, says Cameron Cosgrove, vice president of information technology at Pacific Life.
The company chose a data warehousing solution based on Microsoft SQL Server 2005 Enterprise Edition, part of the Microsoft Windows Server System family. The organization deployed SQL Server 2005’s BI features, such as SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), which helped connect its disparate data sources, ranging from legacy mainframe data to multiple clusters of database servers in locations across the country.
Our business groups are now able to gather client and policy data and generate meaningful reports on their own. And we were able to significantly reduce costs, allowing us to invest in additional innovations to enhance the experience for our clients, said Cosgrove.
