Batch Automation RPA for a leading insurance company reduces the TCO of IT Batch Job Team
Business challenge
The client, a leading insurance company, wanted to reduce the Total Cost of Ownership of IT services team. To do this, one of the areas they chose to work on was the area of automation of execution and monitoring of batch jobs.
About the company
The client is a Fortune 500 Insurance Company. Based in the United States of America, the company sells insurance products across the country.
Solution
The team at ComTec segregated the project into three stages – Discovery, Develop and Deliver.
Discovery
In this stage, the team analyzed the current manual process, i.e:
- Execution of jobs on Unix server,
- Transferring of files to Unix server,
- Downloading of files from the server, and
- Validation of them on UNIX.
- Input file validation,
- Result file validation,
- Mailbox monitoring
- Application monitoring
- Job monitoring
Develop
In the developing stage, the team developed three bots using UIPath. The aim of developing these bots was to help the company to schedule and execute the jobs using the bots.
Deliver
The team delivered three bots.
- TCC job monitoring bot: This bot validates input file, executes the job on UNIX, validates the result file, re-executes the jobs if required, and monitors the mailbox.
- SAP job monitoring: Apart from the input file and result file validation; this bot executes jobs on SAP, monitors jobs and escalates when needed.
- Interface monitoring: Bot verifies every job status and notifies all stakeholders via e-mail. Publishes the report on SharePoint.