FIG. 02.1
Everest Railcar Services
Freight rail SaaS · Dispatch · Real-time tracking
Problem
Rail operators processed daily CSV trace reports by hand. Backlogs stretched into days. Exception handling fell through the cracks. Fleet visibility lived in a spreadsheet.
Solution
I designed a 3-queue BullMQ pipeline — csv-import, exception-evaluation, od-recalculation — with idempotent job keys and atomic Prisma transactions.
Outcome
Daily manual processing went to zero. Each import cycle resolves 214k+ SPLC location codes.
Node.js · TypeScript · PostgreSQL · Redis · BullMQ · Prisma · AWS