WORK FILES

Evidence you can open and inspect.

Decks, editable analytical models, and browser-based dashboards from the case studies. Each item states its evidence type and scope; private data is not included.

38 files12 case studies6 formats

Finance & AI

BlueX

Proprietary research system · Public pages are scrubbed metrics/UI only · Not trading advice

View case study

HTML4 KB

Research Overview

Sanitized entry point for current HUD links, remodel summaries, model compare, and capital-set sample.

Open file ↗

HTML5 KB

Current Signal Overview

Current lights layer with public codes only — stats, NFLX subplot, and ANOVA pilot.

Open file ↗

HTML10 KB

Ensemble Summary

Strategy return, alpha vs buy-and-hold, Sharpe, and ML accuracy for the ensemble remodel.

Open file ↗

HTML16 KB

XGBoost Summary

Gradient-boosted remodel metrics on the same holdout framing as the other tree models.

Open file ↗

HTML16 KB

LightGBM Summary

LightGBM remodel metrics compared against ensemble and XGBoost on identical splits.

Open file ↗

HTML15 KB

MLP Summary

MLP remodel summary table for the same ticker universe.

Open file ↗

HTML11 KB

Model Comparison

Side-by-side remodel comparison without private feature identifiers.

Open file ↗

HTML13 KB

Decision Dashboard

Decision-focused public view; formulas and private recipes stay private.

Open file ↗

Analytics & Growth

Merchant Growth

Deterministic synthetic data · Simulated and modeled impact

View case study

PDF305 KB

Merchant Growth Strategy Deck

Executive narrative covering acquisition, retention, unit economics, wallet adoption, and financing guardrails.

Open file ↗

Excel16 KB

Merchant Unit Economics Model

Editable workbook for contribution margin, CAC payback, and scenario sensitivity.

Download file ↓

HTML9 KB

Merchant Performance Dashboard

Browser-ready executive dashboard generated from the reproducible analytics pipeline.

Open file ↗

Analytics & Growth

Travel Analytics

Public listings + synthetic clickstream · Proxy and simulated impact

View case study

HTML8 KB

Travel Analytics Case Library

Four equal cases with linked dashboards, executive briefs, methodology, limitations, and SQL where applicable.

Open file ↗

PDF216 KB

Travel Analytics Portfolio Case

A 12-slide portfolio overview that connects the four cases without elevating any single case.

Open file ↗

HTML20 KB

Weekly Ops Diagrams

Clickable diagram previews: open each full diagram or its Mermaid source file. Sample/process only — not Agoda production.

Open file ↗

HTML5 KB

Travel Funnel Dashboard

Browser-ready conversion funnel and experiment dashboard built from synthetic clickstream data.

Open file ↗

HTML4 KB

Weekly Product Ops Brief

Slack-ready weekly brief combining content health, funnel metrics, experiment readout, and ops flags.

Open file ↗

SQL4 KB

Content Quality Prioritization SQL

DuckDB queries that size content gaps and rank public-listing improvement opportunities; no listing data is bundled.

Open file ↗

SQL7 KB

Funnel & Experiment Analysis SQL

DuckDB funnel, device, cohort, and experiment-population queries for the synthetic clickstream case; no event data is bundled.

Open file ↗

Analytics & Growth

E-commerce Growth

Public learning dataset · Historical analysis and planning estimates

View case study

PDF213 KB

E-commerce Growth Strategy

Executive deck connecting channel quality, mobile conversion, product mix, refunds, and budget allocation.

Open file ↗

PDF9 KB

Capstone Evidence Summary

A summary of the original capstone’s data model, SQL evidence, findings, recommendations, and limitations.

Open file ↗

Excel13 KB

E-commerce Budget Allocation

Editable planning workbook for channel budgets, expected contribution, and decision guardrails.

Download file ↓

SQL3 KB

PostgreSQL Data Model

Capstone schema for products, sessions, pageviews, orders, items, refunds, and analytical indexes.

Open file ↗

SQL2 KB

Exploratory SQL Analysis

Initial analysis of volume, channel mix, device mix, funnel conversion, and session-to-order joins.

Open file ↗

SQL3 KB

Descriptive SQL Analysis

Business-health, channel, device, refund-risk, and repeat-session analysis supporting the capstone recommendations.

Open file ↗

SQL2 KB

Correlation & Metric SQL

PostgreSQL analysis of session depth, conversion, repeat-session behavior, and revenue quality.

Open file ↗

Finance & AI

Agentic FinOps

Product strategy concept · Not a live financial product

View case study

PDF472 KB

Agentic FinOps Executive Summary

Sanitized opening section of the business foundation deck — concept proposal only.

Open file ↗

Data & Systems

Digital Health

Proposed enterprise architecture · Research-led concept

View case study

PDF1.1 MB

Digital Health Architecture Summary

Sanitized opening section of the research deck — proposed architecture, not a deployed system.

Open file ↗

Data & Systems

Hotel Analyzer

CS50 Python final project

View case study

Python16 KB

Hotel Analyzer Source Code

Python source covering Hotel OOP, regex price cleaning, CLI/interactive modes, filters, aggregates, and CSV export.

Open file ↗

Python6 KB

Automated Test Suite

pytest coverage for regex parsing, missing-file errors, city/price filters, extrema, averages, CSV write, and CLI exit codes.

Open file ↗

Markdown3 KB

Project README

Run instructions and a Week 0–9 skill map tying each CS50 topic to the code.

Open file ↗

Data & Systems

Financial CRM

CS50 SQL final project

View case study

HTML2 KB

Schema Overview

Short overview of the entities, relationships, constraints, views, and triggers in the final project.

Open file ↗

SQL8 KB

SQLite Schema

Source schema showing tables, constraints, indexes, triggers, and reporting views. No sample client data included.

Open file ↗

Data & Systems

Restaurant Data Model

UC Davis final assignment

View case study

PDF302 KB

Relational Data Model

UC Davis Part 2 submission — relational model and normalization rationale.

Open file ↗

SQL4 KB

SQLite Schema

3NF schema with 11 tables, primary/foreign keys, and sensitive-field classification comments.

Open file ↗

SQL1 KB

Business Queries

Monthly revenue and multi-table menu-performance queries from the final assignment.

Open file ↗

Strategy & Research

Adblocker Strategy

Business analytics capstone

View case study

PDF326 KB

GYF Adblocker Strategy Capstone

15-slide Wharton Online Business Analytics capstone covering research, strategy, A/B-test measurement, and staffing decisions. Educational case, not company results.

Open file ↗

Finance & AI

Diversification Model

Historical financial-modeling capstone · 2012–2015 comparison

View case study

PDF238 KB

Diversification Model Capstone

Six-slide historical comparison of a VBTLX/VFIAX mixed portfolio and AAPL over 2012-2015, including return, volatility, and drawdown. Educational work only, not investment advice.

Open file ↗

Strategy & Research

AI in Trading

Research guide · Not a software implementation

View case study

PDF108 KB

AI in Trading Research Guide

Seven-page educational guide on ML approaches, agentic AI, model risk, and governance. Research perspective only, not investment research or trading advice.

Open file ↗

FILE NOTES

Evidence type and scope are stated with each case.

Files may use synthetic, simulated, historical, or public-source evidence. Personal datasets, credentials, and confidential source files are not included.