SUMMARY

• Oracle Applications Senior Techno - Functional Analyst with over fifteen years of experience in managing, solution designing, executing and supporting various Oracle E-Business Suite implementations and Oracle Fusion Cloud upgrades and projects.
• Adept in managing internal and external resources working full time or on staff augmentation and managed services.
• Excellent functional knowledge in Supply Chain Management (Inventory, PDH, Order Management ), Advanced Pricing, TCA, AR, Procurement, AP, GL and e-Business Tax.
• Experienced in implementing Oracle Cloud SCM - Order Management, Product Data Hub, Customer Data Management, Accounts Receivables, General Ledger
• Extensive experience in Implementation, Upgrade and Support of Oracle E-Business Suite with a very good understanding of the integration between boundary systems.
• Highly experienced in converting business problems to productive solutions and training super users and/or users along with creating a knowledge repository.
• Ability to lead and facilitate cross-functional teams to deliver complex projects.
• Excellent Oracle functional knowledge across a wide range of modules in Supply Chain Management, Advance Pricing, TCA.
• Experienced in Conversion of Suppliers, Product, Customer Items, Price List, Sales Orders, Purchase Orders
• Team player with strong interpersonal, communication and time management skills.
• Experienced in implementing projects using various SDLC methodologies like Agile.
• Experienced in full life cycle implementation projects covering Business Requirements Gathering, JAD sessions, Fitment and GAP Analysis, Future Business Process, Solution Design, configuring the Application, Functional Testing, Conference Room Pilot (CRP), User Acceptance Testing (UAT), Go-Live and Production support in Multi-Org environments.
• Worked in a multicultural environment and skilled at people management involving cross-functional teams, including offshore development.
• Extensive technical experience in RICEW (Reports, Forms, Interfaces, Conversions and Workflows), Discoverer and BI publisher Components
• Extensive experience in Oracle E-Business Suite11i and R12, Oracle Reports, Oracle Forms UNIX, SHELL Scripting, TOAD, Oracle Discoverer, XML Publisher/BI Publisher, Oracle Answers and Oracle Workflow.
• Prepared various functional and technical documents using Oracle AIM Methodology
• Customization and Personalization using Custom.pll and Form Personalization
• OAF Personalization and Customizations
• Service Oriented Architecture (SOA) Integrations
• Oracle Integration Cloud(OIC) Integrations with Oracle and third parties
• Expertise in Developed Packages, Procedures, Functions, Database Triggers, Interfaces and Data Conversion using PL/ SQL, SQL * Plus, TOAD and SQL* Loader
• Experience in Performance and Tuning (PL/SQL) using SQL Trace, Explain Plan, TkProf Indexing and Hints.

TECHNICAL SKILLS

Operating Systems: Unix, Linux, Windows

Oracle e-Business Suite: Inventory, Purchasing, Order Management, Advanced Pricing, PIM/PDH, BOM, Engineering, Shipping, AP, AR, GL and eBTax

Oracle Application 11i (11.5.9 and 11.5.10), R12.1.3, 12.2.5

Oracle Cloud: Oracle Cloud Master Data Management and Oracle Cloud Order

Management

Oracle Tools: Data Loader, SQL Loader

Programming Languages: SQL, PL/SQL, Java, Groovy

Project Methodologies: Agile

Databases: MS Access, Oracle 9i, Oracle 10g, Oracle 11g

Other Tools/Packages: MS Office, MS Visio, HPQC, QTest, Jira, PVCS, CVS,ServiceNow

PROFESSIONAL EXPERIENCE

Confidential, Irvine CA

Senior Oracle Techno-Functional Analyst

Responsibilities:

