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

Alexandre Cessac

Expert Excel (Power BI & VBA)

€300/day
4 projects
Bordeaux, FR
3-7 years

Average response time: 1 hour

Freelancer profile translated to English.
Back to original language

About Alexandre

Young Data Analyst & Data Scientist engineer, I enthusiastically support you with all your Data challenges:

- Custom projects: KPIs, automations, dashboards, project management
- Skill development for all levels (OPCO, CPF): certified organizations

Passionate about data analysis, I master all the following software at an expert level:

Office Suite

- Excel (VBA)
- Power BI (Power Query, Power Pivot, M)
- Access (SQLAccess, VBA)
- Word, PowerPoint, OneNote, Outlook etc.

Google Workspace

- Google Sheets
- Google Data Studio
- Google Docs, Slides etc.
- Google Apps Script (process automation)

I also provide support as a Junior Data Scientist in the following areas:

Python

- Data Analysis & Visualization (Pandas, Numpy, Seaborn)
- Machine Learning and Artificial Intelligence (Sklearn)
- Deep Learning (Keras, TensorFlow)

SQL

- Advanced Queries & Databases

With a multidisciplinary background focused on project management, I quickly associate and integrate the technicality of a problem. Curious, I regularly train myself & a professional level of English, Italian, and German allows me to easily integrate into an international work environment.

I am proactive, methodical, and rigorous. I look for the simplest solution to any problem and deliver turnkey solutions (explanations & action plans).

Do not hesitate to contact me for any further information.
  • French

    Native or bilingual

  • English

    Fluent

  • German

    Fluent

  • Italian

    Fluent

Can work on-site
Bordeaux (up to 20km), Toulouse (up to 20km)

Experience

  • Malt
    Data-Analyst & Data-Scientist
    September 2023 - Today (2 years and 9 months)
    Bordeaux, France
    Short, medium, long-term Data missions - travel (France), remote & hybrid

    Non-exhaustive project examples:

    - Creation of Forms (remote) | Excel & VBA ~ Distribution
    Use of Excel database for interface development
    Modification of CRUD according to mockup, User-Experience

    - Implementation & Support SME Databases (hybrid) | Access & VBA ~ Metal Engineering
    Client-company interface - specifications, system understanding
    ERP automation for FTP time tracking system
    Development, testing phase, validation & documentation

    - Automated collaborative Operator Entry (remote) | Google Sheets & Apps Script ~ Translations
    Implementation of a shared service management tool
    Calculation of costs (category, duration, formulas) complete & flexible
    Security, accessibility - use for BI Dashboards

    - Creation of Dashboards (hybrid) | SQL, Power BI & DAX ~ Crafts
    Implementation of Dashboards - production, manufacturing, sales monitoring
    Data retrieval & transformation (ERP, supplier link) visual exploitation

    - Process Automation (hybrid) | Excel & VBA ~ Agriculture
    Computerization of production methods - Agricultural sorting
    Field study, flow synthesis, ERP creation
    SQL modeling, DFD, prototype development & documentation
    Continuous improvement, maintenance & turnkey validation
    Data analysis Data science Automation
  • L'Atelier Digital
    Formateur Pack Office & Data Visualisation
    EDUCATION AND E-LEARNING
    October 2022 - September 2023 (11 months)
    Paris, France
    Formations continues (CPF) - Montée en compétences bureautique

    - Formations Pack Office

    Sessions collectives & individuelles sur Microsoft 365 Word, Power-Point ou Outlook
    Prise en main et compréhension approfondie de l’environnement Office, cours et applications concrètes
    Passage de la certification TOSA fin de cursus, personnalisation parcours & pédagogie

    - Formations Excel & VBA Avancées

    Cours en groupe de gestion des données pour maîtrise complète d’Excel (débutant, confirmé ou avancé) tous niveaux
    Théorie & travaux pratiques pour compréhension de l’environnement : Learning by Doing
    Concepts de base jusqu’à traitement de la Data pour visualisation (Tableaux, Tableaux Croisés Dynamiques)
    Optimisation des tâches via programmation VBA (avancé) : automatisation & projets personnalisés

    - Formations Data Analyse (Power BI, Access etc.)

    Cours de Data Visualisation pour utilisation avancée d’Excel via Power BI
    Gestion des bases de données (sources SQL, CSV) connexions & création de Dashboard
    Projet personnalisé pour mise en pratique : création BDD, pré-travail et création DataViz’
    Microsoft Office Data visualisation Pédagogie Animation de formation
  • Groupe CEMOI
    Supply Chain Intern
    AGRICULTURE
    April 2022 - October 2022 (6 months)
    Bordeaux, France
    Final Thesis (TFE) - Assistance in the Digitalization of a Production Site

    - Implementation of an Embedded Scanning System in the warehouse
    Creation of a map linked to ERP & IT creation of rack movements
    Budget management & supplier orders for barcodes and Scanners
    Change management & training of a team of forklift operators (procedures, manuals, Lean etc.)
    Computer programming, automated creation of EAN-128 labels

    - Digitalization of the storage warehouse
    Implementation of signage, field studies & operational needs
    Creation of a real-time visualization tool for pallet stocks by levels & aisles
    Development of customized operational KPIs

    - Supply Chain & Logistics Data Visualization Tools
    Needs assessment & development of customized specifications
    Leveraging company databases for real-time dashboards (Excel, PowerQuery, VBA)

    - Continuous improvement of the production output flow
    Creation of procedures for managing waste & non-conforming products (studies, writing, monitoring)
    Study of flows and mapping of product transfers
    Change management Team management Microsoft Excel Project management

Reviews

5.0

Out of 3 ratings

B

Benjamin

ATELIER BOUDER

Reviewed on 2/1/2023

Excellent listening and availability, as well as great speed.
L

Latelier

L' ATELIER DIGITAL

Reviewed on 11/7/2022

I am very satisfied with Alexandre's performance, who has the necessary and sufficient qualities to be a good trainer, namely being competent in his field and gifted in pedagogy. The person he trained knew nothing about OUTLOOK email; indeed, the initial assessment indicated a score of 1/5 and after one day of training (7 hours), the trainee obtained a score of 380 points / 1000 points, a level equivalent to mastery of only the basic functionalities of the software.

Recommendations

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

  • Generalist Engineer Degree
    Ecole Centrale de Lille
    Diplôme d'Ingénieur généraliste Solides compétences techniques transversales (informatique, science des matériaux, CAO, traitement du signal etc.) Spécialisation Supply Chain & Genie Civil
  • Data Scientist
    Le Wagon
    2023
    Formation complète Data Science, Python & SQL Big Data, Pipelines, Entrainement & Déploiement de Modèles Machine-Learning, Deep-Learning & IA

Certifications

  • Supply Chain Management Specialization
    Rutgers University
    2020
  • Excel Skills for Data Analytics and Visualization
    Macquarie University
    2021
    VBA Microsoft Power BI Microsoft Excel

Skill set

Categories