Scroll To View More
Ian Erickson, Geospatial Analytics Developer in Durango, CO, United States
Ian Erickson

Geospatial Analytics Developer in Durango, CO, United States

Member since September 24, 2018
For the better part of 20 years, Ian has been a software engineer working in a multitude of industries. He has a special penchant for all things geospatial and ETL, but has contributed to teams large and small doing just about everything. His most recent experience was with Tableau Software and Alteryx where he held principal-level roles and helped shape the product vision and implementation.
Ian is now available for hire

Portfolio

Experience

  • Geospatial Analytics, 20 years
  • Alteryx, 6 years
  • Java, 6 years
  • GDAL/OGR, 6 years
  • C#, 5 years
  • Python, 5 years
  • C++, 4 years
  • Tableau, 4 years
Durango, CO, United States

Availability

Part-time

Preferred Environment

MacOS, Windows, Ubuntu, VS 2013+, Git, JetBrains

The most amazing...

...project I've built and deployed, as a team of one, was a new map tile service for Tableau Software used by every desktop and cloud user in the world.

Employment

  • Principal Architect

    2017 - 2018
    Kespry
    • Deployed a number of internal and external APIs to support the distribution of company and client data and analytic information.
    • Managed, updated and debugged a distributed photogrammetry stitching pipeline.
    • Administered a number of AWS services including Batch, EC2, ECR/ECS, SWF, SQS, IAM, CloudWatch and CloudFormation.
    • Acted as the de-facto Agile coach and mentor for a small engineering team.
    • Acted as an architectural consultant for new service initiatives.
    Technologies: Ruby on Rails, Python, C++
  • Principal Software Engineer

    2013 - 2017
    Tableau Software
    • Built a new, from-scratch, map tile service to displace a costly and error-prone third-party service.
    • Generated a number of geospatial data ingestion tools for OpenStreetMap content.
    • Acted as an embedded architect and engineer on a newly formed Maps team.
    • Implemented support for geospatial data formats in Tableau Desktop and Tableau Server.
    • Worked on a next-generation geocoding solution for Tableau software that improved data compression rates over 80% and improved the accuracy and speed of matching of geocoding results.
    Technologies: Java, C++, Python
  • Chief Web Services Architect

    2008 - 2013
    Alteryx
    • Developed a replacement to the company's only SaaS offering at the time using C# and early JavaScript toolkits including Prototype.js and script.aculo.us.
    • Implemented the first version of AlterxWeb. A SaaS product exposing the features of the company's desktop product and putting them online using WCF, AWS, MongoDB, and a host of other technologies.
    • Wrote some of the early connectors to support Tableau Data Engine (TDE) sources in Alteryx Desktop.
    • Wrote, debugged and improved a number of Alteryx geospatial components.
    Technologies: C#, C++, JavaScript, Prototype.js, WCF, AWS, MongoDB, AlterxWeb, Tableau
  • President

    2000 - 2008
    AnalyGIS
    • Founded a geospatial consulting firm to support the training and development of geospatial technologies.
    • Wrote numerous geospatial web applications using commercial mapping services from ESRI and MapInfo in VBScript and C#.
    • Implemented a vehicle tracking portal using J2ME-enabled handsets and a web-based viewing application written in VBScript.
    • Authored proprietary ETL tools to support the retrieval and packaging of US Census data for sale written primarily in C#.
    • Wrote a US geocoding library for the .NET CLR using openly available data from the US Census and US Postal Service.
    Technologies: Java, C#, VBScript, MapInfo, MapBasic, MapXtreme, ESRI ArcView, ESRI ArcIMS
  • Target Marketing Specialist

    2000 - 2000
    Telocity
    • Was responsible for geographic analysis for the company's DSL marketing efforts.
    • Wrote a number of web portals to report on the effectiveness of the company's marketing initiatives using SQL Server, ASP, and VBScript.
    • Performed routine geospatial analysis to determine street-routed distance from customer residence to service central office to determine DSL qualification status.
    • Ran a number of geographic analytic reports to determine efficacy of target marketing efforts.
    Technologies: ASP, VBScript, MapXtreme, MapInfo
  • Software Developer

    1999 - 2000
    Empower Geographics
    • Acted a primary instructor for MapInfo Professional and conducted monthly 4-day training seminars.
    • Primary author of MapBasic extensions for MapInfo Professional covering a number of industry verticals.
    • Authored large format prints and cartographic presentations for company customers.
    • Performed consultative geospatial analysis functions for company customers using MapInfo, MapXtreme, MapBasic and custom software written in Delphi.
    Technologies: ASP, VBScript, MapXtreme, MapInfo, MapBasic
  • Translation & Fulfillment Specialist

    1996 - 1999
    BLR Data
    • Acted as the primary geospatial data translation expert within the company. I routinely translated a digital street network database into a variety of geospatial formats to meet customer requirements.
    • Managed a small team of shipping and fulfillment personnel.
    Technologies: MapBasic, ArcInfo, ESRI ArcView, Tactician, Autodesk

Experience

  • Tile Map Server (Development)

    Over the span of 9 months, I was the sole developer responsible for designing, implementing, testing and deploying a new tile map server responsible for map visualizations across the company’s entire product line. Written in Java and C++, and based on a number of OSS technologies, the new map server rendered billions of customized map image tiles supported by OpenStreetMap (OSM) vector content for the entire world. The map server supported multiple locales and languages as well as varying styles and geospatial layer combinations.

    The service was ultimately deployed to an AWS cluster across 4 different AWS regions, augmented by a custom-built cache mechanism and geographic DNS to support low-latency delivery to a worldwide customer base. Once deployed, the service provided clients with an experience that surpassed any performance and uptime metrics provided by the previous third-party vendor. In the space of three years of operation until my departure, the service had a 100% uptime record.

  • Laminar (Development)

    While at Kespry, I developed a prototypical workflow execution engine capable of performing a number of analytic and computational functions related to the company’s core domain of photogrammetry. Written primarily in C++, I leveraged a number of OSS libraries that included Boost, Qt, GDAL/OGR and multiple Structure from Motion (SfM) components to deliver 3D artifacts assembled from UAS imagery. The initial concept was to deliver a cross-platform (Linux/Mac OS/Windows) desktop solution with the ability to coordinate and manage remote workflows in AWS, Google Cloud, or Azure with a simple visual interface.

  • ETL/Analytic Web Service (Development)

    In my time at Alteryx, I built and deployed numerous web services responsible for running ETL and analytic workflows for cloud-based users. The infrastructure was written entirely in C# using WCF patterns to expose RESTful services for everything from authentication to workflow execution. Initially deployed on AWS infrastructure, the entire server platform was adapted to allow for installation in on-premise environments thereby opening a completely new revenue stream for the company.

Skills

  • Languages

    C#, Python, Java, C++
  • Libraries/APIs

    GEOS, GDAL/OGR, Flask-RESTful
  • Tools

    Geocoding, Tableau, MapInfo, Git, PyCharm, Visual Studio 2015, AWS Batch, AWS ECS, Perforce, Maven, Eclipse IDE, AWS CloudWatch, AWS CloudFormation, AWS IAM, Amazon SQS
  • Paradigms

    Spatial Databases
  • Platforms

    Alteryx, MapServer, Windows, MacOS, AWS Lambda, Docker, Ubuntu16.04, AWS EC2
  • Other

    Geospatial Analytics, Spatial Analysis, Geospatial Data, Mapping, Maps, Tableau Server, APIs
  • Storage

    AWS S3, AWS SWF
  • Frameworks

    Ruby on Rails 5, Boost, Flask
I really like this profile
Share it with others