Oracle EBS Techno-Functional Consultant - Financials

Good to have skills: BI/XML Publisher and Oracle Reports, Oracle SQL and PL/SQL, Perform performance tuning, RICEW components (Reports, * 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., * 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.

• 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

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.

Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.