Hamdi BEN GATT

Migrating one Legacy Solution to the Cloud : - Responsible for leading the data object and pipeline inventory process. - Lead the process of reverse engineering and traceback to manage the creation of missing documents in the project, such as data transformation documents and dataflow charts. - Lead the choice of the target architecture and draw the architecture documents, such as the high-level architecture,... - Enrich the functional and technical product pages on Confluence. - Responsible for upskilling the junior engineers using the reverse shadow strategy and supervising Danone's best practices that are respected through all the project steps. - Translate the legacy pipelines into cloud pipelines by ingesting raw data using Azure Data Factory from SAP and external source systems to develop the Using Databricks and Snowflake as Warehouse - Responsible for the CI/CD process by using GitHub.

Develop and maintain the cycle and procurement data platform: - Writing the technical documents for the projects, such as requirement documents, high-level architecture, dataflow diagrams, and data model documents, etc. - Leading the environment preparation process with the Azure cloud engineers. - Developing the ingestion data pipelines from internal and external source systems using Azure DataFactory, SAP, and ADLS (azure Datalake Storage). - Preparing the SSOT data based on the raw data ingested by writing Pyspark notebooks on AzureDatabricks and Snowflake as datastore. - Translating all the business rules as data transformations into warehouse objects known as Datamartsusing Databricks Notebooks using PySpark or IICS (Informatica Integration Cloud Service). - Building a project data dictionary to facilitate data mapping as we're handling heterogeneous data from different IT providers. - Prepare and lead the test processes for unitary, integration, and data quality.

Medallion Architecture POC using Databricks to replace Informatica on the warehousing pipelines : - Responsible for leading the development of the Databricks Medallion architecture and all the project documents. - Develop the warehousing notebooks equivalent to IICS flows using Databricks delta tables. - Orchestrate the medallion pipelines to run in parallel with IICS flows. - Develop Event Hub tasks and Databricks streaming notebooks to stream logs from Azure billing services. - Build a dashboard to display comparative costs for the same warehousing use case between IICS flows and Databricks jobs.

- Lead the preparation of the Linux physical servers. - Install the big data clusters and prepare all the necessary binaries for the solution. - Modeling and creating the hive database for the product. - Develop all the needed notes in Scala and Pyspark that collect data from the IN (Intelligent Network) in near real-time to stock under the HDFS storage system. - Develop all the notes that apply all the business rules for promotional campaigns for all Ooredoo's customers. - Send the data well-formatted to the tool that provides the gift in near real-time for all the flagged customers.

- Animating the workshops with all data warehouse users to gather new feature input and usage feedback. - Extend the company warehouse by developing all the needed pipelines using Informatica PWC, Talend,and PostgreDB. - Supervising the daily ETL Warehouse jobs. - Developing the data quality process to alert wrong or missing data collection. - Writing and keeping the enterprise warehousing model and documentation up to date.

I. Principal Assigned tasks: • Develop, Program and configure workflows on Applications coupled with other FE like USSD, IN, BSCS, CRM, TIBCO, WEB, and AppMobile… • Ensure the maintainability of the Platforms by supervising all the Applications Workflows and assuring the 2nd/3rd Level of Support. • Implement Award Promotions using a several tactics fixed by MKG based on top-up, Incoming Calls, receiving minute Call off Pick hours... • Implement Award Promotions using a several tactics fixed by MKG based on top-up, Incoming Calls, receiving minute Call off Pick hours... II. Strategic Projects on Loyalty Program: Upgrade Loyalty Program version by integrating a co-platform called Campaign Engine: o A brand new capability; Points Life Cycle Manager (from Creation, alimentation, consumption, expiration, to deactivation). o Launch more valuable campaigns by having more facilities. • Conducting the project through all the steps: - Expose Marketing’s requirements to provider. - Ensure the hardware and software delivery meet the provider's recommendations. - Ensure all the necessary tests. - Preparing a detailed upgrade plan. - Assure coordination between all involved teams.

• Ensure the implementation of Digital Marketing needs by integrating the banking and postal services on APPmobile and USSD : Alaways in mutual collaboration with all stakeholders in the Tunisian Financial sector (government monetics company , Banks, Post.tn, ...). • Ensure the strategic projects for the company in terms of hardware migration and software upgrade. • Provide prop to Support teams in resolving Incidents and also on applying new patchs and extensions.