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.