Oracle ERP Techno Functional

Conduct impact analysis and identify all impacted technical components for upgraded projects; Analysis of requirement document and design solution for implementation projects; Analysis, design, development and testing of all components; Design and develop new processes using various technologies such as shell scripts, SQL, PLSQL, Oracle reports, BI publisher report, forms, OAF Java Programming, Object-Oriented and Structured Oriented programming; Coding and testing of all components; Development of PL/SQL procedures, functions, packages, tables, indexes and triggers for the business requirements: Development of PLSQL procedures and functions; Development of PLSQL packages; Development of PLSQL interfaces to outbound or inbound from legacy systems; Development of database tables, indexes and triggers; customization and personalization of business pages using Java coding language; Development of XML reports, Oracle reports and OAF customization and extension; Development of XML reports on different database tables for business requirement; Development of critical Oracle reports using data model design and layout design concepts; Create new Oracle reports using PLSQL packages, PLSQL coding to extract table data, reprocess and display in the required format as per the business requirements; Customization and personalization of Java OAF pages; Development of new Java OAF pages for business requirements; Development of shell scripts and customizations; Development of complex shell scripts to process information in files and restructured and modify them according to requirements; Unite testing and resolving issues found in testing phase; Delivering programs and different components according to deadlines. Use of Shell Scripts, SQL, PL/SQL, SQL*Loader, Oracle Forms, Oracle Reports, BI publisher, Oracle Workflow and Oracle Applications Framework (OAF); XML reports, C, C++, and Java. Position may require travel.

Minimum Requirements

• Education: Requires Bachelor’s Degree or equivalent* in Computer Information Systems or related field.* Will accept a combination of education, experience and other credentials for degree equivalent, with the ratio of 3 years of work experience equates to 1 year of college training.
• Experience: 6 months experience in the position offered or related position.

Special Requirements:

Aforementioned 6 months experience must include the following skills:

• Shell Scripts, SQL, PL/SQL, SQL*Loader, Oracle Forms, Oracle Reports, BI publisher, Oracle Workflow and Oracle Applications Framework (OAF);
• XML reports, C, C++, and Java.