Freelancer profile translated to English.
Back to original languageAbout 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
- AddexpertExpert Google Sheets / Looker Studio | Sovereign and GDPR-compliant SolutionsRETAIL (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 watchOther technologies used: SQL, Euria (Infomaniak's ethical and sovereign artificial intelligence, GDPR compliant)
- WattportageExpert Google Sheets / Google Apps Script / BigQuery / Looker Studio / SQLDIGITAL AND ITJuly 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
- WebportageExpert Google Sheets / Google Apps Script / BigQuery / Looker Studio / SQL / Excel / VBA.DIGITAL AND ITMarch 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
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
- DUT Statistics and Data ProcessingIUT de Carcassonne20044ème de la promotion.
- Professional Title: Higher Technician in IT SupportAFPA de Castres2012Certificats 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».