Rayane Bangaly

- Transactional data recovery: Critical migration of stocks and orders; design of mapping and technical correlation rules between the source ERP and the target SAP configuration.

- Master Data Articles (MM) Expertise: Migration via Winshuttle of 6 types of articles (including HALB, ROH, and PIPE) with multi-view loading management; Master Data, Purchasing, Sales, Accounting, CCR, MRP, Storage Location, Work Preparation, and Classification.

- Production (PP) Objects Migration: Loading of technical data; Work centers, Routings, Bills of Materials, Production Versions.

- Data Quality & Self-Service: Design of control tools using Power Query and Excel formulas, allowing business users to validate and correct their data autonomously according to business rules.

- Technical reliability: Cleaning of source data and implementation of consistency checks before loading to ensure alignment with target system constraints and SAP configuration.

- Finance & Controlling (CO): Automation of Cost Center loading.

▪ **Development of a parts forecasting project for engine maintenance**, by designing forecasting models and algorithms to optimize procurement, anticipate stock levels, and reduce intervention times.

▪Design of data pipelines in Dataikuleading to the industrialization of business SQL tables, including:

• Tracking of parts flow between the company and subcontractors

• Management of engine parts nomenclature

• Monitoring of repair activities within factories

▪ Agile (Scrum) project management, resulting in the creation of a tool for monitoring repairs, subcontracting, and parts inventory.

▪ **Automation of processes in Dataiku**, reducing monthly operational workload for data preparation by 3 days.

▪Development of Power BI dashboardsutilizing multiple sources (Excel, JSON, SQL) with GDPR-compliant data models.

▪ **Automation of SAP entries via Winshuttle**, resulting in a reduction of 2 man-days per month on manual tasks.

▪Data quality control and validationto ensure reliable use in an industrial environment.

▪Gathering business needsfrom operational teams (logistics, production, finance) to guide data projects.

▪Management of a Green Belt projectstructuring the process for specifying data projects, using a DMAIC approach for continuous improvement.

▪ **Mentoring an intern**: technical support, skill development, project management.

▪Analysis of business needsfor a pricing grid industrialization project.

▪Design of a MySQL databasecentralizing pricing data.

▪Automation of pricing grid generationusing Python scripts.