Aug 31, 2023

Thomas Gonzalez

  • Data Engineer
  • Miramar, FL, USA
Full time Information Technology Mission Work Nonprofit Research Software Development

Personal Summary

THOMAS GONZALEZ
Miramar, FL 33027 954.450.8821
https://www.linkedin.com/in/tom-gonzalez-56209b3 sirbard@gmail.com


Data Engineer and Data Architect

SUMMARY
● Over 20 years of Data Engineering and ETL experience
Azure Data Factory, Databricks, Informatica PowerCenter, Oracle PL/SQL, Java, Unix Shell scripts
● Cloud Development in Azure and Snowflake, Big Data
● Azure fundamentals certified
● Snowflake Stored Procedure Development
● Azure Data Factory: Pipelines, Dataflows, Datasets
● Databricks: Pyspark, Spark SQL, Delta Lake
● Synapse: Tables and Views
● Hadoop: Impala, Sqoop
● Database and Data Warehouse architecture and modeling
Dimensional Modeling, Star Schema, Fact tables, Type I and II Dimensions, Data Lakes. Data Analysis on complex data.
● Database experience with Snowflake, Oracle, SQL Server and other databases
DDL design, Sql, stored procedures, and functions. Query tuning for performance.
● Healthcare Data Experience
Over 8 years of Healthcare Data experience in a Hospital and Healthcare System setting. Have worked with Cerner and Epic EMRs.


EDUCATION


Bachelors of Science in Computer Science Graduated 1991
Florida International University


Microsoft Certified: Azure Fundamentals December 2020
Verification link: https://www.youracclaim.com/badges/59a2b8db-ec0d-4533-b383-203a441c60cb


PROFESSIONAL EXPERIENCE

Omnidata Analytics 2022 –present
Azure Data Engineer
● Data Engineer in an Azure environment using Azure Data Factory, Databricks, and Synapse
Develop code for clients in a Healthcare setting


Sentry Data Systems, Craneware 2022

ETL Engineer
● ETL/Data Engineer in a Singlestore, Informatica, Oracle environment.
Sentry software is a 340B patient program management software.


Providence Health 2020 –2022

Data Engineer

● Data Engineer in a Snowflake environment on Azure.
● Designed Data Mart to track nurse maintenance on central lines and other projects
● Snowsql, stored procedures, Python
● Control-M enterprise scheduler
● Experience with Epic Clarity data from Epic’s EMR


Nicklaus/Miami Children’s Health System 2014 – 2020

ETL Engineer and Architect
● Informatica ETL design and development in a Linux and Windows environments.
● Conducted Data Analysis on Patients, Hospital visits, Purchase Orders, GL, Survey and other data to
find patterns and root causes of possible data errors.
● Wrote complex SQL scripts in Oracle, Hadoop Impala, SQL Server for data analysis and development.
● Used Hadoop Hue, Impala, and Sqoop. Wrote shell scripts to automate sqoop jobs.
● Data Warehouse Design of Dimensions, Fact tables, and ODS objects.
● Integrated data from Cerner EMR, Peoplesoft and Lawson (HR, Accounting, PO), Press Ganey Survey,
EPSI Accounting, Cactus Physician and other data sources.


Royal Caribbean International 2011-2013

Data Warehouse Engineer
● Informatica ETL design and development with Oracle and Unix.
● Work primarily with a Marketing Data Mart as well as other data marts.
Carnival Cruise Lines 2010-2011
Senior Data Warehouse Analyst
● Informatica, Oracle, and Unix ETL Development and very large data warehouse.
● Data modeling using ERStudio


BankUnited 2002-2010

ETL Developer/Data Warehouse Architect


● ETL design and development with Informatica, Oracle, Unix, and Windows.
● Data Warehouse Design and Data Modeling
● Documentation in team Wiki for team members and users.
● Client server and web based applications in Java or C# .net.
● Informatica, Oracle DBA, Unix Administrator
Achievements/Projects:
● Designed and created 360 degree view of all customers from all bank systems.
● Developed address data hygiene system that utilized post office standards; used to integrate
households.
● Developed processes for data cleansing, data quality tracking and balancing checkpoints.
● Created interfaces from Data Warehouse to third party systems such as terrorists detection screening,
Anti-Money Laundering, and other vendor applications.
● Customer Risk Code: Calculated based on multiple different data elements, such as transactions
activity, customer residency status, account attributes, and others.
● Created process to consolidate bank check transactions from 80+ servers over enterprise network.
● Process to identity NRA (Non Resident Aliens) and NRA exceptions from unrelated account and
customer attributes.
● Created Microsoft SSAS OLAP cubes.


