PROFESSIONAL SUMMARY

• Over 8 years of IT experience in developing cost effective solutions as an Oracle Consultant using Oracle Applications and related technologies including Implementations, upgradations and Customizations.
• Extensive experience in Oracle Application Modules Order Management (OM), Inventory (INV), Purchasing (PO), Bill Of Materials (BOM), Accounts Receivable (AR), Accounts Payable (AP), Application Object Library(AOL).
• Extensive experience in using PL/SQL, Developer 2000/6i/9i, JDeveloper, SQL*LOADER, TOAD, SQL Navigator, Discoverer 3i/4i/9i/10G, Workflow, Oracle 9i/8i/8/7.x, Unix, Linux, Shell Scripts and Oracle Applications (Financials, Manufacturing and Sales & Distribution modules).
• Experience in Forms customizations and personalization.
• Experience in customizing and developing Oracle reports.
• Experience in middleware technologies ORACLE SOA Suite 11g.
• Experience in developing composites using Mediators and Adapters.
• Expertise in using adapters like O/J - DBC, ftp and APPS adapters.
• Involved in developing custom xsd’s according to business needs.
• Extensive experience in developing RICEW (Reports, Interfaces, Conversions, Extensions and workflow event) components.
• Proficient in developing PL/SQL program units using Procedures, Functions, Packages, Triggers and Public API’s.
• Experience in defining processes relative to Order to Cash, Procure to pay business cycles.
• Proficient in conducting requirements GAP analysis, Business process re-engineering, Solution Design, Test Methodologies, Cutover Strategy, Implementation, Knowledge Transfer and Application Support.
• Recent experience in implementation of INV, PO, AP, AR and OM modules.
• Extensive experience in identifying product gaps, coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored TAR’s for several P1/P2/P3 issues.
• Extensive experience in Customization of Oracle Application modules, which involves Forms Personalization.
• Extensively worked on AIM documents like BR100, MD050, MD070 and MD120.
  
  TECHNICAL EXPERIENCE
  
  Oracle Applications: Accounts Payables (AP), Accounts Receivables (AR), Inventory (INV), Order Management (OM), Purchasing (PO), Bill of Materials (BOM) Application Object Library.
• Database Tools: PL/SQL, SQL*PLUS, SQL*LOADER, TOAD, SQL Navigator.
• Oracle Tools: Reports 2.5/6i/9i, Forms 4.5/6i/9i, Developer 2000/6i/9i,
• Oracle 8i/9i, XML Publisher, Oracle SOA
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server 6.5/7.0
• Languages: SQL and PL/SQL, C, C++, XML and HTML.
• Scripting Language: UNIX Shell Scripting, Cron Jobs.
• Application Servers: Oracle10g Application Server
• Version Control: PVCS, Sharepoint.
• Operating Systems: UNIX, Solaris 7/8, Linux, Windows NT/2000/XP/ Windows 7, MS-Dos, Apple
• Mac OS X.
  
  PROFESSIONAL EXPERIENCE

Confidential,Knoxville, TN Mar 2011 - Present
Sr. Oracle Apps Techno-Functional Consultant.

Confidential, is the largest maker of pleasure boats in the world. Brunswick Boat Group manufactures and distributes boats in the United States. It offers fiberglass pleasure boats; luxury sport-fishing convertibles and motor yachts; offshore fishing boats; aluminum fishing boats; and pontoon and deck boats. The company also provides IDS dealer management systems, and marine parts and accessories. It has manufacturing units in Europe, Australia, and New Zealand, as well as in Joinville, Brazil. Brunswick Boat Group operates as a subsidiary of Brunswick Corporation.

Responsibilities:

