Experience Summary

• 8+ Years of experience in analysis, design, testing and implementation of Oracle projects
• Experience in doing Fit/Gap analysis, design, system setup, configuration, testing and implementation, documentation, training and production support of complex applications.
• Worked extensively in Oracle Applications modules INV, BOM, WIP, WMS, Costing, PO, AME, OM, AR and AP.
• Primarily Functional expertise in Oracle Manufacturing and Distribution modules like Oracle Inventory (INV), Bill of Materials (BOM), Work in process (WIP), Engineering (ENG), Material requirement planning (MRP), Purchasing (PO), iProcurement, Advanced Pricing, Order Management (OM), Pricing , Costing modules .
• Secondary skills on AP, AR, PL/SQL.
• Expertise in Order-to-Cash cycle and Procure-to-Pay cycle. .
• Did multiple full cycle end to end implementations, Upgrade and support projects of Oracle E-Business Suite Applications 11.5.10, R12.0.4, 12.1.1 and 12.1.3 .
• Experience in preparing Configuration and Design documents, Process documents, training material, Test scripts and conducting trainings and client presentations.
• Expertise in SYSADMIN and Oracle Applications activities like managing concurrent managers, application user setup, defining responsibilities, value sets, flexfield, registering menus, concurrent programs, providing support to apps users for any functional issues.
• Managed all technical and financial aspects of the annual budget process, providing analytical support, budget data and other financial data for month-end closing.
• Strong documentation, analysis, requirement skills and good interpersonal and communication skills to work with clients and team members.
• Engaged in multiple business development activities with various clients of Oracle consulting.
• Co-ordinate with Onsite/Offshore Functional and technical teams.
• Good exposure on Oracle Applications Implementation Methodology (AIM).
• Experience in conducting Oracle Apps trainings to various levels of people in the organization.
• Ability to work with SQL query tools such as SQL* Plus, Toad.
• Proficient in working with Oracle Service Requests(TAR)
• Skills in Single-Org to Multi-Org implementation of Oracle E-Business Suite.
• Excellent oral and written communication skills and client interaction.

Technical Skills

Packages : Oracle E-Business Suite Discrete Manufacturing Applications 11i and R12.
Module : Oracle Inventory, Oracle Purchasing, Order Management, Oracle Bill of Materials, Oracle Work in Process, Shipping, Advance pricing, AR, AP and GL etc.
Tools : Toad, Data Loader, PL/SQL, Oracle reports, Oracle Forms and Discoverer
Design : AIM

Education

• Masters of Computer Engineering .

Technical Training

• Oracle Inventory, Oracle Bill of Materials.
• Oracle Work in Process.
• Oracle Purchasing
• R12 Order management and Shipping modules training
• R12: Oracle Inventory Management Functional. Overview.

Professional Experience

Confidential, (June’11-Till Date)
Client : Confidential,Southaven, MS
Duration : Currently Working
Role : Oracle Functional Consultant

Team Lead for WMS module.

• Created BR-100 and BR-030 documents for WMS.
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules and all WMS set ups.
• Worked on customizations in WMS.
• Created new functional design documents (MD.050), Business Requirement Documents for the enhancements.
• Identified Test Scenarios and developed Unit Test case documents.
• Performed Demo about Oracle WMS to the business users.
• Worked on designing new label formats (LPN labels and Material labels).
• Integrated Mobile scan guns with oracle using Telnet.
• Provided WMS solution to the business which is suitable for their requirements.
• Handle the tasks of planning testing strategies and identifying software issues
• Responsible for setting up standard testing environment as well as perform monitoring of system test phase
• Perform the tasks of communicating with clients for managing test data and ensure that it meets therequirementsfrom customer point of view
• Handle responsibilities of evaluating design specifications and review functional procedures
• Responsible for managing and executing Oracle Apps planning and testing procedures
• Perform the task of writing test case reports and logging defects by utilizing test directory tools.

Confidential, (May’11-June’12)
Client : Confidential,Ada, MI
Duration : Currently Working
Role : Oracle Functional Consultant

Team Lead for Inventory/Purchasing/iProcurement/iSupplier/iExpense/Manufacturing/WMS modules. Lead for Inventory Interfaces Transaction resolution.

• Identify permanent fixes to recurring problems.
• Created BR-100 and BR-110 documents for WMS, Purchasing, iProcurement and Inventory.
• Worked on set-ups for WMS replenishment tasks. Created WMS picking rules.
• Worked on customizations in WMS.

Support team members to achieve resolution of issues, requests and enhancements.

• Created new functional design documents (MD.050), Business Requirement Documents for the enhancements.
• Worked extensively on P2P cycle.
• Involved in testing of new reports and interfaces during monthly release cycle.
• Interact with the end-users in resolving major issues and also during gathering requirements for new enhancements.
• Provided Level2 production support for a Global Implementation.
• Provide extendedsupportduring Inventory month end close process.
• Customizing and personalizing approvals usingOracleApproval Management (AME)
• Worked with HP-QC during monthly regression testing.
• Worked with client DBA for analyzing patches provided by Oracle Product Support.

