Freelancer profile translated to English.
Back to original languageAbout Christian
⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️ ⬇️
Hello!
I specialize in creating reports, analyzing, and managing data via Excel.
I was able to work as a KYC compliance management manager at Crédit du Nord / Société Générale to bring my knowledge in the field of compliance and establish reports for management as well as for all agencies in France.
Thanks to my training in market finance (master's degree) and my experience in the banking world, I offer you tools adapted to your company while having a personalized user approach.
I am involved in the creation of your reports with these keywords:
🔹Clarity
🔹Visualization
🔹Precision
🔹Dynamism
🔹Automation
🔹Optimization
"Data" rhymes with clarity, which is why I use the full potential of Excel to bring your data to life through integrated tools such as:
🔹VBA / Macro
🔹Power Query
🔹Power Pivot
The extraction, transformation, and loading (ETL) of your data are now within reach thanks to these tools.
Merged with the creation of specialized macros, I support you in the automation of your tools.
Whether you are looking for tools very specific to your business or you want to outsource the creation of your reports to focus on your core business, then I invite you to contact me to discuss your projects. 📨
Christian
English
Fluent
Spanish
Fluent
Portuguese
Conversational
Japanese
Basic
French
Native or bilingual
Can work on-site
Lyon (up to 50km), Paris (up to 50km), Annecy (up to 50km), Grenoble (up to 50km), Saint-Étienne (up to 50km)
Experience
- OVEOCreation of pricing toolsAUTOMOBILENovember 2023 - November 2023Mission objective:Creation of a pre-pricing tool allowing the company to obtain the exact price of the different car models from databases.Result and benefits:Thanks to this tool, the company can now know all the prices in a few seconds against a slower manual update and therefore focus on its core business.Achievements:• Co create a model.• Import, transform and load the database via Power Query.• Create calculations / manage errors / group certain information via the M language.• Create macros with VBA to automate the updating of requests / set up a user interface.• Create a personalized design that meets the company's expectations.Technical environment:Excel / Power Query / VBA / TeamsFunctional skills:• Data analysis• Synthesis spirit• Proactivity• Reactivity• Methodology
- Kerether conseilPilotage - Forms - OptimisationFASHION AND COSMETICSMay 2023 - July 2023 (2 months)Paris, France1/ Adaptation of a Google Forms to Microsoft Forms.Data recovery and optimization under ExcelData processingCreation and automation of a materiality matrix according to the client model2/ Creation of a steering fileOptimization and automation of information from several tabs on the same summary tab3/ Supplier registerFile optimizationIntegration and processing of supplier form dataCreation of a summary
- Berthouly constructionUpdate - VBAJanuary 2023 - January 2023Updating the VBA code to adapt it to the new Excel format.Creation of new documents based on client file for mail mergeAdaptation of the code to the new files
Reviews
Recommendations
Be the first to recommend Christian
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
- Master in market financeMontpellier-BS2018
Certifications
- Mastering data analysis with Power BILinkedIn Learning2023
- Designing Effective Reports in Power BIMicrosoft Learn2023