Visa International, Latin American Region 1998-2001

Systems Analyst/ETL Developer

● Data Warehouse ETL design and development in an Informix, Oracle, and Unix environment using
Java and SAS base.
● Development of Reporting OLAP tools: Oracle Financial Analyzer, Oracle Express, and Seagate Holos.
● Gather requirements
● Design database table structures in Informix and Oracle databases.
● Data steward role of interfacing with key users to maintain dimension attributes.
● Occasional DBA and Unix administrator.
● Development of web applications using Java Servlets and JSPs, and Perl.
Achievements/Projects
● Designed and developed process to load data that included data quality checks and exception reporting.
● Created process to integrate data from different Visa customer banks utilizing multiple branch
products, loaded into Data Warehouse, and interfaced to MicroStrategy BI tool.
● Created interface to G/L system.

Work Experience

Data Engineer
Sep 2022 - Present Omnidata

Omnidata Analytics 2022 –present


Azure Data Engineer

● Data Engineer in an Azure environment using Azure Data Factory, Databricks, and Synapse
Develop code for clients in a Healthcare setting

ETL Engineer
Feb 2022 - Sep 2022 Sentry Data Systems/Craneware

Sentry Data Systems, Craneware 2022

ETL Engineer


● ETL/Data Engineer in a Singlestore, Informatica, Oracle environment.
Sentry software is a 340B patient program management software.

Data Engineer
Feb 2020 - Feb 2022 Providence Health

Providence Health 2020 –2022

Data Engineer

● Data Engineer in a Snowflake environment on Azure.
● Designed Data Mart to track nurse maintenance on central lines and other projects
● Snowsql, stored procedures, Python
● Control-M enterprise scheduler
● Experience with Epic Clarity data from Epic’s EMR

ETL Engineer and Architect
Feb 2014 - Feb 2022 Nicklaus/Miami Children’s Health System

Nicklaus/Miami Children’s Health System 2014 – 2020

ETL Engineer and Architect


● Informatica ETL design and development in a Linux and Windows environments.
● Conducted Data Analysis on Patients, Hospital visits, Purchase Orders, GL, Survey and other data to
find patterns and root causes of possible data errors.
● Wrote complex SQL scripts in Oracle, Hadoop Impala, SQL Server for data analysis and development.
● Used Hadoop Hue, Impala, and Sqoop. Wrote shell scripts to automate sqoop jobs.
● Data Warehouse Design of Dimensions, Fact tables, and ODS objects.
● Integrated data from Cerner EMR, Peoplesoft and Lawson (HR, Accounting, PO), Press Ganey Survey,
EPSI Accounting, Cactus Physician and other data sources.

ETL Developer/Data Warehouse Architect
Jan 2002 - Dec 2010 BankUnited

BankUnited 2002-2010

ETL Developer/Data Warehouse Architect


● ETL design and development with Informatica, Oracle, Unix, and Windows.
● Data Warehouse Design and Data Modeling
● Documentation in team Wiki for team members and users.
● Client server and web based applications in Java or C# .net.
● Informatica, Oracle DBA, Unix Administrator
Achievements/Projects:
● Designed and created 360 degree view of all customers from all bank systems.
● Developed address data hygiene system that utilized post office standards; used to integrate
households.
● Developed processes for data cleansing, data quality tracking and balancing checkpoints.
● Created interfaces from Data Warehouse to third party systems such as terrorists detection screening,
Anti-Money Laundering, and other vendor applications.
● Customer Risk Code: Calculated based on multiple different data elements, such as transactions
activity, customer residency status, account attributes, and others.
● Created process to consolidate bank check transactions from 80+ servers over enterprise network.
● Process to identity NRA (Non Resident Aliens) and NRA exceptions from unrelated account and
customer attributes.
● Created Microsoft SSAS OLAP cubes.

Education

Bachelors of Science in Computer Science
May 1987 - May 1991 Florida International University