OBJECTIVE

• To utilize my extensive system & business process experience as a Functional Consultant / Testing Lead for successfully implementing, testing and supporting Oracle Applications in Financial and Supply Chain Management domains. (Inventory, Order Management, Procurement, Shipping, General Ledger, Accounts Receivables, Accounts Payables,)

SUMMARY

• Seven years of IT experience as an Oracle Applications Functional Consultant/ Testing Lead in Financial and Supply Chain Modules.
• Good understanding of business process operations, organizational assessment and translating them into functional requirements and test cases.
• Strong Oracle Applications experience with testing, deploying the solution.
• Expertise in handling the testing phases for multiple releases of an implementation.
• Skills in leading small to medium sized teams and efficient in Project Management.
• Strong understanding of the day to day Business processes carried out by major companies in their Legacy Systems and mapping them to Oracle ERP solution.
• Proven experience in understanding the Quality Requirements for the solution to be deployed within the time frame.
• Solid understanding of Software Development Life Cycles (SDLC)
• Involved in Project planning phase for Quality Assurance and Controls.
• Experience in setting deadlines, deliverable activities and testing exit criteria.
• Good knowledge of Inventory Control, Order to Cash (O2C) and Procure to Pay (P2P) business cycles.
• Expertise in business process analysis, requirement analysis (AS - IS) system, (TO-BE) mapping, CRP testing, Integration testing, UAT, system configuration, data conversions, master data loading, regression testing, Go-live support, production support.
• Good experience in implementation process mapping, functional requirement analysis, GAP analysis, post implementation production support, training business users (development of training material), presentations, testing and documentation
• Effective communication & experience in various projects using MS Project, MS Excel, and MS Visio
• Expertise in implementing the projects and performing thorough testing during the User Acceptance phase of the project.
• Good experience in providing user training after the acceptance of the application.
• Trouble-shooting user problems during the go-live phase.

TECHNICAL SKILLS

Modules: Oracle Order Management, Inventory, Procurement, Shipping, General Ledger, Accounts Payables, Accounts Receivables

ERP: Oracle Applications R12 (R12.1.2) 11i (11.5.8, 11.5.9, 11.5.10)

Testing Tools: HP Quality Center, HP QTP, Test Link.

Oracle Tools: Data Loader, SQL Loader, TOAD

Document Management Tools: IBM Clear Case, IBM Clear Quest.

Programming Languages: SQL, PL/SQL, C / C++

Databases: MS Access, Oracle 10g

Software Packages: MS Office, MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh PA

Oracle Functional Consultant

Responsibilities:

• Working as Coordinator for Global Implementation of Oracle Applications.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD) and Functional Testing Documents.
• Coordinate activities related to requirements gathering, solution design, testing, documentation, and support.
• Understand the business requirement, documenting the same and translating it to business solution as per the users’ expectations.
• Perform the AS-IS, Gap Analysis, create BR100, MD050, CRP execution and user training material.
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Conducted comprehensive user training with super users and users on Oracle Order Management and Shipping Execution
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, Workday calendar, locations, freight carriers, item parameters etc
• Involved in Full-Cycle Implementation of Oracle Modules: Order to cash cycle Order Management, Inventory and P2P.
• PO: Setup Suppliers, Approved Supplier List, Sourcing Rules, Employees, Jobs, Approval Groups, Assigned Approval Groups, Document Types, and Purchasing, Receiving and Financial Options.
• Lead a team of 10 testers in the GL, AP, AR, Purchasing, OM modules.
• Responsible for understanding the existing business processes and translating them into Test Cases.
• Worked on test plans with the PMO on sequencing, prioritizing the test cases based on the time frame for completing the testing.
• Prepared Regression testing plans to retest the critical functionalities.
• Excellent command on HP Quality Center 10.0 for loading the test plans, test cases and defect management.
• Performed Unit Testing of the new business objects introduced.
• Responsible for generating the daily testing status reports in the work streams and discussing them with the business.
• Worked on testing the Business Critical Reports and resolving the issues encountered while testing with the technical team.
• Worked as a liaison with the process team, test team, technical team to assign the defects to the technical team by providing sample log files when ever any concurrent program or a process errors out.
• Performed extensive testing on custom interfaces, extensions built per the functional design.
• Responsible for maintaining and managing the defect workflow in HP Quality Center.
• Tested the Data Models built by sourcing data from ERP using Informatica.
• Experience in testing the SOA middleware applications used to pull the files from Legacy Systems and place it in the Oracle Applications via interfaces.
• Worked with the OBIEE (Business Intelligence) team by providing them with the test cases from an ERP standpoint.
• Worked with the Business Super Users in educating them with the process and User Acceptance Test testing plans.
• Worked on configuring the Deployment instances to make sure the UAT testing happens smoothly.
• Assisted in preparing the training manuals involved in a release.
• Responsible for documenting the Business Workaround Documents in IBM Clear Case.
• Responsible for assigning the deliverable activities in IBM Clear Quest.
• Worked closely with the Business to understand any changes to the Business Processes by logging in change requests to the FDD’s and altering the test cases accordingly.
• Helped in creating the performance test scripts to assess the performance of the system before go-live.
• Strong working knowledge on TOAD for Oracle and used it extensively while testing.

