Oracle Financial System Analyst

ATR International; San Diego (CA); On-site; USD 120,000 - 160,000; Full time

Job summary

ATR International is seeking an Oracle SME to analyze and implement solutions in Oracle R12 financial modules, configure OUs, and work with accounting and business analysts to define requirements. The role involves testing, documenting configurations, and coordinating with developers and vendors on integrations.

The ideal candidate has strong SQL skills, experience with SOX controls, and excellent communication to bridge business needs with technical teams.

Qualifications

• Must have Oracle R12 implementation experience.
• Experience in writing SQL queries.
• Strong communication skills with developers and business users.

Responsibilities

• Act as SME to analyze, provide solution, configure & perform testing in Oracle R12 financial modules, while understanding regulatory and SOX environment.
• Configure new OUs and relevant Oracle financial modules (AP, FA, SLA, GL, AR, Projects, Costing) as needed.
• Work with key users, accounting team, business analysts to understand requirements and project roadmaps.
• Collaborate with stakeholders to track progress, identify risks, and assess impacts to the business.
• Prepare functional specs for programs, reports and third party integrations; liaise between business and developers.

Skills

Oracle implementation

Testing

Developer liaison

SQL queries

Job description

Must have Skills: Oracle implementation experience, testing, dealing with developers, writing / understanding SQL queries.

Overview

Job Description

Responsibilities

• Act as SME to analyze, provide solution, configure & perform testing in Oracle R12 financial modules, while understanding potential regulatory and SOX environment. Provide recommendation in implementing best practice solutions for both business process and technology.
• Configure new OUs and relevant Oracle financial modules (AP, FA, SLA, GL, AR, Projects, Costing) as needed. Prepare configuration documents.
• Work closely with key users, accounting team, business analysts to understand requirements and project road maps.
• Collaborate with stakeholders and cross functional teams to track project progress, identify, communicate risks and status and assess potential impacts to the business.
• Prepare functional specifications for programs development, reports and third party integrations as needed. Work as liaison between business and developer to communicate and develop custom solutions.
• Create test plans, write test scripts, conduct end to end testing and work with users for User testing.
• Troubleshoot issues related to Finance Modules and third-party integrations.
• Work with software vendor support on system issues and bugs fixes (Oracle Support etc).
• Technical understanding of tables; working knowledge of SQL to troubleshoot issues.
• Experience with 3rd party interfaces (e.g. labor accounting, exchange rates etc.).
• Strong problem solving and communication skills (written and verbal) including technical and non-technical documentation, business interactions, presentations etc.
• Excellent interpersonal skills and ability to work collaboratively with others.

Top 5 Required Skills

1. ERP Oracle Application Functional Finance consultant - General Ledger, SLA, Accounts Payable, Accounts Receivable, Fixed Assets, Tax (EbTax & Vertex)
2. Finance domain knowledge
3. Working knowledge in writing SQL queries
4. Exposure to Mergers & Acquisitions
5. Working knowledge iProc/PO module is nice to have