Post Job Free

Resume

Sign in

Back End Test Automation

Location:
Des Moines, IA
Posted:
June 27, 2023

Contact this candidate

Resume:

PROFESSIONAL SUMMARY

A result-oriented individual with 7+ years of experience in Software Testing.

Good Experience in Testing with the proven ability to implement and maintain cost-effective methods of system testing and troubleshooting to reduce operating costs. Technically-savvy with the ability to quickly learn new concepts, software, and equipment.

A collaborative team player with excellent communication and interpersonal skills.

Experience in Software Development and various types of testing including Functional Testing, Back-end Testing, Regression Testing, System and Integration Testing, Black Box Testing, Regression Testing and Automation Testing.

Extensive knowledge of SDLC, STLC, Agile & Waterfall methodologies.

Knowledgeable about the techniques, approaches, and intricacies of cloud testing in AWS using a serverless architecture

Experience with building Gherkin Cucumber user scenarios and Ruby scripting for automated testing.

Solid Experience in Behavior Driven Development (BDD), Test Driven Development (TDD) using Cucumber & Gherkin.

Expertise in Requirement Analysis, preparation of Test plans, Test Cases and Test Data for various applications.

Experience in writing and executing automated tests scripts using RubyMine, Selenium, Tricentis Tosca BI.

Tricentis certified in AS1 and AS2.

Worked with all modules of TOSCA like Modules, Test Cases, Requirements, Test case Design & Execution Lists

Experience on using UNIX commands for analyzing error logs.

Good Understanding in OOPS and programming languages like Ruby, Java, C, C++.

Good understanding of Data warehousing, ETL in SSIS to perform Source to Target testing.

Working knowledge of all modules of ALM/Quality Center such as Requirements, Test Plan, Test Lab, Defects, and Dashboard.

Experience in Design, Development and Executing Test Strategy, Test Plan, Test Scenarios, Test Cases based on provided BRDs, SRSs, Use Cases

Hands-on expertise in different tools like Quality Center, HP ALM, Rational Clear Quest.

Experience in performing Back-end Testing on distributed data bases using SQL queries.

Ability to learn quickly and adapt to new challenges and environments.

Proven Experience in working independently as well as in a team.

Experience within a global team working with offshore resources.

TECHNICAL SKILLS

SDLC: Waterfall, Agile, Spiral

Project Management Tool: MS Project

Testing Tools: Selenium, QTP, SoapUI, Cucumber, RubyMine, Tosca BI

Bug Reporting Tools: ALM/Quality Center, Rational Clear Quest, HP ALM, JIRA

Operating Systems: LINUX, UNIX, Windows

Frameworks: Junit, TestNG, TDD, BDD, ATDD,

ETL Tools Informatica 5x, 6x, 7x, 8x, 9x & 10.2, Informatica Data Quality

Databases: Oracle, MS Access, MS SQL Server, AWS Athena, Dbeaver

Operating Systems: UNIX, Windows

Business Applications: MS Office Suites (Word, Excel, PowerPoint, Outlook), MS Visio

Web Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari

WORK EXPERIENCE

State of Iowa - DHS, Des Moines, IA

Nov 2023 – Present

Role: Quality Automation Engineer

Responsibilities:

Involved in all phases of SDLC which includes gathering of functional requirements in Agile speed pod projects, code reviews and Unit testing.

Implemented test automation leveraging test automation frameworks while driving processes to reduce manual test coverage.

Involved in developing automation tests from acceptance test criteria using Tricentis Tosca.

Performed front-end and back-end testing using Tosca.

Interacted with Business Analyst and Developers to understand the application architecture and recommend testing strategy.

Performed System, Integration, Smoke, Sanity, Functional, Regression, Back-end, Positive and Negative and monitored the behavior of the applications during distinct phases of testing using testing methodologies.

Involved in testing the web application

Responsible for Application tests to ensure stability of an application by performing high level sanity and regression test by navigating through few application flows to check application availability before passing it on Business users and also certify application is working fine in production environment.

Worked with the Tricentis Team to resolve the Tosca related issues.

Manages defect communication, remediation, and acceptance with business and development stakeholders.

Provided testing Status Reports on daily basis.

Environment: Tricentis Tosca 14.2/15.2, RQM (Rational Quality Management), Oracle, SQL Developer

Nationwide Insurance, Des Moines, IA

Feb 2019 – Oct 2023

