Data Test

Sailaja Venkata

*******.**************@*****.***

Contact-704-***-****

Qualifications:

●Certified Scrum Master.

●Six Sigma Certified.

●Experienced QA Analyst with experience in testing in Web based applications and Client/Server Applications.

●Experience in writing SQL Queries to perform backend testing and data validation.

●Experience in developing data driven and hybrid framework.

●Experience in creating Automation script using QTP, Selenium.

●Expertise in implementation of Automation framework using Selenium, QTP/UFT.

●Experience working with Agile, Waterfall and Iterative software development lifecycles.

● Manual Testing & Automation Testing in QTP/ UFT and Selenium.

●Software Development Life Cycle (SDLC) & STLC

●Black Box, UAT, and Backend Testing

●Requirement and design analysis

●Test Plan, Test scenarios, Test cases

●Waterfall, Iterative, and Agile (Scrum) Methodology

●Core team meeting and status update

●Risk analysis, Defect analysis, and Test Reporting

●Test management with QC/ALM/Rally/TFS Quality Center (QC), ALM, HTML, XML, Java, J2EE, SQL, Windows 7, 8, Share point, Outlook, Lync, Quick Test

●Pro (QTP), Oracle, DB2 and MS-Office. HTML, XML, CSS, Java, J2EE, MS Office Suite, Quality Center (QC), TFS Visual Studio, Oracle, Windows

Summary:

●Have around 8 years of experience in IT industry as a Software Test Engineer with specialization in Manual and Automation Testing (QTP).

●Good knowledge about Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

●Experience in creating excellent Test Approaches, Modularized Automation Scripts, Functional Scripts, Manual Test Plans and Test Cases.

●Created modularized Integration automation scripts to be ported across the various QA automation environments using Quick Test Professional (QTP)

●Involved in Functional Testing, Regression Testing and System Testing

●Proficient in working with Agile, Waterfall and Iterative software development lifecycles.

●Experience of testing in Web based applications and Client/Server Applications.

●Experience in testing Web Services using SOAP UI.

●Experience in Database testing, update/modify queries and writing Joins

●Good knowledge in identifying and analyzing defects.

●Creating and customizing, Defect Reporting and experience in Defect Tracking.

●Expertise in using Defect Tracking Tool i.e. ALM, Bugzilla and Zira.

●Expertise in working with Oracle, SQL Server and MS Access databases to validate data.

●Have knowledge in UNIX.

●Experience in maintaining the Software Quality Assurance process.

●Designing and monitoring Quality Assurance metrics such as Test results, Test status and Defect counts by coordinating with engineers.

●Extensive experience with Software services, Banking, Healthcare and Insurance applications and analysis of its business, technical, and functional requirements

●Experience in preparing Weekly Reports, Daily Status Reports and Test Summary Reports.

●Ability to multitask and prioritize work to meet deadlines.

Technical Skills:

Testing Tools: UFT/QTP 8.x/9.x/10, Selenium

Test Reporting and Bug tracking: Bugzilla, JIRA, Quality Center 9.x/10, SharePoint.

Programming Languages: VB Script, SQL, Java, C.

Build Tools: Eclipse IDE

RDBMS: SQL Server 2008, Oracle 11g.

Browsers: Windows [ IE, Chrome, Mozilla, Firefox].

SDLC Methodology: Agile, Waterfall, Spiral, V.

Operating Systems: Windows 2000/XP/Vista/ 7, Linux.

Professional Experience:

Nov 2016 to Dec 2020 Wells Fargo Charlotte, NC

Software Automation Tester :

Project: GSMOS

Payment Broker: It is the project module where I deal with the transactions in which the data is mapped with payment broker as a middleware. It actually compares the test data which is in xml format and sent back to GMTS to IFML format using UFT from GUI . As an automation tester I validate the test data and work on xml raw data comparing with the Baseline generated for the particular test case and sending the test result as an attachment in my ALM Explorer. . I am responsible to maintain the functional libraries for my project . The whole automation is done solely by me for that particular project. I directly involve in analyzing Business requirements, Functional Requirement specifications, and Design Specification Documents to understand the Application properly.

●Following Agile (Scrum) methodology implementing web and client server based application in various project.

●Responsible for creating Test Plan, Test Scenarios and Test Cases for various kinds of testing.

●Create Test Subject and designed Test Steps for each business functionality for positive/negative test scenarios, in the Test Plan module of Quality Center (QC)/ Application Life Cycle Management (ALM).

●Use the Test Lab module to execute test cases by creating Test Sets, manually testing each Test Step, and updating the Status (Pass/Fail/Blocked/Not Run) and logging defects for all the failed tests.

