Insurance core system upgrade & complex data migration
The insurance company offering auto, home, commercial, and life insurance coverage
- Duration12 months
- Team5 members
- PlatformsWeb
- TypeInsurance Company
- IndustryInsurance Technology
Target audience
Small and medium businesses, freelancers, and independent contractors.
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
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
01
Flexible architecture
Advanced system that is a lot easier to operate and maintain.
02
Productivity
Increased capacity and operations productivity along with optimized workflows.
03
Cost-effectiveness
Reduced costs of delivering insurance products.
04
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 (SSIS)
MongoDB
Data Reporting Tool
MS SQL Server Reporting Service (SSRS)
Testing
Postman
Selenium
CI/CD
Bitbucket Pipelines
Integrations
Google Services
Slack
Stripe
Salesforce CRM