Gary is a data engineer and data scientist specializing in ETL pipelines and integrations.

Experience

2024 — NowByrne Software Technologies, Inc.Software Engineer

2024 — Now

United States

2023 — 2024EnstoaData Engineer

2023 — 2024

New York, New York, United States

Scripted transformation logic in Python for Oracle Primavera Unifier integrations at Meta.

Exercised Git version control on a DevOps team.

Monitored output logs for pipeline failures and published diffs.

Authored the as-built documentation of twelve full-stack ETL pipelines.

Transformed API responses into a DataFrame and then nested JSON objects for REST API client call.

Prepared design documents and SIT (system integration testing) scripts.

Managed a database of around 100 integrated tables and views in Oracle SQL.

2022 — 2023EnstoaBusiness Intelligence Developer

2022 — 2023

New York, New York, United States

Designed, developed, and tested ETL pipeline integrations between Smartsheet and Yale New Haven Health's backend tables, utilizing the REST API, stored procedures, and pivot queries.

2022 — 2022Aretove TechnologiesData Engineer

2022 — 2022

New York, New York, United States

Investigated TommyJohn’s open orders in a PostgreSQL database with DBeaver.

Managed the migration of Dell Boomi integrations from BigCommece to Shopify e-commerce platform on Jira.

Identified pipeline failures due to delimiting commas, two-letter state abbreviations, and out-of-stock merchandise.

Performed data cleaning of around 500 daily line items in production environment.

Architected the warehouse fulfillment center, e-commerce, and NetSuite ERP flat-file integrations running Ruby on Rails scripts.

Education

2024

The University of Texas at Austin

Master of Science - MS

2024

2021

Columbia University

Bachelor of Science - BS

2021

Austin College

Bachelor of Arts - BA

2021