// hello

William Stegemann

Senior HR Technology & Data Analyst

Nine years supporting Oracle HCM, UKG Pro, and the systems around them — building the reporting and analytics layer with Power BI, SQL, Python, and the Power Platform.

01 / about

About

HR technology analyst who administers HCM platforms and builds the reporting and analytics layer around them. Established the HR analytics function at GoHealth from scratch, and now consults on custom data and automation tooling for operations teams outside HR.

Based in Chicago, IL
Focus HR Analytics, Automation, HRIS
Tools Power BI, SQL, Python, Power Platform

02 / projects

Projects

power-bi power-automate power-apps

HR Analytics Suite — GoHealth

Built the Power BI dashboard suite used by executives and HR business partners from the ground up, plus a Power Automate/Power Apps pipeline consolidating multiple HR systems into a central employee roster feeding dashboards and downstream automations.

python rest-api ukg-pro

Performance Review Automation

Wrote Python scripts and REST API integrations (via Postman) across UKG Pro, Microsoft, and AWS to automate extraction and loading of ~2,500 historical performance reviews into UKG Pro — replacing a multi-day manual effort.

power-bi sql

Commute & Site Planning Analysis

Analyzed employee commute distance and patterns in Power BI to support site location planning decisions.

flask sqlite python

3D Print Queue Manager

Personal project — a Flask/SQLite web app that scans OrcaSlicer 3MF files to track a print queue, per-plate filament usage, cost, and spool inventory across materials.

3D Print Queue Manager — project queue view 3D Print Queue Manager — filament inventory view

03 / resume

Resume

William Stegemann — Resume

Senior HR Technology & Data Analyst

Download PDF

04 / contact

Get in Touch

Open to opportunities and collaboration. Reach out any of the ways below.