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: 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 Manage file import mappings, Manage file import objects, Customer Information and schedule export processes to import/export bulk data in to oracle sales cloud using Customer data management.
• 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: 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.5.10 to R12.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.5.10 to R12.
• 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: 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.
• Worked on Import Standard Purchase Order to bring the Standard purchase orders from Order Management base tables to Oracle Application 11i using Import Standard Purchaser Order 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.