Jonathan White Resume
JONATHAN D. WHITE
------------, ------------
SUMMARY OF QUALIFICATIONS
Proven operations research analyst, international strategist, and workforce management professional with 7+ years as an Air Force Officer. Executed data-driven solutions to increase efficiency, accuracy, and utility of internal data processing. Experienced with designing, implementing, and querying large scale databases using Access/Excel/Pivot Tables/SQL, linear and non-linear optimization using VBA/Excel Solver/LINGO, statistical regression using JMP/Excel/Design Expert, predictive data modeling using JMP/R, design of experiments using JMP/Design Expert, integrating Excel/Access/PPT via VBA enabled decision support tools, modeling and simulation using ARENA/Logistics Composite Model, and creating decision quality visualizations to deliver insights and implement action-oriented solutions to complex business problems.
ADDITIONAL SKILLS
• Academic experience programming in C#, Java, SQL, KEDIT
• Academic experience with basic Machine Learning and Data Mining techniques using R
• Experience applying Lean Six Sigma methods to workforce and labor analyses
• Excellent technical leadership and training skills; ensured proficiency of multiple teams of analysts
Current government Top Secret SCI Clearance (Valid through March 2024)
PROFESSIONAL EXPERIENCE
Industrial Operations Management/Business Analytics Intern Ten Star Supply, Tampa, FL
February 2019 – Present
• Established comprehensive manufacturing operations and accounting financial ratio database; linked data to metric dashboards with MS Power BI via Visual Basic for better management insights
• Utilized Power BI Exponential Smoothing forecast function to forecast bi-annual demand for highest volume products; this work guided decisions on the purchase of 82 pallets of stock
• Directed 12 analyses of alternatives for shipment methods; ensured efficient delivery of 24+ pallets
Operations Research Analyst (Aircraft/Equipment Testing) USAF (53d Wing)
April 2018 – February 2019
• Organized and evaluated 577K lines experimental test data with JMP; scaled and graphed intricate time-series data collected from 12 sensors--verified results of $1.4M test
• Managed statistical test design for 9 scenarios; collected and analyzed 1.5K lines of test data using JMP and Excel; ensured execution of design of experiments plan
• Conducted regression analysis to determine significant experimental test factors and generated 36 visualizations of factor level effects; delivered timely insights for interim report to ensure swift implementation of $750M worth of critical equipment
Deployed Strategic/Operations Analyst USAF (Combined Air Operations Center Strategy Division)
October 2017 – April 2018
• Developed comprehensive training curriculum for newly deployed operations analysts; simultaneously executed on-the-job training for 4 analysts over 28 days, ensuring team proficiency with 20+ Access/Excel/VBA/web based decision support tools and 10+ databases
• Authored recurring assessments (60 daily /24 weekly/6 monthly) for a wide range of Air Force senior executives and decision makers; worked 300+ requests for analysis, analyzed 2.5K flying hours/26K events/10 operations --fostered data-driven decisions spanning 4 countries affecting $5B in resources
• Customized Excel VBA code to mine and analyze data for aircraft efficiency during 4 proof-of-concept flights; verified new capability affecting 93 remotely piloted aircraft ($17M each)
• Designed innovative Access/Excel database and visualizations to address senior leader concerns; justified retaining 12 advanced jet aircraft to support senior Air Force executive’s #1 regional priority
• Focal point for aircraft/equipment utilization analysis; presented weekly results to senior executives for 12 weeks--guided strategic decisions affecting 30 jet aircraft flights per day
Operations Research Analyst (Aircraft/Equipment Testing)/Executive Officer USAF (53d Wing)
June 2016 – October 2017
• Led JMP multivariate regression analysis for $500K test project; designed visualizations and presented results to a panel of 12 experts--increased aircrew awareness and safety on 100+ aircraft
• Conducted Monte-Carlo simulations for comparison to test data; built Excel VBA script to integrate sim data from 30 databases into a single database, and co-authored analytical report
• Managed $320K software upgrade test project; directed design of experiments test plan coordination and approval--increased safety for 32 aircraft ($1M each)
• Seized opportunity to save $50K by piggybacking test data collection onto aircrew training flights versus flying dedicated test flights; built probability models to assess critical aircraft ID software
• As senior advisor to an executive, led staffing activities for 500+ person organization; planned and led a week-long leadership summit and perfected over 60 special applications/240 award packages/1.5K staff meeting slides--bolstered organization’s situational awareness on 620 projects
Operations Research Analyst (Workforce Management)/Team Manager USAF
April 2014 – June 2016
• Managed a team of 12 analysts for 8 months that developed five labor analysis studies to optimize workforce levels across five career fields--justified 1.2K military jobs globally valued at $251M
• Executed Secretary of the Air Force-directed maintenance enterprise integration initiative affecting 24 airports and 337 aircraft; modeled/simulated operations, and used sim output to build linear regression model that drove workforce management decisions on 4.2K jobs
• As 3-person team lead for a project affecting 509 jobs worth $38M, decided to build process flow of a local office versus travelling and extrapolated that work flow Air Force wide, saved $12K in travel costs
• Developed Excel VBA decision support tool that modeled 21 core logistics work flow processes affecting all personal property being shipped for Air Force families globally; justified 557 jobs valued at $4.3M
• During a 30 day deployment, implemented VBA-based tools to manage and analyze big data outputs from 24/7 war-game simulations--provided daily visualizations directly to the senior Air Force officer in Korea
• Displayed emotional leadership by aiding family of a fallen teammate; ensured swift and accurate delivery of benefits and belongings and tactfully informed family on legal matters over 4 month period
Graduate Student – Operations Research USAF (AFIT)
August 2012 – April 2014
• Thesis Research: Developed linear/integer programming optimization model and implemented with Excel Visual Basic/LINGO Solver tools; research helps ensure minimal placement of notional vehicles (planes, trains and trucks) and optimal scheduling to achieve global military logistical needs at the lowest cost; United States Transportation Command implemented model in 2015 with potential savings in the billions
EDUCATION
AIR FORCE INSTITUTE OF TECHNOLOGY Dayton, OH
Master of Science in Operations Research, March 2014
UNIVERSITY OF TAMPA Tampa, FL
Bachelor of Science in Mathematics, May 2012
RECOGNITION AND AWARDS
• 2019: US Air Force Analytic Team of the Year - stratified as #1 of 5 analysts on winning team
• 2018: Operations Analyst of the Year - selected as the top analyst among 33 high-caliber peers
• 2015: Unit Officer of the Quarter (1st and 2nd Qtr) - selected among three officer peers
• 2014: Air Force Personnel Center Modeling and Simulation Team of the Year - member of team
JONATHAN D. WHITE
------------, ------------
SUMMARY OF QUALIFICATIONS
Proven operations research analyst, international strategist, and workforce management professional with 7+ years as an Air Force Officer. Executed data-driven solutions to increase efficiency, accuracy, and utility of internal data processing. Experienced with designing, implementing, and querying large scale databases using Access/Excel/Pivot Tables/SQL, linear and non-linear optimization using VBA/Excel Solver/LINGO, statistical regression using JMP/Excel/Design Expert, predictive data modeling using JMP/R, design of experiments using JMP/Design Expert, integrating Excel/Access/PPT via VBA enabled decision support tools, modeling and simulation using ARENA/Logistics Composite Model, and creating decision quality visualizations to deliver insights and implement action-oriented solutions to complex business problems.
ADDITIONAL SKILLS
• Academic experience programming in C#, Java, SQL, KEDIT
• Academic experience with basic Machine Learning and Data Mining techniques using R
• Experience applying Lean Six Sigma methods to workforce and labor analyses
• Excellent technical leadership and training skills; ensured proficiency of multiple teams of analysts
Current government Top Secret SCI Clearance (Valid through March 2024)
PROFESSIONAL EXPERIENCE
Industrial Operations Management/Business Analytics Intern Ten Star Supply, Tampa, FL
February 2019 – Present
• Established comprehensive manufacturing operations and accounting financial ratio database; linked data to metric dashboards with MS Power BI via Visual Basic for better management insights
• Utilized Power BI Exponential Smoothing forecast function to forecast bi-annual demand for highest volume products; this work guided decisions on the purchase of 82 pallets of stock
• Directed 12 analyses of alternatives for shipment methods; ensured efficient delivery of 24+ pallets
Operations Research Analyst (Aircraft/Equipment Testing) USAF (53d Wing)
April 2018 – February 2019
• Organized and evaluated 577K lines experimental test data with JMP; scaled and graphed intricate time-series data collected from 12 sensors--verified results of $1.4M test
• Managed statistical test design for 9 scenarios; collected and analyzed 1.5K lines of test data using JMP and Excel; ensured execution of design of experiments plan
• Conducted regression analysis to determine significant experimental test factors and generated 36 visualizations of factor level effects; delivered timely insights for interim report to ensure swift implementation of $750M worth of critical equipment
Deployed Strategic/Operations Analyst USAF (Combined Air Operations Center Strategy Division)
October 2017 – April 2018
• Developed comprehensive training curriculum for newly deployed operations analysts; simultaneously executed on-the-job training for 4 analysts over 28 days, ensuring team proficiency with 20+ Access/Excel/VBA/web based decision support tools and 10+ databases
• Authored recurring assessments (60 daily /24 weekly/6 monthly) for a wide range of Air Force senior executives and decision makers; worked 300+ requests for analysis, analyzed 2.5K flying hours/26K events/10 operations --fostered data-driven decisions spanning 4 countries affecting $5B in resources
• Customized Excel VBA code to mine and analyze data for aircraft efficiency during 4 proof-of-concept flights; verified new capability affecting 93 remotely piloted aircraft ($17M each)
• Designed innovative Access/Excel database and visualizations to address senior leader concerns; justified retaining 12 advanced jet aircraft to support senior Air Force executive’s #1 regional priority
• Focal point for aircraft/equipment utilization analysis; presented weekly results to senior executives for 12 weeks--guided strategic decisions affecting 30 jet aircraft flights per day
Operations Research Analyst (Aircraft/Equipment Testing)/Executive Officer USAF (53d Wing)
June 2016 – October 2017
• Led JMP multivariate regression analysis for $500K test project; designed visualizations and presented results to a panel of 12 experts--increased aircrew awareness and safety on 100+ aircraft
• Conducted Monte-Carlo simulations for comparison to test data; built Excel VBA script to integrate sim data from 30 databases into a single database, and co-authored analytical report
• Managed $320K software upgrade test project; directed design of experiments test plan coordination and approval--increased safety for 32 aircraft ($1M each)
• Seized opportunity to save $50K by piggybacking test data collection onto aircrew training flights versus flying dedicated test flights; built probability models to assess critical aircraft ID software
• As senior advisor to an executive, led staffing activities for 500+ person organization; planned and led a week-long leadership summit and perfected over 60 special applications/240 award packages/1.5K staff meeting slides--bolstered organization’s situational awareness on 620 projects
Operations Research Analyst (Workforce Management)/Team Manager USAF
April 2014 – June 2016
• Managed a team of 12 analysts for 8 months that developed five labor analysis studies to optimize workforce levels across five career fields--justified 1.2K military jobs globally valued at $251M
• Executed Secretary of the Air Force-directed maintenance enterprise integration initiative affecting 24 airports and 337 aircraft; modeled/simulated operations, and used sim output to build linear regression model that drove workforce management decisions on 4.2K jobs
• As 3-person team lead for a project affecting 509 jobs worth $38M, decided to build process flow of a local office versus travelling and extrapolated that work flow Air Force wide, saved $12K in travel costs
• Developed Excel VBA decision support tool that modeled 21 core logistics work flow processes affecting all personal property being shipped for Air Force families globally; justified 557 jobs valued at $4.3M
• During a 30 day deployment, implemented VBA-based tools to manage and analyze big data outputs from 24/7 war-game simulations--provided daily visualizations directly to the senior Air Force officer in Korea
• Displayed emotional leadership by aiding family of a fallen teammate; ensured swift and accurate delivery of benefits and belongings and tactfully informed family on legal matters over 4 month period
Graduate Student – Operations Research USAF (AFIT)
August 2012 – April 2014
• Thesis Research: Developed linear/integer programming optimization model and implemented with Excel Visual Basic/LINGO Solver tools; research helps ensure minimal placement of notional vehicles (planes, trains and trucks) and optimal scheduling to achieve global military logistical needs at the lowest cost; United States Transportation Command implemented model in 2015 with potential savings in the billions
EDUCATION
AIR FORCE INSTITUTE OF TECHNOLOGY Dayton, OH
Master of Science in Operations Research, March 2014
UNIVERSITY OF TAMPA Tampa, FL
Bachelor of Science in Mathematics, May 2012
RECOGNITION AND AWARDS
• 2019: US Air Force Analytic Team of the Year - stratified as #1 of 5 analysts on winning team
• 2018: Operations Analyst of the Year - selected as the top analyst among 33 high-caliber peers
• 2015: Unit Officer of the Quarter (1st and 2nd Qtr) - selected among three officer peers
• 2014: Air Force Personnel Center Modeling and Simulation Team of the Year - member of team