The leading online financial services provider is a well‐known and first of its kind online marketplace in India that provides services related to fast loans, credits and insurance. They sought Big Data solutions as they were finding it difficult to integrate the data from various sources and leverage it efficiently for improving employee productivity and marketing revenue. Umbrella’s approach enabled the company to integrate and de‐duplicate data with a well‐designed data lake. They were also able to optimise data to channel marketing campaigns through visualization, reduce time to market and enhance employee productivity

BFSI‐Loans

4 Million Customers

01. About

The business acts as an online marketplace that makes it easier for consumers to get affordable loans, credit cards and insurance covers. The well‐established organisation extends  services across 500 cities and partners with more than 100 reputed financial institutions. The pioneering financial company has done more than 45,000 crores of business in Indian rupees.

The company helps users choose a loan by giving them information to compare and select products and process their documents to facilitate approval and disbursement. These processes involve collecting and using a lot of data for key functionalities:

As one of the first establishments of its kind, the financial services provider works off a huge, varied and complex database that forms the crux of the business powering marketing and critical operations.

02. Business Challenge

The business was facing great difficulty in channelling their marketing campaigns to improve conversion and productivity and marketing Return on Investment (ROI). Multiple teams operate by accessing a huge, complex and varied database for which the loan facilitator didn’t have a single view. Data duplication, retrieval, filtering for different purposes, delay in availability for analytics and lack of ready availability were some of the issues that were preventing the client’s team from data optimisation for better efficiency and productivity.

03. Technical Challenge

The main challenge was that the company did not have an effective system to integrate, de‐ duplicate and structure the data and appropriate it to different applications for optimal productivity and revenue acceleration. Data visualisation for various purposes was missing leading to delay in analytics and insights for making business decisions.

Other hurdles that the client had with the existing data setup:

Such complexity was dragging down operations across the organization and slowing down all data users, business users, developers and data scientists

04. Proposed Solution

Umbrella approached the problem with a three‐ronged strategy. This involved creating a data lake to easily integrate data from various sources; de‐duping the data and interlinking the data with various applications; and ingesting the data into the Datawarehouse (Customer Management System) to manage customer records. A dynamic web‐based campaign data planner application enables business users to develop marketing campaigns from the aggregated data. The client’s team is able to run the campaigns productively and capture performance data to gain insights for better planning.

data-sources-img

Data Lake

Data redundancy was the primary issue that was affecting efficiency, quality and customer experience. To first solve this hurdle, Umbrella began by creating a data lake, accumulating data from five major sources:

This step helped clear redundancy and pull all raw data from different sources and formats to create a single source of truth.

Transformation and Datawarehouse

The data from the lake was de‐uped and interlinked through the AWS ETL layer. The ETL layer helped load the raw data and other data points to other applications like the lead management system and the marketing campaign management systems.

Using the ETL layer, the data was then ingested into the customer management system or data mart to manage unique customer records.

Campaign Data Planner

The data is used by the web‐based campaign data planner to help the marketing  team customise and personalise campaigns by analysing customer behaviour and buying patterns. With the data, the team can target campaigns to a specific set of users and offer products that would be most valuable to them. The data optimisation helps them deliver more effective marketing campaigns that accelerate the company’s ROI.

05. Business Benefits

Big Data deployment has empowered the well‐known finance company to achieve critical business goals: