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

Pascal Josserand

Expert Google Sheets/Looker Studio|Python/Metabase

€500/day
5 projects
Mazamet, FR
8-15 years

Average response time: 4 hours

Freelancer profile translated to English.
Back to original language

About Pascal

Hello, and welcome to my profile!

Passionate about IT since childhood (I was already programming at the age of 10 on an Amstrad CPC 464), I have been helping organizations enhance their data for 20 years: from extraction to visualization, including transformation.

My expertise lies in structuring your data to create clear and concise dashboards, giving you a clear view of your results.

I have worked for major groups such as Pierre Fabre, Airbus, and Crédit Agricole, among others...

This background has allowed me to acquire many skills in programming (Google Apps Script, Javascript...), database management (SQL, Bigquery, MySQL, MariaDB...), spreadsheets (Google Sheets...), and finally in setting up data visualization tools (Looker Studio...).

Attentive to the respect of confidentiality, privacy, and data sovereignty, I am increasingly turning to solutions equivalent to Google tools, but natively compliant with GDPR:

- Python for programming / third-party application API management
- n8n for workflow automation
- PostgreSQL for database management
- Metabase / Grafana for Business Intelligence
- Infomaniak for hosting but also for its kSuite, which represents a good alternative to the Google office suite

You will find below screenshots of some applications I have developed. In order to respect the confidentiality of their users' data, I have entered fictitious data.

Finally, I am a rigorous, thoughtful, organized, and serious person. I enjoy working with kind, respectful people who appreciate good work. So if you recognize yourself in this description and need my help, don't hesitate to contact me!
  • Spanish

    Conversational

  • English

    Fluent

  • French

    Native or bilingual

Remote only
Primarily works remotely

Experience

  • Addexpert
    Expert Google Sheets / Looker Studio | Sovereign and GDPR-compliant Solutions
    RETAIL (SMALL BUSINESS)
    June 2025 - Today (1 year)
    Mazamet, France
    - Data extraction/transformation with Google Apps Script from MySQL/MariaDB to Google Sheets/Bigquery, then setting up dashboards with Looker Studio

    - Data extraction/transformation with Python from Strava, Shopify, and Hiboutik using their APIs, integration of this data into a PostgreSQL database, then setting up dashboards in Metabase and Grafana (self-hosted versions on a Linux Mint PC)

    - Setting up an n8n workflow to integrate data from Strava into a Google Sheets file

    - Management of Google Sheets / OnlyOffice Grids (kSuite) spreadsheets: formulas, pivot tables, data validation, custom functions...

    - Setting up a personal workspace with Infomaniak

    - Development of a CRM with GDPR-compliant no-code applications SeaTable and Timetonic

    - Technology watch

    Other technologies used: SQL, Euria (Infomaniak's ethical and sovereign artificial intelligence, GDPR compliant)
    Google Sheets Google Apps Script Google Looker Studio BigQuery Shopify
  • Wattportage
    Expert Google Sheets / Google Apps Script / BigQuery / Looker Studio / SQL
    DIGITAL AND IT
    July 2023 - May 2025 (1 year and 9 months)
    Castres-sur-l'Agout, France
    - Development and implementation of Google Sheets dashboards / spreadsheets (formulas, pivot tables, data validation, custom functions...)

    - Implementation of interactive data visualization tools Looker Studio

    - Administration of Bigquery tables and datasets

    - Development of scripts under Google Apps Script and SQL queries

    - Data retrieval from MySQL / MariaDB to Google Sheets / Bigquery using Google Apps Script
    Google Sheets Google Apps Script Google Looker Studio BigQuery MySQL/MariaDB
  • Webportage
    Expert Google Sheets / Google Apps Script / BigQuery / Looker Studio / SQL / Excel / VBA.
    DIGITAL AND IT
    March 2020 - July 2023 (3 years and 5 months)
    Castres, France
    - Development and implementation of Google Sheets dashboards / spreadsheets (formulas, pivot tables, data validation, custom functions...)

    - Implementation of interactive data visualization tools Looker Studio

    - Administration of Bigquery tables and datasets

    - Development of scripts under Google Apps Script and SQL queries

    - Development of scripts under Excel, VBA
    Google Sheets Google Apps Script Looker Studio BigQuery SQL

Reviews

5.0

Out of 5 ratings

C

Charles

Imediaweb - Imédia360

Reviewed on 12/4/2020

Top!
C

Charles

Imediaweb - Imédia360

Reviewed on 9/4/2020

Responsive and proactive, top mission!

Recommendations

CD
FU
FU
Charles Davrinche and 2 other people have recommended Pascal

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

  • DUT Statistics and Data Processing
    IUT de Carcassonne
    2004
    4ème de la promotion.
  • Professional Title: Higher Technician in IT Support
    AFPA de Castres
    2012
    Certificats de Compétences Professionnelles «Intervenir et assister à distance en centre de services informatiques», «Intervenir et assister sur les systèmes et les réseaux informatiques», «Intervenir et assister sur les applications informatiques transverses».

Skill set

Categories