• Produced Functional design (MD50) and Technical design documents (MD70) based on the business requirement.
• Produced, Installation Instructions documents (MD120).
• Gathered functional user inputs and produced TE020 document.
• Involved in multiple CRP’s and UAT’s to meet business users requirements.
• Implementation of Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Designed and Developed Staging tables, Data Conversion SQL Loader Programs and Custom PL/SQL API’s (Interfaces) to import legacy system Sales Orders to Oracle Order Management (OM), legacy system Purchase Orders into Oracle Purchasing (PO) and legacy system Bills of Materials into Oracle Bill of Materials (BOM) modules.
• Designed and developed an Outbound Interface between Interlace Systems (Supply-Chain Management tool) and Oracle Applications for Customers (AR), Items (INV), BOMS, On hand Quantity (INV), etc.
• Designed and developed an interface between third party billing system (INTUIT) and Oracle Receivables (AR) to load external invoices data on daily basis. Used SQL*Loader for importing INTUIT invoices into Staging tables, and developed PL/SQL API’s for complete validation of data and inserting into AR Interface tables.
• Produced Conversion Mapping Document (CV40) to extract data from legacy system into Oracle Applications open interface tables.
• Developed various Custom reports, Customized existing reports according to the functional specifications including Packing Slip, Pick Slip, Daily Inventory Transactions Report, AP NACHA Payment Format Report , Invoice and Expense reports.
• Used Oracle Applications Object Library (AOL) features like Value Sets, Descriptive Flex fields, Concurrent Programs, Profile Options, standard request submissions (SRS) and parameters in the process of development.
• Worked with Administration and User Edition of Oracle Discoverer. In Administration Edition, created various business areas, user views, custom folders and joins for reporting. In user edition, developed various crucial financial analysis reports (for all modules) written for AP, GL, OM, PO, and AR using Oracle Discoverer 9i.
• Maintained all the work done using PVCS. Documented all processes by creating various user guides and manuals for reference by future testers and users.
• Customized Oracle Seeded Order Management (OM) Transaction Type workflow to add workflow functions for email Notifications when the order is booked using Workflow Builder.
• Developed Check prints using XML and BI Publisher and created Invoice Batches and Submitted process payment Requests.
• Developed Custom forms and added the zoom functionality in the e-Business suite forms.
• Developed PL/SQL scripts. Registered concurrent programs, request groups for reports.
• Performed tuning on the SQL and PL/SQL packages to improve processing time and efficiency.
• Used SQL trace files in tuning process.
• Used Oracle\'s optimizer and monitored how it chooses the execution path/plan for the procedures.
• Performing Code Reviews for customization of existing procedures and Packages as per the requirement.
• Designed, developed, registered customized forms, tables and reports using AOL.
• Create Users and Responsibilities for Security and limit permission as per business needs.
• Defining New Descriptive flex fields on multiple forms as per business requirement.
• Created value sets and value set values using AOL.
• Developed Oracle 11g SOA composites and components.
• Extensively worked on adapters like DB, File/FTP and JMS Adapters.
• Worked on Mediators and Oracle Business Rules.
• Developed Fault Policies to handle exceptions in Oracle 11g SOA Composite.
• Customized Reports, Interfaces, Packages and procedures to behave as org specific.
• Developed Average Exchange Rate Conversion. Obtain the daily exchange rate from a business partner, Oanda, and update the Oracle tables with the previous month’s average BID rate.
• Developed RTF Templates using XML BI Publisher.
• Worked on incompatible option and conflict domain of concurrent programs.
• Developed Human Task Component on Oracle SOA 11g Suite according to the business needs.
• Modification of B2B messaging system on Oracle SOA 11g Suite.

Environment: Oracle Applications R12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential,Redwood City, CA Jan 2010 – Feb 2011
Sr. Oracle Consultant

Responsibilities:

