×
Travis Dunbar

Travis Dunbar

Data Engineer

10251 Bleeker St, Woodbury, Minnesota, US, MN 55129
(651) 269-5198
English, Spanish, Latin

Background


About

About

Database design and ETL, Data Warehouse, Azure Data Engineer

Work Experience

Work Experience

  • Senior ETL System Developer, Compeer Financial

    Oct, 2022 - Present

    Legacy data warehouse and transition to Azure

    • Proof of concept implementation of Microsoft Azure Databricks, Synapse and Data Factory

    • Lease business intelligence reporting system in the legacy data warehouse

  • Senior Software Engineer/Architect/Developer, Illumifin (LTCG,Univita)

    Nov, 2012 - Aug, 20229 years 9 months

    Multiple roles and capacities for the major long-term care insurance services. Primarily engaged with entriprise reporting model (data warehouse) & back-office integration with carriers.

    • Extract, transform and load (ETL) data from transaction long-term care insurance system into enterprise reporting model using SSIS and Transact-SQL.

    • Building out Continuous Integration/Delivery on Azure DevOps for enterprise reporting model.

    • Implementing data warehouse constructs to support actuarial, operations and client/carrier needs.

    • Portfolio Architect role for 6 major insurance carriers.

  • Manager, Database Administrator, American Academy of Neurology

    Dec, 2001 - Nov, 201210 years 11 months

    Team lead & manager of database team to support association website database, fundraising, and analytic applications

    • Designed and built point of care tools for PalmOS/PocketPC applications for neurologists

    • Clinical Neuphysicology Section Liasion

Skills

Skills

  • Microsoft Azure

    Data Factory

    Databricks

    Synapse

    Fabric

  • Microsoft SQL Server

    SSIS

    SSRS

    SSDT

    SSMS

    Visual Studio

    Visual Sudio Code

  • Azure DevOps
  • Powershell
  • Linux
  • Bash
  • C#
  • VB.NET
  • Data Modeling
  • Python
  • Node.js
  • Git
  • YAML
  • T-SQL
Education

Education

  • Computer Science, Bachelor of Science, University of Phoenix

    Jan, 2004 - Jan, 2007

    3.2
  • Chemical Engineering, Bachelor of Science, University of Minnesota

    Jan, 1990 - Jan, 1993

    (incomplete)
Volunteer Work

Volunteer Work

  • Volunteer & Youth Coach, St. Croix Athletic Association

    Jan, 2010 - Jan, 2019

    Head Coach for Football, Baseball and Basketball Teams

    • Awarded 'Rookie Volunteer of the Year - 2010'

    • 2014/15/16 Football Champions

    • 2019-20 Basketball Champions (12-0, undefeated)

Interests

Interests

  • Reading / Writing

    BibleScience FictionHistorical (Non)FictionBig Book of AATao Te ChingLean/Agile DevelopmentSecond Brain
  • Motorcycles

    Harley-DavidsonRoad GlideHondaCB750BobbersTouring
  • Fishing

    WalleyeRedfishIce FishingSpin CastingLake of the WoodsGulf of Mexico
  • Gardening

    HerbsSpicesVegtables
  • 3d Printing

    bambu labsfreecad
References

References

  • Upon request