SUMMARY:

• QA Tester with 3 years of extensive experience mainly in testing Web Applications and DWH/BI applications for various industries Data Modeling, Data Extraction, Data Loading and Data Analysis using Manual Testing Techniques and Automated.
• Experienced in developing Use Cases, Test Plan, Test estimates, Test Approach, Test Scenarios, Test Cases and Traceability Matrix from Business Requirement Documents (BRD) and Functional Specification Documents (FSD).
• Proficient in preparing Test data, Executing Test cases, Reviewing, Tracking Defects, Reporting Defects, Weekly Test Reports & Defect Metrics.
• Skilled with various testing phases including Black - Box testing, Regression testing, System testing, Integration testing, UI testing, End to End (E2E) testing, Adhoc testing and User Acceptance Testing (UAT), Performance Testing.
• Expertise in working with Selenium IDE and Selenium WebDriver using TestNG java framework.
• Hands on experience in writing CSS Selectors, Xpath expressions to identify web elements using Plugins like Firebug and Firepath in Selenium.
• Have experience on integration tool with Selenium like Jenkins.
• Proven ability in writing Gherkins using Cucumber and designing scripts for features.
• Worked with GitHub source code management tool in Selenium WebDriver.
• Extensive experience in ETL and BI testing of DWH applications and reporting applications.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements that were developed in ETL and BI of DWH applications and reviewed scripts for positive and negative test scenarios, and prepared test summary.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Excellent QA experience in all phases of Software Testing Life Cycle (STLC) and Software Development Life Cycle (SDLC) with good working knowledge of QA methodologies like AGILE, Scrum and Waterfall.
• Writing and executing SQL for checking the validity and integrity of the data in various databases such as Oracle, My SQL, and Microsoft SQL Server etc. to perform Back-End-Testing. are used in different scripts.
• Experience in Microsoft Visual Studio and Eclipse .
• Experience in testing tool like Test Complete which creates automated test for Microsoft windows or web application.
• Extensive experience working with Data warehouse ETL tools like SSIS Tool.
• Experience in testing and writing SQL and TSQL statements.
• Hands on experience in writing SQL queries, Joins, Functions, Procedures, Packages, DBMS, RDBMS and SQL Server databases.
• Possessing strong analytical skills, an excellent team player with good leadership qualities and strong oral and written communication skills.
• Experience in testing Middleware technologies IBM WebSphere MQ, SOA, Web Services like SOAP, REST testing using SOAPUI Pro.

TECHNICAL SKILLS:

Languages: C, SQL, Java, .net

Database: SQL, SQL Server, Oracle

Web Technologies: HTML, DHTML, XML, JSP

Scripting languages: JAVA Script

Operation Systems: Windows

Defect Tracking Tools: HP ALM, Bugzilla, Test director

Testing Tools: JIRA, Selenium, SoapUI, Appium, QTP, Cucumber

Front End Tools: MS Office, MS Project Professional, MS Access

Web Browsers: Internet Explorer, Mozilla, Firefox, Chrome

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Jr. QA Analyst

Responsibilities:

• Interacted with Product Owner, Customers and Project team members in analyzing the User stories and acceptance criteria.
• Involved in Requirement gathering, and Preparation of test cases based on Product Backlog.
• Performed manual testing of the application to test the system for both functional and business requirements for positive and negative scenarios using ALM/Quality Center 12.0.
• Worked in Agile development environment and participated in the Test Plan and Test Strategy creation.
• Designed, developed, and executed automated tests using Selenium WebDriver using Java Programming.
• Performed cross browser compatibility testing on Chrome, Firefox, IE browsers using TestNG.
• Involved in Regression testing and creation of automation scripts for web pages.
• Developed BDD Automation framework using Cucumber and developed Features, Scenarios, Step definitions.
• Handled the special mouse events and selected the options from the drop-down menu using Selenium actions builder, mouse hover and synchronization.
• Used Junit as a Unit Testing framework by adding different annotations
• Attended sprint plan meetings every two weeks to review the user stories and daily SCRUM meetings.
• Worked with various databases SQL Server Management Studio for Reporting database, Oracle database.
• Expertise and experience in performing various kinds of testing like Functional, GUI, Integration, Backend, Regression and System Testing.
• Used JIRA for agile project management and issue tracking.
• Prioritized the defects and the severity levels using Quality Center and discussed with the developers to resolve the issues.
• Performed back-end testing on the SQL database by writing SQL queries.
• Developed SQL Queries to validate database.
• Participated in UAT Testing and act as a UAT coordinator and helped UAT tester to set up the Test environment, Test Data with User Ids in to UAT environment.

