SUMMARY

• 13 years of experience in IT industry involved in all stages of projects life cycle such as Analysis, Support, Development, Testing, Implementation.
• Lifecycle implementations of very complex Oracle Sales cloud (CRM), BigMachines (CPQ), ERP/Oracle implementations/Enhancement/Support (10.7, 11.5.10 and R12) as a Techno Functional Analyst.
• Experience in Business Requirements gathering, GAP Analysis, Test Plan Preparation, Unit Testing, System Integration Testing, UAT, Go - Live, Training, Production support, and documentation.
• Experience in Oracle CPQ cloud and its integration with legacy ERP system.
• Expertise in handling assignments in Oracle Manufacturing/Distribution/Financial Modules both Technical (Forms/Reports/Workflow/Oracle Designer/DBA) and Functional (Inventory / Purchasing / OM/ BOM/ WIP/ istore/Oracle Configurator).
• Good understanding of objects like Folders, Model, Effectivity Set, Usage, Configurator Extension Archive and Structure, Rules, User Interface in Configurator developer.
• Experience in Development, Personalization and Extension of OA Framework (OAF) based applications in internet modules and custom self service based modules.
• Proficient in Developing, Customizing and Implementation of Oracle Manufacturing and Distribution modules: INV, BOM, Configurator, OM, Advanced Pricing.
• Expertise in System Administration including Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, values sets, flex fields, registering menus, forms, reports, concurrent programs, providing support to apps users for any technical or functional issues and Data conversion from legacy system to Oracle Database.
• Strong Experience in identification and development of Interfaces & Conversions, carrying out the Data Mapping using PL/SQL Programming methods and Oracle APIs.
• Has excellent interpersonal skills and urge to learn new technologies to meet challenging environment.

TECHNICAL SKILLS

Oracle Supply Chain: - Order Management, Configurator (OCD, CIO), Advance Pricing, Inventory, Advanced Supply Chain Planning, OPM, Warehouse Management System

Oracle CRM: - Sales cloud, Quoting, Contracts, Service Contract, Install Base

Oracle Manufacturing: Bills of Materials, Work in process, Inventory, PIM

Oracle Financials: - General Ledger, Receivables, Payables, Fixed Assets, Cash Management, Expenses, iProcurement, Project Accounting, EBTax, Sabrix 5.2.

Databases & Tools: Oracle 9i, Oracle 8i, PL/SQL, SQL, Database Triggers, SQL* Loader, TOAD, Developer 9i, Oracle Workflow, XML, CSS

Framework: Oracle Applications Framework (OAF), ADF.

Application Development: Developer/2000, Forms 6i, Reports 6i, Discoverer 4.1/9i, Java/JSP, jDeveloper

CPQ: - Configure, Price, Quote (BigMachines)

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, Ohio

CRM and Configure-Price-Quote (CPQ) Consultant

Environment: s: Oracle Application (R12.1.3) (Oracle Sales Cloud R11, BigMachines, Configurator, Pricing, Quoting, OM, BOM, INV, Java, CIO, Groovy)

Responsibilities:

• Worked on integration between Oracle Sales Cloud R11 (CRM) and EBS.
• Create functional design documents and implement solution working with business for Oracle Service Cloud.
• Functional setups like Accounts, Users, Calendar, Opportunities, Currency, Sales Catalog, and Geography data.
• Worked on application and page composer to add and modify standard objects, custom objects and custom field and used groovy script for logic.
• Setup for job roles by using OIM and duty role, role hierarchy, privilege, role privilege mapping by using APM.
• Worked on Object workflows in sales cloud to send email notifications to users.
• Worked on Business processes to create an approval process for an object.
• Worked on reports to customizing standard reports in oracle sales cloud.
• Configured/setup CPQ Configuration, Commerce, Document Engine and its integration with Pricing, Inventory, Item Master modules.
• Converted Product Specs and Price books to become Oracle CPQ Configuration rules and database.
• Worked on Config rules like Configuration flows, Recommendation, Constrain, Hiding and recommended items, BOM and Pricing rules.
• Worked on Commerce rules like Constrain, Validation, Hiding rules.
• Built CPQ Configuration Models for multiple product lines.
• Worked on data tables for commerce libraries and util libraries (BML, BMQL).
• Worked on print action to link with document that was created in commerce process by using printer friendly XSL.
• Worked on workflows for quote approval process.
• Converted Product Specs and Price books to become Oracle CPQ Configuration rules and database.
• Worked on different type of integration XSLs. Ex. Import, Export, Delete.
• Designed Configurator model structure to accommodate the user interface requirements.
• Production instance strategy for CZ model migration and BOM synchronization and publishing.
• Build Configurator models and writing Configurator rules.

