on 14-09-23 03:08 PM
Our finance team had a large backlog of purchase order information which needed to be transferred from .csv files to a newly adopted, online spend management tool. Rather than pay the vendor of this tool to transfer the information into the new system, we opted to use RPA to save the business the $12,000 data migration cost.
Step 1: Discovery
The team met with our finance team to understand how the data was structured, how it needed to be entered into the new tool and what inconsistencies exist between the 2 platforms
Step 2: Design
We knew that this automation would only run once, so we needed to ensure we did as much troubleshooting and exception handling in advance as possible. We also knew that this automation could be attended, since it would likely never need to run on a schedule.
Step 3: Build
The team first built a process to extract the data needed from the .csv file, then check it was compatible with the online tool (and make alterations if not) and alert a human should it find an exception which could not be addressed automatically.
We then built the process to take each record and enter it into the online tool.
Step 4: QA
Since we only wanted to run this automation once, we heavily peer-reviewed the process flows, which allowed fresh eyes to spot multiple issues which may have slowed down our run
Step 5: Run
We ran the process, handled exceptions and built in fixes along the way to prevent exceptions from re-occurring
Step 6: QA
Our finance team checked a sample of the records submitted for accuracy.
Our robots work faster than the web tool could handle, and caused spam / DDoS prevention mechanisms to be activated by the vendor. We solved this by collaborating with the vendor to temporarily lower protections whilst the automation ran, and built in delay time to prevent database issues in the vendor's system.
We saved the business $12,000 in professional services costs, at the expense of 12 working hours from our automations team. The total cost saving was roughly $10,000. We also saved our finance team's sanity, by removing the need for them to copy and paste records from Excel into the new tool!