Afredo Aguilar Lopez
Contact Information
Alfredo Aguilar Lopez [email protected]
Professional Summary
Full-Stack Engineer with 5 years of experience in the full web development lifecycle, from conception to production deployment. Specialized in Next.js, FastAPI, and PostgreSQL, with deployments in Docker. Experienced in designing database schemas, APIs, and frontend, including deployment and on-call support responsibilities. Seeks environments with predictable infrastructure, strict typing, and agile PR workflows.
Core Competencies
Backend: API Design (REST, typed contracts), PostgreSQL Performance Tuning Frontend: React / Next.js Application Architecture DevOps: Docker, CI/CD in Small Teams Soft Skills: Code Review, Mentorship
Tech Stack
Languages: TypeScript, Python, SQL, Go Frontend: React 19, Next.js (App Router), Tailwind, React Query Backend: FastAPI, Node.js, SQLAlchemy, Prisma Databases: PostgreSQL, Redis, ClickHouse Infrastructure & DevOps: Docker Compose, GitHub Actions, Cloudflare, Hetzner VPS
Experience
Senior Full-Stack Engineer — Ruta Logistics Mar 2023 – Present · Remote
- Managed the shipping module, including dashboard (Next.js), service (FastAPI), and database (PostgreSQL).
- Reduced checkout abandonment by 18% by optimizing a blocking third-party call.
- Led the migration from REST callbacks to Server-Sent Events for real-time tracking.
Full-Stack Engineer — Paygrid (fintech) Jul 2021 – Feb 2023 · Guadalajara
- Developed the merchant onboarding flow, integrating KYC, Stripe Connect, and signed webhooks.
- Implemented Playwright and CI gates, reducing production regressions by approximately 3x.
- Participated in weekly on-call rotation, and documented incident runbooks that are still in use.
Junior Developer — Internal Tools Team, Grupo Lamar Aug 2020 – Jun 2021 · Puerto Vallarta
- Maintained an operations dashboard (Django + jQuery) used by ~200 hotel employees.
- Rewrote synchronous PDF report exports to an asynchronous job with Celery.
Key Achievements
- Reduced API p95 latency from 850 ms to 120 ms by optimizing N+1 queries with a CTE.
- Migrated a 40-million-row table to a new schema without downtime, using dual-write and backfill.
- Implemented on-call rotation and runbooks, reducing MTTR from ~45 min to under 10 min.
- Mentored two junior developers to autonomy in feature delivery.
Projects
Shiftly — open-source shift planner Personal project using Next.js, FastAPI, and PostgreSQL. Has over 600 stars on GitHub.
- Manage issues, releases, and project documentation.
- Link: github.com/alfredoal/shiftly
Talk at MexicoDev: "Postgres sin miedo" 45-minute technical presentation on PostgreSQL optimization.
- Covered indexing,
EXPLAIN ANALYZEusage, and materialized views. - Includes slides and additional resources.
sql-lint-action GitHub Action for static SQL analysis.
- Executes
sqlfluffon.sqlfiles modified in pull requests. - Accumulates approximately 1,000 weekly installs.
Certifications
- AWS Certified Developer – Associate · Amazon Web Services · 2024
- Google Cloud Associate Cloud Engineer · Google · 2022
Education
- Computer Engineering · University of Guadalajara · 2016 – 2020
- Full-Stack JavaScript Path · Platzi · 2020
Core Competencies
Backend: API Design (REST, typed contracts), PostgreSQL Performance Tuning Frontend: React / Next.js Application Architecture DevOps: Docker, CI/CD in Small Teams Soft Skills: Code Review, Mentorship
Tech Stack
Languages: TypeScript, Python, SQL, Go Frontend: React 19, Next.js (App Router), Tailwind, React Query Backend: FastAPI, Node.js, SQLAlchemy, Prisma Databases: PostgreSQL, Redis, ClickHouse Infrastructure & DevOps: Docker Compose, GitHub Actions, Cloudflare, Hetzner VPS
Experience
Senior Full-Stack Engineer — Ruta Logistics Mar 2023 – Present · Remote
- Managed the shipping module, including dashboard (Next.js), service (FastAPI), and database (PostgreSQL).
- Reduced checkout abandonment by 18% by optimizing a blocking third-party call.
- Led the migration from REST callbacks to Server-Sent Events for real-time tracking.
Full-Stack Engineer — Paygrid (fintech) Jul 2021 – Feb 2023 · Guadalajara
- Developed the merchant onboarding flow, integrating KYC, Stripe Connect, and signed webhooks.
- Implemented Playwright and CI gates, reducing production regressions by approximately 3x.
- Participated in weekly on-call rotation, and documented incident runbooks that are still in use.
Junior Developer — Internal Tools Team, Grupo Lamar Aug 2020 – Jun 2021 · Puerto Vallarta
- Maintained an operations dashboard (Django + jQuery) used by ~200 hotel employees.
- Rewrote synchronous PDF report exports to an asynchronous job with Celery.
Key Achievements
- Reduced API p95 latency from 850 ms to 120 ms by optimizing N+1 queries with a CTE.
- Migrated a 40-million-row table to a new schema without downtime, using dual-write and backfill.
- Implemented on-call rotation and runbooks, reducing MTTR from ~45 min to under 10 min.
- Mentored two junior developers to autonomy in feature delivery.
Projects
Shiftly — open-source shift planner Personal project using Next.js, FastAPI, and PostgreSQL. Has over 600 stars on GitHub.
- Manage issues, releases, and project documentation.
- Link: github.com/alfredoal/shiftly
Talk at MexicoDev: "Postgres sin miedo" 45-minute technical presentation on PostgreSQL optimization.
- Covered indexing,
EXPLAIN ANALYZEusage, and materialized views. - Includes slides and additional resources.
sql-lint-action GitHub Action for static SQL analysis.
- Executes
sqlfluffon.sqlfiles modified in pull requests. - Accumulates approximately 1,000 weekly installs.
Certifications
- AWS Certified Developer – Associate · Amazon Web Services · 2024
- Google Cloud Associate Cloud Engineer · Google · 2022
Education
- Computer Engineering · University of Guadalajara · 2016 – 2020
- Full-Stack JavaScript Path · Platzi · 2020