Oracle Ebs Technical Consultant

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.