One of the significant challenges of the project was that each of the carriers has a different CRM interface with its specifics on how the information is tracked and provided to their customers, making the gathered data very different in format and analysis potential. Additionally, there was a varying frequency of data export capabilities and integration to the client ERP interface – all causing delays in reporting of performance analysis. We suggested the development of a unified checklist of data required from each carrier. Our team provided the technical expertise and our consultants communicated with the different vendors until we organized and delivered a unified data set. We created an automated dashboard that does hourly data updates and eliminates the need for manual data export and transformations.
We enabled our client to switch to a new model of reporting – On Time and In Full (OTIF), which gave them visibility to the delivery time as well as the quality of the received packages (in full, goods condition, etc.). To keep track of the OTIF metrics, we created a multifunctional application, which provides the management team with a one-single source of data for the whole logistical process, to identify areas of improvement and optimization. Furthermore, based on the collected data and the OTIF model, our client can now easily perform even more in-depth analyses with access through different devices – phone or tablet reports.