We provide IT Staff Augmentation Services!

Sr. Qa Analyst Resume

0/5 (Submit Your Rating)

Sunnyvale, CA

SUMMARY

  • Overall 8 Years experience in Quality Assurance by Performing Test Planning, Test Execution, Web application testing, Mobile Testing, BI testing, Quality Assurance, Reporting, Defect Tracking and offshore co - ordination.
  • Worked in different domains- Sales, Banking, and Retail industries.
  • Strong knowledge and understanding of the SDLC and STLC
  • Substantial experience in Team management and Issue resolution.
  • Extensive experience in manual & automation testing using QTP.
  • Expertise in test planning and managing test documents like test plan, test scripts, status reports etc
  • Experience at generating automated test scripts using QTP. Generated a repository of reusable functions to cut down scripting time
  • Extensively used testing tools like Quality Center, Rational Clear Quest, and Rational Requisite Pro, Quick Test professional.
  • Good understanding of XML with SoapUI.
  • Strong in performing backend testing to validate data using SQL queries
  • Excellent knowledge in Business Intelligence (BI) Testing on various databases using OBIEE
  • Experience in data warehouse testing and good understanding of star schema’s and snow flake schema’s modeling
  • Handled team size of 4 at offshore to drive project execution and coordinated with onsite clients on requirement gathering and was responsible for overall project delivery for QA.
  • Excellent Work Experience in Windows NT, 95, 2000, UNIX platforms, Mac etc.

TECHNICAL SKILLS

Testing Tools: QTP, Winrunner

Languages: XML, Visual Basic 6.0, VB Script

Web Technologies: HTML, DHTML, XSTL, WSDL, SOAP, XML

Databases: SQL Server2000, Oracle 10g, OBIEE

Operating Systems: Windows, UNIX/LINUX, Mainframes, MAC

Browsers: Safari, Firefox, Chrome, Internet Explorer

Reporting Tools: Bugzilla, Quality Center, MS Excel, Rational SODA, Clear Quest

Test Management Tools: Quality Center, TRAC, SharePoint, Bugzilla, Citrix, PVCS Tracker

Other Softwares: VMware, Datastage, soapUI, TOAD, OmniGraffle,Wiki

PROFESSIONAL EXPERIENCE

Confidential, SUNNYVALE, CA

Sr. QA Analyst

Responsibilities:

  • Analyzed business requirements document and technical design document for the reports
  • Analyzing the ETL spec documents provided by ETL developers
  • Created Test cases and Test Plans documents for the reports
  • Provided SQLs as necessary for the Test case development to validate data in the Database
  • Created adhoc queries using OBIEE Answers and validated the Dashboard reports
  • Validated Data at source system, warehouse and OBIEE reports to ensure the data consistency
  • Performed IBOTs testing to ensure the schedules/delivery are meeting the business requirements
  • Worked with the ETL team and Report team to validate the test cases and Test results
  • Test cases/Test Plans/Test Results validated and recorded through HP QC

Environment: OBIEE 11g, IBM Data stage, Oracle 11g, HP QC

Confidential, FREMONT, CA

Software QA Engineer

Responsibilities:

  • Analyzed COPS II Requirement documents and COPS test plan document.
  • Developed Test plans and test cases for COPSII applications.
  • Daily review meeting regarding weekly releases after fixing the defect.
  • Executed sanity, functional and regression test cases to verify business requirements.
  • Daily Supporting and coordinating with QA team of 6 and developers during the project.
  • Executing SQL queries on SQL server for verifying data.
  • Attending Daily status meeting and updating the testing status with QA Lead
  • Logged defects into QC and tracked throughout the project.
  • Participated weekly Defect review meeting with project team members.

Environment: VMWare, IIS Web Server, SQL Server 2008, Quality Center, UNIX, Windows

Confidential, FREMONT, CA

Test Analyst

Responsibilities:

  • Prepared Test model, test scripts and test reports for Integration testing based on system requirement specification document
  • Prepared and Executed Integration Test cases for all three parts of HCP project using High Level Design documents
  • Performed functional and regression testing of the application
  • Prepared Test Model and test scripts for UAT testing
  • Supported clients throughout UAT testing and managed bug life cycle using Defect tracking system
  • Worked on HP Quality Center set up and uploaded test scripts for execution
  • Logged defects and tracked them on Quality center
  • Conducted daily defect meeting to discuss open issues
  • Worked as onsite coordinator to ensure continuous support for the project to meet tight timelines
  • Prepared Test data bed for test case execution and wrote lot of SQL queries to validate data and report bugs on the issues
  • Designed and prepared Test result summary reports and graphs for clients and management for status reporting on the project

