SUMMARY:

• Functional Consultant - Oracle Applications Specialist with 8.6 years of business and IT experience. ERP Analyst in manufacturing and distribution modules of Oracle Applications.
• Worked with various industries and involved in different stages of Projects such as Implementation, Upgrade, Rollout and Support of Oracle Inventory (INV), Purchasing (PO), Order Management (OM), Bills of Materials, Work In Process (WIP), Quality and I-Modules.
• Strong Exposure on above modules along with Account receivables, Account payables, General ledger.
• Experienced in Identifying and Analyzing Business Requirements, Solution Design, Gap Analysis, Business Process Mapping, Application configuration, Data Conversion and Validation, Customizations, System and Integration Testing.
• Having experience in handling Interface/ Integration with 3rd Party Software and customizations in Oracle EBS.
• Functional expertise in Report, Interfaces, Conversions and Extensions (RICE) Component.
• Expertise in Client Interaction, Requirements Gathering, Process walkthrough, Functional Mapping, GAP Analysis and Functional Design documentation.
• Solid understanding of the Business Processes across various business domains.
• Extremely strong on Oracle’s Application Implementation Methodology (AIM)
• Support of Production and Test instances for upgrade/regression/integration/User acceptance testing(UAT).
• Expert in training entry level application analysts.
• Excellent understanding of Oracle Applications base tables, views, data elements for troubleshooting and resolution of Production issues.
• Undergone training in ERP solutions - Oracle Fusion Procurement & SCM.
• Experience in performing detailed reviews of current practices and procedures, examining alternatives and implementing solutions within the current system environment.
• Exposure to onsite-offshore model & successfully managed on-site assignments in U.S
• Developed and executed test scripts to ensure correctness of the implementation.
• Extensive engagement work and project implementation experience has given an insight into the interactions between Oracle’s modules and project implementation methodologies.
• Business experience and background has helped to foster a detailed knowledge of best practices regarding the accounting and finance functions.

WORK EXPERIENCE:

Confidential, Montvale, NJ

Functional Consultant

Software: Oracle Applications -R12

Responsibilities:

• Implementation of Oracle Applications OM, Inventory modules in R12.2.6
• Closely interacted with Clients in collecting Business requirements and designing process.
• Gap Analysis and Resolution provided, Prepared Design & functional specification documents, Prepared Setup specification documents - BR100.
• Understanding the functional requirements of the client, Analysis and documented High Level documents mainly MD50 Functional Specification and resolve the gaps through functional walkthrough.
• Provided Impact analysis of Requirements and provided workarounds wherever possible.
• Upon documentation, conducted regression testing in Dev & Test Instance and upon required approvals, get migrated to Prod. Instance
• Sanity check will be done in Post Prod. Migrations and hand over to business
• Worked on several Customizations and personalization’s in Oracle SCM modules specifically on Order Management.
• Worked on integration of Sales orders into EBS from 3rd party legacy applications to Oracle via EDI.
• Designed Order Preprocessor form which is used to input several upfront data required by Business which will be imported or defaulted to Oracle Sales Order form through EDI.
• Worked on Item Orderability functionality in Order Management and customized according to business requirements
• Worked on Integration with OTM and IDS applications to Order Management module for shipping and planning of different trucks to Forwarding Agents.
• Documented the new business processes & functional requirements and updated process flows BR030 docs.
• Supported throughout Order Management module by validating workflow (Order-to-Cash) for order booking, pick release, ship confirmation and receivable interface.
• Developed a custom workflow which combines IRISO and Back to Back Order process to supply items from ADC to SDS warehouse distribution centers.
• Developed customizations to above workflow such as PONR logic, ISO Adjustment Cemli, etc.
• Provided end user training to the business users about the new procedure developed for the business transformation phase in Order Management, & Pricing modules.
• Performed Gap Analysis so as to map the business requirements to oracle functionality
• Flow Testing for SCM Modules (OM, INV, PO) to make sure flow is working without any issues.
• Jointly worked with the QA team in formulating the Test Cases & Test Scenarios.
• Assisted Business for Business Acceptance Testing and obtain Sign off.
• Carrying out Users Acceptance Test (UAT), go-live activities and Post implementation support.
• Reporting the project status to responsible managers on a daily and weekly basis (Scrum Call). Daily tasks included attending meeting with Business, other team managers; also trained users understand different application modules.

Confidential, San Francisco, CA

Functional Consultant

Software: Oracle Applications -R12

Responsibilities:

