Projects

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.


Telework Simulation Analysis Tool


    • Skillfully created an Excel VBA-based tool for the deputy program executive officer of the LCMC/WB directorate. The purpose of the tool was to simulate the exact days that a given employee would come into work vs. telework in the 10 day pay period; relevant statistics were rolled up and reported at the office level. Furthermore, a dashboard of exploratory based plots were created, which automatically updated based upon the simulation runs. This tool was demonstrated to the WB directorate with high esteem, and the WB directorate plans to use the tool to help plan out their telework posture.