Freelancer profile translated to English.
Back to original languageAbout Catherine
I am a Data Analyst, with a dual expertise in data and 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**, **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 for a food SME:SQL+Looker+ recommendations
🤿 Freediving instructor: I resist 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)
- Sales 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 8 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 databasesProject integration into Power BIDefinition and monitoring of KPIs: sustainable development repository for water and sanitation services following 39 issues and 130 variables🔍 Strategic performance analysis through Business Intelligence (BI) tools.🔍 Data processing and analysis with SQL🔍 User segmentation for effective targeting strategies.🔍 Production of CSR reporting, aligned with sustainability goals.🔍 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 automating data analysis.🔍 Accurate financial reporting for transparent performance monitoring.🔍 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.🔍 Leveraging insights to improve customer experience and user journeys.🔍 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 activityData analysis&datavizShopper studies: analysis of consumer perceptions, sectoral extraction from the 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, charts.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 research, cost analysis, and foresight.Performance indicators: e.g., international sustainable development repository 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 « Concepteur développeur en intelligence artificielle et analyse big data, option Data analyse »Le Wagon2024Data & analytics SQL, Python, Fivetran, Zapier, DBT, Hubspot, BigQuery, Google Analytics, Power BI, Google Looker Studio, Git, Github
- DESS Gestion et génie de l'environnementParis VII1994Formation généraliste et avant-gardiste pour l'époque aux métiers de l'environnement
Certifications
- Certification « Artificial Intelligence and Big Data Analysis Designer Developer, Data Analysis Option »Le Wagon2024