Test Cases Data

Veena Vadlamudi

Email: *********@*****.*** Mobile: 919-***-****

SUMMARY

8+ years of diverse experience in Information technology industry with emphasis on Software Quality Assurance.

Expertise in Automation & Manual Testing for Web Based and Client-Server applications.

Experience in automated testing tools like Selenium Web Driver, Quick Test Professional (QTP) and Selenium Grid.

Designed and implemented various automation frameworks from scratch like Keyword Driven framework, Data Driven framework and Hybrid framework for a number of projects.

Expertise in writing Selenium Web Driver automation scripts in JAVA for Web Based applications

Experience working with Retail, Telecommunications, Banking and Government Tax Systems.

Hands On experience on data validation for Data Ware Housing applications developed in Data Stage, Informatica and BI Reports using Business Objects.

Experience in different SDLC methodologies like Waterfall, Iterative and Agile.

Solid experience of AGILE Methodologies, AGILE Manifesto and Scrum processes.

Tested and executed projects in Multi-Platform Environments like Windows, UNIX and Linux

Proficient in developing SQL Queries for Relational Databases like Oracle, SQL Server and DB2.

Experience in Multi-Browsers testing on IE versions, Mozilla versions, Firefox versions and Chrome versions.

Actively participated in Project Planning, Review and Status meetings.

Demonstrated excellence in writing System Specification documents, creating and developing Test Plans, Test cases and Test scripts.

Experience in all phases of Software Development Life Cycle (SDLC), Testing life cycle (STLC) and Bug life cycle.

Extensively used HP ALM, Quality Centre (Test Director), JIRA for test management and as Bug Tracking System for reporting defects.

Proven Strong Analytical, Logical skills and ability to work on multiple projects

Proficient in developing Shell Scripts, VB Scripts and Java Scripts to validate the application data.

Ability to quickly master in new concepts and applications.

Comfortable working with JAVA, .Net, C, C++, SQL Server, UNIX, Perl, Shell scripting, VB Script, HTML, XML.

Strong functional background, excellent communication and interpersonal skills, good Team player, Self-Starter and worked in onsite-offshore model.

TECHNICAL SKILLS

Automation Testing Tools

Selenium Web Driver, JUNIT, TestNG, Selenium GRID, QTP.

Test Management Tools

HP ALM, Quality Centre, JIRA

Web Based Testing

Browser-Side Test, Page-Layout, Data Validity and Cross-Browser Testing

Database Testing

Transaction Testing, Data Mapping/ Data Conversion, Stress, Volume, Performance, Load Testing and Data & File Validation

SDLC Methodologies

Waterfall, Iterative, Agile

Scripting Languages

Shell Script, VB Script, Java Script

Programing Languages

JAVA, .Net, C, C++, VB JavaScript, SQL

ETL Tools

Data Stage, Informatica

Databases

Oracle 11g/12c, DB2, SQL Server, Tera Data

Operating Systems

UNIX, Linux and Windows.

Web Debugging

XPath, Firebug, Fire path

IDE

Eclipse and Selenium IDE

Version Control Tools

SVN, CVS and Clear Case

Utilities

Microsoft Office Suite

PROFESSIONAL EXPERIENCE

Project: Business Industry Growth System [BIGS] July 2015 to Till Date

Client: Commonwealth Office of Technology, Kentucky state Gov. Frankfort, KY

Role: Senior Automation Tester

Business Industry Growth System [BIGS] application is developed for Cabinet of Economic development [CED]. BIGS application is intended for business users who are willing to start/enhance their business in Kentucky State. In BIGS application we have different actors like Entity/Client, Business Dev Agent, Executive Management, and CED Legal.

CED BIGS work is done in five different phases Inquiry Phase, Identification Phase, Approval Phase, Monitoring Phase, and Close/Inactive Phase. This application has different views (My View, All View, Team View, and Default View) and options based on the user permissions the view and options may change.

Environment: Selenium Web Driver, JUNIT, JIRA, HP ALM, Oracle DB, SQL Server, Maven, MS Office Suite, Case Complete 2014, Share Point.

Responsibilities:

Actively involved in Requirement Analysis, Business Analysis, and Use-Case Analysis.

Achieved customer satisfaction and high quality by effective Automation testing, AGILE Processes.

Implemented automation using Selenium Web Driver, JAVA and Selenium Grid.

Extensively automated regression and functional test suites by developing enormous test cases, test suites using Selenium Web Driver, JAVA, and JUnit.

Created comprehensive Test Strategy, Test Plans, Test Case and Test Scripts and documented them in JIRA.

Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel files and SQL Databases.

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

Wrote SQL queries extensively, queried database and generated test reports.

Tracing the Requirements with the test cases.

Performed Defect Tracking & Management in JIRA. Generated automated daily reports in JIRA.

Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings

