Test Cases Engineer

Divya A

Email ID: acy6xw@r.postjobfree.com

Phone: +1-647-***-****

Professional Summary:

Around 3 years of IT Industry experience as QA Engineer

Extensive work experience in all the Phases of Software Test Life Cycle (STLC) and Software Development Life Cycle (SDLC)

Hands on Experience on Bigdata/ETL Testing

Depth knowledge in data validation of data loading interfaces using Informatica Power center, Teradata BTEQ, TPT, fexp, Loader scripts, Oracle and Unix Shell Scripts.

Hands-on experience in using test management and defect tracking tools such as Jira, HP Quality Center and Confluence.

Good experience in Waterfall Model, Agile Modeling and Agile Scrum SDLC Methodologies

Functional, Regression, Re-Testing, Integration Testing, System Testing, Regression Testing, and Exploratory testing on different environments.

Extensive experience in Designing and Developing the Test plan, Test Scenario and Test case documents

Good Experience in Developing, Enhancing and Maintaining the Test Scripts using Selenium

Extensive experience in implementing Traceability Matrix using various modules available in HP Quality Center

Excellent knowledge in Back End testing using complex SQL queries.

Expert in working in Data Migration projects which involves Data Analysis, Data Mapping and Data Validations.

Rich work experience in writing Sql queries using DML, DDL, DCL for validating the data in the database

Extensive work experience in Analyzing and Breaking the requirements in to Test scenarios and Test Cases.

Good Knowledge in UNIX shell Scripting.

Education:

Bachelor of Technology, JNTU-Anantapur.

Work Authorization: Open Work Permit (Valid upto Apr-2018 – Can be extended)

Technical Skills:

Operating Systems

Windows, Unix, Mac OS

Languages

Java, SQL, Unix Shell scripting, Python

Databases

Teradata, SQL Server, Oracle 11g, Hive, HBase

Tools & Utilities

Teradata SQL Assistant, Informatica 8.6, Cognos BI, Hadoop, HIVE QL, XMLSpy

Test Management Tools

JIRA, Confluence, CQTM, RADAR, Espresso, HPQC

SD Methodologies

Agile, Scrum, Waterfall, Spiral

Project Name: GBI Hadoop QA

Client: Apple

Role: Bigdata Test Automation Engineer

Duration: JULY-2016 – Nov 2016

Environment: MacOS, Confluence, JIRA, RADAR, Teradata, Hadoop, Hive, Unix Shell Scripting, Agile

Apple is migrating its iTunes data from Teradata to Hadoop Environment Hive data base.

As a Bigdata Test Automation Engineer, I am responsible for test automation of data validation between Teradata and Hive. For Data validation, I have used unix shell scripting and bteq commands.

Contribution:

Develop test suites for Hadoop, Map/Reduce, Hive.

Develop test system that inform on key metrics, and detect anomalies

Analyze and improve efficiency, scalability, and stability of data collection, extraction, and storage processes.

Writing test plans and test cases in collaboration with Product and Developer team members.

Review story documentation to identify testing approaches and create testing tasks with estimates.

Collaborate with developers to identify effective test plans/approach.

Document bugs and verify bug fixes.

Project Name: Banking Mobile Application

Client: ICICI Bank

Role: Jr. QTP Engineer / Mobile Tester

Duration: FEB-2016 – JUNE 2016

Environment: : HP QuickTest Pro 11, Perfecto Mobile, Tortuse SVN 1.7, Mingle, SQL, VBScript, SQL Server Management Studio 10, Android and iOS smart phones and tablets, Agile, Python

ICICI Bank is a decoupling project in which the data related to the banking & investment products is decoupled from flat files to the MVS files this is done by using the ETL Abinitio and the target system is IBM Mainframes.

As a Test Automation Engineer, I am responsible for test automation of company's app on Android and iOS. For mobile testing, I utilized multiple mobile devices such as multiple versions of Android and iOS (iPhone3, iPhone4, iPhone4s), iPad, iPad2 and Android tablets.

Contribution:

Responsible for entire test automation process utilizing QTP (QuickTest Pro) and Perfecto Mobile for mobile apps.

Develop automation framework for testing app on Android and iOS devices.

Took a leading role in creation and maintenance of reusable functional libraries on VB Script using HP QTP and Perfecto Mobile.

Used Dynamic Descriptive Programming approach to benefit from Object Identification without using OR

Maintained QTP object repository (OR) along with clouds repository with mobile objects.

Take a leading role in creation and execution of test cases, status and retrospective meetings with members of Project management team as well as Development and Deployment team.

Took a leading role in mobile testing using Perfecto Mobile for testing client's mobile apps on the Android and iOS platforms.

Develop scripts compatible with both Android and iOS devices.

Identified, analyze, and document defects utilizing Mingle as a defect tracking system

Involved in defect reporting, defect tracking and defect reproducing.

Project Name: Insurance Policy Management System

Client: LIC, Bangalore, INDIA

Role: Software Tester

Duration: OCT 2015– JAN 2016

Environment: IBM VC++, VB.NET, MS Excel, SQL SERVER XML, LoadRunner, UFT, Quality Center

Insurance Policy management application used by the LIC wealth Management for issuing Auto and Home Line of Business Policies. Insurance Policy Management system will be used by underwriters of Insurance wealth Management to create setup and bind policies of the customers after successful adjudication of the policies.

Contribution:

Analyzed the Business, Functional Requirements and stream lined the Testing Activities

Involved in developing the Test Plans and Detailed Test cases based on the Use case, Business Requirements and functional specifications documents.

Involved in all the phases of STLC for the assigned components.

Involved in Creating and executing the Virtual User Scripts and Test scenarios using the Load runner

Involved in performing stress, load performance testing using Load Runner

Performed Functional, System, GUI, End to End, System, Installation, Compatibility, Sanity, Retesting and Security testing

Customized the scripts according to the requirements by inserting checkpoints, parameterized the script, conditional statements and loops using QTP.

Involved in Integration, System, End & User Acceptance Testing executions and regression test cycles.

Analyzed the results, tracked the defects and generated reports using HP Quality Center

Performed Regression test to ensure product integrity after modifications and enhancements.

Executed the queries in the test databases using SQL Queries

Worked with Technical staff to validate test requirements, resolve design issues and software defects

Involved in creating the UAT Test Plan and subset of the Functional Test cases for UAT Test

Project Name: Customer Order Management

Client: Hotel International, Kurnool, INDIA

Role: QA Analyst

Duration: FEB 2014 – SEP 2015

Environment: C++, Java, SQL server 2005, Quality Center, QTP, Windows, MS Office.

This is a call center and web application tool used to place an order for various products at different service points with various options. The customer profiles will be maintained with customer account, Service Accounts and billing accounts for order processing and Billing of the products. Hotel International provides Bundle packages for local, long distance and broadband connection applications, which are interlinked with each other. The integration among the modules of application to process customer management, order processing and billing were done interactively using client server GUI application and Web Application

Contribution:

Analyzed the Business Requirements and created Test Plan, Test Cases and Test Scenarios.

Created various meaningful Test cases which covers local and national plan coverage, converting from complex business logic which includes many rules and sub rules

Tested the accuracy of the T-Mobile services in order processing and billing by creating and running functional (positive and Negative Test Cases

Involved in all the phases of STLC for the assigned components.

Developed and executed the Test Cases for BAT, Module, Integration, system, and UAT Testing.

Actively participated in Requirements gathering and Test Plan Review meetings.

Involved in security testing, Data Base testing, Compatibility testing and Middle ware testing

Taken Part in testing different types of orders like change of orders, order submission, Cancellation of orders in different service Points with different status.

Involved in enhancing the test scripts by inserting Check points, capturing the output Values, Recovery Scenarios using QTP

Involved in Regression testing after each modification and enhancements.

Tracked bugs and reported them using HP Quality center

Reviewed and analyzed the executed Test results with Business analysts for coverage analysis.

Corresponded among QA Managers, developers and Team members

Involved in validating the back end data using SQL queries.

Contact this candidate