Oracle Apps Technical Consultant Resume New Jersey NJ - Hire IT People

SUMMARY

Over 8 years of experience as Oracle Apps Technical Consultant in Analysis, Design, Data Modeling (Logical and Physical), Implementation of Business Applications using the Oracle Relational Database Management System.
Experience with the Software Development Life Cycle (SDLC) process - performing detailed analysis, collecting requirements, technical specifications, development and unit testing, integration and production install and support.
Extensive experience in Design, Development, Customization and Implementation of business applications using Oracle Applications, SQL, PL/SQL, Oracle 10g/9i/8i/7.x, Developer 2000/6i.
Proficient working in modules which include Accounts Receivables, Accounts Payables, General Ledger, Fixed Assets, Purchasing, Inventory, Order management, WIP, BOM, Oracle IPM, Shipping and Claims Management.
Strong conceptual knowledge on business processes in Inbound and Outbound Logistics, Operations and Supply Chain Management.
Strong programming experience in creating Procedures, APIs, Packages, Functions, Triggers views, collections (nested tables and arrays), records, sequences, Materialized views, Constraints and other database objects using SQL and PL/SQL.
Worked out with RICE components involved in creation of Reports that are not available as standard reports, creation of the Interfaces to external systems, creation of Conversion programs to transfer data from a legacy system to the new system and Extensions to the existing system to add additional functionality to existing system without disturbing the core software functionality of the system.
Experience in System Administration responsibilities such as registration of concurrent programs, request sets, creation of Users, Responsibilities, Forms, Functions, Values Sets and Flex fields in Oracle Applications.
Developed SQL Program to load data from Excel files, flat files into temporary table using UTL_FILE utilities and SQL loader.
Experience in developing, customizing, modifying forms, reports existing in Oracle Applications according to the business requirements and specifications using Oracle Developer Suite 10g/9i(Forms, Reports) and other front-end tools.
Web service technology, XML expertise
Experience in Performance Tuning & Optimization of SQL statements.
Extensively involved in SQL tuning, troubleshooting, debugging and fixing the codes/scripts.
Ability to work individually as well as in a team with excellent problem solving skills, troubleshooting capabilities, learn new tools and concepts.
Involved in preparing the functional specification, technical documentation, schema documents, test cases, flow charts, production support and user support documents using AIM methodologies.

TECHNICAL SKILLS

ERP : Oracle Applications R12/11i Multi Org.
ERP Modules : GL, AP, AR, OM, PO, CM, FA, INV, PA, BOM, WIP, AOL
Operating Systems : Ms-Dos, Windows 95/98, Windows NT, UNIX, Windows XP
Languages : C, HTML, XML, Java, SQL, PL/SQL, Shell scripting, T-SQL
Databases : Oracle 11g/10g/9i/8.x/7.x
Tools/Utilities : TOAD 10.5/10.6, CVS, PVCS, SQL*Loader, Export, Import, Developer 2000/6i, Discoverer 10g/9i,BI Publisher4.5.6,SQL*PLUS ,MS Visio, IBM Clear Case 7.0/7.1.1, Kintana, Lotus Notes, Putty, PL/SQL Developer,

Remedy, Windows Host Script, Hyperion, SNAGIT, Reports 10g/6i/6/2.5, Forms 10g/6i/6/4.5,Project Tracking System (PTS), Citrix, SSIS, Active
Directory, Forms Personalization, Oracle Web Center Imaging, Oracle Web Center Capture, Oracle Web Center Forms Recognition, Web ADI.

We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

New Jersey, NJ

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship