Page * of *

Riya Mary Roly

Mobile : +91-949*******

Email : adknb6@r.postjobfree.com

February-2021

IT Experience Summary

5.2 years of experience in the field of Information Technology primarily in DW/ETL Testing and Bigdata testing

ETL Test Analyst proficient in Testing Enterprise Data Warehouses - Telecom and Insurance Domains

Extensive experience in preparing Test Plans and Test scenarios, Test Cases, Test Query preparation, Test Execution, defect reporting and Test Closure Reports.

Experienced in User Acceptance Testing and Regression Testing for Europe based Telecom Client and Regression,Functional,Smoke and System Integration Testing for US based Client

Hands on experience in Big data technologies like HiveQL,Ambari, Azure cloud, Oozie, and VSTS tool

Trained on fundamentals of Google Cloud Platform Big Data and Selenium Web Automation Tool.

Experience involves working as a Test Analyst and Senior Test Analyst on Onsite-Offshore Delivery models in both Agile and Waterfall methodologies.

Hands on experience in Test Management Tools – HP ALM Quality center, JIRA,Putty and AZURE SQL DWH and Reporting Tools – Business Objects and Cognos.

Basic knowledge in Python and Unix shell scripting. Education

Bachelor of Technology in Computer Science and Engineering, Mahatma Gandhi University. Employment History

SOFT SKILLS SUMMARY

Name of the Company Designation From To Duration

(Months)

Cognizant Technology Solutions Associate - Projects 22-Dec-2015 Till Date 62 Databases SQL Server Management Studio,Oracle

Bigadata Tools Hadoop, Hive, Ambari, Azure cloud, Oozie, VSTS tool ETL Tool Informatica Powercenter

Test Management &

Configuration Tools

HP Quality Center ALM, WINSCP, Putty(Unix), JIRA

Reporting Tools IBM Cognos, BO

Page 2 of 3

Certifications

Python for Data Science

Google Cloud Platform Big Data and Machine Learning Fundamentals

DP-900 -Microsoft Azure Data Fundamentals.

Project Details

1. Deutsche Telekom AG(DTAG) (May 2016 – Dec 2019) Role: Senior Test Analyst

Databases Used: Oracle

Model: Waterfall

Description: Deutsche Telekom is a German telecom company, which is the largest telecommunications provider across Europe. The cluster test team is involved in the user acceptance test activities of Deutsche Telekom and Regression Test team performs end-to-end test automation using Robot Framework. Responsibilities:

Understanding the business functionalities and validating data from the source to target.

Understanding the Business Requirement Documents, changes requests and raising clarification to the Business Solution team.

Performing requirement mapping, creating Test cases and executing them in Quality Center.

Preparation of test scripts and test data for validations.

Configuring Test Environments and validating Business use cases.

Logging Test results and reporting/Consolidating status reports.

Updating team about issues on time and test progress through Status Mails.

Participate in Defect/Issue Analysis and Resolution with Development.

Document and Share error troubleshooting ideas to the team.

Communicate with design and development team for Issue resolutions.

Mentor the new team members and give them demos on test tools and practices.

Creation of Test closure documents for final sign off.

Involved in automation using Robot Framework.

2. DEEP-XL Catlin Insurance (Sept,2020– Present)

Role: Senior Test Analyst

Databases Used: SQL Server

Model: Agile

Description: AXA XL,the property & casualty and specialty risk division of AXA.AXA XL’s DEEP is a digital,multi-sided platform that extends beyond technology to address the barriers found in insurance digital transformation programs.

Responsibilities:

Understanding the business functionalities and validating data from the source to target.

Preparing test scripts using HiveQL and SQL and mocking up test data for validation.

Preparing testcases for business and functional requirements in AZURE DevOps.

Executing testcases in Hive and SQL and raising defects in AZURE DevOps.

Reporting daily status reports to Onsite Coordinator. Page 3 of 3

Active involvement in daily calls with offshore and onshore team

Involved in Regression, Functional, Smoke and System Integration Testing

Applying logical transformations to transform and load the data as per the requirement.

Performed database validation according to the business logic by comparing the source to the target

Tracked the defects using VSTS and generated defect summary reports.

Preformed SQL validation to verify the data extracts and record count in the database tables by writing complex SQL minus queries.

Tested DEEP transformation mappings from OZ to SZ and SZ to AZ layers

Creating Test Sets in test lab for all the test cases that needs to be created in VSTS

Validating based on Business requirements by understanding the information available in requirement documents

Worked in DE (Data) work stream and performed validation in LZ,OZ,SZ and AZ

Using VSTS- logging, tracking and closing a defect to closure

Preparing test summary documents.

Personal Profile

Permanent Address : Muttappillil House, Kuravilangad P.O Kottayam,Kerala,Pin:686633

Language Known : Malayalam, English and Hindi

Passport Number : M4970192

Date of birth : 11th November 1992

Marital status : Married

Declaration

I, Riya Mary Roly, hereby declare that all the information provided above is true to the best of my knowledge and belief.

Place: Kuravilangad

Date: 23-02-2021

Contact this candidate