• Involved with study of existing system, reviewed Functional (MD50) design documents, produced technical design documents (MD 70) and installation instructions documents (MD 120) as per business requirement.
• Involved in Conference Room Pilots (CRP’s) and Quality assurance to give the client a better understanding of the Applications. CRP Setup included: Inventory (INV), Purchasing (PO), Advanced Pricing, Order Management (OM) and Shipping etc.
• Designed and developed multiple BR 100 setup manuals as per business requirement.
• Implementation of Procure to Pay (P2P) and Order to Cash (O2C) cycles.
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API (Interfaces) to import legacy Payable Invoices into Oracle Payables (AP).
• Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API’s to import the Items.
• Setups for Freight carriers, Freight cost types and shipment transit times are all done as per business requirement.
• Setup profile classes for customers with bulk orders. We used these profile classes to send weekly statements automatically.
• Setup multiple quick codes for INV, PO, OM, AP, and AR. Eg: (Discount Amount Basis, AR Transaction Type Categories, Account Types etc … to meet current business requirements).
• Developed interfaces between legacy systems (AS400, MFG Pro) and Oracle Apps.
• Designed, documented and implemented Accounts Payables Interface. Produced Technical Spec (MD70) and Installation Instructions document (MD120).
• Designed and developed staging tables, Custom PL/SQL API’s and use Oracle Public API’s to load
• Open Payables Invoices (AP), Suppliers, Supplier Sites, Supplier Contacts, Banks, Bank Branches, and Bank Accounts etc … from legacy system to Payables.
• Developed Interfaces on Oracle E-Business Suite R12.1/11i using Open interfaces and Public API’s.
• Developed Supplier API Interface using AP_VENDOR_PUB_PKG for the new Supplier Management System which was developed using OAF.
• Designed and developed Staging tables, Custom PL/SQL API to import
• Customers using TCA (Parties, Party Sites, Party Accounts, Party Account Uses), Open Sales Orders etc., from legacy system to Oracle R12 and 11i.
• Designed, documented and developed Customer Interface (AR) using TCA (Parties, Party Sites, Party Site Accounts and Party Account Uses) between Web Based Application and Oracle Receivables (AR) Module.
• Developing Employee Conversion programs to populate the legacy employee data into Oracle HRMS tables using API’s in HR module and Registering as concurrent programs in Oracle Apps 12.1.
• Personalized Customer OAF Form and added new fields for form to enter extra information with respect to business and user requirements.
• Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Technical, Performance and Regression testing.
• Developed multiple reports using XML BI Publisher as per client’s requirement.
• Customized Invoices Pick and Pack slips to list back ordered items and print discount information in Oracle Order Management (OM) module.
• Execute Public API’ to load pick released (OM) orders into external system (shop floor system).
• Performed tuning on the SQL and PL/SQL packages to improve processing time and efficiency.
• Used Oracle\'s optimizer and monitored how it chooses the execution path/plan for the procedures.
• Performing Code Reviews for customization of existing procedures and Packages as per the requirement.
• Designed, developed, registered customized forms, tables and reports using AOL.
• Create Users and Responsibilities for Security and limit permission as per business needs.
• Defining New Descriptive flex fields on multiple forms as per business requirement.
• Created value sets and value set values using AOL.
• Worked extensively on JMS adapter.
• Worked on SQL, PL/SQL and Reports 9i
• Modification of B2B messaging system on Oracle SOA 10g Suite.

Environment: Oracle Applications R12.1/11.5.10.2, AR, OM, INV, HRMS, GL, AP, BOM, SCM, FA, AOL, Forms 9i/6i, Reports 9i/6i, Oracle 9i/6i, SQL and PL/SQL, Discoverer 4i, Toad, SQL Navigator, Oracle SOA 11g Suite, Windows XP, Windows NT and Windows 7.

Confidential,Santa Monica, CA Jan 2009 – Dec 2009

Responsibilities:

• Involved in the system study, requirements, Gap analysis and design documentation.
• Involved in Functional Document review and Prepared Technical Specifications based on the Business Requirement.
• Implementation of Order to Cash (O2C) cycle.
• Involved in Building Customizations and Enhancements using Reports and Forms.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
• Designed and developed Technical Specifications for the Inbound Interfaces as per the Functional Specifications in OM and AR.
• Imported data from legacy system into staging tables using SQL*LOADER, perform validations prior to transferring data into OM Open Interface tables.
• Involved in setups and customization of ORACLE Payables and developed data conversion program to load payables data from legacy system to ORACLE Payables.
• Involved in Legacy Accounts Receivable Invoice Conversion and loading Receipts. Information from POS system using Lockbox Transmission.
• Uploaded Transactional data such as Item cost and Price list in Oracle Applications using DATALOADER, The business requires that the Item Cost and the Price List be updated every 3 months. DATALOAD captures Keystrokes and loads the data into Oracle Applications.
• Customized reports in AR such as: Customers Profile Report, Aging Report.
• Customized reports in OM and Inventory (INV) such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report.
• Used FTP Adapters to get order and customer information placed on third party(Pablo) sites (extremefitnessresults.com or getmovingcatalag.com) into oracle staging tables.
• Assigning unique customer reference id to the customers who have taken membership before placing the file on ESB queue.
• Created ­­­­­­­customers who placed orders on third party site in oracle.
• Created DFF’s on standard and custom forms to store additional information. Eg: Customer sites form, order lines forms and shipping transactions form.
• Developed documents regarding the custom process of order creation from Customer Service Portal form and involved in the study of all their custom processes.

