Umbrella’s Big Data solution helps a leading ﬁnancial service leverage data for improving conversion and Marketing ROI
The business acts as an online marketplace that makes it easier for consumers to get aﬀordable 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 oﬀ 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 diﬀerent 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 eﬀective system to integrate, de‐ duplicate and structure the data and appropriate it to diﬀerent 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 redundancy was the primary issue that was aﬀecting 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 diﬀerent 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 oﬀer products that would be most valuable to them. The data optimisation helps them deliver more eﬀective 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: