Provided on-site GIS support for client: Northeast Ohio Regional Sewer District Watershed Programs department.
Addressed the client's need to identify previously un-billed waste-water recipients by building a geoprocessing model, using ModelBuilder and Python, and executing the subsequent analysis. Findings helped to locate and identify over 3,000 non-paying customers for a potential value of up to 1.5 million in previously uncaptured revenue.
Helped determine individual customer billing assessments by digitizing GIS layer of parcels' total Impervious Surface acreage.
Performed quality control and daily maintenance editing to stormwater billing database.
Processed daily customer billing inquiries and property transfers from customer service tracking log database.
Managed field collection data by preparing Trimble GPS units for field-data collection crews by loading necessary background map layers before collection, and performing retrieval/post processing of data after collection.
Confidential
GIS Database Analyst / Design Consultant
Responsible for updating the 'Roads' GIS layer on a weekly basis and subsequent distribution to the enterprise system/Oracle database.
Ensured prompt daily submission of database edits from field crew by monitoring the version log within the 4-tier ArcSDE system.
Provide project support for PSE G 'Solar-4-All' solar panel installation project, by running the day-to-day database management functions of the project database. This involved using SQL queries to track solar panels' location and status, as they were shipped, installed, and removed for repair or replacement. 140 million in company assets.
Download monthly asset installations from contracted installer and reconciled list Access queries and visual inspection of data tables . Compiled list of conflicting installation data, investigate with field technician and worked with contractor to resolve.
Responsible for reporting updated installations back to panel manufacturer and PSE G management.
Participate in field investigations to resolve mapping discrepancies.
Provide ad-hoc map generation and reporting of current installations locations and statuses for project management.
GIS Technician
Analyze Autodesk CAD sketches of proposed alterations to electric distribution system, and recreate corresponding changes within the electric distribution GIS database.
Consult with engineering technicians to resolve mapping conflicts.
Perform field investigations to resolve mapping conflicts.
Print and distribute updated versions of electric circuit maps to engineering and field-crew staff.
Producing GIS-related reporting for executive and project management.
Produce general-reference maps of Southern Division service area.
Confidential
Geospatial Technician
Primary geodatabase editor for geospatial-intelligence project.
Built feature databases by digitizing remotely-sensed satellite imagery, including 3D stereoscopic imagery.
Performed quality assurance on SQL batch-scripts used to test and flag errors on the feature databases.
Privacy Policy
