Oracle OFSAA EPM Developer

Role Overview

The Oracle OFSAA EPM Developer is tasked with architecting, building, configuring, and supporting Oracle Financial Services Analytical Applications (OFSAA) Enterprise Performance Management solutions. This position underpins various banking-focused components such as Enterprise Data Foundation (EDF), Profitability Management, Funds Transfer Pricing (FTP), Asset Liability Management (ALM), Liquidity Risk Management, Budgeting & Forecasting, and Regulatory Reporting, ensuring compliance with regulations, data precision, optimal platform performance, and the successful execution of projects.

Key Duties

• Design and upkeep of Oracle OFSAA EDF and related analytical data structures.
• Development and management of ETL processes, including Data Load Rules, Table-to-Table transformations, metadata setup, and staging design.
• Handling of business dimensions configuration, reference data management, and Slowly Changing Dimensions.
• Creation of Oracle SQL and PL/SQL database components, stored procedures, packages, and batch jobs, along with shell scripting.
• Configuration and deployment of OFSAA modules encompassing Funds Transfer Pricing, Profitability Management, Budgeting and Forecasting, ALM, Liquidity Risk Management, and Regulatory Reporting.
• Setting up pricing methodologies, yield curve definitions, behavioral models, liquidity premiums, and product mapping protocols.
• Implementing profitability allocation frameworks, including cost and revenue allocations, and profitability analysis by customer, product, and branch.
• Supporting financial planning via budgeting, forecasting, scenario planning, and variance evaluations.
• Configuring liquidity and risk management metrics such as LCR, NSFR, IRRBB, stress testing, cash flow modeling, and liquidity reserves.
• Designing and generating reports related to management, finance, treasury, profitability, risk, and regulatory requirements.
• Integration of OFSAA with various enterprise systems including Core Banking, General Ledger, Treasury, CRM, Payment Systems, Oracle Data Integrator, and Data Warehouses.
• Ensuring data quality through validation, reconciliation, balancing controls, and following compliance mandates.
• Engagement in solution design, system testing, deployment, production support, and post-launch intensive support phases.
• Documentation preparation such as technical details, mapping specs, deployment procedures, and knowledge transfer portfolios.
• Contributing to Agile development processes, including sprint planning, effort estimation, testing, defect management, and release coordination.

Required Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a closely related field.
• Certifications in Oracle Database, SQL, or PL/SQL.
• Training or certification in Oracle Financial Services Analytical Applications.
• Additional credentials such as FRM, CFA, or Scrum certification are advantageous.

Experience Profile

• Minimum of 5 years of Oracle Database development expertise.
• Hands-on experience in Oracle OFSAA implementation.
• Successful execution of at least two complete OFSAA implementation projects.
• Mandatory experience in banking and financial services sectors.
• Familiarity with one or more OFSAA modules including EDF, FTP, Profitability Management, ALM, Liquidity Risk, Budgeting & Forecasting, or Regulatory Reporting.
• Background in finance, treasury, risk management, MIS, or regulatory reporting environments.

Technical Skills

• Competence in Oracle OFSAA EDF and related modules such as Profitability Management, FTP, ALM, Liquidity Risk Management, Budgeting and Forecasting, and Regulatory Reporting.
• Proficient in Oracle SQL and PL/SQL for development.
• Experience with Oracle Database administration and performance optimization.
• Expertise in ETL design and data integration techniques.
• Knowledge of data modeling and data warehousing concepts.
• Skills in metadata configuration and management.
• Understanding of data quality assurance, reconciliation, and validation controls.
• Awareness of data governance standards and BCBS239 principles.
• Knowledge of banking finance, treasury, and management accounting practices.
• Familiarity with Basel III regulations, ALM, IRRBB, LCR, and NSFR frameworks.
• Understanding of profitability analysis and transfer pricing approaches.
• Experience with Oracle BI reporting and analytics.
• Ability to utilize UNIX/Linux environments and shell scripting.
• Competency in Agile delivery and project implementation methodologies.