OFSAA consultant
Alawwal bank
Total years of experience :16 years, 4 Months
● Design and implementation of enterprise performance management pack
products from Oracle Financial Software Services.
● Understanding the bank requirements and providing effective solution
in Fund transfer pricing and Profitability.
● Studying the banking data warehouse for effective loading of the data
into the Oracle Financial Services Analytical Applications staging
using Informatica.
● Designing and customizing the existing product features in Fund
transfer pricing and profitability to the client needs and help the
clients to master the applications technical aspects.
● Configuration of Oracle Financial Software Services Applications
Infrastructure - Application preferences, Batches, User security
management as well as post production support of the product.
● Part of development & implementation of multiple P&L and balance
sheet cubes enabling corporate executives to closely manage sales and
cost.
● Automated and managing the daily jobs for Essbase data load & working
with Bank's IT operations for daily data load and dimension build.
● Update/Develop Calculation scripts/member formulas and business rules
for actual and budget reporting.
● Reconciling the data between other financial systems like data
warehouse, Core banking system, fixing any issues which arises and
providing confirmation to the business users.
● Built standardized Excel Essbase template for detailed monthly
reporting. Administration & Maintenance of Hyperion Planning, Essbase
v.11.1.2.4. Provided constant support in ad-hoc Essbase reporting.
• Identify and prepare test cases for performance testing.
• Creating test setup and test bed with huge volume of data.
• Executing test cases, and identifying the performance bottlenecks.
• Analyzing pl/sql blocks for performance issues using PL SQL developer, OEM, AWR, SQL monitor, Explain Plan.
• Creating Oracle ATS scripts for front end testing using Open Script.
• Executing scripts and defect tracking.
• Planning and managing the releases of Maintenance Levels.
• Holds the ownership of planning, executing and releasing OFSAAI 7.3.2.x ML.
• Prepare and review test plans as per functional testing requirements for various business functionalities of OFSAA infrastructure ML/Upgrade Kit/Language Packs.
• Verifying product related defects in BugDB under the appropriate component with actions for simulation.
• Installing application with oracle11gr2 and different web servers in different UNIX flavors.
• Monitoring the overall status of the testing process.