Qa Automation Test Analyst

Sujeet Tiwari

Contact: 646-***-**** Email: ******.**********@*****.***

Professional Summary

Having 15 Years of Test Engineer/Test Lead experience with various onsite and offsite projects in various domains and technologies

Software experience in various phases of Software testing including System Analysis, Design, Unit, Integration testing and Documentation.

Experience in testing Web Applications, Client-Server applications.

Extensive experience in the entire application Software Development Life Cycle, which includes Requirements, Design, Development, System Testing, Configuration, Installation, Release Authorization, and Maintenance Phases.

Strong Experience in Developing Test Plans, build Test Conditions and Test Cases, developing and maintaining Test Scripts, creating test data, analyzing bugs, interacting with development team members to fix errors, Bug Tracking and Reporting Systems.

Automating Angular JS applications by using Protractor, Jasmine and Karma using Java script.

Experience in performing Positive, Negative, Boundary, Functional, Integration, System and Regression tests and Salesforce testing.

Strong Skill set of STLC tools like HP ALM/Quality center (QC), SOAP UI, Selenium IDE, Selenium Web driver, QTP and UFT 12.5, Appium, Cypress, Jmeter,Node.js

Experience in developing the features, scenarios, step definitions for BDD (Behavior Driven Development) and TDD (Test Driven Development) using Cucumber, Gherkin.

Expertise in Source to Target Data testing, Data completeness testing, ETL Job set up and validations.

Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/Database Testing.

Experienced in using automation testing tools, involving understanding the process of any particular application, preparing a framework, preparing test plans, preparing test cases and automating test cases.

Extensive experience in API testing using REST Assured, SOAP and POSTMAN

Good exposure to Data Driven, Hybrid, Keyword Driven frameworks using Selenium.

Expertise in analyzing business specifications and use cases.

Experienced in using various Defect Tracking Tools and Defect reporting and Tracking by QC, ALM, Rally, RTC, Test Director and JIRA

Experience in Testing Database Applications of RDBMS in DB2, MS SQL Server.

Experienced in using SDLC models like waterfall, agile software development methodology.

Experience in Mobile testing of applications, with emphasis on Android and iOS platforms

Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, and

Weekly Status Reports.

Domain expertise in Insurance and Finance.

Involved in DevOps migration/automation processes for build and deploy systems.

Experience in test environment and test data management.

Developing and Managing Java/Web Applications, practicing Agile/DevOps methodology by using local/Cloud Infrastructure and ability to use wide variety of open source Technology and tools.

Experience working in Agile/Scrum environment.

Experience in TestNG, Jenkins, Cucumber and BDD.

Experience working in a DevOps Environment

Sound Knowledge on creating SQL queries using various joins.

Technical Skills

Languages

C/C++, SQL, PL/SQL, TSL, UNIX Shell Script

Automation Tools

Mercury Suite WinRunner, TestDirector for Quality Center, Quick Test Professional, LoadRunner, IBM Rational Clear Quest, UFT 12.5. Selenium Webdriver, SOAP UI, BDD with Cucumber, Rest Assured using Core java, Appium, Cypress.io,Jmeter

Testing Techniques

Black-Box Testing (Functional, Regression, Usability), White Box Testing, Performance Testing, Automation Testing

Web Technology

Core java, HTML, JSP, XML, VB Script and javascript, Node.js

Databases

DB2, Oracle 7.x/8i/ 9i,10g, MS-SQL Server7.0/2000, MS Access

Operating Systems

Windows 95/98/00/NT/XP,7 UNIX

Other Tools/Packages

TextPad, MS Office, MS Word, Excel, Power Point, SOAP UI

Browsers

Internet Explorer, Netscape Navigator, Firefox, Google Chrome

Education and Certifications

Bachelors of Engineering (Electronics and Telecommunication), Delhi College of Engineering, IN

AWARDS AND RECOGNITIONS

Got Excellence Bronze award for best team in Industrialized Agile team certification in 2016.

Got Excellence Silver award for best team in Industrialized Agile team certification in 2015.

Got Best Individual Contributor award in PTG GTS in 2014

Got Feather in my Cap award in CSST project in Sep 2013

Professional Experience

Client- Tracfone May 2019- Till date

QA Automation Engineer, Miami, FL

Project- Pega- ENZO

