Date of Award

Spring 5-2020

Document Type


Degree Name

Master of Science in Information Systems (MSIS)


Business and Information Systems

First Advisor

Ronghua Shan

Second Advisor

Christopher Olson

Third Advisor

Stephen Krebsbach


This web-based lookup will allow V employees to find territory sales rep much faster. It will simplify the process and eliminate manual processes.

At the moment, a combination of multiple manual processes is needed to find territory sales reps. The company’s CRM does not allow to find rep sales quickly. When an in-house sales representative is talking to a prospect, this sales rep has to go through a few series of steps to find an outside or territory sales rep --which is usually needed to schedule in-person meetings, that results in delays while doing transactions with the prospects. Besides, because of the convoluted process, not everyone knows these steps and sometimes this process ends up in the hands of more experienced reps or supervisors which means the use of unnecessary additional resources. This will be a web-based app connected to the organization’s database. Employees will have the ability to search for outside reps assigned to specific territories based on their zip codes. Thus, with just a couple of clicks, any employees will find territory sales reps which means that employees will utilize their time more efficiently and avoid escalating the situation.

Due to data security and privacy, A dummy database will be used. The only cost will involve time. The estimate is approximately 12 hours of coding using HTML, CSS, PHP, SQL database, and phpMyAdmin.