About Narjisse
English
Native or bilingual
French
Native or bilingual
Experience
- Pharmaceutical industrySupply chain analystMay 2022 - Today (4 years and 1 month)✅ Project 1: Development of an advanced manual allocation tool• Development of a dynamic Excel tool connected to exported ERP datasets (orders, backorders, inventory)• Automation using Power Query to consolidate raw data into a clear weekly summary view• Automatic pre-allocation generation using backorder prorata by country/client• Implementation of custom allocation rules (VIP > FIFO) using a configurable weighting matrix• Creation of an allocation file ready for warehouse import via Excel form + VBA script in just 2 clicks🧩 Result:• Sales teams regained control over stock allocation and distribution• Processing time reduced from several hours to just a few minutes• Direct improvement in customer satisfaction and service level⸻✅ Project 2: Backorder projection tool following ERP migrationContext: After a global ERP transition (migration to S/4HANA), legacy tools were removed, leaving operational teams without reliable visibility on supply flows.• Audit of the new ERP data structure (analysis of fields such as status, delivery class, plant, transit, GR)• Identification of a critical issue: some “in-transit” lines had already been received ➤ creation of a “ghost inbound” filter• Reconstruction of the full supply flow logic by cross-referencing orders, goods receipts, inventory and delivery statuses• Development of a backorder projection engine in Excel, automatically calculating the real net demand• Automation of multi-source data consolidation using Power Query• Clear visualization of supply/demand gaps through an integrated dashboard📊 Result:• Realistic visibility on upcoming stock shortages• Better anticipation for operational planning• Tool validated and adopted as a reference across EMEA by sales and logistics teams
- Metallurgic industrySupply chain PlanningMay 2019 - April 2022 (2 years and 11 months)🎯 Objective: Support operational decision-making during a global supply shortage by improving data reliability and modeling Supply Chain constraints.✅ Project: Multi-dimensional customer allocation & planning tool• Automated integration of SAP data + manual files (orders, internal capacities, inventory)• Dynamic calculation of delivery capacity by customer and by period• Development of a 3-month projection model to simulate potential delays and anticipate allocation decisions• Creation of an interactive Excel dashboard enabling immediate visibility for planning and logistics teams⚙️ Technologies used• Power Query for automated data consolidation and cleaning• VBA for refresh automation (button-triggered or event-based updates)• Structured file architecture designed for easy use by non-technical teams📈 Results• Significant time savings on customer reporting (from daily manual work → automated weekly updates)• Alignment of data between sales and operations teams• More reliable customer allocation decisions in a high-constraint supply environment
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
- Master degreeSkema business school2018Supply chain management
- Master degreeUniversité de Lille2026Management and international Trade
Certifications
- Green belt lean six sigmaSix sigma2018
- Prince 2Prince 22018