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.