We provide IT Staff Augmentation Services!

Oracle Applications 12i Qa Analyst Resume

4.00/5 (Submit Your Rating)

NY

SUMMARY

  • Over 9 + years of extensive experience in software configuration, Interfaces and Customization of enterprise wide Applications. Hands on solid expertise in administration and coordination strengths in ERP implementation using Oracle Financials Application, Web Applications and Legacy Applications with excellent communication and inter personal skills.
  • Worked as a QA Lead, QA Analyst and Developer.
  • Experienced in testing Oracle EBS, Web, Mainframe and Web Service Applications.
  • Extensive experience in Oracle Applications 12i, 11i (12.0.3 / 11.5.10 / 11.5.9 /11.5.8) modules like iProcurement, iSupplier, iExpenses, Purchasing, Order Management, Inventory, Workflow(Requisition, PO, Invoice, Expenses), Accounts Payable, Accounts Receivable, General Ledger, MDM, OBIEE and Cash Management.
  • Involved in Upgrade from Oracle 11i to Oracle 12i(12.0.3)
  • Strong background working with Multi Org and Multiple Currencies. Strong experience implementing PO, iProcurement, iSupplier, iExpenses, OM, INV, AP, AR, GL and CM.
  • Developed Functional Documents (RICE) for PTP, OTC process.
  • Set Up configuration, CRP, UAT, Conversion, and Customization Functional specification definition and documentation.
  • Rich experience with RICEW (Report, interface, conversion, extension and workflow)
  • Involved in testing Standard and Custom Reports.
  • System Administration functionality performed including end user Set up, Responsibility definition, Menu definition and Function definition.
  • Follows ups of CR, SR and Applications of Patches as and when required.
  • Assisted with overall team management, communications and maintaining positive client/consulting team relationship.
  • Participated in business process reviews. Provided solutions and recommendations to process issues both related and unrelated to Oracle Applications
  • Worked in various roles as Process Designer, Functional Consultant and Techno - Functional Consultant.
  • As Functional Consultant, worked efficiently with multi-national teams.
  • Managed Gap Analysis & Feasibility Study, schedules, and the entire implementation life cycle.
  • Prepared and presented end user training including development of training manuals and population of training database for hands on exercises.
  • Excellent in developing Test Plans, writing Test Cases.

TECHNICAL SKILLS

Oracle Service Line Experience: Functional expertise in Financials, Procurement, Applications and technical expertise in Reports, interface, conversions, extension and workflow (RICEW).

Oracle Applications Experience: PTP, OTC, PO, iProcurement, iSupplier, iExpenses, MDM (Supplier Data HUB), OM, INV, OBIEE, AP, AR, GL and CM

Process Areas: Finance Processes, Procure to Pay, Order to Cash

Oracle Tools Experience: PL/SQL, SQL*Plus, FNDLOAD, Workflow Monitor

Other Tools Experience: Quest Toad, SQL*Loader, Data Loader, Win runner, QC, QTP, Test Director, Rational Clear Quest and Clear Case

PROFESSIONAL EXPERIENCE

Confidential, NY

Oracle Applications 12i QA Analyst

Responsibilities:

  • Studied, analyzed, designed and implemented Oracle APPS 11/12i PO, AP, iProcurement, iSupplier,IExpenses, MDM (Supplier Data HUB), GL, OM, INV and AME Workflow.
  • Prepared Functional, Setup, Business Requirement, Test Plans and Test Summary Documents.
  • Heavily involved in Testing Migration, R12 Patches and CCR (Change Requests).
  • Involved in BR100 setup testing (Profile Options, Financial Setups, Workflow setup’s etc).
  • Written and Executed Test Cases in QC. Delegate QA work to team members.
  • Heavily tested Supplier Data Hub (Involved in workflow testing).
  • Heavily involved in testing Interfaces, Conversions and Customizations. Implemented and Tested interfaces, conversion and extensions.
  • Designed and developed a testing strategy including CRP test scenarios for PO, AP, OM, iProcurement, iSupplier, GL, INV and AME Workflow’s.
  • Involved in testing Electronic Invoice (EDI) interface to Oracle.
  • Involved in testing OBIEE reconciled reports for Account accuracy, Bar charts, PIE Charts and Drill Down functionality.
  • Preparing Flow Charts & Suggesting Customizations. Provided post implementation support to the client.
  • Prepared User Acceptance Training documents. Step by Step Excel file created for QC to download.
  • Reviewed as-is (existing) business process and prepared to-be (new) process flows for multiple business scenarios.
  • Involved in testing Requisition, Purchase Order, Expenses and Invoice Approval Process.
  • Involved in Image Process Testing for PO Matched, Non PO Matched and Electronic Invoices.
  • Coordinated with offshore on daily work.

Confidential, Johns Creek, GA

