Oracle EBS Techno-Functional Consultant – Financials
Job Description
8 – 10+ Years Functional candidates will be assessed on their competency of mentioned technical skills as well.
Key Responsibilities
- 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.
- 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
- Education: Bachelor’s degree in computer science, Information Technology, Accounting, Finance, or equivalent experience.
- Experience: 8 – 12 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).
- 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: Excellent problem-solving, root-cause analysis, and communication skills to interface with business executives and technical teams alike.
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.