Project Lead

Job Summary

We have a resource request for resource in France location. The start date for the resource could be mid October. Below are the details -

Current Situation

PITAGOR is a 28-year-old legacy application used by TotalEnergies as the backbone of refinery valorisation. It supports planning, scheduling and Mass balance for the 7 site refineries of TotalEnergies

Challenges

• PITAGOR is an on-premises solution hosted on the main network.
• Over the years, refinery teams have built many Excel/VBA tools directly connected to the PITAGOR database.
• Estimated volume: ~250 Excel files across seven refineries.
• The exact inventory, complexity, ownership, and transformation effort are currently unknown.
• These files are business-critical and widely used by refinery engineers.

Objective of the Requested Resource

The resource should support an assessment and transformation initiative focused on the Excel ecosystem surrounding PITAGOR.

Phase 1: Discovery & Assessment

• Identify and collect existing Excel files from refinery sites.
• Engage with business users and site contacts.
• Analyze Excel/VBA solutions and database dependencies.
• Document functionality, usage, complexity, and business criticality.
• Assess compatibility with the future Archimed solution.
• Estimate transformation effort and migration approach.

Phase 2: Transformation

• Support redesign and modernization of the Excel tools.
• Adapt Excel files to work with Archimed.
• Identify opportunities to migrate reporting use cases to Power BI where appropriate.
• Continue implementation activities after the assessment phase to ensure knowledge continuity.

Mandatory Skills

Language

• French (mandatory)
• English (mandatory)

Technical Skills

• Advanced Microsoft Excel
• Advanced VBA development
• SQL and database analysis
• Ability to understand and reverse-engineer complex spreadsheets
• Requirements gathering and documentation
• Understanding of the Refinery process

Preferred Skills

• Power BI knowledge
• Data migration experience
• Application modernization experience
• Stakeholder management
• Ability to work directly with engineering users

Location & Travel Expectations

The candidate should ideally be France-based, as site visits may be required.

Potential refinery locations include:

• France (majority of sites)
• Belgium
• Germany
• Limited likelihood of travel to the US site

Experience: 5-10 years

Key Responsibilities:

• Inventory and assess all Excel/VBA applications connected to PITAGOR.
• Analyze SQL/database dependencies.
• Engage refinery stakeholders in French and English.
• Define migration and modernization strategy.
• Implement transformation activities during the Archimed rollout.
• Support Power BI migration opportunities where relevant.

Key Deliverable

A comprehensive assessment delivering:

• Inventory of Excel tools
• Business criticality classification
• Technical complexity assessment
• Dependency mapping
• Migration recommendations
• Effort estimates
• Transformation roadmap aligned with the Archimed program

Key Responsibilities

Experience: 5-10 years

Key Responsibilities:

• Inventory and assess all Excel/VBA applications connected to PITAGOR.
• Analyze SQL/database dependencies.
• Engage refinery stakeholders in French and English.
• Define migration and modernization strategy.
• Implement transformation activities during the Archimed rollout.
• Support Power BI migration opportunities where relevant.

Skill Requirements

Mandatory Skills

Language

• French (mandatory)
• English (mandatory)

Technical Skills

• Advanced Microsoft Excel
• Advanced VBA development
• SQL and database analysis
• Ability to understand and reverse-engineer complex spreadsheets
• Requirements gathering and documentation
• Understanding of the Refinery process

Preferred Skills

• Power BI knowledge
• Data migration experience
• Application modernization experience
• Stakeholder management
• Ability to work directly with engineering users

Other Requirements

Pl refer above