Professional GIS enthusiast with 15 years’ experience in map production, data management, and data analysis as an environmental consultant.
Adept in the Esri ecosystem including ArcMap, ArcGIS Server, ArcGIS Online, Portal for ArcGIS, and Collector for ArcGIS. Versed writing scripts with Python 2.x and many associated libraries. Practical working knowledge and experience with MS SQL Server, PostgreSQL/PostGIS, OGR/GDAL, Adobe Illustrator/Photoshop, MapBox, HTML, CSS, and JavaScript, and Java.
Developed websites and spatial web applications with JavaScript, Java, HTML, and CSS through graduate coursework.
Professional and graduate experience developing and administering PostgreSQL schemas, users, tables, and functions.
Versed in writing scripts with Python 2.x/3.x and many associated libraries.
Continuously striving to expand my technical capabilities to provide clients the best possible solutions.
Engaged in recognizing workflow and process improvements to promote task efficiency and eliminate sources of errors.
WORK EXPERIENCE
GIS Analyst at RETTEW Associates April 2014-Present
Collaboratively developed and support a custom QGIS plugin to meet internal client needs for custom map tools and functionality for fiber optic line routing. This plugin supports all interactions from importing collected field data, to project system design in QGIS, to exporting features for CAD drawing preparation centered around a PostGRES database.
Designed User Interface and handled all UX/UI interactions within plugin with PyQGIS and Qt Designer.
Develop custom map tools using python and PyQGIS (PyQt) for data creation, management, and export.
Write custom database functions for data validation, import, and export from PostGRES database with PL/pgSQL, python and psycopg2.
Prepare CAD plans for client deliverables.
Utilize Esri Deep Learning tools to help in the automation of digitizing building footprints.
Configure web maps, web applications (Web App Builder & Experience Builder), and dashboards for clients to use in ArcGIS Online, ArcGIS Survey123, and ArcGIS Field Maps.
Integrate Field Maps and Survey 123 to prepopulate Survey 123 forms.
Develop work order, maintenance and inspection tracking workflows pertinent to client requirements.
Support client reporting requirements to state agencies.
Develop custom scripts using Python, ArcPy, and other Python libraries as needed to automate workflows and time-consuming processes, including custom map exports, data acquisition, and administration.
Publish, administer, and manage web services and image services using ArcGIS Server and ArcGIS Online.
Support field crews by providing field maps, GPS data files, and assistance with GPS configuration and troubleshooting.
Postprocess incoming field data using Trimble Pathfinder Office, digitize features, and review with the field team for accuracy and completeness.
Create and maintain Esri file geodatabases for individual projects or Microsoft SQL Server databases utilizing ArcSDE for larger clients.
Adhere to client specific schemas and metadata standards.
Manage both client provided data and RETTEW created data.
Produce maps and figures in support of client deliverables including Wetland Memorandums, environmental and construction permits, Threatened and Endangered Species coordination, archaeology and historic resources, environmental site assessments (Phase I/II/III), site characterizations, remedial action plans, mitigation monitoring, and Spill Prevention, Control, and Countermeasure (SPCC) Plans.
Manipulate, scrub, project, and transform data as needed for proper import/usability using Python, Microsoft Excel, or ArcMap.
Coordinate with CAD designers on the correct import/export and usage of data across platforms to ensure consistency and accuracy.
Perform spatial analysis and interpolation of data for planning and decision making using the Esri suite of spatial analysis, data management, conversion, and 3D analysis tools.
Assist in the management and administration of Adobe Flex web mapping applications and associated client websites.
Establish and maintain map templates, layer symbologies, and mapping procedures for the GIS Department and specific client requirements.
Author quality assurance/ quality control procedures for preparation, review, and submittal of maps and data to clients.