Sr. Qa Analyst Resume
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.