Gavin Turbett

Business Systems Analyst

Belleville, IL 62223

adjmou@r.postjobfree.com

313-***-****

Summary

Dedicated business systems analyst with experience leading teams, conducting training, managing updates, and end-user problem resolution. Collaborative Leader engaging with key stakeholders to ensure an efficient system implementation. Substantial experience achieving business goals and developing system processes. Adept at= creating training products to facilitate system implementation. Driven by deadlines and key performance indicators. Information Technology graduate with an academic background in Network Engineering, Information Security, Software Development, and Computer systems.

Work Experience

Plex Business Analyst

Spartan Light Metal Products - St. Louis, MO

February 2020 to December 2020

Interviewed users to identify areas for improvement in the Plex ERP system. Utilized user input to create specifications for system enhancements and changes. Created reports using T-SQL. Conducted a gap analysis in preparation for transition from Plex Classic to the Plex UX version. Hosted bi-weekly meetings to review open Plex-related projects.

Key Achievements:

Created menu used to predict and forecast tooling replacement requirements by type, program and location.

Created reports to:

oMonitor, identify and alert operations users to tools requiring preventative maintenance

oIdentify system changes requiring coordination between facilities

oIdentify user information requiring updates

Business Analyst

Auria Solutions, Ltd. - Southfield, MI

September 2017 to February 2020

Global lead for engineering functions in Plex and Teamcenter. Prolink administrator. Led the transition of engineering systems from Teamcenter and AS/400 to Plex. Led workshops integrating users from all disciplines. Collected user stories and requirements to define technical requirements. Translated data into workflows and menu configuration. Developed timing, test and recovery plans to support project implementation. Identify and manage implementation risks.

Key Achievements:

Led a global transition of engineering functions from Siemens Teamcenter to Plex

Defined engineering procedures to support manufacturing in two regions

Created comprehensive ECR workflows that integrated previously disconnected disciplines within the Auria organization

Improved efficiency by creating T-SQL based reports to automate important functions, such as volume calculation and purchase order confirmation

Conducted Engineering Change training for all system users in North America and the European Union

Senior Engineer (Business Systems)

International Automotive Components - Southfield, MI

March 2013 to September 2017

Monitored the functions of the Siemens Teamcenter Enterprise (Product Lifecycle Management) system to ensure proper functionality. Managed a global help desk, serving 832 users. Mentored system administrators in the EU and China. Developed and maintained documentation for system functions. Trained system users. Engaged stakeholders to create specifications for system enhancements. Collaborated with the developers to implement, create test plans for and conduct testing of system updates.

Key Achievements:

Streamlined efficiency within the help desk department upon hire by taking the lead in managing other system administrators and providing leadership in the understanding of the system

Addressed and resolved system issues globally (Europe, China, and India)

Facilitated over 120 companywide classes over a four-year period to train end users

Utilized JavaScript to enhance the team website to make it more interactive and useful

Account Manager

International Automotive Components - Southfield, MI May 2004 to March 2013

Spearheaded pricing negotiations and financial management of five full interior automotive programs, focusing on margin improvement. Led cross-functional team meetings to implement changes. Delegated to lead annual negotiations for raw material pricing and annual price LTA reductions for the customer group. Maintained knowledge of tooling and manufacturing technologies. Mentored other account managers in procedures and strategies.

Key Achievements:

Maintained a 16% profit margin for all programs managed under my leadership

Contributed to the increased positive NPV value and a 21% internal rate of return by negotiating price improvements and cost reductions

Took on the higher-level responsibility of negotiating both pricing reductions and material pricing corrections

Created a database application using visual basic to assist sales personnel in managing millions of dollars in tooling and annual part sales

Training Development Specialist II

Raytheon Technical Services Co - Fort Irwin, CA

January 1995 to January 2004

Designed, developed and facilitated presentations to teach field artillery tactics and techniques to battalion-sized units. Assisted in improving performance through training based on statistical data retrieved through mock battles. Training material was presented using PowerPoint presentations to convey data reports to unit leadership.

Key Achievements:

Lead a team of four staff members, in the creation of more than 500 multimedia presentations

Formally recognized for excellence by approximately 20 US Army field artillery Battalion

Commanders

Designed and developed interactive simulations to teach techniques for room-clearing and air space coordination

Received the Order of St. Barbara award, presented by the US Army’s Field Artillery Association for significant contributions to the field artillery community

Education

Bachelor of Science in Information Technology

Western Governors University 2017

Skills

Microsoft Excel (20+ years)

SQL (10+ years)

Leadership and Management (10+ years)

Process Improvement (10+ years)

Training Development (10+ years)

Engineering Principals (10+ years)

Software Development (7 years)

System Design (7 years)

Information Systems (6 years)

Project Management (7 years)

Workflow Management (4 years)

Business Process

Data Entry

Outlook

Sales

ERP systems

Microsoft SQL Server

Computer Networking

Java

Certifications and Licenses

Oracle Certified Associate, Java SE 8 Programmer

CIW Certified JavaScript Specialist

CompTIA Security+ce

CompTIA Network+ce

CompTIA Project +

CompTIA A+ce

Contact this candidate