SUMMARY:

• 8.9 years of Experience in IT wif Expertise in Oracle Applications Expertise in Oracle E Business Modules PO, me - Procurement, MSCA, Costing, MRP, ASCP, APCC, VCP, Capacity Planning, Advance Pricing, INV, BOM, WIP modules.
• Extensive experience wif Reverse Logistics and Logistics process including integration wif 3PL Logistics systems
• Extensive experience wif the RMA Process - Return from Vendor, Return from Customer, Retail Returns, Return wif Replacement, Return wif Exchange, Return wif Repair, Containerization, Bar Code Scanning, etc.
• Experience wif Agile Product Life Cycle Management (PLM)
• Extensive experience wif Order to Cash and Procure to Pay Business flows.
• Good working knowledge in Oracle AIM Methodology. Handled Service Requests (TARs) wif 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.
• 1 Full life cycle wif Oracle Fusion Cloud R13 - Fusion Cloud OM, Supply Chain Orchestration, Order Management Orchestration, Inventory Management, Pricing, Procurement Cloud
• Extensive experience wif EDI Standards and e-Commerce Gateway.
• Worked on the data mappings, fixing errors, design specifications around the e-Commerce gateway including the following mappings - EDI 810 Invoice inbound, 850 Inbound Purchase Order, EDI 852 Product Activity Data for transmitting POS Data, EDI 832 Price/Sales Catalog, 843 Inbound Response to RFQ, 856 ASN (Shipping) inbound and outbound
• Worked on Rosetta Net PIPs - 3A1, 3A4, 3A10, 3B2, 3B5, etc.
• 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 wif 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 wif excellent interpersonal and communication skills.

PROFESSIONAL EXPERIENC:

Confidential, Orange County, CA

Oracle Fusion Cloud SCM Functional Analyst

Responsibilities -

• As a SCM Functional Analyst supported the Oracle Fusion Cloud R13 modules: Fusion Cloud OM, Supply Chain Orchestration, Order Management Orchestration, Inventory Management, Pricing, Procurement Cloud
• Worked on the Functional Setup Manager to configure Fusion Cloud OM, Supply Chain Orchestration, Order Management Orchestration, Inventory Management, Pricing, Procurement Cloud
• Worked on configurations of Order Management Cloud module - defining Back to Back order process, Drop Ship Process, IRISO process, RMA Process, RMA wif Depot Repair integration
• Worked on Modifiers and Qualifiers setups in Oracle Advance Pricing.
• Worked on configuring the Primary and Secondary price lists in Oracle Advance Pricing.
• Worked on setting up price breaks in Oracle Advance Pricing.
• Defined the coupons for discounts in Oracle Advance Pricing.
• Used the Get Custom price API for publishing price to an external system in Oracle Advance Pricing.
• Worked on Oracle Inventory module - setting up Item Master, Defining Item Attributes, Item Templates, Item Categories, Item Catalogs, Min Max and Re-Order point planning, Cycle Counting, Physical Inventory, etc.
• Worked on the setups of the Material Resource Planning (MRP) module - setup planning parameters, plan options, etc.
• Worked on Landed Costs, Average Costing and Standard Costing in Oracle Costing.
• User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Created test scripts for UAT (User Acceptance Testing) and helped technical team in testing their all developments in lower instance before migrating them to production.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.

Environment - Oracle Fusion Cloud R13 Rollout for US, Mexico, Latin America, China and UK Module OM, Scheduling, Planning, Sourcing, WIP, Logistics, Shipping and PO, INV

Confidential, Ada, MI

SCM Functional Consultant

Responsibilities -

• As a SCM Functional Consultant implemented the following modules OM, Advance Pricing, Shipping (Logistics), Reverse Logistics, INV, BOM 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 APCC Module configurations of Plan Parameters, Scenario based planning, defined the dimension model and measures, worked on the supply chain dashboard, setup page level filters, defined the resources pages, worked on scenario analysis, etc.
• Worked on the configuration of Value Chain Planning (VCP) including Global Order Promising and Inventory Optimization.
• Worked on Oracle ASCP module - setting up the Source definition, Destination definitions plan parameters, supply and demand sources, etc.
• Worked on the configuration of the MSCA Module.
• Worked on the collection process in ASCP
• Worked on the creating the ATP Flex fields
• Created the routing and BOM for Make Items
• Creating of the ASCP Plans
• Worked on the integration of the Logistics process wif 3PL Logistics system (FedEX)
• Worked on the Functional mapping of data Conversions & Enhancements for PO, me-Procurement, ASCP, APCC, VCP, 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 wif 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 wif 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 wif detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided wif useful training to the users in PO, me-Procurement, ASCP, APCC, VCP, 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, Houston, TX

