SUMMARY

• Senior Quality Analyst/Test Lead with 10+ years of experience in Software Testing across Logistic, HealthCare, E - commerce, Travel & Transport domains.
• Experience in Database testing and data warehouse testing using ETL tool.
• Extensive experience in MS SQL and Teradata.
• Experience on SSIS and Informatica ETL tools.
• 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.
• 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.
• Involved in daily stand up meeting and sprint planning as part of Agile Methodology.
• 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, 2010, Teradata, SSIS, Informatica

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

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

Other Tools: Citrix, MS Visio, MS Office, Saber, GAME, Pluck

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

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 TSQL queries to access and validate data from different database tables.
• Worked on Teradata 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
• Involved in UAT testing phase which includes creating test data preparation for client acceptance testing.
• Involved in UAT defect testing
• 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, JAVA, Windows, MS Office, SharePoint

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.
• 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.
• 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.
• 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.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• 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.

Technologies: 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.
• 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.
• Used HP QC 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.

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.
• 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 inDeveloping TestStrategy 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.
• 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 baseby runningSQL 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 QALead 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.

Technologies: 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.

Technologies: 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.

Technologies: 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.

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