You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Narjisse B.NB

Narjisse B.

Excel Automation Expert ⚡ VBA | Power Query

633 €/jour
Lille, FR
8-15 ans

Délai de réponse moyen : 1h

À propos de Narjisse

💼 Somewhere in your company, there is probably a spreadsheet everyone depends on and nobody wants to touch.

If that file breaks, reporting stops.
If its owner leaves, nobody knows how it works.
And every week, hours are spent updating it manually.

That’s not an Excel problem.

It’s a business process problem.

I help companies turn fragile, time-consuming spreadsheets into reliable tools that save time, improve visibility, and support better decisions.

My goal isn’t to create yet another spreadsheet.

My goal is to help you open a file, click a button, and get in seconds what used to take hours.

Combining Excel, VBA, Power Query, and real-world operational expertise, I transform complex manual processes into simple, reliable, and scalable tools.

Whether you work in Supply Chain, Operations, Finance, Sales, Procurement, or any function that relies on Excel, I take the time to understand how your business works and build solutions that fit your reality.
I am also training your teams.

🔧 Examples of Deliverables

• Custom Excel tools: inventory forecasting, MRP, PSI
• Automated dashboards and KPI reporting
• Inventory management and stock shortage tracking
• One-click data consolidation from multiple sources (CSV, ERP, SAP, databases…)
• Automatic or manual stock allocation tools
• Automated email generation with attachments and screenshots
• Dynamic dashboards for business users
• Data cleansing, transformation, and structuring with Power Query
• User-friendly Excel interfaces designed for non-technical teams, training

🎯 If you’ve ever looked at a repetitive task and thought, “There has to be a better way to do this,” there’s a good chance I can help
  • Anglais

    Bilingue ou natif

  • Français

    Bilingue ou natif

En télétravail uniquement
Travaille majoritairement à distance

Expériences

  • Pharmaceutical industry
    Supply chain analyst
    mai 2022 - Aujourd'hui (4 ans et 1 mois)
    ✅ 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 migration

    Context: 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
    VBA Microsoft Excel automation Allocation Supply chain
  • Metallurgic industry
    Supply chain Planning
    mai 2019 - avril 2022 (2 ans et 11 mois)
    🎯 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

Recommandations

Soyez le premier à recommander Narjisse

Contribuez à la réussite de ce freelance en partageant votre expérience de collaboration avec lui.

Ces profils de freelance correspondent également à vos critères

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Formations

  • Master degree
    Skema business school
    2018
    Supply chain management
  • Master degree
    Université de Lille
    2026
    Management and international Trade

Certifications

  • Green belt lean six sigma
    Six sigma
    2018
    Lean management
  • Prince 2
    Prince 2
    2018

Compétences

Catégories