Oracle EBS Techno-Functional Consultant (AR & Project Accounting)

Jade Global; Hyderabad, Pune District, Bengaluru; On-site; INR 2,000,000 - 3,500,000; Full time

Job summary

Jade Global is seeking an experienced Oracle E-Business Suite Functional Consultant in India to lead requirement gatherings and map business processes to Oracle standard functionality. You will configure PA, AR, and GL modules, design functional specifications, and ensure seamless cross-module data flow.

The role covers data migration, interfaces, testing strategies including SIT/UAT, and production support, with emphasis on performance tuning and robust documentation.

Qualifications

• Experience in PA, AR, and GL modules with strong knowledge of revenue recognition and inter-project billing.
• Expertise in writing functional design documents (MD.050) and application setup mappings (BR.100).
• Strong communication and ability to gather requirements and map to Oracle AIM/OUM methodologies.

Responsibilities

• Lead requirement sessions and map processes to Oracle standard functionality.
• Configure PA/AR modules and ensure cross-module data reconciliation with GL/OM.
• Prepare functional design documents for customizations (MD.070) and installation scripts (MD.120).
• Define test strategies and oversee SIT/UAT and production support.

Skills

Analytical thinking

Communication skills

Problem solving

Team collaboration

Education

Bachelor’s degree in Computer Science, IT, Finance, or related field

Tools

Oracle Forms 10g/11g

Oracle Reports

Oracle Workflow

XML/BI Publisher

Oracle EBS R12.2

Job description

Job DescriptionJob Description

Experience Level: 79 Years

Location: Offshore

Key Responsibilities

Functional Delivery

• Business Analysis: Lead requirement gathering sessions, map business processes to Oracle standard functionality, and perform gap analysis.
• Module Configuration: Configure, maintain, and optimize Oracle AR and Project Accounting modules to meet evolving business needs.
• Solution Design: Prepare detailed functional design documents for customizations, extensions, modifications, and interfaces (CEMLIs).
• Cross-Module Integration: Ensure seamless flow and reconciliation of data between PA, AR, General Ledger (GL), and Order Management (OM).

Technical Execution

• Development & Customization: Design and develop technical components (PL/SQL packages, procedures, functions, triggers, and Oracle Forms/Reports).
• Technical Documentation: Author comprehensive technical design specifications (MD.070) and installation scripts (MD.120).
• Data Migration & Integration: Build and maintain inbound/outbound interfaces using Oracle standard APIs, open interfaces, and Web Services.
• Performance Tuning: Troubleshoot and optimize complex SQL queries, PL/SQL code, and concurrent programs to ensure system efficiency.

Support & Testing

• Production Support: Provide Tier 2/3 technical and functional support, troubleshooting critical system issues and closing month-end/year-end processing bottlenecks.
• Testing: Define test strategies, prepare test scripts (TE.040), and conduct Unit Testing, System Integration Testing (SIT), and User Acceptance Testing (UAT).

Required Skills & Qualifications

Functional Expertise

• Project Accounting (PA): Deep understanding of Project Costing, Project Billing, revenue recognition, agreement and funding setups, and inter-project/inter-company billing.
• Accounts Receivable (AR): Expertise in customer setups, invoicing, receipt auto-matching, lockbox processing, revenue management, and period-close activities.
• Core Financials: Strong understanding of GL (SLA/Subledger Accounting architecture), Subledger-to-GL reconciliation, and Multi-Org environments.
• Documentation: Expert in writing clear, comprehensive functional documentation, including MD.050 (Functional Design), BR.100 (Application Setup), and mapping documents using AIM/OUM methodologies.

Technical Toolset

• Languages & Database: Advanced SQL, PL/SQL, and performance tuning techniques within Oracle Database 12c/19c environments.
• Development Tools: Oracle Forms 10g/11g, Oracle Reports, Oracle Workflow, and XML/BI Publisher.
• Architecture: Proficient in Oracle R12.2 architecture, including Online Patching (ADOP) concepts and standards.
• Frameworks: Familiarity with OAF (Oracle Application Framework) extensions and personalization is highly desirable.

Education & Soft Skills

• Education: Bachelor’s degree in Computer Science, Information Technology, Finance, or a related field.
• Communication: Exceptional verbal and written communication skills.
• Problem-Solving: Strong analytical and debugging skills to trace data flow through backend tables and code layers.
• Working Hours: IST 3:00 pm to 11:00 pm