Tarek Trabelsi

• Currently advancing my skills on Python

• Collecting Stakeholders needs, and identifying data ownership models.
• Animating workshops and identifying technical specifications and priorities.
• Creating SQL tables on DataMart.
• Engineered and maintained tabular models in SSAS to support advanced business logic and high-performance analytics.
• Data validation with the IT team and the product owners post data extractions
• Creating and maintaining power bi dashboards
• Training end-users and implementing data-related security roles to Stakeholders

Technologies: SSIS, SSAS, SSRS, Power BI, SQL SERVER, JIRA, CONFLUENCE, PowerShell, Agile (scrum)

• Developed secure, reusable data pipelines using Azure Data Factory and integrated them with SSIS workflows.
• Implemented a fully automated power bi reports for HR and accounting departments based on Stakeholder’s needs
• Implemented security roles
• Consuming APIs via SSIS “geo APIs “to add more layers of details
• Optimizing existing ETL jobs and reducing the execution time
• Migrating SharePoint files to SQL ODS
• Ensured GDPR-compliant data flows using managed identities and row-level security rules.
• Creating a monitoring system that allows us to identify any job error
• Creating SSRS dashboard to enable the stakeholders to track the product's related errors

Technologies: SSIS, SSRS, SQL SERVER, MS DYNAMICS 365, POWER BI, SharePoint, Atlassian JIRA, Confluence, Agile (Scrum)

• Led migration of legacy ETL workflows to SSIS and Azure pipelines, integrating flat files, APIs, and databases.
• Implement a data warehouse and a DataMart for Geismar France (Mapping, Data modeling)
• Data Integration using SSIS and multiple Information systems (SAP HANA, SALESFORCE, Flat Files, InforM3, BC central)
• Optimizing existing ETL jobs and reducing the execution time by 90%
• Creating a monitoring system that allows us to identify any job error and solve data related problems
• Maintained and optimized SSAS tabular models and SSRS reports for financial monitoring and HR KPIs.
• Used SSRS to generate custom exportable reports for legacy systems
• Tasks and priority management

Technologies: AZURE, SSIS, SSRS, SALESFORCE, SHAREPOINT, InforM3, Business central, Power apps, SQL SERVER, SSIS, POWER BI, Atlassian JIRA, Confluence, Agile (Scrum), azure Data Factory, Azure Devops, GIT

• Implement data mappings between ERP & DYN365
• Support the creation of a migration plan and governance post - migration
• Data Integration using SSIS and multiple Information systems (SAP HANA, Dynamics 365 and flat files)
• Creating a monitoring system that allows us to identify any job error and solve data related problems
• Extract and load data into power bi reports
• Maintaining ETL jobs
• Trained multiple users on the usage of the reports

Technologies: AZURE, SALESFORCE, SAP HANA, Infor M3, Business central, Power apps, SQL SERVER, SSIS, POWER BI, Atlassian JIRA, Confluence, Agile (Scrum), azure Data Factory, Azure Devops, GIT

• Participated in scoping workshops and collaborated with stakeholders to gather and translate business needs
• Designed and implemented functional and technical dashboards using Power BI
• Extracted and transformed CRM data (Microsoft Dynamics 365) for reporting purposes
• Developed logic to handle data inconsistencies and implemented alert systems for quality control
• Documented data models, reporting logic, and technical installation guides for future support
• Worked with SQL, SSIS, SharePoint, and Excel to build integrated BI workflows

Technologies: SSIS, SSRS, DYN365, Windows server, power bi

• Participated in client workshops to collect BI reporting needs and define project scope
• Supported the development of SSRS reports and dynamic dashboards using Power BI
• Assisted in data integration tasks using SSIS and SQL queries for cleaning and structuring source data
• Created and tested data extraction flows for Excel and CSV inputs, ensuring format consistency
• Contributed to functional documentation and user guides for reporting solutions

Technologies: SSIS, SSRS, SAP HANA

• Assisted in building SSAS tabular models to support business logic and enable multi-dimensional analysis
• Supported the development and testing of SSRS dashboards based on marketing and operational KPIs
• Collaborated with analysts to validate cube dimensions, hierarchies, and business measures
• Helped identify and correct inconsistencies in source data during cube processing and report generation
• Participated in report layout reviews and implemented user-focused improvements to navigation and filtering

Technologies: SSIS, SSAS, SQL SERVER, GITLAB