We provide IT Staff Augmentation Services!

Qa Analyst Resume

NC

EXPERIENCE SUMMARY:

  • 7 years of experience on Oracle financial QA testing.(E-Business Suite) FA, PO, OM, INV, A/R, A/P. G/L.BOM, WIP,I Procurement.
  • 3 Years of Structured Integration, System and Performance Testing experience in Financial,(A/R, A/P. G/L) Health care InsuranceBanking, Manufacturing, Departmental Warehouse Management System, Human resources in a Client Server/Environment, /ERP/Oracle.
  • Internal users and external customers can view bills online using Oracle Receivables, Oracle Collections or other calling application.
  • Identified software capability and reliability by conducting functional, system, and performance tests.
  • Resolved testing problems by modifying testing methods during tests; conferring with management to revise test objectives and standards. (Test Cases using Positive/Negative, Object Testing, Unit, System, Integration Testing, Alpha, Beta & Gamma, Parallel, Performance Testing)
  • Maintained testing database by developing defect tracking and regression testing information requirements; designing information system. (Quality Center-Defect Creation-Prioritize-Resolution)
  • Reported test outcomes by collecting, analyzing, interpreting, summarizing, and displaying data; recommending, software changes. (Customer Feedback-Software Release Changes)
  • Tested External documents like User Guide and installation Guide to each release. (External/Internal Documents-Project Plan by Task)
  • Contributes to team effort by accomplishing related results as needed. (Team Work-Resolved QA Team Problem-Trained QA Staff)
  • Expertise in developing SQL Script/UNIX Script using UNIX Utilities. (Validate GUI Testing/Back End Testing).
  • Strong technical knowledge of ETL process of datawarehousing.
  • Software Quality Assurance Process, Attention to Detail, Process Improvement, Works closely with internal team members and external strategic partners. (Process Implementation)
  • Highly dedicated, quick starter, solution driven pattern programmer, Strong Object Oriented Analysis and Design, Excellent at solving complex problems under strict deadlines. (Strength in QA)
  • Technically strong in programming languages and operating systems.
  • Good communication skills coupled with positive end user interaction. (Interactive skill)
  • Can work under demanding time schedules and has excellent attitude towards teamwork and common goals. (Team Player)

Languages

C,C++, SQL, PL/SQL, TSL and Linux, Unix Shell Scripts

ERP

Oracle Financials 10.7/11/11.5.10, R12

Oracle ERP modules

A/P, A/R, FA, GL, ,CRM, Order Management, OTC,P2P, HR Benefits, Install base and Manufacturing, Warehouse management. procurement, I Expenses,

Databases

DB2, Oracle, MSSQL,and MS Access.

Operating Systems

Windows95/98/NT/2000,XP, Unix, Linux and Solaris.

Testing Tools

Compuware, Winrunner, Testdirector, Quality center Loadrunner, QTP 9.5, Silk Test, Rational Robot.

Business Tools

MSWord, MS Excel, MS Power point & MS Project, Visio, VB scripts

Defect Tracking Tools

BugZilla,Test Clear Track pro, Clear Quest, Quality center

Web Technologies

HTML. XML, VB scripts

Graphic Tools

Photo Shop

Reports

Crystal reports

PROJECT EXPERIENCE

Confidential,NC May ’10 - Present
QA Analyst

