Barani Dhanapal

Phone: +1-425-***-****

Email: adbv1n@r.postjobfree.com

Summary

5.6 years of experience in Manual, Mobile and Database testing for software quality assurance

Proficient in HPQC, ALM and Test tracker

Experience in backend data validation using SQL Queries (SQL Server 2008 R2) and generated reports using SQL server reporting services 2008

Certified International software testing qualification board (ISTQB) professional

Experience in STLC and Agile testing life cycle methodologies

Excel in analyzing requirements, creating test plans and executing test cases to detect the software defects, track bugs and validate the functionality of the product by extensive exploratory testing

Capable of learning new technologies quickly and perform good team player.

Technology and Testing Proficiencies

Testing Tools: HP QC(ALM), JIRA, Mobile Rest Service Tool, Test Tracker

And Device Anywhere Tool.

Testing Methodologies: System Testing, Functional Testing, Sanity Testing, Database

Testing, Regression Testing and Mobile Testing.

Databases: SQL Server 2008 and 2012

Requirement Analysis Tool: TFS, Office 365

Certifications: ISTQB

Company Name: Fidelity National Information Services (Dec 2015 to Nov 2017)

Project 1

Project Name : Consumer Driven Healthcare

Type : Database Testing, UI and Mobile

Platform : Window 7

Software : SQL R2 2008 and 2012

Application : SOAP UI, Rest Services and Device Anywhere

Client : Alegeus

Brief description of the project

FIS (Fidelity National Information Services) is an international provider of financial services technology and outsourcing services.

Alegeus client involves in consumer healthcare funding platform.

Providing comprehensives support for all benefit account types in a single platform – including FSAs, HSAs, HRAs, dependent care, commuter and wellness incentive accounts.

Responsible for:

1.Participated in all aspects of testing which includes Smoke, Functional, System, Integration, Regression and Compatibility Testing

2.Involved in the Sprint Planning, User story points allocation, Sprint Retrospective meetings, Sprint Demos, Daily stand up meetings and reporting status to the Scrum Master.

3.Involved in the analysis of the Requirements and discussing the end to end workflow in the practical scenarios with the Requirement Engineer’s and the Development Team

4.Involved in creating the test cases design and execution, test case review, defect logging, tracking the status and retesting the defects

5.Involved in mobile testing by using the mobile testing tools such as Mobile Rest Service and Device Anywhere tool

6.Using SOAP API / Ready API testing the WS request and verifying the same in UI.

7.Executing SQL queries to retrieve test data and validate the successful transactions

8.Involved in raising the defects, defect tracking, requirement mapping using the testing tool HPQC, Test Track and retesting the defects and get the defects closed.

9.Monitoring and Reporting the progress directly to the clients by involving with the clients in the weekly meetings

10.Assisted Clients support during the Beta Phase

11.Update Test closure report and send it to the onsite team

Company Name: iGATE Global Solutions (May 2012 to Dec 2015)

Project 1

Project Name : Universal American

Type : Database Testing

Platform : Window 7

Software : SQL R2 2008

Application : SSRS, SSIS & Fazal

Client : Universal American

Brief description of the project

UAM (Universal American) is an Insurance company in America having its head office in New York. The company offers health insurance, and also deals in Medicare managed care plans, and Medicare prescription drug benefits.

Responsible for:

1.Involved in the database testing and data modeling in reporting application

2.Creating efficient & optimized SQL queries to generate report and Manipulate the database to validate against the business requests

3.Creating New Reports based on the business requests and modifying existing report based on change requests

4.Integration testing with SSRS Report and SSIS Packages output extract.

5.Front end testing on FAZAL application which is used to create the enrollments for the US health care system

6.Performing Regression testing and Functional Testing

7.Identification of different type of bugs and reporting the same using Quality Centre

8.Coordinating with Client, Developers and Business Analyst

9.Received Pat on the Back award for the contribution on 'Reporting' and 'Fazal' application, being instrumental in making deliveries happen in time and without any issues from customer side

10.Leaded knowledge transfer process for new joiners

Project 2

Project Name : Bupa Insurance – Swift Release and Configuration management

Type : Manual Testing

Platform : Window XP and SQL tool 1.5

Software : HP Quality Center 11.00, TOAD, SQL tools

Application : People Soft

Client : Bupa Health Insurance

Brief description of the project

BUPA (British United Provident Association) is a British healthcare organization in the United Kingdom having its head office in central London. BUPA provides private medical insurance and has its own BUPA hospitals.

The primary focus of Batch Team is to process test data in SWIFT and PeopleSoft. Its Batch Team has responsibility to run and monitor batches and also expected to analyze and resolve problems or escalate in order to facilitate a resolution.

Responsible for:

1.Involved in the planning, monitoring, and control of the Batch activities and tasks

2.Performing black box testing and identify bugs and reporting with supporting screenshots and log files

3.Daily Regression Runs, Results Reporting & Defect Management

4.Coordinating with Client, Developers, Business Analyst, configuration team, database team and UAT Support & Test team

5.Restarting PeopleSoft process schedulers and application

6.Creation of job files for processing in PeopleSoft

7.Scheduling and running of PL/SQL batches

8.Escalating issues to concern team based on obtained batch results

9.Writing SQL queries for investigating and resolving batch related issues

10.Monitored the change requests

Academic Qualification

Educational qualification

University/Board

Year

Percentage

Bachelor of engineering in Electronics & Communication

K.S.R College of Engineering

2011

8.2 (CGPA)

Diploma in Electronics and Communication

RMPTC polytechnic college (State board)

2008

85%

SSLC (Secondary school leaving certificate)

Srinivasa Vidyalaya matriculation school (State board)

2005

70%

Personal Detail

Name : Barani Dhanapal

Address : 1125 NE Lilac st,Apt 307,Issaquah, WA-98029

Contact No. : +1-425-***-****

Email Id : adbv1n@r.postjobfree.com

Languages Known : English, Tamil

Contact this candidate