Qa Analyst Sql Developer
Resume:
PROFESSIONAL SUMMARY:
* ***** ** ************ ********** in Automation Test Development, Automation Framework Design, API/Web Services Automation Testing.
In depth knowledge of the Business process development using Software Development Life Cycle (SDLC) and testing using Software Testing Life Cycle (STLC).
Strong experience and understanding of Business workflow and QA Method: Waterfall and Agile.
Excellent experience in Page Object Model(POM) to automate Functional and Regression Testing by creating Hybrid Framework using Selenium WebDriver, Java,TestNG, Maven, IntelliJ, Eclipse.
Experienced in developing Automation Framework using Cucumber BDD, JUnit, Gherkin, Java and Selenium WebDriver.
Experienced in generating test reports using ReportNG and ExtentReport.
Experienced in configuring Jenkins as Continues Integration Server using GitHub repository and Maven to execute tests daily.
Experienced in automating database testing using Java and integrating with Selenium WebDriver and API/Web Services tests.
Experienced in automation testing RESTful Web Services using REST Assured and Java.
Experienced in writing complex SQL queries for Back-End/Database testing.
Experienced in creating automation tests for SOAP Web Services using SOAP UI.
Experience with Performance Testing using Gatling, JMeter tools.
Experience with using AppDynamics for Performance Monitoring.
Experience with API testing tools – POSTMAN, Advance Rest Client and SOAP UI.
Strong Knowledge in Core Java, JDBC, JavaScript, JSON, XML, and HTML.
Experience on various operating systems - Linux and Windows platform.
Experienced in scheduling timely jobs on Linux using Cron.
Excellent knowledge and working experience in Test Planning, Test Execution, Test Result Validation, Creating Defects and maintaining the Requirement Traceability Matrix.
Hands on experience in developing Test plan, Test cases, User Acceptance Test (UAT) and executing regression test cycles.
Experienced with test planning, test execution and bug tracking tools – Rally, HP Application Lifecycle Management (ALM) and JIRA.
Hands on experience with all levels of testing including Smoke Testing, Functional Testing, Integration Testing, System Testing, Regression Testing, User Acceptance Testing, Positive/Negative Testing, Exploratory Testing, Data Driven Testing and Performance Testing.
Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking, System Integration, and Task Scheduling.
Experience with 508 Compliance testing using AXE tool.
Experience with security testing using OWASP Zap tool.
Involved in arranging walkthrough meetings to update and review testing process with other team members.
Experienced in Mobile Application testing, Front end and Back end manual testing.
Ability to use a wide variety of open source technologies and tools.
Experienced in writing code in Java for web application.
Strong understanding of Web Application and Web Services architectures.
Experienced in debugging production issues and reviewing log files.
Highly effective in communicating with Developers & End-Users, and translating technical information into everyday language.
Participated in requirement design meetings and sharing ideas for better user experience.
Strong working experience in Financial, Communication, Digital Media, E-Commerce domains
Ability to learn and adapt quickly to the emerging new technologies and paradigms.
Excellent communication, interpersonal and analytical skills and a highly motivated team player with the ability to work independently.
TECHNICAL SKILLS:
Languages
Java, HTML, XML, JSON, JavaScript, SQL
Testing Tools
Selenium Web driver, Junit, Cucumber, JMeter, TestNG, Jenkins, Quality Center, QTP, SOAP UI, Rest Assured, Postman, Advance Rest Client, Azure DevOps, OWASP Zap
Bug Tracking Tools
Version One, JIRA, Rally, Azure DevOps
Integrated development environment
IntelliJ Idea, Eclipse, STS
Build Tools
Maven.
Web Service Technologies
SOAP, REST, HTTP
Continuous Integration Tool
Jenkins, Azure DevOps, Git Lab
Methodologies
Agile (Scrum), Waterfall.
Databases
ORACLE, MySQL
Database Tools
Squirrel SQL, Oracle SQL Server, Toad
Version Control
GitHub, GitLab
Operating Systems
Windows, Linux
PROFESSIONAL EXPERIENCE:
Company: Plateau Group, VA Feb 2019 - Present
Client: EPA (Environment Protection Agency), VA
Overview: The Environmental Protection Agency is an independent executive agency of the United States federal government tasked with environmental protection matters.
Role: Sr. QA Analyst
Responsibilities:
Involved in requirement discussions with team and identifying.
Coordinated with business testers for User Acceptance Testing for all releases.
Created 508 compliance test cases and automated it with Java, Selenium and AXE library.
Performed security scans before each release using OWASP Zap tool.
Created test suites for regression and functional testing and automated critical functionality testing.
Designed automation frameworks using page object model and data driven approach.
Designed end to end automation scripts using Selenium WebDriver with Cucumber (BDD) for critical web applications along with automated database validation.
Created generic methods for capturing screen shots, reading data from excel file, connecting and retrieving data from database.
Created Database repositories and mappers for reading data and objects for holding data using Java and JDBC.
Created Automation Tests with data driven approach using TestNG Data Provider, excel sheet and xml files.
Created test reports using TestNG reports and Extent Report.
Created SQL queries for database validation and automated database testing within Selenium WebDriver scripts using java libraries.
Created customized XPATH for identifying dynamic elements.
Extensively used TestNG Listener to generate automatic response on test failure, Skip or success.
Created automation test strategies and implemented using Selenium WebDriver and Java for existing and new web applications and web services.
Created automated test execution jobs for automated regression tests using Jenkins and GitHub
Implemented automation scripts for Rest web services using Rest Assured.
Experienced in using Apache POI to read data from external sources to feed locators into the test scripts. Refactored and optimized existing automation scripts and integrated with the deployment build jobs for different environments.
Lead quality improvement efforts within team and shared across different teams working under same project.
Performed performance testing for web applications and web services using JMeter
Actively participated in release review meetings for Go/No Go decisions.
Reviewed GitLab pull requests from other testers and provided feedback for any changes before merging code.
Created user stories for the missed requirements using Azure DevOps.
Created UAT test plans for release activities using Azure DevOps reports.
Dealt with the Bug life cycle phases like Defect analysis, bug tracking and Retesting is performed and maintained the status of reports.
Performed System Testing, Integration testing, Smoke Testing, Regression Testing and created automated scripts.
Organized meetings with business users for providing business overviews to the team members for different applications.
Analyzed log files to help developers for debugging production issues.
Organized and provided demos to different teams for the automation strategies implemented.
Environment: Selenium Web Driver, Java, TestNG, JUnit, Cucumber, Rest Assured, OWASP Zap, 508 Compliance, Git, JMeter, AppDynamics,
Rally, IntelliJ Idea, Eclipse, XML/ JSON, Apache Tomcat, WAS server, Agile, Windows.
Company: InfoWeb Systems, Iowa May 2017 – Feb 2019
Client: John Deere Financial, Iowa
Overview: John Deere Financial is a branch of John Deere Company which offers loans and leasing services to its customers.
It offers financial services for John Deere family equipment and its competitive manufacturers.
Role: QA Analyst
Responsibilities:
Extensively used Java OOPs concepts for developing Automation Frameworks using IntelliJ, Maven, Selenium WebDriver and TestNG.
Designed automation frameworks using page object model and data driven approach.
Designed end to end automation scripts using Selenium WebDriver with Cucumber (BDD) for critical web applications along with automated database validation.
Created generic methods for capturing screen shots, reading data from excel file, connecting and retrieving data from database.
Created Database repositories and mappers for reading data and objects for holding data using Java and JDBC.
Created Automation Tests with data driven approach using TestNG Data Provider, excel sheet and xml files.
Created test reports using TestNG reports and Extent Report.
Created SQL queries for database validation and automated database testing within Selenium WebDriver scripts using java libraries.
Created customized XPATH for identifying dynamic elements.
Extensively used TestNG Listener to generate automatic response on test failure, Skip or success.
Developed Features, Scenarios and Step Definitions using Cucumber (Gherkin), Java and WebDriver.
Created automation test strategies and implemented using Selenium WebDriver and Java for existing and new web applications and web services.
Created automated test execution jobs for automated regression tests using Jenkins and GitHub
Implemented automation scripts for Rest and SOAP web services using Rest Assured and SOAP UI for Test Driven Development.
Experienced in using Apache POI to read data from external sources to feed locators into the test script.
Implemented automated OKTA authentication to retrieve authentication token for web services testing.
Refactored and optimized existing automation scripts and integrated with the deployment build jobs for different environments.
Coordinated with business testers for User Acceptance Testing for all releases.
Lead quality improvement efforts within team and shared across different teams working under same project.
Performed performance testing for web applications and web services using JMeter and Gatling tools.
Actively participated in release review meetings for Go/No Go decisions.
Reviewed GitHub pull requests from other testers and provided feedback for any changes before merging code.
Created test plans for WAS to Tomcat migration activities for different activities and executed tests.
Created user stories for the missed requirements using Rally.
Created UAT test plans for release activities using Rally reports.
Dealt with the Bug life cycle phases like Defect analysis, bug tracking and Retesting is performed and maintained the status of reports.
Performed System Testing, Integration testing, Smoke Testing, Regression Testing and created automated scripts.
Organized meetings with business users for providing business overviews to the team members for different applications.
Analyzed log files to help developers for debugging production issues.
Participated in 3 amigos meetings to understand the acceptance criteria and preparing test plans.
Organized and participated in business requirement sessions with business users and product owner.
Organized and provided demos to different teams for the automation strategies implemented.
Environment: Selenium Web Driver, Java, TestNG, JUnit, Cucumber, Rest Assured, SOAP UI, Git, JMeter, AppDynamics,
Rally, IntelliJ Idea, Eclipse, Groovy, XML/ JSON, Apache Tomcat, WAS server, Agile, Windows.
Company: Accenture, India. Jan 2015 – Nov 2016
Client: T-Mobile
Overview: T-Mobile US is one of the largest providers of wireless voice and data communications services in the US. The company's 61 million T-Mobile and MetroPCS contract and prepaid consumer customers use its networks domestically and are able to connect to the compatible network of Deutsche Telekom when in Europe. It also offers low-cost, no-contract mobile services through the GoSmart brand. In addition, T-Mobile sells phones, tablets, PDAs, and accessories from such vendors as Apple, Nokia, and Samsung. It has about 8,000 T-Mobile and MetroPCS branded retail sites.
Role: Quality Assurance Analyst
Responsibilities:
Actively interacted with the business users, product owner and the developers in the Agile team to understand the test scenarios.
Created a Test Strategy, Test Plan and Test Cases.
Automating the test scripts which are planned, prepared and upgraded using HP Quality Center (QC).
Modernized the automation test scripts based on the periodical changes in the functionality requirements of product.
Automated various critical points identified in functional testing using Selenium Webdriver.
Inserted checkpoints to compare the present behavior of the application being tested to its behavior in the earlier version using selenium webdriver.
Performed automated acceptance tests written in TDD (Test Driven Development) using cucumber.
Developed and automated regression test cases with positive scenarios using Selenium Webdriver.
Also responsible for converting automation scripts to new framework using Selenium WebDriver, Java and TestNG.
Implemented Page Object Model Automation framework with Java, Selenium WebDriver and Cucumber.
Recorded JMeter user scripts implementing parameterization both manually and by data driven wizards in JMeter.
Design and document REST/HTTP, SOAP APIs, including JSON data formats and API versioning strategy.
Executed Backend and Database tests using SQL queries, validating the data for database editing and debugging conducted using selenium.
Preparation and execution of test scripts using JMeter and SOAP UI tool to perform Web Services testing.
Involved in the Continuous Integration of the automation framework with Jenkins.
Dynamic and static objects in selenium are dealt with the DOM, Xpath and CSS path.
Developed test scripts for service calls and rendered data through XML files.
Did application performance test using Apache JMeter and developed reports in Jira.
Dealt with the Bug life cycle phases like Defect analysis, bug tracking and Retesting is performed and maintained the status of reports.
Involved in daily and weekly defect and risk meetings.
Environment: Java, HTML, CSS, Selenium Webdriver, Cucumber, JMeter, JIRA, TestNG, XML, Eclipse IDE, SOAP UI, Junit, Jenkins, SVN, HP ALM/Quality Center, SQL Queries, SQL Developer, Agile
Contact this candidate