Aleric Patterson

About

Backend/data engineer with hands-on production experience across Python/FastAPI services and AWS (Lambda, API Gateway, SQS, ECS) delivered via Terraform and GitHub Actions. Built Glue-to-Redshift ETL pipelines with Step Functions retry/catch patterns, schema evolution safeguards, and data quality checks; also modernized a legacy SAS monthly reporting system into Python microservices with rigorous side-by-side parity validation. Demonstrated strong SQL tuning skills with a reported improvement from 5 minutes to 15 seconds.

Experience

Education

Key Strengths

• Designed and maintained production Python APIs (FastAPI) with Postgres/Redis and JWT auth
• Reliability engineering: strict timeouts, retries (2–3 attempts), structured error handling, logging and alerting
• Delivered AWS serverless + container architecture (Lambda/API Gateway/SQS + ECS) with Terraform IaC and GitHub Actions CI/CD
• Secrets/config management using SSM Parameter Store and Secrets Manager (no hard-coded secrets)
• ETL ownership with AWS Glue + Step Functions retries (exponential backoff) and SNS notifications; handled schema evolution and data quality checks
• Modernized legacy SAS batch reporting into Python microservices with side-by-side parity validation and stakeholder sign-off
• SQL performance tuning with measured impact (5 min to 15 sec) via indexing and date partitioning
• Production incident response for data pipelines: CloudWatch detection, Glue log triage, mitigation via fallback schema, and prevention via validation/retries