Wali Haider Jalali.
Workforce Management · Operations ERPVerified in Production
Sheriff Security Services · 2025 — Completed

Replacing manual spreadsheets with an operations ERP for 400+ guards across 45+ client locations

A mission-critical enterprise workforce ERP deployed for 400+ security guards across 45+ locations, automating monthly payroll (Rs 3.5M+), 1-click bulk attendance, location billing, and 14+ financial reports.

Interface Previews6 Screenshots
Sheriff Security Services preview screenshot 1
Workforce ManagementLive Production
1 / 6

Project Overview

ClientSheriff Security Services
RoleLead Full-Stack Developer & Systems Architect
Timeline2025 — Completed
IndustryWorkforce Management · Operations ERP

Technology Stack

React.jsNode.jsExpress.jsMongoDBJWT AuthREST APIsTailwind CSSPDF/Excel Export

The Core Challenge & Bottlenecks

  • Manual Spreadsheet Chaos: Operations for 400+ guards across 45+ sites were tracked across disconnected paper registers and Excel sheets, leading to constant data mismatches.
  • Exhausting Attendance Routine: Admins had to manually mark attendance guard-by-guard hundreds of times daily, consuming 3–4 hours and causing frequent mistakes.
  • Month-End Payroll Delays: Calculating daily wages, overtime, and allowances by hand took over a week at every month-end.
  • Untracked Advances & Gear Costs: Staff salary advances and uniform costs were recorded informally, causing unrecovered losses during salary disbursement.
  • Billing Disputes & Invisible Margins: Client invoices were drafted manually with frequent tax errors, and management had no live visibility into location-specific profit or loss.
Goal: Eliminate manual bottlenecks & operational friction

The Engineering Architecture

  • Unified Operations ERP: Architected a centralized MERN-stack platform integrating guard profiles, bulk attendance, automated payroll, location billing, and executive analytics.
  • 1-Click Location Bulk Attendance: Built single-click bulk attendance submission by location and shift (Morning/Day/Night), turning a 4-hour daily chore into a 30-second workflow.
  • Rule-Based Payroll Engine: Programmed automated salary calculations factoring in attendance percentages, overtime, and daily wage tiers for monthly runs of Rs 3.5M+.
  • Automated Deductions System: Automated salary advance deductions and uniform fees directly during payroll computation, preventing revenue leakage.
  • Location Invoicing & Live P&L: Built automated invoice generation per client site with taxes calculated, payment tracking, and real-time margin calculation for every location.
  • Immutable Audit Trail: Engineered change-log history for every attendance and salary update so historical records can never be quietly modified.
  • 14+ Built-in Business Reports: Developed one-click PDF and Excel reporting for salary sheets, daily attendance, bank ledgers, client ledgers, and expense audits.

Verified Business Impact & Metrics

✓ Production Verified

400+

Guards managed in production

1-Click

Location bulk attendance

1 Week → 1 Hr

Monthly payroll cycle

14+

PDF/Excel business reports

Ready For Measurable Results?

Engineer a similar system for your business.

Collaborate directly with Wali to build high-performance web applications, AI booking workflows, or custom business software — delivered end-to-end.