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.
-
Manufacturing Staff Finance AnalystFord Motor Company May 2023 - PresentDearborn, Michigan, UsWork/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. -
Cap Launch Finance AnalystFord Motor Company Feb 2024 - May 2024Dearborn, Michigan, UsIn 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. -
Product Development Finance Analyst - 25My MaverickFord Motor Company Mar 2022 - Apr 2023Dearborn, Michigan, UsCFP 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. -
It Operations Finance AnalystFord Motor Company Feb 2021 - Mar 2022Dearborn, Michigan, UsCFP 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. -
Material Cost Finance AnalystFord Motor Company Oct 2019 - Feb 2021Dearborn, Michigan, UsCFP 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. -
Graduate Teaching AssistantNorthern Illinois University Aug 2017 - May 2019Dekalb, Il, UsUpdating Grades for students, assisting students who have questions about Economics, completing other Misc. Tasks given by my assigned Professor. -
Cafe Sales AssociateSam'S Club May 2016 - Jun 2016Bentonville, Arkansas, UsServing various food to customers, preparing pizza's for orders, and pizza's for take and bakes -
Student AssistantUniversity Of North Dakota Aug 2014 - May 2015Grand Forks, North Dakota, UsWorked 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
Stephen Ernst Education Details
-
Northern Illinois UniversityEconomics -
Northern Illinois UniversityEconomics -
Ritsumeikan Asia Pacific UniversityJapanese 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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial