SUMMARY:

• Having 12 years of experience in IT (Oracle ERP implementation and customization Data Analysis and production support)
• Worked in all the phases of the system development life cycle in Oracle ERPversions (11i -11.5.10, 11.5.8, and 11.0.3) & R12.
• Excellent technical Knowledge in Oracle Applications with SCM and OTC Chain Modules like Shipping, Fulfillment, Order Management, Inventory and Advance Pricing.
• Hands on experience in Upgrade and Migration of Oracle Application versions 10.7 to 11.5.10, 11.0.3 to 11.5.10 and 11i to R12.
• Extensive development experience and expertise extending Oracle 11i Advanced Pricing Applications (11.5.10) using Pricing Entities, Price Breaks, Pricing Modifiers, Pricing Contexts and Attributes and pricing APIs, also having good experience with pricing engine rules.
• Hands on experience in development and extension RICE components using SQL and PL/SQL, Customization of forms using CUSTOM.pll, reports using Report builder 6i, XML Publisher and exposure to WF and Oracle Discoverer.
• Experience in Using Oracle standard API, Forms personalization and Extensions.
• Extensive experience in utilizing Oracle Utility tools like Toad, SQL*Loader, Import and Export.
• Performed development, testing and integration of Oracle application objects (Oracle forms and reports) and Oracle database objects (tables and views).
• Extensive development experience and expertise creating custom pricing API's that can price single line and order level queries applying all Advanced Pricing engine rules
• Excellent technical knowledge in Oracle Forms/Reports, Workflow builder, PL/SQL and Oracle AOL (Application Object Library).
• Migration of legacy data to oracle using SQL*Loader and UTL_FILE utilities
• Good experience in implementation and customization of Oracle Application modules for Order Management, Shipping, Inventory, Advance pricing modules.
• Good experience in development of functional/technical design documents.
• Proficient in server side programming - Store Procedures, Functions, Database Triggers, Packages using PL/SQL and SQL.
• Involved in all aspects of Software Development Life Cycle and Production troubleshooting, Software testing, Requirement Analysis, Design Documents
• Strong Communication, Presentation and Analytical Skills.

• Oracle ERP distribution/Supply Chain Modules: OM, SHIPPING, PRICING,EDI, INV, PO, BOM,WIP
• Oracle ERP Financial Modules: GL, AP, AR
• Oracle Developer/GUI Tools: Oracle Forms (6i, 4.5), Oracle Reports (6i, 2.5),Workflow Builder (2.0,2.6,2.6.2), Developer 2000, Visual Basic 6.0, SQL Trace, XML Publisher, JDeveloper
• Databases: Oracle 8i, 9i, MS Access
• Data Migration Tools: SQL* Loader
• Programming Languages: PL/SQL, SQL, C, C++, UNIX Shell script
• Operating Systems: UNIX, Windows NT, 98,2000,XP
• Web Development: HTML
• Others: Toad, SQL Navigator, MS Access, Excel, FTP

PROJECT EXPERIENCE:

Oracle EBS Consultant Dec 2011 - Present
Confidential

Responsibilities:

• Working as an ITA with Onsite co-ordination techno-functional role for the COVC OM IC Engine and NGC Integration project.
• This project is about Auto validation, Configuration and booking of UCS family based configurable order lines.
• Involved in all the phase of Functional Specification Document design, creation, internal review, SME review and External review with Cross functional teams. This scope is for Q4FY12 release.
• Familiarity with Cisco process.
• Worked on CC gate documents like Impact Analysis, Perforomance Analysis, ERIM Impact Assessment, Architecture process engagement kind of all documents.
• Familiarity with TTA, TCA, TTB, and TCB cycles of a release.
• Currently working between Dev team and Cisco Tech lead and Solution lead for this engagement and also directly working with business, Performance, QA and PMO teams.
• Collect and co-ordinate and look for resolution of the issues faced by the dev team from Offshore.
• Design is about auto validation and configuration and auto booking of Legacy order source based order lines in ICE.
• Instead of changing the IC Engine designed logic through independent concurrent program which will do this validation and call the booking API to auto book the legacy order source based order lines.
• Failure cases will be handled by GTMSS team manually based on the tele service case raised thru email alert notification program.
• Main focus is on analysis and discussion at the initial stage and provided the solution for the BRD designed by the business.
• FSD created and modified and walk through with different cross function teams on an external review. At present its in development and TSD phase.
• Currently involved in code walk through, participate in the technical design and daily follow up for the DEV and TEST instance based KP resolutions for the Dev team.

