SUMMARY

• 7+ years of experience in working with IT industry, working as Oracle Applications Technical Consultant.
• Working as technical consultant in oracle application modules OM, AR, PO, AP, INV, GL etc., (O2C and P2P cycles).
• Worked on Application Object Library (AOL) objects.
• Worked on R.I.C.E. components with Oracle Applications and is well versed with RDBMS
• Strong skills in Oracle SQL, PL/SQL, SQL* Loader, Reports.
• Skilled in Oracle Interfaces, Custom.pll, Forms Personalization.
• Worked with Forms, Oracle API’s, XML Publisher.
• Knowledge in UNIX Shell Scripts, XML and Java.
• Exposure to R12 architecture and concepts.
• Worked with Tools Toad, SQL Developer, Star Team, TTMS, Eclipse etc.,
• Work Experience in articulating design and development concepts in technical specification documents (MD050, MD070, MD120), and Test script documents (TE020, TE040) using AIM Methodology.
• Involved in Functional Design and System Integration Testing (SIT).

TECHNICAL SKILLS

ERP: Oracle Applications 11.5.10.2

Modules: OM, AR, PO, AP, INV, GL

Databases: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

Languages: SQL, PL/SQL, C, JAVA

Tools: TOAD, SQL*PLUS, SQL*Loader

GUI Tools: Oracle Reports and Forms

Operating Systems: Windows, UNIX, MS - DOS, SUN SOLARIS

PROFESSIONAL EXPERIENCE

Confidential, NY

Technical Consultant

Responsibilities:

• Support work for technical queries/tickets.
• Handling SCM/FIN track tickets
• Responsible to handle Support of RICE components
• Responsible for to create new or enhancements of RICE components
• Defining Executable, Concurrent Programs and Value Sets.
• Development of custom Oracle Application Reports.
• Customization of Oracle Application Standard Reports
• Developed SQL*Loader control file for loading data from data files to Staging tables.
• Registering the PL/SQL procedures, control files, Reports, Shell Script as concurrent Programs.
• Worked on various aspects of AOL setups.
• Created PL/SQL Packages, Procedures, Functions as per the requirement.
• Worked on Order import interface and other Interfaces.
• Modified Standard reports like AR Invoice Report.
• Created custom GL consolidation report.
• Enabling or enhancing DFF’s for Order Header, Order Line, Shipment, Customer ‘s screen etc
• Custom.pll validation for BOM component deletion.
• Folder manipulation for in Order Entry Screen
• Adhoc Scripts for order flow (Cancellation, Clear Reservations, Close Order etc.,)

Environment: Oracle Apps 11.5.10, TOAD, Star Team, TTMS, Java, BHUB etc.

Confidential, Silver spring, MD

Technical Consultant

Responsibilities:

• Successfully created and debugged many PL/SQL Procedures, Functions and Packages for the application.
• Responsible for creation of new reports
• Worked on Form Personalization
• Worked with Invoice interface, Customer interface etc
• Responsible for technical documentation
• Involved in unit testing
• Created Table dependent value sets
• Created Custom Profiles
• Developed SQL Loader Control files for Inbound Interfaces
• Registering the PL/SQL procedures, control files, Reports, Shell Script as concurrent Programs
• Worked on various aspects of AOL setups

Environment: Oracle Apps 11.5.10, TOAD, Star Team, TTMS, Java, etc..

Confidential, Minneapolis, MN

Techno Consultant

Responsibilities:

• OM Interfaces and standard order import program.
• Receiving using 3rd party.CSV files and parsing them to staging tables.
• Account Alias issue / Account Alias Receipt created using inventory transaction interface and mtl transaction interface tables. rdf reporting for processed/failed records
• Mass cancellation program using OE ORDER PUB.
• Designed Lookups to use the same program for multiple 3rd party order types.
• Technical documentation for deliveries.
• Created PL/SQL Packages, Procedures, Functions as per the requirement
• Worked on various aspects of AOL setups.

Environment: Oracle Apps 11.5.9,OM,INV,PLSQL, XML Java Servlet, TOAD

Confidential, Dallas, TX

Technical Consultant

Responsibilities:

• Documentation - Technical documentation except pricing component.
• Materialized views for order, shipment and product logical layers.
• Involved in the project designing with DI team.
• Involved with operations team to reduce performance issues.
• Participated in design of SAL with architects.
• Used Dynamic SQL to form sql statements to create materialized views.

Environment: PLSQL, TOAD, UNIX, SQL Plus

Confidential

PL/SQL Developer

Responsibilities:

• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL* Plus, SQL Loader
• Written database Triggers, Stored Procedures using PL/SQL
• Successfully created and debugged many PL/SQL Procedures, Functions and Packages for the application.
• Analyzing requirement of client, generating and designing reports.
• Creating Data structures i.e. Tables & Views and applying the referential integrity.
• Designing Data Conversion with use of SQL*Loader.
• Preparing and talking with clients about enhancements and modifications
• Documented USER requirements and Testing of Developed Modules
• Interacted with UNIX Server using Commands and scripts
• Improved system performance in data access by fine-tuning of indexes, SQL statements and Joins.
• Involved in reviewing the Specs of the Reports before developing the Reports.
• Also responsible for writing Test Plan documents and unit testing for the application modules.
• Responsible for performing Code Reviews.
• Worked with DBA in making enhancements to Physical DBA schema.
• Writing high quality and well documented code according to standards.

Environment: HP-UX, AIX, Oracle 8i, 9i, TOAD, Explain Plan, Oracle Trace, TKPROF