DATA ENGINEERING & BI

Data Engineering & Analytics

Automated SQL & Python data pipelines, relational Star Schema modeling, and interactive Power BI executive dashboards driving profitability and operational intelligence.

SQL ETL & DATA WAREHOUSING

Complex PostgreSQL & Snowflake transformations using Window functions (`ROW_NUMBER`), CTE aggregations, and Star Schema dimensional modeling.

EXECUTIVE BI DASHBOARDING

Power BI & Tableau visual dashboards featuring interactive DAX measures, target variance tracking, and margin leak detection.

MACHINE LEARNING & PYSPARK

Apache Spark (PySpark MLlib) K-Means clustering in Google Colab evaluating multi-season player performance and fantasy tier centroids.

MACHINE LEARNING CASE STUDY

UNSUPERVISED MACHINE LEARNING (K-MEANS & PCA)

NFL Player Archetype Cluster Explorer

Interactive visualization of PCA Principal Components (Usage/Production vs Speed/Efficiency) mapping NFL player archetypes.

Silhouette Score:0.72 (k=4)

Y-AXIS: SPEED & EFFICIENCY SCOREX-AXIS: USAGE & PRODUCTION SCORE

Deep Threat Speedsters

High ADOT (>12 yds), top sprint speeds (>21 mph), high separation.

YAC & Possession Specialists

High Yards After Catch, short-to-intermediate routes, high target share.

Dual-Threat Hybrid Backs

Combined rushing & receiving usage, high missed tackle forced rate.

Red-Zone Anchors & TEs

High contested catch rate, red-zone target concentration, high physical impact.

EXECUTIVE REVENUE BI SANDBOX

INTERACTIVE EXECUTIVE DATA SANDBOX

Revenue & Churn Intelligence Engine

Test custom filters to view dynamic metrics visualization and auto-generated SQL analytics queries.

METRIC: revenueSEGMENT: All

DYNAMIC SQL QUERY

PostgreSQL

SELECT 
  DATE_TRUNC('month', order_date) AS month,
  SUM(sales_amount) AS total_revenue
FROM fact_sales f
JOIN dim_customer c ON f.customer_id = c.customer_id
WHERE c.customer_segment = 'All'
  AND f.order_date >= '2026-01-01'
GROUP BY 1
ORDER BY 1 ASC;

Query Latency: 14ms250k Fact Records

ANALYTICS CASE STUDIES

01Data & Analytics

Northstar Commerce Executive BI Dashboard & Data Pipeline

PostgreSQL Data Pipeline, Star Schema Dimensional Modeling & Power BI

Engineered an end-to-end PostgreSQL data analytics pipeline and interactive Power BI Executive Command Center to diagnose margin decay ($5.94M revenue, $2.29M profit) across 63k+ order transactions.

TECHNOLOGY STACK

PostgreSQL · SQL · Power BI · DAX · Data Modeling · Star Schema · ETL Pipelines · Data Quality Audit

VISUAL ANALYSIS PREVIEWZOOM IN

Northstar Commerce Executive BI Dashboard Overview

POWER BI EXECUTIVE COMMAND CENTER$5.94M NET REVENUE

Net Revenue$5.94M

Gross Profit Margin38.6%

Order Items Analyzed63,635

GITHUB REPOSITORY ↗

02Data & Analytics

NFL Player Clustering & Fantasy Tier Analytics

K-Means Machine Learning & VOR Modeling | Python & Scikit-Learn

Unsupervised machine learning pipeline that clusters NFL players into actionable fantasy performance tiers using custom PPR+IDP scoring, Value Over Replacement (VOR), and K-Means with triple-metric validation.

TECHNOLOGY STACK

Python · Scikit-Learn · K-Means · Pandas · Value Over Replacement (VOR) · Matplotlib · Seaborn · CLI Pipeline

VISUAL ANALYSIS PREVIEWZOOM IN

NFL Player Fantasy Tiers K-Means Clustering

K-MEANS VOR TIERS (k=4)SCIKIT-LEARN PIPELINE

Validation MethodsElbow, Silhouette, Gap

Clustering ModelK-Means (k=4)

Core MetricVOR (Value Over Replacement)

GITHUB REPOSITORY ↗

03Data & Analytics

TFT Analytics & Snowflake Data Warehouse

SQL Dimensional Data Modeling & Snowflake Cloud Warehousing

Engineered a Snowflake cloud data warehouse and analytical SQL pipeline analyzing Teamfight Tactics (TFT) player performance, team composition synergies, and win-rate trends.

TECHNOLOGY STACK

Snowflake · SQL · Python · Data Warehousing · Dimensional Modeling · ETL Pipelines

VISUAL ANALYSIS PREVIEWZOOM IN

TFT POWER BI DASHBOARDSNOWFLAKE DATA PIPELINE

Data WarehouseSnowflake Cloud

Schema ModelStar Schema (Fact/Dim)

Query OptimizationCustom CTEs

GITHUB REPOSITORY ↗