Qa Automation Etl Tester

Ashwini

Sr QA Automation Engineer 314-***-**** *******.****@*****.***

Summary:

Around 8 + years of QA experience in Manual and Automation testing of web and mobile applications.

Experience in Requirement Analysis, Test Planning, and creation of Test cases, Test data preparation, Test execution and logging Defects.

Experience in Black Box test methodologies, Functional testing, Integration testing, Sanity testing, Regression testing, database testing using SQL queries, UAT (User Acceptance Test) and end-to-end testing.

Participated in creating Test Scenarios, RTM preparation, Test Plan preparation, Test Procedure Document and Test Reports.

Experience in all stages of Software Development Life Cycle (SDLC), STLC models with Waterfall and Agile and Scrum project environments.

Well expertise in working with Xcode COCOA Android ADB.

Work experience in integrating Automation scripts (Selenium Web Driver) on continuous Integration tools Jenkins for nightly batch run of the script.

Experience in Selenium Web Driver and creation of Automation Framework with POM and TestNG.

Experience in documenting the testing process using MS-Office tools including Word, Excel, PowerPoint and MS-Project.

Experience using Manual testing to troubleshoot systems integration, GUI, Compatibility, User Acceptance Testing (UAT), SOA Testing using web services, functionality, Database and regression testing.

Experience in system testing, integration testing, UAT testing, positive and negative, functionality testing, regression testing, compatibility testing, black box testing and recovery testing.

Experienced in developing and maintaining Test Planning, Test Case Design, Test Script Development, Test Environment Setup, Test Data Setup, Defect Management, Test Log, Test Result and Traceability Matrix.

Expertise in Unit Testing, Integration Testing, Functional testing, System testing, and Regression Testing, User Acceptance testing and end-to-end testing methodologies.

Expert in developing Java Selenium Web Driver/RC/GRID test scripts using Java, JavaScript and Test Frameworks using Junit, ANT, MAVEN build tools.

Experienced in developing Selenium automation framework using Page Object Model architecture.

Well experienced in executing User Acceptance Testing (UAT), Regression Testing, System Testing, Functionality Testing, Performance Testing, Black Box Testing, GUI Testing, Sanity Testing, and Usability Testing for Web, Client, and Server applications testing.

Automated Test cases in Behavior Driven Development (BDD) and Test-Driven Development (TDD)

Experience using Firebug and Fire Path plugins to find the elements on the web page based on the locators like locator ID, Name, Tag, Class Name, XPath, Link Text, Partial link Text and CSS Locator.

Experience in testing native apps on iPhone, Android and iPod devices manually.

Experienced in using HP Interactive automated testing tools like Quick Test Pro and Quality Center.

Experienced with assigning the requirements to the Test Cases in HP ALM.

Experience in Automation tools like selenium, protractor, QTP (Quick Test Professional), load and performance testing tool JMeter and Mobile Automation testing tool Appium.

Expertise in documenting defects with high level of detail, accuracy, and informative recreation steps using Quality Center, JIRA, IBM Clear Quest, Bugzilla.

Good experience in testing both SOAP and REST services using SOAP UI, Postman, Rest Assured and Tested both XML and JSON formats.

Experienced in Database/Backend testing using SQL Queries for data design, data validation.

Skill Set:

Testing Tools

Selenium, QTP, HP Quality Center, JUnit, Cucumber, Appium, Firebug, Fire Path, TestNG.

Web Technologies

HTML, DHTML, CSS, XML, XPATH, REST, WSDL, UDDI, Web Services, SOAP UI

Defect Tracking Tools

qTest, HP Quality Center, Bugzilla, Visual Studio TFS, JIRA.

Languages

Java, JavaScript, Shell Script, Python, HTML, CSS.

Browsers

Internet Explorer, Mozilla Firefox, Chrome, Safari

Databases

ORACLE, MySQL, SQLite, Post GRE, MS SQL Server

Operating Systems

Mac OS X, Linux/Unix Ubuntu, Windows, iOS, Android

