Premalatha Mahendran, Test Engineer

Email: adzmdw@r.postjobfree.com

Mobile: +91-893*******

Professional Summary

Test Engineer with 8 years of strong technical skills in ETL Testing with successful execution of projects.

A result-oriented professional with 7 Years of experience in IT industry, currently working for Cognizant Technology solutions as a Associate since Jan-2018

Expertise in ETL testing and have knowledge in preparing ETL scripts and execution in Oracle SQL Developer

Expertise in Test Analyst activities like planning, designing test scenarios by analyzing Requirement Documents like BRDs and FRDs

Experience in Defect Tracking and Resolution. Troubleshoot and analyze root cause of problems

Expertise in Test Management Tool ALM Quality Center v12.21

Experience in working System Testing, E2E, Regression Testing and Integration testing

Efficient Team Player, communication, interpersonal & problem solving skills with analytical, decision making capabilities to enhance organizational objectives

Experience Details

Organization

Designation

Duration

Syntel Private ltd

Associate consultant

Sep 2013 – Dec2017

Cognizant Technology Solutions

Associate

Jan2018 – Till Date

Appreciations:

Received SPOT Recognition award several times for performing well in project and handling the issues within SLA time and Picked up in 4 Application in short time.

Authoring Test Scenarios after understanding business requirements and functional specifications, and executing Test Cases and logging relevant defects in ALM Quality Center.

Test plan and Test script walkthrough with Business Analyst and Test Manager.

Involvement in Test case preparation and Test execution.

Have regular interactions with onsite Test Manager and resolve queries & clarifications in a timely manner.

Provided full coverage in testing of the application and pin pointing critical defects.

Sending the Daily Execution Status Report to the Reporting Manager.

Received SILVER AWARD from client. (as part of AGILE)

Skill Matrix

Programming Languages : SQL,Unix

Databases : ORACLE 11g

Tool : HP QC, Oracle SQL Developer, Putty, JIRA, RALLY

Testing : ETL Testing

Operating System : Windows XP, Windows 7

Query Builder : Oracle SQL Developer, Tera Data SQL Assistant

Others : MS-Office

Work Experience

Project #1

Project Insurance

(Nov 2019 – Apr 2020) (Jan 2021 – till date)

Client Name : CHUBB

Project Name : CHUBB Insurance

Module : Chubb Insurance - Singapore

Role : Associate

Testing tools : ALM Quality Center v 12.0, Oracle SQL Developer

The Chubb insurance is the publicly traded P&C insurance company and the largest commercial insurer in the U.S. Chubb provides commercial and personal property and casualty insurance, personal accident and supplemental health insurance, reinsurance and life insurance to a diverse group of clients.

Worked in CHUBB2.0 for Singapore insurance. Validated data between various landing zone with mapping logics.

Responsibilities:

Responsible for providing the End-to-End testing on the priority of the issues to meet client’s SLA

Our main responsibilities includes like testing on the requirement as per mapping and to log issues if any in QC

Manage defects throughout its lifecycle as per Defect management guidelines

Responsible in Developing Test Cases from specifications, executing the Test cases.

Defect tracking and Bug reporting in Quality Center and Defect Tracker

Responsible for financial columns validation against previous version of customer report

Project #2

Project Insurance

(Jan 2018 – Oct 2019)

Client Name : CNO

Project Name : CNO Financial Group

Module : CURe

Role : Associate

Testing tools : ALM Quality Center v 12.0, Oracle SQL Developer

The CNO Financial Group.inc is a financial services holding company based in Indiana. Its insurance subsidiaries provide life insurance, annuity and supplemental health insurance products to more than four million customers in the United States.

Worked in CURe and FSTE projects. CURe – CNO Unified Repository, Validated data between various landing zone with mapping logics. FSTE - As part of an organizational initiative, customer is looking to create environments with end-to-end data flows in order to meet integrated testing needs for critical programs such as Pega. This particular SOW is intended to cover the implementation for the Pre-prod and UAT regions.

Responsibilities:

Responsible for providing the End-to-End testing on the priority of the issues to meet client’s SLA