Oracle EBS Consultant Mar 2011 - Nov 2011
Confidential

Responsibilities:

• Worked as a senior techno-functional consultant in SCM / Operations and Merchandising area of Oracle R12 EBS. At present involved in the frameworks of upgrade of 12.1 version. Current system support version is 12.0.4.
• Currently liaising between Business analyst and Oracle developer of ART.com for converting the business requirements into setups / configurations and concurrent programs like UNIX script (HOST) Plsql packages XML publisher reports and sql reports for the higher management forcast analysis.
• Worked with implementing new business requirements using Purchase Orders cancellation API / Price list API / Inventory Item in bound and Item outbound APIs.
• Developed and implemented successfully as per the business requirement for Mass Purchase Order cancellation thru concurrent program using purchasing API.
• Part of Lowes implementation Condenast implementation, allposters.com integration, Drop ship implementation for specific partners.
• Developed custom packages using AR Invoice creation API, customer level attribute update, Customer additional update API for various partner specific projects.
• Configured an important customer facing document “Pack slip” which was deployed successfully in the prod environment working for 14 countries with country specific requirements. All the business requirements configured and executed thru value sets. According to the new partner only the framework and configuration needs to be modified instead of modifying the report for each country specific changes. Changes will be updated only in the flex fields and values sets and the report will print based on the framework parameters specified for the country or region.
• Designed and developed BOM Actual and Planned Report to compare the cost and the Components of BOM and the WIP Jobs.
• Working on new partner integration related HDT (tickets), CR, and SR related technical fix in the dev environment and Test environment for the business testing.
• Technical tasks included in the areas of PL/SQL, XML Publisher Reports /Discoverer Reports and SQL Ad hoc scripts and in general it's in RICE components along with fine tuning Alert management.
• Technical work further extended with the areas of tuning, data bouncing, debugging, sql trace, tkprof and explains plan type tuning activities. Data export/import activities using Sql loader and plsql UTL packages.
• Using Oracle Advanced Pricing attribute mapping checked the attribute sourcing. Pricelist upload program will be executed for every pricing engine call.
• Pricing provides you with an option to source all the setup attributes or source attributes of only active price list, modifiers.
• Performance improved setting up the profile QP: Build Attributes Mapping Options is set to active only.
• Also familiar with Oracle Advanced Pricing Phases and Events which enables pricing engine execution to be divided into phases with each phase associated with an event in the calling application.
• Active participant of client requirement gather meetings, creating new TDDs, modification and maintenance of existing TDDs as per new changes.

Confidential Team Lead Jan 2010 - Feb 2011
SUN-Oracle Integration / CSC

Responsibilities:

• Working as a lead of Development / production support team in SCM Fulfillment track. SUN Oracle integration project.
• Main focus on providing support to the ongoing SW (Oracle) system along with integration of HW(Sun) Components into a Global single instance of Oracle R12 (GSIAP)
• Working on integration bugs user tickets, CR, SR related technical fix in the dev environment and UAT by test team.
• Production support: Oracle shipping / OM / BOM / WIP modules related issues resolution for Business created SRs and daily hand over activity with off shore team for critical P1 issues.
• Active participant of client requirement gather meetings, creating new TDDs, modification and maintenance of existing TDDs as per new changes.
• Involved in system Integration testing (SIT) in UAT environment before implement the corrections and changes done to the existing components and new components in production.
• Actively participating Enter/book / progress the Orders for IT supplemental testing and volume testing for various ATO PTO items for different country specific testing.
• Role includes develop and perform system integration testing for the enhancements and changes received from the business of Oracle and SUN.
• Worked on cash receipt creation, receivables transaction creation, customer attribute update related API's in AR for various sun partner integration with Oracle.
• Developed Shipping Label, RTV label programs of SUN-Oracle External and Internal Manu development for around 22 suppliers of Oracle and SUN. As part of shipping documents the ASN flow will trigger the label automatically for every Internal and External manufacturing suppliers.
• B2B suppliers will be sftped, for iportal customers zpl file will be attached to the PO line. Internal manufacturer's zpl file will be attached to the respective delivery as attachment.

