Automation testing ETL testing

Mobile : 773-***-****

Keerthi Manne E-Mail : ************@*****.***

PROFESSIONAL SYNOPSIS

6+ years of Experience in Software Testing on GUI, Web based applications using Manual and Automation Procedures in Insurance, Finance and Health Care Domain.

Excellent understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Bug life Cycle and Methods like Waterfall and Agile.

Experienced in SQA (Software Quality Assurance) including Manual and Automated testing with tools such as Selenium RC/WebDriver/IDE/Grid using test scripts Java and Test Frameworks using Junit/TestNG, ANT/MAVEN/JENKINS build tools.

Good knowledge in various testing frameworks like data driver,keyword driven and POM frameworks.

Have Hands on experience in ETL Testing on Data Warehousing projects using Informatica and Talend tools.

Experienced on writing SQL queries to extract data from various source tables to perform database testing. Experienced understanding the logic,transfermations rules applied on tables like Oracle, SQL databases

Experienced in Web Services testing using SOAP UI.

Experienced on Reporting tool on BI reports using Qlick view tool.

Excellent skill in finding bugs and over defect management using HP Quality Center, Bugzilla,Jira and Squids.

Experienced in Web content Accessibility, Usability testing using wave and jaws tools.

Experienced in testing the application based on State Portal Fundamentals and W3C standards.

Experience in writing Test Plans, defining Test Scenarios and Test Cases, developing and maintaining test scripts, analysing bugs, interacting with development team and track the bugs till closure.

Experience in Business Functionality Testing, Smoke testing, User Interface testing, Integration Testing, Black Box Testing, End-to-end Testing, Manual Testing, UAT testing, Regression Testing, Performance Testing, Documentation and Reporting.

Possess excellent communications and interpersonal skills with the ability to adapt to any type ofenvironment.

KNOWLEDGE PREVIEW

Testing Tools : Selenium IDE/RC/WebDriver,TestNG,maven,Jenkins,Junit,SoapUI, Informatica,Talend, Qlickview,jaws

Programming Languages : JAVA,PEGA

Databases : SQL Server 2005, Oracle, Netezza,TOAD

Defect Tracking Tools : QC,Jira, Bugzilla,Squids

Operating Systems : Windows 98, Win2000 Prof, XP

Web Technologies : HTML, CSS,soap

Office Tools : MS Word, MS Excel, MS PowerPoint

EXPERIENCE SUMMERY

Worked as Senior Associate in Star Health and Allied Insurance Pvt Ltd .

Worked as Assistant system Engineer in Tata Consultancy Services as outsourcing from APOnline.

Worked as Engineer-QA in Virtusa Consulting Services.

Worked as IT Analyst in Tata Consultancy Services .

KEY RESPONSIBILITIES

Testing of various Modules based on the client requirements.

Experience of working in pressured environment to strict deadlines.

Identifying and monitoring interdependencies between various application implementation activities.

Ability to learn new software quickly.

Having good interaction with the Clients in the Review meetings.

High-quality support on functional issues at Client Place.

Able to test multiple projects at the same time.

PROJECT DETAILS

Project 1

Project Title : Home Serve

Client : Home Serve

Role : QA Automation Engineer

Tools : Selenium webdriver,TestNG,Quality Center, SoapUI, Talend(ETL), Qlickview

Duration : Apr 2016 to Jan 2017

Software Skills : Pega, Oracle

Location : Hyderabad

HomeServe had initiated Unity Programmed with an objective of replacing the Ensura legacy system that Offers Sales, Servicing, Marketing and Billing Capabilities. It provides home emergency and services to the customers in original plumbing and drainage cover to include electrics, gas and oil central heating, external water supply pipe, internal gas supply pipe, appliance repairs, pest infestations, locksmith service and glazing repairs etc.

Responsibilities:

Responsible for UI, Functional, Web Services, cross browser, Automation, ETL, Reporting.

Developed test cases based on functional specification and design documents .

PerformedEUT, Smoke,Functional, System Integration, Regression and UAT Testing.

Created Test strategy and plan, create test data and organize test plans and test runs for automation.

Identified test cases to automate, prioritized suitable candidates for automation and automated test cases using Selenium WebDriver, TestNG and Java

Implemented Page Object Model Automation framework with Java, Selenium WebDriver.