CI/CD

Ant, Maven, Jenkins, Hudson, Git, SVN

MS Tools

ETL Tools:

MS Excel, PowerPoint, Word

Informatica Power Center 8/7.1.2/5.1.1/5.0., Ab initio Cooperating system (2.14/2.15), SAS 9.3

PROFESSIONAL EXPERIENCE:

Client: DIR-Texas Apr 2021 - Present

Role: QA Automation Engineer

Responsibilities:

Wrote selenium automation test scripts to test web applications and the flow of the functionality on the web using Page object model.

Created test scenarios for user stories and creating automation test suites using Python, Selenium Web driver, Pytest framework.

Verified requirements coverage by conducting walkthrough meetings of Test plan and scenarios with business analysts, project manager and test supervisors.

Identified test cases to Automate and Automated test cases using Selenium WebDriver.

Developed test scripts to automate process of testing in Selenium WebDriver by using Java.

Experienced in developing and maintain overall test methodology and strategy, Documenting Test plans, Test cases and editing, executing Tests cases and Test scripts Using Manual, Analyzed User Requirements and Technical Specifications.

Developed exception handling mechanisms using python exception handling.

Worked on distributed test automation execution on different environments as part of Continuous Integration process using Selenium Grid and Jenkins.

Involved in study and analysis of the Business Requirements, System Architectures for creating the project Test Plans.

Created Test Cases and Test scripts for both Manual and Automation Testing using Selenium, Pytest and TestNG Framework.

Coordinated with the development team to fix and close the defects that are created during the sprint

Used HP Quality Center for Test case management, Test Case executions, Defect Tracking and Reporting Test progress to the Project management teams.

Performed Functional Testing, Regression Testing, System Integration Testing, User Acceptance Testing.

Analyzed testing needs, and designed and executed manual scripts, for program to swap set-top box smart cards for models with more robust encryption.

Used Firebug, Fire Path to debug, edit and locate the objects based on ID, Name, XPath, CSS Selector, Link, Partial Link, Attributes and Tags.

Performed manual and selenium IDE script-driven sanity and regression, cross-browser testing to ensure consistency.

Developed Back-end Testing using complex queries to retrieve the user information to cross validate in UI and databases.

Compatibility testing executed the workflow manager web application related test cases on different browsers like Internet Explorer and Mozilla Fire Fox on different Operating Systems.

Involved in iOS and Android Mobile testing includes application testing, test automation using Appium.

Worked on Android based tools like ADB and DDMS for debugging logs and pushing/pulling files and apk's to devices and capturing database.

Followed Agile methodologies and tested the assigned stories within the sprint

Reviewed the test results with the product owner for the acceptance of the stories

Participated in daily Standups, Backlog grooming, Sprint planning and Retrospective meetings.

Environment: Agile, qTest, Selenium WebDriver, TestNG, Java, Jira, Eclipse, XPath, Cucumber, JSON, JavaScript, UNIX shell, Firebug, Windows, XML, JSON, Android, IOS, Jenkins, Maven, SOAPUI, POM, SQL.

Client: Allegion, Caramel, PA Aug 2019 - Jul 2021

Role: Sr QA Automation Engineer

Responsibilities:

Assessed and analyzed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.

Analyzed the business and functional requirements of the application and developed detailed Test Plan, Test cases in Quality Center.

Creation and maintenance of the Requirements Traceability Matrix (RTM) for the Test cases

Involved in the creation of Test data for the Manual and Regression Testing efforts.

Performed back-end Testing on Oracle databases using SQL queries for customer records.

Reported and kept track of defects in Defects module of Quality Center.

Provide defect status summary and testing status to the team lead daily before meetings.

Developed Test Summary Reports and participated in strategy and status meetings.

Created instances in Google Cloud Platform and integrated them with Jenkins.

Executed test cases, analyze problems, and created detailed defect reports, tracking, verifying and closing fixed defects using JIRA.

Responsible for creating test scenarios for user stories and creating automation test suites using Python, Selenium Web driver, Pytest framework.

Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.

