Will Koehler

Resume

Overview

I'm a senior-level developer and system architect. I specialize in helping companies focus a collection of business needs into a clean, simple software solution. I take projects from concept to final deliverable, often continuing with long-term maintenance and updates. I constantly push to simplify and remove unnecessary decisions and distractions from the user. The resulting applications improve daily workflow, track key business metrics, and make companies more efficient. These applications commonly return the initial investment in under a year via revenue growth and cost savings and continue to generate wealth for many years after that.

Consulting Work

Web Applications
2005 - present
Ruby + Rails • PHP • JavaScript • jQuery • MySQL • HTML/CSS • AWS

My preferred stack is Ruby on Rails with a lightweight JavaScript front end. The bulk of the application logic and views are in the Rails application with just enough front-end code to make the user experience fluid and seamless. My applications run on AWS infrastructure, managed by AWS OpsWorks.

I maintain several legacy apps built with PHP and ExtJS. While no longer cutting edge, these apps have been running flawlessly for over 10 years and still deliver important business value.

Infoquest, Ltd

Developed the Investigation Management System, a tool that tracks workers compensation fraud investigations. The system handles every step of an investigation from initial request to monitoring progress to client communications to reporting and invoicing. Investigators can upload surveillance videos and enter surveillance notes from their iPads in the field, saving them significant time.

Key challenge: Encoding and streaming video for playback on a variety of platforms including mobile and flash-based players. Surveillance notes can be linked with the surveillance video so clients can see video clips associated with each surveillance note.

Impact: The IMS helped Infoquest acquire new clients and grow annual revenue from $3M to $4M (2013 to 2016). Key clients, like Toyota and Nationwide, cite the efficiency of using the IMS as a primary reason for working with Infoquest. In addition, by simplifying management and investigation work, the IMS saves Infoquest $200k/year in overhead and employee costs.

Orion America Technologies, LLC

Drawing on Orion AT's expertise in government contract management, I created OMIS, a tool to track projects at FAA-funded research centers. The resulting application is getting attention at all levels of the FAA as an example of the right way to track FAA-sponsored research.

Key challenge: Building a system where a wide range of people, from Program Managers, to Principal Investigators, to Tech Monitors, to Fiscal Admins, to Contract Admins, each feel the system is designed specifically around their needs and makes their job easier.

Impact: Six months after launch, the OMIS is generating $150k/yr in revenue with expected growth to $200k/yr in 2018. In turn, by improving accuracy and reducing duplication of effort, the OMIS is saving the FAA $360k/yr in administrative oversight costs, expected to grow to $560k/yr in 2018.

Pharmacy Systems, Inc

I've worked with Pharmacy Systems for over 15 years building a wide range of tools to help them manage hospital pharmacies, hospital supply chains, and hospital rehab units.

Key challenge: Distilling Pharmacy Systems' business data into a set of key metrics that clearly shows the value they are providing to their customers.

Impact: The Contract Management System has generated $100k/yr in revenue since it's launch in 2012.

Other Clients

Bay Photo Lab
Collagewall LLC

Commercial Prototypes
2011 - 2012
CoffeeScript • HTML/CSS • iAd JS

1K Studios

Built a series of prototypes on Apple TV and iPad to explore the future of the movie and TV viewing experience. This project was for a high profile client contracted through 1K Studios.

Business Intelligence
1997-2005
SQL Server • Microsoft Access • Visual Basic • PHP • ASP

Chase Bank

Built a tool with Microsoft Access and ASP that helped Chase Bank to identify and document relationships between their private banking customers. I analyzed the resulting data with MS SQL Server.

Impact: Helped private banking agents identify the full value of banking relationships so they could optimize service for customers that were generating the most value for the bank.

Kal Kan - Mars Petcare

Built several tools with Microsoft Access and Visual Basic. The Hold System tracks inventory that was set aside (on hold) due to production problems. The Conformance System tracks production line output and conformance to product standards.

Impact: Helped Kal Kan improve production efficiency by identifying trends in production line conformance. Reduced waste by getting on hold inventory back into production quickly, before it needed to be discarded.

Other Clients

Harmony Ball Company
FAA Airworthiness Assurance COE

Real-Time, Embedded Systems
1997-2010
C • C++ • 68K Assembly • x86 Assembly • VxWorks • AMX

ADB Airfield Solutions

Developed firmware for embedded airport lighting control modules with C++ and AMX. These modules receive commands from the control tower to control taxi and runway lights and monitor lighting system status. This ADB lighting system is in use at major international airports in the US and Europe.

Key challenge: Developed a fault-tolerant communications protocol that used multiple channels and automatic failover to ensure reliable communications between the control tower and the lighting modules.

STAR Dynamics Corporation

Worked on a team developing a high resolution tracking radar. The radar had a phased array antenna capable of tracking multiple targets up to 100 miles in range within a few inches of resolution.

Key challenges: Designed an ultra low-latency communication protocol to interface between the target acquisition system and the tracking system. Designed a non-blocking, real-time memory allocation system.

Other Clients

Aeroflex Test Solutions
Dynamic Sensor Systems LLC
Lintek, Inc

Commercial Windows Applications
1997-2001
C++ • MFC • Windows API

John Neal & Associates

Developed “Sundial”, a commercial Windows 95 application using MFC and Visual C++. Sundial displays a changing outdoor scene on the Windows desktop. Sunrise and sunset on the desktop are synchronized with the local sunrise and sunset.

Employment

Lintek, Inc
1991-1997
C • C++ • 68K Assembly • Windows API

Developed real-time, embedded-system firmware and user interfaces using C, C++, 68K assembly, Windows 3.1, 95, NT. Firmware development required creation of an OS kernel including interfacing with SCSI, GPIB, Ethernet, and custom hardware designed in-house. Products developed include:

  • 5000 Radar System user interface, embedded firmware
  • 4000 Radar System user interface, data acquisition
  • GPR (Ground Penetrating Radar) embedded firmware
  • AWG (Arbitrary Waveform Generator) embedded firmware
  • TPI (Target Positioning System) embedded firmware, front panel interface
  • élan Radar System motion device subsystem

ElectroScience Laboratory - The Ohio State University
Summer 1989

Worked as an intern on a variety of projects including the predecessor to the Lintek radar systems.

Education

The Ohio State University
1986 - 1990

BS Electrical Engineering. GPA 3.74

Phi Kappa Phi • Pi Mu Epsilon (Mathematics) • Eta Kappa Nu (Elec. Eng.)