Confidential, is an existing data warehouse containing heterogeneous data of Wells Fargo Legacy Customers using wholesale/Treasury Management products. Currently the Wachovia accounts are employed to this data warehouse to help Merger Transition Customer View team to serve customers better. The CUSTDW development team has provided the even driven framework to support ongoing merger activity in order to convert customer accounts based on predefined Business Rules.

  • Involved in testing of Back End functionalities for different core processes to verify business constraints, Data Validation using SQL.
  • PerformedSoftware development life cycleprocess, developed the system test plans by interacting with cross-functional team to meet end user requirements.
  • Reviews and validated QA Test Plan with functional test scenario using testing methodology by reviewing all test scenarios with internal/external team.
  • Involved with developer to understand design of application, process flow and assist development team in unit testing.
  • Prepared documentation on validating Business Rules/Criteria in forms metadata and helped other team members to understand the whole process.
  • Validating metadata used for various core processes.
  • Performed sanity testing using post installation check using release notes and identified installation or code initial problems.
  • Communicated with Project Management to establish LOE of each phase of SDLC and planned testing strategy with peer team.
  • Involved at validating automated feeds/Manual Feeds generated as part ETL informatica process.
  • Identified business requirement gap with customer level and involved in impact of functionality of application.
  • Worked independently with the users for requirements gathering and prepare Functional specifications.
  • Performed defect analysis to identify root cause of problems and interact with appropriate team and resolved outstanding problems. Discussed blocking defects with team.
  • Assist production support team on release night to complete the testing.
  • Performed regression testing for various modules and core processes to ensure the overall functionality.
  • Created data modifications test scripts for several test scenarios to perform negative testing.
  • Involved in System Integration testing with external & internal interface team and performed E2E Testing.
  • Provide data for SIT and tested all interfaces to make sure functionalities supports E2E.
  • Assisted Production support team to resolved production issues, trained team to develop cross-functional ability.
  • Developed plan for cross-functional training with team for knowledge transfer.
  • Developed local procedures and demonstrated new project functionality to QA team to understand functionally at project level.
  • Attended most of the meetings involved the discussion of new requirements/changes in existing functionalities and shared my thoughts to provide best approach to achieve the goal of organization.

ENVIRONMENT: Oracle 10g,Microsoft SQL Server 2000/2005, Toad, SQL Developer, UNIX, MS Office Tools, SharePoint. Toad 10.5. Quality center: 10.5, UAT, SIT, Production Testing

Confidential,Atlanta, GA Sep ’08 – Mar ‘10
QA Analyst

  • Analyzing business documents like, functional, technical and Test plans.
  • Responsible for gathering information from client, customers, core users regarding the data and business processes and made proper documentation.
  • Participated in all phases of Soft ware development and Software testing life cycle.
  • Execute and Maintain QTP scripts
  • Analyzing business documents like, functional, technical and Test plans.
  • Developed and executed different work products Quality Center. Requirement maintenance, Test plan, Test Suite and execution. Design and execution of test strategy, test plan, test cases
  • Plan & prioritized manual and automation activities and design and developed Automation Test Scripts and manage the testing activities using QTP
  • Developed the Data Driven Framework for maintaining the automation scripts.
  • Reusable functions to increase the reusability in the automation.
  • Created Data Driven Tests to validate the same scenario with different test data.
  • Scheduling and allocating work amongst the team members, ensuring deliverables in time.
  • Developed the strategy for Manual Testing of the application and tested the strategy to be client compliant.
  • FA: Functional testing of various scripts, Asset manual, quick Additions, CIP Assets, Load ADI Assets (Application Desktop Integrator), mass additions, create JE and reconciliation with GL , Retire and re-instate assets, Depreciation,. Transfer of Various Assets.
  • Cash Management Inbound outbound testing: Loading bank statement interface file through FTP, upload files for Asia and Pacific region.
  • HP QTP version 9.2- Debit card reconciliation testing of various automated scripts. Recording and Enhancing scripts and creating scripts. Automated testing using the tools Quick Test Pro, Quality Center torun both manual and automated scripts. Enhanced Test Scripts using QTP features like checkpoints, Synchronization points and parameterization..
  • Write SQL queries to perform data validationand also wrote queries for Log table and Validate that all order Counts are as expected compare to production. Joints- Union, Intersect and minus. Multiple sub queries, Loops, Triggers

Environments: Oracle version 11.5.10 and R12. UNIX, Operating system: sun Solaris, Database: Oracle 9i Release 2, Toad, SQL with Agile experience. QTP Version 9.2 and VBScript.

Confidential, New York Jul ’06 – Sep ‘08
Lead QA Analyst.

CRM application: Worked with 6 offshore resources. Coordinating to accomplish the job and collecting daily matrix report.

  • Creating a DMA (Document Management Agreement) contract database application CDB (Xerox service contract database)
  • Create Performance test scripts using Load Runner.
  • XONE application performance test by executing the load runner scripts to get the contract Unit and contract numbers.
  • Automated Flex contract is for creating line and service contracts and for creating service, labor, equipment, units and pool contract. Service Contract, Install base bring this into Oracle XONE application. Creating workup sheet in value quix, Enter service, meter reads and allowance. Correct the contract error and approve from the controller.
  • Match and post the contract order from flex process through telnet and enter to Oracle database. Did regression test using Load runner.