Worked on Jenkins and Docker interactively and integrating together for end to end automation of builds and deployment.

Designed Manual Test cases and BDD Feature Files from requirements through Cucumber on a data driven framework using Apache poi library.

Performed regression testing at the end of each Sprint and published cucumber reports through Jenkins.

Developed automated test scripts, functions and subroutines using JavaScript.

Involved in writing SQL queries and MongoDB for backend database testing.

Involved in Test planning and Test execution and performed Functionality Testing and Regression Testing.

Participated in the Agile development environment with sprint meetings and story grooming sessions

Performed functional testing to identify various critical points in the application and automated it by using Selenium WebDriver.

Developed web automation testing framework, iOS and Android with Appium, Selenium and Page Object Model.

Worked on Android based tools like ADB and DDMS for debugging logs and pushing/pulling files and apk's to devices and capturing database.

Developed test code in Java language using Eclipse, IDE and TestNG framework.

Writing and managing automation test-cases for endpoints using Rest Assured.

Performed Regression testing for new builds and every modification in the application using Selenium.

Analyzed test results, tracked the defects and generated reports using Quality Center.

Involved in designing and building automation frameworks in support of continuous integration in a test-driven development (TDD).

Maintained Metrics and participated in the Weekly Status Updates showing the progress of the testing effort and open issues to be resolved.

Environment: Selenium IDE, Selenium WebDriver, Apache POI, Auto IT, Java, HTML, CSS, XML, XPath, Windows, SQL Server, Maven, SOAPUI, Jenkins, GIT, JIRA.

Client: Kabbalah Center-Los Angeles, CA Sep 2017 – Jul 2019

Role: QA Automation Engineer

Responsibilities:

Worked in the agile environment with frequently changing requirements and features set.

Developed and executed test cases, logged the defects in Jira.

Developed and maintained automated regression test cases in Selenium WebDriver using Java.

Reviewed requirement and developed functional testing documents.

Experience in finding web elements using locators like CSS, XPath, HTML id, class name.

Performed functional testing of the application in different browsers such as IE, Firefox, Chrome, Safari and Edge.

Automated regression test suite with Selenium Webdriver.

Converted manual Test Cases into automated scripts with Selenium Webdriver.

Involved in preparation of test cases and test scripts for both manual and automation tests.

Followed Agile Scrum methodology to work closely with development team

Responsible for end-to-end testing selected modules from time entry to billing and receiving payments for the invoice

Responsible for execution of Selenium automation test scripts.

Involved in test data preparation for Time Entry, Billing and Account Receivables.

Involved in testing Rest web services with SoapUI.

Validated the API response by querying the database table

Planning and estimating the test activities for the sprint.

Provided status updates to the management on testing progress and automation progress

Created the defects and worked with developers to reproduce the defects

Performed Continuous Integration using Jenkins and triggered the Continuous Delivery process using Jenkins build jobs.

Verified and tested the Web-Services APIs Requests and Responses.

Created test suites to perform Functional, Data Driven and Load Testing for Web services.

Used SOAP UI tool to test SOA based architecture application to test SOAP services and REST API.

Responsible for end-to-end Regression, Build and Smoke testing for every release.

Involved in data mapping of the project requirements, queried the database using SQL queries.

Used complex SQL Quires to perform back-end data base testing.

Responsible for identifying test cases for automation and developing automation test plans.

Used Git as code repository to manage code reviews.

Used JIRA to track the tasks and issues, attended daily status meetings to update the status of work.

Attended meetings with Product Owners, Developers and QA team to resolve issues regarding the requirement updates and/or changes in the database fields.

Environment: Java, Selenium WebDriver, Jenkins, SOAP UI, Maven, TestNG, XPATH, Eclipse, Agile, GIT, SQL, Jira, Windows.

Client: User1st, NJ Nov 2015 – Aug 2017

Position: ETL tester

Responsibilities:

Worked with Business Analysts to define testing requirements to satisfy the business objectives.

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Experience in SDLC and Agile methodologies such as SCRUM.

