Case 01
Separating the shipment's chronology from the order in which its scans arrived
A June 2024 review examined 2,400 shipment histories used by our service teams. The sequence was interpretable in 1,920, while 480 needed further work. Three hundred and sixty involved delayed uploads, and 120 lacked adequate time-zone context. The enterprise view could sort every entry by arrival at the server, but that produced a confident-looking chronology which did not always describe the order of physical events. The display had confused a processing convenience with the evidence the service colleague needed.
The integration sponsor proposed using received time consistently so the platform could avoid maintaining several temporal fields. Depot operations argued that this would make a late upload look like a late movement. I supported a nine-week programme costing USD1.9 million to recover usable event context and preserve uncertainty where the source could not support a precise sequence. Technology worked with the operating owners who understood the scans, rather than inventing a plausible physical history from the order in which messages happened to arrive.
Four hundred and twenty of the 480 uncertain histories became interpretable. Sixty remained unresolved, leaving 2,340 usable histories and sixty explicit exceptions within the cohort. I retained the missing context in the report. The result concerned our understanding of events, not a claim that freight had moved sooner or that on-time delivery had improved. A corrected history might change how an earlier service result was interpreted, but that would need its own examination against the relevant commitment and physical evidence.
The choice added complexity to the enterprise account and postponed a simpler integration rule. It also gave customer-service colleagues a more defensible explanation of what they knew. They could distinguish an information delay from a possible transport delay and identify where another operating answer was still needed. I wanted the system to make those boundaries usable in a real conversation, rather than force the colleague to explain a precise sequence whose apparent certainty came from a field chosen for technical convenience. On a similar programme I would establish the event-time and time-zone requirements before agreeing the integration contract, so uncertainty is not discovered only when a service colleague tries to explain an earlier journey.