Confidential,Chicago, IL Oct 2007 – Dec 2008

Responsibilities:

• Involved in Functional Design Review and preparing the Detail Technical Design Documents.
• Involved in Customization of Standard Oracle Reports as per client requirements.
• Involved in Code Review Process to make sure that code is in compliance with AIM methodology,
• Analyzed and designed customer specific forms and reports and implemented. Reports such as ECO changes Report, Item where used Report, Weekly Inventory Report, Inventory Aging Report Etc and Data entry screens like Quick Customer lookup.
• Developed Interface Program for loading Items information from legacy system to Inventory (INV) interface tables using SQL*Loader and PL/SQL and subsequently ran Item Import to populate the Inventory Base tables.
• Developed a custom conversion program to validate customer information before loading them into AR Base Tables.
• Involved in importing BOM and Costing Data from legacy system.
• Used Order Management API to populate the data into various base tables.
• Registered concurrent programs, request groups for reports and concurrent requests.
• Involved in Unit testing and Bug Fixes, Involved in UAT Process (work involved helping Test Team to come up with test cases and Bug Fixes)
• Involved in Cut over Planning and execution, Involved in Post Production Support (work involved Supporting Oracle Application and supporting training).
• Defining New Descriptive flex fields.
• Created Value sets and value set values
• Manage Concurrent Processing and Concurrent Manager
• Created new reports as per user requirement

Confidential,Alpharetta, GA Feb 2007 – Sep 2007

Responsibilities:

• Reviewed Functional (MD50), Produced Technical (MD70) design document and Conversion Mapping Document (CV40) for Item Import and Open Sales Order Import.
• Developed Conversion programs, Staging Tables and Customized PL/SQL API for Item Import and Open Sales Order Import.
• Design and developed an interface between Bank of America and Oracle Receivables for Cash Receipts (Auto Lockbox).
• Involved in Conversion of Customer information in AR
• Customized the Oracle Order Management Transaction workflows.
• Developed Custom forms and added the zoom functionality.
• Developed PL/SQL programs and scripts. Registered concurrent programs, request groups for reports.
• Created Customized Invoice report for client by modifying standard Invoice Report provided by Oracle
• Enabled descriptive flex fields on Sales orders and Invoices to facilitate additional information.
• Developed Reports using Discoverer4i, Performed setups for EUL, Created business areas, Created joins, Create calculated items, Created conditions, Created new folders based on user requirements.
• Performed Administrative tasks like adding security, granting privileges, and scheduling and sharing of reports.
• Converted standard report to Discoverer reports for more user-friendly access to the data.
• Edited existing reports to add additional functionality (Parameters, sorting, calculations and conditions).
• Tuned reports by using summary management (ASM).
• Designed and Developed Customer and Invoice conversion program through Standard (AR) Oracle Receivables Interfaces. Imported data from legacy systems to Oracle Receivables tables using SQL*Loader. Used Auto invoice to import regular, debit memo, credit memo invoices from legacy systems into (AR) Oracle Receivables.

Confidential,Hyderabad May 2005 – Dec 2006

Responsibilities:

• Map the business process against Oracle Financials and prepare gap analysis report.
• Data setup Oracle General Ledger, Oracle Receivables, and Oracle Payables.
• Developed interfaces between legacy systems and Oracle Apps.
• Involved in various activities like reviewing functional and technical documents, discussions with the client regarding the proposed solution, PL/SQL programs scripts, related reports and forms, unit level and user acceptance testing.
• Involved in setup and customization of ORACLE Payables and data conversion from legacy system into ORACLE Payables
• Importing vendor and invoice information into ORACLE Payables using stored procedures and SQL*Loader.
• Designed, developed, registered customized forms, tables and reports using AOL.
• Developed customized Reports like aging analysis, Outstanding Invoices, and Customer wise report for amount that is considered bad debt.
• Customized Invoices, Pick and Pack slips in Order Entry module
• Uploaded the assets information into Fixed Assets module
• Defined custom shipment document sets and pick release document sets and registered them in AOL
• Create Users and Responsibilities for Security.
• Defining New Descriptive flex fields.
• Created Value sets and value set values
• Manage Concurrent Processing and Concurrent Manager
• Created new reports as per user requirement
• Prepared MD-070’s Technical documents for the components.
• Review of technical design documentation and code walkthrough of the developed components

Education:

• Bachelors in Computer Science.