Oracle EBS Techno-Functional Consultant – Financials

ApTask; Town of Florida (NY); On-site; USD 76,000 - 83,000; Full time

Benefits offered by this job

Subsidized insurance

Job summary

ApTask is seeking an Oracle EBS Techno-Functional Finance Consultant to lead the support, enhancements, and implementation of Oracle E-Business Suite Financial modules such as GL, AP, AR, FA, CM, and SLA. The role requires bridging business processes with technical architecture to translate financial requirements into reliable, scalable solutions.

The ideal candidate has deep hands-on Oracle Financials experience and strong SQL/PL/SQL, BI Publisher, and workflows, with emphasis on close

Qualifications

• 8+ to 10+ years of experience with Oracle EBS R12 Financial modules.
• Deep knowledge of GL, AP, AR, FA, CM, SLA and related financial processes.
• Strong SQL/PL/SQL skills and experience with BI Publisher/Reports.

Responsibilities

• Functional leadership and business support for Oracle EBS Financial modules.
• Incidents, enhancements, and period-close activities; collaborate with finance teams.
• Lead requirements workshops and document BR100/MD050/MD070/TE040 standards.
• Develop and maintain RICEW components and complex database objects.
• Assist with UAT, CRP, and end-user training.

Skills

Oracle EBS functional knowledge

SQL

PL/SQL

Oracle Forms/Reports

BI Publisher

Workflows

Education

Bachelor's degree in CS/IT/Accounting or equivalent

Tools

Oracle Developer Suite (Forms & Reports)

BI/XML Publisher

FNDLOAD

Job description

About Client

The client specializes in delivering technology solutions and services to help businesses with digital transformation, software development, and IT consulting. It provides custom software development services across various platforms and technologies, catering to different industries and domains. The client helps businesses modernize their IT systems, adopt new technologies, and transform their operations to stay competitive in the digital age.

Rate Range: $55-$60/Hr

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

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
• 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.

Non-benefitted (other than those mandated under state or federal law). Please note that this position does not include paid time off benefits. ApTask offers subsidized insurance coverage to our employees.

About ApTask

ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American‑owned and Veteran‑owned company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top‑tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.

Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.