Confidential, Sunnyvale, CA

CRM and Configure-Price-Quote (CPQ) Consultant

Environment: s: Oracle Application (R12.1.3) (Salesforce, Configurator, Quoting, Pricing, BOM, INV, Java, CIO)

Responsibilities:

• Managed the Configure-Price-Quote (CPQ) and Quote-to-Order integration processes
• Starting from Item creation, setting up the BOM, populating the BOM to OCD, publish to OM.
• Configure CRP's, UAT, and Production instances for these modules and setups CZ, OM, BOM.
• Designed interface for Users and User groups from Oracle CPQ to Oracle EBS
• Designing, Publishing and Testing Various Configured Models for the PTO Process using Oracle Configurator and Configurator Administrator
• Designed Configurator model structure to accommodate the user interface requirements.
• Production instance strategy for CZ schema migration, and BOM synchronization and publishing
• Build Configurator models and writing Configurator rules
• Design test and implement BOM and CZ database migration between Development instances to Testing instances and Production instance
• Item details with item types (PTO, ATO models and Option class and options and standard item types) and Description, name and Modeling the structure.
• Creating prices for models, Option classes and options
• Creating configuration rules to control user selection of product options
• Documentation for functional specifications for various client requirements.

Confidential, Wayne, PA

Configure-Price-Quote (CPQ) Consultant

Environment: s: Oracle Application (R12.1.3) (Salesforce, Configurator, Quoting, Pricing, iStore, BOM, INV, Java, CIO)

Responsibilities:

• Managed the Configure-Price-Quote from SFDC
• Creating and Modifying Structure, Rules, UI as per new requirement and Publishing.
• Continuously working with client to build additional Configurator models for existing and new Modules.
• Resolved issues while Migration and Publishing
• Reviewed RD’s documents for the upgrading paths
• Resolved issues Maintenance and Break fixes in enhancement.

Confidential, Redwood City, CA

Sr. iStore Functional Consultant

Environment: s: Oracle Application (11.5.10, R12.1.3) (OM, iStore, INV, Java, CIO)

Responsibilities:

• Upgrade project - 11. .1.3
• Responsible for Setup and configuration of iStore.
• Customizing iStore Custom Item Search and View Search Results. iStore Order Validation and Order Type Defaulting.

Confidential, Westborough, MA

Sr. Configure-Price-Quote (CPQ) Consultant

Environment: s: Oracle Application (11.5.10, R12) (Oracle Configurator, Quoting, Pricing, BOM, iStore, OM, Java)

Responsibilities:

• Upgrade project - 11. .
• Responsible for business requirements gathering, process mapping & gap analysis
• Reviewed RD’s documents for the upgrading paths
• Responsible for BOM design
• Continuously working with client to build additional Configurator models for existing and new products.
• Generate, customize, and test User Interfaces for configuring a complete and valid product or service. Publish your configuration model to test and production environments.
• Worked on Error Handling System in storing all the errors that occur during interfacing and loading.
• Designed the effective usage of Effectivity sets in Configurator
• Discuss with business users and design the user Interface and construct the configurator rules based on the business rules and constraints
• Expert in preparing Business Requirement Documents (BR100), design documents (MD050) and Test Scripts
• Published Run-time models and their user interfaces to HTML Quote, iStore
• Responsible for managing the defect fixes, issue management, Inventory Maintenance and minor product roll outs.
• Designed the Configurator User Interface, Bills of Materials, Business Rules for Monthly Releases
• Successfully delivered the project on-time without any post production issues
• Resolved issues while Migration and Publishing
• Resolved issues Maintenance and Break fixes in enhancement.
• Creating and Modifying Structure, Rules, UI as per new requirement and Publishing.
• Responsible for Setup and configuration of iStore, Configurator & Quoting

