SUMMARY:

• Oracle Functional Test Consultant with strong educational background with experience in Oracle E - business Suite.
• Experience with Implementation and Upgrade projects
• Knowledge of Oracle EBS modules Supply Chain - Order Management (OM), Inventory (INV), Purchasing (PO), I-Procurement, and Financials modules including General Ledger, Account Payable (AP), Account Receivables (AR), Fixed Asset (FA), Cash Management (CM), EB- Tax and System Administrator (Sys Admin).
• Worked on Implementations, and Upgrade projects, including implementations in Oracle R12 (R12.1.3) and 11i (11.5.10.2)
• Understanding business processes and gathering of user input for the purpose of laying out the Functional Cutover plan
• Comprehensive knowledge in preparation and maintenance of Oracle AIM methodology (RD20, BR30, BP80, BR100, MD50, CV040 and TE40 etc.
• Ability to Create test design, test plan, detailed test cases and build effective test strategy to test complex on- demand and integration applications.
• Ability to perform functional testing and document test results Plan, design, create, document, implement and maintain test scripts.
• Ability to Participate and contribute to product code reviews and Participate in product and feature design with developers and product owners.
• Ability to Diagnose, triage and manage quality issues to resolution, Communicate the QA progress to the key stakeholders, and testing of any end to end integration work
• Well versed with the understanding of Oracle R12 including Sub-Ledger Accounting (SLA), FSG reporting.
• Experience with Load/ Performance Testing experience in Oracle OATS, Financials, CRM, HRMS and Manufacturing Technologies.
• Experience on using Linux and Unix commands
• Experience using Putty and Win SCP for FTP usage
• Strong understanding of QA Principles, QA Process and forecasting, Strategic planning and budgeting process for revenue, Use Cases, and Software Development Life Cycle.
• Analyze the functional costs and build detailed financial models for the QA forecasting and processes.
• Hands-on experience using Load Runner, Performance Testing, QTP, Mercury Quality Center/.
• Extensive experience in the Business flows of Order to Cash, Procure to Pay cycles and Payroll Process.
• Extensive experience in writing Test Scripts for TE 020 Unit Test, TE 040 System Test, UAT and Integration Testing.
• Participate in full life cycle testing activities throughout all phases of the SDLC.
• Experience in White Box, Black Box, Functionality, Regression, Performance, Unit, Integration and User Acceptance testing of Web-based Services.
• Extensive experience in reviewing and understanding business and testing requirements and writing detailed automated/manual Test Plans, Test Cases, Test Scripts and Expected Results using Mercury Quality Center, Load Runner, Quick Test Pro according to the requirement.
• Provide estimated testing level of efforts, duration and dependence in support of project planning and scheduling.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle Functional Test Lead, San Francisco, CA

Modules: Oracle e-Business Suite R12.1.3 AR, AP, GL, SLA, E-Business Tax, FA, CM, AGIS, PO

Responsibilities:

• As a Manual Test Analyst Consultant in the Oracle Financial business flows, worked on financial modules: AP, AR, GL, CM, FA in Oracle e-Business Suite.
• Technical Testing for the Auto Invoice interface in AR to load invoices into AR from Org62 (SFDC.com).
• Technical testing of the customer interface to load customers into the TCA Module from an external customer database.
• Technical testing of the Auto Lock box Functionality in AR for Bank of America & Wells Fargo.
• Regression Testing for Sabrix upgrade
• Conducted pilot testing, integration with other financial modules testing.
• Interacted with the Business, analyzed existing business practice and prepared test scripts based on the business requirement document and identified Gaps.
• Written the manual Test Scripts for projects related to AP, AR, GL, FA, CM, PO modules of Oracle
• Prepared QE scripts with respect to the Documentation of BR100, BR30 and Functional Extension and design Document MD50.
• Have driven User Acceptance Testing (UAT) coordination with the business.
• Tested the setups in General Ledger, FSG reports (Income statement and Balance sheet statement).
• Tested the financials and payables options.
• Tested the payment terms, distribution sets, and matching tolerances for purchase order matching and set up of bank details.
• Tested the Payment Attributes-Payment Formats, Bank Account, And Payable Documents.
• Tested the Open/Close of payable Accounting periods, and Payable Transfer to GL.
• Tested the functionality of Recurring Journals, Stat Journals & Mass Allocation Journals.
• Tested supplier sites, suppliers, and banks for payable use.
• Tested Request sets, Concurrent Programs and scheduling various tasks as per different projects.
• Tested the related setup tasks in the applications that work together with Expenses template to create an integrated environment for expenses reporting.
• Tested the different types of payments such as Proprietary and MT101 file format integration from TMS (Treasury Management Systems) to different Banks like Deutsche Bank, Bank of America and Wells Fargo passing through SIL and AC (Swift Integration layer and Auto client).
• Tested the integration from Coupa (external purchasing application) to Oracle.
• Tested the integration from Inspyrus (external Invoicing application) to Oracle - H2H flow.
• Coordinated with the development and functional teams for delivering the project within the provided timelines.
• Took Initiative to deliver future release projects early before time by proper time management.
• Delivered high complexity projects without single UAT/Production bugs.
• Delivered projects with the flexibility to work with 2 Scrum teams - P2P and R2R during the same sprint without failure.
• External Applications Used at Salesforce:
• Arravo for vendor Management
• Coupa for Purchasing
• Concur for Employee Expense and Travel
• Workday for Employee Creation flowing to Supportforce (SFDC Inbuilt app)
• Serengeti for Legal Expenses
• Taulia for Discounts of AP Invoices
• Inspyrus for AP Invoice Imaging
• Swift for Treasury Management Systems payments (External)
• Blackline for transferring GL data to Oracle EBS

Confidential

Oracle Functional Test Lead, Seattle, WA

Responsibilities:

• Prepared the high level strategic Test plan for the Project with its scope and objectives to meet the Deliverables.
• Prepared all the required test cases for all the testing cycles starting from Integration testing cycle 1 until UAT (User Acceptance Testing)
• Tested the Financials Modules of AR, AP, GL, FA, Cash Management, E-Business Tax, Sub Ledger Accounting, OM, INV, PO modules of Release 12.1.3
• Tested the Order to Cash and Procure to Pay business flows
• Prepared and tested all the test cases involving various integrated systems of the project which included Oracle EBS - Accounts Receivables, Accounts Payables, Installed Base, Service Contracts, General Ledger, Order Management, Salesforce, Informatica, Clarify, Siebel.
• Gathered all the business requirements of the project after each testing cycle until UAT and prepared test cases based on the requirement.
• Tested the automatic creation of Sales Orders coming from Amazon Web Services and Market Place in Order Management; automatic Creation of Customers in TCA; automatic creation of Invoices coming from Recurly & Storefront and automatic creation of Receipts coming from CyberSource in AR; automatic creation of Opportunities and Renewal Opportunity in SFDC (Subscription Renewals) via Informatica through Fusion Middleware.
• Tested the automatic update of start and end dates of a subscription renewal product in Installed base with 7 months of expiration based on which an opportunity gets renewed automatically in SFDC via informatica through Fusion Middleware.
• Tested the BAM notifications (Business Activity Monitoring) and Error Recovery Portal which captured the errors in the process flow and suggested the appropriate workable and possible solution.
• Documented all the test cases and its results on the Project SharePoint for management review.
• Coordinated with the Functional resource and Developer to understand the required flow and implementation of upstream and downstream process.
• Involved in Unit testing and system testing.

Confidential

Oracle Functional Test Analyst, Chicago, IL

Responsibilities:

• As an Oracle QA Tester supported the testing of the Order to Cash Business Process (OM, INV) and all financial modules.
• Worked on the Oracle Application Testing Suite (OATS) module - Test Manager, Load testing.
• Worked on the technical scripts for Automation Testing in OATS
• Tested Conversions & Enhancements for OM, AR and INV module
• Created Requirements using Quality Center and generated traceability Matrix to ensure that all the requirements are covered by the test cases.
• Keeping Track of Defects in Service now Quality Center application.
• Coordinated with different users and BA for the Functional Specifications and final utility of the modules.
• Executed and developed all Manual Test Scripts for the testing cycle for Order to Cash and Procure to pay processes.
• Worked on the CRP execution, User training and coordinating with technical teams on Oracle Apps related Custom design validation for integration between Oracle Apps and legacy applications.
• Tested the OM, AR, INV and GL modules from scratch and simultaneously validated the BR100 documentation for the setups.
• Tested the Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into banks BOA & Wells Fargo.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules.
• Used manual testing methods to test Invoice rules, Payment terms and Transaction types in Accounts Receivable module.
• Performed Black box and White box testing to test the custom forms and reports in different modules.
• Involved in defect tracking and created various defect reports.
• Regression testing on weekly builds.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Tested the Multiple Reporting Currencies Setup by testing the primary Set of Books and Reporting Set of Books in Oracle GL.

Confidential

Oracle Functional Test Analyst, New York, New York

Responsibilities:

• Participated in multiple business meetings for Fit-Gap Analysis and Solution.
• Assisted functional analyst to conduct CRP1 and CRP2.
• Involved in configuration of CRP1, UAT and test instance.
• Involved in reviewing the Current Business Model (BP040) and designed the Future Process Model (BP80).
• Tested the Application setup for GL, AP, AR, FA, Eb-Tax, AGIS
• Trained Business Users and troubleshooting duringpo User Acceptance Test (UAT).
• Tested the Legal Entity, ledger with using Account Setup Manager (ASM).
• Tested Intercompany Accounting.
• Tested the Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.
• Tested the Payables and Financials Options.
• Tested the Recurring journals template, recurring journals and Auto-reversal in GL.
• Tested the FSG reports in GL.
• Tested the AP bank accounts, bank documents, bank codes and expense report templates.
• Tested the PO matching option, invoice tolerances, distribution options, terms, holds etc. and Setting up Payment methods, Payment format and Payment Process Profile etc.
• Tested the suppliers, locations.
• Tested the Chart of Accounts, calendar and currency according to the business requirement.
• Tested the Primary Ledger, secondary ledger and defined accounting setup options.
• Tested Configured and implemented Chart of Accounts, Value Sets, Ledger, Security Rules, Cross Validation Rules, Calendar, Journal Source, Journal Category.
• Tested the Special Calendar for Recurring Invoice, Payment Terms and Payable Quick Codes.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Tested the setup steps of the AR module. These included System Options, Receipts, and Lockbox.
• Tested Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets.
• Tested Defined Invoicing information including Payment Terms, Invoicing and accounting rules.
• Tested the Defined receivable activities for miscellaneous receipts, finance charges, bank charges, collectors, and aging buckets.
• Tested various Setups of transaction types, invoices, guarantees, deposit, and credit memos, debit memos.
• Assigned receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types.
• Defined profile options to specify certain implementation parameters.
• Involved in analyst financial data in conversion life cycle.
• Used the System Administrator responsibility to define users and assign responsibilities and set profile options.
• Participated in testing, user accepting testing in test instance and worked with certain key super users
• Development and implementation of Test cases, Test plans, Test data and Test scripts according to the requirements within an Agile/Scrum methodology.
• Responsible for identifying/testing setup items for different functional areas in GL, AP, AR, FA, Eb-Tax, AGIS
• Executed SQL Queries to verify the dataflow from the backend.
• Involved in intensive testing of Interface programs, which move the legacy data to Oracle tables.
• Tested the Period Closing/Month end process across all the modules
• Created Requirements using Quality Center and generated trace ability Matrices to ensure that all the requirements are covered by the test cases.
• Keeping Track of Defects in Service now Quality Center application.
• Coordinated with different users for the Functional Specifications and final utility of the modules.
• Used manual testing methods to test Invoice rules, Payment terms and Transaction types in Accounts Receivable module.
• Performed Black box and White box testing to test the custom forms and reports in different modules.
• Involved in defect tracking and created various defect reports.
• Regression testing on weekly builds.
• Weekly Status meeting with Development and Management teams to discuss bugs and other issues.