Acceptance Testing, Business Analysis, Case Management, Cloud Computing, Consulting, Customer Escalations, Data Management, Data Mapping, Data Migration, Data Modeling, Data Quality, Database Extract Transform and Load (ETL), Engineering Change Management, Enterprise Sales, Establish Priorities, Event Management, Functional Testing, Insourcing, Leadership, Maintain Compliance, Oracle, Oracle PL-SQL, Process Modeling, Product Lifecycle, Reconciliation, Regulatory Compliance, Regulatory Reports, Regulatory Requirements, Regulatory Submissions, Release Management/Engineering, Requirements Management, SQL (Structured Query Language), Surveillance, Test Data, Testing, Traceability, Validation Testing
JD:
Role Purpose
We are seeking experienced OFSAA FCCM ECM Consultants to design, configure, and deliver enterprise-scale Financial Crime Case Management (ECM) solutions within the Oracle OFSAA FCCM suite. The role involves hands-on development, workflow configuration, data integration, and solution leadership for AML, Fraud, and Surveillance programs.
Core Responsibilities
1. OFSAA FCCM ECM Development & Configuration
• Design and develop ECM workflows using PMF (Process Modelling Framework)
• Configure case lifecycle management, alert handling, escalation, and disposition logic
• Build custom actions for SAR/STR filings and regulatory reporting workflows
• Customize event management and case management modules (ECM, CRR)
2. Data Model & Integration
• Customize and extend OFSAA FCCM data models (FSDF / FSDM)
• Perform source-to-target data mapping, transformation, and data quality controls
• Develop ETL pipelines using ODI / DIH or equivalent tools
• Support integration across alerts, cases, customer, account, and transaction data layers
3. Workflow & Business Logic Enablement
• Implement complex workflow scenarios (multi-level approvals, investigations, escalations)
• Configure security matrix (role-based access for investigators, supervisors, compliance users)
• Tune alert thresholds, prioritization, and routing logic
• Enable case enrichment and narrative generation capabilities
4. Solution Delivery & Lifecycle Management
• Lead / contribute to end-to-end FCCM implementations (upgrade, migration, or net new)
• Support agile delivery (design → build → test → deploy)
• Manage multiple releases / phases including data migration and functional rollout
• Ensure compliance with regulatory requirements (BSA, AML, FATCA, etc.)
5. Testing, Validation & Governance
• Perform/support:
o Functional testing (SIT/UAT)
o Data validation and reconciliation
o Workflow and case lifecycle validation
• Ensure data quality, lineage, and traceability across FCCM processes
6. Stakeholder Engagement (Manager+ expectation)
• Engage with:
o AML Operations / Financial Crime SMEs
o Technology & Data teams
o Product teams (Oracle)
• Translate business requirements into ECM configurations and workflows
• Provide solution design guidance and estimation
Critical Skill Requirements
Mandatory
Strong experience in:
• Oracle OFSAA FCCM (ECM, Event Management, CRR)
• PMF workflow design & configuration
• FSDF / FSDM data models
Hands-on with:
• SQL / PL-SQL
• ODI / ETL / Data Integration tools
Understanding of:
• Case management lifecycle
• Alert generation and disposition frameworks
• Compliance with BSA / FATCA / global AML standards
Preferred
• Prior experience supporting vendor transitions or insourcing programs
• Professional certification like CAMS, CAMI, SAFe PO/PM, CSM, CSPO
• OFSAA FCCM on-prem and cloud certifications
• Exposure to OFSAA upgrades (8.0.x → 8.1.2.x)
• Data migration and platform modernization
Top Skills:
• Oracle OFSAA FCCM expertise (ECM, Event Management, CRR) — the core platform skill; the role is built around designing, configuring, and delivering Financial Crime Case Management solutions in this suite.
• PMF workflow design & configuration — hands-on Process Modelling Framework skills for building ECM workflows, case lifecycle, escalation, and disposition logic.
• FSDF / FSDM data modeling plus SQL/PL-SQL and ODI/ETL integration — customizing/extending the OFSAA data models and building the data pipelines that feed alerts, cases, customer, account, and transaction layers.
Additional Information:
• Key deliverables: End-to-end FCCM implementations (upgrade, migration, or net-new); ECM workflow configuration via PMF; custom SAR/STR and regulatory reporting actions; data model extensions and ETL pipelines; SIT/UAT testing and data reconciliation; solution design guidance and estimation.
• Stakeholders you'd engage: AML Operations / Financial Crime SMEs, Technology & Data teams, and Oracle product teams.
• Additional/preferred qualifications: Vendor transition or insourcing experience; certifications (CAMS, CAMI, SAFe PO/PM, CSM, CSPO); OFSAA on-prem and cloud certs; OFSAA upgrade experience (8.0.x → 8.1.2.x); data migration and platform modernization.
• Unique selling points: Enterprise-scale, hands-on solution-leadership role spanning AML, Fraud, and Surveillance programs — blends development, configuration, and delivery leadership rather than a narrow build-only role.