souhail cherni

• Data Extraction and Web Scraping : Extracted data from Jira Software in Excel format, including project risk reports and issue tracking information, and performed web scraping from Wiki to gather and enrich risk-related data.
• Data Warehouse Design and Modeling : Designed and modeled data warehouses to effectively structure and relate multiple data tables for analytical processing.
• Data Cleaning with Python : Cleaned a raw data using Python to prepare datasets
• ETL Integration with Talend : Executed data extraction, loading, and transformation (ETL) processes using Talend to integrate cleaned data from various sources into a unified data repository.
• KPI Creation and Dashboard Development with Power BI : Developed Key Performance Indicators (KPIs) and created dynamic measures with DAX; built interactive dashboards in Power BI to visualize data and provide actionable insights.
• Dashboard Deployment with React.js : Deployed interactive BI dashboards on a website using React.js, incorporating user session login functionality for secure access to data insights.
• AI Chatbot Development with NLP: Developed a chatbot using Natural Language Processing techniques, leveraging PDF documents and word similarity. 02/2024 - present Tunisia

07/2023 - 09/2023 Paris

05/2023 - 07/2023 Tunisia

06/2022 - 09/2022 Tunisia

• Managed LinkedIn profile as page administrator; dynamically extracted data from multiple LinkedIn APIs in JSON format using Talends TREST component.
• Designed and modeled a data warehouse to structure and manage the extracted data.
• Performed data transformation and loading into PostgreSQL with Talend.
• Prepared Key Performance Indicators (KPIs) and developed visual dashboards in Power BI based on the processed data.

• Extracted data from a MongoDB database and cleaned it using Python.
• Designed and modeled a data warehouse to structure
• Utilized SSIS for data integration and loading into PostgreSQL.
• Prepared Key Performance Indicators (KPIs) and input data into PostgreSQL for visualization.
• Developed visual dashboards and performed forecasting in Power BI for predicting results for upcoming years.

• Collected data from 30 bank branches using T24.
• Cleaned data using RStudio.
• Integrated data with SQL Server.
• Prepared KPI s and fed data into Power BI for visualization.
i used power bi and talend and excel