Case Study № 04 of 05Download PDF

Codename — Sextant

One spine for every machine moving from yard to vessel.

Industry

Heavy Equipment Export Operations Platform

Role

Product lead & full-stack engineer

Stack

ReactTypeScriptTanStack QueryTailwind
Sextant operations dashboard

Summary

At a glance

A work-order and customer-portal platform for a heavy equipment exporter, replacing a tangle of spreadsheets, shared inboxes, and phones-buzzing-for-status with a single operational system from arrival to shipment.

The Problem

What the team was up against

  • 01

    Inbound machines were tracked across spreadsheets, paper files, and shared email folders — every team carried its own copy of the truth and the copies disagreed.

  • 02

    Operations leadership had no live view of which units were aging in the yard; priorities were set by whoever shouted loudest that morning.

  • 03

    Customers called constantly for status updates, and photo evidence of each unit's condition was scattered across personal phones with no link back to the work order.

The Solution

How the platform answers it

  • 01

    A single work-order record per machine, owned end-to-end, with role-scoped dashboards for admins, yard staff, and the customer portal — one source of truth, three audiences.

  • 02

    An aging heatmap and stage-gated pipeline (Received → Inspection → Prep → Photo → Ready → Shipped) that surface the units genuinely at risk and route field captures straight onto the right record.

  • 03

    A self-service customer portal with live status, photo gallery, and shareable order links — collapsing inbound status calls and giving the export team back its mornings.

Export pipeline — Sextant

STAFFField capture · checklist · photo uploadReceivedInspectionPrepPhotoReadySHIPPEDAGING HEATMAPCUSTOMER PORTALSelf-service status · photos · ETA

Selected screens

Sextant operations dashboard
Fig. 01

Operations dashboard with aging heatmap

Sextant order tracker
Fig. 02

Customer-facing order tracker with milestone timeline

Sextant field capture
Fig. 03

Field staff capture — inspection checklist and photos

Impact

−70%

Customer status inquiry calls

100%

Photo and document traceability per unit

Real-time

Operational visibility for every stakeholder

1

System of record, down from spreadsheets and shared inboxes

Technology

Frontend

  • React
  • TypeScript
  • TanStack Query
  • Tailwind

Backend

  • Postgres
  • Row-level security
  • Edge functions
  • Object storage

Mobile

  • Mobile-first capture
  • Camera upload
  • Offline-tolerant checklist

Portal

  • Public order tracker
  • Shareable links
  • Role-scoped dashboards
Next case studyContinue

Keystone Accounting / Professional Services