SUMMARY:

• 10+ years of IT Experience, which includes experience as Confidential Functional Consultant/Business Analyst with specialization in Oracle Financial and Distribution Systems
• Industry experience revolves around Oracle ERP Applications - Implementation, Support and Upgrade.
• Experience with Oracle Fusion Manufacturing (Landed Cost Management Quality Management, Outside Processing, WIP, Planning) Procurement and Supply Chain Cloud - Product Master Data Management, Inventory Management, Landed Cost Management)
• Experience with Cloud Fusion Reporting using Oracle Transactional Business Intelligence (OTBI)
• Experience with Cloud Fusion Universal Content Manager (UCM)
• Worked on all the Oracle Supply Chain Modules - Quoting, Advance Pricing, Shipping, OM, INV and PO. Have 2 full life cycle implementations in Release 12. Worked on both the “Quote to Cash” process as well as the “Procure to Pay” process.
• Extensive experience with Reverse Logistics and Logistics process including integration with 3PL Logistics systems
• Extensive experience with Contract Manufacturing - Vendor Managed Inventory and Consigned Inventory processes.
• Extensive experience with Training of End Users and Business Super Users using Oracle Tutor, WebEx virtual training and well as conducting of CRP’s and UAT’s. Well versed in preparing training material and training manuals.
• Responsible for testing of the functionality of Oracle ERP Application
• Conversant with documentation as per the AIM methodology.
• Involved in scoping and mapping of business requirements of clients for Oracle Financials/Distribution solutions.
• Involved Conference Room Pilots and User Acceptance Testing.
• Also, responsible for building, testing & development as per Business Requirements.

PROFESSIONAL EXPERIENCE:

Confidential, Seattle WA

Oracle Cloud Manufacturing Functional Analyst

Responsibilities:

• Responsible for managing the implementation around the Manufacturing Modules (Implementing Back to Back fulfillment, internal material transfers, contract manufacturing, outside processing, inventory management, receipt accounting, cost accounting, landed cost management)
• Worked on implementing Oracle Quality Management Cloud - defined the inspection characteristics, associating inspection characteristics with characteristics group, defined quality inspection levels, defined quality inspection plans, defined OTBI reports for Quality, defined custom quality actions, defined quality event lookup values, etc.
• Worked on Oracle the setup of the Cloud Order to Cash Processes.
• Worked on Oracle Retail Order Broker - maintained Confidential periodic item and inventory update between Oracle Inventory and Oracle retail Order Broker, worked on retail order brokers routing rules to automatically assign backordered items to storefronts for fulfillment, setup retail order broker for to fulfill retail pickup, setup control values, defined retail order broker properties, etc.
• Worked on XML Publisher Report customizations.
• Worked on WEB ADI for loading offers, payment details of Confidential customer into Advance Collections and Channel Revenue Management
• Worked on the Auto Lock Box process in AR for Bank of America
• Worked on Bank Statement Mapping for Bank of America in Oracle AR China Hard Lot Control
• I am responsible for leading the efforts for conversion of 15 Inventory orgs from non-lot control to lot control.
• Involved in Testing of 10 interfaces (Item Master, Purchase Orders, Sales Orders, Inventory Adjustments, Inventory Snapshots and Move Orders) between 3PL (DHL and CJ Rokin) and Confidential .
• Planned cutover activities for implementing Hard lot control.
• Executed cut over activities like cleaning up sales orders, Purchase orders, and Material Transactions.
• Responsible for clearing inventory Interfaces for the Inventory conversion.
• Performed lot control setups in Inventory.
• Prepared test plan, test cases/scripts and scenarios
• Conducting defect triage meetings and report test status.
• Executing test cases in Quality control.
• Recording test results in Quality control
• Recording test defect in the Quality control
• Working with Functional and Technical teams to resolve the defects/issues.
• Interacting with the Middleware team for resolving interface related issues.
• I was responsible for troubleshooting recurring issues in OM/INV/PO modules and implementing long term solutions, which may involve configuration/code changes.
• As part of troubleshooting, identified multiple code fixes, created Confidential master plan for deploying them, working with Development team to get the fixes.
• Weekly reporting Project/status with call outs to the leadership.
• Performed Configuration and Testing. Responsible for creation of Test cases and Test plans for business unit testing, updating the functional & technical specification documents with the latest changes/upgrades.
• Resolved defects of 3PL organizations for both Inbound and Outbound interfaces.
• Performed Configuration and Testing. Responsible for creation of Test cases and Test plans for new operating units (NESTLE US, NESTLE CANADA, and NESTLE EMEA) testing.
• Lead North America and EMEA testing efforts for project gallant.
• Worked with different 3PL (Penske, Geodis, Gist, and Manhattan) for testing Sales Order and drop ship orders.
• Worked with cross-functional teams (EDI, OTM, Siebel, Siren, and Middleware) for SIT testing.
• Weekly reporting Project/status with callouts to the leadership.
• Working with Functional and Technical teams to resolve the defects/issues.

