IndustryBanking & Financial Services
ServicesRPA
We made a visible and
measurable impact to our
client's business
reduction in processing time (from 8 hours to 2 hours).
75%
About the Client
The client is a Large PSU Bank managing high-volume UPI transactions across India. Their operations include reconciling transactions between Person-to-Person (P2P) and Person-to-Merchant (P2M) payments, requiring accurate and efficient processing.
The Problem
The bank's UPI GL Reconciliation (UPI GL Recon) process faced several issues:
- Massive Data Volume: 40 lakh records daily from NPCI and ARCOS.
- Manual Processing: Reconciliation through Excel files was slow and error-prone.
- Long Processing Time: Required 8 hours and 6 FTEs, delaying final GL reconciliation.
Our Approach
Lauren designed an automation-driven UPI GL Recon solution to:
- Automate data insertion using Automation Anywhere A360.
- Process high-volume transactions with SSIS database jobs.
- Generate MIS reports and GL worksheets automatically.
Our Development Process
- Automated Data Processing
- Extracted and reconciled P2P & P2M transaction files from NPCI & ARCOS.
- Implemented SSIS jobs to handle the massive 40 lakh daily transactions.
2. Accelerated Reconciliation Workflow
- Eliminated manual intervention by automating reconciliation tasks.
- Enabled faster and more accurate GL report generation.
3. Scalability & Error Reduction
- Reduced dependency on Excel-based reconciliation to minimize errors.
- Enhanced scalability to handle future transaction volume growth.
Tech Stacks Used
Automation Anywhere A360
MS SQL
SSIS Jobs
The Result
- Processing time reduced from 8 hours to just 2 hours.
- Eliminated errors caused by manual reconciliation.
- Freed up 6 FTEs, allowing them to focus on other critical tasks.