SUMMARY

• Extremely Analytical and can implement, support any technologies. Lead extremely critical projects like FCCS Cloud, EDI, Tableau Reporting, Fusion Cloud and implementing many new aspects in Oracle ERP. Over 23+ years of extensive experience in analysis, design, development, implementation, support, and maintenance of Oracle Applications (ERP) in modules like Oracle Manufacturing, Oracle Financials and Oracle Supply Chain, Service Contracts, Install base. In depth experience in Development/ Customizations/ Conversions/ Up - gradation/ Debugging/ Performance Tuning/ Integration of Oracle Applications modules.
• FCCS Cloud - configured the set ups and loaded the TB from Oracle
• Oracle ERP Fusion Cloud.
• Extensive Experience in Order to Cash Cycle, Finance module and P2P cycle. Handled B2B, Drop Ships and Regular Orders
• Tableau Reporting Tool - Developed many reports be it graphical, or simple reporting
• EDI - lead the EDI project for receiving customer PO and sending POA, ASN and Invoicing
• Experience in Upgrade & Conversion/Migration of data from Legacy to Oracle System.
• Expertise in developing packages, procedures, functions, database triggers, interfaces and data conversion using PL/SQL.
• Uploaded price lists into Oracle from the flat file.
• Uploaded new items into Oracle from the flat file with Category assignment.
• Uploaded AP Invoices into Oracle from the flat file.
• Involved in Order Conversion through APIs
• Expertise in all major modules, Form modification, developing new form from Template.fmb, modified CUSTOM.pll, report development, customized reports.
• Extremely comfortable in concurrent program set up, value set, flex fields, request set and APIs. Written interface/conversion programs for importing data from legacy system to Oracle using PL/SQL, SQL*Loader
• Involved in Item set up, Category assignment, new category set up, Receiving returns, miscellaneous transaction for increasing on hand quantities, sub inventory transfer, inter-org transfer.
• Expert in Debugging and fixing Day to day Production Issues.
• Experience in performance tuning
• Expertise in Oracle CRM, Service Contracts, Install Base.
• Expertise in Bill of Material and Oracle Configurator.

TECHNICAL SKILLS

ORACLE Applications: ORACLE Applications 10.7, 11i, 11.03, 11.5.9, 11.5.10, 12.1.3, AOL, System Admin, Order Management, AR, Inventory, Shipping, Pricing, Purchasing, Service Contracts, Install Base, BOM, Oracle Configurator, Payables, Project Accounting, GL, Oracle Alert, Interface and Conversions, SQL Loader etc.

Database: ORACLE 7.x/8.x/9.x/10.x, 11.2.0.4

Development Tools: ORACLE Forms 4.5/6i/10g, and ORACLE Reports 2.5/6I/10g, TOAD,SQL* Loader

Programming Languages: SQL, PL/SQL and C

Operating Systems: UNIX, Linux, Sun Solaris, DOS, Windows 2000/NT/XP/Vista FCCS Cloud, Tableau Reporting, EDI, Fusion Cloud

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto, CA

Sr. Techno Functional

Responsibilities:

• R12 Upgradation Project. Introduction to multi org and the associated changes.
• Handled many key roles for the successful go live.
• Responsibly carried out the lead role, User Interaction, Understanding and Collecting Requirements, Writing Design Documents and involve in Development, Involved in day to day Production Support.
• OM Integration with in house quoting application. R12 upgrade changes with respect to TCA architecture and new order types etc.
• Inventory Integration with in house EPM application. Involved in design, development and end to end testing.
• Taking care of all custom set ups with respect to the integration with OM, Releasing the items, defining new order types, Picking Rules, Item conversion, Renewal Conversion from US org to Multi Org, Defining inventory, sub inventory for each org, profile set up, Inter Org transfer set up.
• Actively involved in development relating to Reports, plsql packages and AOL objects, Shell Scripts, XML Publisher, Alerts
• Defining Flex fields, Profile options, Custom responsibilities, AR Invoicing grouping Rule.
• Uploaded Price List, Updated Price List. Loading price for new items and Pricing Update to end date the existing pricing for certain items.
• Defined costing for newly created items.
• Sabrix Integration with EB Tax. Supported after go live Tax issues. Coordinated with 3rd party to fix the Sabrix code bugs.
• Coordinating the UAT and involved in development as well as coordinating with offshore for development. Actively involved in the quarter and year end support.
• Easily venture out into new features, modules, successfully delivering the output.

Confidential, Palo Alto, CA

Dev Lead

Responsibilities:

• Working on Service Contract, Install Base and Order Management modules. A portion of portal runs on a database which stores data from EBS and the customers get associated with an Entitlement Account.
• Developed the code, technical design documents (TDDs) from FRDs and coordinated with the off shore team for development.
• Working as a team to resolve critical issues, providing support during qa testing.

Confidential, San Jose, CA

Techno Functional Application Consultant

Responsibilities:

