Ryan Andrews

Experience

• 

  University of Michigan

  Sept 2021 - now

  -Directed on-site operations across three facilities totaling 266,000 square feet, overseeing average daily foot traffic of 5,000 individuals and supervising a team of six staff members to delegate over 80 daily tasks.-Facilitated a seamless transition to a new facility by organizing and conducting three comprehensive staff training sessions, demonstrating effective leadership, adaptability, and ability to cultivate high-performing teams.

  • Building Supervisor

    Dec 2021 - now

  • Membership Services Assistant

    Sept 2021 - Dec 2021
• 

  Stryker

  May 2023 - Aug 2023

  Supply Chain Intern

  -Spearheaded the Daily Production Scheduling (DPS) Project, engaging senior management and 30+ team members to identify operational pain points and implement tailored solutions.-Implemented a comprehensive planning workbook for the DPS Project, leveraging Excel Solver and VBA to utilize linear programming for optimized decision-making and addressed challenges like accurate throughputs, staffing and component shortage navigation, and production prioritization based on inventory constraints.-Streamlined depot-wide communication through the daily execution of the Inventory Morning Reports, leveraging Excel, Power BI, and SAP, and presented the information daily to senior management.-Maintained the precision of inventory data through daily Posting Changes in SAP EWM. Show less

• 

  Lockheed Martin

  May 2024 - Aug 2024

  -Expedited onboarding and eased team transitions by creating a user-friendly and interactive XML documentation directory, encompassing 5,250 lines of HTML code.-Analyzed and risk-assessed data from multiple battalions, generating a master Excel sheet with 2,847 lines using advanced functions, enhancing team efficiency in identifying potential issues in critical systems.-Contributed to the development of an Interactive Electronic Technical Manual (IETM), ensuring accuracy through hands-on component installation and technical collaboration with diverse team members.-Performed data validation using SLICwave and Haystack to ensure database consistency. Show less

  • System Integration/Test Engineer Intern

    Jul 2024 - Aug 2024

  • Sustainment Engineer Intern

    May 2024 - Jun 2024
• 

  General Motors

  Aug 2024 - Dec 2024

  Senior Design Consultant - Purchasing Strategy Optimization

  -Collaborated with General Motors Global Purchasing and Supply Chain to develop an Optimized Shipping Container Pricing Tool as part of a senior design capstone project.-Projected 16% and $39.5 million in savings over the next 3 years by identifying and achieving cost-saving targets.-Leveraged advanced statistical modeling to define data-driven cost targets based on historical data.-Created a custom VBA tool to automate complex data manipulation.-Designed a dynamic Power BI dashboard to visualize KPIs and targets, empowering strategic decision-making.-Achieved a top three finish at the IOE Senior Design Expo and received the highest grade distinction (A) in the capstone course. Show less