Data Test
Resume:
Priyanka Krishna
**********.**@*****.***
C: 732-***-****
SUMMARY
Software Testing experience in Manual/ Automation Testing of Mobile and Web applications & clients specializing in Quality Assurance Testing, QA Automation Engineer, Software Development Engineer in Test (SDET), Selenium Tester proficient in testing Mobile and Web based applications
Experience in performing the Black box testing, integration testing, UAT Testing, Functional, Integration, Regression, User, Acceptance (Alpha and Beta Testing), System, UI-testing, Smoke, Sanity, Content testing, Database testing, system testing, and supported user acceptance testing (UAT) with business users.
Experience in developing, Test cases, Test Strategy, Test scenarios and Test Scripts based on User requirements and System Requirements Documents for Functional, Security, Performance, Configuration, Regression, Integration, Usability Testing and Cross- Browser Compatibility Testing.
Experience in writing test cases as per the Software requirement specifications.
Experience in working with open source tools Selenium (Selenium IDE, Selenium RC, Selenium Web Driver), Eclipse and preparation of automation test framework.
Experience in Understanding the code written in different programming languages Java, JavaScript, SQL, and databases like Oracle, SQL Server.
Extensively worked on Data Driven, Keyword Driven and Hybrid test Automation Frameworks.
Extensive experience in performing Manual and Automation testing using Selenium IDE, Selenium Web Driver and for a web application, by creating test cases and test scripts in Selenium to automate a web application’s functionalities.
Experience in working with Continuous Integration and Continuous Deployment (CI/CD) tools.
Extensive experience in working with Microsoft office products including Word, Excel and Access.
Strong in performing database backend testing and in writing SQL Queries.
Interacted with developers and business Users to communicate the defects and actively participated in replicating the bugs and performed regression testing using JIRA.
Worked with Quality Center to trace the requirements, write the Test Cases in the test plan, execute the Test Sets in the test lab and track the Defects logged in the defects module.
Participated in full SDLC and handled complex projects involving the different phases of SDLC like requirements gathering, design, coding, testing and maintenance.
Excellent skills in overall Defect Management/Problem Solving including tracking bugs, reporting using Quality Center, Jira and Bugzilla.
Ability to understand client requirement and provide with the best solution.
A resourceful team player with good Interpersonal, effective problem solving and decision-making skills. Looking ahead for great career in a fair working environment with opportunities to grow.
Educational qualifications:
Master of Science in Electrical Engineering, USA GPA (3.02) Dec 2009
Bachelor of Engineering in Electrical & Communication Engineering, India GPA (3.20) April 2007
TECHNICAL SKILLS
Languages
Java, Java Script, CSS, HTML, SQL
Technologies
J2EE, JSP, JDBC, HTML, XML, Java Script, Angular JS, SOAP, XML, VB Script
QA Tools
SELENIUM IDE/RC/ Web Driver/ GRID, Protractor, QTP, JUNIT 3/4, TEST NG, Maven, Firebug, Fire Path, Rally.
Skills
ATDD, TDD, BDD Using Cucumber, Varicent.
Bug Tracking Tools
Quality Center, Quick Test Profession, Unified functional testing, BugZilla, JIRA
Build/Integration Tools:
Maven, Ant, Jenkins
Web Services
SOAP, REST, WSDL, SOAP UI
Operating system
Windows, Unix.
Database
Oracle, SQL Server, MS Access, MySQL, DB2
Web Servers
Tomcat, Web Sphere, Web Logic, IIS
Browsers
Internet Explorer, Firefox, Chrome, Safari
EXPERIENCE
Employer: Virtue Group LLC Feb 2012 – Present
Client: T-Mobile, Bellevue, WA MAY 2018 –Present
Software Development Engineer in Test (SDET):
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Performed test for Functionality, regression, GUI, End to End, system, configuration and backend.
Extensively used SQL Queries to verify and validate the data in Database.
Used IBM Varicent process used to transform a series of records into a new result. Typically, a calc is mathematical, but calcs may include sorting, shifting, or adding to a prior result. Calcs enable the model admin to select records from their source data, perform operations on the data, segment results, and begin another calc based on those results
Validate Varicent Web client (UI) for commission UI testing.
Automated the validation of data by writing the complex queries like functions & procedures.
Automated the regression testing process which covers the entire process End to End for any payout changes.
Written Power shell scripting to generate email notifications.
Developed VB script to automate few processes, that acted as external tools to the existing commission systems, that run on the cloud server.
Experience in testing tools such as Mercury Test Director /Quality center.
Client: T-Mobile, Bothell, WA Aug 2017 –Apr 2018
UAT/QAT Test Analyst
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Performed test for Functionality, regression, GUI, End to End, system, configuration and backend.
Extensively used SQL Queries to verify and validate the data in Database.
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and Reports Testing
Used IBM Varicent process used to transform a series of records into a new result. Typically, a calc is mathematical, but calcs may include sorting, shifting, or adding to a prior result. Calcs enable the model admin to select records from their source data, perform operations on the data, segment results, and begin another calc based on those results
Validate varicent Web client (UI) for commission UI testing.
Automated the validation of data by writing the complex queries like functions & procedures.
Modified and maintained test cases with changes in application interface and navigation flow.
Participated in Daily status meetings to discuss the status of the project, review meetings to discuss the bottlenecks and its resolutions.
Client: City of Seattle, Bellevue Feb 2017-Jul 2017
QA Analyst - Software Development Engineer in Test (SDET):
Responsibilities:
Involved heavily in converting Business Requirements into Functional requirements.
Conducted Black box testing, Smoke testing, Screen Validation testing, Data driven testing(Cucumber), Positive & Negative testing, System testing, Regression testing, End to End testing, Functional testing, Integration testing.
Wrote Acceptance test using BDD Cucumber/Java.
Created Feature File, Scenario Outline with Cucumber framework.
Improved data driven selenium framework by creating methods to save/create screenshots on test failures.
Actively involved in black box, functional, regression, system, integration, positive, negative, GUI, performance, load and UAT testing of the application.
Created Automated scripts - Load Runner Web Services REST, TruClient, .Net WCF, Web Http/Html - Vugen.
Involved in automation scripts for mobile native applications using Appium, Java and Selenium.
Created Test Data using SQL: Wrote SQL queries for back-end testing.
Developed ANT Build scripts to run Sanity Test scripts developed in Selenium WebDriver (java).
Developed new and updated existing Automation test cases using Selenium WebDriver and TestNG, using SVN as VCS for java based web application, using Maven as Build tool.
Extensively used ALM/Quality Center for storing all Test plan documents, Test case documents and record defects.
Customized Selenium API to suit in testing environment.
Achieved an Agile Behavior-Driven Development (BDD) implementation with Cucumber gherkin and Jenkins Continuous Integration, expanded test scenarios, tracked Cucumber reports.
Implemented properties files to read configurations and XPath of elements in the application for better readability of the code.
Integrated TestNG with Selenium using Eclipse to generate test execution result.
Had regular meetings with Developers to report various problems.
Worked on the Parameterization using TestNG Parameters and Data Provider annotations in Selenium WebDriver Scripts.
Attended daily Scrum/Agile stand up meetings with the team to discuss status.
Continuous Integration through Jenkins, running the existing scripts on a daily build basis and verifying the results and updating the scripts based on the result and the requirement changes.
Trigger Builds, setup email notification for test results and linked scripts with source code.
Integrated Maven (Build tool) and Version Control system(GIT).
Client: T-Mobile, Bothell, WA May 2014 – Dec 2016
UAT/QAT Test Analyst
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Prepared Test data for interpreting the Positive, Negative and Regression Results.
Performed test for Functionality, regression, GUI, End to End, system, configuration and backend.
Extensively used SQL Queries to verify and validate the data in Database.
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Experience in Data Analysis, Data Validation, Data Modeling, Data Profiling, Data Verification, Data Mapping, Data Loading, Data Warehousing/ETL testing and Reports Testing
Used IBM Varicent process used to transform a series of records into a new result. Typically, a calc is mathematical, but calcs may include sorting, shifting, or adding to a prior result. Calcs enable the model admin to select records from their source data, perform operations on the data, segment results, and begin another calc based on those results
Validate Varicent Web client (UI) for commission UI testing.
Automated the validation of data by writing the complex queries like functions & procedures.
Modified and maintained test cases with changes in application interface and navigation flow.
Participated in Daily status meetings to discuss the status of the project, review meetings to discuss the bottlenecks and its resolutions.
Client: Microsoft, WA May’2013-May 2014
QA Analyst
Reviewing test requirements, develop test plans,test data and expected results necessary to thoroughly test the business requirements
Prepared Test data for interpreting the Positive, Negative and Regression Results.
Performed test for Functionality, regression, GUI, End to End, system, Smoke testing, configuration and backend.
Executing test plans to produce actual results, working with business analyst to validate actual test results to expected test result and ensure testing requirements are met.
Developing Test Plans & Test Cases and SQL Queries Based on Business Requirements
Created SQL queries to fetch and verify the data from Source and Target (Destination tables).
Used MTM Visual Studio 2010 for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
SSIS and SSRS Packages in SQL Server 2008.
Actively involved in SSIS, SSAS design and maintenance activities as part of the business CR’s.
Extensively worked on SSRS & Cube reports validation using SQL queries
Generated Reports using XML spy edit tool.
Experience in testing Web-Services using REST client (LIST, SHOW, POST and PUT Methods and error code verification) and SOAPUI.
Used UI Automation to Test the Code.
Coded UI Tests particularly where there is validation or other logic in the user interface, for example in a web page. And, frequently automate an existing manual test by selecting Visual C#.
In Visual Studio Used Coded UI Test Builder, Coded UI Test Editor to edit existing code.
Trigger Builds, setup email notification for test results and linked scripts with source code.
Integrated Maven (Build tool) and Version Control system(GIT).
Client: T-Mobile, WA June’2011-April’2013
QA Analyst
Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
Performed test for Functionality, regression, GUI, End to End, system, configuration and backend.
Involved in full life cycle development of ETL data warehouse and interacted with the Subject Matter Experts, business analyst and the developer regarding the application requirements and enhancements.
Tested the data loads from Legacy Landing zone to Staging and staging to Commission Landing (ACS & ICS).
Extensively used SQL Queries to verify and validate the data in Database.
Automated the validation of data by writing the complex queries like functions & procedures.
Used Informatica power center tools like Designer, workflow monitor and workflow manager to monitor and schedule sessions and workflows.
Worked on Power Center client tools like Source Analyzer, Warehouse Designer, Mapping designer, Mapplet Designer and Transformations Developer
Testing ETL mappings/Jobs, based on the customer requests.
Modified and maintained test cases with changes in application interface and navigation flow.
Written the Functional specs for new upcoming sources as of how the data is flowing into Adapter and legacy.
Written the functional specs for feeds that need to be given to Varicent,
Tested the new sources in the Legacy system ACS&ICS such that there should not be any brake for existing feeds.
Employer : Software Experts Aug’2010 - Jan’2012
Client: Barclays Capital, PA Aug’2010-June’2011
QA Analyst
Created a comprehensive test plan from the Functional Specification Document, Business Requirements Document, and Technical Design Document
Decompose requirements into test conditions, cases, and scripts, and enter into Quality Center 9.0.
Validating XMLs’ with XSD’s using XML Spy tool.
Used SOAP UI 4.5.1 tool with WSDL’s to test the services and functionality for the web services.
Review test cases and other testing artifacts created by other team members for completeness and accuracy.
Prepared Test data for interpreting the Positive, Negative and Regression Results.
Responsible for testing End-to-End, Functional, Regression and Operational tools(opstool)
Developing Test Plans & Test Cases and SQL Queries Based on Business Requirements
Ran the Adapters which are responsible for Acquisition, Pre-Processing and Persisting of data received from the Avaloq system into WMR and Translating the data into WMR format.
Record Count Verification DWH backend/Reporting queries against source and target as an initial check.
Created test scripts for the application which uses SOA, Web services, SOAP and WSDL.
Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
Monitored and executed Batch (Autosys) Jobs investigated the issues if any and reported the issues to technical developers.
Good Exposure in using the QTP tool features such as Recording, Data table, Object Repository,
Debug viewer, Object Spy, Step generator, Parameterization, Actions, Methods, Checkpoints,
Synchronization and Recovery scenarios.
Experience in Descriptive programming in QTP.
Experienced in writing Automated Test scripts using VB Script.
Continuous Integration through Jenkins, running the existing scripts on a daily build basis and verifying the results and updating the scripts based on the result and the requirement changes
Contact this candidate