Automating monthly dealer payments

Wachovia National Bank · Financial services

A monthly dealer reserve disbursement process at Wachovia National Bank took approximately two weeks to complete. I developed and documented Microsoft Access applications to automate the business process and reduce the time required to complete the monthly workflow.

My role extended beyond development to requirements gathering, application testing, documentation and staff training.

The challenge

The monthly dealer reserve disbursement process required approximately two weeks to complete, creating an opportunity to significantly improve the workflow through automation.

What I did

I developed Microsoft Access applications using VBA to automate the process. I gathered requirements, tested the applications, created user documentation and trained employees to use the new solution.

The result

2 weeks to 3 days

The monthly dealer payment process was reduced from approximately two weeks to three days.

Automation transformed a lengthy recurring business process into a significantly faster workflow while providing employees with the documentation and training needed to use the solution.

Technology and skills

Microsoft Access • VBA • Business process automation • Requirements gathering • Testing • User training

Related services

Learn more about business process automation and custom software development.

See more examples of my work