Test Engineer Sql Developer
Resume:
Premalatha Mahendran, Test Engineer
Email: *****.*****@*****.***
Mobile: +91-893*******
Professional Summary
Test Engineer with 11 years of strong technical skills in ETL Testing with successful execution of projects.
A result-oriented professional with 9 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
Senior 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
*****.*****@*****.***
Date of Birth
12-04-1993
Contact Number – Mobile
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