Revamping the Billing Solution and Upgrading Data Management for Pie Insurance

Solution

Prior to kicking off the development, we extensively interacted with the client’s business stakeholders to define the requirements for their billing system. Based on the results of the research, our software engineers designed the software architecture for the solution.

Building the Billing System

The Billing System we’ve built from scratch allows creating, updating, and customizing billing plans, including payroll reporting plans. It makes it possible to record, track, and report on all the premium billing, payment plans, and payments received. In addition, the billing system allows Pie Insurance to correctly track and report on each policy’s equity. It performs automatic policy cancellation in accordance with equity calculations. Also, as each of the U.S. states has different regulatory cancellation-related rules, the system tracks non-payment cancellations.

In order to accurately pay commissions, the client’s billing system tracks all the premium payments, made by customers. It differentiates between the premium paid and taxes, surcharges, and fees.

Overall, the system we’ve delivered can:

• Process all billing installments for all policies;
• Process and post all payments;
• Calculate equity;
• Trigger non-payment cancellation;
• Work with multiple payment plan options (globally);
• Provide Policy Ledger information;
• Generate reports by customer groups;
• Provide transactional data at the agent level;
• Communicate with PMS to handle cancellation.

Building Operational Data Management Application

As the data Pie Insurance’s applications use is retrieved from multiple disparate sources like spreadsheets or CSV files and needs to be constantly updated, we needed to leverage our data engineering expertise for:

• Data Integration: We implemented ETL processes to consolidate data from different sources. Such an integration ensured that data of all necessary formats was seamlessly integrated into the system.
• Data Cleansing: To remove data inconsistencies and preserve its integrity, we cleaned and standardized it.
• Automated Data Updates: To handle the frequent updates, we created workflows that automatically refresh data. Now insurance agents don’t need to perform this task manually. 
• Operational Data Maintenance: We built an ODM platform that allows the client’s staff to manage all data operations seamlessly and quickly. 

Creating an Integration with Insurance Policy Management Application

Taking into account the system’s intricate business logic, we’ve performed the integration of the services we’ve developed with the client’s Insurance Policy Management application. The application takes into account a multitude of factors and allows for the regional differences in the insurance policy management rules in the different U.S. states. The application allows creating new and modifying existing insurance policies.

Creating an Online User Account (Personal Cabinet)

In addition to the Billing System and the ODM platform, SPD Technology’s project team has developed a self-service application for end customers with an online user account for the Pie Insurance platform. This part of the project also included integrating the developed personal cabinet functionality with the billing system and a payment provider.