Manufacturing -Purchasing –P2P

  • Creating Test plan. Analyzed SRD and BRD and wrote test cases in Purchase Module. Worked on validating end to end flows and interfaces. White box testing, UAT testing, Invoice Transaction coming from Account payable is tested through interface and view results in web methods. Test conducted on multiple organizations. Requisition, Purchase order, Receiving, Blanket purchase agreement. Validation of Purchase order, I procurement, PO print, PO EDI and PO E-mail purchaser. Checking the purchase order in Approved supplier list- Item is purchasable, approved, stock, enabled and Assigned to an organization.
  • A/R: Testing Address validation, Receipts, Adjustments, Invoices Checking the reports.
  • A/P: Testing Supplier information, PO. Import invoices, Payments- online, cash, wire payments, PO header, lines, distribution, releases, credit card payment.
  • WIP testing: Discrete, Assembly, Repetitive manufacturing, Assembly to order. Shop floor control- Assembly moved to shop floor and controlling. Supply chain module and warehouse Transport management.
  • WMS Cycle Count • Internal Order• Internal Requisition• Job or Schedule• Move Order• Purchase Order• RMA• Sales Order
  • OTC: Testing the following – Entering the order, booking the order, scheduling the order. Pricing. Testing the line item, pricing list and modifiers.
  • TOAD: Querying the date from the front to backend using select command and comparing the results using SQL.

Environments: Oracle version 11.5.9 Operating system: sunsolaris, Database: Oracle 9i Release 2, Toad.
Oracle Apps Modules tested: A/P, A/R, and CRM, Install base and Manufacturing & WM Automated tool like Loadrunner 9.0 & QTP 8.2 and Test Director Using AIMS Methodology. Agile experience

Confidential,NY Sep ’04 – Jun ‘06
QA Tester

Project-1: IBM his implementingOracle Apps 11i Accounts Payable Legacy Decommissioning from Mainframe to Oracle App
Bank of Nova Scotia: In bound file testing A/P with payment. Creating Master test plan: Writing Overview, Objectives, Goals, Testing data under test environments, system scope, creating Test plan, Test data, Data strategy
Project -2: Western Union Money transfer: Decommissioning the Mainframe and moving to SQL Server. Every day A& P storetransactions of customer and vendor is sent to IBM to process and make payment to Western Union and generate various reports, such as Daily, Weekly, Division and Group reports. Responsibilities: Creating Master Test Plan. Performing one or more tests, System/Integration test and performance test and Database testing.

  • DevelopingTest scripts from Functional and Technical documents.
  • Common payment engine for outbound and inbound payments.
  • Credit Card support – Validation, authorizationand funds capture.
  • Transmission of Bills Receivable transactions
  • Bank account transfer support for OracleReceivables and Payables.
  • Testing all criticality and functions, provide regular status to project managers, review with developers and technical lead, to ensure software is properly tested
  • Oracle Financial Apps interfaceand getting reports
  • Using Control-M, FTP from Mainframe to UNIX.
  • Testing the data under OAAP-Development environment and Testing environment
  • Testing all criticality and functions, provide regular status to project managers, review with developers and technical lead, to ensure software is properly tested, black box testing and UAT testing.
  • Smart Database to check the records are stored properly
  • Using Control-M, FTP from Mainframe to Unix
  • Text data file taking manual Excel sheet to compare the sql server results
  • Testing the data under OAAP-Development environment and Testing environment

Environments: Oracle Apps 11.5.9, UNIX, Toad 6.5 Hp OS 5.8, Test Director 7.2, Oracle 9i, SQL Server 2000. Agile experience, Iterations

Confidential, CA Mar ’04 - Aug ‘04
QA Tester

Cisco System implementing Oracle Apps 11i in various modules like Order Management, Accounts Receivable, Legacy Systems and Boundary Systems. P2P, Install base & Order Management.
Order to cash: Customers call the order, check the price, check availability, book order, receive cash, generate invoice, ship confirm and pick release. Procure to pay:Check the price of the vendor, P.O for approval and send the P.O to vendor. Matching and paying the invoice, receive the invoice, item to the shelf or to employee and receive the shipment.

  • Going through variousDSD’s and FSD’s and writing String Test Scripts for Book Order and Create Order manually.
  • Writing E2E scriptsand generic scripts.
  • Mapping the entire requirement into the Test Case Builder. Participated in Specification reviews and Mapping Documents reviews with Technical staff and Business System Associates.
  • Uploading all the String scripts and E2E scripts, Generic Scripts into Test Director.
  • Bug fixing all the scripts issues and reports to the management.
  • Performed manual functional testing of various business areas.
  • Writing SQL queries for fetching data from boundarysystems.
