Absolute Delivery Services — Delivery Operations Platform

//Outcomes

//The Problem

Driver and walker scheduling, daily staffing targets, and weekly billing all lived in spreadsheets that had to be updated and cross-referenced by hand. Every week, someone had to manually match staff performance against daily targets, apply the correct rate tier, and calculate pay — a slow, repetitive process where a single copy-paste mistake could throw off an entire week's billing. There was no central place to see staff availability, so scheduling conflicts were caught late, if at all.

//What Was Built

• ›Role-based admin dashboard (admin, manager, user, data entry) with secure session-based auth
• ›Driver and walker scheduling built around service types (Core 0, Core 1, WTC/Bulk, Hubs, Micro Hub) with truck and resource assignment
• ›Staff availability tracking with regular schedules and one-off exceptions
• ›Automated weekly performance rating engine (Great / Fantastic / Fantastic+) tied directly into pay calculations
• ›Automated monthly billing reports generated straight from daily targets vs. actuals
• ›Missing-package and ticket tracking linked to staff performance history

//Solution

I designed and built a full-stack platform — Express and Drizzle ORM on Postgres for the backend, React and TailwindCSS on the frontend — that replaced the spreadsheet workflow entirely. Daily targets and actuals are entered once and automatically roll up into weekly performance ratings, which in turn drive the correct billing rate per staff member with no manual lookup required. Scheduling for drivers and walkers is now built around real service-type and truck assignment rather than a shared spreadsheet, so conflicts and gaps are visible before they become a problem. Role-based access means dispatchers, managers, and data-entry staff each see exactly what they need, and monthly billing reports that used to take hours to assemble by hand are now generated automatically from the same data.

//Tech Used