A CRM System for Insurance: Automated Processes, Accurate Accounting, and Cut Costs

A system that automates the core business processes of the insurance industry: agent certification/onboarding, commission billing, enrollment, claims payment, sales/marketing campaigns, etc.

  • Technologies used:PHP, MySQL, JavaScript, jQuery, Symfony, Bootstrap, Gitab, Codeception, Selenium, Docker, Memcached, Elasticsearch
  • Industry:Healthcare, Insurance
  • Methodology:Agile
AR/VR: Equipment Maintenance and Service Mobile App with Augmented Reality
prev. project
IoT: A Sensor-Based Solution to Monitor the Air Health Status of a Smart Home
next project

 

HIGHLIGHTS

  1. A white-label solution that automates key business processes of the insurance industry
  2. Facilitated agent certification/onboarding, commission billing, marketing/sales campaigns, etc.
  3. Creating and maintaining a database of leads and allocating them between the agents
  4. Keeping track of all the information related to the healthcare providers
  5. Eliminated extra expenses on three different business-specific systems from different vendors

CUSTOMER

The customer is a health insurance company, operating in the United States.

NEED

Partnering with HQSoftware, the company wanted to develop a customer relationship management system (CRM) that would serve the needs of the insurance industry. The main goal behind the solution was to automate sales of health insurance plans, as well as commission billing of the insurance agents.

Turning to HQSoftware, the customer faced the problem that there was no single CRM-like system available on the market to cover all the business processes of interest. So, the company had to utilize three solutions—each addressing a certain pool of tasks—from different vendors. To eliminate costs spent on customizing such systems and monthly payment to the vendors, the customer arrived at the decision to deliver a CRM of its own.

CHALLENGES

In the course of the development, the team at HQSoftware had to face the following challenges:

  • As long as the solution was to facilitate all the business processes, it needed to have a scrupulously designed business logic that would ensure smooth interoperation of the core modules.
  • To enable accurate accounting, the module responsible for commission billing needed to distinguish between multiple factors—e.g., was it the first sale or a change of an insurance plan—and comply with the business rules provided by the customer.

SOLUTION

The delivered system comprises a number of modules that automate the core processes of health insurance.

Onboarding

Starting with onboarding the agents, the solution allows for educating and certifying the specialists. Thus, developers at HQSoftware made it possible for the agents to watch tutorials online and take a test. In case of satisfying results, an agent was offered to upload his/her license, so that the system could check his background. Engineers at HQSoftware integrated the developed solution with the NIPR service that verifies the validity of the agent’s license.

Our experts also delivered functionality that enables top managers to get real-time reports on how many agents were hired, who passed the test, whose license is valid, etc.

onboarding

Commissions

To ensure the accuracy of accounting, the team at HQSoftware developed an algorithm that calculated the commission to be payed to in-house agents and external brokers. While the in-house agent’s commission was KPI-based, the one of an external broker depended on multiple parameters.

Commissions 1

For instance, the algorithm had to take into account such criteria as the state the sale took place, which insurance plan a client was using before the sale, etc. Furthermore, the hierarchy of the insurance system implies that some brokers may get a percent of a deal made by another broker. This percentage differs greatly in accordance with the broker’s place in the hierarchy, so the delivered solution allowed for configuring the rate.

Commissions 2

Sales

The developed sales module stores the information about all the agents and leads. For instance, an agent profile provides access to the licenses, the states an agent can operate in, onboarding information for the current year, as well as for all the previous ones, etc. The module allows for automatically changing the status of a lead once it gets into the system and goes through all the stages of processing / verifying. Furthermore, it is possible to track the history of a status change at any point in time. The system also features an advanced search by numerous options, including the one by tags. 

sales

Marketing

Developers at HQSoftware then delivered a marketing module that automates the process of allocating the leads between the agents. The module also allows for running marketing campaigns: on creating a campaign, a telephone channel is assigned to it. The lead call is automatically transferred to such a channel and the agent responsible. To track the efficiency of the campaigns, engineers at HQSoftware made it possible to analyze data gathered and generate reports.

Third-party service integration

Our developers provided an integration with another third-party service, which allows for checking the credibility of an insurance holder as some plans were available for particular groups of people only.

Providers

Experts at HQSoftware designed a module that maintains the cooperation with healthcare institutions and doctors, as well as with the agency responsible for claims’ payments.

Reports

To furnish decision makers with a tool that enables efficient supervision, our team also designed a module that generates highly interactive reports with clickable values, advanced full-text search, etc.

reports

OUTCOME

Collaborating with HQSoftware, the customer developed a system that automates the core business processes of the insurance industry: agent certification/onboarding, commission billing, enrollment, claims payment, sales/marketing campaigns, etc.

With the delivered platform, the customer was able to replace three different business-specific solutions—each addressing a certain pool of tasks—from different vendors. Thus, the customer eliminated extra expenses on customizing those solutions and monthly vendor fee.

As long as the system covers all the key business processes, the customer is planning to whitelabel the developed SaaS solution to get an additional revenue channel.

 

AR/VR: Equipment Maintenance and Service Mobile App with Augmented Reality
prev. project
IoT: A Sensor-Based Solution to Monitor the Air Health Status of a Smart Home
next project