Boudjadja Mohand

R&D DSIS Digital Solutions Info System: Software Developer, Data Analysis & Processing

Mission Description:

● Develop Google Sheets/Excel applications (Workhorses) coded in JavaScript (AppScript) and VBA to digitize the budget and MTP process.

o Identify, understand, and analyze client needs

o Design application architecture

o Test applications

o Train users (by implementing a technical guide)

o Provide technical support

● Data Analysis and Processing

Project Details:

● Develop Budgetary tools based on a Google Sheet to define the annual budget and the 5-year MTP.

● Translate a Python code (Anaconda) to AppScript to migrate from Excel to Google.

● Develop a LED selection and calculation tool based on a Physical Model (optical, electrical, and thermal) to calculate fluxes, electrical power, temperature, color codes, etc.

● Develop a data analysis and aggregation tool.

● Data Analysis and Processing.

● Create macros (write new code).

● Make code modifications, maintenance.

● Implement significant enhancements.

● Perform iterative updates.

● Bug fixing.

●Technical Environment: JavaScript (AppScript, TypeScript), VBA, Python, Macros, Google Spreadsheet, Excel, Advanced Formulas, Pivot Tables, Charts, Data Studio, BigQuery, SQL

Calibration Department: VBA Developer

Mission Description:

● Develop calibration tools (VBA Excel) to support Safety and Diag teams in their vehicle validation activities.

o Analyze and gather client needs

o Develop tools

o Documentation (technical, user, ...)

o Maintenance and improvement of tools: VBA / Excel

Project Details:

● VBA Technical Referent (Responsible for calibration tools for the Carrière/Poissy and Belchamp sites).

● Automation and development of a Safety level 2 tool.

● Automation and development of a calibration tool (comparison of Paco (XML file) and matrices (Excel file) between different projects, engines, branches).

● Automation and development of a KPI matrix tool (track performance indicators).

● Automation and development of a planning tool (data processing, etc.).

● Create macros (write new code).

● Make code modifications.

● Evolving maintenance.

● Implement significant enhancements.

● Perform iterative updates.

● Bug fixing.

Technical Environment: VBA, Macros, Excel, MS Project, Power Apps, Power BI, Advanced Formulas, Pivot Tables, Charts

R&D System Engineering Service: VBA Developer

Mission Description:

● Develop a fuel circuit sizing tool.

The objective is to create an Excel application coded in VBA (Visual Basic for Applications) to validate engine manufacturer requirements (pressure drops, pressures, diesel speed, etc.) during the design phase.

Project Details:

● Understand the guidelines and specifications of different engine manufacturers.

● Identify the impact of each element and component of the fuel line.

● Model the application based on the fuel system of the AXION 870-800 tractor.

● Create the Excel application (in VBA) to simulate/evaluate the impact of the chosen components and architecture.

● Correlate the application on a tractor.

●Technical Environment: VBA, Macros, Excel, 3D Live, CATIA V5