- Complete understanding of Oracle Apps and E-Business Suite architecture, including underlying table structures, to design efficient program units.
- Strong experience in RICE components; develop and maintain Oracle custom code and interfaces to Oracle Forms-based applications according to business requirements.
- Develop PL/SQL packages, procedures, functions, and triggers from UI events or database triggers to implement complex business logic.
- Proficient in Form Personalization to enhance application usability.
- Collaborate with functional consultants to define technical designs for business requirements.
- Document all technical designs and annotate or comment on actual development.
- Responsible for unit testing and integration testing with other custom components and the larger Oracle application.
- Knowledge of Shell scripting, Java, SQL tuning, and OAF page design is a plus.
- Hands-on experience in R12 and 11i Series with modules like AP, AR, GL, FA, INV, OM.
- Solid business process analysis and re-engineering skills.
- Proficient in Oracle Forms, Oracle Reports (BI/XML/RDF), Oracle Workflow, and Oracle RDBMS.
- Strong understanding of performance tuning and optimization techniques.
- Familiarity with APPS Data Model and adherence to Oracle coding standards.