👋 Great to have you here! I'm Eric, a Data Analyst at Sophia Engineering.
🍷 I have a background of 8 years in the wine industry. During this time, I discovered Python programming because I was learning QGIS to help me manage vineyards.
🎓 I've Completed a first year of computer science while working, followed by numerous online courses on programming, data analysis, and data science through platforms like Coursera, EdX, and France Université Numérique.
🌍 One of my first personal projects was to create a plugin for QGIS (Point Cadastre).
📈 My journey into data analysis began with a simple interest in handling data, thanks to Excel pivot tables. I enjoy sifting through data, creating meaningful charts, and understanding the story it tells.
🖊️ Apart from my work, I also write on Medium about data analysis, career shifts, and upcoming technologies like AI and LLMs.
💻 I'm a contributor to Taipy, an open-source Python application builder.
📸 Besides technology, I love photography and exploring new places. I believe that creativity and curiosity are essential qualities for any data analyst, and I try to bring these qualities to both my work and my hobbies.
- Primary Language: Python for data analysis, visualization, machine learning, and building AI tools
- SQL: Proficient in writing complex analytical queries, including window functions, subqueries, and joins
- R: Familiarity with the R programming language for statistical analysis and data visualization
- Web Development: Familiarity with the "classic" web stack (PHP + JS + HTML + CSS + SQL)
I enjoy learning new programming languages and tools, and staying up-to-date with new technologies by attending conferences, taking online courses, and participating in coding challenges.
The following non-exhaustive list shows some libraries I've used for some projects:
| Tasks | Libraries |
|---|---|
| Data Manipulation & Transformation |    |
| Data Visualization |     |
| Data Mining |   |
| Geospatial analysis |     |
| ML, DeepLearning, LLM apps |     |
| Application builders |   |
| Others |   |
I have a strong background working with various types of databases, including:
- Enterprise data warehouse databases such as IBM Netezza and PostgreSQL. I'm proficient in data modelling.
- Web application databases such as MySQL and PostgreSQL
- Small databases for personal apps or test projects using SQLite and DuckDB
As a data analyst, I have experience using a variety of tools for data analysis and visualization. Some of my key skills include:
- Excel: I am proficient in using Excel for data analysis, and I have experience developing VBA macros. I am also skilled in using Power Query to import and transform data from various sources, and I can use DAX to create calculated columns and measures.
- Data Visualization Tools: I have used Power BI and Tableau, I'm also familiar with Tibco Spotfire.
- Spatial Analysis: I love using QGIS for spatial analysis. In fact, my interest in spatial analysis is what led me to programming in the first place!
While my primary focus is on data analysis and programming, I also have experience with cloud, DevOps, and infrastructure tools that enable me to work efficiently and collaboratively. Here are some of my key skills in this area:
- Cloud Services: I have experience using cloud services such as IBM Cloud and Google Cloud Platform. I am familiar with cloud computing concepts, such as virtual machines and containers.
- Linux and Bash: I use Linux and Bash for command-line operations.
- Docker: I can use Docker to containerize applications, making it easier to deploy and manage them in different environments.
- Version Control: I use Git for version control and collaboration on code projects. I am familiar with Git workflows, branching, and merging.
- Conda Environments: I use Conda environments to manage dependencies and create isolated environments for my projects.
I enjoy experimenting with large language models (LLMs) and building LLM-based applications. Here are some of the technologies I've used in my LLM projects:
- Access several closed models like OpenAI's GPT 3.5 and GPT 4, or Gemini via API (using Langchain).
- Access Open models from Hugging Face with Transformes and Langchain. I've had a special focus on Mistral 7B.
- I've used Hugging Face's transformers library for fine-tuning LLMs on specific tasks.
- I've worked with Chroma's embedding-based search engine for improving the performance of LLM-based applications.
If you want to contact me, here are all my social accounts:
If you want to support my work, you can follow me on Medium or on YouTube:
You can also visit my KoFi:
