Freelancer profile translated to English.
Back to original languageAbout Olivier
Hello,
I work with companies of all sizes to carry out their projects. Entrust me with your needs and I will be able to analyze your project, engage in its design and make every effort to achieve it.
I am a business-trained analyst with a strong interest in data. I have more than 10 years of experience in the energy field and I am bilingual in English. As a former financial journalist, I also have a strong concern for popularization and simplicity.
📁 Excel/VBA/Power Query:
✔️ Data entry, cleaning, calculation and formatting.
✔️ Automation tools: planning, stock or invoice/quote management.
✔️ Improvement of existing tools: adding functionalities, user experience.
✔️ Creation of Power BI dashboards.
🐍 Python:
✔️ Web scraping: data extraction directly on the HTML page (Beautiful Soup, Selenium), in structured files (CSV, Text, Excel) or via an API.
✔️ Data cleaning and formatting (Pandas).
✔️ Data presentation with graphs or maps (Matplotlib, Bokeh, Seaborn).
✔️ File management: renaming, copy-paste, etc.
✔️ Creation of a dashboard (Flask) or entry form.
📊 Data analysis:
✔️ Statistical modeling of time series (Statsmodel, Scikit-Learn, TensorFlow).
✔️ Geographic data analysis (Shapely, Geopandas, Pyproj, OSMnx).
✔️ Analysis of optical or radar satellite images (Rasterio, Snap).
📈Consulting:
✔️Description and visualization of your data (exploratory analysis, descriptive statistics).
✔️Business analysis (data mining, statistical tests, dashboards, explanation of complex phenomena, presentation of results).
✔️Training of one or more employees.
🌐 Web Development:
✔️ Creation of a website (HTML/CSS).
✔️ Mobile optimization (Bootstrap).
✔️ Natural referencing/SEO.
English
Native or bilingual
Remote only
Primarily works remotely
Experience
- Pyramidale communication
On Malt
Extraction, cleaning and migration of dataCONSULTING AND AUDITSApril 2021 - April 2021Paris, FranceMigration of customer data from one CRM software to another. The old software had provided excel files containing errors and a MySQL database with 150 disparate tables. Using Python, I was able to extract the useful data for my client, merge them together and create a csv file that could be used by the new software. I also configured the new CRM software with this data. - Data Is The New OilData scrapingPRESS AND MEDIAJanuary 2021 - February 2021 (2 months)Paris, FranceConstruction of a textual data scraping model with Beautiful Soup, Selenium and Pandas. The script scans hundreds of different sites and thousands of references.
- RhineForecast.comHydrological forecasting modelSOFTWARE PUBLISHINGJune 2020 - December 2020 (7 months)Paris, FranceConstruction of an online model for forecasting Rhine levels, used by several energy companies (Shell, Total) to plan their operations:⚪️ Data scraping of unstructured data (on HTML page) or structured data (text files, CSV, API).⚪️ Construction of a machine learning model for forecasting water levels, based on the weather. It works as well as a classic hydrological model.⚪️ Creation of an interactive application using the Flask library and HTML templates using Bootstrap, HTML5 and CSS3.⚪️ Application management using Heroku and Amazon Web Services.⚪️ Writing a regular blog on Rhine levels.
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
- European Affairs 🌍Sciences Po Lille2007
Certifications
- Dive into BootstrapOpenClassrooms2020
- Deep Learning SpecializationCoursera2020