Environments: Oracle Apps 11.5.9, Unix Hp OS 5.8, Test Director 8.00, , Oracle 8i,PL/SQL

Confidential,TN Dec ‘02 –Feb ‘04
QA Analyst

CNA Life Insurance has implemented Oracle Applications 11i and it is integrated to other widely used legacy applications. They have customized Interfaces to meet the business requirements and in addition, many customized Forms and Reports are built in Accounts Receivable (AR) module. Manually testing Insurance forms.

  • Participated in Specification reviews and Mapping Documents reviews with Technical staff and Business System Associates.
  • Did Extensive testing of the Customized and Oracle standard Reports before and after Customization.
  • Participated in Code review sessions with the developers for production fixes.
  • Executed test Scripts for the Inbound and Outbound interfaces to Oracle AR.
  • Developed SQL scripts to validate the Oracle Interface and Base tables.
  • Performed Functionality testing, Stress testing and Regression Testing.
  • Participated in Production Check outs and Provide QA support for Production fixes.

Environment: Oracle Apps 11.5.5, Sun OS 5.8, Rational Clear Quest, Sun OS 5.8, Oracle8.1.7.4.

Confidential, MO Apr ’02 – Nov ‘02
QA Analyst

Enterprise-rent-a-car was in a process of implementing Oracle applications and it was integrated to other widely used legacy applications. They have customized Interfaces to meet the business requirements and in addition to it many customized Forms and Reports are built.

  • Wrote test cases and test plans based on technical and functional design documentations.
  • Wrote Test Cases and Load Test Plans based on Technical Documents been prepared.
  • Developed Load Test Strategy to do performance testing of the applications.
  • Performed Load and Performance Testing of critical areas of Oracle Applications module by simulating the load on the system using Load Runner 7.0.
  • Performed Load Test of Outbound and Inbound Interfaces.
  • Executed test cases created in Winrunner for functional testing
  • Used Mercury Test Director for defect documentation.
  • Worked on volume testing and stress testing.
  • Performed manual functional testing of various business areas.
  • Network Load testing was done by generating Network load from various locations and the entire application was load tested using Load Runner 7.0

Environments: Oracle Apps 11.5.6, Winrunner 7.0 Load Runner 7.0, Test Director 7.0, Sun Solaris 8, Oracle 8, UNIX.

Confidential,NJ Mar ’01 -Mar’02
QA Tester

This was an application developed for a commercial bank. The complete application covered entry of Cash-In, Cash-Out, Loan Approvals, Wire Transfers, Loans, Financial Cash-flow Statements, Financial Ratio
Statements, Asset, and Equity etc. The product is more focused on Mortgage Home loan schemes and Certificate of Deposits, Facilitated with Home buy ability Test and Mortgage calculators. Involved in Testing of Loans and Certificate of Deposits (Fixed Income) modules.

  • Written Test Plan and Test Cases using Test Director.
  • Created Test Scripts to test the HTML pages according to the Test Cases. Performed Functional, Regression and System Testing.
  • Performed Data-Driven testing using Winrunner.
  • Performed Cross Browser, Configuration, Content & Security Testing..
  • Used V user Script Generator for writing and debugging automation scripts for Vusers, monitoring communication between Test application and server.
  • Incorporated Vuser scripts in load Runner Scenario after inserting the General Function calls.
  • Load tested the application with Loadrunner. Analyzed the graphs and generated Performance reports. Written Database Vuser Scripts and Performed back-end Testing-using TSL, SQL calls to the database server.
  • Tracked extensive IT testing issues of the whole project resulting from test execution and categorized according to severity of the problem.

Environments: WinRunner6.0, LoadRunner6.5, TestDirector6.0.2, Oracle, C, 8.0, PL/SQL, VB 6.0, Windows NT.

Hire Now