SUMMARY

• Around 7 plus years of Oracle ERP Experience in IT including Customizations, Testing and Implementation of Oracle Applications.
• Functional experience in configuration, setup, unit and integration testing of Advanced Pricing, Oracle Order Management, Purchasing, Inventory, customizations on Cycle Count, and Standard Costing solutions designed for meeting gaps in client requirement and application.
• Experience in planning, testing for upgrades, preparation of test plans, test scripts, test cases, training the end users in testing, identification of super users for testing
• Excellent command over functional aspects including implementation, customizations.
• Good knowledge in requirements study, design and development of oracle applications.
• Experience in the preparation of Standard Operating procedures specific to Client's business process with screen prints
• Experience in System Administration tasks related to Menus/Functions, Responsibilities, Users etc.
• Good knowledge on Mobile GUI, WMS Application integrated to Order Management Application
• Preparing Business Requirement Documents (BRD100), design documents (MD050) and Test Scripts.
• Developing extensive functional and analytical capabilities.
• Working knowledge with General Ledger, Accounts Receivable, Accounts Payable, and Fixed Assets in the integration point of view.
• Configuring the application based on solution design, performed gap analysis and designed workaround solutions. Excellent knowledge on Functional Analysis and Implementation, Techno/Functional analysis on Interfaces/Legacy conversions, Views, Reports.
• Expert in Oracle11i E-business implementation of Inventory, Purchasing, iProcurement, Order Management, BOM, WIP.
• Extensively worked on Product Data Hub (PDH) R12 module.
• Excellent business and interpersonal skills, Aggressive Team Player with positive attitude, and Goal Oriented.

TECHNICAL SKILLS

ERP: Oracle Applications R12, 11i (10.7, 11.0.3, 11.5.8, 11.5.9, 11.5.10 and 11.5.10.2) Oracle Applications: Product Data Hub (PDH),Order Management, Mobile GUI, Inventory, Purchasing, Account Receivables, Account Payables, Bill of Materials, Work in Process, iProcurement Languages/Tools: Developer/2000, Forms 4.5, PL/SQL, Oracle, C, C++, Cobol, Visual Basic 4.0, Power Builder Operating System: Windows XP, Windows NT, MS DOS, and UNIX

EDUCATION BS (Bachelors in Engineering)

PROFESSIONAL EXPERIENCE

Confidential, Solon, OH Jul'10 to Present Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.2 in Inventory, Purchasing, Order Management, Shipping, Advanced Pricing, Bill of Materials, Work in Progress, Service Contracts, Account Payables, Accounts Receivables, Costing

Oracle R12 (12.1.2) in Inventory, Purchasing

Confidential designs, develops, manufactures and markets complex electronic instruments and systems geared to the specialized needs of electronics manufacturers for high-performance production testing, process monitoring, product development and research. The Company has approximately 500 products used to source, measure, connect, control or communicate direct current (DC), radio frequency (RF) or optical signals. Product offerings include integrated systems solutions, along with instruments and personal computer (PC) plug-in boards that can be used as system components or stand-alone solutions. The Company's customers are engineers, technicians and scientists in manufacturing, product development and research functions.

Responsibilities:

• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents, Setup Documents (BR100) and other design documents as MD050
• Providing the suggestions/options of the best way to implement their need in Oracle Applications with the SOX approval
• Troubleshooting the production issues on various applications (Work in Progress, Bill of Materials, Purchasing, Inventory, Material Planning, etc), replicating the issues in TEST environment, and testing the fix prior to apply in Production instance.
• Extensively worked on preparing test scenarios, test scripts on different applications to help the users for better understanding the application
• Troubleshooting and fixing the issues on Oracle Standard Costing setups - Copy Item Costs, Month end, Quarter end, Year end processes
• Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization issues
• Created Oracle service requests and fixed the bugs in Oracle Work in Progress application with the help of Oracle support. Tested the fix in TEST instance prior to apply in other instances.
• Trained the super users by providing documents using VISIO flow diagrams for better understanding.
• Extensively worked on Extra compliance screening functionality with the integration of ITM (International Trade Management) Adapters and OTM (Oracle Transportation Management) application
• Prepared the functional design documents to explain the functionality of the custom concurrent programs in Oracle Costing application by analyzing the PL/SQL programs
• Extensively worked on troubleshooting, fixing the issues on Internal requisition, Approved Supplier list, Request for Quotes in Oracle Purchasing
• Troubleshooting and fixing the PO Approval issues, Stuck Purchase Orders from the Workflow utilizing the standard scripts from Oracle
• Worked on Vendor sourcing rules, Blanket Purchase Agreements, Purchase Order Release methods in Oracle Purchasing
• Creating the Training material documents on various applications in Oracle
• Creating Inter-org transfer setups for Inventory application in Oracle R12
• Troubleshooting the order management, invoices, intercompany, WIP transactions, etc issues using SQL statements in Oracle
• Preparing training and knowledge sharing materials on Costing , Item Revisions, View Potential Shortages for the item using Microsoft PowerPoint
• Training the super users by giving demonstrations on various process flows in oracle applications and helping them to understand the process in a better way
• Preparing business requirement, functional design documents and working with the development team to build the custom reports in various applications in Oracle, testing the report and migrating it to the other instances
• Extensively worked with Oracle Metalink on a few SRs (TARs) to fix the issues in Oracle Supply chain management, Financials, Manufacturing areas
• Troubleshooting the issues on Service Contract (on returns, exchanges, repairs) application and providing the fix, solution to resolve the issues
• Troubleshooting the issues on Telesales, CRM applications.
• Gathering the requirement details from the super user and enhancing the Oracle custom report (in PL/SQL) in Bill of Material (BOM) application
• Working on workflow builder 2.6 to modify the PO REAPPROVAL workflow to meet the client requirements

Confidential, Mountain View, CA Jul'08 to Jul'10 Oracle Applications - Functional Consultant

Environment: Oracle Apps Functional Consultant in R12 Product Data Hub (PDH), 11i (11.5.10.2) Advanced Pricing, Order Management, Inventory, Purchasing, Account Payables, Account Receivables, BOM

Confidential is a global leader in providing security, storage and systems management solutions to help businesses and consumers secure and manage their information. Headquartered in Cupertino, Calif., Symantec has operations in more than 40 countries

Scope: Confidential uses Oracle Applications suite (R12, 11i)as the main system for its business along with the other Custom applications/reports. Distribution and Financial modules have been implemented in Symantec, and it's an ongoing project to integrate other business units and new modules to the existing Oracle ERP. The Modules that are widely used include Product Data Hub (PDH), Customer Data Hub (CDH), Advanced Pricing, Order Management, BOM, Inventory, Purchasing, Account Payables, and Account Receivables.

Responsibilities:

• Gathering Business Requirements from business users and preparing Business Requirement, Functional Design, BR100, Test Scripts, Test Scenarios documents.
• Working with Development team to built the functionality for the new requirements and testing in DEV / QA instances before migrating it to UAT and PROD instances
• Understanding / Reproducing / Analyzing / Troubleshooting / Resolving PDH functional issues and helping development team to resolve technical issues
• Understanding and identifying the complexity of new PDH business requirements and proposing the solutions / options to accomplish the requirements as a part of implementing PDH SKU 1.2 project
• Extensively worked on PDH and ERP interfaces as a part of daily activity and troubleshooting / analyzing the issues on those Interfaces
• Creating / Updating / Deleting SKU's, SKU Relationships using spreadsheet tool in PDH, pushing the updates from PDH to ERP by running synchronization programs, and Troubleshooting the Synchronization issues between PDH and ERP
• Working on Flexfields- segments, value sets, values and look up codes in PDH, ERP
• Working on File Upload tool for mass updates on Tax Categories, SKU attribute values, Business Rules.
• Working on Autogen tool to create / update SKU's in PDH, ERP at a batch level and troubleshooting the issues while creating / updating
• Restricting / Granting the access to create / update the SKU at different levels - SKU, SKU attributes, SKU catalog by setting up the rules in setup work bench in PDH
• Working on dynamic Mini tables to create / update the business rules using file upload tool in the customized Oracle form
• Extensively worked on Item Search based on different attribute values by creating our own search criteria.
• Extensively worked on Spreadsheet upload, Multi Item Extract form tools to create / update / delete the SKU for various Inventory Organizations.
• Created SKU (Item) setups for Attribute Groups, Attributes, Catalogs, Item Pages, Display Formats in PDH application
• Worked on Parent and Child SKU (exploded SKU) setups and fixed the issues on Auto-explode linking logic which is being used while creating the SKU's using Autogen Tool in PDH application
• Worked on Item Relationships and actively participated to implement the Relationship enhancements for all type of SKU's in PDH- Provided the functionality to create Item Relationships based on the user configurable rules
• Actively participated on Spreadsheet Upload tool enhancements in PDH - Provided the preview functionality to review the staging data before committing it to the PDH

