Priyanka Marchala

Minneapolis, MN

Summary:

·Over 6 years of experience in development, automation, and manual testing

·Expertise in developing automation scripts using programming languages like Java and Python

·Strong experience in using automation frameworks like Selenium, TestNG and Cucumber

·Experience in working with RDBMS like MySQL, Oracle and developing and executing SQL queries

·Basic understanding of front-end technologies like HTML5, CSS3 and Angular JS

·Proficient in using SoapUI/Postman for testing Web Services/API and used various types of assertions such as soap fault, Contains, Xpath etc.

·Expertise in functional testing UAT using Selenium IDE and Selenium Webdriver using JUNIT unit testing framework.

·Experienced in designing and building Frameworks like Behavior Driven Development (BDD), Test Driven (Extensively automated Regression and Functional test suites by developing test cases and test suites using Selenium Webdriver).

·Proficient in using basic SQL queries to perform backend testing for data integrity and validating stored procedure.

·Proficient in mobile automation testing using Appium with comprehensive understanding of all phases of Test Life Cycle, including requirements gathering, test planning, defect tracking, and reporting.

·Experience testing Mobile Apps on IOS and Android Platforms with Appium. Inspected the App using Appium Inspector on Different platforms.

·Good knowledge in using and configuring tools like Maven, GIT, JIRA, Jenkins for CI/CD

·Experience in Software Development Life Cycle (SDLC) using Agile Methodology

·Extensively automated Regression and Functional test suites by developing test cases and test suites using Selenium Webdriver.

Skills:

Languages

Java, Python, VB Script

Web Designs

HTML5, CSS3, XML

Operating Systems

Windows XP/Vista/7/10, Linux, and Max OS.

Frameworks

Selenium, Cucumber, JDBC, TestNG

Databases

MySQL, Oracle

Environments & Tools

Eclipse, Jenkins, JIRA, HP ALM, Git, Maven, Postman, Soap UI

Professional Experience:

Verizon, Tampa, FL Sep 2019 -Present

Role: Automation Engineer

Verizon is a Telecommunication firm located at Tampa; Florida offers services such as Internet. The project, DTIX involved working on the DTIX Java based application which provides platform to test circuits and devices. Application parses the response and gives the interpretations based on which it recommends the technician without visiting the customer location.

Responsibilities:

·Developing automated tests using Selenium Webdriver (Java, Maven) with developers for Continuous regression testing (Jenkins) and reducing the efforts of manual testing.

·Executed SQL queries to fetch records from the DB and validate results obtained from the logs

·Used Eclipse as IDE and SQL Developer as DBMS tool.

·Performed mobile application automation for iOS and Android using tool Appium.

·Tested applications in all environments (QA, staging (UAT), Pre-Production, and Production)

·Used TestNG Annotations in Selenium Webdriver and executed a batch of tests as TestNG suite

·Performed Assertions like Schema Compliance, Xpath, and SOAP responses.

·Used Selenium and Behavior Driven Development (BDD) approach using tools like Cucumber to setup test automation framework.

·Developed Selenium scripts in TestNG for parameterization using Data Provider annotation

·Performed manual API testing using Postman and tracked defects using JIRA in Agile methodology

Environment: Java, Selenium, Jira, Jenkins, SQL, Postman, SQL Developer, Agile, Cucumber, TestNG

Publix, Lakeland, FL Jan 2019 - Aug 2019

Role: SQA Engineer

Publix is an employee-owner, American supermarket located at Lakeland, Florida. It provides online and in store groceries services. The project involved working on the Online payments Application. This application helps the customers to pay their bills online and it also provides all kinds of services online.

Responsibilities:

·Activity participated in analyzing Online Payments application and worked on hands of the application as per the test case.

·Involved in developing test plan, test strategies, test scenarios, test scripts and test steps based on Business and System Use Cases.

·Executed Selenium tests for automation testing of the web application using Selenium Web Driver.

·Followed Test Driven Development (TDD) as much as possible and written test cases using TestNG for every relevant class

·Worked with Chrome extension Postman REST Client, an HTTP client for testing web

·Services

·Actively participated in testing the web screens (GUI)

·Involved in executing the test scripts developed, during Regression Execution and raised the

·Defects in HP ALM.

·Worked on Databases to verify the Backend Validations using SQL Developer.

Environment: Selenium, TestNG, Postman, SQL Developer, HP ALM, Agile, SQL.

Ameriprise Financial, Minneapolis, MN June 2018 – Jan 2019

Role: Automation Engineer

Ameriprise Financial is a diversified financial services and bank holding company which helps the clients with financial advices. It provides services like financial planning products and services, including wealth management, asset management, insurance, annuities, and estate planning.

Responsibilities:

·Created Test plans, managed team members, assigned tasks and conducted meetings.

·Follow Agile Methodology for all the phases of SDLC and interacted with Lead, Business Analyst, Developers, and other QA Members during Daily Stand-Up Meeting.

