• 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.

• 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.

• 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.