Freelancer profile translated to English.
Back to original languageAbout Patrice
I have been anexpert in office tools(Excel and Access primarily) for 20 years.
I now have a dual role with these tools: trainer and developer.
My initial training (computer engineering) allows me to calmly tackle problems involving technical elements (APIs, databases, JSON, XML...)
Software Skills:
- Excel, Access
- VBA development, automation, macros
- Development of specific applications
- Data processing (ETL, Power Query, VBA)
- Dashboards, analysis, synthesis, reporting (KPIs, indicators, Pivot Tables, Power Pivot, DAX, formulas, charts)
- Interfacing with other software (exports, databases, APIs...)
Some examples of professions I have worked with:
- Accounting, management control, finance
- Human resources (payroll, training)
- Logistics, manufacturing
A few words about me:
I am also a trainer for these software packages. This aspect of my work often confronts me with new challenges and gives me an ease in understanding needs. I have excellent communication skills, which allow me to interact effectively with clients and teams.
I can work remotely, but I also enjoy traveling to meet people and work on-site.
French
Native or bilingual
English
Fluent
Can work on-site
Paris (up to 50km)
Experience
- Radio France
On Malt
Development of an Excel file migration scriptFILM AND AVJanuary 2024 - January 2024Development of a VBA script to migrate the structure of numerous Excel files located on a Sharepoint:- Modification of the table structure (adding columns)- Adding/modifying formulas- Adding data validation (dropdown lists, validity criteria)- Importing Sharepoint lists to populate validation lists or formulasSeveral hundred files, organized in a complex hierarchy, are processed. - SLTIDevelopment of a questionnaire analysis systemHUMAN RESOURCESSeptember 2023 - September 2023Paris, FranceComplete system for analyzing satisfaction questionnaires: retrieving and reprocessing responses from multiple sources (Power Query), consolidating with data from business software, creating summaries (Pivot Tables and formulas). Creation of synthetic PDF reports (VBA).
- Hotel Le BristolDevelopment of a payroll data reconciliation and analysis solutionHUMAN RESOURCESSeptember 2023 - September 2023Paris, FranceFrom extractions from different periods and software (time tracking and payroll), reconciliation of data, calculation, and analysis of discrepancies.Tools used:- Excel- Power Query (import, reprocessing, data formatting)- Pivot Tables (discrepancy calculation, reporting of results)
Reviews
Recommendations
Be the first to recommend Patrice
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
- Computer EngineeringPolytech Paris Sud2000- Développement dans de nombreux langages de programmation - Création, utilisation de bases de données