SUMMARY:

• 9.2 years of Experience in IT with Expertise in Oracle Applications Expertise in Oracle E Business Modules PO, I - Procurement, 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.
• 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 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, Philadelphia, PA

Oracle SCM Functional Consultant

Responsibilities:

• As a SCM Functional Consultant implemented the following modules ASCP, Demantra, 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 Return to Vendor Process, return with Repair, return with Exchange, Return for Credit, Bulk Return, 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 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, Advance Pricing, ASCP, Demantra, 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, Fresno, CA

SCM/Planning Functional Consultant

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

Responsibilities:

• As a SCM/Planning Functional Consultant implemented the Business flows including ASCP, Demantra, PO, i-Procurement, Advance Pricing, INV, BOM, WIP Modules.
• Performed Requirement and Gap analysis.
• Configurations and Setups for ASCP, Demantra, PO, i-Procurement, Advance Pricing, INV, BOM, WIP modules
• 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 with suppliers and customers.
• Worked on the configurations of the RMA process in oracle OM - RMA with 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 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, Emeryville, CA

SCM Functional Analyst

Responsibilities:

• Worked on the setups for the PO, i-Procurement, OM, Shipping (Logistics/Reverse 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.
• 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, Sunnyvale, CA

SCM Functional

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 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 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 OM, AR, INV, BOM.
• 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 (OM, AR, INV, BOM) Oracle 10g/9i, SQL, PL/SQL, Developer 6i (Report 6i & Forms 6i), Toad 8.1.6, Workflow 2.6.

Confidential

SCM Functional Analyst

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 with 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) 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

SCM 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:

• 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 with 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 I 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 with 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 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 Inventory, Order Management, BOM, Shipping, Advance Pricing modules