• Data engineering: Set up PostgreSQL database server with commercial map data/ speed data/ traffic volume/ census/ employment/ survey data. Built an application to automated data inputs pipeline for traffic models from database, using SQL/ indexing/ PostGIS spatial processing/ GDAL geo data conversion.

• Developed large-scale quantitative traffic models for metropolitan areas on road network using traffic

assignment and network data model.

• Developed a tool to use Overpass API to access Open Street Map and decode JSON to geo data.

• Developed a system to produce maps automatically with activity-based model outputs using R and python.

• Calculated and visualized travel behavior measurements by different geographic or demographic groups using R.