Freelancer profile translated to English.

Description

I have over 20 years of experience in consulting and managing Data & Analytics projects. PMP certified, I am involved in various aspects of projects:

- Structuring

- Methodology and audit

- Steering

- Change management

- Delivery

- Project management

With a strong technical background, particularly in setting up BI systems, I advise on architecture/tool choices, design, data modeling, ETL flows, KPIs, and dashboards.

Industry field of expertise

Languages

French
Native or bilingual
English
Fluent
Spanish
Conversational

Workplace preferences

Can work on-site

Paris (up to 50km)

Lapeyre
Data & BI Expert
RETAIL (LARGE RETAILERS)
March 2020 - Today (6 years and 4 months)
Aubervilliers, France
Consulting, client support, and execution on the following topics.

1. Snowflake AI Agent - Quote Analysis
- Agent for COMEX to steer quote transformation
- Semantic layer construction
- Facilitating business workshops

2. AI Analysis of Google Customer Reviews on Snowflake
- Extracting the cause of dissatisfaction from each customer review, enabling targeted action plans for Lapeyre network stores
- Prompt engineering
- Benchmarking/Selection of the best LLM meeting performance/cost/processing time criteria
- Microstrategy Dashboard

3. "Vertical Margin" Project on Snowflake
- Objective: automate the calculation of vertical margin, from factory to store sales, Lapeyre being both a manufacturer and a distributor.
- Conducted business workshops with administrative and financial managers (RAF) of factories, controlling managers, and COMEX members
- KPI specification
- MicroStrategy dashboard creation
- Data processing on Snowflake / Streamlit
- Support for testing and production deployment

4. "Data Platform" Project: Oracle -> Snowflake Migration
- Contribution to the scoping study for Oracle to Snowflake migration
- Participation in technical/functional workshops
- Architecture choices
- POC realization
- Platform implementation + Snowflake certification
- Design and implementation of a data migration tool

5. Migration of the BI system from Business Objects to Microstrategy:
- Inventory of existing systems
- Rationalization
- Mock-up proposals
- Steering/execution of development
- Business Analysis Support with Controlling, Supply Chain, and Marketing departments

6. Lapeyre "Carve-out": impact of Lapeyre's separation from the Saint-Gobain Group on the decision-making system
- Dependency review
- BI system switchover plan

7. Data Warehouse Migration from Oracle 10g to 19c
- Cut-over preparation / rollback plan
Project Management SAP Business Objects Snowflake Microstrategy LLM
Lapeyre (Groupe Saint-Gobain)
Project Manager & Account Manager
RETAIL (LARGE RETAILERS)
April 2011 - January 2016 (4 years and 10 months)
Aubervilliers, France
Enterprise BI Platform
- Enterprise Data Warehouse evolution program (addition of functional domains: customer orders, portfolio, commercial activity, delivery notes, installation projects)
- ERP migration alignment program: impact study, BI architecture, design
- COGNIZANT project management: resources, budget, planning
- Functional scoping and Business Analysis Support
- Architecture
- COGNIZANT team: 3 onsite + 10 offshore
Technical environment: SAP Business Objects, SAP BODS, Oracle
BI Roadmap SAP Business Objects SAP BODS BI Architecture Oracle
ENGIE SA
Transition Manager
ENERGY AND UTILITIES
July 2019 - March 2020 (8 months)
Saint-Ouen, France
Steering the transition of data center outsourcing:
- Scope: 2000 servers / 600 applications
- Project structuring: implementation of RACI, planning, governance, and steering indicators
- Implementation of steering tools: action tracker, flash report, risk monitoring
- Facilitating project committees and reporting to steering committees
Team Management Change Management Reporting Project Management