– It All Starts Here


Tad Hammer

Denver, CO, USA

Data Administrator
Midpeninsula Regional Open Space District - Los Altos, CA
May 2016 to Present

Built, maintained and administered Enterprise GIS Arc Servers and their associated MS SQL Server geodatabases for Development, Test and Production environments.

Administration includes installation and maintenance—nightly as well as upgrades and patch installation of ArcGIS Servers as well as internal ArcGIS Portal and Web Server and SQL Server patches and upgrades.

Assisted in development of initial geodatabase data modeling as well as perform periodic geodatabase schema change tracking and updates.

Implemented Cityworks Work Order Asset Management System that interfaces with the Enterprise GIS developed Asset Feature Classes.

Built and administered MS SQL Servers for Cityworks on Nutanix based virtual servers using Vsphere server management software as well as SQL Server Management Studio.

Developed automating Python scripts to assign Asset IDs linking Cityworks to Enterprise GIS alleviating the manual assignment and/or use of the relatively manual “Attribute Assistant” toolbar tool. The scripts utilized the Attribute Assistant tables thus allowing for use of either the tool or script to make Asset ID assignments flexible.

Developed various Python “Calculate Field” code blocks for data translation of District municipality zoning codes to common internal zones to allow for repeatability and ensured data quality.

Created maps utilizing geospatial processing and analysis tools and cartography skills for internal GIS requests to create both paper maps as well as map publishing to map and feature services to ArcGIS Portal.

Performed field data collection with ArcGIS Collector App.

Developed VBA (in MS Excel) code modules and SQL Server stored procedures for ERP and Grants System data integration.

Led team of SMEs to develop District’s initial O365 SharePoint Intranet/Web Portal as well as a Sharepoint based Project Tracking solution.

GIS Data Analyst
U.S. Forest Service Pacific Southwest Region via Mason, Bruce and Girard – work location: Vallejo, CA
June 2015 to May 2016

Programmed Oracle and Access SQL inside the U.S. Forest Service ArcMap wrapper tool (Geospatial Interface) linking tabular and spatial data for mapping and report generation.
Repaired and Administered BMPEP Water rights MS Access database.

Performed data clean-up to prepare BMPEP database for migration from MS Access to Oracle.

Created change proposal maps to illustrate data inaccuracies in support of improved data stewardship.

Developed NEPA project tool for Forest wide rudimentary NEPA project data gathering.

GIS Technician
Apple Computer via Apex Systems - Cupertino, CA
April 2015 to May 2015

Performed GIS "places" heads up digitization

GIS map system testing

GIS Intern Planning, Zoning and Economic Development
City of Kennesaw - Kennesaw, GA
January 2014 to June 2014

Migrated Arc Server for Workgroup Standard along with ArcSDE with associated raster files, feature classes, attribute data, and models to upgraded hardware.

Created dynamic, multi-module Python annotation scripts to change text to proper/title case for citywide street names.
Performed Public Works feature class and city signage analysis that was used as work input for a data clean-up effort.

Used orthophotography along with existing ArcGIS maps, and Excel spreadsheets, assimilated data attributes for parks and points of interest into a common set of feature classes to be used for future, online city recreation maps.

Published maps to Arc Server which were utilized by the Spillman emergency response system.

Migrated test city maps from the historically used Application Development Framework (ADF) to ArcGIS Online.

Implementation Data Analyst
MedAssets, Inc – Alpharetta, GA
January 2011 to May 2013

Performed data analysis on client data to develop ETL processes into a MS SQL Server database for Charge Description Master Client implementation.

Created dynamic SQL from static T-SQL scripts in order to automate data quality control process ensuring accuracy and consistency of client data load which improved static "cut and paste" scripts.

Upgraded Access database design for Revenue cycle management analysis reporting application to match updated specifications in order to improve data accuracy.


Bachelors of Science in Geographic Information Science - Urban Systems
Kennesaw State University - Kennesaw, GA

Bachelors of Science in Business Administration - Information Systems
University of Colorado at Colorado Springs - Colorado Springs, CO

Tad Hammer

You must be a registered/logged in employer to contact job seekers.