Logistics Marketplace & Fleet Tracking
A nationwide freight platform for load posting, bidding, and real-time fleet tracking.
AngularNode.jsExpressTypeScriptMySQLGoogle Maps APIAWS
800K+
Shipments processed
5M+
Tons of freight moved
500M+
km of tracked travel
Overview
- OpenPort is a logistics moving platform — a digital trucking marketplace and transport management system that takes freight from order dispatch through to consignee delivery. Shippers post loads to pre-approved transporters, who bid in real time; once a booking is confirmed, the same system tracks the truck, records an audit trail, and keeps shippers, carriers, dispatchers, and consignees aligned instead of coordinating over phone calls and spreadsheets.
- The marketplace is built for transport procurement: licensed carriers, competitive bidding, booking management, and cost visibility. Alongside it, the TMS layer gives end-to-end supply-chain visibility — live GPS tracking, operational dashboards, and KPIs from dispatch to delivery, with electronic proof of delivery so consignees can follow order status and SKU-level progress.
- The work in this case study sits at that core: nationwide load posting and bidding, real-time fleet tracking on maps, role-based portals for each stakeholder, and reporting for throughput, utilization, and on-time performance — on a stack of Angular, Node.js, Express, and MySQL.
The problem
- Freight coordination relied on phone calls, spreadsheets, and manual check-ins. Shippers had no visibility into where their goods were, carriers struggled to find return loads, and operations teams couldn't measure performance. The business needed a single real-time system to digitize the entire freight lifecycle at national scale.
My role
- As a full-stack developer I owned major parts of the frontend (Angular) and backend (Node.js/Express with MySQL) — building the bidding workflow, the real-time tracking layer with Google Maps APIs, role-based dashboards, and fleet/team management modules.
Approach & architecture
- Designed a load-posting and bidding workflow so shippers post freight and carriers bid competitively in real time.
- Stored loads, bids, GPS history, and fleet records in MySQL, indexed for live tracking queries and operational reporting.
- Built a live fleet-tracking layer using Google Maps APIs, streaming GPS positions and rendering routes, ETAs, and status on interactive maps.
- Implemented role-based access control (RBAC) so shippers, carriers, dispatchers, and admins each see a tailored, secure view.
- Created operational dashboards and reporting (Power BI) to surface throughput, utilization, and delivery performance.
- Optimized data-heavy map and list views to stay responsive at scale.
What I learned
- Real-time geospatial data at scale is as much a UX problem as an engineering one — batching position updates and virtualizing large lists mattered as much as the backend. MySQL, with the right indexes, kept tracking and reporting queries fast as volume grew. Clear role boundaries (RBAC) early on kept the product secure and simple as it grew.
Want to build something like this?
I'm open to full-stack and real-time projects. Let's talk.