Matthew Rantala

Experienced GIS developer, building stand-alone and ArcGIS platform applications using .NET/ArcObjects and Python/ArcPy. Excels at working with users to understand their needs and then developing the best solution.

Author of popular GIS programming blog that is visited by thousands of visitors each month.
Technical Expertise
GIS Applications: ArcGIS for Desktop, ArcGIS for Server, ArcGIS Online
Programming Languages: .NET/ArcObjects, Python/ArcPy, JavaScript, HTML, CSS, Avenue, AML
GIS Databases: PostgreSQL, SQL Server, ArcSDE, MS Access
Professional Experience.
Geological Information Specialist2010 to present
Minnesota Geological SurveySt. Paul, MN
Design, build, and maintain enterprise GIS using ESRI’s suite of applications including ArcSDE for PostgreSQL, ArcSDE for Server, ArcGIS for Desktop and ArcGIS Online. Design enterprise geodatabases and custom data-entry applications and tools.
  • Built ArcSDE database server on Windows Server platform using PostgreSQL. Analyzed existing archival and active production data needs and designed a logical database structure.
  • Created Quaternary Data Index (QDI) geodatabase of unconsolidated deposits. Assembled and analyzed historic data, created a database structure, normalized and imported existing data. Wrote .NET/ArcObjects data-entry interface to support multi-user editing.
  • Designed and developed outcrop geodatabase. Defined subtypes and multiple coded-value domains. Compiled and standardized historic outcrop data and imported into new structure. Implemented editor tracking.
  • Updated Karst Feature Database to ArcSDE platform. Made easy-to-use .NET/ArcObject data entry forms. This upgrade has allowed off-site editors to triple the number of features int eh database since it has been deployed.
  • Scripting of many database management routines, including those to: verify validity and import data from other sources, batch import of GPS data into QDI, scheduled geodatabase compress functions, nightly replication of water well database hosted by another agency, and various quality control routines.
  • Scripted many of the production processes resulting in standardized products, increased productivity, improved data quality, and documented processes.
  • Deployment of ArcGIS server to publish feature services and presented in both ArcGIS Online and HTML/JavaScript maps. Continued management of this server.
Senior GIS Consultant2008 to 2010
GIS Programmer2002 to 2007
GIS Analyst2001 to 2002
Applied Data ConsultantsEau Claire, WI
Provided GIS solutions for both external and internal clients. Worked with clients to define needs and then design, develop, and maintain solutions. Worked both independently and as a team member on a variety of projects.
  • Lead developer on Automated Delivery, Zoning, Mapping, and Reporting (ADZMAR) application used by ADC staff to provide routing services to one of the nation's largest phonebook delivery companies. It has been used to delivery over a billion phonebooks since 2002.
  • Primary developer of Strategic Integrated Mapping and Modeling System (SIMMS) application used by major retailers to create sales forecasts, cannibalization estimates, and site packet materials for potential new sites.
  • Developed tools for in-house production including ArcMap tools for parcel mapping and annotation, street centerline conflation tools, and automated tools to download and process data before pushing it to online mapping applications.
  • Designed and developed outcrop geodatabase. Defined subtypes and multiple coded-value domains. Compiled and standardized historic outcrop data and imported into new structure. Implemented editor tracking.
  • Managed application development projects including development of effort-tracking application for the Wisconsin Office of Rural House that included map-based reporting functionality, development of an online version of SIMMS, and a pond-identification project for marketing purposes.
Project Manager1997 to 2001
GIS Technician1994 to 1995
GEOCODE Research, Inc.Eau Claire, WI
Managed data conversion project for Defense Mapping Agency (DMA) as a subcontractor through ESRI. Automated much of the production process to improve data accuracy and consistency, some of my code was adopted into ESRI's Production Line Tool Set (PLTS).
Land Information Specialist1995 to 1997
Pierce CountyEllsworth, WI
Developed county's GIS data. Oversaw contractor's production of parcel data, load data from third parties, and digitized data layers. Produce maps for Planning and Zoning Office. Provide GIS training to users.
Education
University of MinnesotaMinneapolis, MN
MGIS Candidate, 2014 to present
University of Wisconsin-Eau ClaireEau Claire, WI
BBA-Accounting, 1993
3.46 GPA, cum laude
Chippewa Valley Technical CollegeEau Claire, WI
Continuing Education Classes:
Coordinate Geometry
.Net Programming
Affliations
Minnesota GIS/LIS Consortium
Wisconsin Land Information Association
Society of Conservation GIS
Road Runner Clubs of America Certified Coach