Professional Summary

• Over 6 years of experience in Oracle Applications - 11i, R12, requirement gathering, analyzing, designing, developing, implementing, and testing.
• Proficient technically in OAF, ADF, JAVA, JSP, XML Publisher, HTML, C, C++, Oracle 11i Framework and UNIX Shell Script.
• Strong Experience in functional and technical knowledge on Oracle SOA.
• Strong RDBMS skills and hands on experience in Oracle database (10g, 11g).Used tools like Toad for performing SQL and PL/SQL programming.
• Good knowledge of System Administration in defining users, menus, request groups responsibilities, and registering concurrent programs.
• Hands-on experience in customizing Oracle Applications using Forms (4.5/6i), Reports (2.5/6i).
• Experienced in various modules of ERP/CRM and manufacturing such as Order
• Management, Accounts Receivables, Inventory, iStore, iprocurement, iExpense, OPM,
• General Ledger and Accounts Payable
• Strong Analytical, Inter-personnel, Problem-solving and Communication skills.
• Assisted with overall team management, communications and maintaining positive client/consulting team relationship.
• Experienced in Analysis, Design, Testing documentations in the implementation life cycle, worked on 4 full life cycle implementation projects.
• Contributed for end user training including development of training material.

Technical Skills

E-Business suite Modules Order Management, Inventory, Cash Management, iStore, General Ledger, Accounts Payable, Oracle Workflow, OPM, Accounts Receivables, Purchase Order and Oracle Alerts.

Solution Areas ERP- Oracle Applications 11i, CRM – Oracle Applications 11i, Oracle Applications R12

Technical Expertise SQL, PL/SQL, UNIX, JAVA, JSP, XML, HTML, C, Oracle Forms 6i, Oracle Reports 6i, Oracle Discoverer, Oracle Java Framework, ADF, Oracle Database 8.0/9i/10g/11g

Process Areas Finance Processes, Procure to Pay, Order to Cash

Professional Experience

Client: Confidential,PA
Duration: September 2012 to Till Date.
Role: Oracle Apps Techno Functional Consultant

Responsibilities:

• Designed and developed custom applications for Teva Customers to access order details and shipment information for the orders they have placed.
• Customer Portal is a custom application where customers of Teva,register to get access to the order details and shipment information. Once they register the customer would receive email confirmation regarding there registration and that Teva Customer Operations team would get back to them on the access details.
• Developed a registration page for the customers to register with their details to get the username and password.
• For Teva Customer Operation’s team, they would receive an email that a new customer has registered through portal application with the given information, Operations team logs into the new application I developed to assign the customer to proper oracle customer id and number and approve the customer to access the portal application.
• Once approved, the customer would receive an email with the access details along with

the password.

• Teva Customer now, can access the portal application, first time login will redirect them to change password page and once the password is updated, they have to relogin with the new password and now they can access the order details and shipment information for the orders.
• Implemented Shipment information page where the order line details would contain the tracking number as hyperlink. When the user clicks on the tracking number, the new window would open with the tracking details either on FedEx or UPS depending on the tracking number.
• Developed an order summary page where the customer has an option of searching for particular order like order number, PO, last number of days, orders between start date and end date.
• Created the custom schema for maintaining the users.
• Personalized and extended iexpense Home page to add Recreate Cover
  Sheet for the user to get the expense reports.
• Actively involved in the requirements and the design phases.
• Developed PLSQL code and invoked the packages in OAF to meet the requirements.
• Created technical design documents for all the custom OAF screens.
• Designed and developed all extended screen in OAF.

Client: Confidential,IA
Duration: Jan2012 to Aug 2012.
Role: Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed Custom OAF Screens to create, update and delete records in OLFM module.
• Implemented logic to create and update customer details, financial details and credit application details for phase -1.
• Implemented custom logic to attach files for a party (Upload and download an image/Document). The logic can download or upload any kind of Mime content type.
• Developed master detail page for party and address result tables, when a party (Customer) is selected the address for that particular party is displayed in the result table below on the same page.
• Developed a navigation page where the user is specified with the different types, directions and transportation in order to reach the party.
• Configured custom OAF screens to be displayed as Menu/sub tab format on oracle applications for a custom responsibility.
• Developed Remarks Screen for the user to add or update remarks for a party or credit applications.
• Actively involved in the requirements phase.
• Designed and developed all extended screen in OAF at the client site.
• Worked on sub versioning to communicate with the other team members.
• Developed PLSQL code and invoked the packages in OAF to meet the requirements.
• Created technical design documents for all the custom OAF screens.
• Used subversion for version control.

Client: Confidential,PA
Duration: Aug 2010 to Dec 2011.
Role: Oracle Apps Techno Functional Consultant

Responsibilities:

