Skip to content

Projects

Things I've built

A selection of data engineering work across banking, finance and retail. Each project includes the problem, the approach and the results.

JPMorgan Chase · Data Owner · 2026

Alerts 2.0 Migration

Migrating the bank's alert preferences application from a legacy platform to Alerts 2.0, including a new database and an entirely new data pipeline.

  • Moved the application from a legacy database to CockroachDB
  • Built a new pipeline from CockroachDB to the AWS S3 data lake and on to Snowflake
  • Coordinated product, technology and data technology teams for a smooth cut-over
  • Involved in every stage of testing
  • CockroachDB
  • AWS S3
  • Snowflake
  • Python
  • Data Migration

Personal project · 2026

Play Chess

A free chess web app: play eight bots powered by Stockfish, review your games, solve puzzles, learn openings and follow live tournaments, all running in the browser.

  • Stockfish running in the browser as WebAssembly, with eight bots from ~400 to full strength
  • Move-by-move game review with accuracy, an evaluation graph and blunder detection
  • 10,000 puzzles and 3,865 openings built from the Lichess open databases
  • FIDE top-100 lists refreshed monthly by an automated data pipeline
  • Next.js
  • TypeScript
  • React
  • Stockfish
  • Vercel
  • Claude Code

JPMorgan Chase · Data Scientist · 2025

Customer Sub-Segmentation

Customer sub-segments for marketing and targeting, built with K-means clustering and supervised learning on secure, enriched datasets.

  • Built the input datasets for clustering with PySpark on AWS EMR
  • Created sub-segments using K-means, followed by supervised learning
  • Enriched customer data with bureau and credit history via Redshift
  • Worked on every step, from raw data to final segments
  • K-means
  • Supervised Learning
  • PySpark
  • AWS EMR
  • Snowflake

JPMorgan Chase · Senior Data Engineer · 2024

Digital Channel Submission Rate

Migrated legacy Hive workflows to an automated PySpark and Airflow pipeline powering Tableau dashboards on digital customer activity.

  • Cut processing time from 12 hours to under 2
  • Replaced manual Hive workflows with PySpark on Hadoop
  • Fully automated scheduling and orchestration with Airflow
  • Fed Snowflake and Tableau for near real-time digital metrics
  • PySpark
  • Hadoop
  • Airflow
  • Snowflake
  • Tableau

Tiger Analytics for Lands' End · Data Engineer · 2022

Dynamic Promo Application

Sell-through scoring pipelines that set SKU-level promotional discounts for Lands' End's e-commerce platform.

  • Calculated sell-through scores from inventory, demand and sales data
  • Applied business rules to set SKU-level discounts
  • Automated with AWS Glue triggers; served via RDS and Redis
  • Improved inventory turnover with targeted promotions
  • PySpark
  • AWS EMR
  • AWS Glue
  • Redis

Wells Fargo · Data Engineer · 2021

Capital Mortgage Operational Data Store

Consolidated mortgage data mart supporting FDIC regulatory reporting and fair value accounting.

  • Integrated Parquet, mainframe and Teradata sources into one data mart
  • Reported Qualified Financial Loans to the FDIC
  • Batch workflows that consistently met a 4:45 AM EST deadline
  • Built fair value accounting pipelines in Ab Initio
  • Ab Initio
  • Teradata
  • Hive
  • Regulatory Reporting