You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Dan TouitouDT

Dan Touitou

Expert Power BI, Automate, VBA, ETL, SQL, DataViz

€650/day
Paris, FR
15+ years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Dan

Experienced IT Project Managerwithin large industrial groups, I have developed solid expertise in Business Intelligence (BI) over the past few years.

Data Analysis and Business Intelligence (BI Expert)
  • Certified Power BI PL-300, with in-depth mastery of DAX and Power Query
  • Creation of automated flows under Power Automate, advanced business data analysis with Copilot
  • Expert in SQL querying and VBA macros
  • Business Intelligence Consultant: Analysis of financial, marketing, production, logistics, and HR data

Data Extraction and Transformation (ETL)
  • Retrieval and cleaning of customer data to make it usable
  • Consolidation of data from multiple sources for a unified view
  • Automation of ETL processes
  • Optimization of processing times and query performance

Data Visualization
  • Selection of the most relevant chart types to highlight key information
  • Creation of interactive and aesthetic dashboards, facilitating informed decision-making

Project Management
  • Collection and analysis of business needs and interface with technical and business teams
  • Proactive risk management and change management support
  • Improvement of operational performance and process optimization (logistics, production, purchasing)
  • Operational excellence: Rigor in managing deadlines, budgets, and resources

Accustomed to close collaboration with business and technical teams, I am a key facilitator in defining needs, simplifying processes, and supporting users through change. My constructive and collaborative approach allows me to build strong relationships, meet specific needs, and exceed expectations.

Do not hesitate to contact me to discuss your BI expertise and project management needs.
  • French

    Native or bilingual

  • English

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Freelance
    BI Expert and Process Improvement
    January 2024 - Today (2 years and 7 months)
    Paris, France
    Power BI & Tableau Expertise
    • Production of operational and/or decision-making dashboards
    • Selection of the most effective chart types to highlight key information
    • Query optimization and dashboard automation
    • Complex developments in DAX and M code

    ✔ Excel VBA Expertise
    • Development of VBA macros to automate complex processing from multiple sources
    • Reduction of repetitive manual actions and data security

    Business Intelligence Analysis
    • Understanding business needs, translating them into technical language
    • Consolidation and cleaning of business data to ensure its quality and usability
    • ETL from heterogeneous sources (Excel files, APIs)
    • Automation of BI reporting

    Process Re-engineering
    • Analysis of existing business processes
    • Proposal and deployment of improvement and simplification solutions

    AI-Based Process Improvement
    • Integration of automation tools to reduce manual processing in business processes

    Digital Transformation
    • Analysis and implementation of opportunities to accelerate the company's digital transformation, focusing on identifying quick wins.
    ETL Data Visualization DAX Macro VBA Excel Microsoft Power BI Power BI Desktop Customer Relations Microsoft Excel Dashboards Business Process Improvement Project Management Communication Digital Transformation Change Management Agile Methodology Code Optimization CRM Dynamics 365 Power Query Microsoft Power Query Business Analysis Data Analysis Extract, Transform, Load (ETL) Process Improvement Process Optimization NLP Artificial Intelligence Artificial Intelligence (AI) Data Extraction Power Automate PowerBI Microsoft Power Automate Automation Change Support SQL VBA Communication Strategy BI Expert BI Consultant Project Manager IT Project Management BI Project Manager Tableau Pivot Tables Tableau Desktop
  • Enedis
    Data & BI Project Manager
    ENERGY AND UTILITIES
    January 2018 - December 2023 (6 years)
    Paris, France
    Data Expertise
    • Design of algorithms to cross-reference data from heterogeneous sources (ServiceNow, QlikView, Power BI) to identify and locate unused computers in the company
    • Production of weekly operational reports, communication management
    • ▶️ Result: Over 2,500 computers collected in 6 months, annual rental costs reduced by 14%

    Operational Support for Management
    • Preparation of dashboards on service performance to improve data-based decision-making processes
    • Facilitation of monthly IT steering committees

    ✔ Design of an IT service catalog
    • Description of all services, mapping of over 50 business processes
    • Deployment and monitoring of SLAs to measure performance and ensure service commitments are met
    • Implementation of controls to detect and improve inefficient processes

    ✔ Implementation and management of a centralized warehouse
    • Management of IT hardware (delivery, installation, removal, recycling) for 12,000 users across 200 sites
    • Operational management of the contract with the supplier: monthly reviews, budget monitoring (€1M per year)
    • ▶️ Result: From 6 to 3 days on average for workstation delivery, 20% reduction in variance

    Facilitation of the network of regional IT correspondents
    • Assistance in formulating user needs
    • Improvement of customer experience (CX) by managing changes, field feedback, and escalations
    • ▶️ Result: 21% increase in user satisfaction over the first 2 years
    ETL Process Optimization Change Management Service Now Microsoft Power BI Qlik Project Management SLA Communication Algorithms Macro VBA Excel Steering Committee Team Management Customer Relationship Management (CRM) Risk Management Schedule Management IT Project Manager Functional Acceptance Acceptance Strategy Business Analysis Data Analysis Process Modeling Process Improvement KPI CSR Energy Lean Management Lean Six Sigma ITIL ITSM Python Python Programming Power Query Power Automate Data Extraction Extract, Transform, Load (ETL) SQL Microsoft Excel VBA Operational Excellence Communication Strategy BI Project Manager Business Owner Project Manager Digital Project Manager Infrastructure Project Manager Technical Project Manager Technical Project Management IT Project Management Project Manager
  • GRDF
    Training and Change Management Manager
    ENERGY AND UTILITIES
    January 2014 - December 2017 (4 years)
    Paris, France
    Design and implement a training plan for 12,000 employees
    • Evaluate the impacts of the Project on all company activities
    • Define training needs with each Business Unit
    • Produce and analyze relevant KPIs and present them in decision-making bodies

    Manage a team of 10 training specialists
    • Workload management, task prioritization and resource allocation, deadline optimization
    • Design of around a hundred courses and e-learnings
    • ▶️ Result: Organization, planning, and delivery of training on time for 100% of the 12,000 employees and subcontractors across 200 sites

    Participate in the implementation of a new LMS in the company (CrossKnowledge)
    • Supervise the integration of new courses into the LMS

    Facilitate the network of regional training correspondents
    • Represent the Voice of the Customer, ensure all business needs are taken into account and that all BUs are aligned
    • Supervise changes and handle escalations
    • Represent the Training aspect in weekly project reviews
    Change Management Communication Strategy Training Learning Management System KPI Macro VBA Excel Team Management Project Management Schedule Management Team Management Team Leadership Team Leadership Cross-functional Team Leadership Cross-functional Coordination Cross-functional Management CSR Energy Internet of Things ETL SQL Microsoft Excel VBA Communication Team Leader Technical Project Manager IT Project Manager Digital Project Manager BI Project Manager Business Owner Project Manager IT Project Management Functional Acceptance Technical Project Management

Recommendations

Daniel B.DB
Emmanuel BismuthEB
Daniel B. and 1 other person have recommended Dan

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • Engineer - Physics and Numerical Modeling
    Ecole des Ponts ParisTech
    2001
    Ingénieur
  • 1-year professional training in Data Science
    Datascientest.com
    2022
    Python, DataViz (Power BI), Machine Learning, Data Engineering, Deep Learning, NLP

Certifications

Skill set

Categories