Confidential, Cincinnati, OH

Sr.Oracle Techno-Functional Consultant

Environment: s: Oracle Application (10.7) (Inventory, BOM, OM, Purchasing)

Responsibilities:

• Experience working on different levels of TAR’s.
• Code review and testing and fixing the problems.
• Provided instant solutions to issues, which were reported in the production instance.
• Involved in design reviews, test plans and code reviews. And also involved in creating the review checklist and technical design document templates.

Confidential

Sr.Oracle Configurator / iStore Functional Consultant

Environment: s: Oracle Application (11.5.10, R12) (Oracle Configurator, OM, Quoting, Inventory, BOM, iStore, Java, CIO)

Responsibilities:

• Techno-functional role in Oracle Configurator module
• Integration of Oracle Configurator into OM Order Entry form and iStore.
• Discuss with business users and design the user Interface and construct the configurator rules based on the business rules and constraints
• Dynamically display the option features and add the components based on the site and responsibility level
• Design and develop functional companions to automatically create instances, validating the text option feature validation for many other validation based on external data using PL/SQL
• Prepare impact analysis for the existing custom extensions. Work with functional people and prepare the technical document.
• Configuration of PTO (Pick to order) and ATO (Assemble to order) models
• Setup the Configurator Model, Rules, User Interfaces, and Publishing
• Utilizes Logic rule, Numeric Rules, Comparison Rules in Oracle Configurator
• Worked with PLM team, whenever the BOM changes, configurator will be synchronized
• Developed the BR70 for the reports requirements. Developed the Functional Design document MD50 to facilitate the technical customizations
• Work on customization and extension of various pieces of iStore pages (menu structures, password management, order tracking)
• Architect Production instance strategy for CZ schema migration, remote BOM synchronization and remote run-time model publications
• Designed Configurator model structure to accommodate the user interface requirements
• Knowledge in the Interface to Configurator (CZ) using CIO from home grown jsp pages
• Coding for Java extensions for customizations

Confidential, Sunnyvale, CA

Oracle Configurator Techno-functional Consultant

Environment: s: Oracle Application (11.5.10)(Oracle Configurator, Inventory, AR, OM, BOM, WIP, EBTax, Vertex)

Responsibilities:

• Manage the Configure-to-Order integration processes
• Configuring Rules (logical, numeric, etc) in Configurator developer
• Analysing, Developing and testing various concurrent programs for BOM validation.
• Involved in the Set-up of the Profile Options
• Architect Production instance strategy for CZ schema migration, publishing and remote BOM synchronization
• Configure CRP's, UAT, and Production (Live) instances for these modules and setups OM, BOM, WIP, CZ, Flexfields
• Build Configurator models and writing Configurator rules
• Design test and implement BOM and CZ database migration between Development instances to Production instance
• Excellent understanding of AOL & Sys Admin, reports, forms, functions, validation sets, request sets and concurrent programs.
• Involved in Product Life cycle, starting from Item creation, setting up the BOM, populating the BOM to OCD, publishes to OM.
• EBTax integration with Vertex and Sabrix third-party software’s for indirect tax solutions.
• Designed Configurator model structure to accommodate the user interface requirements.
• Item details with item types (PTO, ATO models and Option class and options and standard item types) and Description, name and Modeling the structure etc…
• Importing items from Oracle inv to Configurator
• Creating prices for models, Option classes and options
• Creating configuration rules to control user selection of product options
• Develop the generalized functional companions to populate data to CZ config attributes and cz config ext attributes
• Designing, Publishing and Testing Various Configured Models for the PTO Process using Oracle Configurator and Configurator Administrator
• Documentation for release notes and functional specifications for various client requirements.

Confidential

Technical Consultant

Environment: Oracle 9i, Oracle Applications 11.5.10, OM, PO, INV, Developer 2000, XML Publisher.

Responsibilities:

• Preparation of Technical specifications from the functional specifications received from the functional team.
• Converting the technical specification into technical design documents.
• Worked on Order Import to bring the orders from legacy system, which is already made available in flat file to Oracle Applications 11i using Order import concurrent program.
• Developed Outbound interface to get item Quantity Details.
• Changed Labels in Sales Order Form through Form Personalization.
• Customized Purchase Order Form Using CUSTOM.pll.
• Attached Lov’s and Calendar to Developed Forms.
• Developed Requisitions and PO Information XML Report, Return to Delivery Note XML Report, Backlog Orders Report, Customized report on Order details with shipped date more than ‘X’ days.

