Ashok Leyland, India had commissioned a web portal towards serving their end customers with better fleet management. The services offered through this portal helps in improving the productivity and safety of vehicles, business operations and hence, the profitability of the customers. Track and trace, SMS/email alerts and report generation are the major functionalities of this portal. They assist the customers in analyzing the operations of their vehicles and take corrective actions towards optimizing them.
However, there were certain problems faced by the customers, while accessing these functionalities through the web portal. This includes, significantly high lead time taken for report generation, unavailability of location details in the reports and track page due to early expiry of reverse geo-coding service limits. As these problems were affecting the basic functionalities of the portal, analysis was done to understand the root cause of the problems so as to address them appropriately.
The original processes involved in report generation and the associated database table design was examined. The factors causing high lead time were identified and design improvements were made to minimize the lead time, within acceptable limits. The efficacy of the revised design was evaluated for reduction in the lead time, which was observed to be up to three minutes while selecting 50 vehicles and time period up to one month.
The design of applications involved in the reverse geo-coding process was examined. The factors causing early expiry of reverse geo-coding service limits were identified. Design improvements were made in the applications towards optimizing the reverse geo-coding process, which addressed the early expiry of reverse geo-coding services. Hence location names could be displayed in the track page and reports without any interruption.