Retail TracFone Wireless, Inc. (TFWI) is an American prepaid, no-contract mobile phone provider. TFWI is a subsidiary of Mexico's largest telecommunications company, América Móvil,[3] and offers products and services under several brands. It operates as a mobile virtual network operator (MVNO), holding agreements with the United States' largest wireless network operators to provide service, including Verizon Wireless, AT&T Mobility, T-Mobile US, Sprint Corporation, and U.S. Cellular

.

Responsibilities

Analyzed the Business Requirement Document (BRD) and Functional Specification documents (FSD) to prepare Test Cases based on the Test Plan and Use Cases and attended Reviews meetings to better understand the applications.

Involved in DevOps processes for build and deploy systems.

Lead the planning and execution of SIT and UAT with technology and business partners

Developing QA automation framework using Node.JS, Selenium and Gherkin.

Involved in preparation of Test Data to test the functionality of ETL Sources Mappings and Targets.

Created test plans that include functional and non-functional requirements

Created and managed UFT Test Scripts based on the Requirements and Scenarios.

Conducted Data Driven Testing using parameterization in UFT to test the application with different sets of data.

Developed automated test scripts using descriptive programming in UFT.

Created user defined and custom functions using VB scripting.

Created a Hybrid Framework of automation for the application using VBScript coding in UFT.

Worked in Test Data management and test data creation

Hands on knowledge of SQL writing and troubleshooting data issues

Created and executed JMeter scripts for performance testing of portal

Develop scenario based testing for the JMeter scripts and node.js

Prepared and reviewed UAT test artifacts (Test Plans, Test Scripts, Traceability matrices, etc.) with Project Stakeholders.

Logged in to UNIX host to run the batch jobs.

Logged and managed defects using JIRA.

API Testing using POSTMAN and RestAssured

Conducted Automation/Manual testing using the Standards, guidelines and structured methodology in testing the application using Core java.

TestNG API (org.testng.*, org.testng.annotations.*) to write test cases & automate all test cases.

Apply, design and develop automated testing strategies and build automated testing frameworks using different automation tools Viz. Selenium, Soap-UI and Rest – assured.

Analyze and verify best automated and manual test approaches and execute UI functional, acceptance, integration and system testing.

Involved in performing Functional testing, Regression testing, System testing, Integration testing, Security testing, Smoke Tests, Configuration testing, GUI and User Acceptance testing

Used SOAP UI for functional testing of web services. Creating SOAP project using WSDL.

Involved in Application Design Document and Interface documents to develop test cases and test scenarios.

Responsible for implementation of Hybrid Test Automation Framework, Page Object Model using Selenium WebDriver, TestNG and Core java.

Configured Shared object repository and per action in Selenium WebDriver.

Have automated the web application using Core java and TestNG in Selenium WebDriver and Cypress.io

Run the tests with Selenium Remote Control with multiple browsers & platforms.

Prepared the test strategies and plans for all the QA releases.

Mobile testing using Appium for native mobile app functional project.

Worked in User Acceptance Testing in quarterly releases.

Reported the peers on the status of testing in daily scrum.

Used web-debugging tools like XPath, Firebug and Fire path to locate elements.

Extensively used Selenium 3.7 (data-driven, XPath locator) and WebDriver to test the web application.

Estimated the test stories and tasks in Agile Environment.

Intensively analyzed the test results and bugs are tracked and reported with the detailed

status of the bug with HP ALM/Quality center (QC) and Rally

Logged and managed defects using HP ALM defect management tool.

Involved in preparation of SIT Execution summary report to all the teams after execution.

Involved in creation of automation frame work in Selenium Web driver using POM

Involved in Design, Develop, Execute and Maintain Automated Test Scripts using BDD and TDD Testing framework using Core java, TestNG.

Created pom.xml in Apache Maven and executed the build jobs using continuous integration tool Jenkins.

Project Title : Digital Offer Ecosystem

Client : American Express, Phoenix AZ

Role : Test Lead

Period : Oct 2016 to March 2019

Description: Digital Offer Ecosystem, also known as Amex Offers, was launched last year to enable Merchants to deliver coupon less offers to the most relevant Card Members based on their spending history and location. Today, Card Members can enroll in merchant offers through the American Express website, the American Express app for iPhone, American Express emails, Facebook, Foursquare, Twitter – with more to come.

Responsibilities

Analyzed Business Requirements and functional specification document and developed test cases.

Involved in DevOps migration/automation processes for build and deploy systems

Created user defined and custom functions using VB scripting.