• Lead for Implementation of Reverse Logistics
• Lead meetings with business stakeholders to gather requirements
• Manage User Acceptance Test script creation
• Manage cross functional teams to ensure timely delivery
• Integration of RMA from Sales Force and Oracle Service Cloud
• Design Complex pricing procedures for Credit RMA
• Solution for complex replacement product substitution
• Shipping and Receiving of RMAs
• Integration with Serial Number Management Systems
• Integration with Oracle GTM for Denied Party Check and Product Validations
• Implementation of B2C sales channel in US and EU regions.
• Integration of sales orders, inventory on hand, ASN, RMA to Oracle ERP from SAP Hybris, Invoicing and Credit Memo generation, Revenue Accounting and GL Reconciliation.
• Configure order transaction types, AR transaction types, Auto Accounting, Tax accounts, Tax Rates, AR import sources
• Integration of Vertex Tax Software with SAP Hybris and Oracle ERP.
• Solution for O2C accounting - Order entry, AR and GL and Cash Application.
• Solution of Intercompany Purchasing as the sales were from different subsidiaries of the company - Intercompany Orders and Intercompany Invoicing (AP, AR).
• Trial Balance Reporting
• Implementation of Oracle Master Data Management and Oracle Cloud Order Management in both the Americas and EU regions, this project involved the consolidation of sales and processes of multiple subsidiaries across the globe. This required multiple conversions and integrations with legacy system and boundary applications. My major responsibilities on the project were
• Process harmonization and data consolidation of three subsidiaries.
• Designed solution for the Order Orchestration Flow to meet the requirements of three subsidiaries.
• Integration lead for Inbound and Outbound integration from Oracle Cloud to legacy ERP systems (Oracle) - Product, Pricing.
• Provide pricing solutions in Oracle Cloud.
• Data Conversion for Item, Orders, Pricelists, Products and open AR.
• Integration between Oracle GTM and Legacy ERP System.
• Support Month End processing - Execute Create Accounting to import and post Receivables data, open and close accounting periods.
• Developed outbound interface that copies summarized debit and credit records from Oracle GL and posts them to a third-party table through DB Links.
• Developed templates for check printing.
• Used WebADI to upload Journal Entries, Define templates for upload.
• Developed Interface to load employee expenses to GL from Concur using GL Interface.
• GL Interface to Oracle Cloud - Outbound interface to transfer data to cloud for month end closing.
• Integration of Trade Compliance system with Oracle to allow appropriate data to be printed on the Shipping Documents (Commercial Invoice an Delivery Order) and Restricted Party Validation.
• Implemented Oracle Customer Acceptance to allow revenue recognition post-delivery of materials.
• Implemented Tiered Pricing Solution for Credit RMAs based on complex rules that vary by sales channel.
• Implementation of Serial Number (Warranty) lookup, RMA Creation and RMA Status services integrated with salesforce.
• Support EDI integrations for Sales Order Creation, Ship Confirmation from Third Party Logistic Centers and ASN.
• Involved in upgrade of the Oracle 11i system to Oracle R12.
• Provided Techno-Functional Support for the existing 11i system for day to day business activities.
• Built reports per business requirements using Oracle Reports as well as XML Publisher - Open PO Report, Quantity on Hand Report, ECO Approval Report, Commercial Invoice
• Developed form to maintain Additional Sub-Inventory Attributes for sub-inventory, the form was made accessible through the zoom functionality.
• Developed collection programs to provide Quantity On Hand, Item, Shipping and Receiving data to Demantra.
• Provided support for customized PO Approval Workflow and ECO Approval Workflow, including bug fixes.

Confidential, Sunnyvale, CA

Oracle Consulting, Senior Consultant

Responsibilities:

• Involved in Conversion of Item, BOM and Pricelists.
• Lead for Development of Item Integration using SOA middleware. The integration was used to transfer data from PLM to ERP, the target was dynamic. Extensive use of Item APIs.
• Lead for Development of ECO Integration using SOA middleware. The ECO information was flowing from the 11i instances to the R12 instances; the user had the flexibility to change the target instance at run time.
• Led the development of Pricelist Integration using SOA middleware. The pricelist information was flowing from one instance to another; this included the Pricelist Line and Attribute information.
• Led the development of APC Integration using SOA middleware. The integration was used to transfer data from source to target. The integration was developed to transfer single row as well as multi row data.
• Developed APC conversion code to sync up APC attributes between source and target before the integration was scheduled.
• Lead for Development of a program that updates attributes of a certain attribute group in APC.
• Responsible for interacting with Business and getting requirements to perform APC attribution for Oracle CZ Models, this including doing setups (creating Item Categories, Attribute Groups and Attributes). I was the playing the role of an APC (PDH) Techno-Functional Consultant for this.
• Provided Post Production support for the above-mentioned integrations.
• Technical Resource for Oracle Configurator.
• Developed programs for List Price Calculations with complex Rollup Logic for Bundles to calculate List Price Data and update in APC.

Confidential, Bellevue,WA

Senior Consultant

Responsibilities:

• Development of objects which include OAF Personalization and Customization.
• Involved in Conversion of Purchase Orders, Requisitions, Invoices, Receipts and Suppliers.
• Developed E-text templates using BI Publisher for outbound interfaces.
• Lead for a deliverable that required development of a workflow and JRAD notifications. This workflow was used to send out notifications to buyers reminding them to receive the goods.
• Lead for the development of a Supplier Interface, which extensively used TCA API’s and XML Gateway.
• Lead for development of outbound interface that sends weekly invoice data from Oracle Tables to a Third-Party System.

Confidential, Vernon Hills, IL

BI Analyst

Responsibilities:

