Insurance core system upgrade & complex data migration

The insurance company offering auto, home, commercial, and life insurance coverage
Duration
1 year
Team
5 members
Platforms
Web
Type
Insurance Company
Industry
Insurance Technology

Target audience

Target audience

Small and medium businesses, freelancers, and independent contractors.

Project idea

Project idea

Restructure the old, complex system with limitations into a flexible and robust solution to increase capacity and improve efficiency. Migrate historical data and make it available for ongoing business needs such as in-force policy conversion, open claims conversion to improve operations, and build centralized reporting architecture for identifying new growth opportunities more effectively.

Project requirements

Migrate the previous system to a modern .NET platform, implementing the new architecture

Split the monolithic application apart to enable the implementation of microservices architecture, data transfer

Migrate different applications that were part of the system to new technologies and rewrite them with a modern stack of technologies

Implement automation features including reporting, customizable workflows, policy management, and claims management

Test the migrated code for performance and functionality

Solution

Solution

Our team modernized the existing sophisticated platform leveraging the latest technologies that provided high performance and security of our solution. Advanced microservices system architecture designed and implemented by our specialists delivered the required results on platform flexibility that is easily maintained and can be scaled as and when they grow. The centralized reporting created greater operational efficiencies and allowed bringing insurance product offerings to the market faster. The new full-featured microservices application platform enabled accessing massive channels flexibly so as to provide richer and more personalized experiences to their customers.      

We ensured a smooth transition to the new platform adding value to the client with an enhanced framework and partially automated workflows.

Business benefits

Flexible architecture

Advanced system that is a lot easier to operate and maintain

Productivity

Increased capacity and operations productivity along with optimized workflows

Cost-effectiveness

Reduced costs of delivering insurance products

Management

Enhanced data management and reporting

What we did

Phase 1

Our team assessed the source code of the client’s platform based on tools. We used the code slicing methodology to replace the monolithic architecture with independent microservices working in tandem, adhering to global standards of .NET architecture migration. We preserved the system’s logic while rebuilding and transferring it to a modern tech stack. After analyzing the inventory, redundancy, dead code, and source code in its entirety, we developed an effective strategy to perform a smooth transition.

Phase 2

Once the architecture was complete, our software engineers developed a powerful application with several microservices-based solutions including claims management, policy management, and a scalable parametric insurance platform.

Phase 3

The platform migration also included replacing business-critical Windows applications, humongous systems themselves, and adjusting the new apps to the company’s needs. It was essential to synchronize and coordinate their work with a unique internal system. Apart from this, we integrated a suite of tools from Google to facilitate the collaboration and business information sharing within the company. Salesforce CRM integration with the new platform allowed establishing effective customer data management and maximizing business profits while staying compliant with industry regulations.

Phase 4

We analyzed the database mappings to understand the coupling between database objects that will span across the microservices boundaries. Our team successfully separated the database objects related to different functionalities, paying close attention to data synchronization, transactional integrity, joins, and latency. We developed a reusable data migration assistant tool with features like source metadata generation, control files creation for source data analysis, and Microsoft SQL Server Integration Services. Microsoft SSIS package provided a comprehensive automated ETL solution for data migration.

Phase 5

Our team seamlessly migrated data from the source to the targeted platform. We built a robust data model by logically grouping the data for on-going business needs with centralized reporting architecture using Microsoft SQL Server Reporting Services. We also created a direct access UI for the end-users.

Phase 6

We used the Insight tool framework to identify the extent of automation that could be achieved with the new system architecture and ensure the automated processes accurately reflect the work methodology and policies of the organization. As a result, navigation and controller logic along with business logic were automated.

Technology Stack

Development

C#

System Migration

.NET Core

Database

MS SQL Server Integration Services

MongoDB

Data Reporting Tool

MS SQL Server Reporting Service

Testing

Postman

Selenium

CI/CD

Bitbucket Pipelines

Integrations

Google Services

Slack

Stripe

Salesforce CRM

Development

C#

System Migration

.NET Core

Database

ms_sql_56x56

MS SQL Server Integration Services (SSIS)

MongoDB

Data Reporting Tool

MS SQL Server Reporting Service (SSRS)

Testing

Postman

selenium_56x56

Selenium

CI/CD

Bitbucket Pipelines

Integrations

Google Services

Salesforce CRM

Slack

Stripe

SHARE: