ANUP CHINGUNDI

Associate – Senior Test Analyst

Cognizant

09.2021 - Current

Collaborated in developing and implementing comprehensive Test Plans, Test Strategies, Test cases and Test scenarios to ensure Quality Assurance and validate all business requirements.
Developed complex SQL / PLSQL scripts for data validation across various layers and for verifying the ETL mapping rules.
Meticulously reviewed data throughout the process, identified and raised critical defects. My strong foundation in SQL further enhanced this process, allowing me to write complex SQL queries to analyze and thoroughly assess data quality and integrity throughout the ETL process.
Validated Data transformations and performed End to End data validations to make sure the target tables are populated according to the data mapping provided.
Leveraged my Python expertise to automate data validation and few manual tasks within the ETL process, resulting in a 60% reduction in testing time.
Developed reusable Python scripts for data transformation and quality checks, utilizing libraries like Pandas for efficient data manipulation and comparison.
Demonstrated initiative by taking complete ownership of the ETL testing process for 8 months, ensuring its successful completion without receiving any escalation.
Worked closely with Developers, Upstream teams, the Downstream teams and Product Owners to co-ordinate between multiple teams and to ensure features/bug fixes are delivered by iteration end
Independently analyzed issues, recommended changes and wrote detailed bug reports
Participated in all aspects of product testing, including test plan development, execution, and delivery of well tested solutions
Participated in regular project status meetings and QA status meetings.
Leveraged Rally to effectively manage the ETL testing process. This included creating user stories, test cases and defects, tracking progress, and collaborating with stakeholders to ensure timely delivery and project visibility.