Portfolio

Brian E. Ketchens

Business Intelligence

Business context grounded in operations. Modern data skills built to turn that context into insight. I connect the data to the business problems behind it.

LinkedIn GitHub Email

analytics projects shipped

2.9M

rows modeled across BigQuery & Snowflake

2,904

US counties analyzed end-to-end

Green Belt

Six Sigma DMAIC

Python · LightGBM · Streamlit

ERCOT Houston Grid Load Forecasting

Can grid demand be forecast from weather structure alone — no autoregressive crutch?

0.90R² on a weather-only champion model

LightGBMStreamlitTableau

Live app Tableau Source

Python · Embeddings · Streamlit

High-Probability Opportunity Radar

Does qualification fit actually predict interviews? An instrument built to measure the gap — with an honesty guardrail that refuses to coach embellishment.

Study livemeasurement running, findings pending — reported with sample size

Sentence-transformersLLMHonesty guardrail

Live app Source

R · Tableau · Cost modeling

Employee Retention — Where the Budget Goes

With a finite retention budget, who do you fund first?

$20.4Mannual turnover loss analyzed

RTableau

Dashboard Source

dbt · Snowflake · Dimensional modeling

Olist Star Schema — dbt + Snowflake

Can a warehouse model prove its own integrity, not just assert it?

28/28dbt tests passing — every fact row resolves to a real dimension

dbtSnowflakeStar schema

Source

Toolkit

Six Sigma DMAICSQL · PostgreSQL · Snowflake · BigQueryRPython Power BITableauStreamlitGitdbt

Contact

brian.ketchens@outlook.com Jackson, Michigan

All Projects →