Fardy MADI

General engineer from Centrale Marseille, I build data and automation tools on the Microsoft ecosystem (Power BI, Power Apps, Power Automate, Dataverse, SQL, VBA). From gathering requirements to user adoption, I help SMEs and large groups alike (SNCF, Porsche, JLL, Eiffage…) make their data reliable and automate their processes.

1. E

   Eiffage Génie Civil Marine — Peru Filial

   Freelance

   Data Analyst · Power Platform Developer · Digital Support

   Jun 2026 – Oct 2026·5 mosLima, Peru

   • Translated the expectations of the operations, HR and finance teams on the Lima construction site into reliable management tools tracking production costs, headcount and financial indicators.
   • Built a data ecosystem on Dataverse, SharePoint and Power Platform (Power Apps applications, Power Automate flows, Power BI reports), centralizing information and greatly limiting manual entry and errors.
   • User training, documentation writing and tool adoption follow-up, alongside daily support to project teams on their data extraction and analysis needs.

   • Dataverse
   • SharePoint
   • Power Apps
   • Power Automate
   • Power BI
2. E

   Eiffage Génie Civil Marine — Sverige Filial

   Freelance

   Data Analyst · Power Platform Developer · Digital Support

   Nov 2025 – Jun 2026·8 mosBoden, Sweden

   • Gathered and analyzed the reporting needs of the teams on the Boden construction site (production costs, HR and financial monitoring), and designed data solutions on Microsoft Power Platform and SharePoint to make data more reliable and optimized.
   • Developed databases, Power Apps applications, Power Automate automations and Power BI dashboards, and led their deployment while supporting users in adopting the tools.
   • Day-to-day operational support and tailored responses to the teams' data analysis and processing needs.

   • Power Platform
   • SharePoint
   • Power Apps
   • Power Automate
   • Power BI
3. E

   En1Clic

   Permanent contract (CDI)

   VBA Developer · Power Platform Developer · Data Analyst

   Apr 2023 – Jul 2025·2 yrs 4 mos

   Supported a wide range of clients, from SMEs to large groups (Naturalia, Porsche, JLL…), in developing and optimizing Microsoft 365 and Power Platform tools to automate and improve internal processes and team productivity.

   Client assignments8

   Expand all

   • Alliance EnvironnementPower Apps Consultant·Jan 2025 – Jun 2025·6 mos

     • Designed a Power Apps application replacing a 20+ page paper questionnaire for farmers, modernizing and simplifying information collection.
     • Configured a parameter table with a cascading question system, making the tool flexible and scalable over time.
     • Digitalized and centralized responses, making collected data more reliable and reducing processing time for field and analysis teams.

     • Power Apps
     • Dataverse

   • JLLPower Platform Consultant·Nov 2024 – Jun 2025·8 mos

     • Developed a Power Apps application for carrying out real estate appraisals, with automatic generation of Word reports.
     • Set up a SQL database and valuation calculation procedures, centralizing and securing the data.
     • Automated the import of Excel files from SharePoint into the SQL database via Azure Function and Power Automate, reducing manual processing time and making data more reliable.

     • Power Apps
     • SQL Server
     • Azure Functions
     • Power Automate
     • SharePoint

   • DistricashPower BI Consultant·Sep 2024·1 mo

     • Designed a complete sales and purchasing report tracking revenue, margin and volumes, giving a consolidated view of the activity of tire wholesalers and suppliers.
     • Automated the daily export of SQL data to CSV, making it easier for business teams to integrate.
     • Created dynamic dashboards and interactive visuals in Power BI, improving sales performance analysis and strategic decision-making.

     • Power BI
     • SQL
     • DAX

   • CloacinePower Apps Consultant·Jul 2024 – Jul 2025·1 yr 1 mo

     • Took over and improved a Power Apps application running the entire business of selling, installing and maintaining septic tanks in Normandy.
     • Fixed application bugs left unresolved by the previous provider.
     • Developed new screens to improve the precision of customer follow-up.
     • Connected to the APIs of the invoicing and scheduling software, eliminating double entry.
     • Harmonized the interface (colors, fonts, alignment…) and adapted it for mobile, delivering a smooth, responsive application.

     • Power Apps
     • REST APIs

   • MômjiPower BI Consultant·Aug 2023 – Jul 2024·1 yr

     • Took over and optimized a complex environment (500 SQL tables and around a hundred Power BI report pages) in the home services and childcare sector.
     • Corrected and standardized reports according to business rules, ensuring reliability and compliance.
     • Created new measures and visuals, improving decision-making.

     • Power BI
     • SQL
     • DAX

   • KeredesPower Apps Consultant·Jul 2023 – Sep 2023·3 mos

     • Designed a Power Apps application for condominium property management, deployed in 5 agencies in Brittany.
     • Made data more reliable, centralized and secure (previously managed across several Excel files).
     • Automatic generation of Word contracts pre-filled with information from the application.
     • Set up a Power Automate workflow to recalculate each contract's rates on its anniversary date.

     • Power Apps
     • Power Automate
     • Word

   • Porsche FranceVBA Developer

     • Created an Excel ranking file classifying Porsche centres (top/flop) based on criteria tracked throughout the year.
     • Developed an Excel tool for the controlled random selection of Porsche centres to audit, ensuring each centre is audited at least once a year.
     • Set up a custom PowerPoint ribbon for reporting anomalies, removing native ribbon features to limit user actions and secure usage.

     • VBA
     • Excel
     • PowerPoint

   • NaturaliaVBA Developer

     • Designed an Excel tool that automatically generates various product label formats as PDFs from a database.
     • Developed an Excel/Outlook tool to manage organic certifications - analysis of incoming e-mails, automatic archiving of attachments on the server, and real-time update of an Excel database.

     • VBA
     • Excel
     • Outlook
4. S

   SNCF

   Work-study program (3 years)

   IT assignment · Data Analyst · VBA Developer

   Dec 2019 – Sep 2022·2 yrs 10 mosPACA Technicentre

   • Optimized and created IT display and analysis tools for planning and lessons-learned feedback on production robustness, for the maintenance sites of the PACA region.
   • IT support for the PACA technicentre teams (task automation, help with Microsoft suite or SNCF tools).
   • As part of the H00 program, set up a Power BI report tracking the on-time departure rate of all technicentres across France, improving operational decision-making.

   • VBA
   • Excel
   • Power BI