Selected work
Selected software, data, and operational technology work for Public Works. Explore the planning case study or expand a project to read my contribution.
Case study · GIS & planning workflows
Two browser-based workspaces for exploring multi-year infrastructure scenarios, coordinating related work, and reviewing the effects of planning changes.
I defined the planning workflows and domain requirements, then iterated through AI-assisted development and targeted QA.
Read case study & try demoAI & geospatial workflow
Assist identification of crosswalk features from geospatial coordinates and image data instead of relying entirely on manual review.
Designed and developed a Python processing workflow with external API data, concurrent and batched processing, caching, restart-safe execution, structured logging, error handling, and structured output for downstream analysis.
Data & operational reporting
Centralize operational reporting and KPI monitoring for City of Kansas City Public Works programs.
Designed Power BI dashboards, reusable DAX measures, fiscal-year and fiscal-month logic, dynamic date behavior, KPI cards, filters, slicers, goals, status indicators, and historical reporting. Integrated and cleaned data from REST APIs, Excel, ArcGIS, Survey123, and operational systems.
Web application
Give City staff a consistent, repeatable way to calculate municipal degradation fees from established business rules.
Translated operational and engineering requirements into application logic, then developed the web interface, input validation, and deterministic calculation workflow.
Operational systems
Support technology used to monitor, coordinate, and operate municipal snow-removal activities.
Supported Snow Command technology, operational dashboards and reporting, simulator hardware and software, field systems, and troubleshooting during snow operations.
Operational systems
Support deployment and use of fleet, routing, vehicle, and operational technology within Public Works.
Assisted with implementation and technical troubleshooting, supported adoption within existing operational workflows, and helped operational teams resolve system issues.