Close up on financial data in newspaper

Replacing an unsupported insurance system without stopping the business: BindHQ for Scottish American

Scottish American’s legacy policy system was no longer well supported and couldn’t be updated, in an industry where communications between agents, MGAs and carriers are closely regulated. Box UK designed and built BindHQ to replace it, and migrated more than 17 million files, including 1.5 million policies, without disrupting operations.

In short

Scottish American invests in and manages insurance distribution businesses across 11 US offices, and prides itself on fast turnaround times. Its legacy policy system was no longer well supported, and it couldn’t make the technical updates it needed.

  • Box UK’s analysts captured US commercial insurance regulations before any design began
  • BindHQ, a custom web application, brought every policy and communication into one place
  • NetSuite was integrated for accounting and reporting
  • More than 17 million files, including 1.5 million policies, were cleansed and migrated without disrupting operations
  • The old system was switched off, with large savings on server bills

Client

Scottish American

Sector

Financial Services

Customer background

Scottish American invests in, actively manages and grows privately held insurance distribution businesses in the US, including managing general agents (MGAs) and brokers, from 11 offices.

It prides itself on offering some of the fastest turnaround times in the market, and has invested heavily in technology and people to achieve that. In US commercial insurance, that speed has to come with strict compliance: communications between agents, MGAs and carriers are closely monitored.

The challenge

Scottish American’s existing system for managing policy submissions was no longer well supported. That stopped the company making vital technical updates, and limited how far it could grow and change.

Its replacement had to support every compliance standard in US commercial insurance while processing policy requests as efficiently as possible. It also had to be scalable and extensible, because Scottish American planned further development to serve its customers better and to introduce new processes into the commercial insurance market.

And years of accounting and policy data had to move across accurately, without affecting day-to-day operations.

Our approach

Box UK’s analysts began by working closely with Scottish American to understand the commercial insurance industry and capture the regulations and restrictions insurance providers must follow. That consultancy phase produced the list of requirements that guided the design and build.

Extensibility was a priority from the start. The application was built to industry best practices and coding standards, so new features, tools and data sources could be integrated as Scottish American needed them.

What we built

Box UK designed and built BindHQ, a custom web application that holds all policy details in one central system. Scottish American could use it to access and manage enquiries from agents, responses from carriers, and every update and communication in between.

To handle Scottish American’s complex accounting requirements, Box UK’s developers integrated the NetSuite enterprise resource planning (ERP) system into BindHQ, giving the company stronger accounting and reporting capabilities.

That made the accounting data held in the old system part of the job, too.

Delivery

To keep the financial information accurate, all accounting data had to move from the legacy system to BindHQ: more than 17 million files, including 1.5 million existing policies.

A detailed research phase assessed the quality of the data and whether it was in the right format to move between systems. It identified several essential tasks:

  • cleansing data so fields could be validated
  • converting date and time information to a consistent format
  • resolving encryption issues caused by the age of the existing system

Box UK worked closely with Scottish American, drawing on both teams’ knowledge, to decide how each data problem should be handled. Once every issue had been addressed, an implementation plan made sure the migration didn’t affect Scottish American’s operations.

The outcome

BindHQ gave Scottish American a high-performance system for managing its core business processes, and a stable, secure platform to build on. Removing the outdated legacy system delivered large savings on server bills, and left the company able to react quickly to changing conditions and demands.

Box UK went on to extend BindHQ, working on custom APIs to integrate with leading carriers for instant quotations, and a broker portal so agents could upload their details directly. Those features were designed to replace lengthy email-based communication with much shorter, integrated feedback loops, so Scottish American could process applications faster and write more policies.

Frequently asked questions

How do you replace a legacy system in a regulated industry?

Document the regulations first, then design to them. For Scottish American, Box UK’s analysts captured US commercial insurance requirements before any design began.

How do you migrate millions of records safely?

Research the data before moving it. Scottish American’s 17 million files needed cleansing, consistent date formats and fixes for encryption issues before migration.

Can a new system integrate with an existing ERP?

Yes. BindHQ was integrated with NetSuite for Scottish American’s accounting and reporting.

Yes. BindHQ was integrated with NetSuite for Scottish American’s accounting and reporting.

It depends on how much your processes differ from the market. Scottish American wanted to introduce new ways of working, so a custom application built for extension made sense.

What’s the biggest risk when replacing a legacy system?

Usually the data. Scottish American’s migration began with a research phase to assess the data, and ended with an implementation plan so day-to-day operations weren’t affected.

What this means for your organisation

If your business runs on a system that’s no longer supported, every month you keep it adds risk: you can’t update it, it’s expensive to host, and it limits what you can do next. In a regulated industry, the replacement also has to satisfy the rules from day one, and the data has to move across intact.

If you’re facing a legacy replacement like this, send us a few lines about the system and the data it holds. We’ll tell you what the migration would involve.

Client

Scottish American

Sector

Financial Services

Talk to one of our digital experts

Pete Withers-Jones

Head of Development

Do you have an idea or a project you need support with?

Pete Withers-Jones leads Box UK’s Development Practice, and has over 20 years of experience in software development, working across various industries and technologies.

Or call us on 020 7439 1900

Have a project you’d like to discuss?

Give us a call on 020 7439 1900 or fill in the form and we will get back to you.