During the first few months of the Covid-19 pandemic, The University decided to provide University student with support payments. Due to the large volume of payments required, the creation of the payments in the ERP system was handled by the RPA team. The RPA team processed over 20,000 payments reducing lead times and almost a 0% error rate.

• Testing
• Daily management
• Code Refactoring

• Student liason team will receive applications for payments from students.
• Student liason team provides the RPA team with a list of sucessful applications via an Excel file in a drop location.
• Bot begins the process by extracting the data and uploading the data into SQL table, Any duplicates are marked as exceptions and reported back to the student liason team
• Bot checks if a student site for the individual student is present in the ERP student for a payment transaction to be made.
• If a student site is not present the Bot will create the student site in Oracle.
• Once all required student sites have been creatd the Bot begins creating the payment in Oracle
• Payments made by the AP team to students as part of the regular payment runs.

• Payments made to students in need during the Covid pandemic in a timely manner.
• Huge savings in manpower during the end to end automation of the process.
• Reductions in lead times from 2-3 weeks to 3 days for more than 99% of the process due to the automation.
• Reduction in duplications and errors due to the auotmation of the process.