Our main responsibilities includes like testing on the requirement as per mapping and to log issues if any in QC

Manage defects throughout its lifecycle as per Defect management guidelines

Responsible in Developing Test Cases from specifications, executing the Test cases

Monitor ETL batch jobs in Autosys.

Defect tracking and Bug reporting in Quality Center and Defect Tracker

Project #3

Project BNFS

(Jan 2016 – Dec 2018)

Client Name : State Street Corporation

Project Name : Credit MIS

Module : Probability of Default

Role : Testing Engineer

Testing tools : ALM Quality Center v 12.0, Oracle SQL Developer

In Probability of Default (PD), we create a questionnaire for each counterparty type in order to rate each counterparty. PD is an internal tool of State Street Corporation.

Responsibilities:

Responsible for providing the End-to-End testing on the priority of the issues to meet client’s SLA

Our main responsibilities includes like testing on the front end and also from back-end and to log issues if any in QC

Manage defects throughout its lifecycle as per Defect management guidelines

Responsible in Developing Test Cases from specifications, executing the Test cases

Run and monitor ETL batch jobs in Unix

Prepare MOM for the Daily Status Call

Defect tracking and Bug reporting in Quality Center and Defect Tracker

Maintaining Equip (Internal Quality Tool) for the team

Actively participated in live deployments and handled issues within SLA time

Project #4

Project BNFS

(Feb 2014 – Dec 2014)

Client Name : State Street Corporation

Project Name: Credit MIS

Module : Limit Management System

Role : Testing Engineer

Testing tools : ALM Quality Center v 12.0, Oracle SQL Developer

In Limit Management System (LMS) application based on the exposure, risks & the Net Asset Value we propose Credit Limit to Counterparties (one who have contract with State Street for funding).

Responsibilities:

Sending the Daily Defect Snapshot to the Reporting Manager.

Coordinating with the team to keep on track with the process tasks efficiently.

Handled releases of Regression and the releases of new functionalities.

Providing Knowledge Transfer sessions to new hires and maintaining Equip (Internal Quality Tool) for the team

Attending defect calls on daily basis and providing status to the manager.

Our main responsibilities includes like testing on the front end and also from back-end and to log issues if any in QC

Manage defects throughout its lifecycle as per Defect management guidelines

Responsible in Developing Test Cases from specifications, executing the Test cases

Run and monitor ETL batch jobs in Unix

Prepare MOM for the Daily Status Call

Defect tracking and Bug reporting in Quality Center and Defect Tracker

Actively participated in live deployments and handled issues within SLA time

ACHIEVEMENTS:

In Syntel, Received SILVER AWARD from client.

Received SYNTEL Award “IMAGINATIVE”

Completed Beginners Capital Markets Domain Exam “NCFM”

Completed IBM Object Oriented Programming Using Java

Completed C,C++ and Java basic course

Participated in many inter and intra college cultural during graduation and received awards and rewards also active member in National Cadet Crops during school and college level.

Education

LEVEL

BOARD/UNIVERSITY

COLLEGE/SCHOOL

YEAR

SCORED B.Sc.

(Mathematics )

Bharathiar University

Sri GVG Vishalakshi college for women

2013

68

STD XII

(Maths,Physics,Chemistry Computer Science)

Matriculation

Sri GVG Matriculation Higher Secondary School – Udumalpet

2010

65

STD X

Matriculation

Sri Vishalakshi Higher Secondary School – Udumalpet

2008

78

Personal Information

Particular

Details

Name

Premalatha

Father’s Name

Mahendran

Email ID

adzmdw@r.postjobfree.com

Date of Birth

12-04-1993

Contact Number – Mobile

+91-893*******

Languages

English, Tamil

Nationality

Indian

Present Address

4/268, Kumaran Street,

Bodipatti post, Udumalpet,

Tirupur – 642154

Gender

Female

I hereby declare that the information furnished above are true and correct to the best of my knowledge and belief.

Place: Coimbatore.

Date:

(Premalatha Mahendran).

Contact this candidate