Mohamed Jerbi

– Development and maintenance of complex ETL flows with Azure Data Factory (ADF) for data integration and export from multiple sources (flat files, databases, APIs). – Solving technical challenges related to handling diverse data, including optimizing pipeline performance and managing complex data formats. – Designing automated solutions to ensure real-time reliability and availability of data. – Creating basic reports and dashboards with Power BI to visualize integration results and provide a quick overview of the data for business teams. – Responsible for the technical aspect of the Greater China project, including configuring new stores and Chinese marketplaces. – Collaborating with IT and business teams to define technical requirements and align data flows with business objectives.

General context: Project ODYSSEE (Revamping of the entire information system under Oracle CC&B). Project subject: Development of restitution reports on the MS BI suite (SSRS / SSIS / Power BI / Oracle / CC&B). – Gathering functional requirements: – Framing and instruction meetings. – Defining business needs (accounting, invoicing, meter reading, customer relations, etc.). – Indicators. – Creation of reports and dashboards: – Creation of table reports, cross tables under SSRS. – Creation of dashboards under Power BI. – Queries on the replicated production database under Oracle CC&B using SQL developer. – Publication and scheduling on the portal. – Managing security on files and data. – Testing existing reports: – Reviewing and controlling report deliveries from the integrator. – User support: – Handling BI tickets. – Processing change requests and fixing anomalies. – Creating tickets in the teamforge tool for software anomalies at the integrator. – Handling occasional Ad Hoc data extraction requests.

– Consultant IBM Informix/iSQL, 4GL – Consultant Décisionnel sur Microsoft SSRS

– Problems troubleshooting: technically assist SAP BusinessObjects Planning and Consolidation customers. Interact with customers and take in charge their incidents and reclamations. – Diagnose and analyze incidents, investigate and consult SAP Knowledge Base, reproduce abnormalities in internal test environments. – Animate web and phone conferences (Netviewer and Webex sessions). – Set up and tune customers' platforms (BPC servers, web servers, SQL Server DB servers, OLAP...) in order to improve performance. – Deploy and install BPC environments (SQL Server, BPC server, Web server (IIS), OLAP server (SSAS), File share...) on virtualized test environments (VMWare Lab Manager). – Administer and manage BPC security: administration tasks, groups (Teams), member access profiles, Active Directory domains integration etc... – Create BPC reports and inputs schedules; resolve connectivity issues (data sending and retrieval). – Use Data Manager to mass-manage data (dump load, import, export etc...) – Analyze customers' needs and determine solutions for complex environments (NLB, CITRIX, clustered DB servers...). – Contribute to SAP's Knowledge Centered Support by writing technical articles: selected as the KCS Coach for the Tunisian team to ensure the quality of the written articles and to ensure that the team members comply with the KCS methodology.

– Development of a real-time monitoring application for the PBX Asterisk using Java Swing.