Security services · Workforce management

Manual attendance and payroll replaced with one automated admin panel

An end-to-end workforce system covering guards, attendance, payroll, billing and reporting — delivered and handed over, now used daily in production.

Client
Sheriff Security
Duration
Delivered & handed over
Role
Full-Stack Developer
Guards tracked daily
250+
Sheriff Security

The challenge

Attendance and salaries were handled manually. Missing records and payroll corrections could take up to a week to resolve each month, and there was no single view across salary, attendance, billing and expenses.

The approach

  • Modelled guards, attendance, payroll, billing and expenses into one coherent MongoDB schema.
  • Built real-time attendance tracking now used for 250+ guards in production.
  • Automated monthly attendance and salary generation including deductions, advances and bonuses.
  • Delivered a unified Reports module spanning salary, attendance, billing and expenses.
  • Optimised role-based REST APIs and queries to keep dashboards responsive.

Results

250+

Guards in production

Automated

Monthly payroll

2-3

Admins using it daily

1

Source of truth for reports

Stack

React.jsNode.jsExpress.jsMongoDBJWTTailwind CSS