Oracle Technical Consultant

Requirement Gathering:

1. Taking functional specifications from users/functional consultant, converting functional specification to technical specification.
2. Analyze complex work processes for improvement opportunities in technical programs.
3. Participate in the design of high-quality application architecture that meets organization’s business requirements.

Support:

Support and troubleshooting of the existing developed applications (Forms, Reports, Interfaces, and workflows). Experience in personalization and customization of OAF objects.

Database Structure Design:

Database structure design for Tables, views, sequences, synonyms, and database triggers.

Application Development:

1. Development of forms, reports, and workflows.
2. Creation of SQL packages, functions, and procedures.
3. Integrations of customized application with Oracle standard applications modules. Experience with REST APIs (integration repository) would be preferred.
4. Performance tuning of existing programs.

Testing:

1. Preparing test cases.
2. Perform unit testing, integration testing, and support UAT.

Training and Implementation:

1. Training users.
2. Implementation of the applications.
3. Technical documentation.