Portfolio

Work that turns complexity into something usable.

These projects show the connective work between people, requirements, systems, implementation, and documentation.

Systems analysis · implementation · process design

Designing a Repeatable Endpoint Recovery Workflow

Turning an urgent workstation recovery effort into a repeatable deployment process across a mixed hardware environment.

The situation

A ransomware incident affected approximately 33 workstation endpoints across multiple locations. I was responsible for the primary endpoint recovery workstream covering 31 systems, plus two spare or exception systems.

My contribution

I developed and refined the endpoint recovery workflow while restoration was underway, standardizing the common cloning path, separating hardware and boot exceptions, increasing parallel recovery capacity, troubleshooting across storage and firmware layers, and documenting the resulting process.

View full case study

Capabilities demonstrated

  • Systems analysis
  • Implementation planning
  • Process standardization
  • Cross-layer troubleshooting
  • Exception handling
  • Technical documentation
  • Stakeholder communication

Project status

Recovery completed · legacy exception follow-up

Infrastructure · process design · documentation

Realtime Linux Server Build and Setup Guide

Turning an urgent, incomplete technical request into a repeatable server implementation process.

The situation

A dedicated Linux server was needed for near-realtime audio and application-host testing. Requirements arrived incrementally, with hardware constraints, organizational conventions, and implementation details scattered across conversations and prior experience.

My contribution

I installed and validated the operating environment, worked through kernel and service configuration issues, captured corrections as they emerged, and converted the build history into a structured guide that another person could follow and review.

View full case study

Capabilities demonstrated

  • Requirements clarification
  • Linux implementation
  • Constraint tracking
  • Troubleshooting
  • Procedural documentation
  • Knowledge transfer
Software architecture · technical learning

Godot Architecture Mini-Project Series

Using constrained projects to build transferable understanding instead of collecting disconnected tutorials.

The situation

Introductory projects can produce working code without producing a reliable mental model of the engine. I designed a sequence of small projects that isolate architecture questions such as scene ownership, state management, resource loops, and data-versus-display separation.

My contribution

I defined project boundaries, implemented and tested each system, recorded discoveries and failures, and turned the results into public technical narratives that explain what changed in my understanding.

Read Space Miner Clicker

Capabilities demonstrated

  • Architecture analysis
  • Incremental development
  • Testable decomposition
  • Technical explanation
  • Learning-system design
Web architecture · content systems · personal branding

AndrewHakes.com Personal Brand and Publishing Platform

Building a controlled platform for presenting provable learning, demonstrated mastery, technical artifacts, research, and long-term creative production.

The situation

The project began as a custom PHP personal-brand site with a JSON-driven palette-testing lab for evaluating brand colors across practical Bootstrap interface components.

A later attempt to add WordPress as a publishing layer introduced substantial styling, routing, maintenance, and integration friction without producing the consistency or control the site required.

My contribution

I developed the initial PHP site and palette lab, evaluated and removed the WordPress integration, rebuilt the public site around shared PHP components, separated structural styling from visual palettes, and established reusable patterns for portfolio projects, articles, evidence, and future publishing utilities.

View full case study

Capabilities demonstrated

  • Requirements analysis
  • Information architecture
  • PHP templating
  • Bootstrap implementation
  • JSON-driven interface prototyping
  • CSS design-system maintenance
  • Platform evaluation
  • Architectural simplification
  • Publishing-workflow design

Project status

Baseline platform operational

Business systems · data workflow · user enablement

Healthcare Billing and Legacy Database Support

Long-term consulting across application migration, billing-process changes, data outputs, and remote-work conversion.

The situation

Several Clinical Programs relied on a legacy application wrapped around Microsoft Access. The work required learning the real operational process from several staff members, understanding application behavior, and preserving billing continuity through software and organizational changes.

My contribution

I validated an Access 2007-to-2016 migration, translated parked improvement ideas into a functional workflow, adapted input and output data for downstream Epic loading, supported the transition to remote-visit billing during COVID, and trained users in person and remotely.

Capabilities demonstrated

  • Stakeholder discovery
  • Legacy application analysis
  • Database migration support
  • Billing workflow adaptation
  • Data-interface preparation
  • Remote user training

The common thread is translation.

Between users and systems, requirements and implementation, technical behavior and practical action.

Discuss a role or project