Wrote scripts using Cucumber and BDD.

Tested Salesforce Mobile App, Salesforce custom objects, custom fields, page layouts, custom Tabs, Reports and various other components as per application requirements.

Created a Hybrid Framework of automation for the application using VBScript coding in UFT.

Experience in ETL and Data frameworks, processes, strategies, and approaches

Involved in Test data creation and test data processes and strategies

Involved in UI & Salesforce Testing

Run database queries in workbench for Test data into salesforce.

Apply, design and develop automated testing strategies and build automated testing frameworks using different automation tools Viz. Selenium 3.7, Soap-UI and Rest – assured.

Tested the company's Salesforce CRM application.

Analyze and verify best automated and manual test approaches and execute UI functional, acceptance, integration and system testing.

Tested wealth management application with regard to security, browser compatibility.

Experience in Wealth Management and Invest management.

Used TOAD for Oracle in creating & executing SQL queries for testing ETL process.

Participated in walkthroughs of requirements, specifications, database designs, ETL code, and test strategies

Created pom.xml in Apache Maven

Automated AngularJS application module using protractor by writing java scripts and Used Jasmine as unit testing framework.

Involved in preparation of Test Data to test the functionality of ETLSources Mappings and Targets.

Identified mobile elements using Appium Inspector, UI Automator Viewer.

Used Appium to facilitate mobile testing by creating mobile Driver class with the required Mobile capabilities.

Develop test cases to assure that the data that has been loaded from a source to destination after business transformation is accurate in ETL testing

Good experience in mobile testing using Appium in both IOS and Android applications using simulator and emulator.

Involved in performing Functional testing, Regression testing, System testing, Integration testing, Security testing, Smoke Tests, Configuration testing, GUI and User Acceptance testing

Used SOAP UI for functional testing of web services. Creating SOAP project using WSDL.

Involved in Application Design Document and Interface documents to develop test cases and test scenarios.

Done Core java coding extensively for Data Driven framework and Keyword Driven Framework by using TestNG framework along with Selenium IDE, Selenium 3.7.

Actively involved in sprint meetings, managing product backlog, removing obstacles to progress, reallocating resources when necessary, prioritizing, reviewing milestones and accomplishments.

Executed the build jobs using continuous integration tool Jenkins.

Developing automation Test Scripts using Core java, JavaScript, Unit Framework TestNG, Selenium WebDriver and used MAVEN Build tool to run the automation.

Interacted with the Business Clients, Product Owners, Developers and QA Manager for clear exposure to trickle down the technical/functional User Requirements & Change Requests to Test Plans and Test Scenarios. Involved in testing both REST and SOAP web services and tested both JSON and XML formats.

Automated Cross Browser testing through Selenium WebDriver by testing the website on different browsers like Chrome, IE and Firefox.

Logging defects using defect tracking tool Rally.

Actively involved in Functionality, Integration and Ad-Hoc tests.

As a Selenium Engineer, involved in perform testing, verification & validation, and quality assurance of the Sprint.

Environment: Net, Core java, DB2, Java 1.6, JSP 1.2, Java Servlets 2.3, SOAP, SQL, WSDL, XML, Putty, WinScp, QTP, Core java, Selenium WebDriver, Eclipse, TestNG,

Project Title : eCFM

Client : State Street Bank, Boston MA

Role : Test Lead

Period : Apr 2015 to Sep 2016

Description: eCFM (eHorizon Cash Flow Module) is a secure module where clients can post upcoming payments. Once approved, these payments are processed by State Street and delivered to the appropriate vendor by way of check or wire (as specified by the client). The Cash Flow Module provides the clients with number of security features through future entitlements, dual approval option, standard industry encryption protocols and user authentic requirements.

.

Responsibilities

Giving Demo to Product Owner and team at the end of each iteration.

Prepared the test strategies and plans for all the QA releases.

Fixing defects in automation scripts using VBScript.

Backend testing using SQL Server 2008 R2 & 2016.

Executed the build jobs using continuous integration tool Jenkins.

Wrote detailed testing scenarios for User Acceptance Testing (UAT) in each iteration.

Developed automated scripts for Regression Testing through Selenium Web Driver.

Execution of automation scripts using UFT 12.5 and Selenium Web drivers.

Create and manage test data for use by automation test scripts.

Reported the peers on the status of testing in daily scrum.

Preparing the functional test cases for every sprint (AGILE) & executed them manually.

