Lead requirement gathering and configure Oracle AR and Project Accounting (PA), design CEMLI solutions, develop PL/SQL and Forms/Reports, build interfaces/APIs, perform performance tuning, provide Tier 2/3 production support, and manage testing (UT/SIT/UAT).
Oracle EBS Techno-Functional Consultant (AR & Project Accounting)1
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 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
Jade Global Pune, Mahārāshtra, IND Office
Vadgaon Sheri Road, Nyati Tech Park, 7th Floor, , , Pune, Maharashtra , India, 411014
Jade Global Pune, Mahārāshtra, IND Office
7th Floor M Agile, Baner Road Baner, , , Pune, Maharashtra , India, 411045
Similar Jobs
Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Leads six full-stack developers building and maintaining a fintech website while owning GA4, SQL-based analytics, ETL pipelines, dashboards, data quality, and business insights. Sets technical direction, oversees architecture, performance, reliability, and security, partners with Product, UX, and Marketing, manages the website and analytics roadmap, and coaches engineers through hiring, development, and performance management.
Top Skills:
Amazon AthenaAWSDashboardsData PipelinesETLGoogle Analytics 4SQL
Financial Services
Leads a global team of Product Managers delivering ConnectWealth and mandates platform enhancements. Owns advisor research, requirements, Agile backlog management, stakeholder alignment, UAT oversight, regulatory readiness, risk escalation, operational support, and roadmap prioritization using platform and operational data.
Top Skills:
JIRAPythonSAS
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Develop responsive, accessible, and high-performance React interfaces for banking and insurance applications. Collaborate with product, design, backend, and technical teams on frontend architecture, API integration, state management, automated testing, CI pipelines, and code quality. Participate in agile delivery, code reviews, frontend workshops, technology evaluation, and continuous improvement.
Top Skills:
Context ApiCSS3CypressGitGithub ActionsGitlab CiHTML5JavaJavaScriptJestNestjsNext.JsReact NativeReact Testing LibraryReactRecoilReduxSpring BootStyled ComponentsTailwind CssTypescriptViteWebpackZustand
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