Confidential, NJ

Supply Chain Functional

Responsibilities:

• Worked on the modules of Cloud Fusion Manufacturing (Quality Management, Inventory Management, Outside Processing, Back to Back Order fulfillment, Landed Cost Management, Cost Management)
• Worked on the Cloud Quality Management Setups - defined the inspection characteristics, associating inspection characteristics with characteristics group, defined quality inspection levels, defined quality inspection plans, defined quality event lookup values, etc.
• Worked on Cloud OM, Cloud Inventory Management configurations.
• Worked on the Outside Processing in Oracle Fusion Cloud.
• Supported the Interface errors that occurred and resolved them in Confidential timely manner
• Supported the month end and quarter end activities to help the business with the close process
• Supported the tax issues that arose between Oracle e-Business Tax and Vertex.
• Supported the business users for any enhancement requests that were raised.
• Manned the help desk ticketing system, taking ownership for issues and resolving them.
• Worked with Oracle support to open service requests - analyze the read me file, work with the DBA team to apply the patch to the patch instance, certify the patch and work on Confidential schedule of applying it to production

Confidential

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• Responsible of business requirements gathering and definition, gap analysis and process mapping
• Prepared detailed use cases to capture the interaction between user and software, visually present Confidential flow of business model and to determine functional design expectations during systems and environment testing
• Worked on the setups of Oracle Advance Pricing for Purchasing module
• Worked on the setups of Modifiers and Qualifiers in Advance Pricing
• Worked on the setups of Dynamic formulas in Advance Pricing
• Worked on volume based pricing in Oracle Advance Pricing.
• Worked on Coupons and Buy One Get one free pricing in Advance Pricing
• Worked on Attribute definition and Attribute mapping in Advance Pricing module.
• Worked on the setups of the TCA - including the Parties, Accounts, Account Relationships, Party Relationships, Party Sites, Account Sites, Party Relationships, etc.
• Worked on the shipping transaction file to be transmitted to the 3PL Logistics system using EDI transmissions
• Worked on the Contract Manufacturing process flows.
• Worked on the integration of Reverse Logistics with Depot Repair module
• Worked on the integration of the Logistics process with 3PL Logistics system (UPS)
• Worked on the integration of Oracle INV with Confidential 3PL logistics system
• Performed all of the setups for Quoting, OM, Advance Pricing, INV, PO, Shipping modules
• Effectively designed and deployed Confidential new Chart of Accounts and Ledger structure that best supports external and internal corporate management reporting requirements, while simplifying transaction entry.
• Interacted with key stakeholders and gathered requirements to perform corporate financial consolidations, and associated reporting, for numerous corporate entities
• Work directly with the system developers to implement and maintain system changes
• Overseeing day to day performance and schedules, communication to financial community, and security administration tasks
• Issue maintenance requests for all system and balance errors
• Key responsibilities also include management of User Acceptance Testing cycles and end user documentation; Efficiently organized test plan and scenarios for functionality testing and conducted business end-to-end manual testing
• Implemented and identified improvements to the existing interfaces and processes
• Responsible of post-production support for Oracle Modules of Quoting, OM, Advance Pricing, INV, PO, Shipping

Confidential, Philadelphia, PA

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• Worked on the entire Distribution (Order to Cash and Procure to Pay) business process.
• Performed all of the setups for i-Procurement, Advance Pricing, INV, Quoting, OM, Supplier Hub, INV, PO modules
• I procurement: Designed workflow customization and punch-out catalog. Define requisition template and system profile options. Extract catalog and item data. Setup of approval hierarchy, approval groups and approver assignment
• Pre upgrade testing and Post upgrade production live support.
• Support Production issues on Confidential day to day basis including month end closure p1 issues
• Worked on conducting Conference Room Pilots (CRP) and User Acceptance Testing (UAT)
• Developed Test Scripts and Executed Test Scripts.
• Worked on Mercury Quality Center to log defects and report back to the team.
• Provide support/enhancements for the existing Oracle and Discoverer Reports (across i-Procurement, Advance Pricing, INV, Quoting, OM, Supplier Hub, INV, PO) and create new ones based on business requirements.
• Creation of Users, Responsibilities, Menu, Request Groups, Request Sets, Form Folders, Key / Descriptive Flex field Segments / Values, Security Rules, Cross Validation Rules, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options

