SUMMARY

• Over 8 years of experience in software testing processes which include Test Planning, Test Cases Design, Test Environment Setup, Test Data Setup, Defect Management, Configuration Management, Test log, Test results, Test Traceability Matrix and Test Metrics.
• Involved in all the stages of the software development cycle (SDLC), namely design, specification, debugging, testing (test plan and test execution), integration and system testing.
• Working awareness on Ecommerce, Healthcare, Financial and Insurance domain.
• Experienced in various software testing subjects like functional testing, database testing, compatibility testing, usability testing, intersystem testing and other non - functional tests.
• Expertise in ETL and BI report testing using Teradata, Informatica and Cognos BI suite.
• Writing/Executing automated Test Scripts and Test Scenarios using HP QTP 10.0
• Experience in test management and defect tracking tools like Quality Center, ALM and Clear quest.
• Familiar with Agile Methodology (Sprint and Scrum), Waterfall and V Model.
• Ability to test backend applications by writing complex SQL queries.
• Well versed in writing, understanding the UNIX commands & scripts.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Extensive experience in developing Test Traceability Matrix and Gap Analysis.
• Well versed in analyzing Results, Bug Tracking & Reporting, Detailed status reporting
• Experience in Web Services and Web Application Testing using SOAP UI.
• Working knowledge of Microsoft operating systems, Microsoft office applications (word, excel, outlook) and Windows environment.
• Strong in communication and active participant in review meetings.
• Efficient in interacting with developers and other team members to ensure high quality software is delivered

TECHNICAL SKILLS

Software Testing: Manual, Database and Automation Testing.

Testing Tools: Quick Test Professional, Win Runner, SOAP UI

Bug Reporting Tools: Quality Center, TFS, ALM, Clear Quest

Languages: C, C++, VB Script, PL/SQL

RDBMS: Oracle, SQL, SQL server and SQL Developer

Web Technologies: VBScript, HTML and XML

Operating Systems: UNIX, Linux, Windows XP, 7 and 2003.

Packages: Word, Excel, PowerPoint, Project Pro, Outlook Express.

Reporting Tool: Cognos, Microstrategy, Report Studio, Query Studio, Analysis Studio

ERP: JD Edwards, Forms, Reports

Other Tools: Teradata, Mainframes, Informatica.

PROFESSIONAL EXPERIENCE

QA Lead

Confidential, Minneapolis, MN

Responsibilities:

• Has good experience in working as a Release Lead for ICMP project and coordinating the efforts of the release and managing a team of about 6 people in offshore.
• Has good knowledge and working experience in imaging services, Loan servicing applications & handled multiple projects individually.
• Has good knowledge and working experience in writing different types of SQL queries based upon project requirements.
• Has working experience in Web Services and Web Application Testing using SOAP UI
• Used the Unix shell script commands to verify the logs flowing to downstream applications
• Has experience in gathering Business Requirements, Functional Requirements and Design Documents.
• Experience in preparing Ambiguity reviews based on FSD and BRD.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Participated in BRD and FSD design review meetings for different projects
• Experienced in reviewing the test cases and ambiguity reviews prepared by the offshore team and guiding them throughout the entire release
• Has experience in providing High level QA work estimations for test case design and execution
• Used ALM & Clear Quest to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Has experience in preparing and gathering the test data based upon the project requirements
• Has good experience in documenting all the project documents and registering them in MADC for governance review.
• Has experience in performing smoke test after each deployment.
• Arranging & participating in meetings with the business to clarify different questions regarding the ambiguity reviews & following up with them continuously until all the questions are clarified.
• Re-running of the Test Scripts after deployment of each new build in the application for identification of errors and manipulation of the script for Customization of Testing Process
• Participated in daily status meetings and defect calls to report issues.
• Communicated with developers through all phases of testing to prioritize bug resolution using CDTS
• Has experience in creating the Traceability matrix based on Functional requirement in each module.
• Experienced in Onsite and Offshore model.
• Good knowledge in developing automation test scripts using Quick test Professional and managed testing activities using ALM

Sr QA Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Designed and Analyzed Test case design document based on the Functional Requirement Specifications to implement thorough testing process.
• Ability to test backend applications by writing complex SQL queries.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Performed database testing using complex SQL queries and performed the data validation.
• Designed and implemented test cases for database protection and recovery.
• Identified bugs in database and created reports for modification requests and resolved all issues.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Designed and Analyzed Test case design document based on the Functional Requirement Specifications to implement thorough testing process.
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for each module.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Re-running of the Test Scripts after deployment of each new build in the application for identification of errors and manipulation of the script for Customization of Testing Process
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Coordinated user acceptance testing with final users. Prepared end user documentation for the new system
• Interacting with Development team and Users as part of Scrum Methodology.
• Used ALM to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in daily status meetings and defect calls to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using ALM

BI QA Analyst

Confidential, Minneapolis, MN

