GIS ANALYST Resume

SUMMARY

Team - oriented GIS Analyst with nearly 11 years of experience using ArcGIS and SQL Server software to update, QA, and create data for enterprise SDE(Spatial Database Engine) geodatabase, as well as creating and updating maps according to client requirements. Proficient in creating queries in SQL Server & ArcGIS. Adept in communicating with clients to ensure timely and accurate delivery of all data requests.

TECHNICAL SKILLS

ESRI ArcGIS Desktop (ArcMap 3.2-10.5) map creation working in relational databases
SQL Server 2008/12/14
Oracle SQL Developer
Geoprocessing/ Spatial ETL Tools (ModelBuilder & Command Line)
Microsoft Office (Word
Excel
PowerPoint
Access and Outlook)
Developing ETL solutions versioning
SMSS working knowledge of SSIS working knowledge of data warehouses
Visual Studio
Powershell geocoding
Business Analyst(GIS)
Network Analyst(GIS) basic Python basic AutoCAD
Personal geodatabase development/management

PROFESSIONAL EXPERIENCE

Confidential

GIS ANALYST

Responsibilities:

Performed quality assurance via ArcGIS, SQL Server, and Access; conducted follow-up investigations to determine reasons for identified errors and then made necessary corrections. (Composed a 55-page Standard Operating Procedure that compiled SQL & ArcGIS queries to search database for attribute errors, and then provided solutions for fixing them.)
Consistently updated Parcel layer/ table with most recent property data; created a model in Modelbuilder that compared client data to various sources of third party data in order to isolate parcel updates.
Wrote/ updated queries and implemented mass updates on database via SQL Server, SQL Developer, and Access.
Produced maps for client engineers that displayed areas where assets were effected or potentially effected by natural disasters/hazards; maintained a feature class/ table for all natural disasters/ hazards in California and Nevada.
Conducted field work collections of client structures utilizing company GPS (GeoLink).
Updated Municipal and Tax Rates Area boundaries using BOE documentation.
Researched and determined the best solution to attribute single condominium parcels with multiple APNs as an R&D activity.
Managed the handling of all invoicing; processed invoices and checks on behalf of the client, and delivered vendor checks.
Trained new employees on use of ArcGIS for various tasks; provided feedback and support.