About Lucas
French
Native or bilingual
English
Fluent
Experience
- AREA ETUDESAutomation of incoming email sorting and routingARCHITECTURE AND URBAN PLANNINGJanuary 2026 - April 2026 (3 months)Nantes, FranceMission:Automation of sorting and routing of incoming emails to the general address of 2 cabinets of the Area Études group.✔️ Result:**+80% automatic routing and 2 to 3 hours saved per day, per secretary and per cabinet**_______________________________Context:The Outlook mailbox receives 150 to 250 emails per day. The secretary had to read each message, identify the correct project, forward it to the right person, and file and track it manually.Solution:Implementation of an automated system with Power Automate, which for each email:
- Detects the relevant project
- Forwards to the correct person
- Files in the correct Outlook folder
- Manages exclusions and non-priority emails
- Highlights internal emails
The client manages everything from a simple Excel file:- Configuration: projects and associated information
- History: tracking of treatments and potential errors
- Data: monitoring of email volume and flow performance
- Zephyr International FZ-LLCManagement of advertising performance on Google SheetsE-COMMERCENovember 2025 - November 2025Nantes, FranceMission:Redesign and optimization of a Google Sheets tool for managing advertising performance for an e-commerce retailer.✔️ Result:Transition from a generic template to a custom tool for business management, analysis of winning/losing campaigns, and key KPIs.___________________________Context:The client switched to a new template to track their advertising campaign results, but the tool was not adapted to their actual workflow.Redesign of the Google Sheets file to adapt it to the client's actual needs:- Month-by-month summary dashboard- Summary of winning and losing ads- Tracking of amounts spent, revenue generated, and ROAS- Detailed performance analysis pivot table based on several criteria (angle, audience, concept, etc.)
- ValorisecoPlanning file improvementARCHITECTURE AND URBAN PLANNINGSeptember 2025 - September 2025Nantes, FranceMission:Optimization of the Excel planning file and creation of workload management tools for a renovation/kitchen design company.✔️Result:**- 3 to 4 hours saved per week** on planning management.- A workload indicatorfor managers, providing real visibility on team availability and activity management.___________________________Context:The company needs to create the schedule for several teams each week. The existing Excel file was difficult to maintain: frequent re-entry of client data, difficult-to-track changes, lack of readability, and no concrete data on worker workload.Improvement of the Excel planning file to make it easier to use daily:- Data structuring with lists and selections- Automatic conditional formatting for more visual reading- Improved planning reliability despite changes- Elimination of copy-pasting from the CRMImplementation of a management tool for the manager:- Weekly summary table of workload per person and per team- Customizable period tracking table with filterable dates
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
Education
- Master's degree in Industrial EngineeringECAM Rennes2023Diplôme d'ingénieur en Génie Industriel
- BSc Industrial Engineering (study abroad)Central Michigan University2022BSc Industrial Engineering (study abroad)