About Patrick
French
Native or bilingual
English
Fluent
Experience
- CARBON ITBI / Data Analyst ConsultantFebruary 2025 - Today (1 year and 4 months)• Participation in the DSO Cockpit project aimed at making data reliable and centralized for managing SAV and Darty Max subscriptions.• Contribution to the functional and technical scoping of STG, Silver, and Gold data foundations on Google BigQuery.• Definition of business rules, mappings, and enrichment logic for Silver flows.• Close collaboration with the Dataform team for the technical implementation of transformations.• Design and scoping of Gold datamarts, used for both business extractions and ancillary analytical reporting.• Definition of structures and join keys to link SAV, subscriptions, and RCD scopes.• Creation of optimized Power BI datasets from Gold, facilitating the implementation of business reporting.• Development of robust Power BI models with dynamic DAX measures (monthly, weekly, temporal variations).• Design of analytical and operational dashboards for DSO teams and management.• Facilitation of scoping and validation workshops with DSO, DAIF, and Data Factory departments.• Contribution to business and technical documentation: glossary, data dictionary, scopes in Confluence.• Participation in COPROJ for validation of calculation rules and monitoring of BI deliverables.• Guarantee of the consistency, quality, and performance of delivered models and indicators.• Environment: Power BI, Google BigQuery, SQL, Python, Vertex AI, Airflow, Git, Confluence, under Agile SAFe methodology.• Result: implementation of a unified BI foundation facilitating Power BI reporting and reliable dissemination of DSO indicators.
- AXIANSBI / Data Analyst ConsultantMay 2023 - February 2025 (1 year and 9 months)• Identification and collection of data.• BI project management from scratch.• Data retrieval and creation of a PostgreSQL database.• Administration/Management of Tableau Server – PowerBI Server rights.• Data preparation and creation of a database to store processing results.• Coordination with business and technical teams.• Technical documentation writing.• Project management for new dashboard in SCRUM methodology.• Data processing in DataPrep, respecting usage and performance rules.• Monitoring of key KPIs.• Design and optimization of DataViz according to graphic charter and UX standards, with an emphasis on simplicity and readability.• Maintenance and improvement of existing dashboards.• Support/training for business users and end-users.
- BOURSORAMA BANQUEBI / Data Analyst ConsultantApril 2021 - May 2023 (2 years and 1 month)• Analysis of customer journeys and segmentation.• Structuring and enhancement of dashboards to track customer performance.• Data reconciliation to optimize profitability.• Participation in improving customer experience and conversion.• Implementation of tagging plans and analysis of acquisition campaign performance.• Support/training for business users and end-users.• Technical documentation and dashboard automation.• Collaboration with Data Scientists for advanced analysis.
Recommendations
Be the first to recommend Patrick
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Master IPSUniversité Montpellier 22011Master IPS