Lucas Sandhaus
Stittsville,ON
Summary
A professional with geographical experience & technical skills. I have 15 years of troubleshooting problems, delivering geospatial information to partners and clients, within the Federal Government and Hydro Ottawa Limited. I possess interpersonal skills, good judgment, strong tact, and sound initiative. I am able to combine knowledge and technical skills to solve real world problems as well as working well under short deadlines and stressful situations. Currently, I’ve gained over 10 years of work experience at Hydro Ottawa Limited obtaining electrical knowledge, drafting electrical construction drawings, maintaining engineering standards drawings, and updating electrical schematics diagrams. I have also obtained a considerable amount of field knowledge from various field visits across the distribution system.
Professional goals include continuing to grow in technical abilities, knowledge, and work experience within the electrical industry. I intend to supplement current electrical knowledge while working with engineers within the standards group, getting into the field as much as possible, as well as drafting design work.
Possesses of Government of Canada Security Clearance, Secret Level.
Overview
16
16
years of professional experience
Work History
CAD/GIS Technician
Hydro Ottawa Limited
07.2013 - Current
- Responsible for preparation and maintenance of clear, complete, and accurate new construction and record drawings utilizing CAD and GIS software
- Responsible for development and maintenance of GIS and OMS
- Accountabilities/Responsibilities (Drafting and Records)
- Prepare and revise electrical engineering drawings, as-built plant records in accordance with Hydro Ottawa drafting and engineering standards.
- Prepare construction drawings for new residential, commercial, overhead, and civil underground projects
- Develop and maintain schematic and operating record drawings for overhead and underground distribution systems
- Prepare and update distribution mapping system, standard drawings, facility station, and architectural drawings
- Update record databases
- Communicate with internal clients and external consultants, municipal agencies and other utilities
- Assisting with engineering field work and compiling data from Engineer staff, consultants, and internal archives
- Generate accurate proposal drawings, as-built drawings, and standards for planning or for permanent records.
- Cleans, prepare, and posts CAD file received from consultants into HOL GIS land base fabric
- Prepares City of Ottawa Central Registry information for insertion to HOL GIS land base fabric
- Process queued GIS tickets from Service Manager & Salesforce – relating to system isolations, service upgrades, etc.
- Maintains streetlight distribution system
- Participated in company-wide projects ranging from LED streetlight conversion to Long Term Load Transfer
- Accountabilities/Responsibilities (Geographic Information System/Outage Management System)
- Develop and maintain GIS and OMS and digital land base mapping
- Prepare thematic maps, input plant record data to GIS
- Participate in GIS data conversion programs as well as prepare GIS data for external export to consultants and municipal staff
Geomatics Technician
Government Of Canada
02.2008 - 07.2013
- Performed Geospatial analysis and runs Geo Portal (web application) system sanity tests and diagnostics
- Created cartographic requests for Infrastructure Canada, Minister’s office, and PM’s office; included preparing and creating additional maps from using data from government reports and project records
- Mapped and performed quality control of INFC projects using Geomatics technologies
- Searched for and obtained from federal partners and proponents the required project location documentation necessary to map INFC projects
- GIS experience pertaining to e-Spatial GIS: i-Smart. Used i-Smart in order to geo-reference thousands of INFC projects using points, lines, and polygons to generate maps, graphs and charts
- Knowledge of maintaining project geometries in i-Smart GIS spatial database generating maps, graphs and charts using digital mapping techniques, computer interactive graphics and CAD software
- Responsible for collecting and compiling data from various data sources in order for it to be implemented within Geo Portal. Data consisted of the following: Federal Lands, Canada Lands, various census boundary files, water survey data. Used GIS to conform and prepare data for implementation
- Data that was implemented into Geo Portal was on display for users (50+), and web portal being maintained on several servers by third party
- Each project was enterprise-wide deployment with 103 users and was contained on 3 application-based servers, and 3 database servers.
- Tasked with responsibility of collecting and geo-referencing cartographic data (site plans, planning map content, survey maps, aerial photos, survey notes, records.) from various municipalities and engineering firms in our aid our National Geo-referencing project
- Performed system testing on all four system environments (Production, UAT, Development, and SysTest), generating cartographic maps and charts using Geomatics digital mapping techniques with GIS software, (ArcGIS).
- Tasks included running systems diagnostic tests of our Geo Browser and our Geo Locator
- Created user documents/deployment guides pertaining to Change Requests on our system to CGI
- Used cartographic skills using Oracle Maps, Map Viewer, Map Builder, and ESRI products utilizing aerial photographs, planning map content, survey notes, records and reports
- Coordinated our Post QC process with our provincial partners; collected project information in order to geo-reference INFC projects
- Worked with a team at ViaSat in order to coordinate our overflow of geo-referencing and worked as a technician in order to create a standard of work
- Technical skills in our Geo Browser (web application) and our web editing software
- Each project was enterprise-wide deployment with 103 users and was contained on 3 application-based servers, and 3 database servers.
- Aided in construction of information database (My INFC Geoportal) containing over 15,000 project geometries
- Aided in editing/creating document user guides regarding operation of our Geo-referencing process and for our Geo-browser
- Handled a wide variety of mapping requests from various divisions inside Infrastructure Canada, Privy Council Office, and Minister’s Office in order to create and planning maps and their content for Labour Force Survey, federal share of infrastructure projects, and project count maps
- Designed, created, and presented thematic maps expressing labour force data, water and road infrastructure, and minor proximity requests of projects contained within a radius, federal electoral district, and/or census metropolitan areas
- Used various datasets from DMTI, Statistics Canada, Geo base, Ministry of Natural Resources, etc.
- Used various software such as ESRI ArcGIS, and web GIS software (Oracle Map Viewer, e Spatial i-Smart, and Map Server) in order to generate project thematic maps and related graph and charts for various departments within Infrastructure Canada
- Aided in general maintenance of our geo-database by modifying our project information
- Acted as demonstrator to various team members of how our geo-referencing process works
- Worked with SIMSI (Shared Information Management System for Infrastructure) analysts, Infrastructure Canada program analysts, regional partners, and contracted analysts in order to support mapping of Infrastructure Canada projects using our Geo Navigator towards Economic Action Plan. This included locating and creating site plans of projects in order to geo-reference (Documenting, Geocoding, Mapping, and Quality Control)
- Maintained infrastructure projects contained in Oracle Application Express
- Troubleshot such problems as locating infrastructure with limited resources (Legal Land Descriptions, simple addresses and pictures). Converted many different coordinate systems into appropriate formats using ESRI ArcGIS. Converted CSV formatted spreadsheets into ESRI ArcGIS shapefiles to disseminate data.
Education
Certificate of Technical Studies - Geographic Information Systems
Durham College
Oshawa, ON08.2007
Bachelor of Arts - Geography (Specialization in Geomatics)
University of Ottawa
Ottawa, ON06.2006
Skills
- Model Building
- Strategic Planning
- Geographic Plotting
- Verbal and Written Communication
- Project Management
- GIS Troubleshooting
- Vector Analysis
- Data Visualization
- GIS Software Proficiency
- GIS Analysis
- Georeferencing
Accomplishments
- OACETT. C.E.T. designation (Geomatics), 2019
- Technical Report was an implementation plan
mapping the 13kV system neutral within a GIS
- OACETT. C.Tech designation, 2018
- Honouree in the National Awards category of the 2009 Government Technology Exhibition and Conference Distinction Award Program for the MyINFC Geoportal/GeoBrowser, 2009
- Infrastructure Canada Innovation Award, Geo-Management System Pilot Project, 2009
Professional Development
Hydro Ottawa Limited
- First Aid Training. (2014, 2017, 2020, 2023)
- Project Management 101 (2018)
- Practical Time and Workload Management. (2019)
AESIR International Ltd. (AOTA compliant course), Ottawa, Ontario, 2014/2015
- AutoCAD 2014, Essentials course, July 2014
- AutoCAD 2016, Advanced course, November 2015
Technical Summary
Database Systems
- Oracle 10g/11g
- MS SQL Server
- Microsoft Access
- G/Technology (Hexagon)
- JD Edwards
- Salesforce
Applications (Software)
- Oracle Spatial (MapBuilder)
- MapServer (Open Tool)
- ArcExplorer
- ESRI (ArcVIew)
- AutoDesk (Auto CAD)
- Bentley MicroStation
- FME (Feature Manipulation Engine)
- Bluebeam Revu
Languages
English
Native or Bilingual
French
Limited Working
Affiliations
OACETT
Interest & Activities
- Hiking, Cycling, & Camping
- Sports (Soccer and Football)
- Renovation projects (bathrooms, basement, and landscaping)
- Wood working/Carpentry
- Vehicle repair/Maintenance & Motorcycle repair and restoration
Timeline
CAD/GIS Technician
Hydro Ottawa Limited
07.2013 - Current
Geomatics Technician
Government Of Canada
02.2008 - 07.2013
Certificate of Technical Studies - Geographic Information Systems
Durham College
Bachelor of Arts - Geography (Specialization in Geomatics)
University of Ottawa
Similar Profiles
Salma AliSalma Ali
Customer Support Specialist at Optima Communications International (HYDRO OTTAWA)Customer Support Specialist at Optima Communications International (HYDRO OTTAWA)
Dan LegaultDan Legault
Customer Experience & Process Improvement Analyst at Hydro OttawaCustomer Experience & Process Improvement Analyst at Hydro Ottawa
JOSEPH MUGLIAJOSEPH MUGLIA
Director at Hydro OttawaDirector at Hydro Ottawa
Jaydeep PrajapatiJaydeep Prajapati
Lead UAT Test Technician at Ford Motor CompanyLead UAT Test Technician at Ford Motor Company
Danten KochDanten Koch
Legal Assistant at Lister-Beaupré LawyersLegal Assistant at Lister-Beaupré Lawyers