• As Project Lead, responsible for smooth running of project.
• Involved in day to day support of production issues in modules- INV, BOM, WIP, OM
• Understand the current business process and troubleshooting the Production issues to find the Root Cause and reproducing issues in TEST instances and analyzing the resolution / work around to fix the issues in Production.
• Supported production environment and users on a daily basis by responding to emergency requests.
• Interact with the end users and demonstrate the changes in functionality in details.
• Involved in Period close and Physical Inventory process.
• Work with Business Users daily by providing functional support to ensure successful flow of Business processes.
• Prepare training materials with screen shots, exercises and presentations for critical end users.
• Participated in ongoing process enhancements and modification requests.
• Testing the functionalities as per the change in requirements.
• Involved in unit testing and integration testing on various modules.
• Created Oracle service requests and fixed the bugs in Oracle application with the help of Oracle support. Tested the fix in TEST instance prior to apply in prod. instance.
• Define user responsibilities, set up custom menus and request sets based on user responsibilities.
• Undertaking all steps necessary to satisfactorily closure of the tickets raised by clients.
• Tracking all issues logged by end user and provided functional solutions.
• Working with Oracle on created SR’s and uploading the requested files and outputs.
• Interacted with Technical and DBA people to get the solution.

Confidential, Houston, Texas

Functional Consultant

Modules: INV, OM, Shipping, BOM, WIP

Responsibilities:

• As a SCM Functional consultant implemented the following modules: Inventory, OM, Shipping, BOM, WIP.
• Worked on the Functional mapping of data Conversions & Enhancements for AR, AP and GL modules.
• Worked on the setups of Drop Ship and Back to Back order process in OM module.
• Defined Customer Master (TCA) module
• Worked on setting up processing constraints in OM Module
• Designed and setup the Modifiers and Qualifiers in Advance Pricing module.
• Worked on the defining the formulas in Advance Pricing
• Worked on the configuration of the RMA process in OM Module.
• Worked on the Deferred COGS and Deferred Revenue process.
• Worked on setting up Auto Lock Box in the AR Module.
• Worked on the AGIS Module
• Worked on the Cash Management setups of Bank Statement Interface, Reconciliation Process.
• 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.
• Configured Oracle OM, Inventory, BOM, Shipping Modules from scratch and simultaneously created BR100 documentation for the setups.
• Involved in troubleshooting issues on Auto Invoice Import Program.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users OM, Shipping, Inventory, BOM, WIP Modules.

Confidential

Functional Consultant

Project Type: Support of Oracle Apps R12.1.3

Responsibilities:

• Worked as an Functional Consultant for Property Manager & Purchasing module.
• Root Cause Analysis (RCA) for various repetitive problems and provided suggestions for speedy problem resolution.
• Responsible for monitoring and managing production support queue and resolving production support tickets as per defined SLA (Service level agreement).
• Worked with end users to gather requirements on functionality enhancements in Order Management and Inventory modules.
• Interact with the end users and demonstrate the changes in functionality in details.
• Resolved the Support issues by directly interacting with clients connecting to their remote desktop and guiding them.
• Involve in unit testing and integration testing on various modules.
• Testing the functionalities as per the change in requirements.
• Representing for Oracle Service requests regarding issues/bugs/patches and necessary escalations where required.
• Prepare training materials with screen shots, exercises and presentations for critical end users
• Coordinating with technical team in resolving the tickets raised by end users
• Participating in monthly meetings with the clients and providing the details relating to pending issues if any on Property Manager with the help of PPT’s

Confidential

Functional Consultant

Modules: OM,INV,BOM & PO

Responsibilities:

• As a SCM Functional Consultant implemented modules OM, INV, BOM & PO in Release 11.5.10.2
• Performed all the Configurations and Setups for INV, PO, OM Modules
• Preparing BR30, 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 from BAAN & D1.
• Created New FSG Reports, using multi-currency features including foreign currencies for multi org structures.
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Configured Auto Invoice in AR to import data from the non- Oracle ERP instance in Japan.
• Implemented TCA - for AR customer master conversions.
• Implemented the Data Quality Management (DQM) in TCA.
• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks.
• Establish the best practices and controls in Oracle like Security, Segregation of duties.
• Unit & Integration testing across all modules.

Confidential

Functional Consultant

Responsibilities:

• This project implemented Oracle Applications 11. 5.9 in Mitsuba SICAL India Ltd. The Objective was to set up and Implement Oracle Apps Setup in 11.5.9.
• Migrated master data from existing system. Migrated transaction data.
• Worked in the creation and maintenance of item master organization.
• Created multiple item templates based on usage. Set up Inventory controls.
• Set up position approval hierarchy in the Purchasing module.
• Configured classification for materials based on characteristics.
• Performed Inventory Stock Control and ABC analysis.
• Worked in all Purchasing Documents, including: RFQ, Quotation, Purchase Requisitions, and Purchase Orders. Used AIM methodology for Project Documentation.
• Performed self-review of own product and group review of other team member work products and worked closely with technical team given inputs for integration testing.
• Participated in unit testing of own work product and integration testing in other team member work products.
• Prepared user training manual for Purchase and Inventory modules.