·Actively involved in all stages of STLC (Software Testing Life Cycle).

·Created and maintained test plan, test cases and automation test documents.

·Work on software Verification and Validation manually and use Assertions for automation.

·Extensively automated Regression and Functional test suites by developing test cases and test suites using Selenium Webdriver in Java.

·Designed and executed the Automation Test Scripts using Selenium Webdriver and TestNG.

·Used Maven, Selenium Grid to execute Selenium automation suites on different platform, browser combinations in parallel

·Automated regression test suite using in house automation framework based on Java Selenium.

·Performed functionality and regression testing during the various phases of the application using Selenium.

·Created TestNG XML based test suite and integrated with Jenkins Server to execute automation scripts on a regular basis by scheduling Jenkins jobs in different test environments with different test configurations.

·Proficient in using Postman for API testing using POST, GET, PUT, and DELETE.

·Monitored test results, tracked defects, prepared defect profile documents, and reported them using Jira.

·Worked as QA for performing API launches, white box testing, data testing. Tested and analyzed SQL queries and XML code to validate data and database mappings.

·Involved in executing SQL queries to conduct Data integrity testing by checking the data tables from the Oracle Database.

·Effectively communicated testing status to QA lead, project managers, and teams who are involved in User Acceptance Testing.

·Performed User Acceptance Testing (UAT) on each release of the project with the help of end-user requirements.

Environment: Selenium, Toad, Jenkins, Quality Center, Agile, Appium, Cucumber, SQL, Postman, VB Script.

BCBS, Eagan, MN Sep 2017 – May 2018

Role: Automation Engineer

BCBS is a health insurance company located at Eagan, Minnesota. It offers many kinds of health insurance services. The project was to work for the Member Portal Team and assist them in testing for enrollment and billing. Member Portal is one of the applications that helps the customer to enroll in the portal.

Responsibilities:

·Prepared Test Scenarios, Test Cases, Test Data, Test Procedures, and Test Reports.

·Attending status calls in updating the daily status and discussing on the scope of the functionalities and upcoming plans of automating test scripts.

·Generated Automation Test Scripts ran them and analyzed results using QTP.

·Used VB Scripting extensively to automate functional test cases using QTP/UFT performed data driven testing by data driver wizard and parameterization in QTP for web-based application.

·Prepared automation scripts for Regression testing using UFT.

·Performed Data Driven testing using QTP and VB script.

·Inserted checkpoints to check for broken links, Text and Standard properties of an object using QTP

·Responsible to verify Web services API request, response data validations in REST Protocols.

·Worked on Databases to verify the Backend Validations using TOAD.

·Participated in continuous integration using Jenkins.

Environment: Selenium, Toad, Jenkins, Quality Center, Agile, Appium, Cucumber, SQL, Postman, VB Script.

Verizon, Richardson, TX Jan 2016 – June 2017

Role: Automation Engineer/ Core Java Developer

Verizon is a Telecommunication firm located at Richardson; Texas offers services such as Internet. IVAPP is one of the Java based applications which provides platform to test circuits and devices. Application parses the response and gives the interpretations based on which it recommends the technician without visiting the customer location.

Responsibilities:

·Designed and developed test cases and automated using Java and Python.

·Prepared specific Java programs based on the requirement and desired applications.

·Added recent programs to the existing code to improve the functionality of the application.

·Developed the back-end logic layer by using most of the Core Java features such as Collections Framework, Interfaces, Multi-threading and Exception Handling programming.

·Used AWT’s and Swing for the front-end logic.

·Used Robot Framework to automate the test cases and develop simple code.

·Used Python along with Robot Framework to write simple and faster running test cases.

·Configured and monitored Jenkins to perform continuous deployments of scripts for conducting regression tests.

·Used GIT for version control and Bit Bucket as code repository.

·Executed SQL queries to fetch records from the DB and validate results obtained from the logs.

·Used Eclipse as IDE and SQL Developer as DBMS tool.

·Involved in communicating with other team to perform end-to-end testing.

Environment: Robot Framework, Java, Jira, Python, GIT, Confluence, Bit bucket, SQL Developer, Core Java, AWT, Swing.

Paraxel International Pvt Ltd, Hyderabad, India May 2013– Nov 2014

Role: Java Developer Intern

·Implemented business logic using Java 7 and managed dependencies using Maven

·Developed DAO classes using JDBC

·Consumed REST web services using Jersey and JAX – RS for application integration

·Developed SQL queries to perform CRUD operations on Oracle database

·Used GIT for version control

Environment: Java, Maven, JDBC, Jersey, RESTful Web Services, Oracle, GIT

Education:

·Master’s in Information Assurance from Wilmington University, Delaware.

·Bachelor’s in Information Technology from Bharath Institute of Engineering and Technology.

Contact this candidate