Contact

Service department audit

Service Department Vehicle Audit

In production Integrated with dealership data

Verifies that every vehicle in the service department has an open repair order by scanning its VIN with the device camera.

Problem

An automotive dealership's service department holds vehicles under repair, completed vehicles awaiting pickup, and vehicles whose presence is undocumented. There was no reliable point-in-time record of which vehicles were physically in the service department.

Solution

The application retrieves open repair orders from the DMS and compares them with the physical walk-through. Vehicles without a matching repair order retain their details and location for follow-up.

Outcome

The dealership receives a verifiable snapshot of the vehicles present in the service department and identifies those without a matching repair order.

My role

I designed and built the mobile walk-through, DMS lookup, evidence capture, and corporate inventory tracking.

How it works

The physical walk-through checks each vehicle in the service department against open repair orders and documents every exception.

Scroll horizontally to view the full diagram.

Service department vehicle audit against open repair orders The captured identifier can produce an exact match, possible matches, or no match. Each result updates the snapshot, and the auditor continues until completion and export. LISTS ID EXACT POSSIBLE NO MATCH SELECT DISMISS VERIFIED UNMATCHED PROGRESS YES · NEXT NO DMS Load repair orders Location and brand AUDITOR Capture VIN or plate Camera or manual entry MATCHING Match found? Exact, possible, or none AUDITOR Review suggestions Select or dismiss MATCH Verify vehicle Location · photo if scanned NO REPAIR ORDER Log unmatched vehicle Details and location; no photo SNAPSHOT Update progress Pending items and results WALK-THROUGH Continue? Next or close OUTCOME Close and export Completed audit and Excel export WALK-THROUGH NEXT VEHICLE MANUAL COMPLETION
The application distinguishes exact matches, possible matches, and vehicles without a repair order. Each result updates the snapshot before the auditor continues or closes it manually.

Key functions

Technical details

Backend
NestJS 10 · TypeORM · PostgreSQL 15
Frontend
React 18 · Vite · Tailwind CSS · browser image capture
Infrastructure
Elastic Beanstalk · RDS PostgreSQL · S3
Data source
Open repair orders from the DMS