Data Entry Qa Tester

SWAPNA SUSARLA

Phone: 302-***-****

Email: ******@**********.***

Professional Summary:

Over 9 years of professional experience in testing with extensive knowledge of Automation Framework Design & Implementation using Java, Selenium Tool and Experience in Manual & Automated Testing of GUI and functional aspects of Client - server and Web based Applications on multiple levels of SDLC and Software Testing Life Cycle (STLC).

•Expertise in Selenium automation using Selenium WebDriver, Selenium Grid, JAVA, JUnit & Maven

•Designed and implemented different automation frameworks like Page Objects framework, Keyword Driven framework, Data Driven Framework, Page Object Model (POM) and Hybrid framework.

•Expertise in writing Selenium WebDriver automation scripts in JAVA for highly transactional Ecommerce websites Experience in functional testing AUT using Selenium IDE and Selenium WebDriver using TestNG/Junit unit testing framework.

•Extensive experience in designing Test Cases, Test Scenarios, Test Scripts and Test reports of manual and automated tests.

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

•Work experience with QA/Data Governance team to define test cases and data scenarios and Strong Knowledge and experience of all phases of SDLC and QALC (Quality Assurance Life Cycle).

•Experience in Healthcare domain primarily on PBM [Pharmacy Benefit Manager] functionality, Retail Banking and Supply Chain Management.

•Experience in Data Base/Backend testing using SQL queries for data design, data validation, and data integrity testing using JDBC.

•Experience in Cross Browser Testing and Parallel Test Execution using Selenium WebDriver, TestNG and Selenium Grid.

•Experience in using unit testing frameworks like Junit, TestNG, good knowledge in configuring the test suites in TestNG.xml file. Experience in using build tools like Maven and configuring pom.xml

•Expertise in developing Test Framework from scratch using Page Object Model (POM) and maintaining the object repositories, experience in using java libraries like Apache poi and jxl.

•Experience in working with web debugging tools like XPath, Fire Path, and Firebug and provided efficient locators for strategies like XPath and CSS to run test scripts.

•Good knowledge in DEVOPS concepts and working knowledge on Continuous integration and Continuous delivery (CICD)by using tools like Jenkins

•Maintained the Selenium & JAVA automation code and resources in source controls like Git over the time for improvements and new features

•Excellent experience of build tools like Maven and managing JAVA automation projects using them.

•Ability to play a key role in analyzing problems and come up with creative & innovative team solutions to complex problems

•A quick learner who can absorb new ideas and can communicate clearly and effectively.

•Experience in Business Analysis responsible for working with internal and external clients to define requirements for new systems or requirements for changes to existing systems.

Technical Skills/Knowledge:

Project Methodologies

Agile/Scrum, Waterfall, RUP

Automation Testing Tools

Eclipse, Selenium (WebDriver, RC, IDE, Grid), TestNG, JUnit, Cucumber,

SoapUI, Appium, Rest Assured, Protractor, Rally, HP Quality Center, Win Runner and Load Runner

Frameworks

Cucumber, Keyword Driven, Data Driven, Hybrid, Page Object Model.

Application Environments

Eclipse, Java, Maven, Jenkins, Apache Tomcat, GitHub, SVN.

Test Integration Tools

Maven, Jenkins.

Bug Tracking Tools

JIRA, HP ALM & Quality Center, Rally.

Markup Languages

HTML, CSS, XML, XPath, CSS Selector.

RDBMS

MS SQL Server, MySQL, Oracle.

Operating Systems

Windows XP/7/2008/10, Mac OS, Android, IOS, Java, Gherkin

Programming Languages

C, UNIX shell scripting, Java, Java Scripts, SQL.

MS Office Tools

MS-Excel Macros, Outlook, PowerPoint, and Word.

Education Qualifications:

Master of Sciences [Applied Mathematics]

Bachelor of Sciences [Mathematics, Physics and Computers]

Immigration Status: US Citizen

Work Experience:

Client: PNC (Pittsburg National Corporation) Retail Banking Jan 2020 – Present

Project: Technology Migration- Mortgage Application Processing

Role: QA Automation Engineer

This is a technology migration project where PNC Bank upgraded their Mortgage application processing platform from client server architecture to microservices architecture.

