Vyshnavi K.

Cell : 470-***-****

Email: ac1y8f@r.postjobfree.com

Summary

4+ years of experience with Functional testing, performance testing, ETL testing, SQL programming.

Experience in the areas of test requirements gathering, test planning, test scenario preparation, test case preparation, test data setup, test case execution and results reporting.

Expertise in writing large/complex queries using SQL.

Gained good exposure to plan and execute the phases of Software Development Life Cycle (SDLC) including Requirement Analysis, Design, Development, Testing and Maintenance.

Working experience in AGILE project development Environment.

Good Knowledge on Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data from different source systems including flat files.

Experience in Database activities like Data Modelling and Design, Data conformance.

Received consistent client appreciations for improving performance, delivering quality work before schedule for several interfaces and work requests.

Skill Matrix

Programming Languages : C, C ++, Java script, SQL

Database : SQL Server, Oracle, Teradata, MS Access

Testing and Defect Tracking Tools : SoapUI, HP Quality Center(QC), SalesForce, JIRA, Selenium

ETL Tools : Informatica, Data Stage director

Operating System : Windows, UNIX

Others : F-load, M-load, XML, HTML.

Professional Experience

ETL Tester Feb 2014 – Jan 2017

Liberty Mutual

Worked as a Lead ETL tester for Liberty Mutual (Insurance) guiding a team of three on ETL testing. The objective of the project is to ensure data integrity of millions of records, where I as a lead tester used to work with Business Analysts to acquire test business requirements and functional requirements which satisfy the business objectives.

Key Responsibilities in the project:

Analysed the requirement documents, passed them on to the team and reviewed test plan, test design and test scenarios.

Performed Integration, End-to-End, system testing.

Performed data validation testing writing complex SQL queries to verify data from Source to Target with MS Sql.

Used Quality Center for creating Test Plans and Test Cases and register the expected results.

Experienced working in Agile environment and made deliverables to meet iteration to iteration.

Experience in working with Software Development team in resolving defects and presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.

Worked as the single point of contact and responsible to report status and risks to senior management.

Environment: MS Sql server, Informatica, MS-Excel, WinScp, Putty UNIX.

QA Tester Nov 2013 –Jan 2014

Accenture

Client: MedAssets

MedAssets has a number of hospitals and health care providers as their clients. They provide end to end financial services from patient to payment. They have multiple projects for integrating data from hospitals to their database and back to hospitals. They also have internal projects for their internal portals.

Key Responsibilities in the project:

Worked with developers to understand the integration projects developed using TIBCO software.

Created test plans for testing various webservices with multiple operations.

Worked with WSDL files for webservices and modified the endpoint to point it to different test Environment.

Created projects on SOAPUI for webservice testing by importing the WSDL file.

Created different test cases under SOAP UI projects for various input data.

Captured the webservice responses from SOAP UI result and attached to the test case.

Created test cases using Selenium Webdriver methods

Involved in regression testing using selenium and executed selenium test cases and reported defects

Tested User Interface pages created using .net.

Verified various button actions on the UI pages, column sorting and search box functionality.

Performed functionality testing on integration projects by supplying input files and verifying the data on database using SQL scripts.

Performed data validation testing writing complex SQL queries to verify data from Source to Target.

Used JIRA for reserving, executing test cases, defect tracking, and the complete test management

Environment: SOAP UI, Selenium, Informatica, MS-Excel, JIRA, WinScp, UNIX.

ETL Tester Jun 2012- Nov 2013

Accenture

Client: BlueCross BlueShield.

Worked as an ETL tester in Data Conformance team on Healthcare domain. It deals with the development and testing of core data warehouse of IBC-insurance Company. ETL testing is part of the project where the system, integration and regression testing is performed using the SQL. Quality centre tool is used for capturing the test results and also generate reports regarding the testing status.

Key Responsibilities in the project:

Thorough understanding of SDLC processes and the QA lifecycle and methodology.

Requirement analysis - Analyse the business requirements and the process involved in it.

Preparing the Test Scenarios and Test cases - Write the Test cases and modify the same based on the review comments from the Peers/Lead

Test case execution - Which includes test data setup, data validation, verification etc.

Developing complex SQL queries on Teradata- To validate the tables based on the FRD(Functional requirement Document) and Mapping document

Performed Negative testing and Out- of- box scenario testing - based on BRD (Business requirement document ) and FRD( functional requirement document)

Reporting Data mismatch - Which includes test data setup, data validation, verification etc.

Tracking, analysing, review and logging of defects using QC.

Defect reporting and following it up to closure.

Daily Status reporting – Send daily status report mails on the completion of work in terms of the number of test cases executed to onsite POC’s.

Analysed test results and traced performance bottlenecks

Regularly interacting with the development team and client - To solve the execution issues and get the clarifications for efficient and smoother execution and to adhere to client Deadlines.

Environment: Teradata, SQL assistant, Putty, WinScP, Fast Load, Multi Load, BTEQ, Data stage director, MS-Excel, UNIX, Shell Scripting, HP Quality Center.

Education

Bachelor of Technology in Electronics & Communication Engineering at GNITS, India.

Contact this candidate