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+

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