Configured Selenium WebDriver, TestNG, Maven tool and created selenium automation scripts in Java.

Integrated with Continuous Integration tools Jenkins for running test on regular basis automatically.

Tested request and response XML's based web services interfaces using SOAP UI.

Performed Web Services Testing and XML validation by creating test case suite using SOAP UI.

Tested the data is transformed correctly according to various business requirements and rules.

Verified the data transformation from source to destination and expected data is added in target system

Verifiedthe all DB fields and field data is loaded without any truncation

Verifiedthe for rejected data proper error logs are generated with all details

Verified the duplicate data is not loaded and data integrity

Worked on the Business Intelligence reports using Qlick view.

Manage the testing process, schedule batch tests, log and track defects using Quality Center.

Project 2

Title : Provider attribution and scalability

Client : Humana

Role : QA Engineer

Tools : Informatica,Squids

Duration : June 2015 to Feb 2016

Software Skills : Oracle and Netezza

Location : Hyderabad

Humana Inc. to move the current attribution model from the EDW platform to Netezza platform for optimization and scalability in the future and also to build a process for any tables need to be implemented and output of various attribution models.

Existing scripts in EDW which run the current models in EDW needs to be converted to Netezza which includes historical data and needs to be available in Netezza.

Responsibilities:

Gathering and analyzing the business requirements from client.

Created Test strategy and plan, create test data and organize test plans and test runs

Designed test cases based on functional specification and design documents

Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.

Tested data is transformed correctly according to various business requirements and rules.

Verified the data migrated from EDW to netezza based on the transfermations rules and expected data is added in target system

Verified count, structure, duplicates, Aggrigation functions on source and target table to check the data integrity.

Verified the rejected data proper error logs are generated with all details.

Logged the defects using Bug reportings tool Squids .

Project 3

Project Title : Differentiated Clinical Model (DCM)

Client : Humana

Role : QA Engineer

Tools : Migration driver,Squids

Duration : Dec 2014 to May 2015

Software Skills : Oracle,SQL and Netezza

Location : Hyderabad

DCM is the process of extracting demo-graphical information about Humana members and prospects into the analytical environment. The data is pulled from the Humana Enterprise Data Warehouse systems EDW and non EDW tables and is loaded into Netezza for extracting scores using predictive models.

Responsibilities:

Gathering and analyzing the business requirements from client.

Designed test cases based on functional specification and design documents

Tested data is transformed correctly according to various business requirements and rules.

Verified the data migrated from EDW to netezza through migration driver framework based on the transfermations rules and expected data is added in target system

Verified the data is being loaded into specific target with timestamp

Verified count, structure, duplicates, Aggrigation functions on source and target to check the data integrity .

Verified the rejected data is logged into error logs tables with all details.

Logged the defects using Bug reportings tool Squids .

Project 4

Project Title : Chief Minister Relief Fund

Client : Government of Andhra Pradesh

Role : QA Engineer

Tools : Selenium, Bugzilla

Duration : April 2014 to Dec 2014

Software Skills : Java, PLSQL

Location : Hyderabad

Chief Minister’s Office (CMO) is implementing Chief Minister Relief fund (CMRF) Entry form which will be used for entering the beneficiary details to avail financial support for the following reasons:

Health problem which require expensive Medicare

Loss of life of kin and kith

Loss of properties and sources of livelihood due to unforeseen incidents such as natural calamities, road accidents, fire accidents etc.

Responsibilities:

Analysed the Business Requirements Document, put input in Test Plan and prepared detailed Test Cases for new functionality.

Associated with development team to understand technical design and architecture for test planning.

Designed and developed Page Objects using Page Object Design Pattern and Selenium WebDriver.

Developed Selenium Automation framework - Created a hybrid framework (Keyword and Data driven) on Selenium using TestNG.

Used Page Object Model, UI Mapping, Selenium Manager, Data Driven using CSV, CSS Selectors as a part of Framework.

Created and enhanced numerous test scripts to handle changes in the objects, in the tested application's GUI and in the testing environment using Selenium WebDriver, TestNG and Jenkins.

Designing and execution of Test cases using Quality center.

Defects Reporting and Analysis using Quality center.

Perform Functional, System, Integration, Regression and UAT Testing.

Project 5

Project Title : State Service Delivery Gateway (SSDG)

