Guillaume Salvan

I am Product Manager Client Database in the Digital department of CHANEL Europe, optimizing customer insights by integrating and analyzing data from various sources to improve CRM targeting and analytics. My expertise includes understanding the luxury industry and the Lakehouse data organization paradigm to be able to provide different teams with data aggregation such as customer segmentation or predictive scores, while using the Scrum methodology.

Team: PO, Data Engineers, Data Analyst

Clients: CRM Team, Ad-hoc Analysis, Advanced Analytics, Data Viz

Key Responsibilities:

✅ Integrate data from multiple sources (POS, PIM, e-commerce, in-store app, partners) to enrich the customer database.

✅ Create data aggregates for segmentation, revenue by customer, division, product type, etc.

✅ Provide data to CRM (Adobe Campaign), Ad-hoc Analysis (Azure SQL), Advanced Analytics (Azure ML), Data Viz (Power BI).

✅ Develop roadmap based on the priorities of 3 Divisions: Fragrance & Beauty (F&B), Fashion (FSH), Watch & Fine Jewelry (WFJ).

✅ Identify and prioritize CRM needs using "Discovery Card" and "RICE" methods.

✅ Write Epics & US: "As [persona], I want [action] so that [goal]."

✅ Manage product backlog and organize co-creation workshops.

✅ F&B: Integrated sales data from wholesalers and "bill scanning" in the Chanel in-store app.

✅ FSH: Developed a conversion score using "random forest" to boost Ready-to-Wear.

✅ WFJ: Analyzed ring stacking trends to target key customers.

✅ Participated in agile ceremonies: Discovery, Daily, Grooming, Sprint planning, Review, Retrospective.

✅ Created clear nomenclature for backlog and documentation.

✅ Developed a Discovery Card for needs gathering and alignment.

✅ Automated delivery schedules in Confluence with linked Delivery Notes.I am Product

I contributed to the development of the NeoBI program, the new BI of Maison Hermès, set to replace Cognos. Lakehouse and its 3 layers (bronze, silver, and gold).

Key Responsibilities:

✅ Integrate of data from various sources: POS systems (Cegid), PIM, ERP (Infor M3), budget (TM1).

✅Reproduce of Sell-In aggregates (revenue by store, sales forecasting and restocking, margin rate by product, etc.).

✅Ensure data reliability for users by supervising the entire development process:

- Bronze: Raw data from source systems.

- Silver: Structured in Data Vault model.

- Gold: Provision of business-focused Retail Datasets.

✅ Feed a Cube or various dashboards.

✅Develop the roadmap in collaboration with Data Managers.

✅ Identify and prioritizing needs through workshops organized with Data Managers from different business areas (5 DMs for 17 business areas).

✅ Co-write Epics & User Stories with the PO.

✅ Co-create, maintaining, and prioritizing the product backlog, aligned with priorities gathered during my Discovery meetings.

✅ Organizing regular demos based on delivered data.

- 4 members: 2 Analysts / 2 Testers.

- Supervie the creation of test strategies.

I was working in a firm specialized in Microsoft products where I had the chance to accompany clients in the design of reports on the Power BI tool.

✅ Gather the needs of the customers

✅ Manage agile projects (JIRA)

✅ Connect different databases

✅ Design analytical data models

✅ Transform raw data into understandable data

✅ Develop analytical metrics (KPI)