SUMMARY

• Have 7+ years of experience with Result - driven IT Professional with referable & strong experience in SoftwareManualandAutomation Testingfor Web based and Client/Server applications.
• Thorough understanding on SDLCandQuality Assurance lifecycle and all phases ofTesting Life CycleandBug Life Cycle.
• Expert in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.
• Proficient in developing & maintaining Test Plans, Test Cases, Test Procedures and Test Scripts for Manual and Automated testing.
• Expert in different types of testing likeAutomation testing,Manual testing, Integration testing, System testing, Regression testing, JUnit testing, Black box testing, Functional testing, Compatibility testing, Database testing, GUI testing, Web / UIand(UAT)User Acceptance Testing.
• Extensive experience inSelenium WebDriver, Selenium RCandSelenium Grid.
• Expertise in Automation tools such asSelenium WebDriver, Selenium IDE, Selenium Grid, Java, Jenkins & UDeploy (Continuous integration, Regression tests), Maven (Regression tests), Cucumber, TestNG (Regression tests), Eclipse, Junit and JMeter.
• Experience in validating data in databases with SQL validation queries, verify trigger execution, DB metrics tracking.
• Expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing.
• Experience in developing and executing test casesmanuallyand developedAutomation scriptwithSelenium IDE and Selenium Web driver.
• Experience in performing backend data integrity tests using SQL queries.
• Extensive experience in manual testing the ETL and Business Intelligence Applications.
• Strong experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse.
• Expertise in different types of testing likeDatabase testing, Automation testing,Manual testing, Integration testing, System testing, Regression testing, Functional testing, Compatibility testing, GUI testing, and(UAT)User Acceptance Testing.
• Proficient in using ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using SSIS.
• Good experience onLinux, Windowsplatform.
• Possess good communication skills, analytical skills, self-motivated, proactive, task oriented, good team player, and quickly learn at new technologies and systems.
• Extensive experience in SQL, Stored Procedures, Packages, Triggers, Joins in Oracle, SQL Server.
• Have Good analytical and presentation skills.
• Ability to work independently, as well as strong team player, while demonstrating strengths in leadership and mentoring.
• Commitment to quality; ability to work under tight deadlines; strong attention to detail; ability to communicate and articulate technical problems in a concise and coherent manner.
• Having good judgment skills while reporting and prioritizing software bugs in conjunction with the Development & QA Managers.

TECHNICAL SKILLS

Testing Methodologies: Manual and Automated Testing, User Acceptance Testing, White/Black box testing, Regression Testing, End-to-End/Integration Testing.

Test Approaches: Waterfall, Agile/Scrum, SDLC, STLC, Bug Life Cycle

ETL Tools: Informatica, SSIS

Databases: MySQL, Oracle 10g/11g, SQL Server, DB2

Testing Tools: Selenium Web Driver/IDE/GRID/RC, SOAPUI, Eclipse, JMeter, Firebug

Frameworks: TestNG, Page Object Model, Data Driven, Hybrid Testing, TDD, BDD, JUnit, log4j

Defect Tracking Tools: JIRA, HP Quality Center, ALM

Test Build & Integration tools: Jenkins, Maven

Programming Languages: C, Java

Scripting Languages: JavaScript

Markup Languages: HTML, XML, XPath, CSS

MS Office Tools: Word, Power Point, Excel, Outlook

PROFESSIONAL EXPERIENCE

Confidential - Alpharetta, GA

Sr.QA Automation Tester

Responsibilities:

• Created Test plan, High-level scenarios, test case construction and test estimates, resource estimates and weekly status reports.
• Verify the daily/weekly UPS freight data ETL pipeline is executed properly and validate the data in every step of the pipeline.
• Wrote complex SQL queries for validating Business Reports.
• Querying using SQL and updating records and validating database records as expected.
• Created frameworks using Selenium Web Driver, Postman, XML, JSON, JavaScript, Test Driven DevelopmentandData Driven frameworksetc.
• Attended triage meetings to understand and consider the scope changes for the release during the test execution phase.
• Generated defect reports, bugs validation with toolsTest Director / Quality center.
• Migrated scripts fromSeleniumIDEto SeleniumWebDriverand created framework scripts from scratch.
• Performed backend testing to verify the data integrity by passing SQL queries
• Performed data accuracy, data validation and data integrity testing by querying the database using SQL queries to check the data table on server.
• Involved in Code Verification to validate the exceptions written in the code.
• Used Ant for build management and continuous integration.
• Participated in weekly meetings to track the progress of testing effort.
• Automated scripts in Internet/Internet applications usingSelenium Web DriverandSOAP UI.

