Oracle Ebs Technical Consultant

Palsons Derma; Bidhannagar; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Palsons Derma is seeking an experienced Oracle EBS reporting specialist to design, modify, and maintain EBS R12 reports, including parameterized and detailed outputs, and to integrate reports with concurrent programs and menus.

The candidate should have strong SQL/PLSQL skills and experience across GL, AP, AR, FA, and other modules. Knowledge of Oracle EBS Process Manufacturing (OPM) is a plus. This is a role requiring coordination with Finance and Manufacturing teams.

Qualifications

• Key responsibilities are described in the vacancy: Oracle EBS Report Development, SQL & PL/SQL Development, Oracle EBS Technical Development, Business Module Reporting across GL, AP, AR, FA, and related areas, Report Testing & Support, and Requirement Analysis.

Responsibilities

• Oracle EBS Report Development: Design, modify, and maintain Oracle EBS R12 reports; develop parameterized, summary, and detailed reports; integrate with responsibilities, menus, and concurrent programs.
• SQL & PL/SQL Development: Write complex queries; develop procedures, functions, packages, and cursors; troubleshoot and optimize queries; perform data validation and reconciliation.
• Oracle EBS Technical Development: Create/register concurrent programs, executables, value sets, request groups; configure report parameters; ensure adherence to Oracle standards and documentation.
• Business Module Reporting: Reporting experience in GL, AP, AR, FA, Cash Management, Procurement, Inventory, Order Management, Manufacturing/Process Manufacturing, Advanced Pricing, Cost Management, Quality, and ASCP.
• Report Testing & Support: Perform unit/UAT testing; investigate discrepancies; troubleshoot production issues; optimize SQL performance; support users with report parameters/output; maintain version control and documentation.
• Requirement Analysis: Interact with Finance, SCM, Manufacturing, Sales, and other business users; convert requirements into technical specs; suggest reporting solutions; identify automation opportunities for manual MIS/Excel processes.

Job description

Key Responsibilities:

• Oracle EBS Report Development: Design, modify, and maintain Oracle EBS R12 reports; develop parameterized, summary, and detailed reports; integrate with responsibilities, menus, and concurrent programs.
• SQL & PL/SQL Development: Write complex queries; develop procedures, functions, packages, and cursors; troubleshoot and optimize queries; perform data validation and reconciliation.
• Oracle EBS Technical Development: Create/register concurrent programs, executables, value sets, request groups; configure report parameters; ensure adherence to Oracle standards and documentation.
• Business Module Reporting: Reporting experience in GL, AP, AR, FA, Cash Management, Procurement, Inventory, Order Management, Manufacturing/Process Manufacturing, Advanced Pricing, Cost Management, Quality, and ASCP.
• Report Testing & Support: Perform unit/UAT testing; investigate discrepancies; troubleshoot production issues; optimize SQL performance; support users with report parameters/output; maintain version control and documentation.
• Requirement Analysis: Interact with Finance, SCM, Manufacturing, Sales, and other business users; convert requirements into technical specs; suggest reporting solutions; identify automation opportunities for manual MIS/Excel processes.

Preferred candidate profile:

Knowledge of Oracle EBS R12 Process Manufacturing (OPM) will be an added advantage.