Zakariae Dehbi

Designed and implemented data integration pipelines to migrate from Tidemark to IBM Planning Analytics, ensuring seamless data flow and transformation of critical analytical components within the new EPM platform. Key responsibilities and achievements include: - Designed and managed data pipelines using SnapLogic to integrate diverse data sources, ensuring reliable and efficient data flow for IBM Planning Analytics. - Automated dimension and cube population in IBM Planning Analytics, maintaining data accuracy and aligning with business logic to support financial and operational reporting. - Developed and optimized import/export processes to seamlessly synchronize IBM Planning Analytics with other enterprise systems, enabling timely and accurate data availability. - Implemented user security protocols and monitored access within IBM Planning Analytics, safeguarding sensitive financial and operational information. - Led data exports to Google Cloud Platform (GCP) via SnapLogic, facilitating advanced analytics, reporting, and machine learning capabilities on cloud infrastructure. - Continuously enhanced data integration workflows to improve system performance, data quality, and operational reliability.

Assigned to Orange as a data engineering consultant

Developed an integrated system to track customer value and analyze company performance by consolidating data from multiple sources, enabling data-driven decisions that enhanced customer relations and business strategies. Key responsibilities and achievements include: - Developed a comprehensive system to track customer value and analyze overall company performance by integrating and transforming data from multiple sources. - Created data pipelines with Talend to extract and harmonize data from diverse systems, ensuring accuracy and consistency for analysis. - Refined and optimized data using Power Query to cleanse, merge, and enrich datasets for a holistic business overview. - Built custom measures and KPIs with DAX, enabling actionable insights into customer lifetime value, revenue trends, and profitability. - Designed and deployed interactive Power BI dashboards for real-time monitoring of customer segmentation, sales, and operational metrics. - Delivered performance reports and insights that guided business strategies, enhanced customer satisfaction, and improved operational efficiency.

Led the design and implementation of a Business Intelligence (BI) solution for Capital Markets Bank, enhancing operational efficiency and decision-making. Key responsibilities and accomplishments include: - Spearheaded development of tailored datamarts to centralize and structure critical financial data, enabling faster, reliable access for reporting and analysis. - Developed ETL pipelines using Spark to process large‑scale financial datasets, improving data processing speed. - Integrated external financial data through Python-based web scraping, broadening dataset scope for comprehensive market analysis. - Developed dynamic, interactive dashboards and custom visualizations in Qlikview to monitor market trends, KPIs, and performance metrics. - Managed BI solution deployment and server optimization, ensuring high performance, security, and cross-departmental accessibility. - Delivered a scalable analytics platform that significantly improved tracking of capital market activities and supported proactive decision-making.

Implemented a Business Intelligence system to monitor and optimize the profitability of the company’s vehicle fleet. Key responsibilities and achievements include: - Designed and developed a scalable data warehouse using Microsoft SQL Server, centralizing data for efficient and accurate reporting. - Utilized SSIS for data extraction, transformation, and loading (ETL) from multiple relational databases, ensuring high data quality and consistency. - Created OLAP cubes with SQL Server Analysis Services (SSAS) to enable multi-dimensional analysis of profitability, offering drill-down insights on vehicle performance and costs. - Developed interactive Power BI dashboards to visualize KPIs, financial summaries, and operational trends, facilitating real-time decision-making. - Delivered tailored reports and dashboards to support cross-departmental decision-making and cost optimization.