Gowsigan Sritharan

• Worked on several data and map related tasks including: • Performing monthly data tasks including fire data updates and One Call scripts via Python, ModelBuilder and ArcGIS Pro involving running the script, improved efficiency, troubleshooting errors and verifying data. • Developing maps for elections, environmental planning, and enforcement officers throughout the city for different purposes. • Develop various web GIS applications for clients including StoryMaps, Dashboards and Experience Builder. Along with troubleshooting any relevant issues including bugs, missing data/fields, etc. • Reproduced public GIS (GeoHub) maps related to transportation, zoning, environmental and infrastructure. • Made use of various spatial analysis tools to complete tasks including: • Using the Network Analyst tool via O-D cost matrix and route tool to determine driving distance between city facilities and certain addresses. • Employing the suitability modeler to determine optimal locations for building constructions, environmental areas, and agricultural projects. • Geocoding/reverse geocoding, producing heat maps and more for client requests. • Worked with the stormwater team to oversee regular updates including: • Producing subsidy and other reports for stakeholders to assess different properties • Performing annual updates of entire databases and using FME to develop a script for importing stormwater assets (drawings) from CAD data to a GIS format. • Managing various datasets and databases through regular/ad-hoc requests. Made use of ArcGIS Pro, Excel, and SQL. • Other tasks include: • Reproducing documentation, attend technical meetings, adhering to established standards and protocols and assist colleagues/clients with any tasks. • Use of communication skills along with being meticulous with problem solving, organizational and time/self management skills to effectively complete tasks/projects.

• With more detail on portfolio, providing expertise to effectively complete a variety of small to large sized GIS projects/tasks in different industries involving GIS development, data management and analysis and more in a timely manner.

• Conducted GIS database maintenance and management, analyzing and interpreting geospatial and CAD data, upgraded efficiency of numerous FME scripts, developed and tested new scripts for various projects. • Supporting the MultiViewer Team via conducting data QC for utility/energy clients, updating databases and creating/updating documentation for different procedures. Handled weekly processes including updating spatial datasets, running scripts, reviewing data and more. • Troubleshooting FME script issues, offered technical support, answered client support matters, trained current and new staff and more. Generated a series of cartographic web maps well before deadlines for Enbridge and Infrastructure Ontario. • Managed large Bell Canada geodatabase for QA/QC process using Oracle, SQL Server, PL involving running SQL queries, troubleshooting Oracle and SQL Server issues. • Developed and improved efficiency of 10 different FME scripts for a large data conversion project (CAD to GIS) with Metrolinx along with creating and designing numerous geodatabases and more. • Maintained and troubleshooted web applications (Dashboard and Web Viewer) and geodatabases for Ontario Energy Board as they provide regular updates to be made. Made use of ESRI products, Oracle, SQL Server, FME, Oracle, CAD software (AutoCAD, MicroStation and Bentley), MultiViewer and MS Office.

• Worked on a variety of projects/tasks including: • Conducted QA/QC of road sensor data, data analysis with spatial queries using SQL and Oracle, generated reports with MS Excel, troubleshooted and enhanced efficiency of SQL scripts and issues. Along with working with SQL scripts to manage database tables, views and procedures and for data cleaning and integration. • Producing geodatabases and road network datasets and maps using ArcGIS Products to support further analysis of pavement data. • Used FME to update and troubleshoot scripts, reproduce new scripts for various client requests, design and implement data transformation workflows and streamline processes using where scripts were developed to automate various database processes. • Made use of suitability modeler tool for site selection for areas of optimal road construction and development based on certain criteria. • Consistently met project deadlines through collaboration with stakeholders to address project status, data quality issues and technical challenges. Answered user support issues, developed documentation for various procedures, produced project reports to summarize analysis findings, distinguishing opportunities for process improvement, recommending changes to existing workflows, developed training programs and assist colleagues. Made use of SQL Server, Oracle, FME, ESRI products, PostgreSQL, Roadware Vision and MS Office.

• Successfully cleared observation data backlog through performing processing steps on aircraft/satellite observations using QGIS and Python scripts to georeferencing retrieval data, source rate calculation and preparing customer deliverable reports. Completed several side tasks/projects: • Completed backlog of concentration map requests in a timely manner by using QGIS and Python scripts to generate map reports for marketing clients • Tested new data analytics process where emission plume origin points are pinpointed using QGIS and Python scripts • Developed new versions of documentation for numerous post-processing procedures. • Made use of Python, QGIS, Linux, GIT Repositories, PostgreSQL and more.

• As part of a collaborative project with Fleming College and York Region, worked on identifying flood prone assets in York Region and effectually met objectives through the development of web GIS applications, automated spatial analysis workflows tools using Python and Model Builder, technical documentation, offered GIS development and programming support and more. Made use of ESRI products (ArcGIS Pro & Online, Model Builder, Dashboards, Geocortex, StoryMaps, etc.), Python and GitHub.

Courses: • Environmental Science Fundamentals • Water Resources Conservation & Management, Groundwater, Hydrology, Aquatic Systems & Watershed Planning • Soil Science, Conservation & Management • Environmental Chemistry, Toxicology and Organic Chemistry & Natural Chemicals in the Environment • Project Management, Terrestrial Ecology, Ecology & Climate Change Biology Capstone Project: Non-Agricultural Pest Pathways in Leamington, Ontario Greenhouses

Courses: • GIS Collaborative Project & Planning • Surveying & CAD Mapping • Geovisualization, Geodesy and Online Survey Camp • Web Design, Programming and Web GIS Development • GIS Database Principle, Development and Management • Python Problem Solving & Programming and Customizations of GIS Applications • Spatial Analysis I & II and Environmental Modeling • Remote Sensing & Advanced Remote Sensing Capstone Project: Identifying Flood Vulnerable Assets in York Region