Virtusa - OFSAA FTP Consultant

Description :

We are seeking a skilled OFSAA FTP Consultant with 8-12+ years of experience in Banking/Finance services to lead the design, upgrade, and optimization of the Funds Transfer Pricing (FTP) module within the Oracle Financial Services Analytical Applications (OFSAA) suite. Strong understanding of banking profitability concepts and FTP methodologies.

The candidate must have expertise in technical aspects (OFSAA architecture, data models, System maintenance, SQL/PLSQL,ETL and Reporting) and understanding functional aspects (business requirements, FTP methodologies, balance sheet management, profitability analysis, and interest rate risk insights).

The role covers endtoend FTP lifecyclefrom data sourcing and quality controls, to rule design and execution, to performance optimization, reconciliation, controls, and production supportensuring accurate, explainable, and auditable results that reconcile to Finance and Treasury.

Roles and Responsibilities :

- Work closely with business stakeholders to gather and analyze Funds Transfer Pricing (FTP) requirements.

- Ability to bridge the gap between business ,technical and Data teams in translating functional requirements into technical solutions.

- Define and configure FTP methodologies such as Matched Maturity, Multi-Pool, Cost of funds, Break funding, Liquidity Premium models, Net interest income, net interest margin,etc.

- Ensure FTP configurations align with regulatory requirements and banking profitability strategies.

- Conduct User Acceptance Testing (UAT) and ensure FTP calculations align with expected results.

- Set up rate curves (market/reference curves, liquidity premiums, administrative spreads), product hierarchies, and balance mappings aligned with Chart of Accounts and product taxonomy.

- Hands on experience in OFSAA FTP version of 8.0.6.X and above.

- Design batch schedules and dependency graphs for daily/weekly/monthly FTP runs.

- Operate and fine tune OFSAA batch processing (FTP engine, ALM interface if applicable), optimize indexes/partitions, and resolve performance bottlenecks.

- Monitor job runs, troubleshoot failures, perform root cause analysis, and apply permanent fixes across database queries and system configurations, batch configuration; maintain run-books and support playbooks.

- Strong SQL, PL/SQL, performance tuning, and ETL skills for handling large financial datasets.

- Hands-on experience in Application setup, System upgrade, Patch installation ,batch optimization, OFSAA environment migration, and production deployments

- Experience in reporting the product related issues and challenges with Oracle support team, co-ordinate with necessary stakeholders, applying due diligence in sharing the necessary information/logs with Oracle support and apply the resolution for issues, challenges, vulnerability patches,etc.

- Implement environment management (DEV/SIT/UAT/PROD), refresh processes, and change control (versioning, migration packs).

- Support downstream consumption (Power BI, OBIEE/OAS, data warehouse) and adhoc analysis for Finance, Treasury, and ALCO.

- Enforce model governance: document assumptions, parameters, and change logs; support model validations and internal/external audits.

- Implement and maintain access controls, segregation of duties, batch approvals, and auditable evidence for period closes.

- Hands-on with OFSAA components: Data Model (FSDF), Metadata Manager, Rule & Allocation Frameworks, FTP Engine, LRM/ALM interfaces (nice to have).

- Experience with data integration (ETL tools, ODI/Informatica/SSIS or equivalent), and enterprise schedulers (ControlM, Autosys, or similar).

- Reporting exposure (Power BI, OBIEE/OAS) and data warehousing concepts (star/snowflake, semantic layers).

- Familiarity with Git/version control, CI/CD for config migration, and Linux scripting (bash, shell).

- Implement robust DQ controls (completeness, accuracy, timeliness, duplicates, referential integrity) and reconciliation to GL/sub-ledgers.

- Manage data lineage and documentation from source to OFSAA entities and downstream reports.

- Basic understanding of Agile methodology.

- Excellent problem-solving, communication, and documentation skills