Responsibilities:

•Analyzed Business Requirements Documents to get better understanding of the system both on technical and business perspectives.

•Developed new and updated existing Automation test cases using Selenium WebDriver and TestNG, using Maven as build tool and Jenkins to create and run deployment jobs.

•Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.

•Extensively used Page Objects design framework for readable test script and easy maintenance from developer perspectives.

•Performed build acceptance testing and smoke testing using Cucumber automation tool.

•Wrote test cases and performed Manual Testing like Positive Testing and Negative Testing, Regression, Integration, Unit Testing.

•Involved in Design, Architecture, and Development of BDD framework by writing Features files, Step definitions and actively worked with the Product owner using Cucumber.

•Performed SIT Testing activities (as a part of manual testing) to evaluate and support Microservices by providing end-to-end application testing and by providing technical support.

•Used XPath and DOM to work with dynamic and static object locators in Selenium.

•Implemented the architecture of BDD framework from scratch by using the existing Hybrid components.

•Expertise in grouping of test suites, test cases and test methods for regression and functional testing using TestNG Annotations like Groups, Parameter, Data Provider and Tags.

•Used Selenium automation (TestNG) to different type of browsers to perform Cross Browser Testing.

•Maintained Automation scripts and responsible for code check-ins into Git.

•Utilized Apache POI jar file to read test data from the excel spreadsheets and load them into required test cases.

•Prepared SQL scripts to verify the database updates, inserts and deletes scripts for Database Testing.

•Used MAVEN to build and run the Selenium automation framework, once the script got over, framework used to send the automation reports over email.

•Troubleshoot the build issue during the Jenkins build process, after reviewing the codes push them to the CD/CI pipeline in GITLAB.

•Analyzed test results, tracked the defects, and generated reports using Jira

Environment: Java, Selenium WebDriver, Microservices, Apache POI, Rest Assured, TestNG, XML, XPATH, DOM, Cucumber, Appium, Jira, Git, Agile, SOAP, RESTful, Microservices, SQL, Jenkins, SoapUI, Eclipse, Maven, Oracle.

Client: North America Med Tech Group March 2018 – Dec 2019

Project: Manage My Patient (MMP)

Role: Working as a QA Automation Tester.

MMP: Manage My Patient is a web-based healthcare application developed for Doctor’s office to manage their portal. It consists of four different modules namely Patient, Admin, Doctor, and Insurance. In Patient Module, a patient can Register, Schedule Appointment and Payment of Fees. In Admin Module, approve the registered patient, capture vitals. As part of the Automation team for Patient and Admin module I am responsible for automating the tests for Patient and Admin module.

Responsibilities:

•Responsible for fixing and maintaining regression automation test scripts for end-to-end testing using Selenium WebDriver (using Java).

•Used Jira for bug tracking and reporting, also followed up with development team to verify bug fixes and update bug status.

•Followed agile process and tracked user stories, tasks, test cases, Results and Defects in Rally.

•Designed Hybrid Framework using Maven, Page Object Model & TestNG.

•Automated test cases using Selenium WebDriver and TestNG.

•Implemented automation using Selenium WebDriver, Java, Selenium Grid and Maven.

•Located web elements using XPath and CSS selectors.

•Created and executed test scripts for regression and sanity testing and Generated logs and reports using TestNG Reports.

•Integrated complete automation framework with GitHub and executed the same via Continuous Integration tool - Jenkins.

Environment: JAVA, Eclipse, Maven, Jenkins, Apache Tomcat, Java Script, HTML, SQL, Selenium, JIRA, VBScript, XML, Firebug, CSS, Rest Services.

Wells Fargo Bank October 2015- Feb 2018

Project: Default Workflow

Role: Manual QA Tester

Description: Wells Fargo is a diversified financial services company providing banking, insurance, wealth management and estate planning, investments, mortgage, and consumer finance. Default Workflow is a mortgage related workflow application that captures loan details, investor, borrower, property information apart from other lien information and displays the overall case (loan) status as new/pending/resolved with status code. based on the progress of the workflow.

Responsibilities:

•Involved in writing Manual test cases, logging, and analysis of bugs

•Performed Smoke testing to ensure proper deployment of application in the test environment. and performed regression testing. to ensure that the code is not broken.