Confidential, San Antonio, TX

Oracle Functional Analyst

Responsibilities:

• Analyzed the existing business process flows in Manufacturing and Supply Chain Management.
• Analyze TO - BE business process flows by performing GAP analysis in the business requirements and mapping it to oracle apps functionality.
• Key in Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD) and Functional Testing Documents.
• Coordinate activities related to requirements gathering, solution design, testing, documentation, and support.
• Understand the business requirement, documenting the same and translating it to business solution as per the users’ expectations.
• Worked directly with end users to document the business processes & functional requirements also providing them with training materials
• Perform the AS-IS, Gap Analysis, create BR100, MD050 and created appropriate test scripts.
• Excellent coordination with offshore technical resource and got all deliverables in place on time.
• Successfully executed CRP execution and GO LIVE
• Responsible for creating, Internal Purchase Requisition/ Sales Order and complete Order Cycle setups from order entry to ship confirm to support business requirements
• Interacted extensively with the BPO’s and formulated strategies and analyzed gaps to streamline the usage of existing Oracle ERP.
• Studied and modified the existing BR 100 documents by doing gap analysis.
• Modified the existing set-ups in the Dev. Instance for Manufacturing and Supply Chain Management modules.
• Dealt with major Non-Oracle applications like Clear Orbit (Printing and Labeling Software), Vastera (Customs Software).
• Lead the Manufacturing and Supply Chain Management team.
• Upon successful implementation of the modified business process, prepared test cases and handed over to the testing team.
• Coordinating with the testing team on the necessary changes and modifications to be made.
• Post-production support for the BPO’s in Inventory, Order Management, Purchasing, BOM, MRP/MPS.
• Worked on open-source test case repository software titled ‘Test Link’ and maintained the test case repository to facilitate the testing team.

Confidential, Austin, TX

Oracle Supply Chain Analyst

Responsibilities:

• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Setting up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module for business transformation phase
• Performed setups for drop shipment process & split shipments related to Dual Build / Dual Pickup points for both Austin & Singapore mfg unit in Order Management.
• Responsible for building and maintaining the test-repository containing the test plans and test cases.
• Analyzed business requirements & performed Gap Analysis to map user requirements to oracle apps functionality & performed prototyping of “To Be” business process flows
• Setting up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module for business transformation phase
• Incorporated a new consolidation center, added new pickup location, order types in Order Management to fulfill the requirements.
• Defined Pricelists, Modifiers, Qualifiers, for different orders and customers in Advanced Pricing. Modifiers include discounts, freight discounts and point price breaks
• Worked in a team in understanding the integration of Advanced Pricing with OM process
• Documented the new business processes & functional requirements & also provided with training materials to the business users.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management, & Advance Pricing modules
• Participated in the User Acceptance Testing (UAT) Planning.
• Provided onsite training to the business users about the new procedure developed for the business transformation phase in Order Management, & Advance Pricing modules
• Participated in the User Acceptance Testing (UAT) Planning.
• Designed the UAT test cases for various scenarios.
• Executed User, Integrated, and System Level testing with the technical team before the UAT planning.
• Resolved the issues/bugs while the UAT and documented the same for further reference.
• Provided user support in the live phase

Confidential, Miami, FL

Oracle Functional Consultant

Responsibilities:

• Studied the existing business process & conducted meetings on client business overview
• Analyze TO - BE business process flows by performing GAP analysis in the business requirements and mapping it to oracle apps functionality.
• Preparing of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD) and Functional Testing Documents.
• Perform item mapping from legacy system and vendor catalogs into Oracle to define new items and categories.
• Implemented Configure to Order, according to customers’ needs.
• Define Inventory, Order Management and Advanced pricing related setups.
• Responsible for implementation of order to cash cycle and P2P.
• Worked on ATO, PTO and CTO according to client needs.
• Work on setting up order verification holds and new customer credit check holds in Order Management.
• Perform setups for back to back order process, drop shipment process, RMA process, shipping parameters with Order Management and BOM.
• Setups for procure to pay cycle from entering a purchasing requisition to receipts and invoice creation in account payables module.
• Update item master for blanket purchase agreements and quotations, apply sourcing rules and release generation method to the imported item.
• Set up of complete Order to Cash cycle setups from order entry in order management to ship confirm in shipping execution module.
• Done setups for Qualifiers, Modifiers, formulas and Price Lists in Advanced Pricing concurring to the company’s pricing policies.
• Build test scripts & conducted CRP testing for Order to Cash cycle.
• Use SQL extensively to validate the data in Oracle Database.
• Assisted a project team in understanding the integration of Purchasing with iProcurement
• Worked with end users to document the business processes & functional requirements also providing them with training materials

Confidential, Daytona, FL