Oracle SCM Functional Consultant

Environment: Oracle applications R12 (Technology: PO, PO, me-Procurement, APCC, Costing, ASCP, VCP, Advance Pricing, INV, BOM, WIP, Localizations for Europe and China)

Responsibilities -

• As a SCM Functional Consultant implemented the Business flows including OM, ASCP, APCC, VCP, INV, BOM, WIP Modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for OM, ASCP, APCC, VCP, INV, BOM, WIP modules
• Worked on Oracle the APCC Module - defined the Plan parameters, setup the plan options, defined the scenario based planning, setup the supply chain dashboard, etc.
• Worked on the configuration of the Value Chain Planning (VCP) module.
• 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 mapping and data corrections for the Rosetta Net 3A1 (RFQ), 3A2 (Request Price and Availability), 3A4 (Request PO), 3A13 (Notify of PO Info), 3B2 (ASN), 3B11 (Shipping), 3C1 (RMA), 3C3 (Invoice) for interfacing wif suppliers and customers.
• Worked on the configurations of the RMA process in oracle OM – RMA wif Receipt, RMA w/o Receipt, RMA for Repair, RMA for Replacement, etc.
• Worked on the Functional Mappings for data conversion from 11i to Release 12 for PO, Costing, Advance Pricing, INV, BOM, WIP modules
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif 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, CA

SCM Functional Analyst

Responsibilities:

• Worked on the setups for the PO, me-Procurement, OM, Shipping (Logistics/Reverse Logistics), Advance Pricing, INV, BOM, WIP Modules
• Preparing BR30, BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on the following EDI Interfaces –850 – PO Inbound and Outbound, 855 – PO Acknowledgement, 856 – Advance Shipment Notice inbound and outbound and 860 – PO Change inbound and outbound
• Worked on the setups of the Inventory module.
• Worked on the Reverse Logistics - 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, NJ

SCM Functional

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 wif 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 OM, AR, INV, BOM Modules.
• Written standard Integration test scripts for OM, AR, INV, BOM Modules.
• Worked on the setups and conversions of OM, AR, INV, BOM Modules
• Submitted weekly status updates and reports showing the progress of Software Testing.
• Responsible for validating the back-end data dat 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 dat were defined.
• Tested a patch dat we had applied for the Revenue Recognition process.
• Performed Standard Functionality testing OM, AR, INV, BOM.
• Was involved in Standard Functionality testing in Phase me and Phase II for 3 instances.
• Tested Multi-Org Setups as a result of the new Parts Operating Unit dat 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 wif Developers team for different issues

Environment: Oracle (OM, AR, INV, BOM) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential, San Jose, CA

SCM Functional Analyst

Environment: Oracle applications R12 (Technology: AR, Cash Management, AP, GL, me-Procurement, me-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 OM, AR, INV, BOM 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 wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Setup the OM, AR, INV, BOM 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) wif 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 wif 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, Sunnyvale, CA

SCM Functional Analyst

