Title:

Strafford County Payroll System

The Payroll System project provides a web application for Strafford County Sheriff employees to submit payroll online. The web application automates the current paper based process. Officers can securely login and track the amount of hours and the type of work they do. This data is kept in a MariaDB relational database that stores the amount of hours, type of work, which officer, and more about each shift. Payroll administrators have special privileges to generate excel spreadsheets that detail each employee’s shift for the pay period indicated by the payroll administrator. This project provides value by automating the six to eight hours of work that the sheriff’s department currently does each week by hand, automatically generating an excel file of the selected pay period, and providing previously unknown overtime metrics, such as the amount of overtime in a year, to help with budget management. The server is hosted on AWS EC2 and the database is hosted by AWS RDS with an associated account made directly for the police department. The web application is accessible to all officers and is usable by any reasonably modern smartphone, tablet, or computer device with an internet connection.

Name

Comment*

Comments are viewable only by submitter

Captcha*