Project Info
Project Description
The Business
Granite Underwriting is a trading name of Acorn Insurance and Financial Services Limited.
Focusing on non-standard, Motor Trade and allied liability risks, Granite Underwriting operates in the specialist end of the insurance market.
The Challenge
Various Policy Management Systems required integrating to provide a consolidated Management Information dashboard and business intelligence data warehouse.
The Solution
Automated download, decryption and restore of policy management systems databases into SQL Server, Creation of bespoke reporting services to distribute reports, custom membership systems and a bespoke C# developed web application and windows services was written to provide an array of underwriting specific MI as well as transactional analysis and forecasting metrics.