Oracle OFSAA SME

Position:

Oracle

OFSAA SME

Location:

Buffalo, NY (Onsite for now / Might be Hybrid later)

Summary:

We are seeking a highly specialized

OFSAA SME

to own and optimize our Oracle Financial Services Analytical Applications (OFSAA) infrastructure. The candidate will be responsible for the end-to-end data flow-from the Enterprise Data Warehouse (EDW) through OFSAA modules-to ensure accurate regulatory reporting, profitability analysis, and risk management.

Job Description:

8+ Years of relevant experience Bachelor s degree in computer science, Finance, or Accounting (CPA or MBA is a plus).

OFSAA Platform & Data Model :

Deep knowledge of the OFSAA Architecture and the underlying Financial Services Data Foundation (FSDF) is mandatory. Experience with the Data Integration Hub (DIH) and modeling tools like ERwin is often required.

Database & Scripting :

Since OFSAA is Oracle-based, PL/SQL is critical for writing queries, tuning performance, and processing data. Unix shell scripting is also frequently listed for automation and batch management. performance tuning, and data modeling (Erwin or similar).

Middleware & Reporting :

You should be comfortable deploying applications on web servers like WebLogic or WebSphere . For analytics, experience with tools like Oracle Analytics Server (OAS) is valuable. OFSAA Platform (AAI, RRF, FSDF, ERwin), Databases (Oracle PL/SQL), Middleware (WebLogic), Scripting (Unix), and Reporting Tools (OAS). End-to-end implementation, installation, configuration, data integration (T2T/DT/DIH), batch management, and troubleshooting.

Banking & Finance:

Deep understanding of financial banking statements, General Ledger processes, and Management Accounting.

Risk Analytics:

Proven experience in Profitability Management, Funds Transfer Pricing (FTP), or ALM (Asset Liability Management).

Regulatory Awareness:

Familiarity with US GAAP, IFRS, and regulatory reporting requirements for large financial institutions. Experience merging models from different OFSAA instances or migrating from legacy risk systems (SAS, Axiom, Moody''s). Experience with Financial Crime modules (FCCM, AML, KYC).