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

Project Summary

• Oracle Apps Implementation - TEVA Pharmaceuticals, North Wales, PA
• Oracle Apps Implementation - John Deere Financials, Johnston, IA
• Oracle Apps Implementation - TEVA Pharmaceuticals, North Wales, PA
• Oracle Apps Implementation - Terex Corporation, Westport, CT
• Oracle Apps Implementation - Mercury Marine, Fond Du Lac, WI
• Oracle Apps Implementation -- GE Healthcare, Salt Lake City, Utah
• Oracle Apps Implementation Oracle Apps 11i - FedEx Trade Networks, Buffalo, NY

Professional Experience

Client: Confidential, North Wales, 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, Johnston, 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, North Wales, 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 OAFform 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, Westport, 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.

Client: Confidential, Fond Du Lac, WI
Duration: Oct 2008 to Jun 2009.
Role: Oracle Techno Functional Consultant,
Project: Oracle Apps Implementation

• Utilized the GL Interface along with custom processes for (a) Automation ofcollapse (closure) of Revenue and Expense accounts to Retained Earnings, and (b) Mechanical upload of Balance Sheet adjustment journals, and prior-period adjustments, in multiple Sets of Books for the Sale Close process
• Created custom reports showing balances from multiple sets of books to facilitate review by business and finance for Balance Sheet adjustments
• Analyze and resolve CTA and other Consolidation issues encountered as a result of the pre-mature closure of books.
• Created Financial reports using Discoverer and automated scripts to validate the integrity
• of the data based on end user needs.
• Experience in development of Oracle Alerts.
• Developed and customized Forms and Reports.
• Experience in Unit and integration testing of various objects.
• Worked on initial data load (data conversion) for Vendors (AP), Customers (AR) and Items (INV).
• Customized JSP's for display of information on Order & Shipment Detail page in iStore
• Developed a brand new JSP so that after placing the order in iStore the user has the opportunity to change the shipping method according to the warehouse allocated and this is stored in the base tables of OM. To do this requirement worked on OM API (Custom Process Order and also on Hold release API).
• Worked extensively on AK Developer by customizing Order Detail and Shipment Detail pages.
• Customized iProcurement pages using AK Developer and JSP Screens
• Worked on JDeveloper9.0.3 to make all extensions/changes to OAF components on iProcurement and iExpense Pages.
• Enabled supplier punch outs using Oracle Exchange to enable XML/cXML messaging.
• Customized PO Print Report for XML related changes.

Client: Confidential, Salt Lake City, Utah
Duration: Nov 2007 to Sep 2008.
Role: Oracle Techno Functional Consultant
Project: CRM Implementation & Support Oracle Application (11.5.9)

Responsibilities:

• Implemented Custom UI Interface for Sales and Marketing groups to manage inquiries from customers
• Developed custom business areas for reports in Discoverer using simple, complex folders,
• security for data access for Workbooks.
• Implemented specific UI Features like Charts and Graphs, List of Values (LOV), HGrid, Hide/Show and all form Components
• Implemented Server-Side Features like Java Entity Objects, Entity Experts, Validation View Objects and Validation Application Modules
• Developed Model Objects like Entity Objects, View Objects, Application Modules
• Involved in the preparing/reviewing the Detailed Design documents and Unit Test Plans
• Used PL/SQL, Stored Procedures and triggers for handling database processing
• Involved in Production support from client requirements to developmental aspects with coding, system optimization and testing
• Analyze requirements and write functional, technical, and design specifications
• Imported customer information from legacy systems into the oracle application tables using APIs and interface tables. Performed data validations and massaging at staging tables.
• Involved in Design and Development of Interface programs to import Invoice information into the system using Payables Open Interface Import.
• Good schema knowledge in GL, AR, and AP modules.
• Customized forms and reports as per the business requirement.
• Customized various reports like Bank Account Listing Report, Supplier Report, Payment Register Report and Aging Report
• Developed design documents and unit test plans for all the customizations. Also created various user references manuals for functional testers and users.
• Designed and developed a custom payment format program.
• Created Concurrent executables and Concurrent Programs and Concurrent Request Sets for various custom processes

Project: CRM Implementation Oracle Applications 11i
Client:Confidential, Buffalo, NY
Duration: February 2006 to Sep 2007
Role: Oracle Application Techno Functional Consultant

Responsibilities:

• 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.