Jessica Claire
, , 100 Montgomery St. 10th Floor
Home: (555) 432-1000 - Cell: - - -
Professional 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.

  • 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.
  • 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.
Work History
02/XXX9 to 03/2020
Senior ETL Test Analyst World Bank As Client Of Cognizant City, STATE,
  • 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.
10/XXX6 to 01/XXX9
Senior ETL Test Analyst Liberty Mutual As Client Of Cognizant City, STATE,
  • 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 .
08/XXX5 to 09/XXX6
ETL Test Analyst Abbvie Inc As Client Of Cognizant City, STATE,
  • 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.
05/XXX4 to 07/XXX5
ETL Test Analyst CareFirst Inc. As Client Of Cognizant City, STATE,
  • 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.
Expected in 05/XXX3
Bachelor's of Engineering: Electronics And Communications Engineering
MIET, Nagpur University - ,
  • Graduated top of the Class in Final Year.
  • Elected as Editor of Departmental Magazine in XXX2, XXX3.
  • Member of Student's Club "PEACE".
  • Member of National Service Scheme (NSS).
Expected in 12/XXX8
Master of Arts: English Literature

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy


Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

How this resume score
could be improved?

Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:


resume Strength

  • Formatting
  • Length
  • Personalization
  • Strong Summary
  • Target Job

Resume Overview

School Attended

  • MIET, Nagpur University

Job Titles Held:

  • Senior ETL Test Analyst
  • Senior ETL Test Analyst
  • ETL Test Analyst
  • ETL Test Analyst


  • Bachelor's of Engineering
  • Master of Arts

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in: