Technical Projects

I’ve worked on a variety of projects that include geospatial mapping and data analysis, workflow automation with Python scripting, front-end web development, and database management. Below are a few samples of my technical work.
​
​Conservation analysis tool (current project)
Tools: ArcGIS Pro, Python (incl. pandas & numpy data analysis libraries)
​
​Updating a Python script that assesses environmental protection for marine ecoregions. Writing documentation and automating related workflows. ​Project scope includes:
  • Testing code functionality, improving script performance, and repairing issues.
  •  Identifying and addressing defunct script components while incorporating new functionality like logging and flexible configuration options.
  •  Producing user-friendly documentation to orient new users to the script.
  •  Writing a new Python automation script that converts a multi-step Excel-based workflow  to a data analysis script using the pandas library.
​Configuration Checklist API automations
Tools: Python (incl. Selenium WebDriver library), SQL, PHP

As part of my work as a Technical Analyst for a SaaS company, I wrote Python scripts that refreshed an internal configuration tracking tool with new configuration data pulled from client sites. These scripts automated manual data entry activities, reducing task time by 80%. 
  • Wrote SQL queries to access existing configuration data stored in the internal tracking tool database.
  • Used Python to pull new configuration data from client sites and compare this new data against the existing configuration data in the tracking tool. This work leveraged the Python Selenium WebDrive framework to access the client data contained within the sites.
  • Updated the tracking tool database with new client data from the websites using Python-directed API calls and PHP code.
Marine Ecosystem Reference Guide (MERG)
Tools: ArcGIS Online, Web AppBuilder, AWS, Google Analytics, HTML/CSS/JavaScript

Maintained the Marine Ecosystem Reference Guide, an ecological web mapping application.
  • Managed the application backend (Amazon Web Services), geospatial data, and Google analytics.
  • Advised on GIS tools and architectural options.
  • Wrote a user guide for the web map.
  • Developed a series of help pages for the web map (HTML/CSS).
Facilities data analysis & web applications
Tools: ArcGIS Online, ArcGIS REST API, ArcSDE, Python, SQL

While working as a GIS Technican within a university facilities department, I completed emergency mapping projects, managed building data, and produced web applications showing a variety of facilities assets.
  • Integrated room/key data (15K records) from a university lock shop with floor plans (31K rooms) to produce a unified dataset for key queries.
  • Used Python, JavaScript, the ArcGIS REST API, and ArcGIS Online to update and customize web applications displaying facilities features (parking, hydrants, transportation, and room/key data).
  • Completed field work in underground utility tunnels, updated data in the ArcSDE geodatabase system, and built emergency evacuation maps.
Leaflet web mapping workshop
Tools: Leaflet JavaScript mapping library

While serving as a group leader for the Calgary GoGeomatics professional group, I developed and led a workshop with Leaflet, an open-source JavaScript library for building interactive web maps. This workshop helped participants gain exposure to JavaScript and customize a choropleth map showing communities symbolized by population ranges.