PROFESSIONAL SUMMARY:

• Senior Quality Analyst/Test Lead with 10+ years of experience in Software Testing across Logistic, HealthCare, E - commerce, Travel & Transport domains.
• Certified ISTQB Foundation Level tester.
• Experience in Database testing and data warehouse testing using ETL tool.
• Expert in developing test plans, test cases, test data, test checklist, defect tracking and reporting.
• Proficient in performing different kind of testing like Smoke Testing, System Integration Testing (SIT), Integrated Functional Testing ( IFT ), User Acceptance Testing (UAT), Functional Testing, Regression Testing, GUI Testing, Ad-hoc Testing, Database Testing, Browser Compatibility Testing .
• Extensively involved in gathering requirements, developing Test Plans and Test Cases using user case documents.
• Good experience in User Interface Testing of client server & web based applications, Database and Data warehouse Testing.
• Worked on DevOps environment with test automation.
• Extensive experience in testing of client/server, WEB Based, Stand-alone and database applications developed in Java, ORACLE and Windows etc.
• Strong knowledge and experience in all phases of Software Development Life Cycle (SDLC), Agile Methodology and QA Life Cycle (STLC).
• Experience in analyzing and understanding business requirements and functional specification documents.
• Experience in Adhoc testing, Integration Testing, Retesting, Regression Testing, Positive and Negative Testing.
• Manual Testing experience involves Test Planning, Test scenario creation, Test case writing, Test data creation using MS Excel and DB validation, Defect reporting with Test and Defect management in ClearQuest/Quality Center/Jira.
• Experienced in working with the Business Analyst to understand the business process and develop Test Strategy.
• Expert in Test case Execution, debugging and Daily status reporting to the manager and other project members.
• Closely worked with the developer and the other testers to solve any technical and end user issues.

TECHNICAL SKILLS:

Databases: Oracle 11g/10g, MS SQL Server 2012, MS Access 2010, Teradata, SSIS, MySQL

Languages: SQL, PL/SQL, Visual Basic 5.0, C#, Core JAVA.

Testing Tools: Selenium2.0, HP Quality center 9.2, IBM Rational Clear Case 8.0, IBM Rational Clear Quest 8.0, JIRA, Silverlight defect tracking tool.

Other Tools: Docu corp Software, Citirix, MS Visio, MS Office, Saber, GAME, Pluck

Methodologies: SDLC, STLC, V-model, Waterfall, Agile SCRUM, Incremental

Operating Systems: Windows, UNIX, Linux, OS/400

Web Technologies: HTML,CSS, XML, Java Script.

Version Control Tools: VSS, SVN

PROFESSIONAL EXPERIENCE:

Confidential, OH

Sr. Test Analyst/ Test Lead

Responsibilities:

• Analyzed system requirements, developed & executed detailed Test plan, Test cases .
• Participated in various meetings with Project Managers to discuss the status of the testing and decided the best suitable test process/procedure to be followed.
• Followed and Implemented Agile development process methodology throughout application development and testing.
• Designed and developed Requirement Traceability Matrix (RTM) to track overall tests Coverage for release work.
• Created Test Cases for System Testing and Integration Testing .
• Used SQL queries to access and validate data from different database tables.
• Worked on MS SQL Server to access the database.
• Involved with Business and Customers to understand the application.
• Improved Quality Processes in software development by establishing a program of formal Technical Reviews resulting in increased deliverable quality and acceptance.
• Interfaced with Business Users, Application Development Groups and Test Groups.
• Coordinated the Capture, Review, Maintenance and Submission to regulators of all test artifacts.
• Participated in daily Agile Meetings and capture, manage, and follow-up daily action items and Presented testing status to Internal and External Audiences
• Developed Selenium Automation scripts in Selenium IDE, Selenium RC and Selenium Web driver using JAVA
• Developed ‘Data driven’ automation framework using Selenium Web Driver.
• Used Junit for running automation scripts.
• Configured Continuous Integration (CI) testing using Team Foundation Server (TFS)
• Responsible for Web Services testing by validating the XML messages using SOAPUI.
• Worked with Selenium Grid .
• Involved in creating and executing Regression Test Suites using Selenium.
• Responsible for creating the Defect Status Report.
• Responsible for follow-up and coordinating changes to resolve incidents and problems.
• Performed Acceptance, Usability, Cross-Platform and Regression Testing during different stages of the application development.
• Performed System, Functional, Interface, and Integration Testing.
• Responsible for performing various types of process evaluations during each phase of the Software Development Life Cycle, including Review, Walk Through and hands on system testing.

Technologies: Teradata, Informatica, ClearQuest, UNIX SQL Server 2008, Selenium Web Driver, Selenium RC, JAVA, Windows, MS Office, XML editor, Selenium IDE, JUnit, SOAPUI, Team Foundation Server (TFS), Fire Bug, Fire Path

Confidential, Phoenix, Arizona

Senior Test Engineer/Test Lead

Responsibilities:

• Coordinated all QA activities and enhancements using Agile Methodology .
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation Testing.
• Responsible for validation Confidential data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center also tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data .
• Developed and maintained multiple project deliverables such as Test Plans and Test Cases.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Create Crystal Reports, which would facilitate decision-making. The Crystal Reports designed were complex and used formulas, parameters, selection criteria, sub reports etc.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various cruise specialists and the business team.
• Prepared scripts, running tests, Analyzing results in LoadRunner 9.1 for Performance testing.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Executed SQL queries for validation of data and used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Executed and managed test cases and reported bugs in Quality Center.
• Used Clear Quest and Quality Center as the Defect management Reporting tools.
• Performed functional and load testing using SOAPUI .
• Used Clear Case as the Version Control tool.
• Created and executed automated tests for functional, and regression testing using Quick Test Professional using VB scripts.
• Inserted various types of check points including text checkpoints, text area checkpoints and Image checkpoints.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Good knowledge of Financial Products like Derivatives, Equities and Fixed Income.
• Hands on work experience working with offsite team model ; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.