• Lead the Service Contract module, set ups, Contract Renewal Project including Auto renewal, Global Default Set up, Processing method set up, price list load through api, Invoice Transaction Source set up, Invoice Transaction Type set up, defining descriptive flex field to capture sales channel, service contract workflow customization, Email Quote set up, profile option set up, UOM set up, Billing prior to the contract start date, modified custom.pll, reports, forms personalization.
• Also implemented service contract renewal involving multi-currency (for EMEA).
• Customized service contract quote print report and implemented through Custom.pll and modifying the standard package.
• Programmatically assign items to service availability.
• Created covered product and relationships through api.
• Maintain renewal price lists.
• Order Conversion from external source.
• Wrote conversion program importing models with configuration.
• Order Return Line Workflow Customization to send the line details to UPS URL and get the address link in the response.
• Adding the fulfillment set functionality to certain order types.
• Adding the fulfill step to the line workflow. Modified the transaction type set up to assign the line workflow process.
• Bill of Material and Oracle Configurator-- Defining bill of material, populating and republishing the Model in the Oracle configurator.
• Receivables - have created customer accounts and customer sites through APIs Shipping - Supported shipping module.
• Inventory-- Item set up, Performed open interface mtl transactions interface to flush all the material out of Inventory and then updating the IB trackable flag and then perform receipt again, conducted miscellaneous issue and receipt, and received returns.
• Install Base stuck transaction processing, creating IB relationship, Changing IB ownership, Packages and Procedures, Order type set up change, view creation.
• Running ad hoc reports for Service contracts, Install Base, inventory, Bill of material, Order Management.
• Quoting --Entering Quotes and placing order, adding services. Quote to Contract Cycle Production Support: Quoting, OM, Shipping, Inventory, Pricing, Install Base, Service Contracts, Bill of Material, Receivables, Customized reports.

Environment: Sun Solaris 5.6, Oracle Applications 11.5.10, Oracle 9i, PL/SQL, Reports 6i, Forms6i

Confidential, Hayward, CA

Techno Functional Application Consultant

Responsibilities:

• Involved in Order Conversion. Existing Orders converted to Drop ships using Copy Order API and Process Order API.
• RMA Defaulting Rules.
• Customized Defaulting Rules for line type for RMA order type.
• Booking validation placed in Custom.pll. Created Value set to populate attribute based on other attribute values.
• Uploaded New Items. Loading New Items along with Cost and Item template and Categories. - As a part of new acquisition new items are loaded through pl/sql and sql loader to the staging table. Item import, Item assignment, category assignment, cost update; addition to quotation is then carried out.
• Involved in Item set up, Category assignment, new category set up, Receiving returns, Miscellaneous transaction for increasing on hand quantities, sub inventory transfer, inter-org transfer. Developed Reports for backorder due to insufficient inventory etc.
• Uploaded Price List, Updated Price List. Loading price for new items and Pricing Update to end date the existing pricing for certain items and importing price for new items. Customized Program for Pricing attribute selection in an order based on order type
• Service Contracts and Install Base - Attaching replacement line to the existing contract through API. Created DB triggers. Added customization to contract integration Program. Developed Reports
• Service Contracts - Customized Billing Schedule, modified Zoom screen.
• Install base - Involved in clearing transactions stuck in IB. Finding cause why many RMA replacement lines did not get associated with the original contract. Those RMA lines never got associated with the contracts affects revenue. RMA with multiple replacement line was modified to have one replacement line. Booking restrictions were placed for RMAs with multiple replacement line. Many validations were placed to make sure the replacement line if at all associated with service item attached to the contracts.
• Custom Invoice Aging report (Receivables) Invoice Printing report - customization for Siebel integration project. Invoice Import Issues - stuck in interface tables. Developed new Reports.
• Involved in Payables Invoice Import - Invoice load through sql loader and custom interface program. Invoice with PO matching is imported through payables interface program.
• PO creation from Requisition, Receiving Drop Ships, Developed few new reports and modified existing reports.
• Modified the custom interface program to facilitate orders get imported without getting stuck.
• Added new freight and discount logic to the interface program
• Progressed the stuck orders, fixed order import issues.
• Modified shipping ack. (called from Workflow) to have an option to send the report once PO is received.
• Involved in shipping orders and receiving drop ship orders
• Worked on open deliveries even though trip had closed.

Environment: Sun Solaris 5.6, Oracle Applications 11.5.9, Oracle 9i, PL/SQL, Reports 6i, Forms6i

Confidential, Mountain View, CA

Application Analyst

Responsibilities:

• Building custom interface programs to import Orders and Items from boundary systems using standard APIs e.g. Process Order.
• Building custom outbound programs to extract Order information, receiving drop ships e.g . Receiving Transaction Processor.
• Developing and registered new reports and Customizing Standard reports like Invoice Price Variance Report, Sales Summary Report etc.
• Developed custom program to interface Item Catalogs into Oracle Application (Thru Item Import).
• Work on Performance tuning of Reports and custom interface programs using various tools like tkprof and explain plan.
• Defined Custom Responsibilities and Menus.

Environment: Sun Solaris 5.6, Oracle Applications 11.5.9, Oracle 8i/ 9i, PL/SQL, Unix Shell scripts, Forms and Reports 6i.

Confidential, Santa Clara, CA

Programmer Analyst

Responsibilities:

• Involved in writing code for data migration as the data model changed.
• Up gradation of Reports
• Writing Stored Procedures, Reports
• Performance Tuning