Bilel Ouali

Implementation of an end-to-end Big Data platform

• Product Owner — Bridge between stakeholders and technical teams. Facilitating user workshops, materializing business needs into deliverables (flows, algorithms, dashboards), building the product roadmap, managing the JIRA backlog and SCRUM ceremonies.

• Lead Data — Audit of existing systems, definition of data architecture, implementation of data collection, centralization, exploitation, and exposure.

• Data Engineering (SQL, Python, Shell, Git, S3) — Monitoring of the Vertica DWH (volume, sessions, access, and privileges). ELT ingestion from S3 datalake to DWH with transformation and historical tracking. Star schema optimized for batch and BI querying performance.

• Data Analytics (Vertica, Superset) — Implementation of standard and advanced KPIs through decisional scoring rules. Machine Learning algorithms for usage evaluation, monitoring, and predictive maintenance. Responsive dashboards to manage internal activity and promote the product externally.

• AI Innovation — Prototyping of an internal GenAI solution based on MCP (Model Context Protocol) enabling business users to query DWH data via natural language prompts, with dynamic widget generation as output.

Customer targeting and marketing campaign performance measurement

• Project Manager — Scoping business needs, structuring deliverables, managing the backlog, and coordinating stakeholders (CRM, Marketing, IT) in agile mode (JIRA).

• Data Engineering — Identifying relevant data sources, integrating and automating flows to the Teradata DWH. Implementing a comprehensive automation system for multichannel marketing campaigns (SMS, email, print, call center) on Salesforce Marketing Cloud, for the group's strategic offers (FTTH, cross-sell, upsell).

• Analytics — Designing an attribution model to identify the campaign that triggered conversion (Teradata). Creating a library of dynamic Tableau dashboards for park management and campaign performance tracking.

Delivery of deliverables using SAS and SQL: customer scoring, segmentation, ad hoc analyses on Teradata DWH.