Alex Spence Email & Phone Number

Red Bank, NJ, US

New York, New York, US

New York, NY, US

• Develop scripts in Python for data cleaning, storage, analysis, and visualization such as:
• Two Python scripts to clean and analyze crash data for corridor studies in NJ townships.
• Three Python scripts to transfer taxi dispatch, traffic sensor, and 60-day flight airport data from Outlook to a Postgre SQL database.
• Two Python scripts which used ChromeDriver to scrape and clean weather and parking HTML data for an airport in Queens, NY.
• One Python script to clean GTFS bus data and calculate average number of bus trips to and within three pricing zones for a congestion pricing study in Washington, DC.
• One Python script to clean and analyze speed and load data for 50 routes of a bus network redesign in Brooklyn, NY.Develop and maintain scripts in VBA for data cleaning, storage, analysis and visualization of metrics.

New York, NY, US

Used Python libraries such as bokeh, pandas, numpy, and scipy to develop an informative, dynamic dashboard which displayed general statistics and survival curve pages for a metastasis patient registry consisting of over 4,000 patient entries, and general statistics and speech discrimination score scatter plot pages for an acoustic neuroma patient registry.

Parsippany, NJ, US

• Analyzed count data in jobs ranging from New York City to Philadelphia to calculate traffic statistics such as peak hour volumes, peak hour factors, and heavy vehicle percentages Performed trip generation in accordance.
• Coordinated with Sam Schwartz Engineering and NYC Economic Development Corporation for reports and presentationsDeveloped roadway improvement recommendations such as pedestrian safety islands and curb extensions for an.
• Performed over 500 Nuclear Density tests to ensure the base and top course were compacted to 92% of the maximum theoretical densityInspected approximately 1,000 LF of force main, water main, and storm water pipe.

Red Bank, NJ, US

• Performed Roadway Data Management System field work for the Port Authority at JFK International Airport
• Analyzed drawings of 72 intersections and identified information such as signal head type, orientation, material, and height, visor type, and lens typeOrganized and performed data entry for the NJIT and NJDOT Master.

Stockholm, SE

• Conducted research & produced written reports on:
• Safety Glove Investigation: Based on results obtained from a grinder and pneumatic chisel test, final field glove recommendations were given.
• Equalizer Plate Test for the Bayonne Bridge: The design was load tested in accordance with OSHA standards, no cracks were found, and the design was approved.
• Pretension Rod Test for the Oculus Transportation Hub: The hydraulic pressure needed to torque threaded rods to their designed preload was tested with a hydraulic tension wrench & a load cell. Researched and presented.
• Fall Protection Plan for solar panel maintenance on a roof: A final recommendation was given in accordance with OSHA 1910, 1926.Analyzed engineering drawings, As-builts, and provided CAD detailing support for the.
• Produced all assigned CAD drawings of bridge components in an efficient and timely mannerCompleted steel takeoffs for the Bayonne Bridge on a transfer truss and a Mi-Jack craneParticipated in site tours of the Bayonne.

Master Of Science (Ms), Data Science

Bachelor Of Science (Bs), Civil Engineering