●Use the Defects Module in Quality Center to raise and assign defects, track defects, retest the defects fixed and monitor the defects until closure.

●Create test case coverage metrics and requirement coverage metrics and check test case run, pass or fail, not run, not run due to defect, total number of open defect and total number of closed defect in quality center.

●Generate Defect Status Report, Test Execution Report, and Test Summary report using Quality Center ALM.

●Attend weekly status meeting with Developers, Project manager and Business Analyst to discuss the defects, fixes and overall testing status.

●Responsible to create, maintain, modify and execute Automation Test Scripts for Regression Testing using Selenium

●Designed test cases using Selenium Webdriver

●Executing tests and enhancing the Selenium test cases for cross browser testing.

●Created Regression test suite using Selenium.

●Responsible to conduct Backend Testing using SQL queries in Oracle and DB2 database as primary work role

●Perform Data Validation and Data Integration, and retrieve data from database using various SQL joins, sub queries, and complex queries.

●Participate sprint planning, daily scrum, demo, and retrospective meeting with clients and team members.

●Communicate with developers and business analyst daily basis for clarifications and solve defect.

Mastercard – Mdes; St. Louis, MO Jan 2015 – Oct 2016

Automation Tester

●Meet client/SME to understand Application requirement and prepare master test plan.

●Using the requirements/specifications documents provided by client writing test cases and executing them.

●Testing the application functionality as per the requirements provided by client

●Involved in Manual and Automated Testing of the assigned modules.

●Modifying and enhanced scripts in each build

●Attending daily Scrum calls

●Developing Test Cases using WSDL, Schema files which defines Web Service Request, Response, methods/operations, End Point of web service to be tested.

●Preparing Automation test scripts for regression testing using QTP

●Developed Data Driven and Hybrid framework using VB scripts.

●Involved in review of requirements

●Responsible for Setting up Web Services project using WSDL in SOAPUI and provided setup help to other team members.

●Daily interaction with Client, Product Owner, Business leader and offshore team

●Defect analysis and tracking through JIRA

●Assisted agile teams and implemented all test plans in accordance to need of development projects.

●Conducted Black Box Testing (Functional Testing and Regression Testing) using Quick Test Professional.

●Using QTP to capture, verify and replay user interactions automatically to identify defects

●Coordinated with clients and prepared tests cases and ensured that all software applications were compatible with tests.

●Involved in Setting up the Data for Integration and End-to-End Testing

●Involved in preparing and monitoring the Status Reports Every Week, which includes Revision History, test case status, metrics, QA Issues and Defects

●Interacted with developers on defects status on a daily basis

●Testing application in different languages

●Giving training to Offshore team and new comers

●Conducting Poker Planning sessions in Team

●Attending Retrospective meetings to discuss about releases done

●Worked on application with Large scale Integration along with numerous other applications such as Bill Pay utility and Trading accounts, Complex Business workflows, Real Time, and Batch processing,

● High rate of Transactions per seconds, Secure Transactions, Robust Reporting section to keep track of day to day transactions

●Strong Auditing to troubleshoot customer issues, Massive storage system and Disaster Management.

●Involved in Preparing the Test Strategy Document, Test Cases and Test Cases Execution for all modules

●Manual Test Case Generation through exploration

●Test Case Management (Delete/Modify steps)

●Creation of Reusable Components from the Generated Test Cases

●Automate generated Test Cases and Reusable Components

●Test data parameterization

●Create manual and automation scripts when application is not available using virtual objects

●Defining Criteria for Selecting Test Cases for Automation

●Development of QTP Scripts using designed framework

●Test Artifacts documentation in QC and configuring the required mappings of execution and validation components for test cases.

●Object Repository Maintenance using framework on Training the customer and guiding them in maintaining the framework and usage.

●Experienced on working on SQL Single-row functions (Character, Number andDate etc), Group functions and sub queries.

●Experienced in executing SQL queries in order to view successful transactions of data and for validating data.

●Hands-on coding experience in scripting language - VB Scripting.

●Proficient in Functional Testing tool Quick Test Professional (QTP/UFT) and the various frameworks in QTP/UFT.

●Experienced in giving training to the functional testers to execute Test Cases using QTP/UFT as part of Regression Testing.

●Responsible for development of new tools using QTP and VB scripts useful for business needs.

●Wrote SQL Queries to perform Data Integrity Testing.

●Wrote VB Scripts to write scripts for testing certain functionalities in the unit.

●Performed testing extensively unit using QTP.

●Inserted verification checkpoints, synchronization points, and parameterized data using QTP.

