Riyad Bank has developed an excel model with the help of McKinseys for its Cost and Budget Allocation as per the industrystandards. The model follows a three-stage waterfall allocation of expense items from back-office functions to front-officesegments.Profinch solutions been contracted to transform the excel model into a fully automated allocation system using Oracle FinancialServices Profitability Management application.

Islamic Development Bank (IsDB) as part of implementing Enterprise Risk Management (ERM) system has engaged MoodysAnalytics and E&Y to implement the following solutions:1. Moodys Analytics Risk Foundation solution for Enterprise Data Warehouse (EDW)2. Moodys Analytics RiskConfidence solution for ALM (Static Behavioural) FTP Dynamic analysis and cashflowprojections3. Moodys Analytics RiskFoundation Discovery (RFOD) a BI tool to implement reports for the Risk & Finance teams.

As part of the Finance Digitalization project Mashreq Bank decided to automate all their existing reports (most of them are onExcel sheets) using Microsoft Power BI. The aim is to automate the end-to-end reporting process as well as give a self-servicereporting model so that the stakeholders have more control on the reports.

Mashreq Bank has an existing ALM solution implemented using OFSAA ALM 8.0.4 and decided to implement IRRBB using thesame solution and revamp the existing LRR & IRR Gap reports.

 Around 7.3 Years of experience in implementing GRC EPM solutions using OFSAA 4.7.x and OFSAA 8.0.x

 Hands on Experience in implementing and upgrading OFSAA EPM Solutions(ALM,FTP & PFT).

 Hands on Experience, Comprehensive Functional & Technical Knowledge on Governance, Risk and Compliance (GRC) in Banking.

 Sound Application Knowledge of OFSAA – Oracle Financial Services Analytics Application 4.7.x & 8.0.x Versions.

 Expertise in end-to-end implementation of OFSAA ALM solution from Application installation to System Design, Configuration, Testing, User Trainings, Deployments and Production support.

 Expertise in SQL/PL-SQL Programming and Performance Tuning.

 Good problem solving and technical skills coupled with confident decision making for enabling effective solutions for the Business leading high customer satisfaction.

As part of IT transformation the Ithmaar bank has decided to automate the banks Assets and Liability Management LiquidityRisk management using Oracle Financial services Analytical Applications ALM & LRS solutions. To source the data from Banksdata mart to OFSAA staging layer bank has also licensed OFSAA Data Integration solution (DIH).

As part of IT transformation, the Ithmaar bank has decided to automate the banks Assets and Liability Management, Liquidity Risk management using Oracle Financial services Analytical Applications ALM & LRS solutions. To source the data from Banks data mart to OFSAA staging layer, bank has also licensed OFSAA Data Integration solution (DIH).

OFSS has implemented OFSAA 8.0.5 EPM solutions (ALM, FTP, PFT) for Al Rajhi Bank and has a contract to provide post production support from the client premises.

OFSS had implemented OFSAA 8.0.5 EPM solutions (ALM FTP PFT) for Al Rajhi Bank and has a contract to provide post-production support from the client premises.

BLC Bank has decided to upgrade its existing OFSAA EPM 5.6 solutions (ALM, FTP & PFT) to OFSAA EPM 8.0.6 and OFSS has been selected as the implementation partner. It is an as-is Upgrade from the current EPM 5.6 to OFSAA 8.0.6 without changing any existing banks EPM processes.

BLC Bank decided to upgrade its existing OFSAA EPM 5.6 solutions (ALM FTP & PFT) to OFSAA EPM 8.0.6 and OFSS had beenselected as the implementation partner. It was an as-is Upgrade from EPM 5.6 to OFSAA 8.0.6.

