mapds
Contact Information
Alfredo Aguilar Lopez [email protected]
Professional Summary
Full-Stack Engineer with 5 years of experience, specialized in developing and deploying web products. Able to lead features end-to-end, from schema and API design to frontend, deployment, and on-call support. Recent experience with Next.js, FastAPI, and PostgreSQL on Docker in a VPS. Prioritizes robust infrastructure, strict typing, and agile review cycles.
Tech Stack
Core Competencies
Backend & API: API Design (REST, typed contracts), PostgreSQL Optimization, FastAPI, Node.js Frontend: React / Next.js Architecture, Tailwind, React Query DevOps & Infra: Docker, CI/CD (GitHub Actions), VPS Deployment Leadership & Quality: Code Review, Mentoring, Incident Management
Experience
Senior Full-Stack Engineer — Ruta Logistics
Mar 2023 – Present · Remote
- Led development and maintenance of the shipping module (Next.js, FastAPI, PostgreSQL).
- Reduced checkout abandonment by 18% by optimizing a blocking external call.
- Led migration from REST callbacks to Server-Sent Events for live tracking.
Full-Stack Engineer — Paygrid (Fintech)
Jul 2021 – Feb 2023 · Guadalajara
- Developed merchant onboarding flow, including KYC, Stripe Connect, and signed webhooks.
- Implemented Playwright and CI gates, reducing production regressions by ~3x.
- Participated in on-call rotations (1/4 weeks) and documented operational incident runbooks.
Junior Developer — Internal Tools Team, Grupo Lamar
Aug 2020 – Jun 2021 · Puerto Vallarta
- Maintained an operations dashboard (Django, jQuery) used by ~200 collaborators.
- Rewrote PDF report export from synchronous to an asynchronous job with Celery.
Key Achievements
- Reduced API p95 latency from 850 ms to 120 ms by optimizing N+1 queries with CTEs.
- Migrated a 40-million-row table to a new schema with zero downtime, using dual-write and backfill strategies.
- Designed and implemented on-call rotation and runbooks, decreasing MTTR from 45 min to under 10 min.
- Mentored two junior engineers, enabling them to deliver features autonomously.
Projects
Shiftly — Open-source Shift Planner
Side project Next.js + FastAPI + PostgreSQL with over 600 GitHub stars.
- Responsible for full project management: issues, releases, and documentation.
- github.com/alfredoal/shiftly
Talk at MexicoDev: "Postgres without fear"
45-minute presentation on PostgreSQL optimization.
- Covered topics like indexing, EXPLAIN ANALYZE, and materialized views.
- Slides available (URL not provided).
sql-lint-action
GitHub Action to integrate sqlfluff into CI/CD workflows.
- Runs automatic linting on modified SQL files in Pull Requests.
- Logs ~1,000 weekly installations.
Certifications
- AWS Certified Developer – Associate · Amazon Web Services · 2024
- Google Cloud Associate Cloud Engineer · Google · 2022
Education
- Computer Engineering · University of Guadalajara · 2016 – 2020
- Platzi — Full-Stack JavaScript Path · 2020
Core Competencies
Backend & API: API Design (REST, typed contracts), PostgreSQL Optimization, FastAPI, Node.js Frontend: React / Next.js Architecture, Tailwind, React Query DevOps & Infra: Docker, CI/CD (GitHub Actions), VPS Deployment Leadership & Quality: Code Review, Mentoring, Incident Management
Experience
Senior Full-Stack Engineer — Ruta Logistics
Mar 2023 – Present · Remote
- Led development and maintenance of the shipping module (Next.js, FastAPI, PostgreSQL).
- Reduced checkout abandonment by 18% by optimizing a blocking external call.
- Led migration from REST callbacks to Server-Sent Events for live tracking.
Full-Stack Engineer — Paygrid (Fintech)
Jul 2021 – Feb 2023 · Guadalajara
- Developed merchant onboarding flow, including KYC, Stripe Connect, and signed webhooks.
- Implemented Playwright and CI gates, reducing production regressions by ~3x.
- Participated in on-call rotations (1/4 weeks) and documented operational incident runbooks.
Junior Developer — Internal Tools Team, Grupo Lamar
Aug 2020 – Jun 2021 · Puerto Vallarta
- Maintained an operations dashboard (Django, jQuery) used by ~200 collaborators.
- Rewrote PDF report export from synchronous to an asynchronous job with Celery.
Key Achievements
- Reduced API p95 latency from 850 ms to 120 ms by optimizing N+1 queries with CTEs.
- Migrated a 40-million-row table to a new schema with zero downtime, using dual-write and backfill strategies.
- Designed and implemented on-call rotation and runbooks, decreasing MTTR from 45 min to under 10 min.
- Mentored two junior engineers, enabling them to deliver features autonomously.
Projects
Shiftly — Open-source Shift Planner
Side project Next.js + FastAPI + PostgreSQL with over 600 GitHub stars.
- Responsible for full project management: issues, releases, and documentation.
- github.com/alfredoal/shiftly
Talk at MexicoDev: "Postgres without fear"
45-minute presentation on PostgreSQL optimization.
- Covered topics like indexing, EXPLAIN ANALYZE, and materialized views.
- Slides available (URL not provided).
sql-lint-action
GitHub Action to integrate sqlfluff into CI/CD workflows.
- Runs automatic linting on modified SQL files in Pull Requests.
- Logs ~1,000 weekly installations.
Certifications
- AWS Certified Developer – Associate · Amazon Web Services · 2024
- Google Cloud Associate Cloud Engineer · Google · 2022
Education
- Computer Engineering · University of Guadalajara · 2016 – 2020
- Platzi — Full-Stack JavaScript Path · 2020