Mob: 097******** email: ac3e37@r.postjobfree.com

Sangavi Rajan

Career Objective:

To gain employment with a company that offers me a consistently positive atmosphere to learn new technologies and implement them for the betterment of the business.

Professional Summary:

Around 4 years of experience in Information Technology with emphasis on Quality Assurance, Data warehousing Testing, Manual testing of Web and Client/Server based commercial applications.

Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

Well versed with Software testing concepts, SDLC, Agile and Waterfall methodologies

Technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.

Involved in writing SQL Queries using Oracle, SQL Server and Teradata in validating data into Data Warehouse/ETL applications.

ETL experience using Informatica (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager), JIRA.

Hands on expertise in Data ware housing concepts and tools.

Experience with software test management tool HP Quality Center/ALM,SPIRA,SQUISH

High proficiency with use of all modules in HP QC or ALM (Application Lifecycle Management).

Experience in testing ETL data from multiple sources into Data warehouse using Informatica.

Proficient in Functionality Testing, Black and White Box Testing, System Integration testing, Regression Testing, User Acceptance Testing (UAT), and Load &Performance Testing.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).

Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT).

Knowledge on BMC ITSM Remedy.

Technical Skills:

Test Management Tools: HPQC ALM 11,12.0

ETL Tools: Informatica Power Center

Bug reporting: JIRA, HPQC ALM 11,12.0

Programing Languages: HTML, XML

Operating System: Windows, Unix

Certification:

Infrastructure Management Services (L3) from TechMahindra (Windows, UNIX)

PROJECT DETAILS:

1)Test Analyst (March 2016-Present)

Client - Aviva Insurance, UK.

Company - WIPRO Technologies.

Description: Aviva is a British multinational insurance company headquartered in London, United Kingdom. It has around 33 million customers across 16 countries. In the UK, Aviva is the largest general insurer and a leading life and pensions provider. In addition, Aviva has a focus on five markets in Europe and, in Asia, the company is focused on the growth markets of China and South East Asia. Aviva is also the second largest general insurer in Canada.

Responsibilities:

Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)

Implemented various Test cases for the Functional Testing, smoke testing, re-testing, Regression Testing, Configuration Testing, Performance Testing, Back-End and User Acceptance testing (UAT).

2) Test Engineer-(Telecom)

Client - Vodafone Hutchison, Australia.

Company - Tech Mahindra Ltd.

Description- Vodafone Australia (VHA) is a mobile telecommunications company that operates the Vodafone brand in Australia. The result of a merger between Vodafone Australia and Hutchison 3G Australia, it created a mobile communications entity of nearly 7 million subscribers, A$4 billion in annual revenue and a 27 per cent market share making it Australia's third largest mobile telecommunications provider behind Telstra and Optus.

Responsibilities:

Understanding Project Requirements.

Involved in Scenario preparation.

Involved in Test case preparation.

Involved in test case execution, SIT, and UAT testing.

Client Call Interaction.

E2E Application Testing.

Detailed Test Plan Preparation.

Test objective Matrix report(TOM)

Test Case sheet

Preparing the Daily summary report (DSR), Test summary report (TSR).

Education:

B.SC Information Technology from Annamalai University.(Distance Education)

Diploma in Electronics & Communication Engineering from PSG Polytechnic College (2010-2013).

10th Standard (SSLC) from PSGR Krishnammal Higher Sec School (2009-2010).

PERSONAL DETAILS:

Father’s Name: Rajan R

Date of Birth: 17 August 1994

Nationality : Indian

Gender : Female

Marital Status: Single

Passport : Available

DECLARATION:

I hereby declare that the details given above are true to the best of my Knowledge.

Sangavi Rajan.

Contact this candidate