Responsibilities:

• Responsible for gathering Business Requirements, Functional Requirements and Design Documents.
• Performing Informatica Jobs to fetch the data.
• Used Cognos Report Studio to run the reports and validate the report output with the database.
• Used to run ETL jobs in ETL tool Workflow manager and also monitor the status of jobs in Workflow monitor.
• Validated the prompt conditions, filters, calculations and other conditions in the reports.
• Analyzed the report properties of different types of reports like list, crosstab, chart to validate the data.
• Performed database testing using complex SQL queries and performed the data validation.
• Designed and implemented test cases for database protection and recovery.
• Identified bugs in database and created reports for modification requests and resolved all issues.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for each module.
• Modified and Executed automated and manual test scripts for different modules using QTP.
• Re-running of the Test Scripts after deployment of each new build in the application for identification of errors, and manipulation of the script for Customization of Testing Process
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Coordinated user acceptance testing with end users. Prepared end user documentation for the new system
• Interacting with Development team and Users as part of Scrum Methodology.
• Used Quality center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in daily status meetings and defect calls to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using QC.

ETL Tester

Confidential, Raleigh, NC

Responsibilities:

• Responsible for analyzing business and technical requirements.
• Involved in the Cognos Report testing and DWH testing of the application.
• Query from any Teradata Production database in order to perform data quality validation
• Read/Select the Teradata production environment and Investigate the Data Issues
• Performed data drive testing to validate the same set of operation with different set of data
• Perform database testing using SQL queries and performed the data validation.
• Extensively involved in backend testing and Performed tests on back up databases and recovery.
• Responsible for development of Test Plan and Test Cases and checking the screens for Quality Assurance.
• Performed Functional, Integration, Database, Security, UAT and E2E testing at various phases of development and test cycles.
• Involved in Defect Management by creating and tracking the defects using Quality Center.
• Created Test Case Reports, Defect Traceability Matrix reports and Traceability Matrix reports to make sure all test cases are executed.
• Developed Test Plans, Test Specifications, Defect reports, Status reports and Test completion reports.
• Responsible in reviewing and accepting testing efforts done by offshore team from client side and Quality Services Sign off documents.
• Created issues list on a daily basis to discuss with the Development team and Business User to prioritize the issues based on a severity of defects.
• Prepared Test Data and Executed Test Cases and used Quality Center for defect tracking.
• Maintained the list of Defects encountered during the testing and verified the defects once claimed to be fixed by the Development team

QA Analyst

Confidential, Branchville, NJ

Responsibilities:

• Designed and Analyzed Test case design document based on the Functional Requirement Specifications to implement thorough testing process.
• Analyzed and Developed Test Plan, Test Cases, Test Scripts, Expected Test Results and Test Procedure from functional requirement for each module.
• Extensively involved in writing and designing templates for the Test Plans and Test cases
• Performed Functional, Positive, Negative, Integration, Regression, End to End and User Acceptance testing.
• Extensively involved in backend testing and used Joins, SQL functions and sub-queries involving multiple tables from different databases.
• Designed and developed automation test scripts using Quick test Professional and managed testing activities using QC.
• Design and Implementation of the Automation framework, formulating the driver script and the requisites
• Modified and Executed automated test scripts, analyzed the results and reported bugs in QC.
• Enhanced QTP scripts for different modules using recovery scenarios for error handling
• Re-running of the Test Scripts after deployment of each new build in the application for identification of errors, and manipulation of the script for Customization of Testing Process
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using QC
• Prepared and Presented weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using QC.
• Involved in creating the Traceability matrix based on Functional requirement in each module.
• Coordinated user acceptance testing with end users. Prepared end user documentation for the new system
• Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Expertise in generating the daily defect detailed report using QC for the other project stake holders and the project Management

JDE QA Analyst

Confidential, San Jose, CA

Responsibilities:

• Designed and Analyzed Test case design document basing on the Functional Requirement Specifications to implement thorough testing process.
• Performed integration and unit testing of Web Applications.
• Testing of Web Application to perform the Orders Processing.
• Wrote Functional test cases and prepared test data for Web application testing.
• Research suspected or reported issues with data quality and maintained the Quality Standards set by Project.
• Performed Functional, Negative, Positive, Integration, Regression, End to End and User Acceptance Testing.
• Worked with the Developers and the Test Lead to verify the Test Cases.
• Analyzed and Developed Test Plan, Test Cases and Test Procedure from functional requirement for each module.
• Coordinated user acceptance testing with final users. Prepared end user documentation for the new system
• Used Quality Center to store all testing results, metrics, implemented Test plan Document, created Test Cases, Defect Tracking & Reporting.
• Participated in status meetings to report issues. Communicated with developers through all phases of testing to prioritize bug resolution using Quality Center
• Prepared and Presented daily, weekly and monthly QA Defect and Status Reports to the different Stake holders of the project using Quality Center.