Douglas Piper
Phone: 226-505-6022
Email: [email protected]
Location: Waterloo, ON

Highlights of Qualifications
Canadian Wildlife Service/Environment and Climate Change Canada – mapping shorebirds in James Bay
– Created maps to help staff analyse population trends across several shorebird species.
– Redesigned the existing database by introducing a normalised data structure, reducing file bloat by 90%.
– Introduced queries that significantly improved data entry and readability.

Canadian Centre for Inland Waters/Environment and Climate Change Canada – mapping waterbirds in Hamilton Harbour
– Designed a database, web map, and web application that allow researchers to analyse population trends of colonial waterbirds in Hamilton Harbour over a 70+ year period.
– Produced story maps that engage and educate the public on conservation efforts.

Education
GIS – Cartographic Specialist (post-graduate certificate)
Fleming College
September 2017 – June 2018
– Programming (Python, VB, SQL, HTML, JavaScript, CSS)
– Advanced Remote Sensing (Focus, Hypercube, LiDAR, aerial photography)
– Spatial Analysis and Environmental Modelling (ArcMap 10.5, ArcGIS Pro)
– Geovisualisation (Adobe Illustrator, MAPublisher, Adobe Photoshop, AutoCAD)
– GIS Database Principles (MS Access, SQL, VB)
– Surveying (total stations, GPS)
– Web GIS Development (ArcGIS Online, Mapbox, Geocortex Essentials, R/Shiny)

Social Service Worker (diploma)
Fleming College
January 2013 – June 2014

Experience
GIS Specialist (6-month contract), Canadian Wildlife Service/Environment and Climate Change Canada
November 2018 – May 2018 // North York, Ontario

– Redesigned the existing database and improved user experience and functionality. Newly implemented queries reduce data input time from days/weeks to hours. Introduced normalisation that reduced file size by 90% which significantly increased load and query speed.
– Produced dozens of maps for Environment Canada staff, including shorebird sector counts, Motus tower arrays to help visualise data, base maps for field crews, and site suitability rasters for determining optimal research site placements.
– Developed a web application using R and Shiny to engage the public on shorebird conservation efforts being undertaken across Ontario.

GIS Consultant (collaborative college project), Canadian Centre for Inland Waters/Environment and Climate Change Canada
January 2018 – June 2018 // Lindsay, Ontario

– Designed a normalised Access database to manage colonial water bird data, complete with forms to improve usability, reports for annual data reviews, and SQL queries for selective data viewing.
– Created web maps and applications that allow scientists to conduct spatial and statistical analysis of the data via heat maps, proportional dot mapping, and graphing/charting.
– Produced several story maps to educate the public on conservation efforts in the harbour, including a tour of all the monitored nesting sites, descriptions and common nesting sites of the monitored species (including photographs and bird calls), and links to official documentation regarding the Hamilton Harbour Remedial Action Plan.
– Developed a master web application that hosts all the previously mentioned content in one convenient, easy-to-navigate spot.

Program Coordinator (Job Café), The Working Centre
October 2015 – September 2017 // Kitchener, Ontario

– Redesigned and managed an agency-wide database for handling client information. Created forms and reports to improve usability, and cleaned up the database to improve normalisation.
– Collaborated with counsellors, job developers, outreach workers, and supportive housing staff to ensure clients had support in all aspects of their lives.
– Serving clients to assess their employment needs and connect them with employers. Clients included new Canadians and refugees, people with physical barriers, individuals with criminal records, and those with mental health disorders and/or addictions.
– Managed a moving service for low-income individuals. This involved meeting with customers, assessing their needs, matching them with suitable workers, resolving disputes, and negotiating payment solutions.

Intern, HopeSpring Cancer Support Centre
May 2014 – August 2014 // Kitchener, Ontario

– Database management (Sumac, Excel 2010) and IT support.

Skills
Tasks: Cartographic design, spatial analysis, database design, programming, web design, graphic design, remote sensing, environmental modeling, statistical analysis
Geospatial Software: ESRI software suite (ArcMap, ArcGIS Pro, ArcMap Online), AutoCAD, GeoCortex
Programming Languages: Python, SQL, HTML, JavaScript, R, Shiny
Remote Sensing Software: Focus, HyperCube
Databases: Microsoft Access, Sumac
Graphic Design: Adobe Illustrator, Adobe Photoshop
Misc. Software: Excel, Word, PowerPoint, Outlook
Platforms: Windows, macOS

Certifications and Licences
AutoCAD
Adobe Illustrator
Infographic Design
Ontario Class G License

Volunteer Experience
Administrative Assistant, HopeSpring Cancer Support Centre
August 2014 – January 2016 // Kitchener, Ontario

– Served as an agency representative at public events.
– Provided information to clients

Interests
– Comedy

– Karaoke

– Ghost stories

Education

September 2017 - June 2018

GIS Specialist - Cartographic (post-grad certificate) at Fleming College

January 2013 - June 2014

Social Service Worker (diploma) at Fleming College

Experience

November 2018 - May 2019

GIS Specialist at Environment and Climate Change Canada

– Redesigned the existing database and improved user experience and functionality. Newly implemented queries reduce data input time from days/weeks to hours. Introduced normalisation that reduced file size by 90% which significantly increased load and query speed.

– Produced dozens of maps for Environment Canada staff, including shorebird sector counts, Motus tower arrays to help visualise data, base maps for field crews, and site suitability rasters for determining optimal research site placements.

– Developed a web application using R and Shiny to engage the public on shorebird conservation efforts being undertaken across Ontario.

January 2018 - June 2018

GIS Consultant at Environment and Climate Change Canada

– Designed a normalised Access database to manage colonial water bird data, complete with forms to improve usability, reports for annual data reviews, and SQL queries for selective data viewing.

– Created web maps and applications that allow scientists to conduct spatial and statistical analysis of the data via heat maps, proportional dot mapping, and graphing/charting.

– Produced several story maps to educate the public on conservation efforts in the harbour, including a tour of all the monitored nesting sites, descriptions and common nesting sites of the monitored species (including photographs and bird calls), and links to official documentation regarding the Hamilton Harbour Remedial Action Plan.

– Developed a master web application that hosts all the previously mentioned content in one convenient, easy-to-navigate spot.

October 2015 - September 2018

Program Coordinator at The Working Centre

– Redesigned and managed an agency-wide database for handling client information. Created forms and reports to improve usability, and cleaned up the database to improve normalisation.

– Collaborated with counsellors, job developers, outreach workers, and supportive housing staff to ensure clients had support in all aspects of their lives.

– Serving clients to assess their employment needs and connect them with employers. Clients included new Canadians and refugees, people with physical barriers, individuals with criminal records, and those with mental health disorders and/or addictions.

– Managed a moving service for low-income individuals. This involved meeting with customers, assessing their needs, matching them with suitable workers, resolving disputes, and negotiating payment solutions.

  • Updated 4 months ago

To contact this candidate email [email protected]

Contact using webmail: Gmail / AOL / Yahoo / Outlook