Skip to content
MSP

// PORTFOLIO

Selected work

Geospatial data pipelines, solution designs and location-data tools — each with the numbers it moved and the decisions behind it.

3 projects shown

  • // 01

    Geo Data Engineering

    $81.6M UNMET DEMAND

    NYC Taxi Supply-Demand Gap Analysis

    Seven-component GCP pipeline over 35M+ validated trips and 185 zones; PostGIS spatial validation showed that dispatch, not road access, was the bottleneck behind $81.6M in unmet demand.

    // IMPACT

    trips
    35M+
    zones
    185
    ADRs
    56
    • GCS
    • Dataproc
    • PySpark
    • BigQuery
    • dbt
    • PostGIS
    • H3
    • Kestra
    • Terraform
    • Streamlit
  • // 02

    Geo Tech

    2 DAYS → 3–5 MIN

    Geohash Schema Automation Extractor

    Self-service Python and Streamlit tool, still in production, that lets non-geospatial teams extract geohash schemas from map polygons without GIS skills.

    • Python
    • Streamlit
    • Geohash
  • // 03

    Solution Design

    3 DATA-SENSITIVITY TIERS · 9 REJECTED ALTERNATIVES

    Maritime Oil Spill Detection & Investigation — Solution Design

    End-to-end solution design for a national maritime authority scenario: architecture, detection and investigation workflows, WebGIS wireframes, sizing, licensing, and nine rejected alternatives.

    • Solution design
    • C4
    • WebGIS