Company Profile Dell is the world's leading computer systems company. Dell, Inc. and its subsidiaries engage in the design, development, manufacture, marketing, sale and support of various computer systems and services to customers worldwide. The company’s products and services enable customers to build their information technology and Internet infrastructures. It offers various products, including desktop computer systems and workstations.
Project Objective
Dell Inc. has set its third Customer Contact Center in India at Mohali (Punjab). There are around 1500 employees working at Dell, Mohali, who avail the cab facility provided by the organization. The transport department provides 24X7 cab facility to all its employees.
There was a need to automate the processes of the transport department, in order to enable them to make better strategic, tactical, operational and execution decisions related to transportation, so that they can anticipate demand and properly position the transport services to meet that demand.
The primary objective of the project was automation of processed keeping in mind the end goal which was “cost effective route planning process”.
Solution Provided
GrayCell Technologies Exports provided Dell with an optimized solution to manage the Cab Schedule and plan Cost Effective Routes for all the employees of organization who avail the pick/drop facility.
The Transport Management System is a planned and structured process. One of its primary purposes is shift tracking. Here the user will select options such as pick / drop, date, shift time. The duty slips are generated for picks / drops and back to back cab service will be listed. The user can select a respective shift and enter certain data pertaining to that e.g. actual drops, actual picks, kilometers, no shows (reason listed in the drop down) etc. Team managers have rights to input and modify the data.
The project was developed using the .NET technology framework specifically ASP.Net with C# and SQL Server.
Feature List
- Data Reporting for various criteria like kilometers quoted by vendors, transport expense for each employee, etc
- Provision to update / change shift on special request
- Zone wise route planning
- Tracking changes in schedule
- Special requests can be added only by team managers/CCO
- Log files maintenance for every data transaction
- Automated duty slips generation for pick/drop trips
- Graphical representation of shift schedules
- Various data reports on the basis of key attributes
- Vendor Records Maintenance
Result
The Transport Management System enabled Dell Inc’s, Mohali office to identify all of the business areas that were impacted by transportation costs. It helped the organization manage these costs effectively and increase asset turnover by proper utilization of cabs and its proper scheduling.