Increased productivity by 20% by effectively training, leading and managing the AGILE automation team.

Project: Compliance Data Warehouse June 2013 to Nov 2014

Client: Commonwealth Office of Technology, Kentucky state Gov. Frankfort, KY

Role: Quality Analyst

Compliance Data Warehouse [CDW] application is developed for Kentucky State Department of Revenue [DOR]. This application is used for tax data analysis and processing. CDW consolidates the data coming from multiple sources throughout Department Of Revenue and from outside agencies. Daily tax return records are extracted from Tax Systems (ELF and MEF) and send to SAS for Fraud analysis and Scoring. CDW extracts, transforms the data and load into CDW database. CDW uses this data for further Drop out analysis and internal auditing. CDW helps to analyze Tax Payer’s obligation and estimates tax gap. CDW creates predictive models to improve risk metrics and identify non-compliance.

Environment: BI Tool 4.0, HP ALM, UNIX, Oracle 11g, SQL Server, Windows, Putty, File Zilla Client, Oracle SQL Developer, Data Stage, Info Server, MS Office Suite and Share Point.

Responsibilities:

Developed Test scenarios by using Business Requirement Documents (BRDs), Functional Specification Documents (FSDs) and Design Document Specifications (DDS).

Actively participated in Requirement Analysis, Business Analysis, and Use-Case Analysis.

Created comprehensive Test Strategy, Test Plans, Test Case and Test Scripts and documented them in Quality Center (QC).

Designed the Test Cases and participated in review Inspections.

Executed the test cases and test scenarios using Quality center (QC)

Validated data from BI Tool vs. Oracle database

Executed SQL Queries for the data validation

Communicated with developers and business analyst regarding issues and resolved within the timelines

Developed adhoc reports across different tax systems

Extensively performed Back End, Reports and Regression Testing.

Participated in review meetings and took the initiative to meet the QA testing targets.

Project: Default HPO Sep 2012 to May 2013

Client: Wells Fargo Home Mortgage, San Antonio, TX

Role: Automation Test Analyst

Default Homeownership Preservation Office (Default HPO) works with nonprofit organizations (nonprofits) to assist borrowers when the account is in default, at risk of default (imminent default), or in need of assistance due to a complex servicing issue. Default HPO works accounts across all portfolios (Prime, Nonprime, and Home Equity). HPO (Home Preservation Organization Group) is an application used for training customers who attend an event. System of record for every loan entered during a fair. HPO is used to track how many people are assisted during the event. HPO extracts the Loan Summary data to ensure the customer receives the assistance they need.

Environment: Quality Center, QTP, VB Script, Shell scripting, Windows, Oracle, ASP.NET, C, XML, MS Office Suite, SQL Server.

Responsibilities:

Reviewed Business Requirement Document (BRD), Functional Specification Document (FSD) and Design Document Specifications (DDS).

Actively involved in Requirement Analysis, Business Analysis and Use Case Analysis.

Developed Test Plans, Test Case and Test Scripts and documented them in Quality Center (QC).

Involved in preparation of test data using Excel Sheet for End-to-End Scenario based testing in Web environment

Designed the Test Cases and found what test cases need to be automated

This is an Onsite-Offshore Model, Coordinating the Offshore and Onsite teams and clarifying offshore team queries on the spot.

Working independently with the Customer and work to meet their deadlines.

Executed the test cases and test scenarios using Quality center (QC).

Performed Build Acceptance testing of the application from end-to end for testing different functionality and database mapping issues.

Extensively performed Functional, Integration, User Acceptance and Regression Testing on the web-based application.

Created, maintained and executed regression test scripts for HPO based on the Business requirements.

Used QTP to automate the testing process by recording the scripts and perform testing with various user data by parameterization to reduce the future duplication of efforts.

Inserted Standard, Bitmap, Database checkpoints (DB) for GUI, Functional, Data Driven and Regression testing using Quick Test Pro (QTP).

Created Objects in Object Repository, data-driven tests and synchronization points in Quick Test Pro (QTP) to help solve key problems.

Logged and tracked the defects using Quality Center defect tracking system (Defect Management).

Performed production installation and validation.

Project: Pick up Today (PUT) June 2011 to Aug 2012

Client: WAL-MART Stores, Bentonville, AR

Role: ETL Tester

Pick up Today (PUT) project is a part of multi-channel program. In a challenging market, it is important to offer different shopping options for our customers, both in-store and online. Current shopping options available at Walmart.com are limited to the Site-to-Store program and Home Delivery. This project will add another shopping option for our customers to purchase in-store items online and pick it up at their preferred store at their convenience. Items ordered online will be fulfilled from the store’s inventory enabling a faster order fulfillment process. The business objectives of project are fulfillment of customer promise by providing a fast, easy and convenient method to purchase and pick up store items. Provide the systems required to facilitate the in store order fulfillment, binning, customer pickup and item returns processes. Pick up Today pushes daily sales data to home office data warehouse system.

