- Functional and Technical analysis. - collect, clean, and interpret data sets to answer a question or solve a problem. - Functional and Technical analysis - Multidimensional modelling using Kimball methodology (Star schema: determining Dimensions and Facts). - Creation of the entity relationship diagram. - Database Creation using Erwin data modeler tool (tables, views, indexes, functions, and schemas). - Create database objects: Stored Procedures, Functions, views, and indexes using T-SQL. - Load and transform data using SSIS 2005 from DB2 dB, flat files, and Excel files to MSSQL db. - Write a script using VB.NET 2.0 in the SSIS script task. - Publish packages to SSISDB, and schedule ETL package using SQL Agent jobs. - Implementing Unit Tests (T-SQL). - Create Cognos Framework manager (Metadata modelling on semantic layer.) - Create unit tests for data integration and quality. - Design reports with Cognos Report Studio. - Write technical documents.

- Migrate data Access 2003 application MS SQL 2008R2 - Write Software technical requirements. - Design and create a user interface for a new application (VS 2008) - Write code using Visual Studio 2008 (classes, methods, functions) - Write stored procedures and functions (T-SQL) - Create unit tests for data integration and quality. - Application testing.

- Functional and Technical analysis. - Creation of the entity relationship diagram. - Developing Cognos Planning Application 5YP. - Multidimensional modeling (Star schema: determining Dimensions and Facts) - Implementing Stored Procedures using T-SQL - Designing and implementing an ETL solution using SSIS (loading 5YP DataMart from Cognos contributor db) - Design Cognos Framework manager semantic layer - Migrating BO XI catalog (universe) to Framework manager. - Create unit tests for data integration and quality. - Designing reports with Cognos Report Studio

- Functional and Technical analysis. - Data analysis to create the entity relationship diagram. - Data Vault modelling. (define HUBs, LINKs, and SATELLITES) and mapping. - Design and create a Data Vault (DWH database with HUBs, LINKs, and SATELLITES). - Datamart modelling using Kimball methodology (Start schemas). - Creation of the entity relationship diagram - Create database objects: Tables, stored procedures, views, indexes, triggers… - Writing complex SQL Queries for data loading (T-SQL). - Implementing an ETL Flow (data transform) using SSIS 2012. - Create a Tabular Cube using SSAS. - Write DAX formula for measure and KPI Calculations. - Create unit tests for data integration and quality. - Design reports using SSRS. - Publish packages to SSISDB, and schedule ETL package using SQL Agent jobs. - Monitor, and troubleshoot daily ETL job executions. - Writing documentation using EA.

- collect, clean, and interpret data sets to answer a question or solve a problem. - Designing and developing ETL (E-LT) solution using Oracle data integrator 12c with Salesforce as a source. - Designing and implementing universe using BO UDT based on Data Mart. - Designing reports using SAP WEBI 4.2 from universes. - Implementing Stored Procedures and functions using PL/SQL scripts - Create unit tests for data integration and quality - Monitor ETL executions by checking all environments' logs and notification emails. - Install VM Oracle Enterprise Linux with interface packages. - Writing complex SQL Queries for reports from the ODS layer (Oracle 12c database). - Migration of Sunopsis towards Oracle Data Integrator 12c. - Investigate issues (open tickets from business), propose solutions, and solve them using Jira. - Document ETL solutions solved tickets

- Functional and Technical analysis for new features. - Data analysis to create the entity relationship diagram. - Update of existing entity relationship diagram (multidimensional modeling using Kimball methodology). - Collect, clean, and interpret data sets to answer questions or solve problems. - Create new SQL Server objects such as tables, views, indexes, functions, and schemas. - Designing ETL solutions using SQL Server Integration Services (loading data from oracle, sql server, csv, xml files). - Maintain and correct existing SSAS Cubes, stored procedures, views, and functions when needed. - Maintain the existing DWH database and the multidimensional cube. - Create unit tests for data integration and quality. - Publish packages to SSISDB, and schedule ETL package using SQL Agent jobs. - Create Dashboards and reports using Power BI and SSRS. - Monitor daily ETL job executions. - Managing, investigating, and solving incidents on Database and ETL.

- Functional and Technical analysis: UML technique. - Database modelling using the UML technique (Creation of the entity relationship diagram). - Design and create database objects (3rd form). - Implementing Stored procedures, Functions, triggers, and Indexes (Transact SQL). - Designed and created a User Interface (Visual Studio 2019). - Application installation and testing. - Designed reports using Crystal Reports. - Documentation of the solution. - Training of the end users.

- Functional and Technical analysis. - collect, clean, and interpret data sets to answer questions and solve problems. - Data analysis to create the entity relationship diagram. - Create new SQL Server objects such as tables, views, indexes, functions, and schemas. - Write SQL queries using Transact SQL. - Designing ETL solutions using SQL Server Integration Services and WhereScape for data loading. - Publish packages to SSISDB, and schedule ETL solutions using SQL Agent jobs. - Create the QVS script file for data loading. - Create unit tests for data integration and quality. - Create a dashboard/report using Qlik Sense and publish it to the related workspace. - Create versioning with SourceTree / git, GitLab. - Document the solution on the confluence tool. - Monitor daily ETL job executions for DWH. - Managing, investigating, and solving incidents on Database and ETL.

• Installed and configured SQL Server 2019 and SQL Server Management Studio (SSMS). • Designed and delivered comprehensive SQL training materials for internal staff. • Led practical training sessions covering core SQL concepts, focusing (DDL) and (DML). • Key topics included:  Creating and dropping tables, indexes.  Developing stored schemas, functions, and triggers, procedures.  Writing and executing SELECT, INSERT, UPDATE, and DELETE queries