Confidential, San Diego

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• Understanding the existing business processes including PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules
• Preparing existing business process documents
• Mapping the business processes with Oracle standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing
• Preparing BR100 and Completing the Setups and configurations for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing
• Preparing the test cases for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• Fixing the issues for converted data for PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing modules

Environment: Oracle Apps 11.5.9/11.5.10 e-Business suite (PO, i-Procurement, OM, Supplier Hub, INV, Shipping, Advanced Pricing)

Confidential, Sunnyvale, CA

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• Understanding the existing business processes including AR, AP, PO, i-Procurement, GL, & Cash Management
• Preparing existing business process documents
• Discussing with business users and preparing BP80 for future To Be Process documents for AR, AP, PO, i-Procurement, GL, & Cash Management
• Mapping the business processes with Oracle 11.5.10 standard functionalities and identifying the gaps.
• Giving demonstration of standard functionalities of AR, AP, GL, PO, and i-Procurement, FA & CASH Management to the Business Users.
• Proposing solutions and customization for gaps and getting the approval from business users.
• Working with Technical team closely and getting done development for customizations for AR, AP, GL, FA & Cash Management Modules.
• Working closely with Business users to understand the criteria’s and filters for converting data from 11.0.3 to 11.5.10 for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Working closely with developers to develop code for data migration using Oracle APIs and wrapper programs
• Preparing technical specification documents for AR, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing BR100 and Completing the Setups and configurations for AR, PO, i-Procurement, AP, GL, PO, i-Procurement, FA & Cash Management
• Preparing and using data loader script to load the data and completing setups for Service Request module.
• Preparing the test cases for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules
• Conducting CRP1, CRP2 UAT1 and UAT2 and helping the user for going through all the test cases.
• Fixing the issues collecting during CRP1, CRP2 and UAT.
• Working 24 by 7 during cutover and down time
• Providing support to users after implementation is done and fixing all issues related to set ups
• • Fixing the issues for converted data for AR, AP, GL, PO, i-Procurement, FA & Cash Management modules

Environment: Oracle Apps 11.5.10 e-Business suite- AR, AP, GL, FA & Cash Management

Confidential

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: i-Expense, GL, AP, AR, i-Procurement, INV, PO and OM of Oracle e-Business Suite.
• Implemented 2 SOB’s (2 Operating Units) using multi org structure, multi currency along with 1 Consolidation SOB.
• Worked on Confidential deferred revenue customization using the Revenue Recognition process in AR.
• Functional Design for the Auto Invoice interface in AR to load invoices into AR from an external system.
• Created the Collections Administrator, Collections Manager, Collections User profiles in AR module
• Implemented internal control features using Form Personalization’s for modules GL, AP, and AR.
• Implemented TCA - for AR customer master conversions.
• Designed and developed the customer interface to load customers into the TCA Module from an external customer database.
• Implemented Auto Lock box Functionality in AR for Bank of America & Royal Bank of Canada.
• Functional Designing and executing ‘Data migration’ strategy for Master and Transactional data.
• Developed different reports as per the client’s requirement.
• Trained business owners and business end-users on OM, INV, PO, AR, AP and GL modules as part of User Training Strategy.
• Conducted pilot testing, integration with other financial modules testing.

Environment: Oracle E-Business Suite 11.5.10.2

Confidential

Oracle Procure to Pay Techno Functional Consultant

Responsibilities:

• As Confidential Functional Consultant implemented financial modules: GL, AP, AR, Cash Management, iExpense, Fixed Asset, OM, INV and PO Release 11.5.10.2
• Performed all the Configurations and Setups for INV, PO, OM, AR, AP and GL 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.
• Worked on Confidential customization for Deferred Revenue is AR using Revenue Recognition process.
• 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 on all crosses modules.

Environment: Oracle E-Business Suite 11.5.10, Manual Testing, and Windows 2003 server.

Confidential

Oracle Applications Functional

Responsibilities:

• Worked as Confidential functional Consultant to implement Oracle Application 11.5.10.2 involving AP, AR, GL Modules Meet with customers to understand their system and service requirements and then Writing Functional Test Scripts for the end to end testing, coordinating with the technical team to develop load testing scripts for all of the data conversions as well as inbound and outbound interfaces.

Environment: Oracle 9i, Oracle Financial Applications 11i (11.5.10.2), PO, AP, i-Expense, AR, GL