Yuanhui Yang

About

Backend/data engineer from ASML who modernized a legacy SAS-based statistical processing system into a cloud-native AWS platform (Lambda/FastAPI, Step Functions/EventBridge, Glue, S3/RDS) with strong reliability and data-quality practices. Demonstrated measurable performance wins (RDS query reduced from 90+ seconds to <5 seconds) and hands-on incident ownership for production ETL pipelines.

Experience

Education

Key Strengths

• Built and maintained production serverless, event-driven Python backends on AWS (Lambda, API Gateway, Step Functions, EventBridge)
• Modernized legacy SAS statistical workflows to cloud-native Python services with incremental migration and stakeholder sign-off
• Designed reliable APIs/pipelines with auth, retries (exponential backoff), timeouts, structured error handling, and CloudWatch-based observability
• Implemented data quality controls and schema evolution strategies (Glue crawlers/catalog, S3 versioning/partitioning, RDS migrations)
• Delivered robust CI/CD with automated tests, linting/static analysis, staged releases, blue/green and rolling deployments, and rollback readiness
• Optimized production SQL workloads (indexes/partitioning/query rewrites/batching) reducing a 90+ second query to under 5 seconds
• Owned production data-pipeline incidents end-to-end: detection via alarms, log/metric triage, mitigation via quarantine/manual processing, and prevention via monitoring/runbooks