• Developed Custom OAF forms to insert, update and delete records into BPEL master tables like Interface master, Application Master, Error Contacts, Error Codes and so on.
• Developed custom Error Handling Application using OA framework so that the users are provided with the option to reprocess the Errors happened at the oracle end.
• Designed Error Handling Application to handle all the scenarios like
• Resend Option: When user selects this option the process sends the original XML generated/ retrieved by Oracle to the associated system (MES/ WM or Pedigree).
• Recreate Option: When user selects this option the process collects the update information from oracle database, creates a new XML and places the message onto the queue so that the systems interested in this message retrieves the updated data.
• Apply Fix: When user modifies the XML using dynamic entity forms in oracle and wants to send the modified XML to the other system they select this option and clicks on reprocess.
• Ignore All: User can ignore the errors.
• Developed Custom OAF form to enable and disable user access to the Error Handling Application depending on the responsibility, application and the interfaces the user has access to.
• Designed and developed XML Publisher report: TEVA Barr Packaging Master Record report for Barr. The custom report contains all the OPM information required to produce a Packaging Master Batch Record.
• Worked with Discoverer to aid end-users to generate ad-hoc reports.
• Developed custom menu class that extends CustomRenderer to modify the look and feel of the iSupport menu and match it to the TEVA Pharmaceuticals branding standards.
• Working on production support for the modules AR, AP, GL
• Coding interfaces for Customers and Receipts using Customer API and Receipt API in AR
• Developed custom reports using Reports 6i in AR
• Improved the OM Workbench Performance to display the results for releasing holds and actually releasing holds from approx. 5 minutes to 30 seconds on the OAF form
• Extensive Experience in using Oracle Application Object Library (AOL) features including implementation of Flexfields, coding Flexfields in Forms and Reports, implementing Cross Validation Rules, Security rules, working knowledge of Global Descriptive Flexfields, creating and managing of Concurrent programs etc.
• Work experience in analyzing the Oracle SQL Raw Trace , TKPROF , AWR, SQL Profiler Trace files in working query and database performance issues.
• Work experience in generating AWR reports in oracle.
• Created all relevant documents (MD 70, MD 120, and TE 100) as per Teva guidelines.

Client: Confidential,CT
Duration: Aug 2009 to Jul 2010.
Role: Oracle Apps Techno Functional Consultant

Responsibilities:

• Worked closely with the business users to gather requirements and prepare the Functional specifications, Technical Specifications, Installation Documents and unit test scripts.
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met.
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements.
• Developed use cases, workflow, and screen mock-ups for business requirements.
• Designed and developed Inventory Detail report using Discoverer.
• Created brand new JSP to have a new Search functionality based on the VIN number generated while placing the order using oracle configurator rules. The display of the search results is similar to the drill down display we observe in the catalog tab on iStore administration page. The search link on the menu page is based on the custom profile.
• Created a brand new JSP page to display the relationships [Relationships considered were Split, Superceded, Related] for the items entered through Direct Entry Page. This page also allows the user to select the appropriate related items and add them to the cart
• Created Copy Configuration to allow users of configurator on the web to read selections from a previous configuration and apply them to the current configuration.
• Have developed standards and guidelines around configurator modeling.
• Have integrated iStore with Configurator.
• Direct Item Entry page is customized so that the users can order the items across the stores for which they are eligible for.
• Also modified the standard search so that the search is performed across stores depending on the user access to the sites.
• Created a Pop up page so that when user tries to place an order it asks to agree with the terms and condition. Only when user clicks “YES” the order will be placed. By clicking “NO” or closing the window the user is directed to the checkout and review page.
• The Tracking number and Waybill number on the shipment detail, Item detail pages are customized to provide them as hyperlink and the action is to display the respective results in the respective carriers according to the career.
• Created a Javascript to handle the Hotspots on the section images in catalog pages so that when user clicks on the image the corresponding items are selected in the below items table.
• Worked on complete prototype to integrate iStore with Enigma.
• Involved in setup and implementation of iStore and Accounts Receivables modules
  in Oracle CRM 11i.
• Created Concurrent Program to load and Purge items from a Particular
  Section.
• Developed Java Wrapper Classes for Payment Terms, Dynamic Shipping Methods
  and Promotions.
• Created scripts to load the custom data into Development, Test and
  production Instances using SQL*Loader. Created scripts to create custom Tables and Views.
• Implementation of Sales Order Interface and Customer Interface with
  integration point of Order management
• Designed Data Conversion, Interfaces, Customization of reports in Oracle CRM and Financial Modules.
• Involved in Setup and Implementation of iStore and AR modules customer maintenance Business Process.
• Involved in Installation and Setup of Customer Care modules and
  customizing the corresponding JSP pages for the client’s requirements.
• Customer Care Implementation includes Setting up Customer Profiles,
  Running the CustomerProfile Engine, Setting up Relationship Plans and Running the
  Relationship Plan Assignment Engine, Setting up of Quick Menus and defining Profile Options.
• Involved in setting up of Merchant UI, creating Specialty Store, Hierarchy
  and setting up the Product Catalog.
• Used Clear Case for version control of Custom code objects.
• Created MD070, MD120, TE100 and RD120 for each of the enhancement mentioned above.