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.
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.
Senior ETL Test AnalystWorld 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 AnalystLiberty 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 AnalystAbbvie 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 AnalystCareFirst 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.
Education
Expected in 05/XXX3
Bachelor's of Engineering: Electronics And Communications Engineering MIET, Nagpur University - , GPA:
Graduated top of the Class in Final Year.
Elected as Editor of Departmental Magazine in XXX2, XXX3.
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:
