Oracle Data Migration Functional Analyst

Key Responsibilities

Functional Responsibilities

1. Work closely with finance teams to understand business requirements and translate them into Oracle ERP solutions.
2. Configure, test, and implement Oracle Financial modules, including

   GL, AP, AR,

   in both

   EBS R12 and Fusion Financials

   .
3. Perform gap analysis and recommend solutions to optimize financial processes.
4. Provide functional support for end-users and assist in

   UAT, training, and documentation

   .
5. Work with business users to define

   Chart of Accounts (COA), Multi-Currency, Ledger Setup, and Reporting requirements

   .
6. Support month-end and year-end financial closing processes.

Technical Responsibilities

1. Perform

   data migration

   from EBS R12 to Fusion Financials, ensuring accuracy and consistency in financial data.
2. Develop custom reports, using

   PL/SQL, and FBDI/ADFDI tools

   .
3. Design and implement

   integrations between EBS, Fusion Financials, and third-party systems

   using

   Oracle Integration Cloud (OIC)

4. Write and optimize SQL queries, stored procedures, and performance tuning for Oracle databases.
5. Troubleshoot and resolve

   technical issues related to data migration, reporting, and integrations

   .
6. Develop and maintain

   custom forms, personalization, and extensions

   for EBS R12.
7. Work on

   Incident, Problem, and Change Management

   within ITIL frameworks.

Required Skills & Qualifications

Experience & Technical Skills

1. Experience

   : 510 years of hands-on experience in Oracle Financials, with expertise in both

   EBS R12 and Fusion Financials

   .

2. Financial Modules

   : Strong experience in

   GL, AP, AR

   .

3. Data Migration Expertise

   : Experience in

   data extraction, transformation, and FBDI, ADFDI, SQL Loader, and API-based migration strategies

   .

4. Technical Development

   : Expertise in

   PL/SQL

5. Integrations

   : Hands-on experience integrating Oracle ERP with

   third-party applications and external financial systems

   .

6. Customization & Reports

   : Ability to develop

   custom reports, dashboards, and analytics

   in Oracle ERP using BI tools.

Soft Skills & Certifications

1. Strong analytical and

   problem-solving skills

   to resolve complex financial and technical challenges.

2. Excellent communication skills

   to interact with business users, finance teams, and IT stakeholders.
3. Ability to

   work independently and manage the financial system implementations

   .