Role: Test Automation Developer

Industry: Insurance

Nationwide Mutual Insurance Company and affiliated companies is a group of large U.S. insurance and financial services companies based in Columbus, OH. It is one of the largest insurances and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Nationwide currently has approximately 34,000 employees and is ranked #68 in the most recent Fortune 500.

Responsibilities:

Involved in all phases of SDLC which includes gathering of functional requirements in Agile speed pod projects, code reviews and Unit testing.

Implemented test automation leveraging test automation frameworks while driving processes to reduce manual test coverage.

Involved in developing automation tests from acceptance test criteria requirements using Ruby Cucumber.

Involved in the use of Cucumber Step Definition, Scenarios and Features.

Wrote Gherkins/scenarios and generated step definitions and methods using ruby/Cucumber, for different functionalities of the above applications.

Performed Automation testing for data warehouse testing using the Ruby Cucumber framework.

Interacted with Business Analyst and Developers to understand the application architecture and recommend testing strategy.

Responsible in Running the ESP (Enterprise Schedule Process) to generate the extract files for testing and loading data into the Database.

Worked on AWS S3(Storage), AWS Athena (Database).

Performed System, Integration, Smoke, Sanity, Functional, Back-end, Positive and Negative and monitored the behavior of the applications during distinct phases of testing using testing methodologies.

Performed data integration testing on extracted data from various sources like oracle, Netezza, Teradata, flat files and SQL Server.

Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.

Used Variables and Parameters in the mappings to pass the values between mappings and sessions.

Creation of Test Automation scripts, Test Scenarios, Test cases.

Used BDD framework with Cucumber and created feature files with scenario and scenario outline files with Gherkins Language.

Proficient in ServiceNow to create RFC (Request for Change) for Database changes.

Involved in testing the data warehouse for both the initial load and the incremental loads of the target Tested various ETL transformation rules based on log files, data movement and with help of SQL

Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system.

Wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration.

Reviewed and updated Test Plan, Test Case, Test Strategy, and Test Scenarios

Used Quality Center/HP ALM to prepare Test cases, procedures, Requirements Traceability Matrix and managing the Defects

Worked with all modules of TOSCA like Modules, Test Cases, Requirements, Test case Design & Execution Lists

Used SQL day to day for back-end testing

Manages defect communication, remediation, and acceptance with business and development stakeholders.

Provided testing Status Reports on daily basis.

Environment: ALM/Quality Center, R, RubyMine, Git, Gherkin, Cucumber, Ruby, BDD, AWS S3, AWS Athena, Dbeaver, Tricentis TOSCA, Unix, Windows.

Nationwide Insurance, Columbus, OH

April 2017- Feb 2019

Role: Test Automation Developer

Industry: Insurance

Nationwide Mutual Insurance Company and affiliated companies is a group of large U.S. insurance and financial services companies based in Columbus, OH. It is one of the largest insurances and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. Nationwide currently has approximately 34,000 employees and is ranked #68 in the most recent Fortune 500.

Responsibilities:

Involved in all phases of SDLC which includes gathering of functional requirements in Agile speed pod projects, code reviews and Unit testing.

Implemented test automation leveraging test automation frameworks while driving processes to reduce manual test coverage.

Involved in developing automation tests from acceptance test criteria requirements using Ruby Cucumber.

Involved in the use of Cucumber Step Definition, Scenarios and Features.

Wrote Gherkins/scenarios and generated step definitions and methods using ruby/ Cucumber, for different functionalities of the above applications.

Performed Automation testing for data warehouse testing using the Ruby Cucumber framework.

Interacted with Business Analyst and Developers to understand the application architecture and recommend testing strategy.

Responsible for identifying Test cases for Automation and Writing scripts, executing test cases and debugging.

Performed System, Integration, Smoke, Sanity, Functional, Back-end, Positive and Negative and monitored the behavior of the applications during distinct phases of testing using testing methodologies.

Performed data integration testing on extracted data from various sources like oracle, Netezza, flat files and SQL Server

Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables

Performed ETL data validation, testing functionality of mapping by preparing test data for all ETL mapping rules by loading data from various sources using Informatica power center.

Creation of Test Automation scripts, Test Scenarios, Test cases.

Used BDD framework with Cucumber and created feature files with scenario and scenario outline files with Gherkins Language.

