KW KeAndre Williams Financial Analyst · Data Scientist · Systems Builder

Work

Case studies

Each project is written up the same way: the problem, the data, what I built, what it produced, and what I'd do differently. Filter by the kind of role you're hiring for.

Analytics & Automation · 2026

Trucking Cost & Revenue Intelligence Dashboard

A Python-generated dashboard that turns monthly freight cost and revenue data into a decision tool — scoring every station on cost efficiency versus the revenue it enables, with a live what-if simulator on top.

Python, pandas, Plotly, Jinja2, HTML/JS

Software · 2026

Trucking Pulse — Shared Mailbox Triage Console

A triage console for a cargo trucking team's shared mailbox. It reconciles every saved email into a local database, scores and files it, and shows the team what needs action now, which stations are struggling, and what a lane should cost. Five releases from a static dashboard to a tested, bilingual web app.

Python, SQLite, standard-library HTTP server, vanilla JavaScript, Power Automate, unittest, Playwright

Software · 2026

Groundwork — Capital Request Intake

A front door for capital requests. Turns a plain-language need into a structured five-section request, scores it the way Finance actually reads it, coaches it with guided questions, and blocks it until the non-negotiable items are met.

Python, SQLite, standard-library HTTP server, python-docx, Pillow

Data & AI · 2026

StudyForge — Agentic Study Pipeline

Turns textbooks, papers, and language material into grounded, exam- or goal-targeted study output, then delivers it to your inbox one section at a time — and, as the same targeting idea generalized, language-proficiency plans and job-specific interview prep. A four-agent Python pipeline with grounding checks and a FastAPI dashboard.

Python, FastAPI, Anthropic API, pypdf, python-docx, reportlab, SQLite, Jinja2

Data & AI · 2026

The Flyback Machine — Flight History to Calendar

Reads flights out of boarding passes, confirmation emails, and itinerary screenshots, de-duplicates them against each other, and exports the result as calendar events a flight tracker can import. One self-contained HTML file with no backend.

JavaScript, vision LLM APIs, ICS, CSV, single-file HTML

Data & AI · 2025

FrameMatch — Video Similarity Detection

A tool that finds re-encoded, trimmed, or resized copies of a video by fingerprinting frames and matching them — built through three versions, ending on ORB feature matching parallelized across CPU cores.

Python, OpenCV, ORB, perceptual hashing, imagehash, multiprocessing, NumPy

Data & AI · 2025

Parlay Outcome Simulator

A daily pipeline that accumulates live sportsbook odds, and a simulator that reconstructs what a given set of picks would have paid — built to answer a question a group of friends kept asking and never resolving.

Python, pandas, The Odds API, scheduled ingestion

Analytics & Automation · 2025

Market Data Reporting Pipeline

A scheduled Python pipeline that ingests market data, computes portfolio performance, and delivers daily and weekly reports without anyone opening a spreadsheet.

Python, pandas, SQLite, APScheduler, Jinja2, SMTP, matplotlib

Data & AI · 2025

StarStruck — Engineering Career Map

An interactive graph that maps fields to the skills they need, the education that grounds them, and the careers they open — and hands concrete goals off to the mentorship tracker.

JavaScript, custom force-directed layout, SVG, JSON schema

Software · 2025 · Archived

Waypoint — Mentorship Platform

A college and career mentorship platform for underserved high school students — student journals, a cohort forum, and credit-based progress tracking. No longer operating; rebuilt here as a working demo from my original source.

JavaScript, Velo, Wix Data, REST, HTML/CSS

Security & Systems · 2025

Detection Lab — Active Directory

A self-contained Windows domain and Linux network built to generate realistic telemetry, then instrumented to see whether common attacker behavior actually shows up in the logs.

Windows Server, Active Directory, Kali Linux, Wireshark, Sysmon, VirtualBox, pfSense

Software · 2026

This Site — Portfolio Platform

The site you're reading. A custom Python static site generator, a hand-built design system, and four self-contained browser applications — built to consolidate scattered projects into one place and prove the work is real.

Python, Jinja2, Markdown, YAML, JavaScript, CSS