Meryem MALIKI

– Developed and optimized PL/SQL procedures, packages, and scripts for Oracle data integration and reporting. – Managed and maintained Oracle Data Warehouse solutions, ensuring data quality and performance. – Designed SAP BusinessObjects Universes and developed Webl reports for business users. – Developed and orchestrated Microsoft Fabric Data Pipelines for automated data ingestion and transformation. – Created and maintained Apache Airflow DAGs for Oracle data ingestion and workflow automation.

Experience at Deloitte - Key Projects 1. Development and Management of BI Data Flows – Designed and orchestrated data pipelines using Azure Synapse. – Integrated multi-source data (ERP, CRM, SAP) through BizTalk. – Implemented ETL processes with SSIS, OLAP modeling with SSAS, and Power BI dashboard design. – Deployed On-Premises Gateways to ensure real-time data refresh. – Optimized queries and migrated data to the cloud to enhance performance and scalability. 2. Employee Staffing Monitoring – Designed Power BI dashboards to analyze consultants workloads, track HR trends, and forecast staffing needs. – Automated reporting and implemented notifications through Power BI Service. 3. Chatbot for Commercial Pitches – Developing an intelligent chatbot leveraging – and web scraping. – Generating personalized sales pitch materials based on an enriched knowledge base. 4. Burnout Tracking and Prevention – Set up a reporting and analytics system using Excel, Access, and Power BI in order to ientifie potential burnout risks and provided preventive action recommendations.