•Segregated bugs based on Priority and Severe and maintained the log using HP Quality center

•Involved in writing SQL queries for backend testing to verify the proper interaction between GUI and the database.

•Scripted SQL queries to verify data integrity and validate updated data for test cases.

•Participated in regular project status meetings related to testing phases.

Environment: Manual Testing, HP Quality center, MS Excel, SQL

Walgreens, Deerfield, IL March 2013 - Sep 2015

Project: Re-engineering Explanation of Benefits (EOB)

Role: QA Analyst

Explanation of Benefits (EOB) is a reengineering project to convert the existing PL/SQL code to ETL DataStage and to follow the requirements of Centers for Medicare and Medicaid services (CMS). The project aim is to enhance the current processing and response time of the system to meet business expectations. This project generates EOB template reports for members who are part of Medicare partD coverage.

Responsibilities:

•Analyzed the user/business requirements and functional specs documents of various interfaces and involved in testing them and automated them as required.

•Wrote and analyzed user stories and participated in Sprint planning and Scrum Meetings and developed Test scenarios, Test cases and Test data.

•Developed Test cases based on user stories (Functional requirements) in HP Quality Center.

•Executed Test cases and complete QA testing life cycle.

•Created and enhanced numerous test scripts to handle changes in objects, in application’s GUI and in testing environment using Selenium WebDriver.

•Performed build acceptance testing and smoke testing using Cucumber automation tool.

•Wrote test cases and performed Manual Testing like Positive Testing and Negative Testing, Regression Integration and Unit Testing.

•Implemented Data-Driven test to verify the same functionality with multiple sets of data.

•Defect testing and exploratory testing/Ad-hoc testing was performed after each build.

•Performed UI testing, Database testing after reviewing the story cards and database changes.

•Worked closely with development and project management teams for effective defect management and verify resolved bugs and track enhancements made to business requirements.

•Involved in Continuous Integration of automation frameworks with Jenkins.

Environment: Java, Selenium WebDriver, Selenium GRID, REST ASSURED, HP Quality Center, SoapUI, Cucumber, BDD, Agile, Jira, Maven, XPath, Eclipse, Manual testing, JDBC, SQL Server, MySQL, HTML, XML, JSON, GIT, TestNG, Jenkins.

Andhra Bank, Mumbai, India March 2008 – August 2010

Project: Retail Banking Operations

Role: Accounts Executive

Description: Being accounts executive I am responsible for all financial transactions inbound /outbound transactions on retail banking of Andhra bank Division. Most of the transactions are Credit/Debit cash transactions in Savings/Check-in accounts. Some of my key responsibilities are handling customer queries and banking requests at the counter and answering if any queries regarding their bank transactions validate the number of transactions completed daily/weekly and monthly and send consolidated reporting financial transactions dashboards to my senior management.

•Participated in the annual audit of Andhra bank Retail banking Division

•Developed several Excel spreadsheet macros currently in use for reducing entry time and automatically cross-referencing for errors

•Proficient in cash consolidation and executing daily transaction reports through ERP systems End of day cash reconciliation and balance report

Environment: Oracle – SQL and MS Office

Ranbaxy Specialty, Mumbai, Indi. March 2005 – Oct 2006

Role: Data Analyst

Project: Internship program

•Review Functional requirements and use case documents to understand the business logic, application requirements and technical aspects of the system.

•Developed several Excel spreadsheet macros currently in use for reducing entry time and automatically cross-referencing for errors

•Data entry, data auditing, creating data reports & monitoring all data for accuracy

•Analyzing raw data, drawing conclusions & developing recommendations

•Extensive Excel work using pivot tables and complex formulas to manipulate large data structures. Environment: Oracle 10 G, Microsoft Office Suite [Excel, SharePoint, and PowerPoint] graph making, formulas, pivot tables.

Certifications:

Appearing for Selenium certification March 2023

Appearing for Cloud Practitioner certifications on AWS/Azure/GCP April 2023

Advanced Data Analysis in MS-Excel 2010 by UMCS group – Worcester – MA

Pharmacy Benefit Manager [PBM] – SXC Health Solutions is now Catamaran - Lisle, IL

Contact this candidate