Freelancer profile translated to English.
Back to original languageAbout Jehan
🎯My goal**: to help you transform your current processes and accelerate your growth with a **pragmaticand **results-oriented approach**.
Double graduate ofCentrale Lyon(General Engineering) andImperial College London(Business School), I have acquired solid technical, managerial, and business experience by being a consultant (EPSA), then an investment fund analyst (PE mid cap - Dentressangle), and finally co-founding 3 startups.
I have been supporting companies as a freelancer forabout ten yearsinvarious sectors and on multiple topics**. **Rethinking your business processesto generate measurable gains (up to 15x productivity in my previous missions), developing internal tools to **simplify and automate simple or complex processes**, analyzing data of all kinds, implementing monitoring tools...
💻 Technical Expertise
My hybrid "tech + business" approach allows me to intervene on your critical challenges:
- Optimization of simple or complex Excel/VBA tools connected to databases (SQL)
- Automation of high-value-added tasks (reporting, pricing, invoicing)
- Development of tailor-made solutions (Python, React, AI, no-code)
- Securing strategic decision-making processes
💡 Beyond simple development
My entrepreneurial background (CEO of Taxeasy, COO of Gleef) and my experience as a consultant for large groups (TotalEnergies) give me a global vision. I take the time to analyze projects to understand the underlying issues. This allows me to:
- Offer you several options and choose **the best one for you**.
- Provide you with a **reliable, solid, and durable tool**.
I don't hesitate to suggest alternatives to Excel when relevant, prioritizing the 80/20 approach: focusing our efforts on what generates the most impact with the least resources.
Happy to chat!
French
Native or bilingual
English
Native or bilingual
Spanish
Conversational
Can work on-site
Paris (up to 50km), Bordeaux (up to 20km), Lyon (up to 20km), La Rochelle (up to 20km), Angers (up to 20km)
Experience
- MercureBudget & Expense Tracking ToolHOSPITALITYDecember 2023 - January 2024 (2 months)Bordeaux, FranceDevelopment of anExceltool forbudget and expense trackingacross different departments in several hotels.Collaborative tool with database management for departmental views with access restrictions, and a master file for viewing all data.This tool facilitates accounting management of invoices, quotes, provisions, and tracks each department's costs against planned budgets.
- TotalEnergies Electricité et Gaz FranceOverhaul of a Key Account Pricing ToolENERGY AND UTILITIESNovember 2021 - May 2024 (2 years and 6 months)Paris, FranceComplete overhaul of an Excel tool(+ external SQL).Cost optimization(millions of euros saved annually through error reduction),task automation(client tracking, portfolio management, and purchase/sale transactions), **added security, verification, and a logging system**.This was a long-term mission - still ongoing for operational monitoring - involving a complete rethinking of the internal tool used for tracking, managing, buying, selling, and invoicing GAS for Total Energies' key accounts.It was a particularly rich and intense mission.1. Understanding a complex European energy market within a team with little experience (max 3 years) and departing managers.2. Deeply understanding the current tools, their limitations, their functioning, and their interfaces with other tools.3. Fundamentally rethinking their management, which was done via a 10-year-old Excel file, no longer maintainable, leading to numerous errors in contracts and hedging, resulting in annual losses of millions of euros.4. Developing a reliable, comprehensive, and collaborative system that now allows them to accurately track their entire portfolio and perform complex tasks in seconds, while offering great flexibility and agility.You can find images in my portfolio.
- ATELIER DES COMPAGNONSConstruction Site Tracking Tool - Cost and Human Resource ManagementREAL ESTATEJuly 2021 - February 2022 (7 months)Paris, FranceCreation of an internal toolusing Excel for **construction site tracking**.*Human resourcetracking: staffing, personnel management, schedules, absences, etc.*Financialtracking: cost management per project, comprehensive view of personnel costs, project profitability, etc.This tool is particularly complex due to the fine-grained management of personnel to impact construction site costs. It now allows for easy personnel management and accurate cost allocation to specific construction sites to track the profitability of different Business Units.Access control, confidentiality, and inter-BU management, with master files for full visibility.
Reviews
Simon
AKWO
Reviewed on 1/26/2024
N
Nadir
TotalEnergies Electricité et Gaz France
Reviewed on 6/15/2023
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 in General EngineeringEcole Centrale de Lyon2020Diplôme d'ingénieur généraliste - 5e meilleure école d'ingénieur Française. Cette formation m'a permis d'aborder de très nombreux sujets techniques et industriels, tout en m'ouvrant également sur les applications plus business. J'y ai acquis de très solides compétences sur les sujets suivants : Energie électrique et Commande des Systèmes, Fluides et énergie, Génie Mécanique, Informatique (Python & Javascript), Ingénierie des Matériaux, Analyse appliquée, numérique, statistiques et probabilités, Mécanique des Solides et Structures, Physique et Chimie de la matière, Sciences Economiques et de Management...
- Master in ManagementImperial College Business School2021Classé 10e meilleur Master en Management par le Financial Times en 2020 Le MSc Management est un programme stimulant d'une durée d'un an, ayant pour objectif de nous préparer à un large éventail de carrières. J'ai pu y réaliser de très nombreux projets, entre étudiants, mais aussi avec des entreprises, sur les sujets suivants : Data Analyse, Finance, Maths, Comptabilité, Économie des Affaires, Finance d'Entreprise, Management de l'Innovation, Décisions Marketing, Management d'Opérations, Comportement Organisationnel et Gestion Stratégique. Durant 6 mois j'y ai suivi une spécialisation entrepreneuriale autour des sujets suivants : Analyse d'Entreprise, Simulation d'Entreprise, Stratégie d'Entreprise et Gestion de Projets