Freelancer profile translated to English.
Back to original languageAbout Pierre
Developer (VBA, Power Query, Power Pivot) and trainer (Excel, Power BI Desktop, Access, Word, ...) for over 25 years in the Lyon region.
I have worked for all types of clients: from craftsmen to major accounts in the area, including SMEs and mid-sized companies.
Among the more than 400 companies where I have worked, both in training and development, many have kept my macros for several years (and sometimes beyond 10 years).
Some achievements among others with Excel (Power Query, Power Pivot and VBA):
- Quote calculation (aeronautics group)
- Sales tracking (accounting expertise group)
- Management control tracking (medical industry)
- Improvement of a production monitoring process in a small glass industry (30 min before, 10 seconds after)
- Training monitoring table (consular chamber)
- Correction of synchronization files (large NGO)
- Generation of inventory files (medical)
- IKA reporting, innovation project management (large manufacturing industry) ...
Some achievements under Access and VBA:
- Staff scheduling management (hotel industry)
- Complete production management (boilermaking)
- Equipment tracking (rental)
- Cost price calculation for quotes (quarry)
- Call management (call center)
- Reporting (distribution) ...
I particularly enjoy creating small developments with Excel that are used daily by my clients and that facilitate their work.
I am especially attentive to the rendering, ergonomics and speed of the programs.
Modesty aside, I am particularly proud to have achieved a score of 1000/1000 on the TOSA Excel test.
Finally, I regularly participate in specialized forums to share my knowledge and help members solve their problems.
English
Fluent
French
Native or bilingual
Can work on-site
Lentilly (up to 50km), Lyon (up to 10km)
Experience
- NOVAIR
On Malt
DevelopmentJune 2023 - June 2023Implementation of calculations using the new functions of Modern Excel.This avoided VBA development and is much more responsive. - AG ConseilTrainerDecember 2022 - December 2022Development of the training program and methodsFacilitation of the training on the final client siteContinuous adaptation of the program according to the traineesBonus after training for a trainee
- AuctorCoachingDecember 2021 - December 2021Lyon, FranceAdvice on the methodology and techniques to use to process large volumes of data
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
Certifications
- TOSA ExcelTOSA