Developed BDD Automation Framework using Cucumber tool and developed Feature files which includes Features, Scenarios and Step Definitions.

Involved in testing the data warehouse for both the initial load and the incremental loads of the target Tested various ETL transformation rules based on log files, data movement and with help of SQL

Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system.

Implemented Cucumber for regression testing and functional testing with RubyMine as primary tool to the Test Scenarios, Test Cases and Test Conditions identified.

Performed Data Profiling of current state of data in the Data Warehouse by doing Data Analysis using advanced SQL Queries and Microsoft Excel, finding Gaps in Data and formulating solutions for the same

Developed and modified SQL queries and stored procedures with cursors and functions to create & load test data.

Wrote SQL queries and performed Back-End Testing for data validation to check the data integrity during migration.

Reviewed and updated Test Plan, Test Case, Test Strategy, and Test Scenarios

Used Quality Center/HP ALM to prepare Test cases, procedures, Requirements Traceability Matrix and managing the Defects

Executed all test cases and loaded the test results in QC

Used SQL day to day for back-end testing

Manages defect communication, remediation, and acceptance with business and development stakeholders.

Environment: ALM/Quality Center, RubyMine, Git, Gherkin, Cucumber, Ruby, BDD, Dbeaver, Unix, Windows.

Software Quality Experts, Sterling, Virginia

June 2016 – March 2017

Role: QA Analyst

Responsibilities:

Involved in the SDLC of requirement analysis, design and development of the web-based application in the fast paced Agile/Scrum methodology.

Effectively participated in every day Agile/Scrum stand-up meetings and participated in Iteration planning and retrospective meetings.

Worked in Agile, scrum environment in order to change the requirements and features set.

Created Detailed Test Plan, Test Approach, Test Matrix, Test Strategy documents based on the information gathered through business requirements and design/application walkthroughs.

Developed test scripts and test cases using QTP/UFT, Quality Center QC ALM.

Repetitive tests were run using the Automation tool QTP for documenting the regression testing results.

Automated the functionality and interface testing of the application using Quick Test Professional QTP.

Tested web services by generating XML SOAP requests and validated the corresponding XML SOAP responses.

Involved in loading and validating the WSDLS in SOAP UI and preparing the Request XMLs

Analyzed existing test cases to develop automation test scripts using Selenium.

Experienced in performing Data driven testing to validate the components displayed on the website using Selenium.

Done the API testing Using SOAPUI tool creating customers and validate in Back end and front-end systems.

Ran the Automated Regression suite and analyzed results and file bugs.

Helped in preparation of test plans in accordance with the business requirements.

Wrote scripts for testing using Java in Selenium WebDriver by following TestNG framework.

Responsible in executing Selenium WebDriver test scripts on different browsers and checked for compatibility.

Familiar with programming Fundamental Object-oriented Programming (OOP).

Performed REST API Testing using Http java Test Client for REST web APIs.

Performed cross browser functional testing using Selenium WebDriver.

Achieved Behavior-Driven Development (BDD) implementation with Cucumber where backend language used is Java and expanded test scenarios, tracked Cucumber reports.

Performed Automation testing, Black box testing methods -Functional, Integration, System and Acceptance testing.

Wrote complex queries to perform the backend testing of the Oracle database and UNIX shell commands.

Involved in Automation of the test cases using Selenium Web Driver, TestNG.

Worked with developer regarding web service signature and enhanced the framework for all supported web services using Soap UI.

Configured Selenium WebDriver and created Selenium automation scripts in Java using Junit prior to agile release.

Involved in creating Branching strategy and Release management on Code Version system such as GitHub.

Tested APIs (both Restful and SOAP) manually as well as through automation using Restful APIs.

Written positive and negative test cases based on requirements, and specifications, flow charts, process diagrams and executed them.

Worked on developing the automation scripts for backend testing using Selenium.

Created automated scenarios using Selenium for regression and Data Driven testing.

Executed Test Cases with respect to Source and Target database tables.

Written SQL queries in database to validate reports against the database.

Environment: HP ALM/Quality Center, Agile, UAT, SOAP UI, Rest, Cucumber, OOP, Selenium WebDriver, Java, XML, QTP, TestNG, API, GUI, GitHub, SQL, Oracle, Junit, Window, MS Office.

EDUCATION

Holy Mary Institute of Technology - Bachelor’s in Mechanical Engineering

Pittsburg State University – Master of Science Technology



Contact this candidate