Environment: Data Stage, UNIX, Quality Centre, SQL Server, DB2, Micro Strategy, Query-man, TOAD, Shell Scripting.

Responsibilities:

Actively participated in Business requirement documents and Functional requirement documents review before preparing test cases and test scenarios.

Involved in Requirement review meetings and analyzed the Business Requirements.

Prepared Test Cases for the mappings developed through the ETL tool Data Stage and executed those Test Cases.

Executed ETL scripts to load data from input files to the target database.

Performed Verification, Validation and Transformations on the Input data before loading into target database like Operational Data Store [ODS]/Data Ware House [DWH].

Analyzed session logs and workflow logs in case of aborted/failed sessions to identify root cause.

Validated all newly created Dimension and Fact tables after the ETL process.

Verification of the layout format per the design mock-up, style sheets, prompts and filters attributes and metrics on the report.

Understand each report & the linkages of every field displayed in the report with the star schema and trace its origin back to the source System.

Written complex SQL queries to validate data with associated business rules.

Developed shell scripts to run batch jobs.

Prepared and executed Test Cases in QC (Quality Center)

Verified and mapped each requirement with the corresponding test case.

Tracked Defects using HPQC and involved in defect triage meetings along with development team.

Generated reports for Requirement coverage, Test coverage and defects.

Involved in collecting QA metrics and provided necessary reports to the management

Project: Web Automated Regression testing system Apr 2009 to Aug 2010

Client: British Telecom, Bangalore, India

Role: Senior Quality Analyst

This project is to manage voice mails, messages, greetings and distribution lists through web. Voice mails are compressed and stored in CA/Sierra server. Motorola’s wire link protocol is used to interact with Sierra server using Operational Command language (OCL) commands. OCL commands are used to read / update / delete various features of mailboxes. A web component is developed to communicate with Sierra server using OCL commands. This functionality enables user to access, save, forward and delete his voice messages and their accounts from anywhere through internet.

Whenever there is change to the OCL commands to meet the customer requirements, integration and regression testing is required to ensure that there is no impact on the existing system.

Environment: UNIX, C, Pro* C, Oracle 9i, SQL, HP Quality Center, QTP, shell scripting.

Responsibilities:

Involved in preparing test plan and test case templates for manual testing.

Participated in Requirement review meetings and analyzed the Business Requirements.

Developed Test cases based on requirements and the use cases provided

Understanding the Project Related Documents.

Creating and Executing Test Cases in HPQC

Participated in grouping the Regression Test Cases into Automatable Test Scenarios based on the business flow of the application.

Used Parameterization for using various data to test the application using QTP.

Developed SQL queries to pull data from DB2 and Informix databases.

Tracing the Requirements with the test cases.

Defect tracking using HPQC and prepared reports for defects.

Integrating the QTP scripts with HP Quality Center and executing the same from Test Lab from Quality Centre

Project: Online Billing Tool May 2007 to Mar 2009

Client: British Telecom, Bangalore, India

Role: Quality Analyst

Billing is an extensive part of the British Telecom Division. The Online Customer Mobile Billing Quality Assurance Team provides operational support ensuring the accuracy of selected bills for mobile customers. Provide functional, regression, and load testing for the assigned application. Testing included new features, upgrades, enhancements and/or production fixes.

Environment: Windows NT, Web Logic, Java, J2EE, JSP, SQL, PL/SQL, eclipse, VB Script, VSS, Quick Test Professional(QTP), Load Runner, Test Director/Quality Center.

Responsibilities:

Attended requirements and design meetings, review and analysis of requirements and design documentation.

Actively participated in creating requirements traceability matrices, and test plans.

Created, developed and executed test cases and test scripts manually and using automation tools.

Created Objects in Object Repository, data-driven tests and synchronization points in Quick Test Pro (QTP) to help solve key problems.

Recorded Load Runner vuser scripts implementing parameterization both manually and by data driven wizards in Virtual User Generator.

Used Load Runner to check the source of performance delay: network or client delays, CPU performance, I/O delays, or issues with database server.

Designed scenarios and used Load Runner Controller to monitor all vusers in a scenario from a single workstation.

Team participation in implementation of patches and other code fixes with Production Support, Change Management and IT Operations.

Supported version management to meet the needs of the business and applications supported using VSS.

Provided support for Unit and UAT testing as required for the application or any other assigned application.

Use Mercury Test Director to house all test documentation and report/track all issues and defects (Defect Management).

Provided clear concise feedback to Development team on recurring errors both on an individual and team basis with aim of long-term reduction of defects found in final release.

Educational Qualification:

Bachelor of Technology in Computer Sciences from Nagarjuna University.

Contact this candidate