KW KeAndre Williams Financial Analyst · Data Scientist · Systems Builder

Financial Analyst · Data Scientist · Systems Builder

I build the systems that turn operational data into decisions — pipelines, models, applications, and the infrastructure under them.

I analyze freight revenue and forecast performance for a global cargo network, and I build the systems that do it — data pipelines, models, applications, and the infrastructure underneath them.

Selected work

Things I've built

Each one is a full case study — the problem, the data, what I built, and what it produced. Several run as live demos in the browser.

12 projects

  1. 01 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. Analytics & Automation Python, pandas, Plotly 2026 live
  2. 02 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. Software Python, SQLite, standard-library HTTP server 2026 live
  3. 03 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. Software Python, SQLite, standard-library HTTP server 2026 live
  4. 04 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. Data & AI Python, FastAPI, Anthropic API 2026 live
  5. 05 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. Data & AI JavaScript, vision LLM APIs, ICS 2026 live
  6. 06 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. Data & AI Python, OpenCV, ORB 2025 live
  7. 07 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. Data & AI Python, pandas, The Odds API 2025 live
  8. 08 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. Analytics & Automation Python, pandas, SQLite 2025 live
  9. 09 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. Data & AI JavaScript, custom force-directed layout, SVG 2025 live
  10. 10 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. Software JavaScript, Velo, Wix Data 2025 arch
  11. 11 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. Security & Systems Windows Server, Active Directory, Kali Linux 2025 live
  12. 12 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. Software Python, Jinja2, Markdown 2026 live

What I work with

Languages & query

Python, SQL, TypeScript, VBA, Bash

Data & ML

pandas, scikit-learn, OpenCV, FAISS, Jupyter, Alteryx, Tableau

Systems & delivery

FastAPI, React, Tailwind, Node.js, Docker, Git

Security

Linux, Active Directory, Wireshark, Metasploit, Splunk-style log analysis

Certified CompTIA CySA+, CompTIA Security+, CompTIA Network+, Alteryx Designer Advanced, Alteryx Designer Core

From the lab

All writeups →