Othmane Touri

• Data sourcing for analytics and reporting. • Use of virtualization tables on Hive (HUE), with integration and transformation of data in Dremio. • Creating data extractions for stakeholders in Dremio using SQL. • Designing and implementing SQL joins and views in Dremio based on the star schema approach to optimize analytical queries. • Design and implementation of business Data Marts tailored to functional requirements. • Development of management dashboards and control reports in Tableau Desktop, aligned with key business indicators. • Compliance with mockups validated with business teams via Figma during scoping workshops, ensuring consistency and deliverable conformity. • Participation in validation meetings, and documentation of KPI deliverables. • Publishing and maintaining dashboards on Tableau Server, with automated data updates.

Retail Banking : - Electronic Payment Systems : Card transactions (Mastercard, Visa , Visa Platinum) - ATMs withdrawal Analysis. - New Customers Tracking - Monthly Commercial Reporting on Credit and Debit Balances. - Relationship Intensity Monitoring - BMCI Connect Application Subscription Analytics RISK : - Analysis of Guarantees and Authorizations - Monitoring of Irregularities and Unpaid Accounts. OPC (Operational Permanent Control) : - Providing data extractions for business operations. - Overseeing transaction control, conducting compliance checks, and managing operational risk effectively. - Monitoring and managing fraud operations to ensure secure and reliable processes FATCA (Foreign Account Tax Compliance Act) : - Reporting to the Internal Revenue Service (IRS). - Identifying accounts held by U.S. persons or entities, collecting the required information (such as account balances, transactions, and personal identification information), and reporting this data to the IRS to ensure compliance with U.S. tax laws. PDP (Personal Data Protection): - Regularly reviewing and updating data protection policies to comply with regulatory requirements and safeguard against data breaches. • Developing Monitoring dashboards in Tableau Software. • Developing Data Flows in Tableau Prep for post-cleansing and aggregation. • Developed measures using Tableau's calculation fields. • Managing dashboards at every stage from Development to pre-production to full-scale production. • Incorporating evolving needs expressed by dashboard owners. • Proactively identifying and resolving anomalies in the dashboard functionality. • Managing authorization and access to dashboards for all users. • Conducting demonstration workshops for users. • Defining (KPIs), sourcing, and modeling their data. • Drafting reports for various meetings and workshops with stakeholders. • Review user stories in Jira, breaking down epics into manageable tasks for data analysis.

• Applied McKinsey’s structured problem-solving approach using agile thinking. • Strengthened communication and influence across teams and stakeholders. • Built adaptability, resilience, and a future-ready mindset for dynamic work environments. • Gained practical skills in data-driven decision-making and digital collaboration tools.

• Developed interactive dashboards, reports, and visualizations using Power BI. • Utilized Power Query for data cleansing and transformation, ensuring high-quality data for analysis. • Designed and implemented efficient ETL processes using SSIS. • Developed data integration workflows, cleansing routines, and data validation processes. • Applied data modeling techniques to structure and organize data. • Utilized DAX for advanced calculations, measures, and KPIs. • Conducted in-depth analysis to identify trends, patterns, and opportunities. • Provided data-driven recommendations to enhance customer segmentation, pricing, and marketing strategies, utilizing machine learning insights for personalized targeting. • Collaborated with cross-functional teams and presented findings to stakeholders to support decision-making. Clients : Valrhona / Groupe Savencia / Andros / La Maison du Chocolat / deNeuville / Auchan