Oracle Cloud ERP Reports Developer

Technical Experience:

• Possess a total of 6+ years of IT experience in Oracle Cloud/Fusion ERP and Oracle EBS modules.
• Minimum of 3 years of hands-on industry experience with Oracle PL/SQL development.
• At least 2 years of experience developing reports and interfaces in Oracle EBS applications.
• A minimum of 4 years of experience in Oracle Cloud ERP, specifically in designing, developing,

and maintaining custom reports and dashboards within Oracle Cloud Finance and PPM modules

using BI Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI).

• Knowledge of Oracle Cloud HCM modules is not required, but familiarity alongside Finance and PPM modules is preferred.

Responsibilities:

• Design, develop, and maintain PL/SQL packages, procedures, functions, and robust error handling

with defined exceptions.

• Create and optimize bank payment templates, including positive pay templates, RTF templates, E-

text templates, and Excel templates based on business requirements.

• Develop and maintain custom reports and dashboards within Oracle Cloud Finance and PPM

modules using BI Publisher (BIP) and OTBI.

• Write complex SQL queries and perform SQL query tuning for improving the performance of long-

running reports and data models or reports.

• Create custom ESS jobs, job sets, and value sets tailored to business and project needs, and utilize

Data Composer in Oracle ERP Cloud to define data sources, create filters, and design custom

layouts for transactional business reports.

• Design and implement PL/SQL code to interact with Oracle ERP REST APIs for seamless

integration and automation.

• Build and enhance interfaces and integrations with Oracle ERP systems using advanced PL/SQL

programming techniques.

• Leverage Oracle Integration Cloud (OIC) and Business Intelligence Cloud Connector (BICC) for

advanced data extraction and integrations (preferred).

• Collaborate with functional and technical teams to gather requirements, design solutions, and ensure

successful implementation.

• Troubleshoot and resolve technical issues in Oracle Cloud Finance and PPM modules to maintain

high system availability.

• Ensure compliance with Oracle ERP standards and best practices during the design and development

process.

• Provide technical mentorship and guidance to junior team members as needed.

Skills Required:

o Strong PL/SQL and SQL Performance tuning. (Mandatory) o Strong Oracle BI and OTBI Reports. (Mandatory) o Experience payment template customizations, configure transmissions and develop/customize check print templates. (Mandatory) o Oracle EBS Technical Experience with Reports and Interfaces. (Mandatory) o OIC and BICC (Preferred) o Deployment and Support o Problem Solving o Agile methodology (JIRA) o Oracle APEX (Plus)