Featured Case Study

Smart Workforce Management System


A cloud-ready workforce management platform designed to improve staff training visibility, rota awareness, compliance tracking and role-based access within a large retail-style environment.

Node.js Express MySQL Azure JWT Authentication Role-Based Access
SWMS dashboard screenshot

Main login screenshot

SWMS Dashboard Example HTML page

View SWMS Dashboard Demo

Please click on the above link to view the page used for the project.

Project Introduction


The Smart Workforce Management System was developed as a final year project to explore how a digital workforce platform could improve staff training visibility, rota management and compliance tracking compared with legacy spreadsheet-based methods.

Objectives


  • Improve visibility of staff training records.
  • Track completed, due and overdue training.
  • Support rota and staff availability awareness.
  • Apply secure login and role-based access.
  • Create a responsive system suitable for desktop and mobile use.

Proposed Outcome


The proposed outcome was to design and build a working prototype that demonstrated how a cloud-based workforce system could reduce reliance on spreadsheets, improve compliance visibility and support better operational decision-making.

Actual Outcome


A working application was produced with secure login, a training matrix, compliance tracking, employee records, administrative access and database-driven updates. The system demonstrated how training and workforce information could be viewed and updated more efficiently through a central digital platform.

Technical Implementation


The system used a Node.js and Express backend connected to a MySQL relational database. Authentication was handled using JSON Web Tokens, with role-based permissions used to control access to administrative and general user functions. The frontend was designed using HTML, CSS, JavaScript and Bootstrap to provide a clear and responsive interface.

Dashboard screenshot

Dashboard interface

Training Compliance screenshot

Compliance Training Tracker

Manage employees screenshot

Manage Employee records

User details screenshot

User Details

Key Skills Demonstrated


Reflection


During development I gained practical experience in designing a workforce management platform that balanced usability, security and business requirements.

The project strengthened my understanding of database relationships, authentication systems, responsive design and the importance of user-centred development.

Future improvements