Ludovic MEALET

Ludovic MEALET

Paris, France

Ludovic MEALET

Excel VBA & Data, Process Automation Expert
Category : Data base
Senior Consultant with a solid experience in Excel VBA development, business process optimization and support to operational teams, I am currently open to missions on the Luxembourg market.

Committed to bringing a plus, I automate complex, repetitive and time-consuming processing, in order to save time, precision, and money to end customers.
During my various missions, I was constantly required to analyze the data I had to process, both in their overall structure and in their particular specificities.

I carried out data transfers for migrations to new tools by following ETL processes. I am used to cleaning, normalizing, transcoding and enriching, meeting the standards of the business and/or the recipient tool, before launching consistency checks developed by me. I have a strong taste for analyzing data structure and processing strings. Concerned about transparency, I automate the reports corresponding to the progress of the processing and any deviations observed after migration.
Once customer expectations have been integrated and structured, my VBA skills allow me to automate Data Automation processes and deliver datasets intended either for imports for migration, or for reporting or analysis, according to a standard and duplicable model.
Intervening on requests for the evolution of undocumented tools, I am used to establishing documentation, maps and mappings of the tools I take over and those I create.

I particularly like to work as closely as possible with the teams, in order to understand their needs and their business context, as well as with the tool referents in order to understand how data flows interface. Having developed my skills by responding to concrete problems, I am particularly able to put myself at the level of my interlocutors to communicate and popularize my work. It is this same pragmatism that leads me to find solutions and learn new features or areas of development.
Once the business context has been understood, it is natural for me to model my experiences on their environment and be a force of proposal.

Looking forward to a future collaboration!

Working hours

  • Monday:08h00 To 18h00
  • Tuesday:08h00 To 18h00
  • Wednesday:08h00 To 18h00
  • Thursday:08h00 To 18h00
  • Friday:08h00 To 18h00
  • Saturday:Not available
  • Sunday:Not available
Code review of an Excel application, related to MIFID regulatory requirements, written in VBA by the business via Copilot.
Code redesign in line with best practices.
Evolutions at the request of the business, functional tests and stress tests before production.
Mission in the context of the changes in regulatory reporting of the CFTC, EMIR, FCA & MAS jurisdictions, requested by the regulator (DTCC).
Creation of data automation (ETL).
Development, under Access VBA, of an administration tool and aggregation of the reports received from the regulator (Trade State, Submission, Recon). Gain: 5 times faster processing.
Automation of production/test gap analysis, and DTCC platform rejection causes, via Excel/VBA, Access/VBA & Power BI.
Creation of an automated matrix for monitoring the progress of tests.
Creation of Access/VBA databases for Data Quality and statistical measurements.
VBA developments in the context of the creation of the central purchasing management tool of the Casino-Intermarché Joint Venture (Auxô)
Development of tools for the administration of the central database.
Data recovery, SQL Database management in Azure environment, via SQL Management Studio and Azure DataFactory.
Creation of the documentation of developments and the general context.
Adaptation and optimization of Excel and Strategic Financial Access macros in connection with the migration from Office 2010 (32-bit) to Office 2013 (64-bit), in close collaboration with users in Luxembourg, Geneva and Lugano.
  • 🇬🇧 English
  • 🇫🇷 French
0.0 (0)
0
0
0
0
0
⚠️
Please sign in as a customer to give your feedback

    Need a service ?

    Do you want to hire the services of this Professional ?

    Post your need and you will receive dozens of proposals from the Professionals of the community.