Stephen Ernst

Stephen Ernst Email and Phone Number

Finance Analyst at Ford Motor Company @ Ford Motor Company
Stephen Ernst's Location
Canton, Michigan, United States, United States
About Stephen Ernst

Despite being just a Finance Analyst, I fully exercise my ability to be Agile/Adaptable, sticking my nose in variety of technology solutions such as Python, Alteryx, Microsoft 365 & PowerApps, & dabbling in Linux. My current focus has been the management of manufacturing cost data and designing cool innovative ways to manage, cut, and report out the information using Machine Learning as a support tool.

Stephen Ernst's Current Company Details
Ford Motor Company

Ford Motor Company

View
Finance Analyst at Ford Motor Company
Stephen Ernst Work Experience Details
  • Ford Motor Company
    Manufacturing Staff Finance Analyst
    Ford Motor Company May 2023 - Present
    Dearborn, Michigan, Us
    Work/Focus on supporting various Agile Workstreams:Modernization & management of the Supplier Recovery Dashboard.Creation of Support Tools for the Dashboard (PowerApp that is used to feed the SharePoint that supports the dashboard).Using and Finding unique ways of using the Ford LLM & Microsoft Co-Pilot to perform Automation, Generate Images, Create & Structure Alteryx Workflows.Development of an Updated Budget Process, and files for the standalone Stamping Plants. Supporting the greater Manufacturing Team with creating and managing changes and file improvements to our Budget Files that are used in the "Should Cost" Budget Process.(Former Duties)Day to day includes weekly consolidation of the weekly cost savings target progression, and preparation of the presented charts for the weekly war rooms (which is attended by the CEO & CFO on a monthly basis). Consolidation of the monthly Forecast, and investigation of the variances vs budget and prior forecast.Presenting monthly Cost information to the director of manufacturing.Preparation of ad hoc assignments to help drive the business.
  • Ford Motor Company
    Cap Launch Finance Analyst
    Ford Motor Company Feb 2024 - May 2024
    Dearborn, Michigan, Us
    In an effort to provide aid to our Plant team in need:Coordinating meetings with the Launch team to collect actuals and report out the teams budget performance. Created a method of tab improvements in the excel file in order to better summarize the information for everyone onsite to see. Creation of an Alteryx workflow to support the weekly management of the WAVE Tool which manages the cost save projects that were created and managed by the operations teams. Temporarily running the Weekly Cost Package for use in the teams weekly cost meetings. Process improvement for the C-Crew Man Power File for the management of the teams current on-roll working headcount for that day. Adhoc Work requests (such as pulling Weekly/Daily Scrap information) in order to help support the Operations team.
  • Ford Motor Company
    Product Development Finance Analyst - 25My Maverick
    Ford Motor Company Mar 2022 - Apr 2023
    Dearborn, Michigan, Us
    CFP Year 3 (Final):Successfully managed an operating team helping lead the vehicle from the 3rd Key milestone to Project Approval (resulting in a final Avg Vehicle EBIT above segment guideline and updated stretch target requested by leadership). Running and Interpreting Business Cases for the operating team to help drive the best decisions for the vehicle refresh. Managing the weekly cost changes of the program, & managing the Risks and Opportunities for the program.
  • Ford Motor Company
    It Operations Finance Analyst
    Ford Motor Company Feb 2021 - Mar 2022
    Dearborn, Michigan, Us
    CFP Year 2:- Managed Large Excel file for outstanding Liabilities and Purchase Obligations within IT Finance.- Eliminated complexity driven by work required by accounting system "Tririga" by moving highly process oriented work load over to GBS team in India to allow more time to support other team members. -Quarterly Presentation of Current Liabilities and Purchase Obligations List to both People Leader (Manager) and IT Finance Controller.
  • Ford Motor Company
    Material Cost Finance Analyst
    Ford Motor Company Oct 2019 - Feb 2021
    Dearborn, Michigan, Us
    CFP Year 1 - EPE - Managed multiple component BOM's for the Electric Powertrain on various Vehicles (21MY FHEV F150, 22MY F150 Lightning, 24MY F150 Lightning).- Aided in completing milestones for 3 different vehicles at a component level- Presented Financial Information to Engineering Supervisors/Managers for Approvals in Various Forums.
  • Northern Illinois University
    Graduate Teaching Assistant
    Northern Illinois University Aug 2017 - May 2019
    Dekalb, Il, Us
    Updating Grades for students, assisting students who have questions about Economics, completing other Misc. Tasks given by my assigned Professor.
  • Sam'S Club
    Cafe Sales Associate
    Sam'S Club May 2016 - Jun 2016
    Bentonville, Arkansas, Us
    Serving various food to customers, preparing pizza's for orders, and pizza's for take and bakes
  • University Of North Dakota
    Student Assistant
    University Of North Dakota Aug 2014 - May 2015
    Grand Forks, North Dakota, Us
    Worked in the Multicultural Student Services with the following duties:• Updated, maintained and kept record of the trafficking data for the center in case of emergency or if the director needed to see them.• Updated scholarships for the scholarship website (approx. 200 total, all updated in a week and a half worth of time).• Assisting Students and Guests with general customer service when asked.• Completing Misc. Tasks from the Director of Multi-Cultural Student Services.

Stephen Ernst Skills

Autocad Hand Drafting Photoshop Microsoft Office Powerpoint Research Microsoft Word Microsoft Excel Teaching Editing English

Stephen Ernst Education Details

  • Northern Illinois University
    Northern Illinois University
    Economics
  • Northern Illinois University
    Northern Illinois University
    Economics
  • Ritsumeikan Asia Pacific University
    Ritsumeikan Asia Pacific University
    Japanese Language And Literature

Frequently Asked Questions about Stephen Ernst

What company does Stephen Ernst work for?

Stephen Ernst works for Ford Motor Company

What is Stephen Ernst's role at the current company?

Stephen Ernst's current role is Finance Analyst at Ford Motor Company.

What schools did Stephen Ernst attend?

Stephen Ernst attended Northern Illinois University, Northern Illinois University, Ritsumeikan Asia Pacific University.

What skills is Stephen Ernst known for?

Stephen Ernst has skills like Autocad, Hand Drafting, Photoshop, Microsoft Office, Powerpoint, Research, Microsoft Word, Microsoft Excel, Teaching, Editing, English.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.