Business Analyst / Oracle Functional Consultant

Responsibilities:

• Performed solution pilot covering prototyping of “To Be” business process flows by analyzing the gap in the business requirements & then mapping it to oracle functionality
• Worked on setting up order verification holds and new customer credit check holds in OM
• Performed setups & did integration testing for split shipment, drop shipment process, RMA process, shipping parameters with Quoting, Order Management & custom made ‘Scheduling & Dispatch’ modules
• Perform on-site deployment activities for oracle solution for Inventory, Order Management, Quoting modules & custom solutions including ‘Scheduling & Dispatch’.
• Performed Item Mapping from legacy system and vendor catalogs into Oracle to define new items & categories
• Performed configuration setup of custom module ‘Scheduling & Dispatch’ & facilitated user validation.
• Setting up of complete Order to Cash cycle setups from Quoting & order entry in order management to ship confirm in shipping execution module
• Developed test scripts & conducted CRP testing for the Order 2 Cash cycle
• Involved in the deployment cycle for Item Mapping, Production Cutover activities, helping the Pilot divisions to Go-Live, & user support in live phase
• Documented new procedures & Involved in training the business users on the new processes and also assisted them during their on-job training exercise.
• Worked on Data Generator to generate large volumes of custom data, populating databases.
• Participated and executed all phases of UAT: The test plan, developing test cases, documenting the test logs, and user sign-off.

Confidential, Chicago, IL

Functional Consultant

Responsibilities:

• Prepared business requirement documentation by analyzing new business process design, requirements analysis, and solution design using oracle AIM methodology
• Part of a business transformation project team and assisted the end-users in the functional configuration of Order Management and Inventory modules
• Involved in a feasibility analysis of integrating oracle functionality and legacy system
• Analyzing the parameters involved in physical inventory and cycle counting, and setup of ABC classes for teams to aid in implementation of counting methodology
• Analyzed the need for sub inventories, stock locators & setup shipping networks transfer
• Performed organizational set ups including inventory organizations, item categories, product catalogs, locations, freight carriers, item parameters etc
• Responsible for defining and setting up complete Order Cycle setups from, order entry in order management to ship confirm in shipping execution module to support business requirements
• Performed setups for process involving split shipment process, drop shipment process, RMA process, in Order Management.
• Performed setups for shipping parameters like picking rules, pick slip grouping rules, release sequence rules for Order Management
• Conducted CRP and Integration testing for related modules
• Maintain issue tracker and coordinated with the team for debugging
• Involved with user acceptance testing (UAT) and end user training
• Prepared and provided comprehensive training materials and practice exercises

Confidential, Houston, TX

Oracle Functional Consultant

Responsibilities:

• Rendered post production support in Purchasing and Order Management modules to the client
• Provided first point of contact customer support during business and non-business hours to meet customer support response time commitments
• Analyzed issues and closed calls with minor assistance from other Tier 1 & Tier 2 teams
• Trouble shoot problems pertaining to Purchase Order, Requisition, user access, notifications, suppliers set-up, punch-out sites, payment options, and buyer activities
• Participated in the configuration, implementation and testing of new client rollouts
• Research the implementation issues on Metalink and, if needed, open a TAR with Oracle for critical issues
• Worked on user’s menus and functional set-up and provided training to the end users
• Tested and implemented the requested changes in existing setups
• Participated in ongoing process enhancements and modification requests
• Involved in training users on applications usage and developed necessary documents
• Prepared standard operating procedure for modification / changes to the setup documents

Confidential, Hutchinson, KS

SCM Functional Consultant

Responsibilities:

• Analyzed the current business process and did the requirement gathering for Work In Process (WIP) and Bills of Material (BOM) modules
• Reviewed the implication of the functional decisions being made during the setup processes
• Performed a walk through of the To-Be business process flows
• Documented the functional requirements for data conversion and historical data incorporating industry best practices and standards
• Worked with full life cycle like creation of Items, creation of BOM structure, assembling in WIP and copying to Multi-Org
• Setups of Bills of Material parameters, department classes, resources, locations, WIP accounting classes and options
• Mapping the transactions relevant for client and ascertaining workarounds
• Application setups review to make existing business processes work
• Documented the AS-IS, training material and operating procedures
• Conducted Integration Testing and User Acceptance Testing

Confidential, Piscataway, NJ

Functional Consultant

Responsibilities:

• Provide post-production support for Inventory, Bills of Material and Work In Process applications
• Rendered support for researching, troubleshooting and testing product problems and client configurations
• Involved in training end users on application usage and developed the necessary documentation
• Worked closely with the development team on all application enhancement requests and bug fixing
• Tested the system functionality after scheduled upgrades and customizations
• Co-ordinate with oracle support on various TAR’s on a periodic basis
• Handled customer requests with respect to system enhancements, testing and maintenance
• Involved in creating manuals, test scripts, best practice proposals for Inventory, Bill of Material (BOM) and Order Management
• Actively participated in all the application enhancement requests and received excellent feedback from the client