Environment: Oracle Applications R12, Oracle 9i, Shipping WSH, OM, AR, PO XML Publisher TOAD SQL Navigator Forms6i, Reports 6i ZPL printer Configuration.

Apps Support Analyst Dec 2008 - Dec 2009
Confidential CA

Resposibilities:

• Worked as part of IBIS team on supporting deployment1 to 3 in production and deployment4 development and business validation.
• Working closely with the business/functional users to gather the Technical Requirements for the Order Management Workflow.
• Map the Business Process Flow to the Out of Box 11i Order Management Functionality
• Performed Gap Analysis and Identify Customization areas where needed.
• Prepared Technical Design Specifications (MD70) for areas of Customizations and Extensions needed to support the Client Business Rules.
• Customization/Extension of the Oracle Standard Order Header/Line Workflow (OEOH & OEOL Item Types) to align with the Customer Business Processes.
• Defined New PL/SQL Function Workflow Activities, Notification Activities using Standard Activities like Start, End, and Wait etc.
• Code PL/SQL procedures called by the PL/SQL Function Activities in the specified format.
• Defined New Workflow Processes and embed these processes in the Oracle Standard Order Management Workflow to ensure the business needs of the client are addressed.
• Write PL/SQL programs using Workflow Engine APIs (CreateProcess, Start Process, Get Item Attr, SetItemAttr etc).
• Involved in Developing Rice components related to deployment4 which is Oracle Apps R12 Order to Cash modules.
• Involved in Liaison between Business teams and users to analyze and investigate the issues related to the ERP 11i and 10.7 related Interfaces and Information Highway related issues.

Environment: Oracle Applications R12 and 11i , Oracle 9i, Order Management, AR, AP, PO, Inventory, Alerts, Workflow Builder Forms6i and Reports 6i.

Confidential Alameda CA March 2008 - Nov 2008
Oracle Apps Consultant

Responsibilities:

• Worked in data extraction for various requirements of Business Intelligence team.
• Worked as Liaison between Business Intelligence team and users to reconcile the ERP 11i and R12 data (Order to Cash modules) for their BIEE Dashboard report creations.
• Worked on specific requirement like Bookings report data, Shipping report data, Recognized Revenue data, and Revenue Backlog data for Business Intelligence team.
• Handled the Database object creation, CR creation for any new packages or synonym to be used for BI team.
• Designed and developed solution delivery (MD50 & MD70) for OM,PO and Inventory modules.
• Custom program also recognize revenue based on percentage of amount entered by user in Revenue transaction form.
• Imported BOM\'s and Routings from Legacy system into Oracle Bill of Materials using the standard BOM and Routing interface program.
• Involved in developing new reports and PL/SQL based extract programs for BU reporting and application extensions.
• Involved in providing the most suitable technical solution where there is a gap in out-of-the-box functional solution.
• Involved in Data Migration (Conversion) for GL, AP, AR and OM Modules.
• Involved in enhancement and development of reports using Reports 6i for Iexpenses and OM.
• Extensively worked on Order Management API's and Pricing API's for generating Custom Price using functions in Pricing Formulas.
• Used Modifiers, Qualifiers and Pricing Formula for Advanced Pricing
• Developed Reports in Order Management and WIP, BOM Modules using Reports Builder and XML Publisher.
• Extensively worked with PL/SQL Procedures, Functions, Triggers and Packages and Custom.pll
• Involved in Production Support, Month end and Quarter end support.

