Freelancer profile translated to English.
Back to original languageAbout Catherine
I am a Data Analyst, with a dual expertise in data & studies that allows me to identify the most relevant business insights to optimize your activity.
🧑💼Some information about me
I work onthe entire value chain**: **collection**, **processing**, and data exploitation, up to **insightsand **recommendations**, combining studies and data analysis.
I combineExcel·SQL·Looker·Power BIwith solid expertise inmarketing studiesand **strategic analysis**.
Accustomed to collaborating with marketing, sales, purchasing, technical, and financial teams, I place particular importance on the clarity of reporting to facilitate decision-making.
Main sectors:circular economy**, **fast-moving consumer goods (FMCG)**, **health
🔎 Examples of achievements
• Professional-healthBarometer**: **Excel+Power BI+PowerPointreport
•Price analysis&multi-criteria grid- Pharmaceutical sector:Excel+PowerPoint(international context)
• Customersegmentation(5,000): Excel analysis +PowerPointsummary
• B2B/B2C activity analysis of a food industry SME:SQL+Looker+ recommendations
🤿 Freediving instructor: I can handle pressure and take care of my clients and students!
◉ My references
3D Dental Store, Sanofi, ecosystem, CITEO, BDO Advisory, Baxter Factory, La Brasserie du Pays Basque, key players FMCG
◉ My key expertise
- Definition and monitoring of KPIs
- Customer segmentation
- Dashboards (Power BI, Looker, Excel)
- Commercial performance & customer risk
- Customer/consumer insights
- Price studies and multi-criteria grids
- Data cleaning, processing, and exploitation
- Written and oral communication
- Reporting
Available 7 days a week via Malt messaging.
Response in less than an hour
French
Native or bilingual
English
Fluent
Spanish
Conversational
Can work on-site
Clichy (up to 50km), Biarritz (up to 20km), Paris (up to 50km)
Experience
- IzpiaFounder - Data Analyst - Data Analysis - Business Intelligence - ReportingCONSULTING AND AUDITSOctober 2024 - Today (1 year and 9 months)Clichy, FranceI help companies and public organizations make decisions by combining advanced analysis with data creation through tailor-made studies, to enable the identification of actionable insights, maximize the ROI of data initiatives, without resorting to external agencies thanks to my integrated approach from 25 years of experience.Over 25 years of experience in studies and data analysisManagement of an Excel project containing several hundred thousand linesExploitation of Excel databasesIntegration of the project into Power BIDefinition and monitoring of KPIs: sustainable development framework for water and sanitation services following 39 issues and 130 variables🔍 Strategic performance analysis using Business Intelligence (BI) tools.🔍 Data processing and analysis with SQL🔍 User segmentation for effective targeting strategies.🔍 Production of CSR reporting, aligned with sustainability objectives.🔍 Benchmarking to identify best industry practices.🔍 Exploitation of Looker Studio for complex data visualization.🔍 Definition and monitoring of KPIs, ensuring informed decision-making.🔍 Integration of Python for data analysis automation.🔍 Accurate financial reporting for transparent performance tracking.🔍 Sales analysis in the fast-moving consumer goods sector.🔍 Use of AI to generate actionable insights.🔍 Economic analysis for in-depth market trend assessment.🔍 Impactful data visualization, simplifying decision-making.🔍 In-depth analysis of user insights to refine marketing strategies.🔍 Collaboration with teams to translate insights into operational solutions.
- CiteoHead of Studies and ForesightENVIRONMENTALMarch 2010 - July 2023 (13 years and 5 months)Paris, FranceManagementof studies and foresight activitiesData analysis&datavizShopper studies: analysis of consumer perceptions, extraction from the sector's Excel database and visualization in PowerPoint.Analysis of packaging potential (> 300,000 lines of data) on Excel & Power BI.Customized Excel scorecard for clients (indicators: contribution and environment).Annual customer satisfaction barometer: 37,000 contacts, 4 targets, 1,000 responses, 5 KPIs.Customer segmentation: 40 variables, 5 defined typologies.Customer risk analysis: 4 KPIs + 1 aggregate, database of 1,000 clients, graphs.Strategic watch and foresight studies: analysis notes for management.Communication & reporting: internal and external presentations, conferences, webinarsAd hoc presentations for fast-moving consumer goods clients: manufacturers and distributors.
- BIPE (actuellement BDO)Mission DirectorCONSULTING AND AUDITSMarch 1996 - February 2010 (13 years and 11 months)Issy-les-Moulineaux, FranceConsultant - Mission DirectorManagement and execution of economic studiesMarket studies, cost analysis, and foresight.Performance indicators: e.g., international sustainable development framework for water and sanitation services (39 issues, 130 variables).Communication & reporting: reports, presentations, trade shows
Reviews
Recommendations
Be the first to recommend Catherine
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
- Certification "AI and Big Data Analysis Designer Developer, Data Analysis option"Le Wagon2024Data & analytics SQL, Python, Fivetran, Zapier, DBT, Hubspot, BigQuery, Google Analytics, Power BI, Google Looker Studio, Git, Github
- DESS Environmental Management and EngineeringParis VII1994Formation généraliste et avant-gardiste pour l'époque aux métiers de l'environnement
Certifications
- Certification "AI and Big Data Analysis Designer Developer, Data Analysis option"Le Wagon2024