KW KeAndre Williams Financial Analyst · Data Scientist · Systems Builder

Portfolio

Selected work

Two kinds of work, in one place. Professional projects done at enterprise scale inside American Airlines. Independent builds done outside it — systems I designed and shipped myself, with demos and case studies.

Applied work · American Airlines Cargo

Professional projects

Enterprise-scale work on internal systems and data. Source and output are confidential; what's shown here is the problem, the approach, and the result.

Data Science & ML Active (production)

Predictive Forecasting & Cost-Anomaly Detection

Context

Enterprise spend of $100M+ was managed with static reports that surfaced problems only after the fact.

Approach

Trained forecasting and clustering models on 10+ years of financial and operational records to project spend and automatically flag anomalies against expected patterns.

Tools

Python, R, Alteryx Intelligence Suite, Jupyter, SQL

Outcome

Improved forecast accuracy and shifted cost oversight from reactive to proactive, surfacing savings opportunities earlier in the spending cycle.

Customer Analytics Active (production)

Customer Segmentation for Enterprise Migration

Context

A migration of 150+ enterprise cargo customers needed a data-driven view of who to prioritize and where value was concentrated.

Approach

Built customer-analytics and segmentation models and partnered with commercial-strategy and finance to translate segments into an engagement and migration plan.

Tools

Python, SQL, Tableau, Excel

Outcome

Supported migration of 150+ enterprise customers; identified $3M+ in strategic cost savings.

Statistical Modeling Active (production)

Econometric & Causal Driver Modeling

Context

Leaders needed to know which operational levers actually moved financial outcomes — not just what correlated with them.

Approach

Applied regression and econometric modeling to estimate driver effects, complemented by Monte Carlo simulation to quantify uncertainty and risk across scenarios.

Tools

R, RStudio, STATA, Python

Outcome

Gave stakeholders defensible, driver-based reasoning behind forecasts rather than surface-level trend descriptions.

Data Engineering Active (production)

Governed, Reproducible Data Pipelines

Context

Analysis was trapped in 100+ hours of annual manual reporting that was slow, error-prone, and difficult to audit.

Approach

Engineered automated ingestion and classification pipelines that parse varying data structures, placed under GitHub version control with documentation; integrated LLM-assisted development (GitHub Copilot) to accelerate delivery.

Tools

Alteryx, Python, SQL, Git/GitHub, VBA

Outcome

Eliminated 100+ hours of manual work annually; downstream models are now reproducible, version-controlled, and audit-ready.

Independent builds

Portfolio projects

Projects I designed and built outside of work. Most have a live demo or interactive case study.

Analytics & Automation Active

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 Active

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 Active

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 Active

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 Active

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 Active

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 Active

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 Active

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 Active

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 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 Active

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 Active

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

Core toolkit

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