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

Narjisse B.

Expert Excel Automation | VBA | Power Query⚡️

€549/day
Lille, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Narjisse

💼 You know that file everyone uses but no one wants to take over when its owner leaves?

The one with dozens of tabs.

The one that's been updated manually for years.

The one that wastes hours every week but no one has time to overhaul.

This is often where the biggest opportunities for time savings and productivity lie.

My job is to solve these kinds of problems.

I design custom Excel solutions that automate repetitive tasks, ensure data reliability, and simplify daily operations for teams.

The goal isn't to create another Excel file.

The goal is to allow you to open a file, click a button, and get in seconds what previously took hours of work.

Using VBA, Power Query, and my operational experience, I transform complex manual processes into simple, fast, and reliable tools.

Whether you work in Supply Chain, Purchasing, Sales, Finance, Operations, or any other function that uses Excel daily, I adapt to your business reality to build a truly useful solution.
I also train your teams.

🔧 Examples of deliverables

• Custom Excel tools: stock projection, MRP, PSI
• Dashboard automation (KPI, Revenue, Customers, Orders…)
• Inventory files and stockout tracking
• One-click multi-source consolidation (CSV, ERP, SAP…)
• Automatic or manual stock allocation
• Automatic generation of emails with attachments/screenshots
• Dynamic dashboards
• Data cleaning, structuring, and transformation with Power Query
• Intuitive Excel interfaces for non-technical users and training

🎯 If you've ever thought: “This task should be automatable,” there's a good chance I can help.
  • French

    Native or bilingual

  • English

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Grande distribution
    Project Manager
    RETAIL (LARGE RETAILERS)
    April 2017 - April 2018 (1 year)
    Project Manager for drive-through stores and transition to sales forecasts with the automatic ERP tool.
    Automation Supply Chain Microsoft Excel Power Automate Inventory
  • Industrie pharmaceutique
    Analyst
    PHARMACEUTICALS INDUSTRY
    May 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 tool

    Context: 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
    VBA Power Query Process Optimization Resource Allocation Decision Support Tool
  • Industrie métallurgique
    Planner
    June 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

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

Education

  • Specialized Master's Degree
    Skema Business School
    2018

Certifications

  • Prince2
    Prince2
    2018
  • Green Belt Lean Six Sigma
    Six Sigma
    2018

Skill set

Categories