Job Description
Job Description
Experience Level:

7–9 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 explicit, 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

📌 Oracle EBS Techno-Functional Consultant (AR & Project Accounting) (Mumbai)
🏢 Jade Global
📍 Mumbai