Environment: QC/ALM, Selenium, Java, Cucumber, SOAP UI, SQL Server, Oracle, TestNG, JIRA.

QA Analyst

Responsibilities:

• Was responsible for writing test cases, documenting bugs, and communicating with Development to get them fixed.
• Researched and analyzed the software requirements, workflows and designs to define detailed test suites, test cases, test data and procedures.
• Created complex manual Testing test cases from approved requirement and design documents and traced them to the relevant use cases.
• Assigned the tasks of preparing test scripts and perform white-box testing
• Reported and entered defects and issues in Clear Quest.
• Performed Manual and Functional Testing to test the functionality of the application and modules.
• Validated test to check boundary conditions and error messages.
• Analyze data to identify areas for improvement in the quality system.
• Manually performed functional, GUI, regression Testing, User Acceptance testing, and End-to-End Testing.
• Developed SQL queries to perform backend testing of the database.
• Created progress reports to ensure appropriate test coverage and results.
• Created bug reports and test summary.
• Assigned responsibilities of testing web-based applications as required.
• Responsible for documenting work for quick references Guide utilizing MS WORD.

Environment: MS SQL, JAVA, MS Word, Visual Studio, HTML, JAVA Script, CSS, JIRA.

Jr. Manual QA Analyst

Responsibilities:

• Wrote SQL Statements to extract Data from Tables and to verify the output Data of the reports.
• Performed back-end testing on the SQL database by writing SQL queries.
• Collected, analyzed and reported testing metrics, executed SQL queries.
• Built and maintained effective QA test lab environments.
• Tested several complex reports generated by Tableau Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Used Query Studio to test ad hoc reports.
• Developed SQL queries in Toad and DB Artisan to achieve the data transformations.
• Participated in various meetings and discussed Enhancement Request issues.
• Conducted Regression testing after the bugs have been fixed by the development team.
• Analyzed the Requirements and prepared Test Cases for module, integration and system testing.
• Developed Traceability matrix, Test Data's for the test cases.
• Analyzing the Test Cases prepared by other team members.
• Developed SQL Queries to validate database.
• Interacting with business analyst to make sure business workflow scenarios are tested.
• Performed Functional, Smoke, Integration, System, Regression, End- to-End Testing.
• Responsible for updating and maintaining Version One for tracking the status of the project.
• Follow up the bug life cycle, provided status and progress reports.
• Defect Tracking and Reporting, logged defects using JIRA tool and reported it to the developer.
• Prepared Summary Reports, attended Review Meetings within the Team.

Environment: MS SQL, .Net, MS OFFICE, Visual Studio, Windows XP, 7, 8, HTML, JIRA.

Jr. QA Analyst

Responsibilities:

• Plan and prepared Software test process, Software Test Plan and all process documents and templates related to software testing.
• Used Quality Center to store all testing results, metrics, created Test Cases, and Reporting.
• Reviewed Business requirements, IT Design documents and prepared Test Plans which involved various Test Cases for all assigned module/projects; Review Test Requirements, Creating Test Plans and Test Strategy documents.
• Developed a Defects Tracking Log for the SharePoint Site to track defects while testing.
• Involved in UAT testing, SIT Testing, Regression Testing and Functional testing.
• Automation test script execution and defect reporting.
• Running automation scripts for regression testing.
• Test artifacts maintenance in SharePoint.
• Creating of Test report and Metrics graphs.
• Attending biweekly project meeting and daily scrum meeting.
• Facilitated organization’s Quality Assurance activities covering CMMI and ISO Audits.