Unified login across Klaviyo & external services (Klaviyo Community + Academy) with SAML 2.0, boosting registration by >35%.

Optimized MySQL query patterns by migrating reads to replicas, refactoring, and detecting anomalies, lowering data volume & CPU usage.

Created authentication layer for Klaviyo V3 developer-facing APIs, enabling secure access.

Coordinated & worked on Python 2/3 + Django 1/2 version upgrades for increased reliability.

Built ELT pipeline from data lake to Snowflake, enabling analytics & real-time bidding ML models.

Wrote Scala library for managing JDBC connections to Snowflake utilizing HikariCP, simplifying development.

Constructed dimensional models for UGC performance via incremental, batch ETL pipeline in Redshift, generating >250 million facts.

Created data marts (e.g cross-platform aggregates) in Redshift tracking >$1 billion of social advertising spend, served with Ruby on Rails.

Performed ad hoc tasks such as querying SQL data stores and reprocessing Kafka backups from an S3 data lake.