Daily Average Loan Retrieval
Streamlining daily loan data retrieval and reporting with RPA automation
Key Solution: Robotic Process Automation (RPA)
Challenge
Complex Data Calculations: The Risk Management Department must query and count changes in the daily average loan amounts for various departments, retrieve detailed customer loan account information, and issue expiration warnings in accordance with the risk compliance system.
Labour Intensive: A dedicated person spends an entire day each month manually compiling these complex reports.
High Risk of Errors: Manual data handling is prone to omissions and inaccuracies, leading to operational risks.
Solution – Automation Workflow
Automated process by having the RPA Bot automatically query and download daily loan data under each customer’s name, then calculate the average daily loan amount and generate a comprehensive credit report—all without manual intervention.
Before Implementation:
- Full manual effort during normal working hours.
- Approximately 1 hour per transaction.
- Prone to errors and omissions, with high operational risk.
After Implementation:
- Increased reporting frequency.
- Saves one person’s labour.
- 1 transaction per month, taking 15 minutes.
- 100% accuracy via rule-based automation.
Impact
100% Accuracy
15 mins Single Transaction Time