data-modeling

Apache Ossie semantic model for the Chinook sample database — verified against the real DDL, not just schema-valid. Generated with ossie-domain-kit.

Full-stack data analytics platform built with Python, Streamlit, and MySQL, integrating 2M+ Chicago open-data records with relational database design, ETL pipelines, geospatial analytics, and interactive SQL-driven dashboards.

End-to-End Data Engineering and Business Intelligence Project using Brazilian E-Commerce Dataset, Python, MySQL, Power BI, ETL Pipelines, Data Modeling, SQL Analytics, and AWS Cloud Deployment.

Explore Linear Regression with Gradient Descent, Stochastic Gradient Descent, and Ridge Regression. Uncover algorithmic insights in data modeling. 📊🎶🚀

Star-schema dimensional model with a KPI mart, ready for Power BI / Tableau.

End-to-end ELT data pipeline for US flight performance analysis. Orchestrated with Apache Airflow, transformed with dbt, and containerized with Docker.

Dashboard interactivo en Power BI que analiza el rendimiento de los Juegos Olímpicos de París 2024, desde una visión global hasta el detalle por atleta.

Social Network Simulator is a layered, test-driven CLI + API project built in Python 3.12 to model a lightweight social networking platform. It supports user, status, and picture records, tag-based reconciliation, and exposes a RESTful API using Flask.

End-to-end ETL pipeline for research analytics data processing and emissions forecasting

Web app that matches university students with study partners based on personality, study style, academic focus, and schedule overlap. FastAPI, PostgreSQL, SQLAlchemy. UNCC Capstone.

DuckDB ELT + star schema for Olist e-commerce data, with CI tests and performance benchmark (indexes + EXPLAIN ANALYZE).

Visualize cross-system business-object relationships, identifiers, dependencies, and broken links from ordinary data exports.

Mitron Bank Credit Card Strategy — Tableau to Power BI migration, customer spend analytics, Star Schema modeling & commercial revenue strategy.

SQL Server star schema and Power BI report on synthetic data for a coach company

Scores a five-day forecast into a crop risk rating from deterministic per-crop thresholds. FastAPI, SQLAlchemy, React, Tailwind.

End to End data engineering project

Exploring Worldwide Shopping and Tourism Economy.

Video game library and discovery system built with Python, SQLite, SQL, and relational database design.

AWS Data Engineering portfolio: SQL, Python, Glue, S3, Redshift, dbt, Airflow, Terraform | Retail, Vending & Payment pipelines

Dimensional modeling of the Global Semiconductor Industry (2010–2026) dataset on a medallion architecture.