You are using an outdated browser. For a faster, safer browsing experience, upgrade for free today.
Employee of the Quarter - Q3, 2023
Image of B. Rauenbuehler

Benjamin Rauenbuehler

  • Electronics Engineer
  • Spangdahlem AFB, Germany
  • Executed daily support for over 889 sorties for Q3 at Spangdahlem AB with 99% effective rate.
  • Designed pod maintenance actions database; created 5 spreadsheets to manage corrective inputs.
    • Corrected RAMPOD discrepancies for 3 pod cumulative hours, 20 serial numbers and 34 TCTOs.
  • Developed a digital RTO Shot Log to replace handwritten shot log. This spreadsheet contains 50 unique buttons coded with over 500 unique lines of VBA code and implemented USAFE wide.
    • Faster, more accurate shot recording—20% faster, lower RTO workload and improved SA.
    • Features include adjustable real-time Probability of Kill calculations, multiple, editable, simultaneous shot tracking, and manual override for pilots to meet desired learning objectives.
    • Lauded by 52FW pilots for clean, easy to read logs and for auto generated statistics capture.
  • Created and implemented a digitally automated pod loading & aircraft configuration database.
    • Ensures record keeping accuracy and improves pod loading efficiency, saving 1 hour per week.
    • Advantages include sorting by location, auto-highlighting pods coming due for inspection, and autonomously showing pods available for loading and their total cumulative hours.
  • Established a sortie tracker spreadsheet to function as a single source of data of all sorties.
    • Organized to easily compare numbers to monthly sortie report and RAMPOD sorties.
    • Includes a macro to export sortie data into the correct format for auto-import into RAMPOD.
    • Saves at least 10 hours/month from previous system and reduces conflicts between reports.
  • Repurposed unused unit assets; provide all six employees new desks and monitors--saved $5.2K.
  • Completed physical overhaul of site manager office layout and organization; lauded by PMR team.
  • Stepped in as site computer specialist position; completed TARIF software updates on 16 devices.
    • Streamlined cloning procedures; PGS refresh done 5 days early--increased productivity 20%.
  • Introduced various digital organizational efficiency changes to shop, including a shared task list, shared calendar for reoccurring tasks, and restructuring the site’s computer file structure.
  • Initiated idea of sending monthly TARIF updates electronically; implemented DOD Wide.
    • Process reduced cybersecurity incompliance; expedited software compliance by 4 months.
  • Lead on establishment of WarRoom; led multi-agency site survey team--identified 3 potential sites.
  • Executed Alternate Site Manager duties, single-handedly managed shop during Cobra Warrior EX.
    • Led team in 52FW WarRoom $10K equipment purchase; prevented $3.7K in unnecessary costs.
    • Coordinated sorties data collections with deployed units; fixed 10 errors--saved 7.5 man-hrs.
  • Spearheaded tech refresh: upgraded 5 of 6 computers and added 2 tablets for mobility tracking.
  • Facilitated use of NIPR computers outside of office; enabled use while TDY--saved 20 hrs. monthly.
  • COMSEC Officer; received zero discrepancies during AF COMSEC audit--awarded highest AF rating!
  • Finished three self-improvement books on effective communication & habits.
  • Continually learning VBA coding/excel functionalities, automated complex and tedious office tasks.
  • Volunteered 70 hours to Cadence Int’l; improved MWR for local chapel associated organization.
    • Designed and fabricated new coffee/serving bar, led weekly young adult group consisting of airmen and spouses, and served in the children’s ministries.