Onsite Lead Analyst and data collector to pass and lead corrections and fixes with the Offshore Team.

• Worked on RICE components related to advanced pricing and its integration with service contracts, Quoting and OM. Set up Price lists, Multicurrency Conversion Setup, Modifiers, Qualifiers, Formulas, Pricing Attributes and Factor Lists.
• Worked with cross functional teams in developing the extension that included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts)
• Available for on-call during week-ends and off-hours.

Onsite 24x7 support and mediator for Oracle TAR processing, testing and implementation. Developed the TE40 documents. Quality Assurance responsible for discreet manufacturing modules. Oracle TAR handling.

• Performed responsibilities of defect tracking and identifyingrequirementsof manual testing
• Handled the tasks of gathering businessrequirementsof clients to develop standard applications and work flow procedure
• Handled responsibilities of conducting functional testing of software functionality
• Assigned the tasks of preparing evaluation reports and updated the same to the senior staff.

Confidential, (May’10-May’11)
Client : Confidential,Sacramento, CA
Duration : 1year 10Days
Role : Oracle Functional Consultant

• Involved in the full life cycle implementation of Oracle EBS R12 SCM modules
• Developed, modified and Executed Application Setup Documents (BR.100) for INV, BOM, WIP, OM, iSuppleir, iExpense, iProcurement and PO.
• Worked on core setups, interface configurations, workflow documentation, requirement definition, and fit/gap analysis.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using OracleApproval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form.
• Assigned employee-user responsibilities, menu structures, security profiles
• Defined and implemented, organizational hierarchies, security profiles, security report groups, and responsibilities.
• Provided end-user support and training for INV, BOM, WIP, OM, PO, iProcurement, AP and AR.
• Developed, modified and Executed Test Scripts for INV, BOM, WIP, OM, PO, iProcurement, AP and AR.
• Worked extensively on P2P cycle.
• Worked with cross functional teams in developing the extension that included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts).
• Provided documentation tailored to company needs.
• Research, troubleshoot, and resolve issues that arise in the production system including data inconsistencies, unexpected error messages and daily close exceptions.
• Ensure that any Oracle integration into other systems meets functional requirements, system compliance, interface specifications and is in direct correlation with overall IT strategy.
• Wrote the Test Scripts (TE.040), Setup Documents (BR.100) for INV, BOM, WIP, OM, PO, iProcurement, AP and AR.
• Successfully executed CRP1, CRP2, and UAT and provided post production support for the end users after go-live. Provided post go-live support in INV, BOM, WIP, OM, PO, iProcurement, AP and AR
• Provided first level support for the Financial Applications, interacting daily with end users. Duties include, but are not limited to: User/responsibility maintenance

Confidential, (Jan’10-May’10)
Client : Confidential,Ontario, Canada (This is a Work from Home Project)
Duration : 5 Months
Role : Oracle Functional Consultant

• Lead the RICE components related to advanced pricing and its integration with service contracts, Quoting and OM. Set up Price lists, Multicurrency Conversion Setup, Modifiers, Qualifiers, Formulas, Pricing Attributes, Factor Lists.
• Developed, modified and Executed Application Setup Documents (BR.100) for INV, BOM, WIP, OM, iSuppleir, iExpense, iProcurement and PO.
• Lead the cross functional teams in developing the extension that included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts)
• Determined and negotiated the deliverables and delivery schedule with the client
• Directed the activities of the team supporting the project post implementation.
• Lead the business critical extension to generate price lists using APIs for communicating the prices to the distributors globally
• Worked extensively on P2P cycle.
• Worked on customer conversion from legacy to Oracle 12i system
• Proactively resolved issues and escalations and reported status to the management
• Worked on cut over activities related to the RICE components
• Designed the Modifier conversion from legacy to Oracle Apps
• Monitored the progress of the team; managed scope by identifying changes; estimated the impact to project schedule and recommended resolution.
• Managed project progress against schedule, proactively resolving problems and reported status to the management.
• Involved in requirement gathering sessions, worked on BR100, BR30 and MD50 documents.

Confidential, (Jan’07-Dec’09)
Client : Confidential,Pittsburgh, PA
Duration : 2years 11Months
Role : Oracle Functional Consultant