Analyzing requirements and creating and executing test cases

Test Case Execution and Ashco testing

Implemented Page Object Model framework with Python and Selenium.

Performed Integration, End-to-End, system testing.

Involving in Functional Testing & Regression Testing

Involving in writing complex SQL queries to verify data from Source to Target

Performed data validation testing writing SQL queries.

Written complex queries in SAS tool check the data from Source and Target.

Used TSYS to update the accounts status.

Extensive testing ETL experience using Informatica 8.1/7.1/6.2 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager).

Used TSYS mainframes, for posting payment transactions for the card member to get enrolled by posting the monthly fix pay amount. Extensively worked on Virtual User Generator.

Used Quality center for test management and report generation.

Generated Test Scripts using LoadRunner and QTP for Stress testing and Regression testing.

Regression Testing is performed and the additional scripts are generated for each version.

Worked on Web Interfaces functionality and Load testing them.

Also analyzed the LoadRunner reports to calculate Response time and Transactions Per Second (TPS).

Tested and wrote queries on Salesforce CRM tools work flow to test the repeatable process to eliminate inefficiencies and enhance productivity.

Used Quality Center for creating and documenting Test Plans and Test Cases and register the expected results.

Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting

Experienced in retest the existing test cases with the different kind of source systems for different periods of data.

Preparing documentation for some of the recurring defects and resolutions and business comments for those defects

Environment: HP Quality Center, DB2, SAS 9.3, Oracle, SQL, SQL*Plus, UNIX, Quick Test Pro

8.0, TSYS Mainframe, Test Director, Windows NT/2000 Quick test pro, Quality Center, Load Runner, VB Script, Java, J2EE, Web Logic Server, JSP, EJB, VB, .Net, XML, MS Office, Unix.

Client: CSI, Hyderabad, India Jul 2013 – Jan 2015

Position:QA/UAT Analyst

Responsibilities:

Prepare detail test cases for different scenarios by analyzing functional documents, wireframes, visual design documents, content metrics and use cases to cover the user acceptance criteria.

Performed User Acceptance Testing along with some functional scenarios to give the final sign off on the behalf of business/stakeholders.

Responsible for writing and execution of positive, negative, and functional test cases to cover overall quality assurance using HP Quality Center (QC) for each release.

Responsible for Black Box, functional testing, User Acceptance Testing (UAT), smoke testing, exploring testing and Regression testing on various releases of ecommerce website.

Planning and execution of backend testing.

Designed simple to complex SQL Server data Studio to retrieve data for database testing.

Tracking test case results, analysis problems, log defects, defect tracking in QC.

Regular Interaction with core developers to assure that all the defects was addressed in time.

Performed initial manual testing of the application as part of smoke testing.

Performed API testing to validate the error message coming from backend.

Executed test scripts and tracking test case results, analysis problems, log defects, defect tracking in QC.

Implemented Page Object Model Automation framework with Java, Selenium WebDriver, and Cucumber.

Executing the test plans on web and mobile (Apple & Android) as per requirements.

Mapped test plan back to functional requirements for ensuring all the requirements are been included in the test cases.

Working with business stakeholders and assists in Quality Assurance by participating in system testing, Integration testing, and regression and Smoke testing.

Coordinate technical activities; provide guidance and direction to team of engineers to ensure project completion.

Written SQL queries for data extraction and validate it from front end application for specific business criteria.

Used Version One tool to organize and manage agile activities.

Participated in all the meetings related to Sprint planning, daily stand-up meetings, retro, poker planning, story review meetings and discussed the issues arising out of test execution.

Involved in SCRUM meetings with the Development and Product Management team and analyzed and developed product stories and included them in Sprint backlog.

Executing Selenium Web Driver test scripts om different browser and checked for compatibility.

Executed test and monitor system performance SiteScope, LoadRunner Controller.

Environment: SQL Server data Studio, QC, Windows, Jira, MS Office, Manual Testing, Version One.

Contact this candidate