VS01643 - OFSAA ERM Functional Consultant

E4 Software Services Pvt Ltd.; India; On-site; INR 900,000 - 1,300,000; Full time

Job summary

E4 Software Services Pvt Ltd. is seeking a skilled functional consultant to gather requirements and configure OFSAA ERM modules across ALM, LRM, Basel, and FTP. You will map business needs into functional designs and collaborate with senior consultants and clients throughout the project lifecycle.

The role involves preparing FRDs, test plans, and gap analyses, plus participating in workshops and training sessions to ensure production readiness.

Qualifications

• Experience in functional consulting for OFSAA or risk/finance domains.
• Understanding of RBI, EBA, Fed, PRA, MAS regulatory frameworks is a plus.
• Ability to translate business requirements into OFSAA configurations.

Responsibilities

• Gather and understand functional requirements with senior consultants and stakeholders.
• Configure OFSAA ERM modules including ALM, LRM, Basel, FTP, or PFT.
• Prepare FRDs, mapping sheets, and gap analyses for client projects.
• Participate in client workshops and provide functional clarifications.
• Document configurations, rule logic, and test findings; support SIT/UAT.
• Collaborate with data engineers, QA, and project leads; escalate risks as needed.

Skills

Analytical thinking

Client communication

Independent working

Detail orientation

Stakeholder collaboration

Education

Bachelor's in Finance or related field

OFSAA or risk-related certifications (FRM/CFA)

Tools

OFSAA ERM modules

OFSAA Rule Framework

Cash Flow Engine concepts

Job description

• Work with senior consultants and business stakeholders to gather and understand functional requirements.
• Analyse regulatory and internal risk requirements in areas such as ALM/IRRBB, Liquidity (LCR/NSFR), Basel III/IV, FTP, and stress testing.
• Support the creation of functional requirement documents (FRDs), mapping sheets, and gap analyses.

2. Functional Configuration of OFSAA ERM Modules

• Perform hands-on configuration within OFSAA including:
• Product behaviours & bucketing rules
• Allocation rules, transformation rules, and calculation rules
• Configure metadata, dimension hierarchies, member attributes, and rule dependencies.
• Run test scenarios for ALM, LRM, Basel, FTP or other modules during SIT/UAT.
• Validate scenario outputs, cash flows, rates, balances, risk metrics, and KPI calculations.
• Support reconciliation of OFSAA outputs with business expectations and source system data.

4. Data & Mapping Support

• Work with technical teams to clarify functional data requirements for staging and foundation layers.
• Review mappings, data dictionaries, DIM/FCT attributes, and business rule translation requirements.
• Validate data loads from a functional standpoint (completeness, correctness, business logic alignment).

5. Testing & Documentation

• Prepare test cases, expected results, and traceability matrices for SIT and UAT.
• Document configuration setups, rule logic, scenario assumptions, and test findings.
• Track functional defects, analyse root causes, and work with technical teams on resolution.

6. Client Interaction & Functional Support

• Participate in client workshops, walkthroughs, and solution demos.
• Provide functional clarifications to the client and internal teams.
• Assist in user training, handover documentation, and production readiness activities.
• Collaborate closely with technical consultants, data engineers, QA teams, and senior functional leads.
• Escalate risks and issues promptly with appropriate functional insights.
• Support project management with inputs for effort estimation and planning for assigned modules.

Required Skills & Experience

Functional Skills

• Strong understanding of core banking products: loans, deposits, securities, derivatives, cash management.
• Working knowledge of risk management areas such as:
• ALM / IRRBB
• Liquidity (LCR/NSFR) & funding gaps
• Basel regulatory calculations
• FTP methodologies (basic familiarity)
• Ability to interpret business requirements and translate them into OFSAA configurations.

OFSAA Product Skills

• Hands-on experience in at least one OFSAA ERM module (ALM, LRM, Basel, FTP, or PFT).
• Understanding of:
• OFSAA Rule Framework
• Cash Flow Engine concepts
• DIM/FCT structures
• Scenario and assumption setups
• Knowledge of OFSAA interface and model execution lifecycle.

Soft Skills

• Strong analytical, conceptual, and problem-solving skills.
• Good communication skills to explain functional logic to technical teams and clients.
• Ability to work independently on assigned modules with minimal supervision.
• Detail-oriented with strong documentation habits.

Preferred Qualifications

• 3–6 years of experience in OFSAA or risk/finance functional consulting.
• Experience in at least one regulatory framework (RBI, EBA, Fed, PRA, MAS).
• Exposure to ALM/Liquidity analytics or basic quant knowledge is a plus.
• Degree in Finance, Economics, Banking, Risk, or related field.
• OFSAA or risk-related certifications (FRM/CFA) are a plus but not mandatory.