Oracle Financial System Analyst

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

Job summary

A technology consulting firm in California is seeking an Oracle Application Consultant. You will analyze business requirements and configure Oracle R12 financial modules, ensuring compliance with regulatory standards. Key responsibilities include creating test plans, collaborating with stakeholders, and providing solutions for system issues. Candidates should have strong problem-solving skills and experience in Oracle applications, particularly in General Ledger and Accounts Payable. Join us to work in a dynamic environment with a focus on best practices and technology advancements.

Qualifications

• Experience with Oracle R12 financial modules, including GL, AP, AR, and FA.
• Proficiency in writing SQL queries for troubleshooting.
• Ability to analyze business needs and provide effective solutions.
• Experience with end-to-end testing and user acceptance testing.

Responsibilities

• Act as SME in Oracle R12 financial modules and regulatory compliance.
• Configure Oracle financial modules and prepare documentation.
• Collaborate with stakeholders for project tracking and assessing impacts.
• Prepare specifications for program development and integration.
• Conduct end-to-end testing and user acceptance testing.
• 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.

Skills

Oracle implementation experience

Testing skills

SQL query writing/understanding

Strong problem solving skills

Excellent interpersonal skills

Tools

Oracle R12

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