Freelancer profile translated to English.
Back to original languageAbout Alain
Hello, I am Alain, an Excel consultant specializing in automation, reporting, and the creation of custom steering tools.
I help companies, freelancers, and business teams save time with more reliable, readable, and automated Excel files.
I can assist you with:
✅ Creation of interactive Excel dashboards
✅ Automation of files with VBA / Excel macros
✅ Data cleaning, structuring, and transformation with Power Query
✅ Creation of Power BI reports
✅ Setup of tracking files: inventory, sales, purchases, quotes, KPIs, reporting
✅ Optimization of existing Excel files that are slow, complex, or difficult to use
✅ Creation of simple, visual, and easy-to-use tools
My goal is to create concrete, clear solutions adapted to your way of working. I can also provide a user guide so that the tool remains understandable and reusable by your teams.
French
Native or bilingual
English
Fluent
Spanish
Conversational
Can work on-site
Paris (up to 30km)
Experience
- ThalesMaintenance Engineer / Data & AutomationDEFENSE AND MILITARYSeptember 2024 - Today (1 year and 11 months)
Business Data Transformation / Excel VBA / Support Databases
As part of my work-study program at Thales, I worked on projects involving the transformation and automation of data related to support and maintenance.My tasks included designing tools to transform data from existing databases to adapt them to new data models or new business needs.Project 1 — Transformation of a Logistics Support DatabaseI participated in the implementation of a tool to automatically transform data from an old logistics support database to a more recent model based on the S3000L specification.Achievements:- Analysis of the source and target data structure
- Identification of correspondences between the two models
- Automatic data transformation to facilitate integration
- Consistency check of generated data
- Creation of structured files usable by business teams
- Automation of repetitive tasks using Excel and VBA
Project 2 — Transformation of Maintenance Support Data to a Design DatabaseI also worked on a tool to adapt maintenance data to make it usable in a design-oriented database.Achievements:- Analysis of support and maintenance data
- Data transformation to adapt it to a different target structure
- Automation of processes via Excel files and VBA macros
- Generation of structured output files
- Data validation before integration
- Implementation of checks to limit errors and facilitate use by teams
Skills used:Excel, VBA, automation, data transformation, data structuring, databases, maintenance, data quality, functional analysis. - Messer - CanadaBranch ManagerLOGISTICS AND SUPPLY CHAINApril 2022 - July 2022 (3 months)Montréal, Canada
ABC Analysis / Excel Dashboards / KPIs / Stock Optimization
During a three-month assignment, I worked on optimizing product storage space in a warehouse.I conducted an analysis of the existing situation to identify areas for improvement, then implemented Excel tools to better visualize stock data, track key indicators, and facilitate decision-making.Achievements:- Performed an ABC analysis of products in stock
- Created Excel dashboards with tracking KPIs
- Implemented charts to visualize product distribution
- Used VBA macros to automate certain analyses
- Developed a warehouse plan and analyzed space utilization
- Identified priority products and areas for optimization
- Proposed improvement solutions for storage organization
- Monitored continuous improvement after implementing actions
Skills used:Excel, VBA, ABC analysis, KPIs, dashboards, charts, stock management, continuous improvement, warehouse optimization. - Coopérative Agricole Ile de France SudIT Project ManagerSOFTWARE PUBLISHINGSeptember 2023 - September 2024 (11 months)Morigny-Champigny, France
ERP Migration / Data Preparation / Excel
As part of an ERP change project, I participated in the preparation, control, and migration of essential company data.My main tasks involved structuring and validating data before its integration into the new ERP, particularly through Excel files used as import supports.Achievements:- Prepared Excel files for data integration into the ERP
- Cleaned, controlled, and structured item, supplier, and price data
- Verified information consistency before migration
- Identified and corrected anomalies in source files
- Participated in securing the transition between the old and new ERP
- Worked on data integrity to ensure a reliable and smooth migration
Skills used:Excel, data structuring, quality control, ERP migration, data cleaning, functional analysis.
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
- Master - MIAGE (Methods, IT, Applied to Business Management)Paris-Saclay2026Diplômé d'un MIAGE (Méthodes Informatiques Appliquées à la Gestion des Entreprises), je renforce mon profil avec une expertise croissante dans le domaine de l'informatique appliquée à la gestion d'entreprise. Au travers de cette formation, je développe des compétences pointues en méthodologie de projet, en conception de systèmes d'information, ainsi qu'en développement informatique. Cette approche orientée vers les besoins des entreprises me permet de comprendre les enjeux spécifiques auxquels celles-ci font face et de proposer des solutions informatiques adaptées. Ma rigueur et ma capacité à analyser les besoins des entreprises s'associent harmonieusement à ma formation antérieure, notamment en logistique et qualité. Cela me positionne comme un professionnel polyvalent, capable de mettre en œuvre des solutions informatiques intégrées tout en respectant les normes de qualité et en optimisant les processus opérationnels. Mon parcours académique, alliant la Licence 3 MIAGE et le DUT QLIO, reflète ma volonté d'acquérir une double compétence qui me permettra d'apporter une valeur ajoutée significative dans le domaine de l'informatique appliquée à la gestion d'entreprise. Je suis ainsi prêt à relever de nouveaux défis et à contribuer activement au succès des projets informatiques au sein de votre entreprise.
- Bachelor's Degree in MIAGE (Methods, IT, Applied to Business Management)Université Paris-Saclay2024
Certifications
- PIXMinistry of Labour, Health and Solidarity2022