Revolutionizing trip routing for transportation companies

Home » Portfolio » Revolutionizing trip routing for transportation companies

Project overview

Project deteils

Case Study Summary

Industry

Healthcare, Logistics

Project duration

6 years

Location

New York, USA

Team

1 PM and Architect, 3 Full Stack PHP Developers (middle), 3 PHP Developers (strong juniors),  1 QA (junior)

Services

MVP development, Web development,  API Integrations, Cloud migration

Our approach / Solutions

Business objective / Project overview

A new medical transportation startup aimed to scale operations, reduce manual work, and increase performance and quality. Their system needed to support a diverse user base of approximately 2,800 users, including brokers, insurance and healthcare providers, transportation providers, and patients.

Сhallenge

The startup faced significant challenges in establishing an IT solution that could support its operational processes and help win contracts. The client needed a scalable IT solution that could integrate with other medical transportation to meet their customers' needs. However, they lacked the necessary infrastructure to support this type of solution.

Our Approach

To kick off the project, the startup worked with a dedicated team, including a PM and architect, three full-stack PHP developers, three junior PHP developers, and one junior QA. GisArt suggested starting with an MVP approach to meet the initial six-month deadline.

As the project progressed, our client’s strategy and features were continuously refined based on retrospectives and team feedback. Recognizing the need for scalability, the team transitioned to a Large Scale Scrum (LeSS) framework with two-week sprints. As the project grew, so did the team, comprising a business analyst, tech lead, more developers, QAs, a data analyst, and a DevOps engineer, ensuring that all aspects of the solution were covered.

The startup faced tight deadlines, frequent changes in requirements, limited resources, managing a large team, and integrating new technologies like AWS, Docker, CI/CD, and Angular. To address these, GisArt developed a web portal that connected insurance providers, transportation providers, healthcare providers, and patients. 

Scope of work

Integrated Web Portal: Connected insurance, transportation, healthcare providers, and patients.
API Integration: Seamlessly connected with multiple transportation provider systems, allowing seamless data exchange and real-time updates.
Automation: Reduced manual work through automated trip reservations, monitoring, and real-time updates.
User Management: Allowed brokers to manage trips, providers to update credentials, and patients to order trips and receive notifications.
Scalability: Supported a diverse user base and handled large data volumes efficiently.

Solution

Software Architecture

To enable maintainability and scalability, we designed and implemented a software architecture that utilized both MVC (Model-View-Controller) and REST architectures.

Client Side

Choosing jQuery enabled dynamic interactions on the client side because of its simplicity and ease of use, allowing us to develop responsive web interfaces quickly.

Server Side

Selecting PHP for its flexibility and rapid development capabilities allowed quick changes and efficient application scalability. Using the Phalcon PHP framework ensured high performance and access to specific microservices. Laravel was a great choice due to its popularity and excellent support and documentation.

Components

The client’s system was built using:

Web Pages: To serve as user interfaces for brokers, insurance providers, transportation providers, and patients.
Views and Forms: For interactive data entry and display.
Controllers: To handle business logic and user requests, ensuring smooth interactions between the front end and the back end.
REST API: To facilitate communication between different system components and external services.

Data Models

The database layer:

MySQL: Known for its cross-platform compatibility. Including two replicas ensured redundancy and reliability.
PostgreSQL: Used in some microservices for its excellent performance with large datasets, providing robust read and write capabilities.

Data Collection and Analysis

The system was designed to collect, process, and analyze various data types, including numbers, strings, dates, times, geodata, and files.

Key data categories included:

PHI (Protected Health Information)
Trip data: Trip details, including origins, destinations, and times.
Provider data: Information about transportation providers, including credentials and compliance information.
Vehicles and drivers: Data on the fleet and personnel.
GPS data: Real-time location information for tracking and monitoring.
Billing and payment data: Financial transactions related to trips and services.

The system managed approximately 300 GB of data, encompassing around 4.6 million trips.

Infrastructure

Leveraging AWS Cloud for its HIPAA compliance, security, reliability, and scalability allowed us to handle sensitive healthcare data safely and efficiently. Docker was used to facilitate reliable and simplified deployment. As a result, this allows for easier rollbacks of releases and consistent environments across different stages of development and production.

Testing

Employing both manual and automated testing ensured the software's reliability. With tools like vREST NG for API testing, Selenium and Java for UI tests, and PHP Unit for unit tests, the team was able to release new features quickly and improve software reliability.

Teck stack

PHP, Phalcon, Laravel, .NET, C#, JavaScript, HTML, CSS, jQuery, Angular, MySQL, PostgreSQL, AWS Cloud, Docker

Outcomes

The startup successfully developed a scalable, efficient, and secure Web Portal connecting insurance, transportation, healthcare providers, and patients.

Brokers could now easily manage trip reservations, distribute trips, and monitor execution without manual intervention.
Insurance and healthcare providers benefited from real-time monitoring and alerts.
Transportation providers could maintain and update driver and vehicle credentials seamlessly.
Patients experienced enhanced services such as ordering trips, receiving SMS alerts, and viewing vehicle locations on a map.

This new solution automated critical tasks, significantly reducing manual work.

Integrating key transportation provider systems via API enhanced performance and allowed the client to score new contracts.

Our partnership has extended to supporting the product for more than 6 years.

Client Review

Contact us

Start the Conversation Today

Looking to optimize your business with GIS solutions?

As the CTO of GIS Art, I can help boost operations and enhance customer experience through efficient GIS implementation. Unravel patterns and actionable insights derived from spatial data. With over 15 years of software development expertise in Healthcare, Real Estate, Transportation, Logistics, and beyond, we can unlock the potential of your business.

Let’s talk!

You accept our policy