Freelancer profile translated to English.
Back to original languageAbout Karl
Structure and develop your business
My name is Karl Guerin, a graduate of ESCP with experience in leading companies such as Goldman Sachs, BNP Paribas, Daimler, BPI, Michelin, Natixis, Céline, and Papernest.
I've had the opportunity to observe how these leaders optimize their sales and operational processes, and I've developed a dual expertise in Sales Operations (Business Analyst & Project Manager) allowing me to design and implement tailor-made solutions.
Today, I help SMEs apply these commercial and operational best practices to boost their development and reduce their costs. My expertise includes:
1. Process & Automation:
- Structuring and optimizing sales processes around CRMs (HubSpot, Pipedrive): diagnosis, recommendations, and execution
- Automation and implementation of suitable tools to increase efficiency
2. Sales Performance: improving sales effectiveness, optimizing the sales funnel, conversion, and retention
3. Analytics: data analysis using SQL, Google Sheets, and Excel, with visualization via Looker and Power BI for precise reporting
4. Project Management: support in tool adoption, change management, team training, and special project management
To ensure concrete results, I rely on:
- 5 years of experience in Sales Operations, Business Analysis, and Project Management
- +15 successfully supported clients
- Methodology in 3 key steps: i) audit and definition of commercial & operational specifications, ii) optimization of the sales funnel and internal processes, iii) after-sales service: continuous improvement and team training
Contact me for support on your CRM, operational, and sales challenges!
French
Native or bilingual
English
Native or bilingual
Spanish
Native or bilingual
Can work on-site
Paris (up to 50km)
Experience
- GimmyFoodImplementation of a CRM (Hubspot) to structure and automate sales processesRESTAURANTS AND FOOD SERVICENovember 2024 - December 2024 (1 month)Paris, France**Situation**: GimmyFood, a startup specializing in catering, faced major challenges:
- Lack of centralization: no tool to group prospects and clients
- Lack of structured processes: time-consuming manual tasks and often forgotten opportunities
- Impact on growth: disorganization hindering revenue and productivity
**Scope**:1. Configure HubSpot to centralize data and structure processes2. Automate workflows to optimize lead management3. Simplify prospect data import4. Document processes to facilitate adoption**Actions**:1. HubSpot Configuration:- Creation of the sales pipeline, workflows (follow-ups, lead assignments)
- Configuration of dashboards for real-time monitoring
2. Process Automation:- Simplified import of scraped data via Google Sheets (3 clicks)
- Automated workflows for follow-ups and communications
3. Documentation:- Creation of a data catalog and video tutorials detailing the processes
**Results**:- Increased productivity: reduced time spent on manual tasks
- Data centralization: efficient management of prospects and clients
- Team satisfaction: rapid adoption and positive feedback on tool simplicity
- Impact on growth: optimized opportunity tracking, strengthening revenue potential
- Brown-FormanConsolidation of sales reports and data visualizationWINE AND SPIRITSJuly 2024 - October 2024 (3 months)**Situation**: Brown-Forman, a global spirits leader, faced major challenges in managing its sales performance:
- Lack of report consolidation: 12 markets produced separate reports, preventing a regional overview
- Lack of harmonization: varied formats, making analysis and comparison difficult
- Complex trend identification: absence of consolidated reporting to identify opportunities and track market share
- Urgent strategic needs: necessity of a global vision to drive competitiveness
**Scope**:- Create consolidated reporting for sales data (volume, value, market share, trends)
- Design a PowerPoint template for C-levels, highlighting key insights
- Automate tools to simplify monthly updates
**Actions**:1. Target report mock-up:- Definition of priority KPIs and structuring of analysis categories (5 categories, 5-10 brands)
- Adjustment of KPIs based on available market data
2. Harmonization of local data:- Standardization of formats for the 12 markets and centralization via Google Sheets
3. Automation:- Use of advanced formulas (QUERY) to automatically organize and update data
- Dynamic connection between Google Sheets and PowerPoint for updatable presentations
4. Production of the C-level presentation:- Creation of a PowerPoint template (+25 slides) consolidating key data and insights
**Results**:- Data centralization: a single report providing a global view of European performance
- Efficiency gains: reduced production time thanks to automation
- Increased visibility: better identification of trends and opportunities, previously invisible
- Client satisfaction: positive feedback on the clarity and effectiveness of the delivered tools
- CELINEData Business AnalystLUXURY GOODSSeptember 2024 - Today (1 year and 8 months)Paris, France**Situation**: CELINE wanted to optimize its data architecture and analytical tools to better meet the operational needs of its business teams. Challenges included:
- Data accessibility and understanding: ensuring a clear and usable structure for business teams
- Critical KPI monitoring: providing suitable tools to monitor supply chain and business planning performance
- Strategic analysis: identifying insights through ad-hoc data analysis to inform decision-making
**Scope**:1. Development and improvement of the data architecture to meet information system evolution (GCP)2. Creation and optimization of Power BI dashboards to track operational KPIs3. Conducting ad-hoc data analyses to uncover insights and formulate strategic recommendations**Actions**:1. Data architecture optimization:- Collaboration with IT teams to adapt information systems based on business needs
- Provision of new data sources through specific projects aligned with IT system evolutions
2. Power BI dashboard development:- Creation and maintenance of automated dashboards for business teams, enabling real-time KPI monitoring
3. Ad-hoc analyses and recommendations:- Conducting specific studies to identify opportunities or resolve operational issues
Reviews
Recommendations
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 of ManagementESCP Europe2019Master In Management Grande Ecole
- CPGE ECEInstitution Saint-Jean2015CPGE ECE
Certifications
- No-codeMaestro2023