Oracle Applications QA Tester/Performance

Responsibilities:

  • Studied, analyzed, designed and implemented Oracle APPS 11/12i PO, AP, Payments, AR, OM, INV, GL,EDI Transactions, AME Workflow, Vertex, BWB and SWB.
  • Prepared Functional, Setup, Business Requirement and Use Case documents. Heavily involved in Testing Migration and CR (Change Requests).
  • Created scripts using goal oriented functions in Load Runner to test web service applications on a transaction per second basis to establish acceptable benchmarks and then implemented manual scenarios for more advanced performance testing.
  • Involved in Functional, SIT, Regression, Performance, Automation and UAT Testing.
  • Determined application performance and maximum scalability, critical parameter such as number of users, response times, and hits per seconds and through put using LoadRunner Monitored Apache web server, Web Sphere application server and Oracle database servers.
  • Inserted various Transactions to note the response times and Correlation statements to parameterize dynamic values from the server in VuGen
  • Hands on experience with QA processes and testing tools (QC, Quick Test Professional) and SQL queries.
  • Championed the design and rollout of test reporting standards, and creation and delivery of concise metrics to leadership for enhanced decision-making.
  • Monitored and Analyzed various performance graphs (vusers, hits per second, response time, network delay,database,webserver,appserver graphs)
  • Performed database testing by passing SQL queries to retrieve data

Confidential, Harrisburg, PA

Oracle Applications 11i QA Tester / Consultant

Responsibilities:

  • Studied, analyzed, designed and implemented Oracle APPS 11i PO, AP, iProcurement, iSupplier, iExpenses,and AME Workflow.
  • Involved in testing Oracle 11i for PO, AP, GL and INV. Prepared Test Plans and Test Summary Documents.
  • Heavily involved in Testing Migration, Patches and CCR (Change Requests).
  • Involved in preparing MD50, BR100, BP80 documents and Testing (Profile Options, Financial Setups, Workflow setup’s etc).
  • Written and Executed Test Cases in QC.
  • Delegate QA work, Monitored and supported QA work, Issues and Status.
  • Implemented and Tested interfaces, conversion and extensions.
  • Created Load Runner scripts to validate all web servers, app servers, and databases up and running.
  • Created scripts using goal oriented functions in Load Runner to test web service applications on a transaction per second basis to establish acceptable benchmarks and then implemented manual scenarios for more advanced performance testing.
  • Observed the Performance of the application by creating Vusers and Monitored the graphs using Load Runner
  • Reviewed as-is (existing) business process and prepared to-be (new) process flows for multiple business scenarios.
  • Involved in testing Requisition, Purchase Order, Expenses and Invoice Approval Process.
  • Involved in Image Process Testing for PO Matched, Non PO Matched and Electronic Invoices.
  • Coordinated with offshore on daily work.

Confidential

End-to-End QA Tester/System Analyst

Responsibilities:

  • Worked as an End-to-End Team Lead/System Analyst for PLA projects, Web (eAuto and eHome) and Mainframe Applications.
  • Identified and Documented Projects Risks, Dependencies, Issues and Assumptions.
  • Analyzed Business/System Requirements and involved in developing Test Plans and Test Cases
  • Review the BSM (Business Scope Management) report to understand the scope and benefit of the projects.
  • Attend the BRI (Business Requirement Identification) meeting to understand the business Requirements.
  • Review the TRD (Technical Review Document) from developer and prepare the TDR (Technical Data Review) document with detail objectives (test cases).
  • Implemented WEB projects eAuto, eHome, Agent Dashboard (eCommerce), OTC, RCV projects.
  • Involved in P&C Auto and Property Billing Application (ASB and FSB), which covers Payments (Check, Cash, Credit Card), Statements (Monthly Statements), Notices (Cancellation, Reminder, Final Cancellation etc).
  • Tested Web Online Credit Card Payments thru Batch Process.
  • Involved in analysis, Design, Coding, Testing, Implementation and support.
  • Prepared work/Process flow diagrams.
  • Working with Product Management, Actuarial, Service centers, and rate-testing teams to get the requirements, produce and analyze various compare reports, provide solutions and resolve any issues.
  • Performed Requirements Analysis, Risk analysis, Dependency Analysis and Issues/Problems Analysis.
  • Responsible to identify the test data from production to request Data migration.
  • Set up the Data Migration Jobs to load data from Production to Test Database.
  • Involved in the review of the test plan, scripts to ensure they match and cover all the requirements in the functional specification document.
  • Translate requirements in to Test Cases. Involved in Test Execution.
  • Reported the defects to Business Team Lead and Development Managers.
  • Collaborate with Developers as needed to isolate root cause of defects.
  • Performed Integration, Functional, Regression, Compatibility Testing and System Testing

We'd love your feedback!