Cloud-Based Loan Recovery Analytics for the Banking Sector
Case Studies
Challenges & Solutions
Technical Environment
Results
Executive Summary
Client
Bank
Industry
Banking, Financial Services, & Insurance
Business Problem
The customer sought cost optimization due to various applications running on different platforms, with a focus on improving loan recovery through enhanced automation. They developed a robust analytics platform to serve the entire organization, delivering improved KPIs. A centralized data repository with high-quality, enriched data was established to support the analytics platform.
Challenges
- The on-premise infrastructure was costly and spread across multiple sources, limiting business expansion due to the constraints of the IT infrastructure.
- Partial automation of critical activities adversely affected operations, while delayed loan recoveries, stretching over several days, led to reduced profitability.
Solutions
- The entire analytics platform was migrated to the AWS cloud, utilizing the AWS stack and Databricks for tasks such as data migration, cleansing, and transformation.
- A data lake was built using both batch and real-time pipelines, tailored to the critical KPIs and CI/CD pipelines.
- Dashboards were developed to offer a comprehensive 360° view of loan status at various levels.
Technical Environment
- Amazon Athena, Amazon S3, DevOps, AWS Lambda, Amazon Glue, Databricks, Elasticsearch
Results
- Debt collection is estimated to increase by 7% after solution implementation
- KPIs is estimated to increase from 2300 to 4500+
- Dashboards is estimated to increase from 10 to 18