Client : Govt. of Madhya Pradesh, Govt. of Chhattisgarh, Govt. of Andaman and Nicobar and Kerala.

Role : QA Engineer

Tools : Bugzilla, Selenium, JAWS

Duration : Jan 2012 to March 2014

Software Skills : Liferay, Java, Oracle 10g.

Location : Hyderabad

SSDG is a single point of access to the citizens, for either information or transactional purposes. One of the goals of the Government is to cooperate, collaborate and integrate information across different departments in the Centre, States and Local Government. It is served through this portal.

E-forms: citizens can apply for several services across the administrative departments through electronic form applications in both online and offline.

Portal: various information services such as about the state, departments, various Government schemes, Recruitment, the latest travel schedules of ships, trains and buses, updates the citizens about latest announcements from the respective state etc.

Responsibilities:

Understanding the Business Requirement Specifications.

Designing, Execution of test cases and reporting bugs using Quality center.

Done Accessibility testing as per WCAG,W3C and SPF standards

Perform Functional, System, Integration, Regression and UAT Testing.

Regression test cases were written and automated using Selenium Web Driver.

Prepared and executed text scripts using selenium webdriver for E-forms Services .

Prepared Traceability Matrix to ensure the adequate coverage of the test cases.

Tested applications in different types of browsers and versions, such as Internet Explorer, Firefox, Google Chrome to simulate production environment.

Project 6

Project Title : E-office

Client : Star Health and allied Insurance pvt Ltd

Role : Manual Tester

Duration : April 2010 to May 2011

Software Skills: Java, Oracle 10g.

Location : Hyderabad

E-Office is software developed to automate the functions of any organization with definite work flow defined for various activities. E-Office provides you a one-stop shop for managing office work flow automation. E-Office is designed to address the following activities involved in any office.

Manage file/request work flows with File Management System.

Knowledge Management System.

Recruitment, KPI, AMS

Manage employee related activities.

Modules:

HRMS (Human resource Management System)

This module deals with the automation of all the HR process consists of

1.RRF(Resource Requisition Form)

2.Recruitment Process

3.Payroll process

4.Exit formalities

AMS (Asset Management module)

This module deals with automation of maintenance of assets in the organization consists of the following phases.

1.Asset Request Initiation

2.Asset Allotment

3.Procurement

4.Bidding Process

5.Asset Maintenance

6.Payment Initiation

Responsibilities:

Involved in the Requirement Analysis.

Understanding the Business Requirement Specifications.

Involved in identifying Test Scenario's.

Designing, Execution of test cases and reporting bugs.

Perform smoke,Functional, System, Integration, Regression and UAT Testing.

Involved in manual testing of applications on web environment.

Developed SQL Scripts for Backend Testing to ensure that the data is updated as per the Business Rules.

Generated detailed reports of the bugs, pass-fail reports and the test results in Bugzilla.

Training the new members in the team and getting them productive quickly.

Project 7

Project Title : Aarogyasri Health Insurance Scheme

Client : Star Health and allied Insurance pvt Ltd

Role : Manual Tester

Duration : Jan 2010 to Mar 2010

Software Skills : Java, Oracle 10g.

Location : Hyderabad

Description:

This Project is field of Health Insurance, Tailor made to the health needs of poor patients and providing end-to-end cashless services for identified diseases through a network of service providers from Government and private sector.

Grievance and Feedback Module:

Any concern, problem or complaint of beneficiaries with regard to Aarogyasri Scheme reported to and registered by Grievance department through the different sources.

Responsibilities:

Involved in the Requirement Analysis.

Involved in writing and executing the Test cases.

Generated detailed reports of the bugs, pass-fail reports and the test results in Bugzilla.

Co-ordinating with the development team for defect analysis.

Performed Smoke Testing, functional, Regression and UAT testing.

Participated in weekly walkthrough and inspection meetings, to know the status of the testing effort and the project as a whole

ACADEMIC CREDENTIALS

2008 B.Tech (CSIT) 68.3% Anurag Engineering college [JNTU]

2004 Intermediate (M.P.C) 78.3% Adarsa junior college, Repalle

2002 S.S.C 79.9% CRH school, Repalle

PERSONAL DETAILS

Name : M. Keerthi

Date of Birth : 16-9-1985.

Keerthimanne

Contact this candidate