Transportation and Logistics 2025 Project plus managed services

Logistics telematics, consolidated. Four feeds. One operational view.

A regional logistics carrier ran telematics from four OEMs, three TMSs, and an old historian nobody would touch. The dispatch team saw a fraction of the signal. We consolidated the feeds onto one platform, rebuilt the dispatch tooling, and moved reporting off the legacy stack.

Dispatch latency

40%

Reduction in median latency from signal to assignment.
Telematics feeds unified

4 OEMs

Plus 3 TMSs and the legacy historian retired.
Operational store TCO

32%

Lower than the legacy stack it replaced.

01 / Challenge

What was hard.

Dispatch saw one OEM's feed in near real time. The other three arrived in batches of varying reliability. Reporting ran on a legacy historian that the only person who understood it had retired. Every peak week, dispatch ran on gut feel and an Excel sheet. Finance could not trust the cost-per-mile numbers they published. The CIO had a budget to fix it and sixteen weeks to show progress.

02 / Approach

How we worked.

01
Source and shape audit

Two weeks mapping every feed, every downstream consumer, every report anybody actually used. Fourteen reports retired in that audit alone.
02
Target platform design

Snowflake chosen over Databricks based on the team's existing skills and the query shape. Ingestion through Fivetran and Kafka. Modeling in dbt.
03
Unified telematics model

One canonical model across OEMs, normalized units, late-arriving data handled, fault codes reconciled. Dispatch tooling rebuilt on top.
04
Migration and retirement

Legacy historian read-only, then quiet, then archived. Reporting moved to Looker. Old dashboards rebuilt once against the new model.
05
Day-two handoff

Runbooks, monitoring, and a quarterly managed-services arrangement for the data platform. Cost governance reports in the first monthly cycle.

03 / Outcome

What we shipped.

Dispatch cut median signal-to-assignment latency by 40% in the first quarter after cutover and held it. The operational store cost 32% less to run than the legacy historian plus OEM portals it replaced. Finance closed the month on the new reports by month four. The managed-services arrangement continued after the project closed.