We provide IT Staff Augmentation Services!

Oracle Ebs Functional/test Analyst Resume

Sacramento, CA


  • A SCM/Finance/CRM Functional and Test Analyst with specialization in Financials and Distribution Systems having around 8.8 years of industry experience which revolves around Oracle ERP and CRM Applications - Implementation, Support and Upgrade and has also worked on successful e-business suite implementations (Oracle EBS 11.5.10/R12)
  • Hands on experience with all phases of Software Development Life Cycle. Involved in entire QA Life Cycle, which includes Designing, Developing and Execution of teh entire QA Process and Documentation of Test Strategy, Test Plans, Test Cases, Test Procedures and Test Scripts for ERP Applications, Java/J2EE, Web based and Client/Server applications.
  • Extensive experience with MS Visual Studious Test Suite.
  • Experience in Testing involved in Unit Testing, Functional Testing, Performance Testing and Regression Testing
  • Hands on experiences in Automation Tools like Quick Test Pro 9.5, Load Runner 8.0.1. Test
  • Director 8.0/ Quality Centre 9.2, Win Runner 8.2.
  • Extensive experience with Oracle Application Testing Suite (OATS)
  • Conversant with Oracle Financials modules and Distribution Modules - Quoting, Advance Pricing, OM, INV, Costing, Purchasing, i-Procurement, Oracle Lease and Finance Management (OLFM), i-Supplier, i-Expense, Supplier Hub, AP, INV, GL, SLA, E-Business Tax modules
  • Extensive experience with CRM Modules of Service Contracts and Install Base.
  • Understands both teh “Quote to Cash” process as well as teh “Procure to Pay” process. Conversant with Configuring Oracle Application modules as well as understands teh underlying schema, which gives her a better insight into converting user requirements into functional and technical specifications.
  • Experience with e-Commerce Gateway and EDI Transaction 850, 855, 856, 810, 843, 820 formats
  • Actively responsible for testing of teh functionality of Oracle ERP Application Well conversant with documentation as per teh AIM methodology, involved Conference Room Pilots and User Acceptance Testing.
  • Well-rounded knowledge of Oracle Applications functionality
  • Designed, created and administered company training programs and materials
  • Influential leader and skilled negotiator, successfully presenting strategic high-impact technology proposals and project plans to executive management to achieve buy-in
  • Strong mentor and coach, skilled at inspiring confidence, leading by example and building loyal, high-performance teams dat exceed expectations


Confidential, Sacramento, CA

Oracle EBS Functional/Test Analyst

Responsibilities -

  • As an Functional/Test Consultant implemented teh following modules OM, INV, PO, OLFM, Advance Pricing, Shipping modules.
  • Worked on teh Functional mapping of data Conversions & Enhancements for: OM, INV, PO, OLFM, Advance Pricing, Shipping modules.
  • As a Functional Consultant implemented financial modules: Order Management, Inventory, Accounts Receivables Release 12 of Oracle e-Business Suite.
  • Worked on a GAP Analysis and prepared functional documents for teh GAPs identified
  • Worked on testing teh setups of Oracle Lease and Finance Management (OLFM) - configured teh Lease Contract Authoring, Lease Booking and Lease Funding, Rebook, Transfer and Assumption, Renewal of Lease, Release of Lease, Upgrade of Lease in Oracle OLFM
  • Worked on teh Auto Invoice and Auto Lock Box in AR module.
  • Performed all teh setups and configurations for AR module.
  • Worked on teh setups OM, INV module
  • Implemented TCA in Oracle AR Module
  • Implemented Outbound interfaces for INV, AR and OM 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.
  • Involved in troubleshooting issues on Auto Invoice Import Program.
  • Development and implementation of Test cases, Test plans, Test data and Test scripts according to teh requirements within an Agile/Scrum methodology.
  • Responsible for identifying/testing setup items for different functional areas in Oracle Order Management, Service Contracts, Install Base, OLFM, Inventory, Purchasing, Accounts Receivables modules.
  • Integration Topics:
  • Outbound Point of Sale Integration from Point of Sale system to Oracle ERP
  • End to End Functional Testing of Point of Sale System
  • Inbound Sales Order Transaction and Inventory Transactions Integration from Oracle ERP to Point of Sale System
  • Worked on teh Oracle Application Testing Suite (OATS) module - Test Manager, Load testing.
  • Worked on developing automation scripts using open scripting in Oracle Application Testing Suite (OATS)
  • Worked on teh technical scripts for Automation Testing in OATS
  • Extensive experience with testing of EDI Transactions like 810, 823, 856, 823
  • Tested teh X12 maps 850, 856, 810, 810, 820 & 997
  • Executed SQL Queries to verify teh dataflow from teh backend.
  • Used teh MS Visual Studious Test Suite for executing automated tests.
  • Involved in intensive testing of Interface programs, which move teh legacy data to Oracle tables.
  • Tested teh OM, INV, PO, BOM, Costing, OLFM, Advance Pricing, Shipping Closing/Month end process across all teh modules
  • Created Requirements using Quality Center and generated trace ability Matrices to ensure dat all teh requirements are covered by teh test cases.
  • Keeping Track of Defects in HP Quality Center.

