We provide IT Staff Augmentation Services!

Sr.qa Automation Tester Resume

Alpharetta, GA

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.

Hire Now