Othmane BENBELLA

Mission for L'Oréal Global D2C Team

• Designed and implemented data models & ELT workflows for D2C business dashboards (Bigquery, GCS, Cloud Functions, BigqueryML, Git, Docker, Python, SQL, Terraform, Confluence & Jira, CI/CD ..)
• Designed and created the business dashboards (Looker Studio, Javascript, Figma ..)
• Conducted UX & Product research to improve customer journeys & website features (BigqueryML, SQL, Slideware ..)
• Conducted Data analysis/science projects to generate performance insights to business stakeholders (Python, SQL, Bigquery, Scikit-Learn, Slideware ..)

• Statistical Analysis to measure media spend optimization's impact on revenue (Python, Marketing Mix Modeling)
• Automation of the statistical Analysis for future needs (Python)

• Clustered client churners based on navigation behavior & interests using ML, to personnalize CRM communication (K-means, PCA, Bigquery, Python, Scikit-learn, R).
• Created & updated Dashboards in Tableau
• Automated product procurement predictions for Supply Chain team (Bigquery, Python, GSheet API, Git ..)
• Automated merchandising via API calls & crawlers (Selenium, Python, GSheet API, Git ..)
• Automated creation of daily, weekly, & monthly business reports (python, smtplib, gsheet API, Tensorflow, Seaborn ..)
• Created web crawlers to monitor competitors' pricing (Selenium, Scrapy, Python, Bigquery, Git ..)

• Automated data scraping and database enrichment processes (Python, Scrapy, Selenium ..)
• Developed an ML model for news article categorization (Python, Keras, spaCy, XGBoost ..)
• Led a freelance team tasked with data entry and extraction (guru.com, Communication ..)

• Performed audits of operational and financial areas to check compliance.

• Researched dynamics between French brands and Chinese retailers.
• Assisted in devising a crowdfunding strategy.

• Performed customer service and administrative duties.