I’m always interested in finding new ways to apply and build upon my knowledge of enterprise GIS and public sector software implementation from more than two decades of experience in the field.
EXPERIENCE
Application and Database Support Manager
Springfield Water and Sewer Commission, Springfield, Massachusetts
March, 2017 – Present
Manage the Commission’s Applications Team of GIS and CMMS professionals. The team’s responsibilities include work order and records workflow management; GPS and drone data capture and processing; map revisions; enterprise GIS and database administration; and implementation of enterprise applications.
Founding Partner
OpenCheck, LLC
March 2014 – Present
Open Government For The People! We provide a simple and flexible open checkbook interface for public access to government financial records.
Applications Manager
Town of Amherst, Amherst, Massachusetts
August, 2016 – March, 2017
Design and manage the implementation of municipal software solutions. Responsible for selection and management of software applications to meet the individualized needs of departments. Maintain enterprise system data integrity.
GIS Administrator
Town of Amherst, Amherst, Massachusetts
September 2004 – March, 2017
Management & Implementation of an award-winning enterprise municipal GIS. Developer of online GIS resources at www.amherstma.gov/maps. Maintain, monitor, upgrade, and optimize all aspects of the organization’s GIS to ensure performance, security, scalability, and stability. Develop transparent, live connectivity between primary Town software package databases and GIS. Provide end-user assistance with software problems, software customization, and projects as needed. Coordinate with all municipal departments, IT staff, and vendors to solve problems.
Esri-Authorized ArcGIS Instructor
Freelance and at Applied Geographics, Inc
September 2002 – September 2010
“Introduction to ArcGIS I” instructor on-site at various locations from 2002-2010.
“ArcGIS Desktop II” instructor on-site at various locations from 2008-2010.
Senior Project Manager
Applied Geographics, Inc, Manchester, CT
January 2002 – September 2004
Responsible for the management of more than a dozen municipal GIS implementation, application development and data automation projects. Enterprise municipal GIS implementation & public safety GIS specialist. Business development associate and proposal / contract writer. Responsible for GIS instructional service offerings to clients. Mentor and supervisor to production staff. Data model developer and cartographic design specialist
GIS Coordinator
Town of West Springfield, West Springfield, Massacusetts
December 1998 – January 2002
Managed the multi-phased implementation of an enterprise GIS built on ArcInfo & ArcView GIS technology. Developed custom GIS-based applications for municipal departments. Provided technical support, assistance and technical instruction to staff. Coordinated QA/QC efforts for base and tax mapping projects. Designed and customized relational databases. Principal participant in municipal IT budgeting and planning. NT Administrator for a 60-client domain. Hired and supervised GIS technicians and interns.
GIS Coordinator
Central Massachusetts Regional Planning Commission, Worcester, Massachusetts
August 1996 – November 1998
Managed a forty community regional GIS, map and data automation program in a high-production project-oriented environment. Assisted constituent communities with GIS implementation plans. Administered and customized a GIS-based regional Development Suitability Model.
SKILLS
- ArcGIS Server Administration
- ArcSDE Versioned Enterprise Geodatabase Administration
- ArcGIS Online Implementation & Administration
- ArcGIS Desktop Power User
- MS SQL Server Database Administration
- MS SQL Server Analysis Services / Reporting Services
- C#.NET Application Development
- JavaScript Coding
- GPV Online GIS System Integration Implementation
- Windows Active Directory System Administration
- VMware vSphere & Fusion
- Vision Appraisal Technology Software
- Trimble sub-meter GPS & Trimble Pathfinder Office Support
- Cartegraph Asset & Work Order Management System
- AutoDesk Infrastructure Design Suite Deployment`
EDUCATION
Geography, Master of Arts
University of Connecticut, Storrs, CT
September 1994 – December 1996
Geography & Economics, Bachelor of Arts
University of Connecticut, Storrs, CT
September 1990 – May 1994
ACTIVITIES & AWARDS
- Certified Geographic Information Systems Professional (GISP) #16127, 2009-Present
- President, New England Chapter of the Urban and Regional Information Systems Association (NEURISA), 2012
- Esri Special Achievement in GIS Award recipient, 2008
- Northeast Arc User Group Conference Planning Committee, 2008
- Northeast Arc User Group Spring Conference Planning Committee, 2005-Present
- Founding Member, ValleyGIS Western Massachusetts Regional GIS User Group, 2000-Present
- Marathon Runner
PRESENTATIONS AND PUBLICATIONS
Taking Advantage of ArcGIS Online to Push a Mobile Agenda, Presented at the 2012 Northeast Arc User Conference, November, 2012
A Simple Approach to Mobile, Presented at the 2011 Spring Northeast Arc User Conference, May 2011
Why Not Let the Data do the Driving?, Presented at the 2010 Spring NEARC Conference, May, 2010
Amherst’s Mapping Initiative: 21st Century Basemapping…it’s a whole new ballgame!, Presented at the 2009 Northeast Arc User Conference, October, 2009
A Collaborative Approach to Designing Database Integrated Web GIS Interfaces, Presented at the 2008 Northeast Arc User Conference, October, 2008
Using Web-Based GIS to Create a more Participatory Planning Process, Presented at the 2007 Northeast Arc User Conference, November, 2007
General Purpose Viewer Using ArcIMS and SQL Server. Presented at the 2006 Spring Northeast Arc User Conference, April 2006.
Deploying GIS for the Small Enterprise. Presented at the ESRI Boston Open House Seminar, November 2005.
Tying It All Together: Municipal System Integration and Content Delivery Tips. Presented at the 2005 Northeast Arc User Conference, September 2005.
Transitioning to the Personal Geodatabase. Presented at the 2004 Northeast Arc User Conference, September 2004.
Parcel Geodatabases for Small to Mid-Sized Communities. Presented at the 2003 Northeast Arc User Conference, November 2003.
Automated Mapping for Local Public Safety & Emergency Dispatching.Presented at the 2003 ESRI International User Conference, July 2003 and at the 2003 URISA GIS in Addressing Conference, August 2003.
Automated Mapping for Fire & EMS Dispatch. Presented at the 2002 NEGIS Conference, May 16 2002 & the 2002 NEARC Conference, November 4 2002.
West Side’s Story: The Development and Implementation of Municipal GIS for West Springfield, Massachusetts. Presented at the 2000 ESRI International Users Conference and the 2000 NEARC Users Group Conference.
Meyer, J. W., Butterick, J., Olkin, M. and Zack, G. November 1999.
GIS in the K-12 Curriculum: A Cautionary Note. The Professional Geographer 51(4)
QA/QC & Municipal GIS Parcel Mapping. Presented for the Massachusetts Geographic Information Council on May 4th, 1999
The CMRPC Regional Development Suitability Model. Presented for the Massachusetts Geographic Information Council on May 5th, 1998.
Mike Olkin 