A selection of featured projects demonstrating experience in data engineering, data warehouse architecture, and Business Intelligence, built with different technologies depending on each project's needs.
Web system for managing a small business's inventory, orders, and catalog: a public catalog with search and filters, an admin panel for supply control, product recipes, and inventory auditable by stock movements
Scrapes remote data engineering job postings from We Work Remotely, analyzing which skills employers demand most, modeled in a classic star-schema data warehouse and enriched with AI
A denormalized analytical table built on Kaggle's "Craigslist Cars/Trucks Data" dataset (used cars listed on Craigslist), designed for an AI assistant to explore directly through natural-language chat. Note: Streamlit puts the app to sleep after 12h with no visits -- if it appears asleep, click "Yes, get this app back up!" to wake it (takes under a minute)
Real-time streaming of Mexico City's Ecobici bike-share availability via Kafka, visualized on a live map with stations colored by occupancy level
Medallion pipeline (bronze/silver/gold) over Mexico's public economic indicators (Banxico, INEGI), using MinIO, PySpark, and DuckDB as a local stack equivalent to S3/Glue/Athena, orchestrated with Airflow
Note: this file uses local connections -- reconnect them to your own copy of the repository when opening it in Tableau Desktop.
Modern warehouse on Databricks Free Edition with tested and documented dbt models, deployed through a continuous-integration pipeline in GitHub Actions, visualized in a self-hosted Metabase dashboard
Week-ahead forecasting of hourly yellow-taxi demand in New York: NYC TLC trip records and Open-Meteo weather loaded into MySQL, calendar/lag/weather feature engineering, and gradient boosting and Prophet backtested against a seasonal baseline, published as a notebook report that GitHub Actions rebuilds every week