Confidential

Technical Consultant

Environment: Oracle 9i, Oracle Applications 11.5.9, OM, PO, INV, Developer 2000

Responsibilities:

• Creating Value sets for report parameters and registering them in applications.
• Registering Custom Applications, Concurrent Programs, Tables, Oracle ID’s and Forms
• Defining Executables and Concurrent Programs
• PL/SQL Method of submitting Concurrent Programs
• Developing conversion and interface programs and registered them as concurrent programs and unit testing.
• Worked on Item Interface to bring all items from legacy system that is already made available in flat file to Oracle Applications 11i using interface tables and item import concurrent program.
• Developed outbound interface to get Daily net material transaction. The main purpose of this out bound interface is to bring data of all the Blanket purchase agreement to a flat file.
• Customized Oracle standard PO forms calling the ZOOM functionality as per the client requirement.
• Developed POs with Inactive Items report, Drop Ship Po’s having pending receipts, vendor zero debit n credit amounts, cancelled orders based on Customer name, PO-Report of Purchase orders.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.8, OM, INV, AR, Discoverer 4i, PL/SQL, SQL*Loader, Toad7.

Responsibilities:

• Bookings Adjustments tracking system, Reports, Database Triggers and SQL Procedures related to this task. Involved in defining Transaction types.
• Involved in writing interfaces of incremental and refresh program (Inbound and Outbound) to send data from one system to another.
• Defining set up options, Job and Position flex fields, Purchasing position hierarchy, Job and position attributes purchasing cycles, RFQ’ s for suppliers in purchasing module.
• Developed and Customized Shipping Reports, Backlog Reports, Open Picking Batches Report, Booking Reports, Scheduling Reports, Back Order Reports Shipment Summary Reports.
• Setting up Purchasing Document type, Line Type, Parameters Purchasing Approval Hierarchy, Employee set up.
• User support on performing various activities like train the users to enter POs, Requisitions etc.
• Interpreted the end-user business requirements to design and develop complex Discoverer reports.
• Created parameterized reports using Discoverer Plus.
• Printing Bitmap AR Reports and customized numerous extract and reports used for day-to-day purposes.
• Responsible for performance tuning of the existing procedures and table indexes.
• Defined profile options, payment terms, Quick and shipping documents, Sales credit types, Import order sources, order cycles, security rules, order cycles, Pricing agreements in Order Entry module.

Confidential

Technical Consultant

Environment: Oracle Applications 11.5.9 - Manufacturing, Order Management, AR, EBS, Discoverer 3i/4i, UNIX, Oracle 8, PL/SQL.

Responsibilites:

• Responsible for Customer Interface customizations in Oracle Order Management.
• Created a package as a library, which in turn is called by Order Import Process with the required parameters to allow Oracle Applications Order Import to generate Credit Memo in AR.
• Worked as a Report Developer using Discoverer desktop created and maintained the work sheets.
• Created Concurrent Programs to create transactions and update balances in exchange for Invoice adjustments, Credit Memos, Receipts and Reverse Receipts which are otherwise manually created in Oracle Financials.
• Responsible for Data Migration process and involved in performance tuning of existing stored procedures, table indexes.
• Developed PL/SQL Packages, Stored Procedures and Functions specific for project implementation.
• Customized Order/Invoice detail report; Order by item report, Sales Order Workflow status Report, Order on credit check hold Report, Sales Order and Purchase Order Discrepancy Report in Order Entry/Management.
• Conversion execution of second Region was done on a Production environment over a period of 2 months with absolutely no impact to the Production environment.
• Discussion with users and system owners in analyzing and understanding data conversion requirements.
• Requirement gathering, analysis and development of functional designs for legacy data conversion to Oracle applications.
• Identify dependencies & execute the different conversion entity programs in parallel.
• Conducted TEST & DRY Runs to rehearse the actual conversion process and to clean up the legacy data in-order to reduce the fallout.
• Significant contributions to Customer, Prospects, Contracts, Tasks & Sales Order migration.