Offering a 360-degree Data Warehousing Solution to an NBFC organization
01
About the Organization
Our client is an NBFC player with the mission of catering to the diverse credit requirements of underserved households and businesses by providing efficient and reliable access to debt finance.
Their diversified debt platform taps into a large network of financial institution partners, technology platforms (fintech), and other entities to originate financial exposure, as well as small businesses and individuals. They also engage with an equally large network of investors across different investor classes to access opportunities to invest in the under-served sectors in India.
02
Business Requirement:
1) Eliminate De-duplication
The client required a streamlined de-duplication process to identify and reject loan applications (in case the customer already has an active loan and reaches the maximum number of loans that can be sanctioned). They faced challenges in verifying and preventing the de duplication within their ecosystem.
2) Unique Customer Identification (UCIS) Creation
They required an automated UCIS system to replace their manual UCIS process that lacks integration across their products. The manual disjointed approach hindered their internal operations team from gaining a 360-degree view of their customer database.
Continued >
03
Business Requirement:
3) Customer Portfolio Management for Insights and Analytics
They faced challenges to perform analytics, derive insights and visualize data from their existing customer data (across products) owing to data silos. Hence, they required a data warehousing system to perform advanced and real-time analytics on the go.
4) Risk Analytics and NPA Identification
They wanted to establish an automated data analytics system to minimize the time and manual effort required for their internal business verticals to perform analytics and identify non-performing assets.
04
Key Achievements
1) Improved Data Accessibility:
Enabled quick and informed decision-making by ensuring a single view of accurate data for all loan products.
2) Optimized Data Storage:
Reduced data storage from 13 TB to 1TB by consolidating information from various sources into a unified system (data lake) for efficient reporting.
3) Efficient Fraud Detection and Loan Disbursement:
Implemented a historical intelligence system with the aid of a unique customer identification number for timely fraud detection and precise loan disbursement.
Continued >
06
Key Achievements
4) Swift Monthly Book Closure:
Achieved a remarkable reduction in monthly book closure time from 10 working days to immediate, enabling instant analysis of financial data.
5) Enhanced Operational Efficiency and Error Reduction:
Automating the manual book closure process resulted in zero errors, provided enhanced performance assessment of different loan products through real-time information, and increased operational efficiency by 100%.
6) Proactive Business Insights:
Empowered stakeholders with real-time data for predicting business growth proactively.
07
Tech Stack
07