Mokhtar Théo AOUF

Data Analyst & Engineer — graduating from EFREI in October 2026, open to full-time (CDI) roles.

Download Resume

About Me

I'm a graduate of EFREI Paris in Computer Engineering, majoring in Data Engineering, with international experience across France, South Africa (Cape Peninsula University of Technology in Cape Town), and other locations — giving me a global perspective and a strong ability to thrive in diverse environments.

I am a data analyst and engineer at heart: I turn raw, messy data into reliable pipelines and clear, actionable insights. Across consulting engagements, academic projects, and independent work, I have developed the versatility to architect a cloud data pipeline and tell the story behind the numbers with equal confidence.

My expertise spans building and migrating pipelines on GCP (BigQuery, Dataform) and SQL Server, automating workflows in Python, and delivering insights through Power BI, Tableau, and Excel. I bridge complex data infrastructure and strategic business decisions — making data both trustworthy and meaningful, end to end.

Professional Experience

Delivering measurable impact through data-driven insights and strategic analysis.

Givenchy (LVMH) via Talan

Consultant Data Analyst/Engineer — Paris

BrainGain

Data Analyst/Engineer

Transdev

Data Analyst

Givenchy (LVMH): Data Architecture & Pipeline Migration

Consultant Data Analyst/Engineer — Paris, March 2026 – Present (7-month internship)

01

The Challenge

  • Givenchy needed to modernize its data infrastructure
  • Legacy SQL Server systems were limiting scalability and agility
  • Required migration to cloud-native architecture for Harrods (UK) operations
02

The Solution

  • Migrated data procedures and architectures from SQL Server to Google Cloud Platform (GCP)
  • Built ingestion and transformation pipelines for stock and pricing data from multiple sources
  • Reverse-engineered 122 SQL Server stored procedures and classification rules
  • Extracted and validated rules to map Sell-Through reporting pipeline
  • Designed scalable data workflows using BigQuery and Dataform
03

The Impact

  • Delivered modernized cloud infrastructure enabling real-time data access
  • Presented architecture recommendations and technical strategy to IT stakeholders
  • Enabled Harrods to scale operations with reliable, maintainable data pipelines
  • Reduced technical debt and improved data governance
04

Location

Paris, France

Transdev: Workforce Risk Analysis

01

The Challenge

The strategy team needed to anticipate workforce risks regarding bus driver demographics across the national fleet.

02

The Solution

I led the collection and analysis of national demographic indicators. Cleaned data with Python and modelled it for internal reports.

03

The Impact

Delivered Power BI dashboards and strategic reports presented directly to

leadership. Enabled data-driven HR planning and risk mitigation

04

Location

Paris, France

Brain Gain: Marketing Intelligence

The Challenge

The organisation required a scalable approach to optimise international marketing campaigns, with user engagement processes demanding automation to support growth objectives.

The Solution

Designed and implemented a comprehensive tracking framework for multilingual cold email campaigns. Developed an AI-powered fitness assistant to personalise user progression pathways and drive long-term retention.

Location

London, United Kingdom

3

Languages Tracked

Multilingual campaign analysis

2x

Efficiency Gain

Automated user engagement

The Impact: Enhanced campaign visibility through rigorous performance analysis, encompassing key metrics including open rates, click-through rates, and conversion benchmarks — delivering actionable insights to inform strategic marketing decisions.

Featured Projects

Transforming complex datasets into actionable insights through innovative analysis.

1

Social Media Automation & Analytics Consulting

Real Estate · March 2026

  • Built custom Instagram/TikTok automations to improve lead acquisition
  • Centralised content performance data (views, clicks, engagement rate)
  • Analysed viewing trends and user behaviour
  • Built dynamic dashboards to report KPIs to clients and guide strategy
2

Legal NLP Analysis

Academic Research Project

Extracting insights from 7,000+ legal documents

3

Global Displacement Tracker

Personal Initiative

Visualising 60 years of humanitarian crises

Legal NLP Analysis

Extracting insights from 7,000+ legal documents

Built an automated pipeline to collect and clean unstructured PDF court decisions. Applied advanced NLP techniques to extract verdicts, dates, and parties.

Visualised court acceptance rates for legal researchers. Enabled pattern recognition across thousands of cases.


Data Collection

Automated PDF extraction pipeline processing thousands of documents

NLP Processing

Structured extraction of key legal entities and outcomes

Visualisation

Interactive dashboards revealing acceptance rate patterns

Global Displacement Tracker

Visualising 60 years of humanitarian crises — Internally Displaced Populations (1960–2024)

Processed UNHCR and IDMC datasets to track internally displaced populations as a share of national population from 1960–2024. Created interactive Excel and Tableau visualizations with comparative analysis across 5 major conflict zones.

1

Data Integration

Combined multiple humanitarian databases spanning six decades

2

Analysis

Identified displacement patterns across global conflict zones

3

Publication

Shared insights on LinkedIn reaching policy and research audiences

Skills & Toolkit

Technical Skills

Python, SQL, R, Git, Excel, Google Sheets, GCP Dataform, SSMS

Advanced data manipulation and analysis

Visualisation

Power BI, Tableau, Excel, Qlik

Creating compelling business intelligence

Languages

French (C1), English (C1), Arabic (C1), Spanish (B1)

Multilingual data storytelling

Certifications/Courses

Google Data Analytics Professional Certificate

SQL, R, Tableau — October 2025

Mastering Google Dataform: Beginner to Pro

BigQuery, SQL, Dataform — March 2026

PL-300: Microsoft Power BI Data Analyst | Practice Exams

July 2026

Let's Connect

AI-Powered Portfolio Assistant

For a comprehensive overview of my professional background, technical expertise, and project portfolio, I invite you to engage with my interactive AI assistant.

The assistant is equipped to provide detailed responses regarding my analytical capabilities, tools proficiency, and career trajectory at your convenience.

Made with