Freelancer profile translated to English.

Description

Graduated in MIAGE in 2013, I have been involved for 12 years in the design and development of data back-office solutions on operational and decision-making systems, as well as reporting solutions.

I also occasionally work on functional assistance, support, training, or project management.

I have supported various business areas (food industry, banks & insurance, energy, public services).

Available for missions ideally in full remote, or with occasional travel in the Southwest region.

Languages

French
Native or bilingual
English
Fluent

Workplace preferences

Can work on-site

Figeac (up to 50km)

ANDROS GLOBALSERVICES (Direction des systèmes d'information)
Business Intelligence Project Manager
AGRICULTURE
October 2023 - Today (2 years and 8 months)
Brive-la-Gaillarde, France
Technical environment: Snowflake, Click & Decide On Premise, Microsoft Power BI

- Responsible for the support and application administration of BI solutions for Andros and its subsidiaries. Project management, and implementation of BI solutions.

- Responsible for the support and application administration of the Click & Decide BI platform (approx. 1000 users), as well as the Microsoft Power BI solution (approx. 500 users)

- Participation in the migration of ERPs to Infor M3, for all group subsidiaries, and within the BI scope: requirements gathering, writing functional and technical specifications, designing and populating a datamart, implementing Power BI, and writing operational procedures for the Run team.

- Implementation of group quality indicators (internal scrap rate TRI, first-time right B1C): definition of common quality indicator rules with the quality department, definition of site-specific technical rules, development of queries and loading of the datalake, development of reports in Power BI, rights management.

- Participation in various projects for: populating the Snowflake group datalake, user support and training for Click & Decide and Power BI BI tools.
Snowflake Microsoft Power BI Click & Decide
ANDROS GLOBALSERVICES (Excellence opérationnelle)
Industrial IT Project Manager
AGRICULTURE
September 2018 - September 2023 (5 years)
Brive-la-Gaillarde, France
Technical environment: SQL Server 2008 R2, Transact-SQL, SSRS, Tortoise SVN

- Contribution to the development, configuration, and deployment of ANDROS group's MES production management software for several sites in France and internationally (data and reporting specialization)

- Requirements gathering, and writing functional analysis documents (fruit campaign process traceability, KPI availability, packaging pallet marking traceability)

- Design of the MES-ANDROS data model (operational and decision-making)

- Technical specifications

- Operational management: monitoring progress of external service providers (embedded terminals, marking applications, web), task planning, writing and executing test scenarios

- Development of Transact-SQL stored procedures: SQL query performance optimization, obsolescence management, log analysis

- Development of SSRS reports

- User training on production lines
SQL Server SSRS Tortoise SVN
CNES
Decision-Making and CRM Consultant
PUBLIC SECTOR
February 2018 - August 2018 (6 months)
Toulouse, France
Technical environment: Microsoft Dynamics Online CRM, Talend Enterprise Data Integration v.6.3.1, C#, Javascript

- Extraction and processing of data from the operational IT system "Purchasing Management" of CNES, for populating an xRM application

- Creation of the data model

- Development of ETL jobs: SOAP web service consumption, log and error management, interface between Talend and Microsoft Dynamics

- xRM development: entity management, form management, creation of C# algorithms (auto-increment, dynamic entity creation), development of dynamic filters in JavaScript

- Client workshop: presentation of the rejection strategy, demonstration of Talend flow sequencing
Microsoft Dynamics CRM Talend C# JavaScript