Ryad BEN ABBA

Lead data migration initiatives, focusing on data preparation, transformation, and delivery of validated datasets for integration into SAP and Salesforce by IBM. Built and optimized data pipelines on Databricks (PySpark) and Azure Data Factory, ensuring reliable migration from legacy sources to target structures. Delivered automated outputs (Excel/CSV via Azure Blob Storage) to IBM migration teams, streamlining integration into SAP. Actively contributed to the drafting and review of Functional Design Specifications (SFDs), bridging business requirements and technical implementation. Participated in the migration from Google Data Platform legacy sources to a new enterprise data platform, leveraging dbt and modern ELT practices to standardize data models. Acted as technical lead for transformation rules, quality controls, and workshops with business teams and IBM consultants. Supported the migration and redesign of Power BI dashboards, creating new KPIs and visualizations to strengthen reporting during the transition.

Participated in the migration of management control data from on-premise systems to Azure Cloud, handling interface contracts and developing target tables to ensure smooth data transfer. Designed and maintained data integration pipelines on Azure and Oracle EPM, automating consolidation for finance and risk reporting. Developed and optimized SQL Server views and stored procedures in SSMS to improve performance and reporting accuracy. Enhanced existing Azure Data Factory pipelines, ensuring scalability, monitoring, and data quality controls. Collaborated with finance and IT stakeholders to align reporting needs with data models and ETL processes. Improved reporting efficiency and reliability, reducing manual processing and accelerating delivery cycles.

Contributed to the migration of BI and analytics workloads to Google Cloud Platform (GCP) and Snowflake, modernizing data architecture for sales and marketing teams. Built and automated ETL pipelines integrating multiple sources into centralized data models, improving data accessibility and governance. Developed interactive Power BI dashboards (sales performance, customer behavior, campaign ROI) adopted by business stakeholders across France and Spain. Designed and optimized SQL queries and data models, reducing report generation time by 40%. Collaborated with marketing and finance teams to translate business needs into actionable KPIs and analytics solutions.