PROFILE SUMMARY:

• Dynamic and accomplished professional with 12+ years of proven IT Operation and Management experience in end - to-end Implementation, maintenance, migrations, upgrades and integrations in Oracle Applications. Highly experienced in design and implementation of Oracle Configurator, OM, WIP, ASCP, BOM, Oracle PIM/PDH - Product Data Hub & CPQ BigMachines. Have been working as Lead Techno-functional consultant.
• CPQ Big Machines implementations, leveraged the product rules, configuration rules, Pricing rules & quoting.
• Extensive experience in design and implementation of Oracle Configurator. Highly experienced in design and develop model Structure, Defining Bill of Material(BOM), User Interface, writing Rules, Configurator Extensions, Publications. Implemented the Oracle configurator for various clients.
• Strong techno-functional experience on Oracle Configurator, Bills of Material(BOM), Order Management(OM), WIP Process, Adv. Pricing, Inventory. Strong Techno-functional experience in Oracle manufacturing processes.
• Having more than 6 years of experience on conducting full Life-Cycle implementations of Oracle MDM/PIM/PDH and Fusion PDH modules for the clients like Confidential, Confidential, Stuller and Confidential .
• Designed and configured Workflow for setting up Business Events, designing Event Subscriptions, Change Management workflows, NIR and Change Order workflows, setting up attribute groups, UDAs on Implementing PIM/PDH/MDM.
• Strong Techno-Functional experience in other modules such as ASCP, Purchasing, iSupplier, Order Management, Oracle apps financials - GL, AP and AR.
• Possess strong technical’s in Oracle 9i/10g/11g, SQL, PL/SQL, Unix Shell Scripting, Oracle forms, reports, Workflow, BI tools like Business Objects XI and Oracle discoverer. Performed feasibility analysis, impact analysis, RCAs, AWR reports, proof of concepts for complex business problems and issues.

TECHNICAL SKILLS:

Oracle ERP & DB: Oracle Apps 11i & R12, Oracle Fusion, Oracle 9i/10g/11g, SQL/PL/SQL, Java, Shall Scripting, Oracle forms, Report, Workflow.

BI and Other Tools: Business Objects XI, Oracle Discoverer, Clarify, Maximo, MS-VSS, WinCVS Source Control, PL/SQL Developer, TOAD, Putty, Psftp, Wincsv, Control-M.

PROFESSIONAL EXPERIENCE:

Confidential, Sunnyvale, CA

Oracle Apps Analyst

• Interfaces, OM/WIP set-ups, Issue fixes, functionality testing pertaining to OM, BOM, WIP, Purchasing modules.
• Performed functional testing, Inventory org creation, setting up the inventory parameters, BOM parameters, WIP parameters, shipping parameters and costing elements and testing end to end functionality of order management, WIP, Direct org transfer. Prepared the cut over plan for SITs and production.
• Business Process Fit Gap Analysis and mapping with the existing processes.
• Architect highly scalable integration mechanism to support information exchange with their enterprise systems within Confidential .
• Develop and execute test scripts, end to end functionality testing with different test cases, document outcomes, analyse and support development team for bug fixes.
• MD50, MD60, MD120 documentations for implementing various SCM functionalities.
• Experienced on working with BML/BML Functions/BMQL. Achieved the big machines functionalities by implementing the functionality using BML languages.
• Requirement gathering, solution designing, solution development, unit testing, code reviews, facilitating UAT, facilitating migration of changes & code migration cut over plans, prioritization meetings

Confidential, Mt Pleasant, MI

Techno Functional consultant

• CRPs - Demonstrated the CQP BigMachines functionality and implemented the functionality with respect to configuration, price changes, quoting & proposals.
• Implementation comprises configuration, pricing, quoting. Strong understanding of CRM, CPQ, Price to Quote and Order to Cash business processes. BigMachines Pricing setup, Commerce Setup, Doc Engine.
• Participate in the Fit Gap Analysis of existing processes, Facilitate the collection of all required knowledge about business processes on the project.
• Leverage the product rules, standards, distribute price to feature, and dynamic products with the requirement type of Mandatory, Recommend & upsell opportunity.
• Commerce Rules, Steps, Participant Profiles & Transition Rules, Configuration rules has been design, built Hiding, Constraint & Recommendation Rules
• Creating Configuration Rules, Recommended Item Rules & Configuration Settings.
• Pricing modified & created the new rules - Account specific pricing, maintenance product pricing, optional maintenance pricing, Volume Pricing etc.
• New Doc Engine, dynamic data access. Setting up file manager, user management, group. & Data upload/downloads for parts and price data.
• Work with the business architect and other planners to assess current capabilities and identify high-level customer requirements.
• SOA calls to Oracle API to Create Order in OM, It will be reviewed in OM and manually book, and once Order is booked Business Event will be raise thru trigger and send the Order Info to SOA layer which will be update to BMI Corresponding Quotes.
• Oracle CPQ Cloud integration with CRM/ERP applications,
• Experienced on working with BML/BML Functions and BMQL to implement CPQ functionality.
• MD50, MD60 documentations for implementing various functionality.
• Designed and Implemented configure to order solution.
• Implementing around 95 models for the Unified Brands, it includes Cooking Equipment’s, Refrigeration, Ventilation/Utility Distribution system, meal delivery system etc.
• Extensively involved in Design and Implementing the configure to order solution, which includes requirement gathering, implementing Oracle Configurator by creating items, Bill of materials(BOM), configurator model, rules, user interface and publishing it to order management.
• Leveraged Configurator CDL property based rules to implement data driven solution which led to reduction in maintenance and new product introduction efforts. Property based rules were used to drive item selections and were also used to drive compatibility between option features. Leveraged logic, numeric, compatibility rules, design charts in order to implement the configurator models
• Oracle pricing setups, configuring and placing Sales Orders from OM, followed WIP process for assembling the parts. Functionality implemented pertaining to Order Management(OM), Adv. Pricing, Inventory.
• Item Pricing updated, modifier & qualifier setups. Order booking by configuring and creating the discrete job.
• Model migrations activity from Test instance to CRPs, UAT and productions instances using the standard model migration functionalities.
• Production support activity- Analysing and Fixing production issues. Also, Educate the configurator processes to the client application engineers; trained them on configurator technically and functionally which includes Item and BOM creation, model migration, configurator rules, UIs generation & publication etc.
• Requirement gathering, solution designing, solution development, unit testing, code reviews, facilitating UAT, facilitating migration of changes, prioritization meetings. 

