 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, 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.

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.

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.

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.

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.