Brian Bartell Email & Phone Number

Dearborn, Mi

• Using Autodesk VRED, built/updated Virtual Reality models for Ford car / truck programs during the design phase of vehicle development• Supported and/or conducted VR reviews as required

Livonia, Mi

• Built simulation models of powertrain assembly workstations to analyze manufacturing feasibility and assess Bill of Process (BOP) compliance.• Piloted Virtual Assembly involvement with Ford NA Axle programs, modifying established workflows as required.• Conducted Virtual Builds to review program issues related to: product, process, labor optimization, safety, tooling, layout and ergonomics.• Created a macro to automate GSPAS Assembly Process data entry into the PTME Scorecard.

Redford, Mi

• Created the initial framework to kick-off a program, including: creation of the initial prototype Bill of Materials (BOM) for BIW sheet metal parts / assemblies, creation of cost estimation models, and management of supplier quotes.• Managed the manufacturing development of prototype end-item sheet metal parts/assemblies for Ford Motor Company• Organized end-item quality reviews with both suppliers and customers• Created an RFQ Tracker macro to manage RFQ’s (quotes) received via the Ford WebQuote system. Ford Purchasing cited an improved average quote response time from 37 days to 5; an improvement of 86% (32 days).• Created an Excel macro to automate the previously manual process of updating internal part order tracking documents with the latest Ford GPIRS part order information, greatly improving both quality and timing.• Created and implemented Cost Summary macro to import and compile supplier quotes into a single document. This has improved the decision making process when selecting from quotes between several different suppliers, while also providing a past history.

Dearborn, Mi

• Managed the development of exterior trim components (underbody shields, wheel liners, air deflectors)• Drove the Product Development process (design, development, validation, and launch) of exterior trim components, achieving compliance of requirements; SDS, design rules, FMVSS, etc• Led and resolved all financial and part-related issues with applicable tier 1 suppliers

Redford / Dearborn, Mi

• Assessed Ford future-model Underbody and Front Structure parts to identify areas that would require engineering (prototype bridging part development or modified carryover part) to mate properly to a current-model Upperbody• Managed successful development of Ford M1 bridging parts/assemblies through concept, design, manufacturability/stamping feasibility (FEA), and product launch• Interfaced with Ford J1 Engineering (Structures, Chassis, HVAC, Electrical, Cooling, Safety, etc), through part development to ensure that the bridging part meets M1 testing requirements• Organized customer/supplier meetings to facilitate issue resolution• Facilitated communication between various departments within TDM (M1 Team, Program Mgmt, WIM (Weld) Group, Fixtures Group)• Created and distributed M1 prototype bridging part Bill of Material (BOM)• Entered/released parts into AVBOM / WERS• Interfaced with Ford Purchasing Analysts (PPM) to ensure successful part ordering• Supported the M-1 Prototype Build at the Ford Pilot Plant (NMPDC)

Dearborn, Mi

• Acted as a liaison between Ford Craftsmanship and Dimensional Control (DCD) to record and manage fit & finish targets/specifications within a web-based data management system (E2ks)• Worked with cross-functional teams (Manufacturing, Studio, Engineering) to identify and escalate issues• Drove issue resolution by modifying the product (locating strategy, GD&T), process (Assembly Bill of Process), or adjusting the targets/specifications• Created an Excel macro to automate DPA3 QOS metric creation

Redford, Mi

• Created and maintained models representing the assembly process, tolerances, and CAD data used for the virtual assembly of an automobile using VisVSA software• Created virtual simulations that predicted possible variations, and potential issues, in the manufacturing process• Supplied Ford DCD (Dimensional Control) with reports that included a prioritized list of contributors and potential solutions to any issues before they are encountered in a physical build• Performed CAE / FEA swept-volume analyses to verify the robustness and performance of components and assemblies• Updated and provided support for an Excel macro to automate report documentation for all required Ford DVA interfaces• Created an Excel macro to combine the workload of every DVA vehicle program into a single document, allowing management a single-source document to track the department’s workload

Redford, Mi

• Simulated Final Assembly manufacturing plant layout and operations using Product Lifecycle Management (PLM) software (Process Designer / Simulate) by Tecnomatix / Siemens• Presented simulations at Ford Virtual Build Events• Performed static hand and posture ergonomic checks to verify the feasibility of part installs• Worked with Ford Manufacturing (VOME) and KUKA to simulate a $3.7 million dollar Frame Flip tooling proposal for the Kentucky Truck Plant• Created an Excel macro to combine all Lessons Learned (TGR/TGW) from each department into a single document• Created an Excel macro that matched the Plant Process with quality checklists to provide an all-in-one solution when assessing checklists as the vehicle is being virtually built-up

Rochester Hills, Mi

• Designed prototype gears and sprockets for engine timing assemblies using AutoCAD• Checked Unigraphics and AutoCAD prints for accuracy• Worked alongside Design Engineers to design the component within required specifications

Dearborn, Mi

• Developed coordinate systems within vehicles to prepare them for Federal Motor Vehicle (FMVSS) 201U Interior Head Impact Testing (IHI) Testing• Utilized a laptop with Faro CAM2 and AutoCAD software, along with a manual CMM• Communicated between engineers/suppliers to prepare the vehicle correctly for the required test• Utilized MS Excel, along with macros, to automate calculations and speed completion time• Developed various manuals to quickly familiarize beginners to the IHI / Safety Lab• Created an Excel workbook to track the Automotive Safety Centers $10 million dollar budget