Featured work 05 · Logistics
Carton tracking and logistics visibility platform
A North American third-party logistics provider serving major retail brands could not reliably see where cartons were held up across its distribution locations. We built tracking and exception reporting that works over millions of scan records.
- Java
- MySQL
- Microsoft Azure
- BI dashboards
The challenge
Cartons stuck somewhere, nobody sure where
Operations teams could not see where cartons stalled between distribution locations, and reporting over millions of scan records was slow.
What we built
The solution
- Tracking of every carton through each scan stage across multiple pool locations.
- Exception reporting that flags cartons stalled between stages, by shipper, location and date range.
- Query and index tuning on the high-volume reporting database.
The outcome
Impact
- Live visibility
- Shipment status across every location.
- Exceptions on demand
- Exception reports in place of manual reconciliation.
- Java
- MySQL
- Microsoft Azure
- BI dashboards
- Query optimisation
FAQ
Frequently asked questions
How do you keep reports fast over millions of records?
By tuning the queries and indexes on the reporting database around the questions operations teams actually ask, such as stalled cartons by shipper, location and date.
Can exception reports be filtered?
Yes. Stalled cartons can be broken down by shipper, location and date range.
Talk to us
Not sure where to start?
A thirty minute conversation, no charge, and an honest view of what you need first, whether that is a new application, a security assessment or both.