# Gary Casey > Data Science & Engineering Location: New York City Metropolitan Area, United States Profile: https://flows.cv/garycasey Gary is a data engineer and data scientist specializing in ETL pipelines and integrations. ## Work Experience ### Software Engineer @ Byrne Software Technologies, Inc. Jan 2024 – Present | United States ### Data Engineer @ Enstoa Jan 2023 – Jan 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. ### Business Intelligence Developer @ Enstoa Jan 2022 – Jan 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. ### Data Engineer @ Aretove Technologies Jan 2022 – Jan 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 ### Master of Science - MS in Data Science The University of Texas at Austin ### Bachelor of Science - BS in Applied Mathematics Columbia University ### Bachelor of Arts - BA in Physics Austin College ## Contact & Social - LinkedIn: https://linkedin.com/in/garycasey42 --- Source: https://flows.cv/garycasey JSON Resume: https://flows.cv/garycasey/resume.json Last updated: 2026-04-01