Project: Al Rajhi Bank KSA.• Working on the BRD’s Business required documents and Information sourcing to verify the mapping documents.• Development of the CORE layer by using Teradata BTEQ’s and informatica command tasks for BTEQ execution.• Development of the Semantic layer Facts and Dimensions by using the Informatica Power Center 10.2.• Extraction and processing data from Teradata Database.• Test and validate the Informatica mappings.Project: BUPA Insurance Company.• Develop ETL processes in MSSIS.• Writing queries and procedures in MS SQL server.• Develop data warehouse in MS SQL server.• Data validation by applying different test case scenarios.• Developing & deploying reports & dashboards with Power bi Report builder.

Project: Kuwait Airways.• Develop ETL processes of Airline using IBM Info Sphere Data Stage.• Develop data warehouse in Oracle.• Query optimization.• Writing queries in Oracle (Toad) to test and validate the data.• Moving & migrating data from operational & external environments to business intelligence environment. Project: Investment Company BI Report.• Develop ETL processes in MSSIS. • Writing queries and procedures in MS SQL server.• Develop data warehouse in MS SQL server.• Data validation by applying different test case scenarios.• Design model in Power BI. • Developing & deploying reports & dashboards with Power BI. Project: GR-Farms BI Report.• Develop data warehouse in MYSQL.• Writing queries, procedures and Events to populate the refreshed data.• Data validation.• Design model in Power BI. • Developing & deploying reports & dashboards with Power BI.