Ryan Morgott
Consultant at Spectrum Consulting Group- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Experience
-
Spectrum Consulting Group
-
United States
-
Business Consulting and Services
-
1 - 100 Employee
-
Consultant
-
Jan 2022 - Present
• • Supported client engagement with large utilities company based in Michigan, in providing performance management recommendation by conducting internal analysis and recommending key performance indicators.• Assisted in the expansion efforts of a private, nation-wide transportation company by analyzing data collected through contacts of government entities using R, Tableau, and Excel to create predictive market sizing functions.• Participated in annual consultant training, which consisted of modules on Excel, PowerPoint, communication, and problem solving to ensure preparation for client facing engagements.
-
-
Business Analyst
-
Oct 2021 - Dec 2021
-
-
-
Johnson & Johnson
-
United States
-
Hospitals and Health Care
-
700 & Above Employee
-
Supply Chain Data Management and Engineering Co-Op
-
Dec 2021 - Aug 2022
• Designed and managed a project using a Master Data Management System, NextGen Informatica, to correct over 500,000 product/material data errors through data extracts manipulated in Excel and imported front-end. • Utilized SAP Information Steward to monitor and edit business rules and automated tasks to assist the business in maintaining accurate data. • Collaborated with the ICA E-Board to facilitate over 10 professional, credo, and social events for over 100 virtual Co-Ops between multiple offices to enhance professional networks and skills. • Constructed and presented 2 educational sessions: Windows & Microsoft Office Toolkit and Resume & Case Workshop, each event with over 50 other Co-Ops from multiple offices in attendance. • Received Lean Six Sigma Yellow Belt Certification through training and applying process improvements to various projects.
-
-
-
Integrated Systems Design (ISD)
-
United States
-
Automation Machinery Manufacturing
-
1 - 100 Employee
-
Mechanical Engineering Intern
-
Dec 2019 - Aug 2021
• Worked alongside the Head Mechanical and Design Engineer to improve on Automated Storage and Retrieval Systems (ASRS). • Oversaw the assembly of multiple ASRS machines, now installed in the production plants of Tier 1 automotive suppliers. • Developed and implemented a quality assurance tracking system for the ASRS machines using Virtual Basic for Application (VBA) on Microsoft Excel. • Worked alongside the Head Mechanical and Design Engineer to improve on Automated Storage and Retrieval Systems (ASRS). • Oversaw the assembly of multiple ASRS machines, now installed in the production plants of Tier 1 automotive suppliers. • Developed and implemented a quality assurance tracking system for the ASRS machines using Virtual Basic for Application (VBA) on Microsoft Excel.
-
-
-
Franklin Hills Country Club
-
United States
-
Recreational Facilities
-
1 - 100 Employee
-
Golf Services
-
Apr 2017 - Aug 2019
• Maintained 4 separate golfing practice areas. • Ensured the organization, safety, and cleanliness of the 1,000+ members’ golf belongings as well as 60 golf carts. • Built networking skills by establishing strong relationships across a diverse group of members in the Detroit Metropolitan Area. • Maintained 4 separate golfing practice areas. • Ensured the organization, safety, and cleanliness of the 1,000+ members’ golf belongings as well as 60 golf carts. • Built networking skills by establishing strong relationships across a diverse group of members in the Detroit Metropolitan Area.
-
-
Education
-
Michigan State University
Bachelor of Science - BS, Applied Engineering Sciences -
North Farmington High School
High School Diploma