Global P&C Carrier increases speed to market by 60%

Everything you do in Excel just got easier.

Convert spreadsheets into ready-to-integrate code in minutes, not months.

Automate complex Excel models and react to market changes instantly.

Update and launch products faster, without slowing down IT.

Company background

This client is a top five global property and casualty carrier, providing complex coverage policies for commercial entities across various asset classes. To meet the ever-changing socioeconomic environment and an increasing number of natural disasters, they refined business processes to increase the velocity of re-rating their books of business.

Benefits

Reduced Cost
The carrier eliminated an estimated $14M in development costs and reduced IT overhead by retiring multiple legacy systems.

Centralized, consistent logic
‍With raters living in a controlled, cloud-based environment, all actuaries could access the same logic, eliminating manual spreadsheet errors.

Faster product updates
‍Product updates could be made and shared across all relevant systems in an hour compared to the previous timeline of 3 months – over 2,000% increase in speed.

Challenge

Managing thousands of raters across dozens of countries to evaluate risk for different assets is challenging. Each rater, being a unique, complex model, is built in Excel and stored in a document management center; this complicates tracking version control across raters, quotes, and final client estimates, and technology integrations across the product value chain are particularly onerous.

Deploying new raters across a complex technology ecosystem means software developers must code the corresponding changes across multiple systems for every new rater.

Implementing a single product averages 9 months, and errors are frequent as different developers hard-code each rate change for each system in the applicable language.

Solution

With Coherent Spark, the carrier deployed 20 products in 90 days.

Spark reproduces the rating logic for each product into 24 code languages with 100% accuracy. This ensures consistency across every disparate technology system that utilizes the outputs and logic of each rater—and updates products in days instead of months.

Coherent also enables the carrier to centralize its logic, ensuring all actuaries, analysts, and systems use the same models for the same risk. Actuaries spend less time maintaining raters and more time customizing components for customer needs.

Customizations are easily connected to the core product, and the client-specific portions are managed, controlled, and shared within the Spark platform.

Automate product development and deployment to maximize IT resources - contact Coherent today.

Frequently Asked Questions

What platforms does Coherent Spark work with?

Modern APIs and security features integrate with cloud-based CRMs, no-code / low-code platforms and custom-built apps. Connectors and SDKs enable Coherent Spark to work with legacy and native apps and mainframe systems.

Does Coherent Spark offer deployment flexibility?

Coherent Spark is supported by world-class architecture and offers multiple deployment options: on-premise, on cloud, or on mobile (online and offline).

How many business rules can Coherent Spark handle?

From straightforward lookup tables to stochastic modelling, Coherent Spark supports all forms and types of product, business and procedural rules. There are no limits to what it can do for you. If you have your rules on a spreadsheet, Spark can convert it into an API.