Below are just a sample of the some of the analytical tool based projects that I have been the lead tech on during my professional career. I was the lead technical coder for all of these projects.
F16 SLEP Tool
Created a VBA based tool in Excel to optimize the induction schedule for the F16 Service Life Extension Program. The tool took as input the current F16 effective flying hours for each F16 tail and then produced a GANTT chart which showed the optimal induction for each F16 tail into the SLEP program. A hill climbing based optimization method was coded exclusively in VBA. The advantage of this VBA approach is that the customer did not have to rely upon any outside software. The tool saved the F16 scheduler at Hill AFB days of manual labor time, and this same customer consequently gave the tool a high degree of kudos.
F22 Scheduling Tool
Deftly developed a Microsoft Visual basic-based scheduling tool for F-22 scheduling clients at Hill AFB. The novelty of the tool lied in the fact that the user could visualize both the Infrastructure and Manpower side-by-side for any forecasted day in the future. This tool received a high degree of recognition, including winning Honorable Mention at the Military Operations Research Symposium (MORS) in 2016.
IG Text Mining Tool
Diligently developed an R-based tool for the inspector general (IG) of the LCMC. The tool takes as input IG related text-based complaints from Excel and then translates them into text-based mining graphs and plots. This tool was successfully demonstrated and delivered for independent self-execution on the IG’s workstation. The tool received good praise from the IG.
PK Dashboard
Expertly created a dashboard tool in R for the PK office using RMarkown’s flexdashboard capability. The dashboard provided an overview of career-based succession data. This dashboard tool was successfully delivered to the PK office with good kudos.
STAMP Simulation Model
Deftly lead an analytical team in the creation of a self-created simulation model in Simio for the 649th STAMP munitions team at Hill AFB. The simulation model mimics the movement of swing stock munitions throughout the STAMP bomb dump area for later air delivery to various DoD theaters around the world. The simulation model takes, as input from the user, the number of various STAMP related resources (such as tractors and trailers) and then performs simulation-based design of experiments around these resource counts. This simulation model was delivered with kudos to the STAMP team and ultimately used by the customer to justify funding for more trailers - which would be or urgent need during a war-time surge scenario.