← Projects

Traffic Analytics (Trafficure)

2024 – Present · Cities / Municipal

End-to-end architecture for city-level traffic analytics: high-throughput ingestion, geospatial processing, and dashboards that help reduce congestion and logistics cost.

PythonPostgreSQLPostGISDockerAWSETL

System design

Layered pipeline: ingest (batch + streaming) → normalize & geocode → aggregate by time/space → serve via APIs and dashboards. PostGIS for spatial indexing and catchment analysis; clear separation between raw, derived, and serving layers.

Highlights

  • Owned system design for high-throughput traffic data ingestion and analytics; defined schemas, retention, and SLAs.
  • Enabled cities to reduce congestion and save human time and logistics cost through real-time and historical analytics.
  • Designed geospatial models and APIs for traffic flow, hotspots, and reporting; ensured scalability and operational clarity.