Confidential, Cupertino

Responsibilities:

  • Prepared Test deliverables - Test cases, execution Plan and Test reports.
  • Executed and performed SIT, Sanity and Browser compatibility testing.
  • Logged issues and linked to test cases in RADAR tool.
  • Prepared Test Data and performed data analysis using SQL
  • Onsite co-ordinator and managed team of 4 at offshore to drive project execution
  • Prepared Requirement traceability documents to ensure 100% coverage of requirements
  • Automated Sanity test cases using QTP to determine the stability of the build
  • Prepared automation test scripts and used HP quality center version control the scripts and executes the same
  • Uploaded documents to confluence (Wiki) and managed document versioning.

Confidential

Responsibilities:

  • Coordinated with developers for SRS walkthrough and query resolutions.
  • Prepared Test Deliverables/Test Cases- BK & ARE Regression Cases, Query Tool, Revalidation, BK Vendorfeed and BK IT Test cases.
  • Prepared Test planning and Test data.
  • Managed all test deliverables in RADAR and Confluence.
  • Performed Regression testing on Brickhouse code.
  • Performed Integration and functional testing on Query tool.
  • Prepared Test Reports daily to track the Test completion in Excel sheet.
  • Logged issues and linked to test cases in RADAR tool.
  • Prepared project layout design using OmniGraffle drawing tool.
  • Organized documents on Wiki online tool.

Confidential

Responsibilities:

  • Preparing Test cases for BTS Integration and ART Expansion Phase I regression.
  • Prepared the Test Data by coordinating with AOS and POS team for BTS testing.
  • Uploaded Test cases to RADAR, relating issues to test cases and tracking them.
  • Performed System testing on BTS code.
  • Conducted Compatibility testing on MAC, IPad, Iphone and window.
  • Prepared Test estimation for every Test Cycle using MS Excel.
  • Performed performance testing using Stubs.

Confidential

Responsibilities:

  • Involved in SIT, Database, Compatibility and Performance testing.
  • Analyzed the different services integrated with ART application like XCard, MRT, etc
  • Coordinated work with offshore team on weekly bases.
  • Prepared the Test Data and Test Plan for testing every new build.
  • Reviewed all deliverables preparation like Performance Test cases and Test reporting.
  • Performed performance testing ART application using FireBug tool
  • Follow up with issues and clarified them during offshore status calls.
  • Logged issues and tracked the issue status in RADAR tool.

Environment: JAVA, RADAR, SQL Developer, Oracle, Windows (IE), MAC (Safari, Firefox, Chrome), Confluence, IPad, Firebug, IPhone

Confidential, San Bruno

Responsibilities:

  • Coordinated with Confidential subject matter experts for project level discussions and query resolutions.
  • Analyzed the data flow from Product Download, Stores-VUE, Stores-PFI, VUE - PFI
  • Prepared the Test Data, Test Plan, Test Scenarios and Test Cases.
  • Organized test cases in Quality Center and linked to requirements for traceability.
  • Prepared Test estimation for every Test Cycle using MS Excel.
  • Providing Knowledge Transfer to Offshore Team about RFID components and data flow.
  • Responsible for Integration testing between all the 6 components of RFID i.e. Stores, RA, PFI/RMS, Prompt, VUE, RFID (ICOD)
  • Assigned work to offshore team on daily bases.
  • Requirement changes required re-estimation of the affected interface.
  • Worked with Datastage, Mainframes and Putty (Jobs, Scheduler and Events) by triggering the jobs.
  • Manage communication with Test Lead, Project Lead on daily status meeting.
  • Performed dry run of all Smoke Test Cases.
  • Worked closely with other supporting teams like Stores, POSAS, Revenue Accounting, PFI etc
  • Collaborate with Confidential lead to identify and manage testing risks proactively
  • Conducted Data Validation using Oracle SQL queries after running the jobs.
  • Logged and tracked the defect using Quality Center.
  • Overall accountability for the project deliverables.

