# Dylan McFarlin

> Software Engineer at Aquent Studios

Location: Stockton, California, United States
Profile: https://flows.cv/dylanmcfarlin

Full-stack engineer specializing in cloud-native architectures and platform modernization. I design scalable APIs, build event-driven systems, and lead database migrations—currently supporting John Deere's Construction, Forestry, and Ag & Turf divisions.



My focus areas: Node.js/TypeScript backends, AWS serverless (Lambda, SQS, RDS), PostgreSQL optimization, and infrastructure as code with Terraform. I'm passionate about improving developer experience, establishing testing standards, and mentoring teams on production-ready practices.

## Work Experience
### Software Engineer @ Aquent Studios
Jan 2022 – Present
• Designed contract lifecycle API with 50+ RESTful endpoints handling 50K+ requests/day, implementing validation schemas, error handling middleware, and standardized response patterns across 3 business divisions
• Architected multi-Lambda event pipeline with AWS SQS for bi-directional sync between legacy DB2 and PostgreSQL, processing 2K+ messages/day with automated billing workflows
• Led Aurora PostgreSQL v13→v16 migration via blue-green deployment with 30-second downtime, saving $10.5K/year while mentoring team on zero-downtime database strategies
• Diagnosed production connection leaks via pg_stat_activity and implemented RDS Proxy pooling, reducing active connections 84% (350+ to 31) and saving $2.9K/year
• Led platform modernization from legacy Java/DB2 to Node.js, TypeScript, and PostgreSQL, serving 5K+ dealers processing 15K+ transactions/month across Construction, Forestry, and Ag & Turf
• Implemented Redis caching for high-frequency queries and singleton Databricks/EDL client pattern, eliminating per-query connection overhead across 16 service integrations
• Owned cloud infrastructure using Terraform IaC (RDS, Lambda, SQS, Secrets Manager) and CI/CD with GitHub Actions, enabling daily deployments vs. previous bi-weekly releases
• Implemented feature flag system enabling gradual rollouts, environment-specific configs, and instant rollback capabilities, reducing deployment risk across production releases
• Achieved 90%+ test coverage with Jest and Puppeteer E2E automation, reducing production incidents and establishing backend testing standards adopted team-wide
• Built Dead Letter Queue monitoring with automated Teams alerting, improving incident response time across all async message workflows
• Overtime: Architected enterprise AI chat platform with real-time LLM streaming via SSE, achieving sub-200ms time-to-first-token with InfluxDB metrics for cost analytics

### Software Engineer @ The Engineered Innovation Group, LLC
Jan 2022 – Jan 2022
• Collaborated on 3-engineer team through full SDLC—contributing to technical architecture decisions, conducting code reviews, and coordinating sprint planning—delivering 100% of milestones on schedule
• Built React CRM dashboard for cryptocurrency trading platform, featuring real-time portfolio tracking,
transaction history with infinite scroll, and responsive data visualizations using Chart.js
• Architected data migration pipeline from Neo4j graph database to PostgreSQL with custom ETL scripts, enabling unified reporting and reducing complex query times by 40%
• Designed and implemented RESTful microservices with comprehensive input validation, error handling middleware, and OpenAPI documentation, improving API reliability and developer onboarding
• Built CI/CD pipelines with GitHub Actions featuring automated testing, linting, and staged deployments, reducing release cycle time by 30% and deployment failures by 50%


## Education
### Certificate in Computer Software Engineering
CodeStack Academy


## Contact & Social
- LinkedIn: https://linkedin.com/in/dylanmcfarlin

---
Source: https://flows.cv/dylanmcfarlin
JSON Resume: https://flows.cv/dylanmcfarlin/resume.json
Last updated: 2026-04-11