Environment:
Oracle Applications 11i/R12 UNIX, Oracle 9i, Workflow Builder, TOAD, SQL Loader, GL,OM, INV, AP, QP, AR, I Expenses, Forms6i, Reports 6i.

Confidential, Duncan, SC Jun 2007 - Feb 2008
Project: Migration of 11.0.3 to 11i

Implement existing business unit into oracle ERP. new operating unit /Inventory Organization (USAC) introduced in Oracle Applications Rel. 11.x.lesser interfaces manual conversions customization of exiting forms to the new operating unit from existing operating units and customization and new report creation for the new operating unit. Custom.pll changes for handling various requirements of form customization for the incoming operating unit.

• Project involved new setup, data migration, data cleanup and up gradation of 10.0.3 instance into an 11i instance also setting up a new inventory organization.
• Developed an extension for Pricing and Trading Database in Oracle Applications for USAC
• Support for USAC business users in the area of OM, Shipping and PO and INV.
• Defined new setups for transaction types, Price list setup and upload.
• Creation of descriptive flex fields in extension.
• Scripts for data upload from flat file using UTL scripts for price list uploads.
• Customized Reports like Shop Pack, Pick List, Pack Slip, Order Details, Drop Ship and Delivery Note using Oracle reports 6i for USAC
• Testing and migration of Order Entry related customized reports in Oracle Apps. Rel. 11.0.3 to 11.x.
• Part of design team to finalize on implementation strategy to use Oracle Order Entry, Shipping and Pricing.
• Involved in functional and technical design to use Oracle OM module related various interfaces
• Involved in pricing design for various price lists and modifiers using qualifier rules.
• Developed price list upload program for price list / modifiers with Oracle API Normal Price list set up as well as Price Break set up in Listing.
• Involved in data conversion of Advanced Pricing with Oracle API for Various Types of Modifiers and qualifier setup for the Modifiers.

Environment: Oracle Applications Release 11i (11.5.10), SunOS 5.6, Oracle/ SQL*Plus

Confidential, Singapore Apr 2005 - Apr 2007
IT Analyst

As an IT Business analyst major involvement in EDI project implementation with different Trade Partners with different EDI methodologies (XML / Traditional and Web form, HTTP, FTP) using Rosetta net and X12 standards.
Involved in supporting OM and OC modules of Asia Pac Region of the major integration project called OASIS (Symantec and VERITAS integration)
As well as day to day productions support activities especially in OM/ INV / BOM and WIP modules.

EDI/e-Commerce Gateway:

• Did the setup of the e-commerce gateway module, corresponding setups in the other modules.
• Defined Trading partners and code conversions.
• Wrote Automation programs for EDI files processing.
• Setup EDI 855 Purchase Order Acknowledgements.
• Setup EDI 997 Functional Acknowledgements.
• Wrote custom packages to define the Trading partners in the e-commerce gateway module, update the EDI details in the corresponding modules.

Production Support Activities:

Daily activities include day-to-day Production support Activities and trouble shooting of Oracle Order Entry, Shipping and Pricing Modules of OM and the related modules Inventory and PO. Such as Order entry, Po creation as drop ship, Po receipt Order staging Picking, shipping and Interfacing. Also familiar with the Service contracts and Install base modules

• Through checking of any part of the above flow of box order or Licenses and fix the problem if any until it flow to install base and invoiced to AR
• Every Quarter end closing activities of OM order /RMA and items in staging sub inventories
• Before opening of every financial Inventory and GL periods. Fixing the problems of any of the License and box orders and its flow thru to Install Base and Invoice to AR
• Regular maintenance of all scheduled jobs in Order entry, picking shipping interface to IB and AR
• Related BAUT (Business Analyst Unit) for every HD ticket, Change Request or Service Request raised by the business users.
• Co-ordination of the UAT from Asia pacific Japan region of the specific modules like OM/INV/PO and Bills of Materials.

Environment: Oracle Applications Release 11i (11.5.8), SunOS 5.6, Oracle/ SQL*Plus

Confidential, Singapore Feb 2002 - Mar 2005

Involved in development of two implementations and post go live and production support activities.
Worked mostly on RICE components and conversion.

