Preview only show first 10 pages with watermark. For full document please download

Oracle Apps Functional | Oracle Database | Business Process

design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities. Experience with Oracle Business Accelerators for e-Business Suite Release 12. Experienced in working with Oracle Applications Release 12 Possess strong knowledge of ...

   EMBED

  • Rating

  • Date

    January 2018
  • Size

    174.7KB
  • Views

    5,271
  • Categories


Share

Transcript

Extensive Experience in all life cycle stages of implementation including Requirement Gathering, Solution design, GAP analysis, Custom development, System configuration, Test Plan Cycle, CRP, UAT, Cut-Over and Project Coordination activities.  Experience with Oracle Business Accelerators for e-Business Suite Release 12.  Experienced in working with Oracle Applications Release 12  Possess strong knowledge of Supply Chain Management modules of Oracle applications, with concentration on Quoting, OM, PO, INV, WIP,BOM, AP, AR, PDH combined with a unique combination of their integration with other modules like Advanced Pricing, Shipping and i-Procurement.  Extensive experience with the Order to Cash and Procure to pay business flows.  Formulated solution design and implementation strategy based on client requirements.  Configured the application based on solution design, performed gap analysis and designed workaround solutions.  Trained the clients’ super users on the application and conducted pilot testing, integrated testing.  Design validation & Setups of OM, INV, PO, AR, AP, PDH and Shipping modules.  Strong Exposure in preparation of high-level functional design documents for Custom application development, Conversions, Interfaces & Reports.  Experience in preparing Requirement Analysis Documentation, Training scripts, Functional Documentation, User Training Documents and Customization Documents.  Knowledge of SQL, relational database query tools (e.g. TOAD). TECHNICAL EXPERTISE ERP Oracle ERP RDBMS Programming Languages Development Tools Methodologies Operating Systems Oracle Applications E-Business suite (EBS) 11i -R12 (INV, BOM, WIP, OM, AR, AP, PO, SHP, AOL, PDH etc) Versions 11.5.10/R12 Oracle 10g/9i SQL, PL/SQL SQL navigator/TOAD Application Implementation Methodology (AIM) Windows XP/NT/2000/Unix PROFESSIONAL EXPERIENCE NCH Corporation (World Headquarters), Irving, TX Oracle Functional – Supply Chain and PDH Consultant July 2012 - Present NCH Corporation is a major international marketer of maintenance products, and one of the largest companies in the world to sell such products through direct marketing. NCH's products include specialty chemicals, fasteners, welding supplies, pet products, and plumbing parts. Responsibilities:  NCH has upgraded to Release 12.1.3 and was rolling it out to their UK and Europe locations. Worked on implementation and rollout of e-Business suite Release 12.0.3 of OM, PO, INV, Shipping, PDH/PIM modules.  Performed AS IS Analysis for the 11.5.10 setup and Identified GAPs with R 12.1.3  Provided detailed understanding to the users on change points and impact of moving to a Multi-Org environment through extended key user sessions  Involved in dealing with all the stakeholders on the project to gather requirements, firm up the requirements and then get the signed off by the stakeholders for each functional track.  Involved in designing the Project Plan for the individual modules  Involved in developing the Process flows for the Quote to Cash and Procure to Report modules.  Involved in the Functional Analysis of designing and developing a custom licensing module called elicensing, which was primary designed to provide license keys for products sold and tie back to Install Base.  Purchasing – Worked on the configuration of the Purchasing module including the setups of the Approval hierarchies, Purchasing Options, Setting up Matching, etc.  Integration of PIM/PDH (Product Information Management) with Inventory.            Defining Item Catalog Categories, attribute groups, attributes, item templates, roles, security and groups in PIM. Interface Items from Legacy system to PIM via WEB ADI. Designed a Streamlined process for Fulfillment flow. Conducted several sessions with key users to analyze business requirements and performed fit-gap analysis to map user requirements using AIM methodology Responsible for developing and maintaining documentation like BR-100, CV-40, test scripts and results Worked on designing the power point presentations for the business requirements and solutions for the GAPs that were identified. Worked with Oracle support for Oracle functionality issues by raising Service Requests. Was involved in developing Use Cases for testing of the Quote to Cash business process Was involved in designing the communication plan for any changes that were made to the system, any changed that were made to any of the functional processes. Designed and Developed the Test Plan for testing of the System as wells as testing of the entire bolt on modules and custom RICE components. Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications. Environment: Oracle applications R12 (Technology: Quoting, OM, Oracle Inventory, Purchasing), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD United States Steel, Pittsburg, PA Aug 2011 – July 2012 Oracle Functional – SCM (Order to Cash and Procure to Pay) U. S. Steel Tubular Products manufactures quality tubular products for the energy industry as well as a number of other specialized end-use applications. Major product lines include oil country tubing, casing and drill pipe, standard and line pipe, and coupling stock. Responsibilities:  Setting up of complete Order to Cash cycle setups.  Authored and executed test plans to ensure successful implementation. Actively involved with Unit testing, QA, Integration and Regression testing, and UAT.  Resolved/debugged various issues during process mapping, development, unit testing, UAT and postproduction support.  Liaison with Oracle support, helpdesk, business process owners, developers and major stakeholders. Facilitated communication between the business unit and IT from initial requirements definition to final implementation.  Part of S&M team & assisted the business for understanding the new Dual Build / Dual Pickup process flow in the business transformation phase  Performed setups for drop shipment process & split shipments related to Dual Build / Dual Pickup points for both US & Canada mfg unit in Order Management.  Worked on the configuration of Setting up of Price Lists, Modifiers, Qualifiers, Extended Attributes, Dynamic as well as Static formulas for pricing  Worked on catalog setup and management in i-procurement  Performed master data sets for Procurement including approved supplier list, sourcing rule, custom BPO conversion for production cutover activity Define Supplier & Item Combination, Sourcing Rule, Approved Supplier List  Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization  Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases  Configured Auto-Sourcing rules, Approved Supplier List (ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench  Developed solution to manage Inventory using ‘Inspection’ as receipt routing for Items routed through Quality department and established ‘Return to Vendor’ process  Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type     Established an Item Category and Item Cataloging for their products. Defined a ABC Analysis and Cycle Count Established Customer Item and Customer Item Cross Reference Established a process for smooth month end closing procedure in Inventory Environment: Oracle applications R12 (Technology: Quoting, OM, Shipping, Oracle Inventory, Costing, Purchasing), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD Qualcomm, Inc, San Diego, CA Oracle Manufacturing Functional Consultant July 2010 – July 2011 Responsibilities:  As a Functional Consultant implemented Inventory, Cost Management, Bills of Material, Work in Process of Release 12 of Oracle e-Business Suite.  Performed all the setups of Inventory, Cost Management, Bills of Material, and Work in Process including setting up of the expense-reporting template.  Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.  Setup up 80 inventory organization with average costing method in cost management. Setup transactions, item master, unit of measures, sub inventory, Inventory calendar, shipping network and hierarchy.  Work in process - Discrete manufacturing setup, accounting classes, workstation setup.  Setup more than 60 bills of material and routing, more than 50 alternate bills of material and routing. Determined supply item supplies depending upon different  Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.  Worked on the integration of Inventory with PO and also worked on the functional specifications for customizations to Inventory module.  Provide production support for users after implementation and fixing all issues related to setup. Environment: Oracle applications R12 (Technology: Oracle Inventory, BOM, WIP, PO) Oracle database 10.g, SQL, PL/SQL, TOAD Carnival Cruise Lines, Miami, FL Sept 2009 - June 2010 Oracle Apps Functional Consultant - Oracle Procure to Pay The Miami and London-based Carnival Cruise Line is the flagship brand of Carnival Corp., one of the largest vacation/travel conglomerates in the world. On release 12.1.3 version of oracle applications, Carnival worked on changing an existing mapped requisition system to i-procurement requisition system for the Carnival Casino Division on the ships. I was a functional resource on the Procure to Pay Track. The modules were Purchasing and i-procurement. Responsibilities  Requirements gathering from end users, Requirement analysis.  Worked on the entire Procure to Pay business process.  Performed all of the setups required for i-Procurement, PO.  Developed several enhancements to the Business Processes on the Procure to Pay side.  I procurement: Define system profile options. Extract catalog and item data. Setup of Sourcing Rules and Sourcing rules assignment using Blanket Purchase Orders.  Coordinated all rounds of CRP and SIT testing with the business users.  Supervised and helped business users in UAT (User Acceptance Test) testing.  Support Production issues on a day to day basis including month end closure p1 issues  Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Categories, Document Sequence Assignment, Profile Options.  Preparing the BR030, BR100, To-Be Document.     Prepared MD050 functional design document. Prepared the test script documents TE040, TE050 & TE130 for SIT & UAT testing. Prepared i-procurement training manual for the Ship users and the Casino Managers. Performed Framework Personalization setups. Environment: Oracle applications R12 (Technology: Oracle Inventory, BOM, WIP, PO) Oracle database 10.g, SQL, PL/SQL, TOAD APC by Schneider Electric, Bangalore, India Apr 2008- Aug 2009 Oracle Functional Consultant – Supply Chain APC is a leading manufacturer of uninterruptible power supplies (UPS) and surge protection products for endto-end legendary Reliability, providing protection against data loss. Their business also includes Maintenance of Data centers, power conditioning equipment, power management software, and DC power systems as well as precision cooling equipment, and professional and consulting services for Nonstop Networking™. Responsibilities:  Involved in the upgrade of the oracle applications from 11.5.10 to R12.0.1 using AIM project management methodology.  Requirements gathering and analysis  Revising existing business process for better efficiency and optimization.  Mapped and validated the business processes between legacy system and Oracle applications.  Providing solution design for customizations.  Validated Setup steps for Inventory like Inventory Organizations, Source Types, Item Templates, Category Sets, UOM, Classes and Conversions.  Setup the item categories, category sets, item attribute controls and item template and catalog groups.  Assisted the project team and end-users in the functional configuration of Order to Cash Life Cycle.  Setup item Costs types, Lead time Rollup, Cost rollup using Resource and Material Overheads.  Involved in a feasibility analysis of integrating Oracle and Legacy System.  Analyzed the need for sub inventories, revised stock locators and locations and setup shipping networks for Inter-org transfer.  Responsibilities included testing the existing standard functionality and custom enhancements.  Understand all the requirements and prepare test plans and test cases.  Involved in testing of end-to-end scenarios and application-to-application scenarios  Provided Post-Live support and help resolve any user issues and requirements.  Provided production support as and when issues occurred.  Running daily maintenance checks on the production instance.  Maintaining price lists, set-up pricing attributes, creating pricing qualifier groups, price modifiers, pricing agreements etc.  Setting up pricing attributes and defining price lists. Environment: Oracle Apps 11.5.10 (INV, BOM, WIP, OM, PO) Leading Edge System Computers, Bangalore, India Functional Consultant Feb 2007- March 2008 Worked as a Functional consultant for the implementation of Oracle Inventory and Purchasing Responsibilities  Procure-to-pay process analysis  Prepare functional specifications  Involved in Inventory, Purchasing system configuration  Create Requisition Templates, Approval Groups and Assignments, and Catalogs  Prepared setup documentation  Involved in unit and integration testing  Worked with users on production issues and provided application training  Worked on issues with Oracle Support Environment: Oracle Apps 11.5.8(INV, PO) Featherlite Office Systems, Bangalore, India Aug 2005 – Jan 2007 Oracle Functional – Supply Chain Featherlite expertise in manufacturing innovative and customized office furniture such as modular work stations, chairs, partitions, desks conference tables educational, lab & retail furniture and fixtures etc. Responsibilities:  Conducted Business Process Analysis for Oracle Inventory, BOM, WIP modules through discussions with Process Owner and Champion Users  To understand the Current business flows as a part of the As -Is study and freezing of TO-BE processes  Functional Analysis and design to map the new business process to Oracle Applications and Custom Functionalities  Prepared RD20 document based on business requirements gathered from the client.  Involved in Period end closing Activities.  GO-Live and Post GO-Live Support. Inventory  Key setups like Flex fields, Organization, Inventory Parameters, UOM, Sub inventory, stock locator, Item Attribute control, Item Template and Transaction Type  Item Master setup and interfaces between Lotus notes database and Oracle ERP.  Established an Item Category and Item Cataloging for their products.  Defined a ABC Analysis and Cycle Count  Established Customer Item and Customer Item Cross Reference  Established a process for smooth month end closing procedure in Inventory  Designed and implemented Item Status, Item Attribute Control, Item DFF, Item templates, Serial Control, Sub inventory, Locators, Planners, Min-max planning, Cycle Counting, Item Attachments, Shipping Network, UOM Conversion, BOM Parameters, PTO Bills of materials and Manufacturing Calendar.  Major activities included setting up Inventory Organization, Sub inventory, Item locators, Network Routing, Resource, Resource Cost, Cost Elements, Department Resources, Department Class, Departments, Standard Operations, Operation Resources, resource Shifts,  Lotus Notes Database Integration to Oracle ERP for Item Master Data and Pricing Information.  Item category configuration in Oracle Inventory. Purchasing  Established Purchase Requisition process and Approval hierarchy to manage non-production (Indirect) Items purchases in the Organization  Developed solution to manage Stock Items and recurring non-stock purchases using Blanket Purchase Agreement (BPA) and Blanket Releases  Configured Auto-Sourcing rules, Approved Supplier List(ASL) and BPA to enable Buyers to release purchase orders automatically from Planners Workbench  Developed solution to manage Inventory using 'Inspection' as receipt routing for Items routed through Quality department and established 'Return to Vendor' process Order Management  Implemented integration for service orders from Siebel to Oracle 11i.  Available to Promise(ATP) and Auto-Scheduling functionality configuration reduced the Scheduling process time and enhanced customer service level  Drop ship Functionality was setup to enable the OM team to ship the goods directly to Customers from Supplier warehouse.  Internal Sales Order/Internal Requisition process was configured to establish a simplified Intercompany sales across operating Units  RMA and Approval Management functionality setup reduced the process time in Customer Returns management Environment: Oracle Apps 11.5.8 (INV, OM, PO, AR, AP) Featherlite Office Systems Pvt Ltd (ISO 9001-2008, 14001-2004 EMS & OHSAS 18001-2007) Certified Position: Department Head (Carpentry, Upholstery, Assembly) June 2001 – July 2005 Featherlite is the prestigious high tech Modular Furniture and Office System Manufacturing Company with huge clients like Oracle, Dell, IBM, Hyundai, Value labs, RMZ, Fiat, Reliance, ICICI, TCS, NOKIA, and many more. A result oriented professional with over 4+ years of experience in Project Implementation, Execution, Operations & production in Modular Furniture and Office System Manufacturing Industry. Specialization is Panel and Tile system, Fabrication, Upholstery and Assembly My Pivotal Role:  Manual processing to automated enhanced production.  Designing R&D Methods based on Customer drawing & Requirements.  Processes synchronization by detailed time - study & planned manpower.  Preventive / breakdown maintenance introduced: o Process Training, Charts, Displays, Checklists, Flowcharts introduced. o Frequent Customer interaction to collect Product feedback & Customer satisfaction. o Immediate Troubleshooting to any problem occurring at the Customer end, on Spot.  Customer co-ordination in their field, during new product Developments.  Facilitates continual improvement intervention and employee involvement teams throughout the organization.(Kaizen ) Associate to encourage 5s and kaizen activities and implement.  Acquired Certificates by TUV NORD & AIM ENVIROMENT          ISO 9001:2008 (Quality Management System) certified as an Internal Auditor & Implementation core team member. ISO 14001:2004 (Environmental Management System) certified as an Internal Auditor & Implementation core team member. BS18001:2007 (Occupational Health and Safety Standards) certified as an Internal Auditor & Implementation core team member. BIFMA (Business and Institutional Furniture Manufacturers Association) certified as an Internal Auditor & Implementation core team member. Certified member in Fire Prevention and Fire Fighting by Crisis Management Pvt Ltd. Certified member in First Aid by Saint John Ambulance.(India) Poka-Yoke and Khaizen training from Essae Chandran Institute. Training on Leadership qualities conducted by CII (Confederation of Indian Industry). 5’S Activities training from Essae Chandran Institute.