2x Faster grant processing time
96% reduction in data entry errors
40% of code contributed to the Consortium
Comprehensive public research university located in Virginia that offers 200 degree programs in a wide range of fields and is committed to promoting academic excellence, research and innovation, and community engagement.
- Industry: Higher Education
- Challenge: Manual Data Entry
- Solution: Custom Automation
- Outcome: 2x faster grant processing time
Are you ready to add WonderBotz to your organization?Get a Quote
Challenge: Manual Data Entry
The university’s processing team handles up to 500 monthly requests to create new grant data for scholarships, awards, and other fiscal line items.
Team members received requests by email and manually entered grant data into multiple screens in their account management platform, Ellucian Banner. This highly repetitive and time-consuming process often experienced data entry errors requiring rework.
Leadership sought a solution to eliminate the need for manual processing and improve data accuracy and compliance.
Solution – Reusable Ellucian Banner Automation
Working together with the institution’s Automation COE, WonderBotz provided custom RPA development. Creating reusable code that can be applied to other Ellucian Banner automations accelerating ROI as their RPA program expands.
The solution makes an API call to Google sheets which retrieves an Excel list of new grants to be created. The data is validated and loaded to an RPA work queue, where it is picked up by a digital worker. The digital worker navigates the platform and uses the grant data and configurable business logic to update all the necessary forms. Once completed, the solution updates the Google sheet with the processing status and alerts the team to records requiring follow-up.
The reusable RPA code was contributed to the WonderBotz Education Consortium. This program allows our university clients to share reusable code pieces through our RPA code library. Working together institutions can lower the barrier of entry, making RPA for Higher education reachable for all universities.