Client
Our client is a small business that provides outsourcing services for corporate insurance billing.
Challenge
We previously built self-billing insurance automation software for this client to automate manual invoice calculation and delivery. Subsequently, they decided to monetize the product by offering it as a SaaS in the U.S. market. Thus, they needed custom insurance software development to upgrade the product and prepare it for wide use.
Project Description
The previous version of the self-billing solution offered the following workflow:
- Configuration of all insurance plans conditions as the basis for invoice calculation
- Importing files from HRIS (Human Resources Information Systems) with employees’ monthly insurance expenses
- Generating and sending invoices to all stakeholders
To increase bandwidth of the product and team, we made the following upgrades to the product architecture and features:
The previous version of the product could only process limited data formats from specific HRIS systems – making it complicated to scale. We developed an ETL (extract, transform, load) pipeline that pre-processes data from any HRIS system and converts it into the desired format for seamless invoice calculations. This made the product accessible to any company, no matter which HRIS they use. ETL also eliminated the need for manual configuration of plan conditions, leaving employees responsible only for uploading files.
Automatic invoice verification
Insurance invoice totals can vary due to several factors: the insured person's age, health condition, family status, the specific terms of their insurance plan, etc. To ensure invoices accounted for all these variables, the previous version of the product performed automatic checks and provided sum correction recommendations. However, final decisions were still made by employers after manual review. In the upgraded version, the automated check became the single source of truth – not requiring manual verification.
We implemented two user-friendly dashboards that visualize operational and financial data in real time. The first dashboard displays data processing status. It is used by the operational team to ensure HRIS files are uploaded and processed successfully. The second dashboard presents financial metrics, which can be tracked by both the operational team and clients (insurance companies) to support analytics and decision-making. These metrics include Loss Ratio, Combined Ratio, Policy Retention Rate, and more.
Historical data availability
Our client can now access all historical data, not just the latest calculations. This enables retrospective analysis and helps provide clarifications when needed.
Key Features
Automated, customizable corporate invoicing and invoice delivery
ETL pipeline to unify data from various HRIS systems
Automatic checks of Insurance invoice totals
Dashboards visualizing operational and financial metrics
Team Composition & Project Duration
This insurance software development project took us 12 months, with a team of:
1 Project Manager
1 Tech Lead
1 Front-end developer
1 Back-end developer
2 Data Engineers
1 DevOps
1 QA Engineer
1 UX Designer
1 Business Analyst
Major Tech Stack
.NET 8, Airflow, Grafana, Angular, MSSQL, Azure Hosting, GIT, Azure pipelines, Azure Storage, Azure AppInsights, log4net
Results
After the upgraded product release, our client expanded their customer base fivefold, gaining companies from across the U.S. They reported growing market interest in the product and a high satisfaction rate among current customers. End-users cited smooth performance, user-friendliness, and the elimination of manual insurance invoicing for both insurers and their corporate clients as key factors behind the product’s success.
