Our SI partner Ingenious Qube worked with a customer who wanted to price auto insurance based on driving behavior insights obtained from sensors on cars using Hortonworks Data Platform. Rajnish Goswami, CEO of Ingenious Qube, describes the customer story below.
Insurance companies around the world strive to provide lower insurance rates, and auto insurance is no exception to this phenomenon. The automobile insurance companies are devising ways to derive innovative pricing models that will help customers reduce their insurance premiums; however, it requires an understanding of how one drives their vehicle. Insurance companies determine the premiums not just by the driver’s or vehicle’s history but also by statistical probabilities including age and gender.
Usage-based insurance (UBI) also known as pay as you drive (PAYD) and pay how you drive (PHYD) and mile-based auto insurance are types of vehicle insurance whereby the costs are dependent upon type of vehicle used, measured against time, distance, behavior and place. This differs from traditional insurance, which attempts to differentiate and reward “safe” drivers by giving lower premiums and/or a no-claims bonus. PAYD car insurance enables the insurance companies to charge the client based on how they actually drive their vehicle. This radically changes the insurance model where distance driven and insurance premiums are not aligned.
This requires integration of several technologies to enable an end-to-end system including an in-vehicle device, communication network and an application platform hosting a number of capabilities including a Geographical Information System (GIS) and Customer Relationship Management (CRM) system. The European and North American motor insurance industries have been operating at a loss due to price pressure and the customer acquisitions costs related to the need to hold a statistically viable data set that actuaries can analyze to define risk against. PHYD based insurance is able to offer an alternative to this method by charging an insurance premium based on the actual risk of the driver and reduce the size and volume of claims by between 17% and 50%.
PHYD requires an insurance company to source the driving data and is usually achieved by offering a traditional policy at a discount and by installing a telematics device. The driver’s data can be analyzed against existing risk measurement tools and insurance segmentation. Products can then be structured around charging for high-risk behaviors or reducing the premium for low risk. The complexities of the charging regime are only limited by the ability to communicate the proposition to the end user.
Ingenious Qube did an analysis on the data provided by its client, procured from the sensors installed on the vehicles. The sensors send the data every 5 seconds to the backend system, and then the client provided us the data files for further processing and data analysis. The analysis was based on user behavior on these aspects:
The data has provided our client the ability to improve its services and to provide the best premium rates to its customers based on the above data.
This helps in defining actual risk rather than projected risk to a group of users based on their driving behavior. The transition from projected to actual risk is based on the insurer’s ability to identify new risk factors from the data and apply these within a product.
Driver activity data can be mapped and used to identify generic high-risk behaviors. This method of detecting risk by applying algorithms to automatically analyze the data is sometimes referred to as the driver fingerprinting or DNA.
Ingenious Qube helped the client in identifying which technology to be used for the proof of concept (POC). The implementation of the POC included the Hortonworks Data Platform (HDP) and specifically leveraging Apache HBase for NoSQL, Apache Pig scripting language, Apache Hive for SQL queries and Apache SQOOP for data transfer into Hadoop. Apache Solr was used for the Hadoop search capabilities.
The selection of Hortonworks Data Platform (HDP) over other distributions was primarily due to its open source nature and its various deployment options including cloud or an on-premise solution across both LINUX and Windows operating systems. HDP is also a complete Hadoop solution and incorporates all the components to create an enterprise platform including data access, data management, security, operations and governance.
Data received from the vehicle sensors was imported into HDP using SQOOP, an open source tool for importing structured data like the CSV files received from the client. Queries were then written using Hive and Pig to extract the required data based on predefined specific criteria of user driving behavior.
Apache Solr, an adjunct open source search tool to HDP, was used to search through the large chunks of data (Terabytes/Petabytes). The combined solution was able to process the large data volumes in a much faster manner as compared to traditional databases and provided many valuable insights.
Ingenious Qube brings the best combination of IT landscape knowledge and the industry best practices for Quality Methodology for service delivery, AGILE methodology to reduce the cycle time in order to deliver the product on-time, culture for KAIZEN (“Continuous Improvement”) and data protection practices.