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 consists of structuring your data to create synthetic dashboards, in order to give you a clear vision of your results.
I have worked for major groups such as Pierre Fabre, Airbus, Crédit Agricole, among others...
This background has allowed me to acquire numerous skills in programming (Google Apps Script, Javascript...), database management (SQL, Bigquery, MySQL, MariaDB...) and spreadsheets (Google Sheets...), and finally in implementing data visualization tools (Looker Studio...).
Attentive to respect for confidentiality, privacy, and data sovereignty, I am increasingly turning to solutions that are equivalent to Google tools but natively GDPR compliant:
- Python for programming / managing third-party application APIs
- 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 like to work with pleasant, respectful people who appreciate a job well done. So if you recognize yourself in this description and need me, do not 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 - June 2026 (1 year)Mazamet, France- Data extraction/transformation with Google Apps Script from MySQL / MariaDB to Google Sheets / Bigquery, then dashboard implementation 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 dashboard implementation with Metabase and Grafana (self-hosted versions on a Linux Mint PC)- Implementation of an n8n workflow to integrate data from a Shopify store- 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- Technological watchOther technologies used: SQL, Euria (Infomaniak's ethical and sovereign AI, 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 of 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».