oracle applications developer
R12.1.3, R12.2
Maintaining Oracle Application Databases and Oracle Standalone Databases.
Application Tuning using TKPROF STATS Pack, DBMS PROFILER and SNAPSHOTS.
Oracle Database administrative functions - Oracle Export/Import/SQL*Loader, External Tables, FND_LOAD, CONCSUB Utility, writing shell scripts, creating Printer Drivers, Printer Styles and Printer Types.
Oracle PL/SQL development- Packages, procedures, functions, triggers, sequences, nested tables, types, views.
Oracle Forms - migrating forms from Forms 6i to 11g, Forms Customization and Development using Template.fmb. Maintaining application screens and reports.
SQL, PL/SQL tuning using various Oracle Tools- TK-PROF, Explain Plan, level 8 trace.
Documenting the Modules under AIM standards, Client Specific Standards for different application functionality.
Knowledge of R12 manufacturing, Oracle Work in Process, Oracle Bills of Material, Oracle Inventory and Oracle Shipping Execution, Oracle Order to Cash, Procure to Pay and Record to Report.