Summary
Overview
Work History
Education
Skills
Hobbies
Timeline
Generic

Zach Gastineau

Summary

Data focused expert experienced in developing database applications, ETL, troubleshooting, and automating related processes. Possesses strong analytical and problem-solving abilities. Equally confident working independently and collaboratively with excellent communication skills.

Overview

22
22
years of professional experience

Work History

Developer, Engineer and Team Lead

HCA/Parallon
11.2001 - Current
  • Automation accomplishments: Transaction HOST upload, Alert Database, Webex integration, Real-time streaming (workflow) application syncing with Meditech, 271 Parser, Database CI/CD.
  • (PDU, PME and ePTAC) Major SSC workflow tools; lead or co-lead during significant management, developer and technical tool changes and turnover.
  • ("e" applications and passport) Designed all backend data components from integration to implementation.
  • (Dynamic File Import) Quick to market, ideal support tool for importing data.
  • Responsible for all databases development, (workflow) applications and processes for integration and implementations across Revenue Cycle Operations. *See attached powerpoint for further detail on project work.
  • (rcomTrans) Also know as the transaction database application. This application (active since 2004) consolidated and revolutionized (for SSC activities) loading PA transactions to HOST mainframe for nightly processing.
  • (DB2 Connect) Pioneered Parallon's approach to interacting with PA HOST data. Moved us away from file based ETL to a more direct approach in which we centralized use and education of group/stack PA data.


  • Automation Innovation: Database Devops process using redgate tools, teamcity, and github Actions.
  • Automation mindset: Proposed a data sharing and consuming idea using realtime streaming to address inefficiencies.












Education

Google Boost Training in Progress - Data Engineer

UI Path Certification (2020)

Bachelor of Science - Computer Science And Mathematics

Lipscomb University
Nashville, Tn
05.1988

Skills

  • RDMS Development Solutions and SQL: SQL Server, SSIS and Streamsets
  • Programming Languages: tSQL, Various Compiled languages and often used Scripting languages like Powershell
  • Comfortable with code review in various languages and methods (OOP etc)
  • Analytical Thinking and Problem-Solving
  • Strong Communication and Interpersonal Skills
  • SDLC and Continuous Integration Systems (early innovation and leadership)
  • Github Actions, TFS, Redgate SQL Tools

Hobbies

  • Photography - As the Father of 3 children and 7 grandchildren, I have had many opportunities to practice!
  • Astronomy
  • Amateur Radio (KC4WKX)
  • Wood Working

 

True Colours: Green / Gold

DISC: Creative

Timeline

Developer, Engineer and Team Lead

HCA/Parallon
11.2001 - Current

Google Boost Training in Progress - Data Engineer

UI Path Certification (2020)

Bachelor of Science - Computer Science And Mathematics

Lipscomb University
Zach Gastineau