Senior Consultant

• Aug 2015 - Present

Elm National Labor Observatory Project Brief Description: ------------------------- Extract Data from Different Agencies/Ministries to One Centralized Staging Area, then Move Data to another Database to Build a Data Warehouse for Reporting Purpose in order to Measure and Enhance Saudi Labor Market. Role: ------- Project Team Lead. Based on the Business Requirements Specification, the Data Model is Designed and ETL Jobs are Designed and Developed accordingly. Elm National Labor Observatory Project Brief Description: ------------------------- Extract Data from Different Agencies/Ministries to One Centralized Staging Area, then Move Data to another Database to Build a Data Warehouse for Reporting Purpose in order to Measure and Enhance Saudi Labor Market. Role: ------- Project Team Lead. Based on the Business Requirements Specification, the Data Model is Designed and ETL Jobs are Designed and Developed accordingly.

Senior ETL Consultant

• Jan 2010 - Jun 2015

Riyad Bank Insight Program new requirementsBrief Description:-------------------------Change Requests and Issues Supporting.Role:-------Technical analysis of source systems to identify the technical requirements in order to meet the business requirements.Provide design documents of required ETL mappings and/or PL/SQL stored procedures of data marts.

Senior ETL Consultant

• Nov 2008 - Dec 2009

Riyad Bank Insight Program Phase II (Data Warehouse for Corporate Customers)Brief Description:-------------------------Extract Data from Different Source Systems (Treasury and ALGO Systems) to One Centralized Staging Area, then Move Data to OFDM Database for Reporting Purpose.Implementation Tools: ---------------------------------Informatica 8 PowerCenter for Back-EndSAS for Front-EndRole:-------Development of ETL Mapping for Data Warehouse Phase II from Source to Staging and from Staging to Data Warehouse Database.Development of PL/SQL Procedures and Functions for pre/post Mapping. Show less

Senior ETL Consultant

• 2015 - 2015

ETL Administration and Development

• May 2008 - Oct 2008

ALINMA Bank Project(Enterprise Data Hub) Brief Description: ------------------------- Alinma Enterprise Data Hub Provides One Centralized Area Available for Other Work Streams like Multi-Channels and Party Master. Implementation Tools: -------------------------------- Informatica 8 PowerCenter Role: ------- Informatica Server Installation and Administration (HP System). Informatica ETL Mapping for Centralized Data Hub. Extracting Data from Temenos/T24 (XML-Oracle Based) Core System. Dealing with XML Transformation, XSD, Primary/Foreign Key Relationships. Show less

ETL Developer

• Jan 2008 - Apr 2008

Riyad Bank Insight Program Phase I (UCM-Siebel)Brief Description:-------------------------UCM System is the Owner of Master Customer Information in Riyad Bank. Master Customer Information(Name, Address,…) is Collected Online through Siebel Screens. However, Slave Information is Collected as Daily Batch. Implementation Tools:-------------------------------Informatica 8 PowerCenter for Back-End.Siebel Tools for Front-EndRole:-------Development of Back-End Informatica ETL Mapping to Siebel-EIM Interface Tables. Complex Relations and Ranking of Customer Information for Initial Load.ETL Initial Loading of Customer Information.ETL Daily Loading of Updated Slave Customer Information. Show less

ETL Developer

• Aug 2007 - Dec 2007

Riyad Bank Insight Program Phase I (Data Warehouse for Retail Customers)Brief Description:-------------------------Extract Data from Different Source Systems to One Centralized Staging Area, then Move Data to OFDM Database for Reporting Purpose.Implementation Tools: ----------------------------------Informatica 8 PowerCenter for Back-EndSAS for Front-EndRole:------Development of Informatica ETL Mapping from Source Systems to Staging Area and from Staging to Data Warehouse.Extracting Data from Different Source Types: Oracle, DB2, SyBase, SQL Server, Informix, PowerExhange and Flat Files.Complex Aggregations and Transformations(Dates, Strings, Characters, Numbers). Show less

Data Quality Analyst

• Feb 2007 - Jul 2007

Riyad Bank Insight Program Phase I (Data Quality)Brief Description:-------------------------DQ Assessment and AnalysisImplementation Tools: --------------------------------IDQ and Informatica ProfilesRole:------Development of Informatica Auto Profiles and Custom Profiles.Applying Integrity, Consistency, Conformance and Completeness rules.Applying Aggregations and Business rules.Providing Solutions about how to do Automatic and Manual Data Cleansing. Show less