Tools: HP Quality Center, Manual Testing, Saber Red App, GAME, Database Testing

Confidential

Senior Test Engineer

Responsibilities:

• Analyzed Business Requirement Documents (BRD) and Functional Specification Document (FSD) .
• Followed and Implemented Agile development process methodology throughout application development and testing.
• Followed the organization’s standard documentation format for developing test plan, test cases, test data, generated test report and coordinated with development team.
• Attended regular project meetings, workshops with BA, Network Administrators and Developers.
• Reviewed/ modified/ created test cases and test scenarios for different types of testing like Functional testing, System testing, Backend testing, Integration testing, Performance testing, Load testing and Regression testing as per the requirement.
• Involved in performing regression testing as Build Coordinator for verification of daily builds of Code Release to SIT, IFT and UAT server.
• Coordinated with data support team on test data and created various test scenario .
• Involved in validating batch jobs for the transactions with different business scenarios.
• Constructed and executed SQL queries to create test data and validated tables .
• Validated the web service request and response using Soap UI, verified the XML files and data quality.
• Involved in keeping track of SharePoint site that is used to manage project document over legacy system.
• Validated SQL Store procedures and triggers for backend functionality .
• Designed and Implemented Automation Test components using Quick Test Professional (QTP) to handle the functionality and regression testing .
• Created automation test script using shared repository and descriptive programming as well.
• Automated the test scripts using QTP for the GUI, Functional, Data Driven, keyword driven and Regression testing .
• Created Checkpoints using VB function and involved in Parameterization in QTP.
• Used HP ALM extensively to log Defects encountered during the Test Cycle.
• Involved in bug review sessions and coordinated with development team to keep track of bug.
• Gathered test results and created test status reports.

Tools: & Technologies: Java, Oracle, Manual Testing, Mainframe Testing

Confidential, MN

Senior Test Engineer

Responsibilities:

• Analyzed the requirement documents and detailed design documents to prepare test plans.
• Communicated with BA's for questions related to the requirements and use cases.
• Initially performed White box testing with a limited number of test cases to the internal workings of software under test and in the remaining part takes Black Box approach in applying input and just observing outputs.
• Tested the UNIX Shell Scripts of the ETL processes.
• Worked in OLTP and OLAP environment that includes production, QA and development database in SQL Server.
• Involved in Developing Test Strategy and Requirements Tractability Matrix (RTM) to ensure adequate test coverage.
• Involved in Test Case Design with respect to Test Plan .
• Executed Positive and Negative Test cases. .
• Involved in Test Execution and Bug Reporting using Test Director.
• Performed GUI, Functional, Regression and compatibility Testing.
• Used Joins like Inner join, Outer joins while testing from multiple tables.
• Involved in performing various levels of testing like Unit Testing, System testing and Integration testing.
• Develop parameter driven ETL process to map source systems to Confidential data warehouse with Informatica complete source system profiling.
• Performed validation testing for each field in the application for different scenarios with the use of Mercury Test Director and HP QC.
• Used Joins like Inner join, Outer joins while testing from multiple tables.
• Tested PL/SQL procedures used in the ETL batch processes ; used complex SQL queries to verify the data in the database tables.
• Analyzed and validated the data stored in the data base by running SQL Queries using SQL Server 2005.
• Involved in Test Reporting on daily/ weekly basis through company prescribed format.
• Provide accurate and timely testing status reports to the QA Lead and Project Manager.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Executed test cases through Iterative testing for testing the incremental functionality.
• Responsible for communicating with Development Team, Technical Support, Business Support in order to resolve the issues.

Tools: QC (HP-Quality center), Manual Testing, Database Testing, Agile Scrum

Confidential

Test Engineer/ Sr. Test Engineer

Responsibilities:

• Involved in exploratory testing of application for requirement understanding.
• Involved in test case scenario preparation.
• Involved in test case design and test case execution.
• Involved in writing SQL based on user requirement for front end report validation.
• Involved in ETL testing using Microsoft SSIS.
• Involved in defect logging and reporting, in JIRA.
• Involved in preparing traceability metrics and test summary reports.
• Involved in exploratory testing of MetaSolv application.
• Involved in test plan document preparation.
• Involved in client calls for clarifications and test documents walkthrough.

Tools: JIRA, SQL Server 2005, SSIS, ETL Testing, VSS, SVN

Confidential

Responsibilities:

• Involved in automating the manual test cases (Data Preparation) in QC.
• Involved in Functional testing of application for new requirements.
• Involved in Regression Testing of Manual and Automation
• Involved in Bug tracking and Reporting in QC 9.0
• Performance testing on load runner
• Involved in running automation script in QTP.

Tools: HP Quality Center, QTP 9.5, Manual Testing

Confidential

Responsibilities:

• Involved in preparing Test Data.
• Designed Test Cases/ Test Scenarios by going through the Use Cases.
• Involved in the Functional and Regression Testing.
• Involved in Bug tracking and reporting in JIRA.
• Involved in preparing traceability matrix for requirements and test cases.

Tools: QC (HP-Quality center), Database Testing, Postgre SQL, UNIX, JIRA, SVN