About Narjisse
French
Native or bilingual
English
Native or bilingual
Experience
- Grande distributionProject ManagerRETAIL (LARGE RETAILERS)April 2017 - April 2018 (1 year)Project Manager for drive-through stores and transition to sales forecasts with the automatic ERP tool.
- Industrie pharmaceutiqueAnalystPHARMACEUTICALS INDUSTRYMay 2022 - Today (4 years)✅ Mission 1: Creation of an advanced manual allocation tool• Development of a dynamic Excel file, interfaced with exported ERP databases (orders, backorders, inventory)• Automation with Power Query to consolidate raw data into a synthetic weekly view• Generation of automatic pre-allocation via BO prorata by country/client• Implementation of specific arbitration rules (VIP > FIFO) using a configurable weighting matrix• Creation of an allocation file ready for warehouse import via Excel form + 2-click VBA script🧩 Result:• Regained control over stock distribution by sales teams• Reduction in processing time (from several hours to a few minutes)• Direct improvement in customer satisfaction and service level⸻✅ Mission 2: Post-ERP migration backorder projection toolContext: After a global ERP switch (S4/HANA migration), historical tools were removed, leaving teams without reliable visibility into flows.• Audit of new ERP data structures (analysis of fields: status, delivery class, plant, transit, GR)• Detection of a critical issue: some "in transit" lines had already been received ➤ creation of a "phantom inbounds" filter• Reconstruction of a complete flow logic by cross-referencing: orders, goods receipts, stock, delivery statuses• Development of a backorder projection engine under Excel, with automatic calculation of the actual net requirement• Automation of multi-source consolidation with Power Query• Clear visualization of supply/demand gaps via integrated dashboard📊 Result:• Realistic view of upcoming stockouts• Better anticipation for planning• Tool validated and adopted as EMEA benchmark by sales and logistics teams
- Industrie métallurgiquePlannerJune 2019 - June 2022 (3 years)🎯 Objective: Assist decision-making in a context of global shortage by ensuring data reliability and modeling Supply Chain constraints.✅ Construction of a multi-dimensional customer management tool• Automatic integration of data from SAP + manual files (orders, internal capacities, stock)• Dynamic calculation of delivery capacity per customer / per period• Implementation of a 3-month projection table: simulation of possible delays, anticipation of arbitration• Creation of an interactive Excel dashboard for immediate reading by planning/logistics teams⚙️ Techniques used:• Power Query for consolidation + automated cleaning• VBA for automating update cycles (via button or event)• Structuring of the file for simple use even by non-technical profiles📈 Results:• Time saved on customer reporting (daily → automated weekly)• Alignment of data between sales and operational teams• Reliable customer arbitration in a tight context
Recommendations
Be the first to recommend Narjisse
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Specialized Master's DegreeSkema Business School2018
Certifications
- Prince2Prince22018
- Green Belt Lean Six SigmaSix Sigma2018