data-mart

Canadian disaster machine learning analysis and predictive model

PoC for building unstructured note based data-mart

Logistic Data Warehouse & Data Mart: Efficient data storage and analytics solutions for logistics optimization.

Automated end-to-end ETL data pipeline orchestrating REST API ingestion, custom Pandas transformations, and secure loading into a PostgreSQL Data Mart via Apache Airflow and Docker.

Multi-touch marketing attribution with GA4, BigQuery and dbt on GCP. Web, app and email touchpoints, 4 attribution models, market views without PII. Built on the GA4 public sample and synthetic data.

Data Engineering project for building a multi-source DWH pipeline with Apache Airflow, PostgreSQL, REST APIs, MongoDB, and ETL/ELT processes. Includes STG, DDS, and CDM layers, data marts, incremental loading, and data quality processing.

Automated daily retail fuel telemetry ETL & Data Mart pipeline using Apache Airflow (PythonSensor, PostgresHook), SQL upserts, and PostgreSQL.

Data-driven analysis of the real estate market (Santiago, Dominican Republic) using web scraping, ETL pipelines, PostgreSQL and Tableau dashboards.

Pipeline de inteligencia regulatoria (SMV/SBS/BVL): Data Mart unificado + segmentacion comercial con K-Means

Automated end-to-end ETL data pipeline orchestrating REST API ingestion, custom Pandas transformations, and secure loading into a PostgreSQL Data Mart via Apache Airflow and Docker.

Multi-Layer Retail Data Warehouse (Staging -> Kimball Star Schema DWH -> Analytical Data Marts) supporting Full and Incremental loads via Apache Airflow, PostgreSQL FDW, and Metabase.

Three-layer ETL pipeline (staging, presentation, data mart) for the Olist Brazilian e-commerce dataset with Python and PostgreSQL.

Python script that collects data from GitLab using the GitLab API and stores it directly into a dimensional data model (facts and dimensions). The collected data includes issues, projects, users, milestones, and labels. Designed as part of an ETL pipeline feeding a data mart.

End-to-end earthquake data pipeline built with Apache Airflow, DuckDB, MinIO, PostgreSQL and Metabase. Ingests daily USGS data and builds analytical data marts.

Claims data mart and HEDIS style quality and cost measures on CMS DE-SynPUF synthetic Medicare claims, with PySpark/Delta and an independent DuckDB reconciliation

Analytical Data Warehouse — an end-to-end data engineering project that implements a data pipeline from S3 through Apache Airflow to Vertica DWH. The project includes staging, Data Vault 2.0-style data modeling, SQL transformations, and analytical queries for user group activity.

End-to-end data engineering project transforming Olist e-commerce data into a star schema data warehouse and interactive Streamlit dashboard for business insights.

Data Mart para análisis de rentabilidad de palta Hass (2016-2024) - Proyecto Inteligencia de Negocios

High-performance Analytics Engineering benchmark consolidating 5 fragmented BI visual queries into unified single-pass Redshift SQL datamarts. Reduces query latency by 60%-90% and saves >3.5h/day across 4 operational domains.