Welcome to my portfolio

Hi, I'm William Gerstung

I'm a

Data Engineer

I build things for the web and enjoy turning complex problems into clean, efficient solutions. Take a look around to see what I've been working on.

GitHub Profile Resume

Projects

A selection of repositories I've been working on

224 contributions in the last year

Less

FebMarAprMayJunJulAugSepOctNovDecJanFeb

Mon

Wed

Fri

typer

Typing practice in your terminal. Like monkeytype, but in the CLI.

clicommand-line-toolcurseskeyboard

Python21

homebrew-typer

Homebrew tap for typer — typing practice in your terminal

Ruby

mcp-builder

AI-powered web app for building MCP servers through a chat interface. Describe what you need, and it generates the full server spec, code, and file structure — with built-in testing, deployment, and publishing to PyPI.

TypeScript

mcp-bible-mcp-server-hmmj24

A comprehensive Bible server providing verse lookup, search, chapter reading, and study tools using the Bible API

Python

AI_Therapist

Utilizing OpenAI's GPT-4 and txtai embeddings, this script generates personalized life consultation reports from a brief user input and dataset analysis.

huggingface-transformersopenaisemantic-searchtxtai

Python11

William-Ger

About me, list of my repositories, and contact information

About Me

I'm a data engineer who enjoys building performant applications and exploring new technologies. I care about clean code, good developer experience, and shipping things that work.

Tech Stack

Python

Spark

Databricks

Azure

Next.js

FastAPI

TypeScript

React

Tailwind CSS

Git

Experience

My professional journey so far

Download full resume

2023 - Present

Data Engineer

Gibson Consulting — Chicago, IL

Lead data engineering initiatives for implementation projects with potential client savings of ~$35 million. Built comprehensive data pipelines to automate RFQ/RFI processing across 3,000+ global suppliers, reducing manual processing time by 90%. Designed ETL pipelines for multi-client reporting dashboards and developed custom web applications for client workflows.

PythonSQLAzureSparkNext.jsFastAPI

2020 - 2022

Data Analyst Intern

Danley's Garages — Elk Grove Village, IL

Identified and resolved critical database integrity issues with SQL queries. Automated sales analytics dashboards through Excel VBA programming, eliminating manual reporting. Created monthly sales performance reports and managed procurement planning for building materials.

SQLExcel VBAData Analysis

2019 - 2023

B.S. Business Analytics & Information Systems

University of Iowa — Tippie College of Business

Graduated May 2023 from the Tippie College of Business with a focus on Business Analytics and Information Systems.

AnalyticsInformation Systems

Get In Touch

Have a project in mind or just want to connect? Feel free to reach out.

GitHub