Confidential, Lafayette, LA

Oracle Apps Analyst

• Implemented Real Item Substitution functionality which lead to considerable reduction in the number of items which get imported into configurator and every change in BOM did not required the model to be published.
• Leveraged Configurator CDL property based rules to implement data driven solution which led to reduction in maintenance and new product introduction efforts. Property based rules were used to drive item selections and were also used to drive compatibility between option features.
• Designed and Implemented configure to order solution for Stones and Rings. It included implementing Oracle Configurator by creating BOM, configurator model, rules, user interface and publishing it to order management.
• Oracle pricing setups, configuring and placing Sales Orders from OM, followed WIP process for assembling the parts & functionality implemented pertaining to Order Management(OM), Adv. Pricing, Inventory.
• Setup documentations, test and production cut over plan for migration activity, client coordination.
• Prepared and implemented the various PIM functionality like bulk item uploads, Change Orders, NIR processes, ICCs, Item imports, use of dependent value sets to control the dependent attributes, the implemented business rules and business events, BOM import export functionality and the use of page personalization.
• Performed the analysis the current PIM issues and suggested the solutions in order to fix the issues; Provided fixes on bulk item upload issues, multiple ICCs and seeded item import functionality implemented and suggested the solution to improve the item export capabilities within PIM.
• Provided fixes and demonstrated the best practices for functionality related to ICC setup, Attribute Group setups, Item page, Add Lifecycle, Create Display, Import format and template Creations and associations to ICC. Style and SKUs items creation and setups for Stuller.

Confidential, San Antonio, TX

Environment: Oracle Apps 12.1.3, Oracle, SQL/PLSQL, UNIX.

• MD50, MD60, MD120 documentations for implementing various PHD functionality.
• Setup PDH configuration, ICC, Attribute Groups, Product Lifecycle and Lifecycle faces, NIR, CO WF processes and documented in BR.100 Applications and MD120 setup Documents.
• ICC setup, Attribute Group setups, People assign to ICC, Item page, Add Lifecycle, Create Display, Import format and template Creations and associations to ICC.
• Built Item Description generation functionality to generate the item description by checking the item uniqueness at ICC level. Wrote the PL/SQL Process to implement the same. Implemented NIR item number generation.
• Generated FNDLOADs ldt files and used Metadata Import Program scripts to load setup data into test & prod environment. Prod migration cut over plan and co-ordination.
• Purchasing, Order Management(OM), functionality implemented, prod support.

Confidential, Lisle, IL

Responsibilities:

• Full life cycle Implementation of Oracle Product Information Management (PIM) module, multiple interfaces have been built to integrate different legacy system.
• Built the interfaces using PL/SQL & Unix for Cross references, Related item, Manufacturing items, BOM (Bill of Material Interface). Built Data conversion processes for bulk item import, ICC structure, people and Role assignment.
• New Item Requests(NIR), Change Order WF Setups, Item-People Role associations and Role assignment and Item interfaces (Item Catalog Categories) structure, attribute groups, UDA setups, BOM Creation. Extensively involved on to streamline PIM standard processes.
• Worked on and used the several oracle EGO APIs to stream line the PIM processes and to build the custom processes using business events to interface and to load the data in PIM. Custom implementations to publish items to other legacy systems.
• Worked as Techno functional on Oracle item Configuration, Bill of Material(BOM), Production support, new product introduction with BOM structures.
• Oracle Configurator by creating BOM, configurator model, rules, user interface and publishing it to order management, New Product Introductions to BOM, Production Support.
• Support, Development, enhancement on Supply chain planning solution which decides the supplies and demands based on that Inventory is managed and Purchase order deployed within an extended supply chain.
• Educate the client to understand the business processes like ASCP PO recommendation, PO creation, PO receipts, supporting planners on ASCP plan recommendations and for generating POs.
• Analysing and Fixing issues for any inconsistencies on demand and supply across ASCP module and PIM item Creation processes etc.
• Performance Improvements for ASCP, Collection process using SQL tuning, SQL Trace, Explain Plan, TkProf, AWR report, Indexing and Hints.
• In order to accommodate client's specific supply chain needs, built customization in Oracle Apps with high scope of scalability. Support and development of ASCP, Purchasing, Order management, PIM & Configurator modules.

Confidential, Danbury, CT

Environment: Oracle Apps- GL, AP, AR, FA, Oracle Forms, Report, Unix, Oracle/PL/SQL, Discoverer.

• Implementation and Support for Oracle apps financials GL, AP, AR, WEB ADI, Discoverer and BO tools for GE Capsol business.
• Planned, Managed and Coordinated for application upgrades, server upgrades and Database upgrade. Planned, designed and developed data migration strategies to integrate GL, AP, AR and FA data into existing businesses and as well as new businesses.
• Developed complex GL JE Interfaces for general entry creations. SQL tuning to enhance the customized PL/SQL programs/Interfaces. Interfaces (Inbound and Outbound) developed using PL/SQL, SQL Loader, shell scripts to interface GL, AP, AR, FA, modules.