Contact Center Workforce Management Team Request Tracker

By Sean Woodward on 4/22/2021 in Projects

The people responsible for managing the telecom system, setting agents schedules, skills, and other important data recieve many requests per day. Certain Workforce Management Employees are designated responsibilities to specific service lines. Some requests need to be processed immediately, while others need to be processed in the future. The person responsible for managing the productivity of their employees needed a way to keep track of how many requests were coming in and how timely they were being responded to.

This was a business process that began with the business creating a SharePoint list, and they setup a process where Supervisors that needed the assistance of a Workforce Management team member would submit the request by creating a new item on this SharePoint list. The WFM team recieved a notification each time an item was created, the appropriate person would work the request, and an email would go back to the person that created the item to let them know that their request had been completed, or needed more information, and etc. They would then export the SharePoint list to excel and perform some pivots to analyze the productivity of the Workforce Management Employees. The SharePoint list views were in a constant state of being over the size limit, that this process just became unmanageable from a SharePoint perspective.

I transitioned all of the processes supported by this SharePoint list to a .NET Framework MVC Web App "from soup to nuts".

The SQL Server was setup as having extra Schema's and Tables added to the MasterRoster database.

This application went live in production on April 29th, 2020 and is still in use today. There have already been over 32,000 requests tracked in this system.