VHE2 Integration Engineer
RLE International

V801 Vehicle Integration role for the Interiors team (VHE2), supporting various engineering issues and reporting to management.
Developed numerous tracking documents to support the team and optimised ongoing workflows to enhance day to day operations. Helped with cross VHE metrics reporting in a developed Excel document supported with VBA scripts and with data architecture planning for a new multi-program Power BI report.
Supported teams in meeting CAD MCI completeness targets for UXV0 and then took on the role of tracking Recycling and Renewables content in ensuring suppliers met Ford's 20% renewables target for UXV1.
Developed a solution for extracting folders and files from SharePoint using VBA to extract the data into CSV and then a Python script to tag the files into categories using fuzzy matching ready for a searchable Power BI report, allowing the combination of multiple sites into one searchable location.
Developed numerous tracking documents to support the team and optimised ongoing workflows to enhance day to day operations. Helped with cross VHE metrics reporting in a developed Excel document supported with VBA scripts and with data architecture planning for a new multi-program Power BI report.
Supported teams in meeting CAD MCI completeness targets for UXV0 and then took on the role of tracking Recycling and Renewables content in ensuring suppliers met Ford's 20% renewables target for UXV1.
Developed a solution for extracting folders and files from SharePoint using VBA to extract the data into CSV and then a Python script to tag the files into categories using fuzzy matching ready for a searchable Power BI report, allowing the combination of multiple sites into one searchable location.
Key Achievement:
The set up and maintenance of the VHE2 metrics Excel, supporting the team with a VBA script for easy update ready for management reviews, saving the team set up time for daily reporting.