Summary
Overview
Work History
Education
Skills
Prior Experience
Timeline
Generic

Michael Reed

east northport

Summary

Versatile IT professional specializing in Snowflake SQL, AWS-integrated ETL pipelines, and enterprise data solutions. Skilled at optimizing workflows, troubleshooting complex data issues, and collaborating across teams to deliver scalable systems.

Overview

20
20
years of professional experience

Work History

Principal Developer

Zeta Global
01.2023 - Current
  • Developed and optimized Snowflake stored procedures and ETL workflows, tightly integrated with AWS (EC2-backed virtual warehouses, S3 data storage), orchestrated via Harmony and tracked through Git for full lifecycle management.
  • Orchestrated ETL pipelines using both Airflow and Harmony, leveraging the same PostgreSQL metadata tables with minor configuration differences.
  • Experienced with Airflow’s interface and debugging workflows, later transitioned to monitoring via Grafana and Kafka service alerts under Harmony.
  • Provided application-level troubleshooting and data support for client onboarding and processing.
  • Collaborated with internal support teams to resolve production issues in a timely manner.

Database Engineer

Zeta Global
01.2013 - 01.2023
  • Provided hands-on technical support and development for Oracle PL/SQL applications.
  • Collaborated with analysts to resolve client-reported data issues and technical problems.
  • Maintained system documentation and monitored batch job execution.
  • Diagnosed and resolved performance issues across databases.

Technical Consultant

AutoOne (OneBeacon) Insurance
01.2006 - 01.2012
  • Enhanced and maintained PL/SQL packages (including XMLDOM) for generating XML documents used by AIPSO and state DMV reporting.
  • Converted a business-critical batch scheduling system from Pro*C to Java and PL/SQL. Reduced runtime from 2 hours to ~30 minutes.
  • Developed and tested PL/SQL procedures, functions, and packages supporting the Renaissance policy and claims administration system.
  • Monitored nightly batch schedules, troubleshooting and resolving production issues.

Education

BA - Mathematics

Concordia College

AS - Computer Science

Nassau Community College

Skills

  • Snowflake SQL
  • Stored Procedures & Functions
  • AWS S3/EC2
  • Harmony & Airflow
  • Grafana & Kafka Monitoring
  • Oracle PL/SQL
  • Performance Tuning
  • ETL Orchestration
  • Postgres
  • Postman
  • Troubleshooting
  • Collaboration

Prior Experience

Interim Technology – Provided consulting support to financial clients, enhancing database systems and
reporting solutions  (COBOL, DB2, JCL).
Bank of New York – Developed and maintained financial reporting systems, ensuring accuracy and
regulatory compliance  (COBOL, DB2, JCL).
Avis Rent-a-Car – Built and supported mainframe-based rental systems (COBOL, DB2, JCL, IMS).

Timeline

Principal Developer

Zeta Global
01.2023 - Current

Database Engineer

Zeta Global
01.2013 - 01.2023

Technical Consultant

AutoOne (OneBeacon) Insurance
01.2006 - 01.2012

AS - Computer Science

Nassau Community College

BA - Mathematics

Concordia College