Lauren Logo
How a Large PSU Bank Automated AEPS Data Processing with RPA
IndustryBanking & Financial Services
ServicesIntelligent Automation (RPA)

About the Client

The client is a Large Public Sector Bank (PSU), responsible for handling vast financial transactions, including AEPS (Aadhaar Enabled Payment System). Their objective was to automate the reconciliation of NPCI AEPS files, reducing manual workload and improving operational efficiency.

The Problem

The bank received a single raw AEPS file from NPCI, which had to be manually processed for Business Correspondent (BC) wise calculations across three daily cycles.

Key challenges included:

  • Time-consuming process – The manual calculations and reconciliation took an entire day.
  • High risk of errors – Human intervention increased the chances of miscalculations.
  • Lack of scalability – With growing transactions, manual processing was becoming unmanageable.

The bank needed a faster, more efficient, and error-free solution.

Our Approach

Lauren took swift action by isolating the compromised server and disconnecting it from the network. We initiated comprehensive scans on all applications and conducted a vulnerability assessment test for all endpoints, firewalls, applications, and cPanel. Immediately, we severed the server’s connection to the Disaster Recovery(DR) site and promptly initiated the creation of backups for existing data in Azure Data Lake. The workload was efficiently shifted using Azure connectors and Azure Sync, ensuring the Azure cloud remained in active mode throughout the process. To enhance security further, we promptly changed the IP addresses of users and modified the Fully Qualified Domain Name(FQDN) to an alternate one. Additionally, we ran scans across the entire infrastructure layers, utilizing existing OEM’s security products for added protection.

Tech Stacks Used

Automation Anywhere A360

Automation Anywhere A360

RPA Bots for Data Processing

RPA Bots for Data Processing

MFT (Managed File Transfer) Integration

MFT (Managed File Transfer) Integration

NPCI Portal Integration

NPCI Portal Integration

The Result

  • Processing time reduced from a full day to fully automated execution.
  • Eliminated human errors through RPA-driven accuracy.
  • Seamless integration with NPCI and MFT Portal.
  • Scalable and future-ready automation for growing transaction volumes.

Let's Work Together

Whether it's to discuss your next project, learn more about our services, or join our team, drop us a line and get the conversation started.