SUMMARY:

• 8.4 years of Experience in IT with Expertise in Oracle Applications Expertise in Oracle E Business Modules - PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP modules.
• Extensive experience with Reverse Logistics and Logistics process including integration with 3PL Logistics systems
• Extensive experience with the RMA Process - Return from Vendor, Return from Customer, Retail Returns, Return with Replacement, Return with Exchange, Return with Repair, Containerization, Bar Code Scanning, etc.
• Experience with Agile Product Life Cycle Management (PLM)
• Extensive experience with Order to Cash and Procure to Pay Business flows.
• Good working knowledge in Oracle AIM Methodology. Handled Service Requests (TARs) with Oracle. Knowledge on Oracle Accelerator and Oracle R12.
• Expertise in Implementation where am involved in Module selection, Requirement gathering, Gap Analysis, Solution Design, Building, Testing, User Training and Production.
• Proficient in Creating User Requirement Specification, Functional Requirement Specification and Business Process Flows.
• Extensive experience with EDI Standards and e-Commerce Gateway.
• Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).
• In Upgrade projects, handled Discovery, Mapping, Testing and Transition.
• Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.
• Extensive experience in conducting training sessions for users to give them knowledge about how the system is going to work.
• Good documentation skills and Proficiency in MS Visio
• Good organization skills & Ability to interact at all levels in an IT organization to assess, evaluate, recommend a different and robust solution and lead through the development.
• Well-proven track in achieving the timeline for deliverables.
• Highly motivated with excellent interpersonal and communication skills.

PROFESSIONAL EXPERIENCE:

Confidential, Pittsburg, PA

Responsibilities -

• As a P2P Functional Consultant implemented the following modules PO, i-Procurement, OM, Advance Pricing, Shipping (Logistics), Reverse Logistics, INV, BOM, WIP modules
• Worked on the setups of the OM Module - defining the transaction types, defining the pricing options, setting up the defaulting rules, processing constraints, etc.
• Worked on the setups for the flows of Return Material Authorization (RMA) process for Reverse Logistics
• Worked on the Return to Vendor Process, return with Repair, return with Exchange, Return for Credit, Bulk Return, etc.
• Worked on the functional design of the fulfillment module with Warehouse Management system
• Worked on the containerization process in Oracle Warehouse Management
• Worked on the integration of Reverse Logistics with Depot Repair module
• Worked on the integration of the Logistics process with 3PL Logistics system (FedEX)
• Worked on the Functional mapping of data Conversions & Enhancements for PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP modules.
• Worked on the setups of Advance Pricing module - defining the Price Lists (primary and secondary), modifiers, qualifiers, pricing formulas, etc.
• 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.
• Worked on INV module configuration - defining the Inventory Master and Child Orgs, Sub Inventories, Locators, Lots, Min Max Planning, Re-Order Point planning, cycle counting, physical inventory, etc.
• Worked on the integration of Oracle INV with a 3PL logistics system
• Involved in troubleshooting issues on Order Import Program In Oracle OM module.
• 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 in PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP Modules.
• Documentation of the detailed Projects conversion and integration approaches
• Creating validation approaches for data conversions
• Lead mapping and validation of Projects data
• Participate in conversion validations
• Identify data cleansing requirements

Confidential, Pittsburg, PA

Senior P2P Functional Consultant

Modules - PO, i-Procurement, OM, Shipping (Logistics), Advance Pricing, INV, BOM, WIP

Environment : Oracle applications R12 (Technology: PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP, Localizations for Europe and China ), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Responsibilities -

• As a P2P Functional Consultant implemented the Business flows including PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP Modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP
• Worked on the setups of the Logistics Process and Reverse Logistics using the Return Material Authorization (RMA) process.
• Worked on the setups of the Advance Pricing Module
• Worked on the design of the INV Module
• Worked on the configurations of the OSP process in Oracle WIP module
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for PO, i-Procurement, OM, Advance Pricing, INV, BOM, WIP modules
• 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.
• 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, Journal Sources, Categories, Document Sequence Assignment, Multi-org Setup, Profile Options
• Facilitate Segregation of Duties in Oracle Applications. Customize various roles and responsibilities as per the SOD Document in System Administration.

Confidential, Malta, NY

P2P Functional Analyst

Modules: PO, i-Procurement, OM, Shipping (Logistics), Advance Pricing, INV, BOM, WIP modules

Responsibilities:

• Worked on the setups for the PO, i-Procurement, OM, Shipping (Logistics), Advance Pricing, INV, BOM, WIP 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.
• Implemented Supplier Conversions - for AP Supplier Master conversions.
• Worked on the setups of the Inventory module.
• Worked on the Return Material Authorization (RMA) process in Oracle OM module
• Worked on the configurations of Order Management module - defining the Order and Line Transaction Types, defining the processing constraints, defaulting rules, setting up pricing attributes, etc.
• Worked on the shipping transaction file to be transmitted to the 3PL Logistics system using EDI transmissions
• Worked on the AR/AP netting process in AP module.
• Worked on the AP Processes of Retainage, Recoupment, etc.
• Worked on the defining the transaction types, financial options, tax rules in Oracle AP module
• Involved in understanding the existing business process & conducted meetings on client business overview
• Performed Gap Analysis so as to integrate the business requirements to oracle applications
• Prepared business requirements documents for Purchasing and Order Management

Confidential, SFO, CA

P2P Functional

Modules: i-Expense, SLA, Cost Management, e-Business Tax, Inventory, GL, OM, AR, INV, AP and GL

Environment: Oracle Application Release 12.0.5

Responsibilities -

