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.