Development and Production Support Activities:

• Daily checklist activities include day-to-day Production support Activities and trouble shooting of Oracle Order Entry, Shipping and Pricing Modules of OM and the related modules Inventory and PO. Every month end closing activities of OM order /RMA and items in staging sub inventories
• Before opening of every financial Inventory and GL periods, technical fix related to the above production support Activities.
• Customization of forms to facilitate user updates, before transactions can be interfaced to GL.
• Participation in designing of implementation, finalizing the segment values
• Understanding of business requirements and mapping with the standard functionality- included design for using of descriptive flex fields.
• Part of design team to finalize on implementation strategy to use Oracle Order Entry, Shipping and Pricing.
• Involved in functional and technical design to use Oracle OM module related various interfaces
• Developed price list upload program for price list / modifiers with Oracle API Normal Price list set up as well as Price Break set up in Listing.
• Uploaded almost 7 operating companies of Fuji Xerox braches all over APACJ related pricelists.
• Pricelist will be provided in excel by the operating companies which will be uploaded into interface tables first and validation will take place through a pl/sql package for the records which loaded into the interface tables. Successful records will be uploaded into the pricelist and error records will be inserted into the error tables with proper error messages.- QP_PRICE_LIST_PUB.Process_Price_List API.
• Involved in data conversion of Advanced Pricing with Oracle API for Various Types of Modifiers QP_Modifiers_PUB.Process_Modifiers API.
• Involved in functional and technical design to use Oracle OM interface tables to create financial transactions and customized OM, PO, and BOM related reports.

Environment:
Oracle Applications Release 11i (11.5.3, 11.5.8, 11.5.10), SunOS 5.6, Oracle 8i, Forms 6i, Reports6,
SQL*Plus, PL SQL.

As a part of IBM implementing team:

• Oracle Pricing Setup
• Modifier Setup
• RMA Interface set up
• Design to Import orders using Order Import Interface based on the client requirements
• Design and developed transactions interface using standard Transaction Open interface for sub inventory transfers.
• Conversion of custom procedures and reports (6i)
• Creation of Database triggers to support required customization.
• Designed and developed the interface logic to receive RMA items and close or split the order line according to the quantity received
• Design and developed automation of Pick Release and ship confirmation using the SHIPPING INTERFACE APIs according to client requirements, which required automating the process of splitting of order lines according to an external shipment file, creating deliveries, assigning deliveries. Further the design accommodated splitting and shipment of serial items.
• Design to Import orders using Order Import Interface depend on the client requirements
• Design and developed transactions interface using standard Transaction Open interface for sub inventory transfers.
• Customized Service Contracts Summary Report, Detail Report, Setup Report and Generate quote Report.
• Part of Post Go live support team.

Environment:
Oracle Applications Release 11i (11.5.3), SunOS 5.6, Oracle 8i, Forms 6i, Reports6, SQL*Plus, PL SQL

Confidential India Jul 1999 - Aug 2000

As a Technical Consultant, involve in the integration and Customization of Oracle Order Entry with the existing System for Confidential. The Project comprises of various Onsite-Offshore Modules for Customization and Integration.

• Role included mapping the Client requirement to Oracle applications, designing the interfaces required. Designing the interface and data mapping
• Interfaces include- Orders open interface to import orders coming in through the website. Interface included applying logic with respect to business rules. The organization assignments would depend on the source of items, items were assigned with the same ship sets if they were sourced from the same organization, to the same ship to address and were shipped by the same carrier.
• Modifications and enhancements to Customer import to bring in new customers into oracle receivables. Trouble shooting with Dunning Letters
• Wrote interface procedure to throw data into the Delivery base ship confirm interface tables (Oracle Order Entry)
• Use Oracle Alerts to send emails to Customers to notify delay, cancellation of shipments.
• Production support and troubleshooting related to Oracle OE, AP, AR, INV, PO

Environment: Oracle Applications Release 11.0.3, SunOS 5.6, MS Windows98, Oracle 8.x, Forms 4.5, Reports2.5, SQL*Plus, PL SQL, Discoverer 2000