• Involved in the Implementation and Post-Implementation Support
• Impact analysis done on the service items and professional service items with the new setup done for the Event-based Revenue Recognition process
• Involved in making the detailed data conversion strategy and data cleaning road map for PO, AP, I-Procurement, INV, and Oracle Sourcing Modules.
• Written standard Integration test scripts for PO, AP, I-Procurement, INV, and Oracle Sourcing Modules.
• Worked on the setups and conversions of PO, AP, I-Procurement, INV, and Oracle Sourcing Modules
• Submitted weekly status updates and reports showing the progress of Software Testing.
• Responsible for validating the back-end data that was migrated from previous versions.
• Recommended areas for fine-tuning the system based on the analysis to the server experts(s) and system administrators.
• Worked on testing the Revenue Recognition functionality in AR for all the Accounting and Invoicing rules that were defined.
• Tested a patch that we had applied for the Revenue Recognition process.
• Performed Standard Functionality testing PO, AP, I-Procurement, INV, and Oracle Sourcing.
• Was involved in Standard Functionality testing in Phase I and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit that is being introduced as part of the upgrade to R12.
• Involved in Unit Testing and System Testing.
• Documented and communicated test results to the Test Management and Business Management Team
• Worked closely with Developers team for different issues

Environment: Oracle (PO, AP, I-Procurement, INV, and Oracle Sourcing) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential, Seattle, WA

P2P Functional Analyst

Environment : Oracle applications R12 (Technology: AR, Cash Management, AP, GL, i-Procurement, i-Expense, PO, Project Costing, Project Billing, Project Contracts, OM, INV, Sub Ledger Accounting, e-business Tax, Cost Management, Localizations for Europe and China ), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Responsibilities:

• Study AS-IS Business Process.
• Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on the setups of i-Expense, AR, GL modules
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• 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 the AR, AP, i-Expense, GL modules
• Good understanding Financial Accounting standards and Revenue Recognition Standards.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation.

Confidential

Finance Functional Analyst

Environment : Oracle applications R12 (Technology: AR, Cash Management, AP, GL, i-Procurement, i-Expense, PO, OM, INV, Sub Ledger Accounting, e-business Tax, Cost Management, Localizations for Europe and China ), Oracle database 9.x, 10.g, SQL, PL/SQL, TOAD

Responsibilities:

• Study AS-IS Business Process.
• Analyze the Upgrade Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Worked on setting up the Intercompany Accounting process including both GL and Internal Order Internal Requisition Process (IRISO)
• Worked on setting up of Revenue Recognition process in AR Module
• Defined the Accounting and Invoicing rules to be used in Revenue Recognition process in AR.
• 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 the AR, AP, GL and i-Expense modules
• Good understanding Financial Accounting standards and Revenue Recognition Standards.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle - to define new items and categories.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track
• Documented and analyzed businesses processes and develop detailed user requirements and functional specification documents.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go Alive.
• Provide user training & documentation.

Confidential, Phoenix, AZ

Functional Consultant

Oracle 11.5.10

Modules: AP, i-Expense, GL and AR

Responsibilities:

• Member of Global GL/GIS team responsible for AP, i-Expense, GL and AR modules
• Core member of CRP2 Team
• Worked on Mercury Quality Center as a Test Director.
• Functional design for GL interface with external systems for 70 SOB
• Responsible for communication with overseas IT resources for different global GL components
• Worked closely with IT team for different issues.
• Set up, created the FSG profile options and created datasheets for the FSG reports.
• Developed FSG reports in Oracle General Ledger, which includes balance sheet, income statement, revenue recognition reports, and profit and loss statement.
• Developed and maintained functional specifications for custom reports
• Created test scripts for validating the FSG reports.
• Met with Dell leads and users to generate and review the current and future reporting requirements of the client.
• Provide end user support of financial and analytical reports using Oracle General Ledger, FSG, ADI and Discoverer.
• Developed several reports using Discoverer 4i.

Environment: Oracle Applications 11.0.3, 11.5.8 ( AP, i-Expense, GL and AR, Discoverer 4i), ADI

Confidential, Mountain View, CA

Oracle Financial Functional Consultant

Responsibilities:

• Examined the client’s current and future business processes.
• Defined the calendar and chart of accounts. Defined the Multiple Set of Books, Accounting Periods, Journal Sources, Journal Categories, Automatic Posting, Suspense Accounts, Round difference accounts and Summary Accounts.
• Created journals (standard and formula) for the interfaces.
• Defined Mass Allocation Formula.
• Used ADI (General Ledger Desktop Integrator) to integrate the GL module to the Excel spreadsheet.
• Defined value sets, key flex fields segments and roll-up groups with security and cross validation rules.
• Prepared documentation provided adequate knowledge transfer.
• Generated several FSG Reports.
• Work with team to resolve critical issues. Identify, document and expedite resolution of Oracle functionality issues. Track and expedite Oracle TARS (Technical Assistance Requests) and assist with the planning and testing of updates and patches.
• Worked on testing the applications end to end. Wrote test scripts, worked with business to execute test scripts.
• Developed financial statement generator reports in Oracle General Ledger, which includes profit and loss statement, balance sheet, revenue recognition reports.
• Developed and maintained functional specifications for custom reports
• Met with users to generate and review business test cases.
• Developed several reports using Discoverer 4i.

Environment: Oracle Applications v.11.5.3 (AP, PO, GL, INV, WIP, Forms, Reports 6i, Discoverer 4i), ADI, Workflow, Workflow Builder 2.5, Oracle 9i, SQL, PL/SQL.