●Experienced on demonstrating the Automation Framework in QTP/UFT to client and driven project status calls with client.

Houston Methodist; Houston, TX Aug 2013 – Dec 2014

Automation Tester

●Meet client/SME to understand Application requirement and prepare master test plan.

●Perform a proof of concept for a new project and present reports to client.

●Lead the testing activities from scratch to end.

●Meet with client to describe the methodology timelines and cost induction on any new project.

●Identify critical and important functionality and script using HP Loadrunner 11.5.

●Enhancing, Modifying and validating new scripts including correlation and parameterization.

●Execute tests and identify issues during performance tests.

●Preparing Automation test scripts for regression testing using QTP

●Designing a versatile automation framework for unattended/lights out testing

●Involved in Manual and Automated Testing of the assigned modules.

●Conducted Black Box Testing (Functional Testing and Regression Testing) using Quick Test Professional.

●Using QTP to capture, verify and replay user interactions automatically to identify defects

●Involved in Setting up the Data for Integration and End-to-End Testing.

●Involved in Preparing the Status Reports Every Week, which includes Revision History, test case status, metrics, QA Issues and Defects.

●Interacted with developers on defects status on a daily basis

●Involved in Preparing the Test Strategy Document, Test Cases and Test Cases Execution for all modules

●Porting of Requirements, Test Conditions, execution of scripts, analysis of results and graphs, bugs /issues tracking and management done through Quality Center.

●Creating Automation Scripts (VBScript) in the sprints and stored them in the Test-Plan module of Quality Center.

●Running Automation Test scripts for regression testing

●Prepared automation scripts each build and enhanced for each script execution

●Good interaction with client as weekly base for each script release and status of automation

●Involved in analysis of manual test cases for automate those test cases.

●Involved in automation execution coverage reports.

●Involved in automating test scripts using Hybrid approach.

Smart Button Inc; Newark, DE Apr 2012 – Jun 2013

Automation Tester

Description: Smart Button Inc is a loyalty program software developer company. Loyalty Program project is a SaaS (Software as a Service) application for retail industry which helps to build marketing database and then identify, track, reward, communicate to and develop loyal customers. The clients can create promotions, coupons and rewards to target new customers to enroll in the loyalty program or to retain existing customers. The application provides analytical dashboards to analyze customers’ preferences and transaction data. By knowing preferences and purchase behavior through the dashboards, the clients can further create targeted messaging and offers to increase their business.

Responsibilities:

●Reviewed and identified critical functionalities in loyalty program management SaaS website and Clients’ customer facing portals

●Created and executed test cases manually for social interfaces which are integrated in the customer facing portals.

●Involved in writing SQL queries to test analytical dashboards data and reported the defects found

●Generated test scripts for functional and regression tests using QTP.

●Designed and Generated Reusable Test Scripts using QTP.

●Implemented the launch Script where loads the library functions into QTP

●Incorporated various checkpoints and Regular Expressions in Scripts where ever required using QTP.

●Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and Functionality of the application using Quality Center.

●Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center.

COMSCI; Edison NJ Jun 2008 – Mar 2011

QA Analyst

●Analyzed Business Requirements, Functional Specification, and other required documents for testing and involved in preparing Test Plan and Test Strategy for eMedFusion, GeoMed, InterPhase and Seren Communications.

●Led design of Test Scenarios and Test Plans to ensure that Automated Tests can be implemented and executed against Interphase and Seren Communications Builds & Releases

●Tasked with creating Test Planning, Test Design, Test Execution and Test Evaluation

●Performed various Regression Testing, functionality, navigation, volume testing of the billing module.

●Automated Manual Test Scenarios using HP QuickTest Professional (QTP) to perform Regression Testing

●Performed Functional, Regression and Smoke Tests on the new enhancements as added to AUT

●Migrated existing manual Test Cases in Quality Center (QC) to automated test scripts in QuickTest Professional (QTP) to add to Automation Framework

●Involved in test planning, writing test cases/scripts, reusable test data, test case automation using automation tool HP QuickTest Professional (QTP)

●Scheduled weekly meetings with office staffs, developers and QA team to discuss about quality issues

●Created Data Driven tests for multiple sets of data using HP QuickTest Professional (QTP) and for repetitive tasks.

●Performed Backend Testing using SQL queries to validate the data in the Oracle Database

●Developed documentation & performed User Acceptance Testing and trained the users about the system.

●Executed scripts from Test Lab and Test Cases in Quality Center (QC), verified testing results against expected results

●Communicated and negotiated with development team where appropriate to resolve issues found during testing

●Tracked and logged defects and problem throughout the project life cycle

Contact this candidate