• Converted Actuate reports to BI Publisher. The conversion of the reports included layout conversion, creation of Integration Objects and registering the reports in the Siebel Application.
• Developed OBIEE Analytics Reports using Oracle Answers.

Confidential, Santa Clara, CA

Staff Consultant

Responsibilities:

• Developed triggers on the Items table.
• Designed and developed reports using BI Publisher. The reports were built to track change history on items and to create invoices for GIS transactions
• Designed and developed a PL/SQL program that extracts journal entries based on parameters provided, creates balancing lines for the journals and submits another custom program that calls the Journal Import program.
• Designed and developed an interface program that imports GIS transactions into base tables. The data was provided in flat files, the SQL Loader inserts the data into staging tables and the interface program validates and imports this data.
• Designed and developed a custom program to close Purchase Orders based on business validations. This program was designed to work differently for Purchase Orders created through the Purchase Order screen and Purchase Orders created from iProcurement requisitions.
• Customized of the PO Requisition Approval workflow.
• Designed and developed an object that allows Bulk Termination of Contract Lines, the form allows an option to choose whether the Header, Lines or Sub lines are to be deleted and fetched the information from the database for the selected option. Standard APIs were used for the termination. This also involved building a workflow, so the contract goes through proper approvals before termination.
• Designed and developed a form to display Install Base and Service Contracts. The data was provided in the form of a spreadsheet which was populated into tables. Any data manipulation was done through the form.
• Designed and developed a form that displays Customer Account Site Use, Pricing and Relationship Details for a Party Name or Number. The form consisted of two windows - one is a find screen that allowed the Party Name or Number to be selected and the second window to display the information.

Confidential

Staff Consultant

Responsibilities:

• During my tenure on this project I was involved in review and estimation of Functional Documents.

Confidential

Staff Consultant

Responsibilities:

• Designed and developed a data conversion program for Sales Orders. A consolidated package was written for multiple operating units, each having a different set of validations. This program imported sales order headers, lines, holds, attachments and allowed creation of ship to customers and addresses during the import.
• Designed and developed an interface that is scheduled to run every 10 minutes to update the sales order status in a custom table. The program determines the status of the sales order based on the status of the sales order lines. The sales order header status to be updated to the staging table is a combination of four alphanumeric characters that is analyzed based on business rules.
• Designed and developed a conversion program for Stock Locators.
• Designed and developed a conversion program for Customer Items and their Cross References.
• Designed and developed generic SQL Loader scripts to be used by the project team.
• Designed and developed shell scripts for FTP transfers.
• Created Discoverer Reports for GL, AP modules
• Designed and developed an Outbound Interface that sends Sales Order Information to a third party, the out file was to be generated in XML and placed in a directory.
• Designed and developed an interface that loads Purchase Order information to Oracle, the data file was received in XML format, the information is processed and loaded to Oracle standard tables.
• Designed and developed an interface that loads shipping information to Oracle, the data file was received in XML format; the information is processed and loaded to Oracle standard tables.

Confidential

Associate Consultant

Responsibilities:

• Designed and developed a very complex Equipment Transfer Form. This form was developed using Forms 6i. It provides a screen to allocate equipment to projects, calculate the usage and to query equipment.
• Designed and developed an interface program to calculate the usage and cost of equipment on a weekly basis.
• Designed and developed a form to create bill items and calculate markup values. The form consists of two windows (one query window and one bill items creation window). The form was developed using Forms 6i.
• Designed and developed a form using Forms 6i to maintain Rate Schedule Details. The form consists of only one window that allows the user to enter, update or delete rate schedules.
• Created Discoverer Reports for GL, AP modules.
• Designed and developed an Insurance Premium report using Oracle Reports 6i.
• Designed and developed a Purchase Order (PO) Report using XML Publisher.
• Designed and developed a Request for Quote (RFQ) Report using XML Publisher.

Confidential

Associate Consultant

Responsibilities:

• Designed and developed an interface program to extract data from GL tables and write them to a flat file.
• Designed and developed a Fixed Assets Conversion Program.
• Involved in development of Invoice Exception Report, Account Payable Summary Report using Discoverer.
• Created shell scripts for migration of the code files.

Confidential

Associate Consultant

Responsibilities:

• Designed and developed an interface program to update shipping information to Oracle. The shipping information was received in a flat file.
• Designed and developed an interface program to fetch Internal Order and RMA receipts data from Oracle tables and insert into custom interface.
• Created shell scripts for migration of the code files.

Confidential

Oracle Application Developer

Responsibilities:

• Designed and developed a conversion program to for Inventory Items.
• Designed and developed an interface program to load the daily rate data from GL’s standard table to a flat file.
• Developed Item Description Audit Report using Discoverer.
• Created Discoverer Reports for GL module.
• Develop shell scripts to migrate the objects.