Case Study: Robotic Process Automation (RPA) for a Large Financial Client
Radiant helped one of its financial services clients with process automation using industry-leading RPA tools. The factors that lead to effective automation of repetitive business process are:
A large financial services organization is transforming its securitization process that impacts the entire secondary mortgage industry. Three large financial services institutions and a governing body required quality reporting on a program’s progress to have a common understanding, track and monitor the issues and make informed decisions from time to time. It was a three-year-long, half-a-billion-dollar program.
The quality reporting data has to be obtained from all three participating organizations that use five different tools: Two instances of HP ALM, Rally Dev, IBM Clear Quest, and Service Now. These tools support their custom processes and configure very differently, which resulted in the following challenges:
Our Approach:
Radiant solved the problem in the following systematic steps:
Process / Data Normalization – We studied and analyzed the existing business processes of 3 different organizations and how the tools are configured in support of them. Since the business processes are tied to their other internal supporting processes, they cannot be changed without impacting the business. Hence, we developed a mechanism to fetch data from feeding organizations into a shared repository, which involved writing VBA macros, SQL scripts, and Python Programs that made seamless connections to all the tools in different organizations.
Six-Sigma Analysis to understand process bottlenecks – We analyzed and timed the 32-step process that took 4.5 hours to generate one weekly report to eliminate bottlenecks and reduce error-prone areas.
Automated Manual processes – Error-prone tasks were further automated to improve the accuracy of reporting and reduce the time taken to generate the report by 70%
Implemented Blue Prism to support more processes, implement controls to processes, support more processes, and support more intervals.
Summary
The Quality reporting is consumed by 300 stakeholders, including executives and decision-makers, and is carried out every day since February 2017 without a break, including holidays and furloughs of the client. Reporting errors are a rare scenario. New reports can be developed, implemented, and stabilized within a week. The necessity to support the late-night and weekend reporting was significantly reduced. This mechanism was humming along with process optimization and the implementation of Blue Prism.
The critical factors to success come with an in-depth understanding of business processes, applying engineering methods to optimize the processes, using the right tools and technologies such as python, SQL scripts, VBA scripts to automate small steps in the processes, documenting business rules for manual steps, tuning to the culture of an organization, securing infrastructure, establishing controls, and the ability to configure the RPA tool so that new processes can be easily supported.
Benefits / Facts
We learned how to leverage the culture, technology stack, and infrastructure of an organization to implement Robotic Process Automation. Please contact us to discuss our RPA expertise.