• Worked closely with external vendors in setup and functional gap analysis,
• Identified required RICE components and guided the team to deliver the components.
• Created inbound, outbound interfaces and conversions for GL and AP.
• Responsible for Month end closing and nightly Batch jobs.
• Co-ordinate efforts for applying oracle patches.
• Developed, modified and Executed Application Setup Documents (BR.100) for INV, BOM, WIP, OM, iSuppleir, iExpense, iProcurement and PO.
• Trained Business Users and involved in documentation of user support documents
• Monitor and fix errors in interfaces, research the reason for errors, fixing the issue and reprocessing data.
• Responsible for accuracy of data and is accountable for any system issues including storage capacity.
• Delegated work to onsite and offshore teams
• Designed FSG reports in GL to get balance sheet for each entity within the organization in order to help month-end reconciliation.
• Customized reports in AR such as: Open-Debit Memo Report, Aging Report Customer Payment Details Report.
• Defined Transaction Types, Invoice Batch Sources, Customer Profiles, Customers, Payment Terms, Sales Tax Location flexfield, Exemptions and Exceptions.
• Gathered end-user specifications and work with Development team to deliver system customization and enhancement requests.
• Worked extensively on P2P cycle.
• Created Set of Books by defining value sets, segments, security rules, cross validation rules key flexfield structure, period types, currencies, accounting calendar.
• Resolved the day-to-day critical production support issues like Payments sent to the Bank.
• Developed external payables invoice load using the AP Invoices Interface.
• Worked on critical production issues, which includes interacting with users, Root cause analysis, Data fix and Patch Impact Analysis.
• Worked on Oracle Process Manufacturing Modules
• Gathered requirements from users/gap analysis, setup of the application and training users/developers with the use of application functionalities, worked with other functional applications lead with regards to setup/patching issues and also working with the DBA and developers to identify and address custom needs of the client.
• Participate in workshops with clients in the design, configuration, and conversion of the financial management application.
• Performed systems integration testing and support user acceptance testing
• Set Up Locations Sub-inventories
• Set up the internal Order flow
• Developed the TE40 for internal orders and conducted unit testing
• Set up Customers Order Types and Line Types Document : Sequence Price Lists Release Sequence Rules Pick Release, Rules Pick Slip Grouping, Rules Ship Confirm Rules·
• Conducted the unit testing for complete Internal order flow
• Designed the RMA interface to external system
• Set up Value Sets, DFF and Lookups· Worked on BR100, TE40 and MD50 documents.
• Worked on planning the tasks and assigned and directed the activities of the team
• Participated in a cross-functional projects activities, co-ordinate the tasks to maintain the seamless integration of the application with other systems
• Designed the Item Category assignment interface based on the custom business rules using the API EGO_ITEM_PUB.
• Worked on Inventory Item Open Interface for bringing in the items into Inventory
• Designed the outbound interface that extracts Item category assignments and Product attributes from PIM (Product Information Management System)
• Designed the outbound interface that extracts Items that do not have categories assigned for a given category set category assignments
• Designed the outbound interface that extracts leaf nodes of the category hierarchy in a given category set. Successfully handled the functional and technical issues, communicated with senior management, resolved conflicts that arose and recommended the optimal approach.

Confidential, (Feb’06-Dec’06)
Client : Confidential,San Antonio, Texas
Duration : 11 Months
Role : Oracle Functional Consultant

• Lead the RICE components related to advanced pricing and its integration with service contracts, Quoting and OM. Set up Price lists, Multicurrency Conversion Setup, Modifiers, Qualifiers, Formulas, Pricing Attributes, Factor Lists.
• Lead the cross functional teams in developing the extension that included multiple modules (Quoting/ OM/ EDI/ Pricing/ APC/ Service Contracts)
• Determined and negotiated the deliverables and delivery schedule with the client
• Directed the activities of the team supporting the project post implementation.
• Lead the business critical extension to generate price lists using APIs for communicating the prices to the distributors globally
• Worked on customer conversion from legacy to Oracle 11i system
• Designed the AR invoice import interface
• Proactively resolved issues and escalations and reported status to the management
• Worked on cut over activities related to the RICE components
• Designed the Modifier conversion from legacy to Oracle Apps
• Monitored the progress of the team; managed scope by identifying changes; estimated the impact to project schedule and recommended resolution.
• Managed project progress against schedule, proactively resolving problems and reported status to the management.
• Involved in requirement gathering sessions, worked on BR100, BR30, MD50 and MD70 documents.
  

Confidential, (Jan’04-Dec’05)
Client : Confidential,Trumbull, CT
Duration : 12 Months
Role : Oracle Finance Techno-Functional Consultant

• Managing a team for functional implementation of Oracle Financials (GL, AP and AR modules) across the organization.
• Planned the tasks, scheduled and monitored project work with respect to project scope and timing requirements.
• Worked on future business process flow, identified the gaps and suggested the resolution
• Lead the functional design and got the business sign off on that,
• Documented test scripts for user testing. Helped PMO with user training documentation.
• Responsible for analyzing the business requirements defining the scope and planning the deliverables
• Studying the requirements, performing risk analysis and mapping the business processes
• Documented test scripts for user testing
• Conducted CRP with the key users
• Worked with the cross functional teams to ensure the end-to-end solution works.
• Ensured technical stability, timely support and successful integration of enhancements.
• Configuring the modules, designing reports and add-ons and coordinating with the technical team to monitor development and implementation progress.
• Designed the customization of PO approval Workflow
• System Administrator: Documented user matrix and created Custom menu and Responsibility and Report group and Report set and Concurrent program and Executable for the custom programs.