Job Role – Oracle EBS Techno-Functional Consultant – Financials
Location – Jacksonville, Florida (Hybrid working model --Starting with 5 days/week office for 2-3 months, It can change to 3 days per week later on.)
Contract - 6+ Months
Experience Range – 8 – 12 years
Must have skills : Oracle Financial Modules(AP)
Good to have skills: BI/XML Publisher and Oracle Reports, Oracle SQL and PL/SQL, Perform performance tuning, RICEW components (Reports
Job Description :
8 – 10+ Years Functional candidates will be assessed on their competency of mentioned technical skills as well Job Summary We are looking for a highly skilled Oracle EBS Techno-Functional Finance Consultant to lead the support, enhancement, and implementation of our Oracle E-Business Suite (R12 / 12.2.x) Financial modules.
In this role, you will bridge the gap between business processes and technical architecture, translating financial requirements into reliable, scalable technical solutions.
The ideal candidate possesses deep hands-on expertise in Oracle Financials (GL, AP, AR, FA, CM, SLA, E-Biz Tax) alongside strong technical proficiency in SQL, PL/SQL, Oracle Forms/Reports, BI Publisher, and Workflows.
Key Responsibilities
Functional Leadership & Business Support
Provide primary support for Oracle EBS Financial modules, addressing daily incidents, enhancements, and period-close activities.
Work directly with business users and finance teams to analyze business processes, perform fit/gap analyses, and gather requirements.
Lead requirements-gathering workshops and document specifications using standard methodologies (AIM/OUM—e.g., BR100, MD050, MD070, TE040).
Support key financial operations including Month-End/Year-End closing, Bank Integrations, and Account Reconciliation.
Conduct Conference Room Pilots (CRP), User Acceptance Testing (UAT), and end-user training sessions. Technical Design & Development
Design, develop, customize, and maintain RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows).
Build complex database objects using Oracle SQL and PL/SQL (Packages, Procedures, Triggers, Functions, Views).
Develop and maintain custom reports and document templates using BI/XML Publisher and Oracle Reports.
Build and manage inbound/outbound integrations using APIs, Web Services, and interface tables to connect Oracle EBS with 3rd party applications.
Perform performance tuning on SQL queries, PL/SQL code, and custom reports to optimize system execution.
Required Skills & Qualifications
Functional Expertise Oracle EBS Version: 5+ years of experience working with Oracle EBS R12 (12.1.3 or 12.2.x preferred).
Core Financial Modules: Deep functional knowledge in General Ledger (GL), Accounts Payable (AP), Accounts Receivable (AR), Fixed Assets (FA), Cash Management (CM), and Subledger Accounting (SLA).
Strong understanding of accounting principles, trial balance reconciliation, subledger reconciliation, and financial reporting workflows.
Technical Expertise
Languages & DB: Strong hands-on proficiency in SQL, PL/SQL, and database performance tuning.
Tools & Frameworks:
Oracle Developer Suite (Forms & Reports), BI/XML Publisher, Oracle Workflow Builder, and OAF (Oracle Application Framework).
Utilities: FNDLOAD, SQL*Loader, Unix/Linux Shell Scripting
Soft Skills & Education
Education:
Bachelor’s degree in computer science, Information Technology, Accounting, Finance, or equivalent experience.
Excellent problem-solving, root-cause analysis, and communication skills to interface with business executives and technical teams alike.
Preferred / Nice-to-Have Skills
Experience with Oracle Projects (PA), Advanced Global Intercompany System (AGIS), or E-Business Tax (EBTax).
Experience with automated testing tools, CI/CD pipelines, or code repository platforms (Git/Bitbucket).
