Olivier van Overstraeten

Olivier van Overstraeten

💼 Professional experience

Agilytic

Data Science Expert Since 2022

  • Customer Service: Building a chat bot that automatically handle customer complaints using a mix of LLM and classical chatbot technologies.
  • Public service: Uncover and summarize the IT strategy of hundreds of public institutions by using web scraping and LLM for content classification.
  • Retail: leveraging LLM agents to build a self-service querying system on top of the existing Data Warehouse
  • Pharma: Modeling and optimisation of supply chain processes, to reduce the delivery time by a month, leading to significant gains
  • Debt recovery: Development of a tool to automatically score the probability to recover at every step of the process
  • Real Estate: Development of a tool to help the client explore new opportunities, from scraping and consolidating internal and external data sources. Using AI to monitor building’s energy consumption. Provides a real-time consumption deviation alerting system and an in-depth consumption analysis report
  • Media: Building a model to better predict the attribution of campaigns based on historical data
  • Retail: Using AI to model the drivers of churn of a retailer insurance product. Results in a reduced attrition and a reviewed customer lifecycle management approach.
  • Stock optimization: Helping a parapharmacy distribution center review its stock management approach. We use AI to better anticipate the effects of seasonality and promotions.
  • Pricing optimization: Developing a price monitoring tool for a self-storage company. The data were collected on competitors web site and made available through a centralized app.

Haystack consulting

Data Science Team Lead 2019-2022

  • Lead the Data Science team. Responsibilities: Customer segmentation, predictive modelling, dashboarding, advanced analytics and data processing.
  • Develop a web-based Data Platform that automates the creation of clients and internal dashboards / reports.

Technologies : R, Shiny, Python, Power BI, SPSS

McKinsey & Company

Data Science Specialist 2016-2019

  • Product Owner of a Big Data platform that leverages professional social media information to improve HR processes (CV screening, competition benchmarking, hiring strategy).
  • Develop machine learning algorithms in the Human Resources domain and advise client on their Big Data strategy and roadmap.

Technologies: Python, TensorFlow, R, Elastic Search, AWS Glue, AWS Athena, Snowflake, Tableau

Delhaize Belgium

Team lead customer analytics 2013-2016

  • Lead the customer analytics team. Responsibilities: Customer buying behaviour analysis, segmentation, Targeted/1to1 marketing, strategic reporting/analysis.
  • Customer 360 database owner: Owner of the customer big data strategy and implementation.
  • Development of new analytical models:
    • Marketing: recommendation engine (next best offer), promotion sensitivity (uplift modelling), price elasticity, customer lifecycle management (loyalty segmentation, loyalisation modelling).
    • Procurement: assortment optimization tool.
    • Finance: sales forecasting methodology.

Technologies used: R, SAS, Google BigQuery, DB2, Microstrategy

Vadis Consulting

Consultant / Project leader Data Science 2008-2013

  • Lead projects involving from 2 to 6 consultants/developers.
  • Predictive modelling projects: customer value estimation, lead generation model, churn and up-selling models, marketing campaign optimization, risk models and fraud detection.

Technologies: R, SAS, Rank, SQL Server, Amadea

Sectors: Retail, FMCG, e-Commerce, Banking, Data Brokers, Market Research and Public institutions.

Departments: Marketing & Sales, Finances, HR and Procurement

🦾 Certifications, trainings

Methodologies

  • Machine learning/statistics: regression, classification, clustering, time series forecasting, NLP, deep learning (Tensorflow, PyTorch).
  • Datawharehousing
  • Agile

Software & programming

  • Certified AWS cloud practitioner 2022
  • Data programming: R, Python, SAS, SQL, VBA
  • Data visualization, reporting: Tableau, Power BI, Microstrategy, Shiny
  • Database: SQL Server, DB2, Elasticsearch, Snowflake, AWS-Athena, Redshift, Google-BigQuery

🎓 Academic credentials

  • Master in Statistics UCLouvain, 2008
  • Master in Sociology UCLouvain, 2007 Magna cum laude

🇺🇳 Languages

🇫🇷 French: native

🇬🇧 English: professional proficiency

🇳🇱 Dutch: conversational

🔐 Proprietary and confidential. 💡 Profile CVs are provided for illustration purposes. ✅ Planning of specific experts will be secured upon formal agreement.

Logo
LinkedInInstagramFacebook