Logged in to UNIX host to run the batch jobs.

Wrote scripts using Cucumber and BDD.

Created pom.xml in Apache Maven

Executed automated scripts in TAF framework.

Participate in the weekly project meetings to evaluate the progress of the project.

Environment: Net, Core java, DB2, Core java 1.6, JSP 1.2, Java Servlets 2.3, SOAP, SQL, WSDL, XML, Putty, WinScp, QTP, .Net

Project Title : CSST

Client : Credit Suisse, NY

Role : Test Lead

Period : Feb 2012 to Mar 2015

Description: The Credit Scenarios and Stress testing has been established to address the weakness identified by FSA and adhere to Basel-III regulations through improvements to scenario and stress testing controls, processes and infrastructure. It involves migration of tactical databases and applications onto robust/scalable infrastructure, leveraging front office for scenario calculations where appropriate.

Responsibilities

Participate in Functional Specification Document weekly review meetings with Business Analysts, Development teams.

Web services testing using SOAP UI

Involved in Change Control meetings for changes in the Functional Specification Document

Review the Functional Specification Document whenever updated for changes

Prepared Standard Test Matrix based on the Functional Specification Document

Interact with the Business Analysts, Development teams for any queries/issues in Functional Specification Document

Setting up data for the Use case based on the Functional Specification Document for positive and negative flows

Logging defects in IBM Rational Clear Quest for any deviations in Standard Test Matrix from Functional Specification Document

Completing test cases execution based on the release dates

Testing for the positive and negative flows based on the flow chart in Functional Specification Document

Environment: Net, Core java, Oracle 11G, Core java 1.6, JSP 1.2, Java Servlets 2.3, SOAP, SQL, WSDL, XML

Project Title : BEFG

Client : US Bank, Minneapolis

Role : Test Lead

Period : Oct 2009 to Dec 2011

Description: The application EFE is a comprehensive credit application processing solution that provides fast, consistent credit decisions, based on certain rules. It enables information capture and transfer, automates credit-risk assessment, and basic workflow.

Responsibilities

Produce a consolidated Testing Sign-off for the entire project.

Manage testing activities for all applications/interfaces impacted by the project for ST1, ST2 and BLA.

Provide direction and leadership to the test team.

Mentor test team on methods and tools and ensure proper usage.

Define & coordinate the test requirements, data, and software for each test environment.

Provide estimates for all testing efforts.

Coordinate all requests for information changes and notices of problems as defined by the project s change control and problem reporting procedures.

Environment: Unix, Shell scripts, Html, Core java, JSP, javaScript, MySQL, SQL scripts, Putty, XML, QTP, PL/SQL

Project Title : Hibernian

Client : Aviva, Ireland

Role : Test Analyst

Period : Nov 2008 to Aug 2009

Description: Hibernian intends to replace its existing system with a new J2EE based system viz. HiPLUS, to service the direct channel business through its Contact Centre and Branch Network. HiPLUS will not actively service the functioning of existing web channel (HDWeb).

Responsibilities

Interacted with developers and users to analyze the business requirements and functional specifications.

Close interaction with designers and software developers to understand application functionality and navigational flow.

Designed test strategy and test plan by understanding the business logic and user requirements for manual testing.

Environment: Core java, JSP, J2EE 1.3, JDBC, ESP 5.3, Unix, Shell scripts, PHP, Html, Core java, Java Script, Mysql, SQL scripts, PL/SQL, QTP

Project Title : QA Authoring

Client : Morgan Stanley

Role : Test Analyst

Period : Apr 2007 to Oct 2008

Description: APG is Process in which a Research note is prepared that allows Analyst team to disseminate their opinion on equity Research covered companies to large investment community. Company Research contained the specific detailed and material information on a subject company.

Responsibilities

Interacted with developers and users to analyze the business requirements and functional specifications for the developed Core java application.

Analyzed user requirements and Created Functional Test Plans, Integrated Test Plans, Test Procedures and Test Cases

Close interaction with designers and software developers to understand application functionality and navigational flow.

Participated in QA Team meetings for daily and weekly QA testing reviews.

Environment:

Core java, JSP, J2EE 1.3, JDBC, Edit Plus Text Editor 2.3, Toad 9.0, Microsoft Access 2003, Core java Script, JUnit, Oracle 9i, QTP, MQ Visual Edit v1.3.0.

Contact this candidate