I build practical automation, data, and tooling systems that make messy workflows easier to understand and operate.
- Data systems and automation engineer
- BS Chemical Engineering from UIC, with concentrations in Biochemical Engineering and Process Automation, and an MCS from UIUC
- Focused on C#, Rust, Python, VBA, Excel, embedded systems, and data-heavy workflow tooling
- Interested in internal tools, technical systems, and engineering work that improves clarity and leverage
Website · Blog · Portfolio · LinkedIn · ORCID
linreg-core
Rust linear regression library published across Rust, WebAssembly, Python, VBA, DLL, and Excel XLL surfaces.
Repo: jesse-anderson/linreg-core · Packages: crates.io, PyPI, npm
xll-rs
Rust runtime and support library for building native Excel XLL add-ins on Windows.
Repo: jesse-anderson/xll-rs · Packages: crates.io
xllgen
Proc-macro layer for generating Excel XLL wrappers in Rust.
Repo: jesse-anderson/xllgen · Packages: crates.io · Docs: docs.rs
xll-utils
PE/COFF parsing and export verification utilities for Excel XLL development.
Repo: jesse-anderson/xll-utils · Packages: crates.io · Docs: docs.rs
xll-template
cargo-generate template that scaffolds a working Excel XLL add-in project in Rust.
Repo: jesse-anderson/xll-template
Workbook Radar
Excel/VBA auditing and tracing tool focused on workbook risk, dependency graphs, and VBA flow analysis.
Private project, no public site or repo.
Tools
Durable collection of 50+ small web utilities published for everyday use.
Live Site: tools.jesse-anderson.net · Repo: jesse-anderson/Tools
- Rust/WebAssembly: DBSCAN Visualizer, Linear Regression, AI Image Detector
- Process and controls: PID Playground, Control Valve Sizing, Psychrometric Calculator, Steam Tables, Moody Chart Reader, Uncertainty Propagation
- Data: DuckDB Playground, Parquet Viewer, SQLite Viewer, CSV Profiler
- Excel and documents: Excel Formula Extractor, PDF Diff Checker, OCR Text Extractor, Scientific Graph Compare
- Biochemical engineering: Oral Multi-Dose Simulator, HED Calculator, Toxicology Body Burden, Stoichiometry Calculator, Yogurt CFU/g Estimator, Species Doubling Reference, Creatine Lab
- Workflow and diagrams: Process Flow Mapper, Sankey Diagram Builder, Meeting Planner
Oak Park Crime Map
Public-facing crime map and data exploration project for Oak Park.
Live Site: opcrime.jesse-anderson.net · Repo: jesse-anderson/Oak-Park-Crime
Oak Park Crime Dashboard
Descriptive, source-linked data science dashboard over public Oak Park Police Department daily activity bulletins.
Live Site: opcrimeds.jesse-anderson.net · Repo: jesse-anderson/OP-Crime-Dashboard-Public
N-Back
N-back working memory trainer built as a polished end-result project.
Live Site: nback.jesse-anderson.net
SpeedReader
Browser-based RSVP speed reader with a Rust/WebAssembly core, ORP highlighting, and adaptive pacing.
Live Site: speedreader.jesse-anderson.net
Home Environmental Sensor Network
ESP32 boards around the house logging particulates (PM1 through PM10), temperature, humidity, air pressure, light, and soil conditions since June 2024. Readings flow through a cron Worker into precomputed artifacts with no runtime database. The public view publishes daily statistics on a 30-day delay, alongside an outdoor baseline from the city sensor network.
Live Site: sensors.jesse-anderson.net/public
Portfolio
Project portfolio site.
Live Site: portfolio.jesse-anderson.net · Repo: jesse-anderson/Portfolio
Blog
Engineering, science, and tech writing.
Live Site: blog.jesse-anderson.net
Oak Park Crime Data Docs
Lineage, column documentation, and test coverage for the Oak Park crime dataset: two ingest streams, 19 models, and a parity check against the Python it reimplements.
Live Site: opcrime.jesse-anderson.net/dbt-docs · Repo: jesse-anderson/Oak-Park-Crime
Oak Park Crime Dashboard Data Docs
Lineage, column documentation, and test coverage for the Oak Park crime dashboard: 33 models, 570 documented columns, 100 tests.
Live Site: opcrimeds.jesse-anderson.net/dbt-docs · Repo: jesse-anderson/OP-Crime-Dashboard-Public
Meal Kit Analytics
dbt project modeling a weekly meal delivery business end to end, from raw landing tables through to BI-ready marts: 477,000 boxes, 20,000 customers, 24 months.
Live Site: mealkit.jesse-anderson.net · Repo: jesse-anderson/mealkit_analytics
SPS30_ESP32
Generalized Python library for the SPS30 particulate matter sensor on ESP32.
Repo: jesse-anderson/SPS30_ESP32
VBA_Batch_Reactor
Excel to Word VBA reporting pipeline with Python-generated synthetic batch reactor data.
Repo: jesse-anderson/VBA_Batch_Reactor
Scientific_Paper_Graph_Comparison_Tool
Python tool for comparing control vs treatment values read off published graphs on a percentage basis. A JavaScript version runs in the browser as Scientific Graph Compare.
Live Site: Scientific Graph Compare · Repo: jesse-anderson/Scientific_Paper_Graph_Comparison_Tool