JAI SURYA S

KNOW LED G E S U M M ARY:

Email: adwk53@r.postjobfree.com

Mobile: +91-944*******

Having 3 +years of Experience in Software testing which includes ETL Testing, DWHTesting, and DB Testing.

Good knowledge on Data warehouse concepts and Transformation logics.

Good understanding of Software Development Life Cycle (SDLC), Defect Life Cycle and Software Testing Life Cycle (STLC).

Responsible for Requirement analysis, Test cases creation, Test case execution, Defect Logging, defect analysis, and status report generation.

Good Knowledge of Database Systems – Oracle 18c and Data warehouse concepts.

Defect tracking With Dev team.

Source to Target loading and validating the same.

Involved in SIT End to End testing.

Ability to analyze root cause of a problem and demonstrate good sense when handing the Execution

Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

Good Knowledge on Data Warehousing concepts like Star Schema, Dimensions and Fact tables.

Experience in different types of testing like System Testing and Regression Testing. E X P E R I EN C E:

Working with Genpact, from July 2019 as QA Engineer. E D U C A T I ON :

M.E (Power Electronics and Drives) Government College of Engineering, Salam (Anna University) 2018, with 86.6%.

B.E (EEE) K S Rangasamy College of Technology, Tiruchengode, (Anna University) 2016, with 66.5%

Diploma (EEE) Kavery Polytechnic College, Mecheri, (State Board) 2013, with 76.12%

SSLC, South Indian Matriculation School, Omalur, (Matric) 2010, with 58.9% T E CH N I C AL S K I L L S :

ETL Tools : Informatica

Test Management Tools : JIRA, HPALM.

Technology : ETL Testing, DB Testing, Data warehouse testing, Operating Systems : Windows and Basics of UNIX.

RDBMS : Oracle

PROJECT EXPERIENCE – DETAIL:

PROJECT 1:

Title : Consumer Analytics - Fox

Client : Fox, USA

Role : ETL Tester

PROJECT SUMMARY:

The Fox Broadcasting Company is an American free-to-air television network that is a flagship property of the Fox Corporation.

RESPONSIBILITIES:

Worked on both Migration Testing as well as ETL Testing

Gathering requirement documents from Business team like Technical document and Mapping document.

Analyzing requirements and get clarification if need any from Business team.

Prepare Test scenarios and Test cases and Test scripts.

Executing Test cases by running Test scripts in DWH.

Checking with Dev Team If any observations found during execution.

Logging and tracking the defect in JIRA if any defect found while execution.

Participation in Scrum call and Retrospective

PROJECT 2:

Title : PHI Vault

Client : Novartis

Role : ETL Tester

PROJECT SUMMARY:

PHI Vault is a Protected Health information system. In this we maintain the patient journey of particular health divisions. Each patient journey is used to determine and improve the innovation techniques of a medicine. RESPONSIBILITIES:

Receiving and analyzing requirements documents.

Preparation of Test cases with SQL Queries

Designing the Test scenarios and Test cases.

Preparation of Test Data based on the requirement

Validating the data files from source to make sure correct data has been captured to be loaded to target tables

Created and executed SQL queries to perform source to target testing on oracle database.

Performed validations like File validation, count and data validations, QC Checks on Land table, QC validations etc.

Identification of Defects and notified to Dev Team. PROJECT 3:

Title : Network rail ADS

Client : British Railways

Role : ETL Tester

PROJECT SUMMARY:

The main goal of the project is all about storing the complete infrastructure of the railways in the data warehouse to perform the statistics to improve the infrastructure and the quality of the railways. RESPONSIBILITIES:

Identified test scenarios and designed test cases.

Executed the test cases and tracked the defects.

Involved in defect reporting and tracking

Validating the data files from source to make sure correct data has been captured to be loaded to target tables

Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.

Designing the Test scenarios and Test cases.

Created and executed SQL queries to perform source to target testing on oracle database. PERSONAL DETAILS:

Date of Birth : 12-06-1995

Languages : Tamil, English

Marital Status : Single

Father Name : Sundararajan

Jaisurya S

Contact this candidate