Oracle Techno-Functional Consultant (EBS R12.2.10 Finance & Projects)

Job Description

Systems Analyst for Oracle eBusiness Systems on-premise release R12.2.10 providing application support for customizations and extensions covering Finance and Oracle Projects modules. Focus on production support, troubleshooting, root cause analysis, and data corrections using SQL. Must be aware of data flow processes between subledger and General Ledger. 12+ years experience required per client feedback.

Requirements

• • 5–7+ years supporting Oracle eBusiness Modules, preferably Finance and/or Oracle Projects (R12.2 on-prem current or within past year required)
• • Client requires 12+ years for senior profiles
• • Bachelor's degree with Accounting Major or 5 years related industry
• • 3+ years of SQL/PL/SQL experience (required)
• • Must be aware of EBS Data model and architecture in Finance and Projects
• • 3+ years of Oracle APEX programming experience preferred
• • Knowledge of data flow between subledger and General Ledger (mandatory)
• • Local to Texas only; 10% travel; techno-functional candidates only (not purely technical)

Responsibilities

• • Provides application functional and limited technical support for Oracle EBS Finance (AR, AP, GL, CM, FA, iExpense, iSupplier) and Projects (Costing, Billing, Accounting)
• • Troubleshoots issues, identifies root causes, and recommends workarounds and corrective actions
• • Uses diagnostic scripts, SQL, and query writing tools to analyze data and extract ad hoc reports
• • Provides data correction scripts to address defects due to inconsistent data state
• • Conducts UAT on defect fixes, features, and system improvements
• • Engages with Oracle support for diagnosis, troubleshoot, and patch verification
• • Documents issues, workarounds, and error recovery steps using incident management tools (Helix)

Technologies & Skills