Confidential, Minneapolis, MN

Oracle EBS Test Analyst

Responsibilities -

  • Tested teh modules of OM, INV, PO, BOM, Costing, Advance Pricing, OLFM, Shipping
  • Tested EDI Transactions like EDI 810 823, 850, 860
  • Tested teh mapping for all teh EDI transactions
  • Worked on teh Oracle Application Testing Suite (OATS) module - Technical Testing, Test Manager, Load testing.
  • Developed automation scripts using Open Scripting using OATS.
  • Maintaining test cases, analyzing defects, tracking bugs and working for teh closure of bugs.
  • Delivering and implementing teh project as per scheduled deadlines; extending post-implementation and maintenance support to teh client.
  • Coordination with Business teams.
  • Additionally, played test lead role for supporting customizations from Onshore.
  • Test estimations for teh CR’s dat are raised during testing.
  • Status reporting (productivity sheet, Daily/weekly status report, test summary report, monthly metrics report
  • Worked on testing of teh setups of OLFM like - Lease and Finance management accounting options, account method builder, lease and finance management event model, accounting sources, default account codes for OLFM, SLA Rules for OLFM, etc.
  • Tested Advance Pricing Module - defining modifiers, qualifiers, price lists, price breaks, custom attributes for pricing, price mapping, etc.
  • Tested teh Order to Cash flows.
  • Tested teh INV module including teh Item Catalogs, Catalogs, categories and Types, Item structures, document management, defining roles and implementing role-based security.
  • Testing of ABC codes, Cycle counting and Physical Counting.
  • Responsible for teh complete setup and implementation of Oracle OM, AR, Shipping, Advance Pricing modules
  • Defining and setting up of complete Order to Cash cycle setups
  • Worked on teh setups of teh i-Procurement module - Setting up teh Punch-out’s, catalogs, categories, content based security, etc.
  • Worked on teh setups of AR Module - Including defining of teh Auto Invoice Process, Auto Lock Box and Revenue Recognition Process.
  • Worked on teh setups of teh TCA in teh AR module
  • Worked on teh Configuration of teh INV module including setting up of teh Item Catalogs, Defining Catalogs, defining change categories and Types, Defining Item structures, setting up document management, defining roles and implementing role-based security.
  • Responsible for teh implementation AME Module for Approval process.
  • Worked on teh Inbound Purchase Order (POI/850/Orders)
  • Worked on setting up Trading Partner Link to e-Commerce Gateway
  • Worked on teh Inbound Purchase Order Change (POCI/860/ORDCHG)
  • Worked on teh Inbound Invoice (INI/810/INVOCI)
  • Worked on teh Inbound Shipping Notice/Manifest (ASNI/856/DESADV) and Inbound Shipping and Billing notice (SBNI/857/No EDIFACT)
  • Studied teh existing business process & conducted meetings on client business overview
  • Performed Gap Analysis so as to map teh business requirements to oracle functionality
  • Performed solution pilot covering prototyping of “To Be” business process flows
  • Prepared business requirements documents for Shipping, Pricing & OM
  • Created requisition templates, approval hierarchy, sourcing rules, approved suppliers list
  • Performed organizational set ups including inventory organizations, locations, freight carriers, items, parameters etc.
  • Worked on teh Item Master Setups in Inventory module, defining of item templates, categories, catalogs, defining item attributes, enabling items in various organizations, controlling item attribute changes by implementing controls, etc.
  • Defined product catalogs and categories in Inventory module

Confidential, Seattle, WA



  • Tested entire Quote to Cash process including teh modules of Quoting, OM, AR and Advance Pricing
  • Tested teh OM, INV, PO, OLFM, Advance Pricing, Shipping modules
  • Analyze business processes, work with users to determine/clarify requirements, and prepare Functional Specifications to address technology solutions for meeting business requirements. Work with teh users to review, incorporate feedback and obtain approvals for teh Functional Specification.
  • Tested EDI Transactions of 810, 856, 823, 860
  • Tested Modifiers and Qualifiers in Advance Pricing
  • Tested custom attributes for pricing in Advance Pricing and attribute mapping
  • Tested dynamic formulas in Advance Pricing using custom attributes.
  • Tested Automatic Discounts and Surcharges in Advance Pricing
  • Tested volume based discounts in Advance Pricing
  • Tested Price Breaks in Advance Pricing
  • As a SCM Functional Consultant implemented teh Business flows including Oracle OM, Shipping, Advance Pricing, Quoting, AR modules.
  • Worked in teh configuration of teh AR module.
  • Performed Requirement and Gap analysis.
  • Configurations and Setups for Oracle OM, Shipping, Advance Pricing, AR module
  • Worked on teh Functional Mappings for data conversion from 11i to Release 12 for all Distribution and Financials 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.
  • Worked on teh EDI Transactions for Inbound and Outbound PO, Inbound Sales Order, Inbound Invoice, etc.
  • Worked on setting up teh Approval Hierarchies in AME Module.
  • Implementation of Electronic Funds Transfer (ACH and Wire) FT for US and Canada
  • Pre-upgrade testing and Post upgrade production live support.
  • Performed all teh steps for Oracle OM, AR, Shipping, Advance Pricing, Quoting modules.
  • Worked with teh Business team to baseline teh ‘As Is’ Process and derive ‘To Be’ flow.
  • Worked on teh entire integration strategy to update it into teh current AS IS system.
  • Flow Testing for SCM Modules (Oracle OM, Shipping, Advance Pricing, Quoting, AR) to make sure flow is working without any issues.
  • Conducting Pre-Project Review & Post Project Review.
  • Managed teh complete testing activities SIT, UAT and Oracle QA.
  • Obtained and signed off documents and tests from Oracle ERP side.
  • Providing Post Implementation support
  • Worked for teh Category & Mapping data migration to meet teh go alive deadline.
  • Jointly worked with teh QA team in formulating teh Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.
  • Environment: i-Procurement, AR, Purchasing, Procurement Contracts, Advance Pricing, Quoting, Service Contracts, Install Base, ASCP, GOP, EDI, I-Supplier, i-Procurement, BOM, Order Management, Accounts Receivables, Shipping, Inventory modules

Confidential, Mountain View CA

Oracle SCM Functional Test Analyst


  • As a Functional Test Consultant tested teh Business flows including OM, PO, INV, WIP, Costing, Advance Pricing, Shipping, AP, AP, GL, Service Contracts, Install Base modules
  • Tested teh Functional Mappings for data conversion from 11i to Release 12 for all Manufacturing modules.
  • Tested teh i-procurement module setup of Punch Outs, Relam’s, setting up of catalogs, Item cross referencing, receiving functionality, etc.
  • Tested teh configuration of teh i-Supplier module.
  • Implemented Oracle SCM modules Oracle OM, Quoting, Service Contracts, Install Base, Shipping, Advance Pricing, AR, AME, BOM, i-Procurement, i-Supplier integrated with internal e-Procure system, Release 11i of oracle (
  • Preparing business test scripts with teh business rules associated with it to test teh data integrity of archived data.
  • Preparing business requirement documents with teh business rules associated to archive teh daily transactional data across different Operating units for nine fiscal years until Sep-2007.
  • Performed all teh setups for: Oracle OM, Shipping, Advance Pricing, Quoting, AR, i-Procurement, i-Supplier modules
  • Worked with teh Business team to baseline teh ‘As Is’ Process and derive ‘To Be’ flow.
  • Worked on teh entire upgrade strategy to upgrade teh application footprint from to Release 12.1.1
  • Pricing Business Requirement Study and designed / documented Functional Specification.(AIM Methodology Adoption)
  • Identification of Gap & put collaborative effort with teh Technical team to address teh same thro Technical Specification.
  • Providing Post Implementation support
  • Worked for teh Category & Mapping data migration to meet teh go alive deadline.
  • Jointly worked with teh QA team in formulating teh Test Cases & Test Scenarios.
  • Assisted Business for Business Acceptance Testing and obtain Sign off.


Oracle Apps Consultant


  • Complete setup of OM, Shipping, Advance Pricing, AR modules which includes defining all of teh configurations for each of these modules.
  • 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.
  • Defined Journal Sources, Journal Categories, Shorthand Aliases
  • Oracle – to define new items and categories.
  • Implemented Oracle Cash Management for Bank reconciliation.
  • Performed Bank Reconciliation.
  • Trained users on General ledger.
  • Fully participated in Conference Room Pilot (CRP) and authored user’s manuals.
  • Test various business scenarios in teh new system.
  • Interact directly with end users, infrastructure teams, and project teams.
  • 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 with attachments, before passing on to teh senior business analysts for further review.
  • Interacted with teh end users to get necessary feedbacks.

Environment: Oracle Applications - 11.5.10


Oracle Consultant


  • Designing teh system with configuration setup for Purchasing and Order management modules
  • Setting up Document Approval and Security
  • Maintaining Purchasing Items
  • Managing teh Supply Base
  • Managing Requisitions and Document Approval
  • Creating Purchase Orders and Blanket Purchase Orders, Receiving Production Items, Generating Purchase Requirements.
  • Managing Outside Processing
  • Worked on Order Cycle, which includes Booking, Scheduling of Order, Pick Release, Ship Confirming, Closing Order Lines and Order Headers, and Interface to Receivables, Invoice/Credit memo generation.
  • Defined time limit for Booking of Order, Set up pricing parameters/list.
  • Modification/cancellation of Orders/Order lines.
  • Defined teh Set of Books and Chart of Accounts. Summarized accounting information required by product, by department.
  • Set up budget organizations & set up systems for entering budget amounts & journals and Set Cross Validation and Security rules.
  • Defined Rollup Groups, Summary Accounts and Suspense Accounts.
  • Set up of Oracle Receivable dat included - Defining System Options, Accounting Rules, Aging Buckets,
  • Banks, Bank Charges, Bank transaction Codes, Dunning Letters, Transaction Types, Payment Terms, Invoicing etc.
  • Implemented Payables - Payment Terms, Pay Group, Tax Set up, supplier’s Sites, Bank, Distribution set, Financial and Payable options.
  • Basic Purchasing set up, identifying structure
  • Conducted Regression testing to examine teh effects of a new Org on teh previous Org.
  • Successfully provided Technical and Functional support to teh users, testers and Business System Analysts.
Environment:Oracle Applications (11.5.9)

Hire Now