Freelancer profile translated to English.
Back to original languageAbout Lucien
Freelance since 2019, I assist companies in designing powerful, automated, and user-friendly Google Sheets tools.
Google Sheets is a central and strategic tool for organizations today, whether small or large: collaborative, connected, scalable. This is precisely why it's my tool of choice.
For over 3 years, I have been working as a freelancer for Meilleure Copro, where I design and maintain several business tools, including a major application based on:
API calls (Pennylane, Podio, Google Analytics, Google Ads),
advanced automation via Google Apps Script,
reliable and secure data flows,
automated email sending with HTML/CSS integration.
Google Apps Script holds no secrets for me:
fetch API
process automation
business workflows
notifications and automated reporting
I have also worked for large companies such as La Banque Postale, Sanofi, Cegelec, April International, Andritz Selas, Clarke Energy Ltd., as well as for numerous SMEs and smaller organizations (accounting firms, restaurants, transport, event management, co-ownership syndicates, etc.).
In parallel, I have provided Excel and Google Sheets training for Each One, and more recently for Bolton, where I supported the skill development of an entire department, approximately 40 employees divided into 5 groups.
Trainer Number – Activity Declaration: 11 92 25760 92
My approach is primarily business-oriented: listening, understanding the need precisely, and then translating it into a clear, robust, and truly useful daily tool.
English
Native or bilingual
French
Native or bilingual
Portuguese
Fluent
Remote only
Primarily works remotely
Experience
- Richebourg ConseilAutomatic Google Slide Generation from Google SheetsJanuary 2023 - February 2023Cascais, LI, PortugalDevelopment of a Google Script contained within Google Sheets, allowing the generation of a copy of a Google Slides presentation from a Google Slides Template. This new Google Slide contains text fields, elements, and charts, automatically modified from the Google Sheets. The Google Sheets also contains a script to automatically generate a PDF of the Google Slide and send an email with the newly created PDF as an attachment.My intervention provides considerable time savings for the team as it is no longer necessary to manually edit the Google Slide: everything is done from Google Sheets.
- SAUTECDevelop an Excel Tool to Facilitate Offer FormalizationRAW MATERIALS INDUSTRYJune 2022 - June 2022Bois-Colombes, FranceThe objective was to facilitate the editing of offers in Word from an Excel file. You enter in Excel cells containing drop-down lists, the sections you wish to add to Word. Once the user has made their choices, they click on a macro button that will execute code and build the offer from a folder containing all possible sections. The user then has a new Word document that corresponds to an offer for a client.The folder containing the Word sections is composed of 3 levels of hierarchy to separate sections by discipline.I have written a guide to explain to users how the Excel file works and how to add new sections to the folder containing all the Word sections.
- ExentysAutomation from an Excel Extract.CONSULTING AND AUDITSJune 2022 - June 2022Bois-Colombes, FranceThe goal is to quickly identify which projects have a negative balance: the difference between billing and the time invested by employees in charge of the project.
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
- Generalist Engineer - Conventional and Sustainable EnergiesEPF - Engineering School20163 ans de formation généraliste et 2 ans de spécialité énergie conventionnelle et durable. Formation d'ingénieurs flexibles et adaptables, aptes à résoudre les nouvelles problématiques industrielles, en lien avec la transition durable. Les ingénieurs bénéficient d'un bagage de compétences scientifiques, techniques et managériales basées sur : - Une approche industrielle des modes de production, de conversion de la matière et de l’énergie, du pilotage et du suivi des procédés - Les aspects politiques, économiques, géopolitiques et réglementaires de l’énergie et de l’environnement - Les problématiques de gestion des ressources minérales et énergétiques depuis l’extraction jusqu’à l’exploitation et la production industrielle en passant par l’écologie industrielle, l’analyse de cycle de vie et les techniques de valorisation matière et de valorisation énergétique.
Certifications
- TOEICTOEIC2016