← 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.