Tony Barreto

About

Product-focused full-stack builder who has shipped and operated multiple production apps from scratch, including an e-commerce bakery delivery scheduler (with concurrency controls and timezone handling) and a real-time passenger music-request system for Lyft rides that hit and resolved YouTube API rate-limit scaling issues via debouncing and caching. Strong in React+TypeScript and Node.js/TypeScript backends, with solid PostgreSQL/PostGIS data modeling and performance tuning.

Experience

Education

Key Strengths

• Shipped end-to-end customer-facing features (DB schema → backend validation → frontend UI) for e-commerce delivery scheduling
• Concurrency/overbooking prevention using optimistic locking with re-validation at checkout
• Strong product/UI engineering focus (80% app-layer) with polished UX patterns (skeleton loaders, disabled states, graceful empty/slow-network handling)
• Designed and optimized PostgreSQL/PostGIS models for ride-booking/dispatch (indexes for key query patterns, EXPLAIN ANALYZE, constraints, migrations, selective denormalization)
• Handled real production scaling incident: mitigated YouTube API rate limits via debouncing (~60% reduction) and caching (~70% additional reduction)
• Built real-time passenger-facing music request/voting/queue system used by 100+ passengers

Reference Highlights

• Diligent
• On-time delivery
• Consistently top-notch quality
• Strong understanding of technical problems/issues
• Excellent Python backend engineering
• Good understanding of algorithms and programming language
• Good React and UX knowledge
• Handled feedback well
• Excellent SQL and data modeling skills
• Invested time in query performance
• Good AWS/cloud knowledge
• Resolved on-call and production issues
• Responsible
• Strong ownership of product work