Adrián López Rendón · projects

Project shelf

Projects

40 words 1 min read

Data engineering pipelines, ML systems, and full-stack applications.

A collection of data engineering pipelines, machine learning systems, and full-stack applications I’ve built and documented.

Each project prioritizes production-grade engineering: reproducible environments, modular codebases, and real data problems. Work spans MLOps workflows, ELT pipelines, data warehousing, and full-stack automation.

Air Quality RAG Assistant

LLM-powered RAG assistant for querying Mexican air quality data via natural language, with hybrid vector + BM25 retrieval, Dagster-orchestrated embedding, and a Grafana-monitored FastAPI + Next.js stack, built as the capstone for the DataTalks LLM Zoomcamp 2026.

LLMRAGFastAPI

Air Quality Pipeline: dlt + dbt + Dagster

Rebuild of the Mexico air quality monitoring pipeline on a dlt + dbt + Dagster stack, with asset-based orchestration, dbt tests, and CI-published documentation, built as the capstone for the DataTalks Data Engineering Zoomcamp 2026.

Data EngineeringdbtDagster

Comprehensive Osteosynthesis Service Management Platform

Full-stack platform managing surgical event lifecycles and government invoicing for a Comprehensive Osteosynthesis Service contract across Mexican state healthcare agencies. In production across 15 hospitals, 10 users, 2 states.

Full-StackFastAPIAngular

Mexico Air Quality Monitoring Pipeline

Production-grade ELT pipeline centralizing air quality data from 300+ monitoring stations across 121 Mexican cities into a BigQuery analytical warehouse with a Looker Studio dashboard.

Data EngineeringBigQueryKafka

Airline Passenger Satisfaction ML

End-to-end MLOps pipeline predicting passenger satisfaction in real time using XGBoost, enabling airline operations teams to trigger proactive customer service interventions.

MLOpsPythonXGBoost

Accounts Payable Automation System

Full-stack AP automation pipeline for Mexican CFDI invoice processing, with structured extraction from XML/PDF/image files and a React frontend for invoice lifecycle management.

Full-StackFastAPIReact

NYC Taxi ELT Pipeline

ELT pipeline centralizing NYC taxi trip data from a paginated REST API into DuckDB, with interactive analytical reporting on fare patterns, tip behavior, and temporal demand.

Data EngineeringDuckDBdlt

Open Library DLT Pipeline

ELT pipeline centralizing bibliographic data from the Open Library public API into DuckDB, with an Ibis query layer and Altair visualizations in a Marimo interactive notebook.

Data EngineeringDuckDBdlt

Media Hit Prediction ML

End-to-end MLOps pipeline predicting whether a film will be a commercial and critical hit, enabling data-driven decisions on marketing budgets and production resource allocation.

MLOpsPythonBentoML