Projects

Automated Systems

Python · SQL · FinBERT

Bot Bought – Automated Paper-Trading System

Tested whether a dip-buying rule can beat the S&P 500 using a Monte Carlo null baseline, an A/B test of a news-sentiment filter, and a power analysis. Paper trading only.

Open project →

Python · SQLite · Ubuntu

Newsbot – Self-Hosted News-Intelligence Pipeline

What's the biggest story today, measured by how many outlets cover it rather than by one editor's choice? Collects 59 RSS feeds from 42 outlets every 15 minutes into SQLite, with deduplication, feed-health monitoring, and verified backups. Ranking in development.

Open project →

Python · SQLite · NWS API

wxbot – Automated Weather Data Pipeline

Where is the weather actually unusual today, not just hot? Designed to compare live station reports against 1991–2020 normals, with a data-quality layer and an NWS forecast-accuracy scorecard. In development.

Open project →

Analytics Projects

SQL

E-commerce Business Optimization Analysis

Multi-dimensional SQL analysis of 181K+ e-commerce orders in BigQuery – examining revenue, profit, margins, returns, and lost revenue across products, brands, categories, customers, trends, and distribution centers.

Open project →

SQL

Nashville Housing Data Cleaning & Transformation

End-to-end data cleaning in MySQL – DDL, DML, string functions, type conversions, deduplication, views, indexes, and stored procedures on 56,000+ property records.

Open project →

Excel

Sales Dashboard – Superstore Dataset

Interactive dashboard showcasing KPI development, Power Query cleaning, pivot analysis, and executive-ready visuals.

Open project →

Tableau

Marketplace Ops & Customer Experience (Olist)

Built an interactive multi-dashboard Tableau Public report focused on fulfillment performance, delivery delays, and customer review drivers using a multi-table marketplace dataset.

Open project →

Power BI

Healthcare Analytics Dashboard

Multi-dashboard healthcare BI portfolio project featuring advanced DAX, Power Query, and executive-ready insights.

Open project →

Python

Financial Analysis

Analyzing 10 years of financial market data using Python for time series analysis, risk metrics, and forecasting.

Open project →

R

A/B Testing & Experimentation

Comprehensive A/B testing analysis workflow demonstrating statistical testing, power analysis, regression adjustment, and quality assurance using simulated SaaS onboarding data.

Open project →

Looker Studio

Cohort Retention Analysis

End-to-end cohort retention analysis using BigQuery SQL and an interactive Looker Studio dashboard – covering retention matrices, revenue retention, acquisition channels, lifecycle segmentation, and cumulative LTV.

Open project →

Julius AI

Health Data Analysis

AI-powered analysis of the CDC's U.S. Chronic Disease Indicators dataset using Julius AI – exploring diabetes trends, asthma disparities, cardiovascular correlations, and more through natural language prompts.

Open project →

API Pipeline

Federal Job Market Analytics Pipeline

Automated ETL pipeline that collects federal job postings daily from the USAJobs API, stores them in SQLite, and visualizes insights through an interactive Streamlit dashboard.

Open project →

Oracle SQL · Excel · Power BI

Supply Chain Demand Forecasting, Inventory Optimization & MRP Simulation

End-to-end automated supply chain analytics – Oracle stored procedures, MRP net requirements simulation, ABC/XYZ classification, demand forecasting, and a six-page Power BI dashboard with scheduled refresh and data alerts.

Open project →

Machine Learning

Customer Churn Prediction

End-to-end ML pipeline – 5 classification models compared head-to-head, SHAP explainability, hyperparameter tuning, and an interactive Streamlit app for real-time churn risk scoring with 0.83 AUC and 79% recall.

Open project →

Excel

FP&A Financial Model – Skechers U.S.A.

3-statement financial model built from SEC 10-K filings – 5 years of historical data with 3-year forward projections, segment-level revenue modeling, working capital forecasting via DSO/DIO/DPO, variance analysis, scenario planning with sensitivity tables, and a KPI dashboard with model integrity checks.

Open project →

Python · Streamlit

College Match Finder

Interactive Streamlit app using U.S. Department of Education College Scorecard data – weighted multi-criteria scoring, distance filtering, acceptance likelihood badges, side-by-side comparison, and exportable reports.

Open project →

JavaScript · JSON

Car Catalog

Structured dataset of 1,492 vehicle trims across ~40 fields per row, every value individually sourced and cited under a manufacturer-only policy.

Open project →