Environment: SeleniumIDE,SeleniumWeb Driver,HP Quality Center 10.0/9.0, Manual Testing, Agile, Eclipse, Java, XML, HTML, MS SQL, SQL Server 2016, Oracle, Informatica, Test Director, Jira, HP ALM11.0, SSIS

Confidential

Sr QA Automation Tester

Responsibilities:

• Analyzed theBusiness Requirement Document (BRD)andFunctional Specification documents (FSD)to prepare Test Cases based on the Test Plan and Use Cases and attended review meetings to better understand the applications.
• Analyzed test data and ConductedDatabase or Data driven testingunder certain business rules for data population in DB.
• Tested the ETL process for both before data validation and after data validation process.
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Involved in querying using SQL and updating records and validating database records as expected.
• Attended triage meetings to understand and consider the scope changes for the release during the test execution phase.
• Migrated scripts fromSeleniumIDEto SeleniumWebDriverand created framework scripts from scratch.
• Performed backend testing to verify the data integrity by passing SQL queries
• Execution of test suites andHTMLreport generation usingTestNG.
• Track the test results in QC ALM based on Test Plan upload Scripts and Test execution under Test lab.
• Track the defects in QC ALM and linkage will be shown in JIRA for developers to resolve the issue.
• To have the conversation with the developer in Daily Scrum call, If they need inputs to get clarity on the defect.
• Follow the Agile methodology to closure on JIRA User story and give the final sign-off on each assigned user story.
• To attend the retrospective meeting on each sprint ends and give the better improvement points to Scrum Master for upcoming Sprint cycles.

Environment: Oracle, Informatica, HP ALM11.0, SeleniumIDE,SeleniumWeb Driver,HP Quality Center 10.0/9.0Agile, Eclipse, Windows, Java, XML, HTML, Test Director, Jira

Confidential

QA Consultant

Responsibilities:

• To gather Requirements from Business to Achieve End to End testing completion.
• As Test Coordinator to interact with various test system teams and to complete the end-to-end testing on time.
• To prepare a test execution summary report, defect metrics based on HP ALM test conditions status and publish the weekly & daily report to the team management.
• Interpret application architectures and identify areas forautomation.
• Developed & executedSQLqueries in the database to conductData Integrity testingby checking the data tables on the server.
• Coordinate with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema Design (Star Schema) and maintenance.
• Created Test plan, High-level scenarios, test case construction and test estimates, resource estimates and weekly status reports.
• Conducted Test Case walkthroughs to achieve consensus on Test Case correctness & completeness ensuring width and depth of test scenarios.
• CreatedJavabased scripts forSelenium Web DriverwithJunitas automation framework.
• PerformedCompatibility testingof applications for dynamic and static content of browsers usingHTML IdsandXPathinSelenium.
• Updated framework functions developed test scripts usingSelenium Web Driver.
• Conducted Cross browser testing in IE, Chrome and Firefox usingSelenium.
• Managed Test results and defects usingBugzilla defect tracking tool.
• Created queries inTFSto validate results ofTFS reports.
• Prepared user documentation with screenshots forUAT (User Acceptance testing).

Environment: Selenium, JUnit, SVN, JIRA, JMeter, Quick Test Pro, Quality Center 9/10, PL/SQL, Agile, TFS, HP Loadrunner 9.1, XML, Java, Microsoft Visual studio, Web Services.

Confidential

Quality Assurance Engineer

Responsibilities:

• Analyzed requirements documents to formulate a detailed test plan, test cases and conducted manual testing for the different phases of the entire application.
• Involved in System Test Plans, Test Strategy and created System Test Cases based on the business and system requirements to test the functionality of the system.
• Involved in Mobile based application testing which includes CDMA, GSM series.
• Testing a single mobile application across multiple devices running on the same platform.
• Involved in validating output on Mobile i.e., which mobile network supports the application.
• Responsible for converting English text to Hindi language and to check which mobile series supports Hindi text.
• Performed Requirements based testing (Unconventional Testing) on SRS and BRD.
• Created Change Requests (CR).
• Written manual test cases in Microsoft Word, organized, executed the test cases efficiently.
• Created Data Driven Tests that randomized the test data, for testing the UAT with real time test conditions
• Parameterized test scripts to ensure a unique set of data inputs.
• Performed Manual, Functional, System Testing Regression Testing
• Created Unix scripts for automation of some test cases.
• Conducted Negative and Positive testing
• Created various reports like Test Prep report, Test Execution Report, Testing Summary Report
• Extensively used Quality Centre to track bugs and writing test requirements and test cases
• Reported the bugs and Email notifications to the developers.
• Created a Load test plan and analyzed result files generated after each run of load test and exported the data to actual results in the test report.

Environment: Java, JMeter, Quick Test Pro, Quality Center 9/10, PL/SQL, Agile, TFS, HP Loadrunner 9.1.