Archana Kothakota
********.****@*****.***
* ***** ** ********** ** a SOFTWARE DEVELOPMENT ENGINEER IN TEST-SDET
PROFESSIONAL SUMMARY
* ***** ** ********** ** Software Automation Testing, Manual Testing, Software Release Management and Quality Improvement Processes with almost 2 years of experience as SDET Engineer. Expertise in writing Test Cases, Test Plan and Automation test scripts using Selenium, Cucumber BDD, API testing using SoapUI, Mobile Testing using Appium, Angular UI testing with Protractor, Continuous Integration using Jenkins & current QA methodologies serving various domains such as Insurance, Agriculture, E-commerce, HealthCare and Finance.
TECHNOLOGIES SKILL SET
Test Approaches
SDLC, STLC, Bug Life Cycle, Waterfall, Agile/Scrum,
Testing Tools
Selenium WebDriver, Selenium IDE, Selenium RC, Selenium Grid, TestNG, JUnit, Cucumber, Appium, Protractor, SoapUI, QC
Test Build& Integration Tools
Maven, ANT, Jenkins
Frameworks
Data Driven, Keyword Driven, Hybrid, Page Object Model (POM)
Programming Tools
JAVA, JavaScript, Angular JS, VB Script, Gherkin, SQL, C, C++
Markup Languages
HTML, XML, XPath, CSSS elector
Databases
MySQL, Oracle, SQL Server
Browsers
Internet Explorer, Mozilla Firefox, Google Chrome, Safari, Opera
Operating Systems
Windows 7/8/10, Ubuntu, UNIX, LINUX, Android, IOS
Defect Tracking Tools
HP Quality Center, JIRA, .
MS Office Tools
Outlook, Word, Excel, PowerPoint, MS Access
Utilities
Eclipse, GIT, SVN, Firebug, Fire Path, IntelliJ, IOS XCode, Appium Desktop
Mobile testing tools
Perfecto Mobile, Appium
CORE QUALIFICATIONS
Worked on various open source tools such as Selenium WebDriver, Selenium Server, Selenium Grid, Selenium IDE, TestNG, Cucumber, Appium, Protractor, JAVA, Jenkins, Maven, JUnit, Web Applications, SoapUI, JIRA, and SQL.
Worked in various domains such as Insurance, Healthcare, Agriculture, E-commerce and Finance.
Develop critical metrics for effectively measuring and managing test deliverables and processes.
Proficient in complete testing process of a given software application for different software releases, includes creation of test plans, test cases/test scripts by maintaining Quality procedures and standards to meet client's requirements and expectations.
Experienced with Review meetings to identify Ambiguities in functional requirements.
Experience in Requirement analysis, Project effort estimation, Resource planning, monitoring the progress of the activities and application reviewing.
Closely worked with the developers and the other testers to solve any technical and end user issues.
Strong expertise in Agile with SCRUM lifecycles.
Experienced in all the stages of the SDLC (Software Development Life Cycle).
Expertise in Defect Management/ Problem solving including tracking bugs, reporting using Rally, JIRA, Quality Center and Bugzilla.
Used various Selenium Locators like ID, name, Link Text, Partial Link Text, XPath, CSS for identifying correct GUI elements in creating automation scripts.
Validated various test scripts using Assert and Verify commands.
Well acquainted with Selenium Synchronization Techniques like Implicit, Explicit, and Fluid Waits in the WebDriver.
Expertise in using different Navigation Commands and managing web-based Popups using Alerts.
Executed automation scripts on different browsers/environments by executing tests in parallel through Selenium Grid, for cloud testing used Sauce Labs and reported defects/results to the team.
Possess qualitative experience in testing on Service Oriented Architecture (SOA Testing) and JUnit testing, along with providing technical support assistance to developers in troubleshooting.
Possess the expert level of understanding of WSDL, WADL, XSD, Schema, DTD, and XML documents for Web Services Testing using SoapUI.
Actively involved in implementing testing Frameworks Keyword Driven, Data Driven, Hybrid and Page Object
Model (POM) using Selenium.
Established working rapport with business partners to take a more ATDD approach. 100% Automation of
Business scenarios-Decreasing testing time significantly.
Proven ability in developing BDD scripts with Cucumber and writing step definitions, features in Gherkin.
Good knowledge of API testing to ensure functionality, reliability, performance, and security of API’s.
Utilized SQL for test setup and data validation on Oracle, SQL Server databases also handled the tasks of designing and managing SQL Queries, Stored Procedure's and cursors and performed Database testing.
Designed and used Automation Test Frameworks (Hybrid-POM and Data Driven) and involved in the development of Singleton Design Pattern from scratch.
Strong understanding of TestNG Data Provider annotation to configure multiple datasets to implement Data Driven Testing in WebDriver.
Inculcated Apache POI API with Selenium WebDriver to read and write data from Microsoft Excel.
Perform as hands-on tester and performed in-depth Data Driven Testing to simulate complex business scenarios in test environment.
Trained and mentored offshore team on automation best practices and methods to improve reusability for regression testing.
Hands on experience in using build and project management tolls like Ant, MAVEN
Responsible for developing the scripts to support Jenkins (Continuous Integration) of the scripts with the build server
Involved in End to End Testing of Angular 2 application using Jasmine and Protractor.
Produced Quality Center and Excel metrics/reports from scheduled execution test run.
Used Appium for testing native mobile applications.
Worked closely during Requirements Gathering Phase with business and Development Departments to adequately define the testing scope for projects.
Interpreted and converted manual test cases into automation Smoke and Regression Suites in Selenium Web driver in Java.
Maintained the Selenium JAVA automation code and resources in source controls like CVS, SVN, GIT over the time for improvements and new features and resolved conflicts while merging source code to trunk or with other branches in the same.
Ability to work under tight deadlines and rapidly changing priorities and handle multiple projects simultaneously with a limited timeframe release cycle.
Proficient knowledge in various types of software Testing such as Usability Testing (UT), Smoke Testing, Sanity Testing, Positive and Negative Testing, Data Driven Testing, Regression Testing, Unit Testing, black box testing, white box testing and Integrated Testing.
Delivered thorough QA testing reports that determined product quality and release readiness using TestNG and JUnit reporting.
Proficient in Defect analysis, performing Verification using walkthroughs, reviews, inspections also performed Validation activities using smoke, regression, functional, systems and UAT testing.
Generated test logs using Log4j for various log levels.
Reviewed and transformed Business and User Story requirement documentation and created wireframes for stakeholder approval.
Efficient in reformulating strategies through Process Re-engineering, Change Management, Release Management, Process Improvements and UAT Testing.
Coordinated with developers and worked on bugs until they are resolved.
I traced Requirements throughout the development process and verifying adherence using the Requirement Traceability Matrix (RTM).
Ensure content and structure of all Testing documents / artifacts are maintained. Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
Holds strong ability to handle multiple tasks, prioritize workload and work independently as well as in a team.
Dynamic team player who is consistently motivated toward success and completion of projects with an ability to work independently.
PROFESSIONAL EXPERIENCE
Software Development Engineer in Test at Anthem Blue Cross and Blue Shield Wallingford, CT
March 2017- Present
Description:
Anthem is a trusted health insurance plan provider. Anthem provides health care, dental, vision and Medicare plans. The system helps with expression effectively manage current and future needs for end to end customer communication Insurance policy lifecycle. Expression provides a comprehensive set of components for insurance policy document design, assembly, composition, output processing and delivery.
Roles and Responsibilities:
Primary duties include System, Integration, Regression and Data testing for D2L (Desire to Learn) application in an Agile development environment, to include execution, defect tracking, reporting and test team coordination.
Secondary duties Process Integration/Interaction, JIRA project setup and maintenance (import test cases, create test cycles, execution, dashboard reporting) and interfacing directly with the end client
Worked closely with Product team, Designers and Developers to ensure application development meets requirements & user's expectations.
Excellent understanding of Software Development Life Cycle (SDLC), Software Development Engineer in Test(SDET), Defect life cycles(DLC) and Test Strategies from project definition to post-deployment.
Evaluated & Reviewed user stories and participated in Sprint planning, Review Sessions & Scrum Meetings and developed Test scenarios, Test cases, Test data, Test procedures, Test reports.
Performed testing of the batch job that expression uses to provide comprehensive set of components for insurance policy documents assembling and output.
Used JDBC to save and retrieve the policy pdf files using the policy database.
Created automation framework and test scripts using JavaScript, Selenium WebDriver, Java, Selenium Grid, Cucumber, and Maven and executed the test scripts.
Continuously improved automation test suite to match development life cycle.
Understanding with coding in Java, C++, HTML, CSS, JavaScript.
Experience in Core Java concepts such as OOP Concepts, Collections Framework, Exception Handling, I/O System, Multi-Threading, JDBC.
Created Generic functions that deal with different sets of data.
Created Test Plan and wrote Test cases for each sprint.
Involved in developing of Data driven framework with Page Object Model to test the web application and used Maven build tool to implement the framework dependency jar files.
Used GIT-hub repository as a source repository system to share code within the office as well as with the team in overseas and stored the framework and all the developed test cases.
Performed Cross Browser and parallel testing to test whether the web applications are working as desired in different browsers and environments using TestNG.
Implemented TestNG in Grouping of Test Cases, Test Methods and Test Suites for regression and functional testing using the TestNG annotations like Groups, Parameter, Data Provider.
Took the application Screenshots and copied the images whenever exceptions occurred and at important checkpoints of application execution.
Used Apache POI to read data from Excel sheet.
Performed continuous integration of code and scripts using Jenkins, Maven and TestNG. Configured and launched builds using Jenkins jobs and analyzed the Test Results from Jenkins UI.
Implemented TestNG automation framework for Smoke Test to ascertain that the crucial functions of the application work.
Used Jasmine and Protractor for End to End Testing of Angular2 application.
Performed Integration and Regression Testing to check compatibility of new functionality with the existing functionalities of the application and executed end-to-end testing.
Achieved Synchronization between test scripts execution and application using Implicit waits and Explicit waits.
Handled automation framework code re-factoring to support test suites reusable.
Actively participated in code reviews to increase test coverage.
Performed Database testing, scripted SQL queries to verify data integrity and validate updated data for the Test cases in different modules of the application.
Performed functional testing of SOAP and REST Web Services. Validated request and response XML. Added assertions to validate the XML in Web services SOAP and RESTFUL service
Performed BDD (Behavior Driven Development), ATDD (Acceptance Test Driven Development) using Cucumber Features, Scenarios and Step Definitions in Gherkins format.
Experience in doing automation testing for Mobile application using Appium tool.
Segregated defects based on the hierarchy of the effects on the test scripts using Log4j using its components like loggers and appenders.
Involved in Weekly Status Meetings with development and management Teams.
Involved in Product Backlog, Sprint Planning, Sprint backlog, Daily Scrum Calls, Sprint demo, Retrospective Meetings.
Provided support to the client during UAT and regularly involved in client communication.
Interacted with the Development team and the Environment team in prioritizing the defect list and validating known bug fixes.
Worked closely with onsite team and worked on needed enhancements to the legacy platform.
Reported the test result using the output in excel files, TestNG reports, XSLT reports and Cucumber JVM reports.
Accessed Share point for all the report.
Interaction with Business Analysts and Developers to resolve the technical issues to meet the client's requirement for a better-quality software product.
Experience in handling team and coordinating team with Offshore (Direct/manage).
Served as QA resource during launches to the production environment.
Participated in concept and requirements definition meetings; provided feedback for functional and technical design documents.
Produced QA Level of Effort estimates and QA release schedules for projects.
Identified and documented product risks and project risks, and the severity and impact of those risks.
Well versed in Jira Agile - For Plan, Add User Stories, Add Task, Create Test Cases, Create Defects, and Iterations.
Followed Sprint Burn down Chart, Release Burn down Chart and attended Agile Sprint Meeting.
Worked in high-pressure environments adhering to product quality standards and delivery dates.
Stay abreast of new test methods and tools.
A versatile team player coupled with excellent interpersonal and communication skills.
Environment: Selenium IDE, Selenium WebDriver, Apache POI, Java, HTML, CSS, X-path, SQL, Maven, SOAPUI, Appium, Cucumber, Protractor, TestNG, XML, Log 4j, Share point, Agile, Jira, Jenkins.
Senior Agile QA tester at State Street Corporation
Boston, MA
April 2015-March 2017
Description:
State Street Corporation, known as State Street, is an American worldwide financial services company. Online banking provides client to login, to view account information such as account summaries, account details, monthly statements, balance transfers, accrued interest, check ordering, loan application, to apply credit cards, financial services and gives opportunities to perform online trading of securities stocks and bonds.
Roles and Responsibilities:
Actively involved in all stages of software development life cycle (SDLC), which includes requirement, analysis, design, development, testing and documentation, Agile/Scrum methodologies
Designed and developed test plan, test cases and automated test scripts.
Designed and executed test scripts for manual testing on desktop browsers (Windows and Mac), and mobile devices (iPhone and Android)
Evaluated Business Level Requirements, and Manual testing methods.
Involved in understanding the requirements from Functional Specification Document, Use cases, User Stories, cross team meetings and discussions.
Validated modules of online banking which includes add external account, Balance transfer, Online Payment Management, Mortgage, etc.
Performed Smoke, Functional, Integration, System, User Acceptance Testing, Regression and GUI testing.
Developed test cases and performed Integration testing of the combined software modules and tested as a group.
Automation Expertise through HP Unified Functional Testing Selenium for creating, maintaining, and debugging complex and innovative scripts for frameworks such as Modular, Data-Driven, Keyword-Driven, Hybrid Framework and BPT Framework.
Performed end-to-end testing considering all interfaces and subsystem for functional and non-functional testing.
Followed up on defects status and generated reports for managements.
Identified correct GUI elements using various Selenium Locators like ID, Name, Link Text, Partial Link Text,
XPath and CSS to find the Web Elements using selenium and creating automation scripts.
Developed and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using Selenium WebDriver
Designed and executed Selenium test cases using Maven (Page Object Module) and Jenkins.
Used Jenkins for nightly build execution and sending status mail if build fails to QA team
Performed acceptance testing using Cucumber.
Developed BDD tests using Cucumber by writing behavior and step definitions & developed required Selenium support code in JAVA for Cucumber.
Experienced with Acceptance Test-Driven Development (ATDD).
Developed Cucumber suite for Behavior Driven Development using Cucumber.
Developed and maintained several test scripts to automate the process of testing using Selenium WebDriver, with TestNG framework using java.
Developed, maintained, and executed test plans, test case, and manual testing using SQL scripts for Oracle with TOAD.
Expertise in writing the Test scripts using core java language.
Expertise in Object Oriented Programming and skilled in developing automated test scripts in Selenium.
Experienced in using Selenium WebDriver, Eclipse, Java and TestNG frameworks in creating test scripts, Annotation, Parameterization, Data providers, Test suites and HTML reports.
Used GitHub as a version control managements system for the automation scripts and used Git to update repository.
Performed cross-browser testing for the web interface and mobile application using Selenium WebDriver
Identified the Elements using Appium Inspector. Configuring the Appium for the Mobile IOS using selenium
Configured Appium for the Mobile Android Native App using selenium.
Responsible for performance testing (Load, Stress and Volume) using JMeter (Controller, Virtual User Generator).
Involved in end-to-end testing from the planning to design and development into execution, working very closely with the development teams and the customer
Performed test automation for UI and WCF/REST Services and created reusable and shareable components Using JMeter
Developed and executed complex SQL queries to validate test data.
Performed activities in SQL like select, Index, insert, joining tables, aggregate functions, and sub-queries, set functions, triggers, errors and views.
Generated status reports and Defect reports and presented them in weekly status meeting.
Communicated with different team such as development, requirement, and configuration management.
Environment: JIRA, Selenium WebDriver, Appium, JMeter, API, JUnit, TestNG,Maven, Jenkins, Fire Path, Firebug, HTML, Internet Explorer, Chrome, Mozilla Firefox, Cucumber, Gherkin, Java, UNIX, Linux, Windows XP, JavaScript, XML, Excel, SQL, Windows, Selenium.
QA Automation Engineer at PNC Bank
St. Louis, MO
October 2013- March 2015
Description:
PNC is a highly diversified and growing financial services organization spanning the retail, business and corporate markets. PNC offers a wide range of services for all our customers, from individuals and small businesses, to corporations and government entities, their business are categorized in to Retail Banking, corporate and Institutional Banking, Asset Management and other services like the Borrowing, Investment, Insurance, Online Banking Activities, e-statements, Home Loans, Equities, Mortgages, Loan center. The project was to create a Test automation system to deal with Mortgage based on Home Value, Loan Amount, Interest Rate, Loan term, Start Date, Property Tax, and Private Mortgage Insurance. Based on Customer requirement specifications, System enables mortgage Repayment Summary along with Re-payment chart, Balance graphs.
Roles and Responsibilities:
Understanding business requirements gathered from Business Analysts.
Participated in identifying the Test scenarios and designing the Test cases.
Understanding requirement and developing end to end automation test scripts using Selenium WebDriver with TestNG framework.
Involved in development and execution of TestNG suites for the bank application modules using TestNG framework.
Developed and maintained automated regression test cases in Selenium WebDriver using Java.
Used Ant build management and implemented the framework dependency jar files.
Identifying the web elements easily by id, name, CSS Selector, XPath, Class Name, link Text, partialLinkText, tag Name using the Firebug and FirePath.
Saved remarkable time and cost of testing by automation using Selenium WebDriver, JAVA, Cucumber.
Implemented Implicit and Explicit waits to overcome synchronization issues.
Automated Smoke and Functional test cases using Selenium WebDriver, TestNG and Java (Eclipse IDE).
Used updated extent reports dependencies to generate more pictorial reports.
Involved in updating Framework functions when needed, executed them and generated reports.
Analyzed Test Reports and Prepared Test Summary Report.
Performed Smoke, End to End and Regression tests in Test environment and Production support environment.
Involved in cross browser testing in different browsers and operating system using selenium grid.
Handled broken links and inter application links in development test and production environments using Selenium WebDriver.
Used SOAPUI tool to test Service Oriented Architecture (SOA) based architecture application to test SOAP services and REST API.
Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
Used JIRA as a test Management tool and as a bug reporting tool to track test progress, execution and deliverables.
Configured TestNG to get reports using Listener in selenium WebDriver.
Implemented the mouse and keyboard events using the Actions class.
Used Apache POI to read and write data from Excel sheets and testing the test scenarios.
Provide Daily and Weekly Status Reports on project.
Environment: Selenium IDE, Selenium WebDriver, Apache POI, Java, FireBug, FirePath, HTML, CSS, X-path, SQL, Ant, SOAPUI, TestNG, XML, JIRA, Jenkins.
QA Test Engineer at Basket Option
Bangalore, India.
January 2012- September 2013
Description:
Basket option is an online E-commerce portal in India. It has got a quick and efficient service, making people’s life as leisure as possible. Taking time in to most consideration, they came up with a new caption to simplify the consumer needs.
Roles and Responsibilities:
Analyzed user requirements for application enhancements and preparing testing specifications.
Optimized Selenium scripts for Regression testing of the application with various data sources and data types.
Involved in Automation testing of web based applications using Selenium.
Involved in bug tracking using Quality Center.
Involved in writing the SQL Queries.
Executed and scheduled the automation test scripts from Quality Center.
Involved in preparing manual test scripts to evaluate Corporate Information Security Web based user authentication applications.
Involved in Analyzing the requirements document to formulate the test cases and conducted manual testing for the entire application
Prepared Test cases and Test plans for new functional modules.
Used Selenium IDE for test automation for record and play back of scripts and performed functionality testing, GUI testing, and regression testing manually.
Performed Data Driven and Keyword driven Tests
Designed and maintained Hybrid Framework
Extensively used my SQL proficiency during data migrations.
Prepared load test scripts using Apache JMeter.
Developed unit tests using JUnit.
Used Firebug and Firepath for element identification while creating Page Object Repository.
Executed automated tests in appropriate test regions in support of unit, integration, functional, and regression testing using WebDriver.
Designed and developed automated scripts.
Developed automation scripts using Selenium to make them flexible and useful for Regression testing.
Environment: Manual Testing, SQL, User Acceptance Test Cases (UAT), Agile Testing Methodology, UNIX, MS SQL Server, MS Excel, QC, JUnit, Windows XP, Selenium IDE, WebDriver, HTML, SoapUI, XML, Java Script, UNIX and Windows.
Software Developer at Sunshine Hospitals Hyderabad, India
Jan 2010 – July 2012
Description:
This is a care communication service for payers to provide pre-care messages and print messages to members and providers. The service targets quality improvements in healthcare decision-making and cost avoidance for payers. It also intends to improve member health and reduces the overall healthcare cost.
Roles and Responsibilities:
Involved in analysis and design of the application.
Prepared the detailed design document for the project.
Involved in developing the application using J2EE architecture.
Involved in developing forms using HTML and performing client side validations using JavaScript.
Forms were designed for user interaction using JSP, JavaScript, and HTML.
Involved in API development using Core Java concepts and developed the code per functional requirement.
Developed code Using Eclipse for integrated development environment.
Designed User Interfaces using JSP, JavaScript, CSS, and HTML for front end view and displayed the hierarchy tree of agents.
Created cross-browser compatible and standards-compliant CSS-based page layouts.
Designed and developed Servlets to communicate between presentation and business layer.
As a developer, coordinated with onsite team and client in understanding the business process and requirement understanding.
Used JMS in the project for sending and receiving the messages on the queue.
Developed the Servlets for processing the data on the server.
Used JDBC for database connectivity with MySQL Server and used the JDBC for data retrieval from the database for various inquiries.
Designed SQL queries and Stored Procedures for data accessing.
Involved in the team discussions regarding the Modeling, Architectural and Performance issues.
Maintained versions using CVS tool to merge code, check in and checkout the data.
Participated in Code Review and Quality Assurance.
Analyzed defects and fixed problems and Involved in peer review of test results.
Performed testing of the application (Unit testing, Integration testing, System testing).
Involved in writing and reviewing unit test cases using JUnit.
Environment: Core Java, J2EE, Servlets, JDBC, JMS, JSP, JavaScript, CSS, HTML, MySQL Server, CVS, JUnit