Ryan Andrews Email & Phone Number

Fort Worth, Tx, Us

Warren, Michigan, United States

-Collaborated with General Motors Purchasing and Supply Chain to develop an Optimized Shipping Container Pricing Tool as part of a senior design capstone project, targeting a 10% sourcing cost reduction and 20% increase in pricing accuracy for 50+ commodities.-Analyzed historical data from US, Canada, and Mexico to identify cost drivers, improving container sourcing decisions with predictive analytics and optimizing supplier negotiations.-Integrated Power BI with Excel for real-time data visualization, providing GM with actionable insights to enhance supply chain efficiency and support decision-making.

Ann Arbor, Michigan, United States

-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 and adaptability.

Ann Arbor, Michigan, United States

Grand Prairie, Texas, United States

-Conducted 134 launch tests, assessments, and comprehensive data analyses across two projects.-Achieved an estimated 80% reduction in data review times by developing and implementing a VBA script in Excel to automate data organization and generate analytical charts, enhancing efficiency in the validation process.

Grand Prairie, Texas, United States

-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.

Portage, Michigan, United States

-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 for optimal decision-making and addressing 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.

Minor, Business Administration

Bachelor Of Science In Engineering - Bse, Industrial And Operations Engineering, 3.50/4.0

High School Diploma, 3.97/4.0

"The Battle Creek Area Mathematics and Science Center (BCAMSC) is a unique, exciting partnership with 15 school districts, offering.

High School Diploma, 3.97/4.0

Activities and Societies: Drumline (Captain), Cross Country (Captain), Track and Field, Link Crew, National Honor Society