• Met regularly with project managers to accurately create and maintain spatial models of 22 potential expansion projects using linear referencing and SQL databases to track project data including mode, alignment location, land ownership/ROW, surrounding demographics, ridership model OD data, and environmental concerns.
• Used data from the Census Bureau, the local MPO, internal TransCAD model results, and Replica to analyze changing demographic, employment, and travel trends in the MTA region.
• Authored Python and SQL scripts to efficiently manage, analyze and map demographic, ridership, travel flow, and project data.
• Designed and maintained data visualizations using ArcGIS, Python, Adobe Illustrator, Power BI, and Microsoft Excel.

What I learned.

Why I felt useful.

• Designed a spatial database to site and engineer green infrastructure and managed 2,000 assets over the life of the multiyear project.
• Authored python scripts to collect and manage census and project data and to communicate project progress with other team members.
• Designed tools in ArcGIS Model Builder for spatial and hydraulic analysis of green infrastructure sites.

• Aggregated and managed demographic and transportation data for analysis and public presentation.
• Supported spatial data needs of Civil and Traffic Engineers.

• Updated spatial data networks in GIS to reflect ongoing pipeline construction and repair.
• Researched historical drawings, maps, and other documents to verify and correct existing data.