Data Analyst
Resume:
Riya Mary Roly
Mobile : +91-949*******
Email : ************@*****.***
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