Environment: JAVA, Mainframes, Putty, Quality Center, DB2, Oracle, UNIX, Windows NT/ 2000, TOAD, Datastage, Share point (Project Management), Citrix

Confidential, PALO ALTO, CA

QA Consultant

Responsibilities:

  • Raised request for all the applications for testing purpose.
  • Arranged knowledge sessions with Test Lead with Test Team.
  • Analyzed the transaction workflows to develop test cases when new features get released.
  • Manually tested the ad platform application on every new release.
  • Test ad banners in various formats (JPEG, GIF, BMP, SWF, PNG) and check in different versions of flash player.
  • Provided the feedback to Test Lead for daily assigned work.
  • Uploaded the test cases in TRAC (Project Management system).
  • Performed functional test execution on the online video applications.
  • Performed backend testing to ensure the correctness of the workflow
  • Conducted Data Validation using SQL queries.
  • Filed bugs in a defect tracking tool and verify fixed bugs in every new release.
  • Submitted Test results to Test Lead and uploads to TRAC.
  • Worked closely with Test Lead and developers in discussing the Issues/Defects.

Environment: Windows NT/ 2000, MySQL, TRAC (Project Management)

Confidential, CHICAGO, IL

SQA ANALYST

Responsibilities:

  • Attended JAD Sessions with Business Analysts to gather and analyze requirements.
  • Analyzed the transaction workflows to develop Test data and test cases.
  • Reviewed the requirements, Developed the Test Plans, Designed and Reviewed the Test Scenarios & Test Cases, and Prepared the Requirement Traceability Matrix
  • Organized test cases in Quality Center for traceability.
  • Prepared Test estimation and Test metrics documents using MS Excel.
  • Performed vigorous black box testing to ensure the correctness of the application.
  • Analyzing XML requests and response files to verify data accuracy.
  • Executed XML test scenarios to validate the transactions and file format.
  • Coordinated the test activities with Quality Assurance team.
  • Executed Smoke Test Cases using QTP to ensure that the build is testable
  • Developed and executed various Test Scripts using QTP for Functional and Regression Testing of different versions of the application
  • Conducted Data Validation using SQL queries.
  • Performed data warehouse testing after the informatica loads to check the referential integrity of the tables
  • Performed adhoc query analysis to test the data
  • Validated OLTP to OLAP data after the informatica.
  • Logged and tracked the defect using Quality Center.
  • Participated in Defect Review meetings with Business users and Development team.
  • Prepared weekly/daily status reports & Test Metrics using Quality Center.
  • Performed Compatibility Testing to verify the browser compatibility on IE and FireFox

Environment: ASP.NET, XML, Oracle, UNIX, Windows NT/ 2000, Web services, SoapUI, HP Quick Test Professional (QTP), WBS Chart Pro, Quality Center, TOAD, RUP, Informatica

Confidential, SOUTH PORTLAND, ME

Automation Test Engineer

Responsibilities:

  • Conducted Formal Reviews of Software Requirement Specification and Design documents.
  • Designed Test Plan, Test Cases using Quality Center for end-to-end system testing.
  • Created manual test cases and test suites for different modules in Siebel Sales application.
  • Executed Smoke and Regression Automated Test Scripts as a Batch using QTP.
  • Customized Scripts to in corporate GUI Check points, Data Driven testing using Data Tables, Output Values.
  • Created Virtual Objects and mapped to the existing Siebel standard objects.
  • Implemented Regular expressions and parameterized checkpoint properties.
  • Executed SQL queries for Back-end testing.
  • Tested the conversion data into Siebel OLTP by running SQL scripts
  • Performed Data validations on the Oracle Datawarehouse after the loads
  • Handled unexpected errors at time of playback using Recovery Scenario wizards.
  • Performed OBIEE report testing by running lot of adhoc queries on the warehouse.
  • Prepared Status Reports with “Pending-Open” Issues and report to the client on weekly basis.
  • Maintained Defects, Test Scripts, Requirements & management of test suites using Quality Center Tool.
  • Implemented testing activities as per AUP (Agile) software methodology followed by project team.

Environment: Quick Test Professional, Quality Center, VB Script, Oracle SQL, Siebel testing, UNIX, JAVA, Informatica, OBIEE.

We'd love your feedback!