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 such as enplanement data, bus travel times, and headways for an airport in Queens, NY.Develop SQL statements to create new relation tables, insert data/update existing tables, and compute key metrics from an airport’s AWS database.Develop clear and concise data visualization tables and graphics such as coordinate heat maps, line, bar, and scatter plots using Tableau and Excel, including airtrain entry and exit passengers organized by hour, day, and year for an airport in Queens, NY.Use git to pull, add, commit, push, fork, and merge Python scripts to and from Gitlab and GitHub repositories.Develop Linux commands to navigate virtual machine directories using PuTTY and use Vim text editor to update scripts and text files.Work independently and with teams in Manhattan, Jersey City, Chicago, and Washington D.C. to produce written reports and proposals.Maintain client satisfaction of deliverables through comprehensive and proactive communication techniques.

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 consisting of over 400 patient entries.Interactions developed for the pages included “MultiSelect” widgets to filter by patient, gender, cancer type, histology, prior/subsequent chemotherapy/immunotherapy as well as “RangeSlider” widgets to filter by age, tumor volume, and speech discrimination score.Hosted dashboard locally on NYU Langone’s network and titles were added to the dashboard using bokeh HTML div elements.Collaborated with a doctor and physicist to develop project reports and to ensure reliable and accurate results.

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 with the CEQR manual, and the ITE Trip Generation Manual for a proposed warehouse in Harlem, NY Developed roadway infrastructure recommendations for a traffic study in Brooklyn, NY• 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 intersection in Brooklyn, NY Developed roadway design improvements and circulation plans for a Philadelphia hospital and a proposed mall in Queens, NYDeveloped traffic networks in Synchro to model existing, no action, and with action conditions for a proposed parking facility in Plainfield, NJ and a proposed football stadium in PhiladelphiaBalanced trip generation maps for a proposed skyscraper building in Dubai Analyzed MPT plans for two proposed mixed use buildings in Manhattan, NY to identify design flaws Passed the official Langan CAD Certification ExamInspected the construction of a parking lot consisting of 136 car parking stalls, 147 trailer spaces at the Goya Warehouse in Jersey City, NJ• 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 excavation, installation, and backfill for warehouse construction sites in Cranbury, NJ and Jersey City, NJInspected the backfill and compaction of two 50 ft. deep jacking pits for water main and force main installationOversaw 7 soil borings, 10 test pit excavations, and completed gINT soil classification entries for warehouse construction sites in Elizabeth, Gibbstown, Paramus and Newark, NJ

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 Plan transportation planning projectPerformed CAD detailing support for the Port Authority on the installation of Adaptive Transportation Systems to 16 intersections in Elizabeth, NJ

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 on:• 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 Bayonne Bridge design• 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 Bridge, the Oculus, and FCS Modular’s Atlantic Yards building factory

Master Of Science (Ms), Data Science

Bachelor Of Science (Bs), Civil Engineering