Oracle Functional Consultant

Pressurejet Systems; Ahmedabad District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Pressurejet Systems in Ahmedabad, Gujarat, seeks an experienced Oracle EBS reporting specialist to drive custom reports and data workflows.

You will develop with BI Publisher/OTBI, tune SQL/PLSQL, personalize forms, and support upgrades while coordinating with finance, SCM, and procurement teams.

Candidates should hold Oracle EBS/PLSQL certifications and have strong analytical, communication, and multitasking skills.

Qualifications

• Oracle certifications in Oracle EBS, PL/SQL preferred.
• Strong expertise in Oracle EBS reporting and data extraction.
• Experience with BI Publisher, OTBI, XML Publisher.
• Knowledge of GST, TDS, TCS tax rules in ERP context.

Responsibilities

• Develop custom reports using BI Publisher, Oracle Reports, and OTBI.
• Write complex SQL and PL/SQL for data extraction and reporting.
• Personalize Oracle forms and implement AME workflows.
• Support EBS patches, upgrades, and data migration.
• Collaborate with finance, procurement, and SCM teams.

Skills

Custom Reports Development

SQL/PLSQL Programming

Oracle Forms Personalization

Performance Optimization

Security and RBAC

Education

Oracle certifications in Oracle EBS, PL/SQL

Tools

BI Publisher

Oracle Reports

XML Publisher

OTBI

Job description

1. Key Responsibilities

A. Technical Responsibilities (Primary Focus)

1. Custom Reports Development C Maintenance

• Develop custom reports using Oracle Reports, BI Publisher, XML Publisher, and OTBI.
• Write complex SQL and PL/SQL queries to extract relevant data for reporting.
• Maintain reports related to finance, inventory, procurement and manufacturing.

2. Application Personalization C Extensions

• Perform Oracle Forms Personalization to modify standard Oracle forms without customization.
• Implement custom workflows, alerts, and approvals using AME (Approval Management Engine).

3. Custom Development C Enhancements

• Develop custom PL/SQL scripts, concurrent programs, and workflows.
• Automate reports and workflows to reduce manual efforts.

4. Technical Support C Troubleshooting

• Debug Oracle Reports, PL/SQL scripts, and concurrent programs.
• Troubleshoot performance issues and system errors.
• Provide technical support for system upgrades, patches, and data migration.

B. Functional Responsibilities (Support C Collaboration)

1. Business Process Understanding C Support

• Work closely with finance, procurement, and SCM teams to ensure accurate reporting.
• Ensure ERP compliance with Indian tax laws (GST, TDS, TCS).

2. User Support C Documentation

• Provide technical training to users on reports and processes.
• Maintain technical documentation, system logs, and change requests.

3. System Upgrade C Patch Management

• Support Oracle EBS patches, cloning, and upgrades.
• Work with DBAs for performance optimization and system monitoring.

2. Required Skills s Qualifications

A. Educational C Professional Background

• Oracle certifications in Oracle EBS, PL/SQL, or related technologies will be preferred.

B. Technical Expertise (Key Focus Areas)

• Custom Reports Development: BI Publisher, Oracle Reports, XML Publisher, OTBI.
• SQL C PL/SQL Programming: Writing efficient queries, stored procedures, and triggers.
• Oracle Forms Personalization C Workflows: OAF, AME, Oracle Workflow Builder.
• Performance Optimization C Debugging: SQL tuning, troubleshooting reports.
• Security C User Roles: Oracle EBS Role-based access control.

C. Functional Knowledge (Support Role)

• Basic understanding of Oracle EBS Finance (AP, AR, GL), SCM (Inventory, Procurement, OM) and Discrete module.
• Awareness of Indian tax compliance (GST, TDS, TCS) in Oracle ERP.
• Knowledge of ERP business processes and best practices.

D. Soft Skills

• Strong analytical and problem-solving skills for debugging ERP issues.
• Excellent communication skills to collaborate with functional users and technical teams.
• Ability to manage multiple priorities and work under tight deadlines.