Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

RAm Kothandapani

Port Glasgow

Summary

Seasoned ETL testing professional with 5+ years of proven track record of performing quality checks on diverse issues, authoring test cases and creating user stories. Knowledgeable about estimating hours, tracking versions, defects and understanding business requirements. Experienced in managing complex tasks and teams. Creates a team-driven environment that fosters room for development and growth using technical as well as analytical skills.

Overview

6
6
years of professional experience

Work History

Senior ETL Test Analyst

World Bank As Client Of Cognizant
02.2019 - 03.2020
  • Tracked and reported errors by collaborating with developers, clients and onsite counterparts.
  • Managed resource allocation and networked to manage planning and operations in testing cycle.
  • Evaluated test results and generated reports for development teams.
  • Verified development and maintenance of regression test suites.
  • Analyzed and interpreted test data and prepared technical reports.
  • Performed report testing on SSRS reports.
  • Created test scripts for verifying report data with Dbeaver.

Senior ETL Test Analyst

Liberty Mutual As Client Of Cognizant
10.2016 - 01.2019
  • Created test cases to perform source system to landing layer, landing layer to staging layer validations.
  • Performed count check, duplicate check, audit details check, Null check to ensure data quality.
  • Independent test execution of ABC (Audit, Balance and Control), RDM (Reference Data Management), MDM (Master Data Management) modules.
  • Created Test cases, test scripts and performed validation for encrypted data in Tier 1 Hub, Link and Satellite tables.
  • Created Test cases, test scripts and performed validation between two different databases (MySQL and Redshift Tables) using Platinum.
  • Deployed, Scheduled and ran Talend jobs using TAC scheduler.
  • Verified the messages in Amazon SQS queue and Verified the files generated in Amazon S3 bucket and Winscp path for all the modules such as ABC, RDM, MDM, Tier 1 and Tier 2.
  • Reviewed the work of junior resources and guided them on the test execution.
  • Knowledge Transfer to the team on RDM and MDM modules.
  • Effort Estimation and Test plan preparation for System Testing .

ETL Test Analyst

Abbvie Inc As Client Of Cognizant
08.2015 - 09.2016
  • Created, edited and refined test cases as necessary.
  • Created and executed Test scripts in two different databases.
  • Report Defects, Follow up for Defect fix, Retest and closure of defects .
  • Documentation of Test Results.
  • Prepared Test cases for testing the data of the reports generated from Cognos Tool.
  • Creating SQL scripts to verify the data in report against the database.
  • Prepared unit test cases for reports and executed them in Quality Center.
  • Performed different phases of testing such as Dry Run and Formal Execution.
  • Keeping at par with the rapidly changing requirements as testing methodology followed was Agile Testing.

ETL Test Analyst

CareFirst Inc. As Client Of Cognizant
05.2014 - 07.2015
  • Prepared Test cases based on the requirements and uploading in HP ALM .
  • Prepared test data in Facets based on all the possible scenarios and transformation rules.
  • Created Test result documents, QA approval document, passing Test cases, raising and linking defects in HP quality center.
  • Involved in Defect root cause analysis with onsite counterparts.
  • Created DHMO group data which was one of the most important aspect of the project and giving KT to team members.
  • Reported Defects in quality center and got them fixed with day to day onsite co-ordination.
  • Creating and processing XML files based on requirements.
  • Ensured proper data flow from tables to report (CSV files) and then to PDF.
  • PDF validation: Look and feel according to business needs, ensuring correct old and new rates, logo, address and various other details are populated in PDF .
  • Testing various jobs such as Letters, Vendors, Billing, Termination and Reinstatement.
  • Testing various letters such as ON and OFF exchange open enrollment, IPP not paid, pediatric medical/dental age out notification.

Education

Bachelor's of Engineering - Electronics And Communications Engineering

MIET, Nagpur University
05.XXX3

Master of Arts - English Literature

IGNOU
12.XXX8

Skills

  • System verification, ETL Testing, Manual Testing
  • Report Testing, Database Testing, Regression Testing
  • QA Management, Data Analysis
  • Test Automation using Platinum and Selenium
  • Amazon AWS, S3, SQS, Azure
  • Redshift, DB2, DBeaver
  • MySQL, SQL Server, Oracle, Teradata SQL Assistant
  • HP ALM, JIRA, Version One
  • Facets, CDW, PEGA Interface
  • STLC, Defect Lifecycle
  • Windows, MAC, MS Office
  • White box, Black Box and Gray Box testing

Accomplishments

  • Awarded with the Liberty Spotlight Award for identifying a number of quality defects for Liberty Mutual.
  • Awarded with the Delivery Excellence Job Well Done Award for going extra mile to deliver tasks on time.
  • Won poster designing competition 3 times in a row organized for creating awareness on various topics as part of corporate social responsibility.
  • Took responsibility to keep employees motivated and healthy by being a part of "Whatta Wednesday" and "Cheers! Be healthy" team.

Timeline

Senior ETL Test Analyst

World Bank As Client Of Cognizant
02.2019 - 03.2020

Senior ETL Test Analyst

Liberty Mutual As Client Of Cognizant
10.2016 - 01.2019

ETL Test Analyst

Abbvie Inc As Client Of Cognizant
08.2015 - 09.2016

ETL Test Analyst

CareFirst Inc. As Client Of Cognizant
05.2014 - 07.2015

Bachelor's of Engineering - Electronics And Communications Engineering

MIET, Nagpur University

Master of Arts - English Literature

IGNOU

Similar Profiles

CREATE PROFILE
RAm Kothandapani