Aaron Walker Email & Phone Number

Cannon Beach, Or, Us

Vacaville, California, United States

• Performed data analysis and financial modeling techniques to improve future squadron sales of air show merchandise.• Collected and analyzed aircraft damage data resulting in publication rewrites to improve operational loading procedures.• Led training for 22 AS NASA missions, certified five primary loadmasters, 12 observers and five winch operators to increase manning for AF only Space Containment Transport System Squadron by 66%.• Produced C-5M's first M052 training and led integrated tactical mission brief for ATSO scenario requirements.• Utilized One Note program to combine missions, scheduling, training, currency, and forms, eliminating redundancies/errors by 20%.• Managed and oversaw $20,000 in financial transactions as booster club treasurer ensuring accurate record-keeping.

Vacaville, California, United States

• Prepared quarterly budget reports for commander summarizing current expenses and forecasting future financial needs.• Collected equipment pricing data resulted in securing 20% additional funding through a comprehensive budget proposal. • Eliminated redundant records systems and consolidated in one product reducing 15% excess man hours. • Increased squadron supply funds $10,000 by successfully streamlining quarterly expenses through financial modeling.• Conducted critical loadmaster training of over 70 students on aircraft weight and balance, systems, restraint methods, and emergency equipment and procedures.• Headed loadmaster continuation training program of 130 loadmasters emphasizing Air Mobility Command hot topics and critical thinking techniques when loading.• Provided in-depth instruction, assessed, and corrected student loadmaster performance in aircraft systems and loading operations.

Vacaville, California, United States

• Provided real-time mission updates to Squadron leadership, alerted/tracked 425 operations and training flights.• Airlifted USN SEAL assault vehicle worth $688M and an eight man seal team• Airlifted USMC missile defense system consisting of three tracking radars which improved early warning ability• Coordinated and supervised the airlift of NASA’s James Webb space telescope valued at $9B• Non-Commissioned Officer in Charge, overseeing POTUS movement of 78 member extraction team and 16 armored vehicles

Vacaville, California, United States

• Utilized advanced Excel functions such as VLOOKUP, INDEX-MATCH, and array formulas to streamline financial data analysis and reporting, reducing manual processing time by 15%.• Leveraged Power BI to automate data consolidation and reporting processes, cutting down the manual data preparation time by 10% and enhancing data accuracy.• Developed comprehensive FP&A models to forecast revenue, expenses, and cash flow for strategic planning.• Created datasets to analyze training operations efficiency across four flying squadrons, driving data-driven decision-making.• Developed cost/price proposals and expenditure requests by managing the completion, documentation, and compliance verification of training for USAF personnel.• Built and maintained Standard Operating Procedures (SOPs) for squadron training operations, ensuring consistent and effective processes.• Led the development and delivery of new tactics training programs, resulting in enhanced operational capabilities.• Partnered with engineering teams to implement new training protocols, integrating automation tools that enhanced compliance tracking and planning.• Collected, analyzed, and presented monthly and quarterly financial data for over 200 personnel, providing actionable insights to leadership.

San Francisco, California, United States

• Utilized Power BI to create mock earnings call presentation for 20-person team.• Developed regression tables in Microsoft Excel to compare dividend and stock prices of multiple firms.• Created Microsoft Excel product with pivot tables to model sales data, account type, and customer type across 5 U.S. regions.• Produced Tableau product to break down company income statement, cash flow, and equity data for easier comprehension.• Created Power BI product based on Uber data set to forecast future data and assist with scalability of the company.• Utilized Tableau to forecast supply and demand of various products in the next fiscal year.

Bachelor Of Science - Bs, Finance, 3.8

Associate'S Degree, Aviation/Airway Management And Operations, 3.8

High School Diploma