PARASAKTHI G

Email: acunuj@r.postjobfree.com Mobile: +91-973*******

PROFESSIONAL SYNOPSIS

5.5 years of Experience in Software testing which includes ETL/DWH Testing and Web application testing

4 years of Experience on ETL/DWH testing

Expertise as a data warehousing specialist using ETL tools and technologies like ETL/DWH Testing, Informatica Power Center Tools, Oracle database and SQL.

Expertise in testing Facts and Dimensions Based on mapping logic

Strong Exposure to Data Warehousing concepts like star schema & Snow-flake schema

Hands on experience in writing database Queries

Strong abilities in Software Testing including execution of Functional / System / Regression Tests

Experience on Agile Methodology

Scrum Master Certified.

ISTQB Certified.

TECHNICAL SKILLS

Testing : ETL/DWH testing & Manual testing.

ETL Tools : Informatica Power Center 8.6

Databases : Oracle 10g

Languages : SQL

Test Management Tool : Quality Center, JIRA, Rally

Operating Systems : Windows, Unix

EXPERIENCE

Working as Senior Quality Engineer with Tavant Technolgies pvt Ltd, Bangalore from November 2010 to till date.

EDUCATIONAL QUALIFICATION

B.Tech (IT) from Anjalai Ammal Mahalingam Engineering College, ANNA University, Thanjavur.

Percentage : 75%

PROJECT SUMMARY

Project : Trelleborg Sealing Solutions

Client : Trelleborg

Environment : Informatica 8.6, Oracle 10g, Windows, JIRA, Rally, SAP Object Model

Role : Senior Quality Engineer

Project Brief:

Trelleborg Sealing Solutions (TSS) is a leading global supplier of sealing solutions. This project is to create Data Warehouse which has all the information and generate reports using Reporting services. The aim of Warehouse is to analyze the Customer, Sales, Finance data etc. The data gets refreshed and maintained historically. This Enterprise Data Warehouse plays a major role in enabling the higher management to take proper decision in each level with proper data as well as build various types of reports which will help them to improve their sales revenue.

Responsibilities:-

Involved in functional study of the application

Running the Jobs/Workflow for ETL process

Prepared and Executed SQL queries

Designed & Executed test cases

Verified data in target database according to business rules

Verified the column mapping between source & target databases

Prepared the Test Data

Raise & follow-up issues in JIRA

Interactions with BA & Dev teams to resolve the issues.

Identified test cases for Regression testing

Daily Status Reporting

Project : NMI – AXIS

Client : National Mortgage Insurance

Environment : Informatica 8.6, Oracle 10g, Windows, JIRA, Rally

Role : Senior Quality Engineer

Project Brief:

National MI AXIS (Advanced Exchange and Information System) provides an interactive platform that is unmatched in the MI marketplace – from ordering, through underwriting, servicing and claims. We offer single sign-on and an easier online application to order mortgage insurance. This project was to create Lender Data Warehouse and generate reports using Reporting services. The aim of Lender data Warehouse is to analyse the Lender’s list in Quarterly wise, Half-yearly wise. The data gets refreshed yearly and is maintained historically.

Responsibilities:-

Involved in functional study of the application

Running the Jobs/Workflow for ETL process

Prepared and Executed SQL queries

Designed & Executed test cases

Verified data in target database according to business rules

Verified the column mapping between source & target databases

Prepared the Test Data

Posted and Tracked the issues in JIRA

Interactions with BA & Dev teams to resolve the issues.

Daily Status Reporting

Project : TraneMAP

Client : Trane

Environment : Soap UI, QC, Windows

Role : Senior Quality Engineer

Project Brief:

Trane is a world leader in air conditioning systems, services and solutions. They offer a broad range of energy-efficient heating, ventilation and air conditioning (HVAC) systems; dehumidifying and air cleaning products; service and parts support; advanced building controls and financing solutions. Trane systems and services have leading positions in premium commercial, residential, institutional and industrial markets.

Responsibilities:-

Requirement Analysis

Test Scenarios Preparation

Test case Preparation

Test Data Preparation

Test case Review

Test Case Execution

Performed Smoke/Functional/System Tests

Reporting and Tracking bugs in QC

Prepared Test Summary Reports

Interaction with BA and DEV Teams to resolve the issues

Daily Status Reporting

Project : ACT Profile

Client : ACT

Environment : JIRA, Rally, Windows

Role : Quality Engineer

Project Brief:

ACT Profile is part of ACT Group. ACT Profile is a social network for students. It is the first social college career planning platform built on more than 30 years of ACT research. Students can use this information to better understand the connections between their unique interests, abilities, and values and potential education and career paths.

Responsibilities:-

Requirement Analysis

Test Scenarios Preparation

Test case Preparation

Test Data Preparation

Test case Review

Test Case Execution

Performed Smoke/Functional/System Tests

Reporting and Tracking bugs in QC

Prepared Test Summary Reports

Interaction with BA and DEV Teams to resolve the issues

Daily Status Reporting

Project : SpringCM

Environment : QC, Windows

Role : Quality Engineer

Project Brief:

Companies of all sizes are inhibited by the cost and complexity of managing their documents and related processes. SpringCM’s purpose is to enable all organizations to achieve business success by unlocking the value of their content while renaming free from the constraints of traditional in-house technology. We do this by providing enterprise-class content management as a subscription-based service delivered via the Internet.

Responsibilities:-

Requirement Analysis

Test Scenarios Preparation

Test case Preparation

Test Data Preparation

Test case Review

Test Case Execution

Performed Smoke/Functional/System Tests

Reporting and Tracking bugs in QC

Prepared Test Summary Reports

Interaction with BA and DEV Teams to resolve the issues

Daily Status Reporting

PERSONAL PROFILE

Awards/Achievements : Got Spot Award in Tavant Technologies

Languages known : English, Tamil

Date of Birth : 04/06/87

Nationality : Indian

Address : #223, B Block,

Mahaveer Rhyolite Apartment,

BTM 4th Stage, Nyanapanahalli,

Bangalore-76

DECLARATION

I consider myself familiar with Information Technology Aspects. I am also confident of my ability to work in a team. I hereby declare that the information furnished above is true to the best of my knowledge.

Date: Yours faithfully,

Place:

(PARASAKTHI.G)

Contact this candidate