The GRC solution provides a comprehensive framework to manage governance, risk and Compliance across the organization. This solution provides a mean to manage banks Operational Risk Management, Internal Audit and Regulatory Compliance Management needs. Operational risk management is responsible for providing a framework for identifying, measuring, monitoring and managing all risks within the scope of the definition of operational risk. Financial institutions and supervisors need to manage operational risk due to a growing number of high profile operational losses. OFS GCM takes the core Operational Risk solution the next level where the audit teams can oversee and review all risks and controls across the line of business, while recording their notes, opinion and ratings. The Compliance managers needs to know various regulations wherever the firm does business. This application allows them to make sure each part of the business knows how those regulations affect them, as well as ensuring that those regulations are fully complied.

The GRC solution provides a comprehensive framework to manage governance risk and Compliance across the organization.This solution provides a mean to manage banks Operational Risk Management Internal Audit and Regulatory ComplianceManagement needs.Operational risk management is responsible for providing a framework for identifying measuring monitoring and managing allrisks within the scope of the definition of operational risk. Financial institutions and supervisors need to manage operational riskdue to a growing number of high-profile operational losses.OFS GCM takes the core Operational Risk solution the next level where the audit teams can oversee and review all risks andcontrols across the line of business while recording their notes opinion and ratings. The Compliance managers needs to knowvarious regulations wherever the firm does business. This application allows them to make sure each part of the business knowshow those regulations affect them as well as ensuring that those regulations are fully complied.

Oracle Funds Transfer Pricing (FTP) is the application for implementing a matched rate transfer pricing system. Oracle Funds Transfer Pricing calculates transfer rates at the lowest possible level of detail in your institutions balance sheet, the instrument record level. OFSAA Profitability Management delivers complete, accurate, and inclusive profiles of profitability. Profitability Management links general ledger, account level, and statistical data together to produce detailed financial statements for individual business units, products, and customers.

ORION is HSBC groups system of record for capturing and reporting Operational Risk data. It is designed to benefit both Businesses and Functions by providing better insight into HSBCs Operational Risk profile. It is also aligns Risk and Control activities across multiple risk disciplines on a single technology solution.

ORION is HSBC groups system of record for capturing and reporting Operational Risk data.It is designed to benefit both Businesses and Functions by providing better insight into HSBCs Operational Risk profile.It is also aligns Risk and Control activities across multiple risk disciplines on a single technology solution.

BLC Bank decided to upgrade its existing OFSAA EPM 5.6 solutions (ALM, FTP & PFT) to OFSAA EPM 8.0.6 and OFSS had been selected as the implementation partner. It was an as-is Upgrade from EPM 5.6 to OFSAA 8.0.6.

Duration: Oct’18 to Feb’19

Environment: OFSAAI 8.0.6, OFSAA ALM 8.0.6, OFSAA PFT 8.0.6, OFSAA FTP 8.0.6, OBIEE 12c, Oracle Solaris SPARC 11.3, Oracle Database 12c, Weblogic 12c, Erwin Data Modeler 9.5

Role: Technical Principal Consultant

Activities:

Clone the Current Production OFSAA EPM 5.6 solution to the Development server.
Data model merging and upgrading the existing OFSAA Infrastructure from 7.2 to 7.3.0.0 to 7.3.5.0 to 7.3.5.1
Install OFSAA 8.0.6 (ALM, FTP, PFT) by merging their data models on a new OFSAA instance.
Migrate from the EPM 7.3.5 to OFSAA 8.0.6 using the migration utility.
Merge and Deploy ALM BI with the existing RPD.
Unit & System Integration testing to conclude existing process are carried to the new system.
Train and support the users during UAT.
Deployment of OFSAA Applications on Production and DR setup.
Provide post production support.

Responsible for manging the OFSAA Production and DR servers.
Loading the data from Bank data mart to OFSAA staging area with the help of ETL team daily.
Executing batch jobs to load, instrument and dimensional data from staging to OFSAA FSI Layer.
Running and monitoring the ALM & LRM BAU batch jobs daily.
Verify the results using the Reporting layer for the cashflows generated.
Running and monitoring the monthly FTP, PFT & PRRBB batch process.