Environment: Oracle applications R12 (Technology: AR, Cash Management, AP, GL, me-Procurement, me-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:

• Implemented the following modules: Inventory, Order Management, BOM, Shipping, Advance Pricing
• Worked on the Functional mapping of data Conversions & Enhancements for Inventory, Order Management, BOM, Shipping, Advance Pricing modules
• Worked on the mapping and data corrections for the Rosetta Net 3A1 (RFQ), 3A2 (Request Price and Availability), 3A4 (Request PO), 3A13 (Notify of PO Info), 3B2 (ASN), 3B11 (Shipping), 3C1 (RMA), 3C3 (Invoice) for interfacing wif suppliers and customers.
• Worked on the Inventory module – defining the System Items, Category, Catalog, Sales Order, Account Alias flex fields.
• Worked on setting up Min Max and Re Order Point planning in Oracle INV module
• Worked on the ABC Analysis, Cycle counting and Physical Inventory of INV Module
• Worked on the setups of Transaction Types and Move Order process in Oracle INV module
• Worked on setting up the BOM module – defining the Multi Level BOMs, Routing, Alternate BOMs, setting up resources, departments, assigning resources to departments, defining the BOM Parameters, etc.
• Defined the rates, regimes, rate to regime flows for tax calculation me oracle e-business tax module.
• Worked on the setups of OM Module – defining Processing Constraints, Credit Check rules, setting up defaulting rules, Transaction Types, Header and Line workflows, etc.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Configured Inventory, Order Management, BOM, Shipping, Advance Pricing modules from scratch and simultaneously created BR100 documentation for the setups.
• Involved in troubleshooting issues on Transaction Import Program in Oracle INV module.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided wif useful training to the users in Inventory, Order Management, BOM, Shipping, Advance Pricing modules

Confidential, San Francisco, CA

SCM Functional Consultant

Responsibilities:

• Provided Information to User leads about new enhancements / features
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the customizations, in Processes, Programs, and Reports.
• Performed all of the setups and configurations for Inventory, Order Management, BOM, Shipping, Advance Pricing Modules.
• Worked on customizing as well as developing new Workflow processes.
• Providing necessary Training to User Leads and Users on Enhancements
• Worked on testing of the 11.5.10 instance from end to end including enhancements and extensions.
• Tested several patches dat were applied to the 11.5.10 instance for functionality as well as performance.

Confidential, Cleveland OH

Oracle Financial Functional Consultant

Responsibilities:

• As a O2C Business Analyst implemented the following modules: Inventory, Order Management, BOM Shipping, Advance Pricing, AR
• Worked on the Functional mapping of data Conversions & Enhancements for OM, INV modules.
• Preparing BR100, MD050, TE40, TE50, CRP execution, User training and coordinating wif technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Worked on Inventory setups – defining the Organization Structure, defining the Sub Inventories, Catalogs, Categories, Planning (Min Max and Re Order Point Planning), Defining Cost Groups, ABC Analysis, Cycle Counting, Physical Inventory
• Worked on BOM Setups – defining the resources, resource usages, resource cost rollups, setting up routing, defining departments and assigning resources to departments, setting up BOM Parameters, etc.
• Worked on data mapping, design, file structure validation, e-Commerce Gateway configurations for EDI transactions like 810, 852, 832, 826, 850 file formats
• Worked on the setups of the e-Commerce gateway setups – defining the data file directories, trading partner data, defining code conversions and e-Commerce profile options, etc.
• Worked on the setups of OM Module – Defining the order and line workflows, defining the transaction types, setting up Processing constrains and Defaulting rules.
• Involved in troubleshooting issues on Item Import Program In oracle INV module
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation wif detailed testing of all the above modules.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided wif useful training to the users in Inventory, Order Management, BOM, Shipping, Advance Pricing, AR Modules.

Environment: Oracle Apps Release 11.5.10 e-Business suite (Inventory, Order Management, BOM, Shipping, Advance Pricing, AR)

Confidential

Oracle Apps Functional

Responsibilities:

• Defined Accounting Flex field Structure, Security Rules, Assigned Security Rules Setup, Define Cross-Validation Rules.
• Defined Period Types, Accounting Calendar, Currencies, Conversion Rate Types, Enter Daily Rates, Set of Books.
• Performed all the setups for PO, AP, CM, Project Accounting (Costing, Billing), FA, INV, me-Procurement, me-Expense
• Defined Journal Sources, Journal Categories, Shorthand Aliases
• Implemented Oracle Cash Management for Bank reconciliation.
• Performed Bank Reconciliation.
• Trained users on Cash Management and General ledger.
• Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
• Writing and executing detail manual test scripts in Mercury Test Director.
• Developed input test data and expected results for test plans.
• Researched testing errors for resolution and documented all defects in detail wif attachments, before passing on to the senior business analysts for further review.
• Interacted wif the end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10