· Responsible for all reporting and data management for Clipper, including the maintenance of the Clipper Data Store· Spearheaded the rebuilding of the data store using Amazon Redshift, making it robust and scalable. Managed a team of interns to complete this effort.· Wrote Python code to automate the ingesting and cleaning of data into the data store.· Wrote Python code that automated the creation of tables and charts for the monthly Clipper Update· Wrote detailed documentation of my coding projects in Word and on GitHub· Monitored Clipper system operations and device performance and supported investigation of performance issues· Heavily involved in the design and implementation of the next-generation Clipper system and helped lead the design meetings relating to business intelligence, reporting, and the data warehouse · Identified usability issues with the proposed UI for the handheld card reader device and extensively documented concerns· Created dashboards with Power BI and Tableau to aid in data visualization and also analysis· Coordinated effectively with transit agencies and Cubic.· Consistently completed assignments ahead of schedule· Managed the invoices and purchase orders for the AT&T network required for Clipper functionality · Selected for the 2022 MTC Leadership Academy

See above.

· Conducted literature review on crash and health data linkage to contribute to the creation of a complete picture of collisions, and am writing a paper on findings· Interviewing experts in Vision Zero work to discover how road safety decisions are made in· Analyzing Emergency Medical Services data using Stata to determine if there is a difference in response times between urban and rural areas in California

· Collected data on roadway characteristics, diagnosed crash causes, and suggested countermeasures as part of Solano County’s Systemic Safety Analysis Report Program· Used Synchro and Excel to perform transportation impact analyses and communicated my findings through memos· Collected bus headway data in the field to establish the state of the system prior to the construction of a Bus Rapid Transit line

· Studied and compared common tools for estimating vehicle miles traveled to inform the implementation of SB 743, and wrote a section of the final report

· Transcribed conference calls and summarized comments and suggestions for improving school infrastructure· Researched possible causes and solutions to poor school infrastructure, summarized findings in memos

· Standardized and digitized project maps using ArcGIS· Entered pedestrian safety audit data into Access database for future analysis· Created a digital map of Maryland sidewalks using ArcGIS

• Worked as research assistant to Dr. Rachel Davidson at the Disaster Research Center• Geocoded the locations of survey participants to determine proximity to flood plains· Used ArcGIS and Excel to analyze property damage data from New Zealand earthquakes

I worked with Microstation, editing and making changes to plans, gathered information, and wrote reports.