Case Studies

Dispatcher Web App - Technician Job Management

An all-inclusive application built for easy technician job management, report generation, and payment processing by dispatchers.

Web App URL

Overview



The proposed application by the client required a comprehensive technician job management system that worked in real time. With a vast number of locksmiths spread across various regions, the application allowed dispatchers to connect with technicians, manage jobs, payments, maintain reports, generate invoices, and more.


Core Features



  • Real-time Technician Job Management.
  • Designed for flexibility across different time zones and locations.
  • Completely configurable dashboard with custom settings.
  • SMS & Email messages with two-way communication sync.
  • Generating customized reports, invoices and more.
  • Easy retrieval of data using the search feature.
  • Payment calculator based on pre-defined variables.
  • Multiple programmable Twilio numbers provided.
  • Failed SMS automatic override with voice call.
  • Supports end-to-end Job Management life cycle.

Challenges



The idea was like no other, requiring in-depth analysis and broad research to come up with a realistic development plan. Owing to the widespread locksmith network spanning across various locations, the real challenge lay in bringing them altogether and providing real time, easy and hassle-free technician job management.

Some of the complex challenges we came across during development include:

  1. Identifying the core platform to build the system on.
  2. Finding a solution to allocate jobs as per different time zones in different areas.
  3. Synchronizing Gmail and Web Mail.
  4. Generating the area radius of the job using inputs entered.
  5. Two way communication and job allocation via SMS.
  6. Calculating technician’s payment factoring in variables, such as the working zone, check rate, credit card rate, etc.
  7. Automatically updating job location on Google maps for easy traceability.
  8. Keeping a track on technician activities and a record of all the critical data.
  9. Ensuring fast processing and complete optimization of the portal.

Solutions



Once we received the client’s requirements, our team carefully analyzed it, and after rigorous brainstorming sessions, they came up with viable solutions to overcome the challenges stated above.

Here’s what we achieved:

  1. To build the application, we decided to use technologies such as LAMP and CodeIgniter.
  2. A combination of MaxMind GeoIP and Google API was used to determine locations and time zones, thus allowing the application to work in real time.
  3. The PHP IMAP client library was integrated to retrieve the client email and attachments, and sync between Gmail and Web mail. 
  4. To derive the metro radius, we used the Zip code API, which allows us to calculate the radius, distances, and latitudes and longitudes for the zip codes.
  5. Twilio API allowed us to achieve SMS synchronization to facilitate two-way communication between the dispatcher application and messages server.
  6. Using predetermined percentages for each technician, payment is calculated based on the location and time zone that’s captured using the Zip code API and Google API.
  7. We used the Google API, tweaking it to seamlessly update the technicians on job locations.
  8. Customized report generation feature was included to keep a tab on various activities, ease the management of jobs and payment processing.
  9. To ensure robust performance of the system, we minified CSS and JS, optimized MySQL query, used MySQL Indexing, followed the PDO data model, utilized the MySQL stored procedure and triggers, and designed the front controller using CodeIgniter.

Result


Technical proficiency combined with our team’s meticulous approach to the project, resulted in the development of an application that fulfilled client expectations. By utilizing an exemplary product unlike any other, the client was able to facilitate better job management, improve work efficiency and streamline several business processes.



ROI



The end product assisted the client in managing jobs, technicians, dispatchers and the overall operation, thereby boosting organizational efficiency, which in turn translated into substantial returns.