• Understanding the current business process and troubleshooting the Production issues to find the Root Cause and replacing the issues in TEST instances and testing the resolution / work around to fix the issues in Production
• Worked on gathering the business requirements for the NEW SKU releases and mapping into Oracle 11i, identifying the GAPS and providing the alternatives to minimize the GAPS.
• Preparing business requirement, functional design documents to develop the custom reports in various applications in Oracle
• Troubleshooting the Production issues on Order Management, Advanced Pricing, Inventory modules
• Extensively worked on Price Upload, Item Upload, Autogen process to create / update the Items, Prices in Oracle
• Testing the new functionality, identifying and resolving the issues in Advanced Pricing, Order Management (OM), Inventory (INV), Purchasing (PO) modules
• Providing the Test Scripts, Test Scenarios to the Business to test the business process in Oracle in various modules including Advanced Pricing, OM, INV, PO
• Extensively worked on Change Requests (CR's) and preparing the BRD's, FD's on OM, Advanced Pricing module
• Extensively worked on troubleshooting the issues on Custom Concurrent Programs in Oracle, providing the workaround and finding the Root Cause of the issues.
• Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances
• Analyzing the issues using TOAD, providing the workaround to fix the issues, testing the workaround in TEST instances and providing the updates to Business.
• Extensively worked on Price Lists, Modifiers, Qualifiers, Pricing Attributes in Advanced Pricing and created the setups in TEST instance
• Monitoring the help requests created by the Business in AdvenNet software and helping them in resolving the issues.
• Troubleshooting the issues while updating / creating the Prices, Items in Oracle using Price Upload, Item Upload, Autogen.
• Worked extensively on Item categories, Category sets, Category codes and prepared the setups for Item categories in Inventory, Purchasing, Order Management modules
• Worked on creating the Licenses, Certificates for the various SKU's in Order Management, Inventory Application
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
• Extensively worked on different Inventory transactions and solved the period end issues
• Worked on the different Purchase Order setups, generated the invoices, and resolved the pending transactions
• Worked on RMA Process, importing EDI orders, and Credit Memo process in Order Management, Account Receivables Application
• Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
• Created category sets, category codes, default category sets for the various items in Inventory application
• Troubleshooting the technical issues and preparing analysis on the issues in Oracle applications
• Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management

Support Activities:

• Perform Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Implement various improvised processes to prevent user errors and stabilizing the system.
• Implement major modifications in the application with focus on making the system more user friendly and ease in extracting the required data from Oracle.
• Work on major upgrades of database and application that included testing of major upgrades and releases.
• Co-ordinate with Oracle Support for resolution of TAR's- Worked with Oracle to resolve the issue on maximum number of attributes within the multi level row attribute group, and the mini table setup issues
• Serves as part of the Transition Project that successfully enabled the Team to start within the specified timeframe
• Responsible for training of end-users and provided the aggressive support to resolve the UAT, Production issues

Confidential, Duluth, GA Mar'08 to Jun'08 Oracle Applications - Functional Consultant Oracle Applications production support in Inventory, Purchasing, and Order Management, BOM, WIP, Account Payables, Account Receivables, Mobile GUI, WMS in 11i environment

Environment: Oracle Apps 11.5.10.2

Confidential, is a division of vast manufacturing and distribution network of Euramax International, Inc., a leading international producer of value-added aluminum, steel, vinyl, fiberglass products and it is based in Norcross, Georgia, and other various locations. It consisting of 41 strategically facilities, 35 of which are located in the United States and 6 in Europe.

Responsibilities:

• Understanding the clients business and taking care of the business users help requests on Oracle Apps using AdvenNet software
• Extensively worked and resolved the issues on OM, Shipping Execution, INV, PO, BOM, WIP, Mobile GUI, AP and AR Applications
• Monitoring the business users screen to understand the issues and fixing it by guiding them to complete the process in a right way
• Analyzing the issues and finding out the root cause of the problem to get a permanent fix for the issues in various applications
• Replacing the critical issues in Test instances to fix the problem in PROD instance
• Resolving the issues on Pending Transactions from various applications
• Resolving the month end issues and prepared a setup document for Month-end closing
• Worked on Mobile GUI Application for Receiving, Picking, Packing, Dropping, and Unpacking the items
• Resolving Physical Inventory and Cycle Count issues in Inventory Application
• Worked and resolved the issues on Drop Shipment, Internal Sales Order in Order Management application
• Resolved the issues on Sub inventory transfer, Inter-Org transfer in Inventory Application
• Extensively worked and resolved the issues on Work Flows (Requisition, Purchase Order, RMA Order, Standard Sales Order, Internal Sales Order, Drop Ship Order)
• Worked on Modifiers, Qualifiers, Price List setups to define the discount (or) surplus charges at various levels in OM application
• Resolved the critical issues on Shipping Execution while Ship Confirming the Sales Order.
• Worked and fixed the root cause problems in BOM, WIP Applications
• Worked on workflow notifications and re-routing the notifications to other employees based on the super user requests
• Resolved the issues while importing the EDI orders to OM Application
• Worked extensively on Over (or) Under Shipment tolerances and corrected the setups to populate those values as needed in Order Management module
• Worked on Processing Constraints, Validation Templates, Record Sets and corrected the setups according to the business needs in Order Management module with the SOX approval
• Worked on Shipping Tolerances at Customer level in Order Management Application
• Worked with client in suggesting & developing position hierarchy for organization in Purchasing module
• Good Knowledge on Blanket Purchase Agreement and Releases in Purchasing Application
• Worked extensively on Item categories, Category sets, Category codes and resolved the issues on Item categories for the reports in Inventory and Purchasing modules
• Troubleshooting and clearing the PO Approval issues, Stuck POs from the Workflow utilizing the standard scripts from Oracle.
• Working with different teams to resolve the issues for the assigned sites. Research the issues on Metalink and Open the TAR with Oracle for critical issues and following up with Oracle support regarding bugs and patches
• Resolved the issues on Taxes, Freight charges for the customers in Order Management Application

Confidential, Santa Clara, CA Oct'07 to Mar'08 Oracle Applications - Functional Consultant Implementing Oracle Applications in Inventory, Purchasing, and Order Management in 11i environment Environment: Oracle Apps 11.5.10.2

Confidential designs and markets high-performance semiconductor image sensors. Its OmniPixel and Camera Chip products are highly integrated single-chip CMOS image sensors for mass-market consumer and commercial applications such as mobile phones, digital still cameras, security and surveillance systems, interactive video games, PCs and automotive imaging systems.

Understanding the client's business process and gathering the Business Requirements from the business users to map into Oracle Applications.

• Participated in CRPII to explain the business process flow in Oracle according to OVT business needs.
• Conduct the GAP analysis and prepared Business Requirement Documents (BRD100) and MD050's, MD070's with the SOX approval
• Worked extensively on Unit Testing, and System Integrated Testing
• Prepared User Training Manuals in INV, PO, and OM applications and trained the super users
• Worked extensively on Inter Company transactions, Inter Organization transactions in Inventory application.
• Creating functional design documents to build the new Oracle custom reports and testing the developed reports before migrating it to the other instances
• Created various order types with the approval hierarchy in Order Management (OM) module
• Worked on Quote Management in OM including creation of versions for the Quotes
• Worked extensively on Return Material Authorization (RMA) transactions in Order Management.
• Created Purchasing Hierarchies, Approval Limits, Approval Assignments for the various positions in Purchasing application
• Worked on Internal Requisitions, Internal Sales Orders, and Drop Shipment process in Purchasing, Order Management applications.
• Created Inter Company price list for Inter Company transactions in Order Management and Inventory application
• Extensively worked on Modifiers, Qualifiers to create a price list for various items in Order Management module.
• Created setups to import Freight Costs entered at shipping into Account Receivables module
• Created setups for Physical Inventory in Inventory Application
• Setting up user defined transaction types for inventory transactions pertaining to the issues done to the various cost centers from Stores. Custom Pll was developed to restrict the Transaction Types LOV based on the Inventory Organization in which the transaction is being performed
• Created Shipping Networks between the organizations for Inter Organization and Internal Requisition setups
• Extensively worked on Multi Currency conversion setup in Purchasing and Order Management Applications
• Setting up of buyer less procurement process for frequently procured items through the internal catalog for iProcurement requisitions. Set up of ASL's for iProcurement-requisitioned items with release generation method "Release using Create" enabling auto generation of Blanket Releases, Standard Purchase Orders against the Blanket Agreements and Catalog Quotations
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations.
• Created category sets, category codes, default category sets for the various items in Inventory application
• Performing regression testing during upgrades.
• Responding to functional assistance tickets from the super users, problem analysis and resolution

Confidential, Solon, OH Sep'07 to Oct'07 Oracle Applications - Functional Consultant

Environment: Oracle Apps 11.5.10.2 Implementing and support in Oracle Applications in Purchasing, Inventory, Order Management, Advanced pricing, Shipping Execution in 11i environment

Responsibilities:

• Understanding the client's business process and mapping into Oracle Applications accordingly
• Identifying the functional specs, preparing the documentation setups and maintaining Business Requirement Documents (BRD100) and other design documents as MD050 with the SOX approval
• Providing the suggestions/options of the best way to implement their need in Oracle Applications
• Creating Item Templates in Oracle Inventory module by modifying the control level options
• Extensively worked on Item Attribute Controls and created different inventory items Oracle Inventory Applications.
• Creating the shipping networks and Inter-Organization transfer between two child Inventory Organizations in Inventory module
• Defining and maintaining ABC classification of items for cycle counting procedures and maintained physical inventory procedures for inventory and sub-inventory locations in Inventory application
• Creating Job, Position, and Position Hierarchy in Oracle Purchasing Module
• Setting up Buyer, Approval Groups, and Approval Assignments in Oracle Purchasing Application.
• Trained and assisted the super users in testing.
• Setting up Group by option as "Vendor" to pick up the requisition lines through scheduled "Create Releases" program before the end of the day to optimize the Purchase Order costs. (Reduced number of Purchase Orders creation)
• Working on serial controlled items and item reservations against the sales orders based on the scheduled ship date in Order Management
• Setting up of ASL, Sourcing Rules, and Assignment Set for Inventory Min Max Planned Items with release generation method "Automatic Release" for auto generation of Blanket Releases and Standard Purchase Orders.
• Working extensively on Advanced Pricing setups in Oracle Order Management - Defining Pricing Formula, Price Lists, and Modifiers - Manual Discount, Manual Surcharge, Freight, Freight Charges
• Setting up Pricing Attributes, and Pricing Contexts in Advanced Pricing.
• Creating Multi-Currency conversion setups in Advanced Pricing for various items.
• Creating the setups for Drop Shipment, Internal Sales Order and resolving those issues in Order Management.
• Creating Shipping Parameters, Picking Rules, and Release Sequence rules for a new child inventory organization.
• Generating the invoice against the sales order in Account Receivables module
• Setting up processing constraints to restrict the users to cancel the sales orders at different stages.
• Working with business users to resolve all the issues in Oracle Applications. Resarch the issues on Metalink and Open the SR with Oracle for critical issues.
• Setting up the appropriate Price List in Order Management Application for various inventory items
• Demonstrating the configuration setups for the new child inventory organization, Item attributes, and the item templates.
• Working with the super users to resolve all issues for the assigned sites. Research the issues on Metalink and Open the TAR with Oracle for critical issues.

Confidential, Scottsdale, AZ Apr'07 to Aug'07 Oracle Applications - Functional Consultant

Implementing Oracle Applications in Purchasing, Order Management, iProcurement in 11i environment Environment: Oracle Apps 11.5.10

Confidential provides the large number of Real estate and Re-locationservicesto the customers and is dedicated to offering quality service to homebuyers and sellers throughout the North America along with the global mobility of the re-location services.

Responsibilities:

• Mainly responsible for mapping the client's business process in the modules of Oracle Purchasing, and Order Management.
• Responsible for doing the gap analysis based on the customer's requirement.
• Responsible for the setups for purchasing (PO), Order Management (OM), Bill of Materials (BOM) with the SOX approval
• Defining Positions, Position Hierarchy, Approval Groups, Approval Assignments, and Document Types in purchasing module.
• Was responsible for the setup of items, defining cost types and assigning cost to the items
• Setting up the setups forContract Purchase Orders for Multi Function Printers
• Setting up Item templates, Item attributes, UOM and UOM classes
• Setting up of Approved Supplier List, Assignment Set, and Sourcing Rules for the service Items with release generation method "Automatic Release" for auto generation of Blanket Releases and Standard Purchase Orders.
• Setting up Group by option as "Vendor" to pick up the requisition lines through scheduled "Create Releases" program before the end of the day to optimize the Purchase Order costs. (Reduced number of Purchase Orders creation)
• Worked with client in suggesting & developing position hierarchy for organization.
• Defining and maintaining receiving options, control options, Payment terms, Purchasing locations, buyers, approval groups, approval assignments.
• Developing business relationships and integrating activities with other IT colleagues, primarily developers to ensure successful implementation and support of projects.
• Coordinating with Oracle Support on various TAR's on daily basis through Metalink.
• Analyzing the PO Approval issues and clearing the Stuck POs from the Workflow utilizing the standard scripts from Oracle.
• Enabling descriptive Flexfields and key Flexfield segments on some forms in Oracle Purchasing Application.
• Defining the Purchasing, Receiving and Financials Options as part of the setup
• Setting up the Drop Shipment and Internal Orders for some of the service items in the Oracle Order Management module
• Creating the option classes in the Bill of Materials Application for the service items selection in the Order Management (OM).
• Restricting the Desk Top receiving for iProcurement requisition (expense) items by User Departments. All items are received at Stores and then issued to User Departments outside the system.
• Setting up REALMS to restrict access to items based on the item category to users based on the business requirements
• Setting up shipping networks to enable Inter Organization Transfers
• Documents (MD60) for the new requirements
• Coordinated with business users and IT, in developing new solutions based on gap analysis
• Extensively worked with the development team to build the Oracle custom forms in various applications and testing the functionality before migrating it to the other instances
• Preparing Test Cases for the new functional requirements
• Preparing process mapping, GAP, User Training Documents.
• Testing of the migrated changes in QA Instance and giving sign-off to move production.
• Developing business relationships and integrating activities with other IT colleagues, primarily developers to ensure successful implementation and support of projects.
• Working with different teams to resolve all issues for the assigned sites. Research the issues on Metalink and Open the TAR with Oracle for critical issues.
• Coordinate with Oracle Support on various TAR's on daily basis through Metalink.

Confidential, Gardena, CA Jan'05 to Mar'07 Oracle Applications - Functional Consultant Implementing Oracle Applications in Purchasing, Inventory, Order Management, in 11i environment

Responsibilities:

• Understanding the existing processes and carrying out requirement analysis for Order management flow. Project deliverables included - understanding business requirements, mapping them to Oracle Applications functionality, demonstrating and recommending relevant Applications Fit, supporting Testing cycles etc.,
• Identified the functional specs, Preparing the documentation setups and maintaining Business Requirement Documents (BRD100) and other design documents as MD050
• Functional Testing after development of the RfCs (Request for Change)
• Setting up of position hierarchy, Approval groups, Approval Assignments, Approved Supplier List in Oracle Purchasing Application
• Extensively work done on RFQ's, and Quotes in Oracle Purchasing
• Setting up Work Flow Attributes in Oracle Purchasing Application
• Mapped complex outbound logistics requirement on Order Management.
• Setting up Pricelists, Qualifiers, and Modifiers and defining pricing attribute contexts to setup formulae.
• Performed the setups for Drop Shipment, Internal Sales Order and resolving those issues.
• Trained and assisted the super users in testing.
• Logging of TARs and liaison with Oracle support for resolution.
• Worked heavily on Item master, enabling additional attributes in item, categories, Item catalogs
• Worked in Various Inventory Planning Methods for Safety stock levels.
• Extensively worked on physical inventory and cycle count setups to indicate to MRP in OPM application.
• Created Item Categories for the various reporting and Business purposes.
• Developed the auto-invoice setup functionality of transaction type, transaction source, line transaction flexfield, line order rule and grouping rules.
• Developed the procedures for establishing the costs for various items in OPM applications
• Extensive work done on Advanced Pricing and Pricing Attributes Linking and Mapping
• Credit Limit control of Customer and Credit sharing with Customer Relation ship
• Did Customization on Sales order Form which Triggers the Print Sales Order Report for the booked orders
• Design and implement Oracle Proposal template and components, which include cover letter, quote details, quote summary with categories (such as hardware, software, training, documentation and discount), product details, installation notes and terms and conditions. Setup email functionality to send proposal package to customers
• Set ups for freight and special charge types and converting actual costs into charges based on the defined terms and rules in Order Management application.
• Successfully implemented Order Management (Stock and sale, Drop Shipments and Internal Orders) using workflow and Shipping (Trip and Contained Management).
• Creation of Multi level Standard Bills with alternative routing & Substitute components
• Creation of WIP Job Routing / Job Costing & configuring outside processing process.
• Production Support Analyzing and resolving implementation issues. Month end activities.
• Responsible for Defining and Assign Shop floor activities
• Configure Customers Online. Import customers from legacy (external) system with validations. Identify duplicates and merging of parties/customer accounts.
• Consolidate organizations and inventory activities to limit the number of transactions and complexity of the processes.
• Consolidate and implement one master price list with qualifiers, formulas handling special price and discounts and multi-currency conversion.
• Calculate freight charges based on item physical attributes (weight/dimension) using tan data ADSI server control console and print the label based on container details that items goes into one package.
• Set up value sets, key flex fields, descriptive flex fields, concurrent program, printers, function, menus, responsibility, users
• Set up modifier for price adjustments, freight and special charges, discounts and surcharges. Ship confirms workflow notification requires sales manager to approve before invoice lines can be invoiced. Enhance functionality of order management using custom library without modifying the standard code
• Design an interface by providing link from Customer Care to inquiry management, call logging and messaging, email center, web callback and web-chat
• Responding to functional assistance tickets from the business users, problem analysis and resolution
• Analyzing and troubleshooting of Agile and Oracle interfaces for New Product Introduction

Confidential, Hyderabad, India Feb'03 to Nov'04 Oracle Apps Functional Analyst Environment: Oracle Apps 11.0/11i, Inventory and purchasing modules

Responsibilities:

• Understanding and gathering the business requirements of the Organization
• Identifying the gaps between existing solution against the new gathered requirements
• Preparing Business Requirement Documents (BRD100) and Functional Design Documents (MD60) for the new requirements
• Coordinated with business users and IT, in developing new solutions based on gap analysis
• Preparing Test Cases for the new functional requirements
• Preparing process mapping, GAP, User Training Documents.
• Testing of the migrated changes in QA Instance and giving sign-off to move production.
• Developing business relationships and integrating activities with other IT colleagues, primarily developers to ensure successful implementation and support of projects.
• Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues.
• Coordinate with Oracle Support on various TAR's on daily basis through Metalink.