Title : SWIFT SARIE Messages Online and Retrieval Archiving SystemDuration : June 2017 Database : Oracle 11gDescription : The proposed solution will allow to read the swift messages from BESS system directly using ODBC HPNON STOP driver on production and also will read the historical swift files to load it on the database based on the swift structure. The solution will avail Archived SARIE\SWIFT messages to any other channel required other than the provided front End inquiry screens and reports.Responsibilities: • Extract Different Messages Types from Bess system using ODBC HPNON Stop Dirver.• Extract Historical Messages Types from Source excel files.• Validate messages components depends on the extract messages from the extract component. and have revalidate after correction of invalid messages • Convert the swift messages to the database based on the structure and it will include (199, 295. 296, 999, 195, 999, 210, 103, 102 )• Data Correction (The Source of the Data correction component is the invalid message from the validate message components) • Transform Messages to Structured XML (Transform to XML component apply its process on the validated standard messages only, which have standard parsers Libraries to transform to XML)• Convert Structured XML to Structured Staging DB• Load Structured valid messages from source system to target system to be available for inquires, monitoring and decision support

Title : Siebel CDCDuration : September 2016Database : Oracle 11g Description : The project objective is to Build a real-time Operational-Warehouse for Siebel using Informatica-CDC feature. Informatica-CDC will capture all the data modification for the pre-defined scope to be replicated in a near real-time mode into the new Operational-Warehouse. Responsibilities: • Meeting business owners to sensitive data should be masked.• Build new Operation-Warehouse Model for Siebel source tables included in-scope list.• Target Model should take into consideration to match the source model for the following: - Future requirements which is triggered by any new functionality on Siebel. - Decrease the replication time from Siebel to the new target DB. - Decrease/Eliminate the impact on the current EDWH extraction jobs once they are migrated to ready from the new CD Replica.

Title : Data Masking ProjectDuration : September 2015 Database : Oracle 11g & SQL SERVER 2008Description : The project objective is to - Create smaller subsets from production database which used for testing and development purposes- Mask/scramble the sensitive data while creating the data subsets and change the data physically in the Non-Production systems only.Responsibilities: • Meeting business owners to sensitive data should be masked.• Identify the tables relationships related to the sensitive data identified in previous step• Get a consultation excursive to study which data types, systems and attributes are going to be masked as a part of this scope• Developing the masking rules for Persistent Data Masking (PDM) for non-prod environments• Create subsets of data across applications, databases from a single environment that’s easy to use and maintain• Testing on some test environments which should be provided by Border Guard Production deployment• Final business testing on the Production• Handover to DBA and System Administrator• Develop a user guide specific for the Border Guard contains all instructions to run, stop, monitor the masking processes• Train BG Team how to deploy the masking rules to any environment.

Project Name : SWIFT SARIE Messages Online and Retrieval Archiving SystemDatabase : Oracle 11gDescription : The proposed solution will allow future expansion of the solution through Utilizing data Transformation connectors to read more SWIFT message types Without much efforts and be up To date with SWIFT message format changes in The future. Moreover, the solution will avail Archived SARIE\​SWIFT messages to any other channel required other than the provided front End inquiry screens and reports.Responsibilities: • Extract Different Messages Types from Source Flat Files • Validate messages components depends on the extract messages from the extract component. and have re-validate after correction of invalid messages • Data Correction (The Source of the Data correction component is the invalid message from the validate message components) • Transform Messages to Structured XML (Transform to XML component apply its process on the validated standard messages only, which have standard parsers Libraries to transform to XML)• Convert Structured XML to Structured Staging DB• Load Structured valid messages from source system to target system to be available for inquires, monitoring and decision support

Project Name : Informatica Data Masking ProjectDatabase : Oracle 11g & SQL SERVER 2008Description : The project objective is to implement the proper data masking protocols to the sensitive data that the bank identified. The data masking scope will be for production and non-production environments (UAT, SIT, Development, etc.).Responsibilities: • Requirements gathering, analysis, design and documentation activities• Developing the masking rules for Dynamic Data Masking (DDM) for Prod environments • Developing the masking rules for Persistent Data Masking (PDM) for non-prod environments• Develop test plans in cooperation with First Bank ( internal testing, integration testing, system testing, UAT )• Develop a user guide specific for the First Bank contains all instructions to run, stop, monitor the masking processes• Develop training specifications for First Bank• Give the First Bank users training to how to use masking application including how to run/stop masking process and how to monitor the masking processes• Train First Bank support staff how to deploy the masking rules to any environment

Project Name : File Based Integration Architecture Framework Database : Oracle 11g Description : Riyadh Bank acts as a mediator between the sender banks worldwide and the beneficiary banks resides in Saudi Arabia for remittance and account to account transfers between them.• B2B File-based Integration with Informatica B2B Data Exchange and Data Transformation: provides different protocols (FTP, web portal page, attached email) and different formats (xml, structured/unstructured based) for sender bank to send file.• Informatica PowerCenter: validating and processing the file with the bank middleware services Technical support for Powercenter. Involved in Informatica Technical Support Team for projects in development environment and in production.

Project Name : Converting unstructured files to Xml files Database : Oracle 11g Description : Bank Al-Bilad is an Islamic Bank, offers banking services in the Kingdom of Saudi Arabia. BAB ODS is the Operational Data Store for the daily transactional data, which stores data from difference systems to files within the bank (Loans, GL, and Payment Systems etc.). Informatica is used as Integration tool to Convert files from unstructured files to xml files and after that convert xml files to database Responsibilities: • Perform source system analysis, provide estimations and prepare technical design documents• Convert unstructured files to xml files using Informatica B2b Data transformation • Designing and developing the ETL mapping using Informatica Power center by understanding existing business model and customer requirements.• Use swift library to convert swift messages to xml files.• Use power center to convert xml files to database.