Many insurers have complex, highly customised, spreadsheet-based applications that rely on extensive manual intervention from highly skilled actuaries and underwriters. Northdoor can transform these existing applications into robust, highly automated enterprise systems that enable data to be used quickly, confidently and consistently across the business.
One of our insurance clients had developed its own Solvency II‑related application using a combination of Excel and Access. This worked in a limited way, but required manual intervention and was not scalable. Initial quarterly runs took days to complete, and the whole process was error-prone.
Northdoor industrialised the process by introducing a series of Microsoft SQL Server Integration Services (SSIS) packages executed from a set of SQL Server Reporting Services (SSRS) reports. The original application included more than 20 Excel workbooks and 50 manual steps; the transformed application has just 2 workbooks and 3 manual steps.
The entire reporting process can now be completed in less than an hour, and re-runs of individual steps can be completed in minutes, versus up to a day previously. Northdoor also greatly improved the performance of the Excel workbooks by rewriting inefficient sections of macro code.
Since our formation nearly 30 years ago in the City of London to provide data solutions to the insurance industry, Northdoor has built up a reputation for delivering business‑enhancing IT projects for the London Market. Our services cover the entire data journey; through our Store IT, Protect IT and Use IT offerings we help clients ensure their data is effectively and efficiently stored, secure and able to be used effectively.
To learn more about how we helped this London Market insurer transform its application, download the full case study.