HomePortfolio

Task Manager
January 2018 - Present

Our service desk used a laptop with an excel spreadsheet for tracking tasks. Eventually, the spreadsheet corrupts after the 300th entry. We lost vital information to unfinished tasks. The idea was great but there were a few concerns including repetition with having to manually type the customer's name and phone number for every entry.

While presented with the problem of the crash, I had to come up with a solution. After doing research, I decided to store all information into a local database and build a vb.net application.

Task Manager: Each button in the top navigation changes the command and queries to correct data requested. The user can separate tasks by current, completed and deleted. As soon as an employee types in the "New Task" view, the program will try to auto complete the fields. If the customer is found, the phone number field will auto complete but if the customer is not found, then the phone number will be completed by the user and stored for next time. The "Task Type" field is to stop duplication in the database for repeating tasks; an example is door quote. Multiple customers can request a door quote. The "Customers" & "Employees" button leads the user to the management system. The "Calendar" shows dates in bold for current tasks to help remind employees visually and the software has a bottom right overlay that always states how many tasks are current.

We're currently on our 500th task and the system is showing no signs of stopping or slowing down. Building forms in vb.net demonstrates a friendly and easy to use software for all employees. Anyone can enter a task without having to memorize or type repetitively. The program also includes custom commands that operates the right-click menu to filter and find tasks if needed.

Instead of manually updating the program, I took advantage of the in-house publish feature (built in to Visual Studio) to allow forced updates. Instead of one computer operating the software, the updating feature allowed easy access to this program on multiple computers. When an employee is inside of a task (whether modifying a task or viewing it) it becomes locked until the employee is finished.