Yasmina Sekal

• Design and modeling of BigQuery datamarts from CRM, transactional, loyalty, product, and media data with high volume. • Development of industrialized SQL transformations and preaggregated tables feeding Power BI and Looker Studio dashboards. • Centralization and reconciliation of multiple sources, with definition of business and deduplication rules for clients, transactions, and revenues. • Optimization of BigQuery models and queries through partitioning, clustering, and reduction of scanned volumes. • Implementation of Data Quality controls on volumes, duplicates, client matches, and discrepancies between sources and outputs. • Conducting advanced client analysis: segmentation, purchase behavior, loyalty, retention, contactability, and campaign impact measurement. • Construction of before/after methodologies and exposed/control groups, then supporting business teams in KPI definition and result interpretation. • Tools: BigQuery, SQL, Dataiku, Power BI, Looker Studio, GCP, GitHub, SharePoint, Copilot Studio.

Consulting mission within the Watches & Fine Jewelry division, specialized in data. I work within Chanel's Watches & Fine Jewelry division on digital data issues with a dual site-centric (GA4) and media-centric (SEA, Display, Social) approach, working closely with the marketing, e-commerce, CRM and data science teams. Main tasks : • Design and deployment of 15 Power BI dashboards covering digital, media, social, and e-commerce performance, for over 50 active users. • Construction of a GA4 data model in BigQuery, documented and scalable, to meet cross-market analysis needs. • Development of automated pipelines for media and social data integration from GCS and the Emplifi API to BigQuery. • Optimization of BigQuery architecture and queries, allowing an 86% reduction in processing and storage costs. • Conducting strategic analyses: media investment contribution, multichannel attribution, and correlation between sales and investments. • Training internal teams in SQL and Power BI, writing documentation, and disseminating data best practices. • Tools: Power BI, Google Analytics 4, Google Cloud Platform (GCP), BigQuery, Looker, Alteryx, Emplifi. Goal: Provide reliable, accessible and actionable data to drive digital strategy in an international luxury environment.

• Consulting missions in Analytics Engineering, Business Intelligence, Web Analytics, and Data Quality for major accounts. • Design of data models, pipeline automation, and development of BI dashboards. • Conducting ad hoc analyses and supporting business teams in KPI definition. • Contribution to the recruitment and support of data consultants.

• Design and delivery of SQL courses applied to marketing analysis, from beginner to intermediate level. • Creation of practical cases, exercises, and exams, then evaluation and support of students.

Consulting mission: Creation of a custom Kinaxis connector (supply chain tool) on PowerBI

• Ad hoc analysis of business performance for the L'Oréal Dermatological Beauty division • Creation of several Power BI dashboards to track business performance • Tools: PowerBI, BigQuery, Excel

• Data audit and definition of quality rules to ensure the reliability of flows and databases. • Development of an anomaly detection algorithm to automatically identify errors and flow breaks. • Design of a Data Quality dashboard to monitor and communicate reliability indicators. • Tools: Snowflake, Azure Machine Learning, Python, Jupyter Notebook, Qlik Sense

• Gathering business needs, defining KPIs, and writing requirements for B2B and B2C activities. • Data audit and reliability, then structuring new databases in collaboration with Data Engineers. • Conducting ad hoc analyses and designing a Web Analytics dashboard to track traffic and conversion. • Tools: SQL, Redash, Husprey, Notion.

• Extraction and structuring of client data, conducting RFM segmentations and CRM analyses. • SQL query quality control and design of a CRM dashboard to track performance. • Tools: Snowflake, Qlik Sense, Piano Analytics, Excel.

• Development of an automated pipeline between Matomo and BigQuery using Cloud Functions and Cloud Scheduler. • Design of a Looker Studio dashboard and training users on its use. • Tools: Matomo, Looker Studio, BigQuery, GCP, Cloud Functions, Cloud Scheduler.

English tutor for 5th and 9th grade students.

• Analysis of digital performance of TotalEnergies' websites and advertising campaigns. • Design of Web Analytics dashboards and training materials for business teams. • Tools: Google Analytics, AT Internet, Reeport, Google Business Profile.

• Analysis of advertising revenues and production of financial reports for senior management. • Online management, monitoring, and analysis of desktop, mobile, and in-app advertising campaigns in coordination with the Trading Desk. • Design of Data Studio dashboards and post-campaign reports to optimize media performance. • Tools: Google Analytics, Google Ad Manager, Data Studio, Salesforce.

• Creation of a new communication platform. • Realization of the press review (Capitalization of the press view on the vehicles). • Synthesize and give the technical references and issues and decrypt the trends that will make the car of tomorrow.