Philip Cooper Email & Phone Number

Waterloo, Ontario, Canada

Toronto, Ontario, Canada

Technical • Automated repetitive tasks and processes with VBA, Python, and Power Automate- Excel Worksheet Compare: identify changes between work sheets- Excel to Word: DOORS export to styled and formatted report for review/editing- Word to Excel: Report back to spreadsheet for import into DOORS including 'Comments' - Defined Terms: Extract defined terms and location of each instance used across multiple docs• Conducted data analysis with Python in Jupyter Notebook- Equity based fare analysis for TTC and YRT using Census & Transportation Tomorrow Survey• Conducted Carbon Emissions Inventory Analysis for Whitewater Midstream pipelines• Developed data scaping scripts in Python for real time data collection• Created Power Apps and Power Bi dashboards• Developed GoogleMaps.js and Leaflet.js web apps in React.js• ArcGIS and QGIS spatial analysis• Developed a 3D stress model in Excel• Spearheaded team's roll out of Microsoft Teams• Developed and implemented a Document Control System in Client's SharePoint • Developed sophisticated tracking and data collection tools in Excel and SharePoint• Developed dynamic PowerPoint visuals such as automated Progress Bars• Developed interactive PowerPoint Presentations with Poll Everywhere• Developed surveys in Microsoft FormsCommunication• Managed Projects• Wrote proposals, reports, case studies, onboarding documents, and documentation for scripts• Conducted a Site Visit for operations audit• Ran and led lunch and learns, client meetings, and workshops• Joint Health and Safety Committee Employee Co-ChairAwards and Acknowledgements• 1st place at internal Dynamo Hackathon (Global)• 1st place at internal Shark Tank Competition (North and South America)• 2nd place for internal Digital Delivery Award (Global)• 3x 1st place finishes with University of Toronto Capstone Projects as Client representative/advisor

Vancouver, British Columbia, Canada

Toronto, Canada Area

- Followed specifications to size and select air handlers, fan coils, pumps and heat exchangers. - Provided quotes to clients and addressed concerns as needed.

Waterloo, Ontario

- Assessed impervious surfaces via aerial imagery to determine storm water management fees- Developed forms in infraMap for mobile data collection during maintenance operations- Utilised definition queries to develop project maps in ArcGIS to streamline field navigation- Updated and created activity records for hydrants, valves, and water quality results

Brantford, Ontario

ArcGIS - Used georeferencing to draw newly verified assets in their existing feature classes- Assigned ID values to assets for future querying and management- Created KML layers from ArcGIS projects to be displayed within Google MapsDatabase- Created records to document relevant attributes for the newly verified assets- Utilized VBA and HTML to dynamically display Capital Planning projects as an overlay on Google Maps for Access database records

Velocity Garage

Scripting- Used Python and Javascript to improve map production efficiency and reduce employee workload- Developed batch files to accelerate setup of new units and manage user access on devicesNetwork Monitoring- Established mobile monitoring system of assets using VPN and SSH connections to access vitals

Waterloo, Ontario

Web Development- Utilized Ruby on Rails (as well as HTML and CSS) to develop a wire-frame for the official website - Tested a variety of gems to determine their viability regarding account registration and management

Stavanger Area, Norway