ENTERPRISE WORKFORCE & SAAS CASE STUDY

ShiftMatrix — Enterprise Guard Dispatch & Patrol Platform

Re-engineering security workforce management with 28-day master rotas, geofenced NFC patrol dispatching, LMS guard certification, and automated waterfall payroll.

https://app.shiftmatrix.com/operations/dispatch-dashboard

v2.4 Live

badge Role

Lead Full-Stack Architect

domain Domain

Security & Field Workforce

code Tech Stack

Laravel 13 PHP 8.4 Alpine.js MySQL

bolt Impact

⚡ 85% Faster Scheduling

🎯 100% Payroll Accuracy

auto_stories

Executive Summary

ShiftMatrix is a high-availability enterprise SaaS built specifically for physical security providers and workforce agencies managing hundreds of guards across dozens of client locations.

By replacing legacy paper rotas and disconnected tools with a centralized platform, ShiftMatrix enables operations managers to schedule 28-day shift rotas in seconds, monitor live NFC/GPS patrols in real-time, automate guard training certifications, and compute error-free multi-rate payroll.

Operational Friction

Solving Critical Field Bottlenecks

event_busy

1. Manual Rotas & Banned Guard Conflicts

Creating rotas for hundreds of guards across sites led to double-bookings, assigning expired SIA licenses, or scheduling guards banned from specific client sites.

check_circle Solution: Automated 28-day master cycle & live ban filters.

wrong_location

2. Unverified Check-Ins & Patrol Rounds

Lack of real-time visibility into whether guards physically arrived on site or completed mandatory NFC/QR patrol checkpoints during midnight shifts.

check_circle Solution: GPS geofencing & NFC tag scan tracking.

calculate

3. Complex Multi-Rate Payroll Multipliers

Reconciling SIN base rates, statutory holiday multipliers, split shift allowances, and gas reimbursements required hours of manual spreadsheet work.

check_circle Solution: Waterfall hours allocation engine.

database

4. Database Storage & Evidence Bloat

Storing millions of high-resolution incident evidence photos directly in production databases degraded server performance during peak hours.

check_circle Solution: Date-filtered DB streaming & images.txt manifest.

Architecture & Features

Core Software Modules

calendar_month

1. Master Rota & Recurring Scheduling Engine

7, 14 & 28-Day Cycle Automation

Engineered a master recurring rota system supporting multi-week template cycles with 1-click batch publishing. Before publishing, the engine executes automatic validation checks:

✓ Guard Availability & Overlap

✓ SIA License Expiration Check

✓ Site Guard Ban Rules

[ Master Template (28-day cycle) ] ──> [ Conflict & Ban Filter ] ──> [ 1-Click Publish to Live Board ]

my_location

2. Geofenced Live Patrol & Dispatch Engine

GPS Geofencing & NFC Tag Verification

Enables real-time field dispatching with mobile check-ins restricted to verified GPS geofence radiuses. Guards scan physical NFC/QR tags along patrol routes, logging instant timestamped location records.

payments

3. Automated Waterfall Payroll & Operational Reports

Scheduled vs. Actual Worked Hours Reconciliation

Parses scheduled rota hours against actual check-in/out logs (ACT) to calculate exact payable hours, applying statutory holiday multipliers and travel allowances per shift.

school

4. Guard Onboarding LMS & Anti-Cheating Certification

Chapter PDF/Videos & Timed Mock Assessments

Integrated learning management system featuring guard training courses, chapter PDF/video materials, and timed mock test assessments with randomized questions and anti-cheating controls.

inventory_2

5. Date-Filtered DB Archiving & Self-Healing Cron Jobs

High-Performance Database & Media Storage Optimization

Built a custom data archiving engine filtering shift records by execution window (started and completed) and bundling media URLs into an images.txt manifest alongside MySQL dump streams.

terminal

System Architecture Overview

┌─────────────────────────────────────────────────────────────────────────┐
│                       Client Presentation & Mobile                      │
│        (Blade Templates + Alpine.js + FullCalendar + Mobile API)       │
└────────────────────────────────────┬────────────────────────────────────┘
                                     │ HTTP REST APIs & Sanctum Auth
┌────────────────────────────────────▼────────────────────────────────────┐
│                             Laravel 13 Backend                          │
│ ┌──────────────────────┐ ┌──────────────────────┐ ┌───────────────────┐ │
│ │  Schedule Controller │ │  Waterfall Payroll   │ │ DB Archiver & LMS │ │
│ └──────────┬───────────┘ └──────────┬───────────┘ └─────────┬─────────┘ │
└────────────│────────────────────────│───────────────────────│───────────┘
             │                        │                       │
┌────────────▼────────────────────────▼───────────────────────▼───────────┐
│                              Database Layer                             │
│               MySQL (Indexes, Many-to-Many Pivots, JSON)               │
└─────────────────────────────────────────────────────────────────────────┘

Proven Results

Measurable Business Impact

85%

Time Savings in Scheduling

Fast 28-day master cycle rotas replace hours of manual rota entry.

100%

Payroll Calculation Accuracy

Automated waterfall hours & stat holiday multiplier rules.

Unverified Guard Check-Ins

Mandatory GPS geofencing & NFC tag scan tracking on patrols.

60%

Admin Overhead Reduction

Unified scheduling, LMS compliance, and automated payroll in one SaaS.

Ready to Build an Enterprise Software SaaS?

Partner with our engineering team to design, architect, and launch high-impact web and mobile platforms tailored to your industry.

Start Your Project arrow_forward