• Created bus GTFS real-time passenger count adjustment procedure to improve the accuracy of reported bus crowding categories• Developed new geospatial methodology for mapping bus route shapes to OSM roadway segments which helped to identify passenger crowding at the roadway level

• Create user defined functions and transformations for geospatial data using python, pyspark, scala, and PostGIS SQL using EC2, EMR, Databricks and AWS Aurora• Automated ETL pipelines connecting APIs to Aurora RDS leveraging AWS infrastructure - including S3, EC2, and custom Lambda Python functions• Developed and automated SQL data transformation scripts to support data visualizations• Provided technical support for a variety of data science modeling projects utilizing Azure resources• Developed technical Azure training for researchers building ML and AI applications on Azure• Facilitated technical training sessions covering Azure storage solutions, data connections, Azure Machine Learning, Power BI, and Azure resource management

Capstone - King County Metro Bus Predictor: • Leveraged AWS S3 to store over 5M raw bus and stop updates from OneBusAway's API • Created python data cleaning pipeline to organize bus stop and vehicle data into an AWS RDS for easy querying • Cross validated a gradient boosted regressor for all routes in the King County Metro bus system (365 models covering all route directions)Case Study - Movie Recommender: • Utilized AWS EC2 and Spark to manipulate dataset of 20M movie reviews • Used Alternating Least Squares matrix factorization to populate a ratings matrix for existing users and movies • Used a gradient boosted regressor to fill ratings for new movies, and new users to help with cold start challenge

• Coordinate project designs with other engineering disciplines and Department of Environmental Protection (DEP) Bureaus• Design and analysis of stormwater piping for water and wastewater capital improvement projects• Develop construction documents including plans and specifications for site development, grading, drainage, piping, and soil and erosion control, for water and wastewater capital improvement projects• Develop RFPs, review proposals and cost estimates and select appropriate bidder• Perform GIS spatial analysis and visualization to support IHD projects

NYC Right-of-Way Bioswale Program• Managed the planning and analysis for an Office of Green Infrastructure (OGI) Right of Way Bioswale (ROWB) and Stormwater Greenstreet (SGS) contract area in Jamaica, Queens.• Developed project delivery standards for In-House Design ROWB and SGS projects• Managed and trained staff to assist with the ROWB and SGS contract• Developing and implementing remote data collection system for the ROWB and SGS contract using ArcGIS Online• Prepared multiple Request for Proposal contracts and a bid contract including budget and schedule coordination, drafting contract and specification language• Managed a $2.1 M geotechnical investigation and survey contract including over 300 shallow borings taken to determine water content, Unified Soil Classification System classification, organic content, and particle size distribution as well as in-situ permeability tests• Co-presented at NYWEA Annual Meeting 2016, “Geotechnical Investigation for Green Infrastructure Goes to the Cloud”

Sustainability, Permitting, Organizational Development• Implemented a recycling pilot, analyzed pilot survey results, planned an agency-wide recycling roll out, produced educational documents and facilitated training, and developed a long-term recycling strategy and DEP-wide program• Assisted with a the development of new sustainability guidance documents as a member of DEP’s Panel for Sustainable Infrastructure• Collaborated on a framework for a knowledge sharing system within the Bureau and the Department• Assist in preparing and reviewing technical information required to support permit identification and acquisition• Supervise, facilitate and review design and construction correspondence to regulatory agencies• Research and investigate regulatory documents directly related to project engineering activities

• Set up stream monitoring stations; Retrieved and analyzed station data• Became familiar with Total Maximum Daily Loads, Idaho Fish and Game reports and Clean Water Act regulations