Prakash Chandra

Highly motivated ETL/Manual Tester seeking a challenging role in a dynamic software testing environment. I possess strong analytical and problem-solving skills, and I am eager to leverage my expertise in data quality assurance to contribute to the success of your data integration initiatives.

• Over eight years of extensive experience in software development, including four years as a Manual/Functional Tester and over four years specializing in ETL/DWH/Database Testing with Informatica Tool.
• Proficient in managing projects from inception to closure, collaborating effectively with cross-functional teams.
• Versatile experience across various functional domains such as Insurance, Healthcare, POS, Banking, and Retails applications.
• Well-versed in Agile methodology, V Model, and Iterative Model for project execution and management, actively participating in daily Scrum calls to monitor project progress.
• Comprehensive understanding of the Software Test Lifecycle (STLC), adeptly handling requirement analysis, documentation, coding, and testing phases.
• Skilled in diverse testing methodologies including Functional Testing, Regression & Retesting, Integration Testing, GUI & System Testing, and more.
• Proficient in designing and reviewing critical documents such as BRD, FSD, Mapping Sheet, RTM, and testing documents.
• Hands-on expertise in composing High-Level Test Cases (HLTCs), meticulous test case development and review, precise test case execution, comprehensive defect tracking, and test summary report generation.
• Specialized proficiency in ETL/Data warehouse backend testing, encompassing Requirement Analysis, Testing, Implementation, and Support of Data Warehousing ETL using Informatica Power Center/Powermart.
• Familiarity with databases like Oracle 11g/10g/9i, MS SQL Server, and PostGreSQL.
• In-depth understanding of Dimensional Modeling, Star Schema, Snowflake Schema, Data Warehousing & Business Intelligence concepts, and Decision Support systems.
• Proficient in Windows XP/7/8/10/11 operating systems.
• Extensive exposure to API tools such as Postman Client, JMeter, SQL Editor tools like Sql Developer, Microsoft SSMS, PostgreSQL Manager; and Defect and Test Management tools like Bugzilla, RallyDev, QA Complete, and Azure DevOps.
• Skilled in crafting SQL Queries using SQL Server, Oracle, and Teradata Databases.
• Articulate communicator endowed with robust analytical, logical, and interpersonal skills, enabling seamless interaction across all levels of business and management.
• Adept problem-solver adept at thriving under pressure and consistently meeting deadlines.
• Extensive experience in crafting Release Metrics at the End of Delivery.

• Testing: Manual Testing / DWH / ETL Testing
• Operating System: Window XP/7/8/10, UNIX
• ETL Tool: Informatica Power Center
• Project/Defect Management Tool: Azure DevOps, CA RallyDev, QAC, Bugzilla
• RDMS/Database(s): Oracle 9i/10g/11g, Oracle SQL Developer, MS SQL Server, PostgreSQL
• Web Service /API Tool: Postman Client, Fiddler, Jmeter
• Documentation Tool: MS Excel, MS Word, PowerPoint, Notepad++

• ISTQB Certified Tester Foundation Level - 2013
• TOSCA Automation Specialist (AS) Level1 & Level2 - 2022

• Nominated multiple times for the Nagarro Cheerboard as the best performer in the team during 2021,2022,2023 & 2024.
• Awarded the HCL R&R Award for outstanding project execution and management in 2018.
• Secured the Quarterly Performance Award for excellence in project execution and management in 2015.

Project #1

Project Title: NYLIC

Company: Nagarro Software

Client: Leading Insurance Provider - US

Role: ETL Tester

Environment: Oracle 10g, Informatica Power Center

Description :  NYLIC is the one of largest life insurance company in the United States, the largest mutual life insurance company in the United States and is ranked 67 on the 2021 Fortune 500 list of the largest United States corporations by total revenue. NYLIC has about $593 billion in total assets under management, and more than $25 billion in surplus and AVR. In 2007, NYLIC achieved the best possible ratings by the four independent rating companies (Standard & Poor's, AM Best, Moody's and Fitch). Other New York Life affiliates provide an array of securities products and services, as well as institutional and retail mutual funds.

Responsibilities:

• Analyzed Functional/Business requirements thoroughly.
• Validated Incremental and Historical data loads using Informatica and Oracle Queries.
• Ensured the correctness of business logic for each column.
• Validated the creation of new tables, tracked data flow from source to data mart, managed new column additions, historical data fixes, report testing, creation/modification of feed files, and changes in existing feed files.
• Validated SQL procedures and Informatica Mappings and Sessions after code migration to load data into corresponding tables, Dimensions, and Facts.
• Executed AutoSys load jobs to validate job dependencies and data loads.
• Conducted various data quality/validation checks for feeds and tested end-to-end data flow from Stage to Target and Feeds.
• Created test plans, test cases, and executed functional and regression testing.
• Participated in Bi-Weekly User Story Grooming sessions and Sprint Planning meetings with Scrum Master, Product Owners, and Agile Team members.
• Reported bugs on the Azure DevOPS tool and verified fixes with each build.
• Provided daily updates on testing status during Scrum meetings, including progress made, tasks planned for the day, and any blocking issues.
• Performed End-to-End Testing, covering data flow from Sources to Staging, Staging to ODS, ODS to Legacy System, ODS to Target Data Marts, and Reports using ETL tools like Informatica and Toad, and BI Reporting tools.
• Validated business logic and Source to Target mapping directly in the Oracle Data warehouse.

Project #2

Project Name: IKEA Retail Sales Analysis

Company: HCL Technologies

Client: IKEA Retails

Role: Sr. QA Engineer (ETL Tester)

Environment/Tools: Oracle 11g, Informatica Power Center, CA Agile Central (RallyDev ), QA Complete

Description:  IKEA is world's largest furniture retailer based out in Netherlands. This project is for RETAIL SALES ANALYSIS DWH covering the consumer products. Data Warehouse designed for the purpose of Sales Analysis that basically helps the decision makers to analyze the sales as Product Wise, Brand Wise, Category Wise, Company Wise, Customer Wise, Supplier Wise, Area Wise, City Wise, State Wise, country wise, Time Wise, etc. and analyze the sales and profit in month wise quarter wise, and year wise.

Responsibilities:

• Involved in understanding business requirements and functional specifications.
• Designed and developed QA documentation such as Test Scenarios and Test Cases based on business and functional requirements.
• Reviewed requirements to identify gaps and raised clarifications.
• Executed smoke, regression, and end-to-end scenarios for each release.
• Performed SQL validation to verify data extracts, record counts, and duplicates in the Teradata and SQL Developer databases using complex SQL queries.
• Tested Derived data element mapping from Source to Target across multiple layers.
• Ran Jobs/Workflows for ETL processes.
• Reported bugs through the CA RallyDev tool and verified fixes with each build.
• Utilized Informatica tool for running and monitoring workflows and checking Session logs.
• Used Oracle SQL Developer to access source data and Teradata as the target.
• Extensively worked with Informatica Power Center tools including Power Center Designer, Workflow Monitor, and Workflow Manager for monitoring and scheduling sessions and workflows.
• Attended Sprint Planning, User Story Grooming, and Sprint Review meetings.
• Participated in daily Scrum meetings, providing QA status updates to the rest of the Scrum team.
• Presented tested user stories to Business Analysts and Product Owners for acceptance.
• Conducted Knowledge Transfer and Training Sessions for new team members.
• Responsible for various Data mapping activities from Source systems to Data Warehouse.

Project #3

Project Title: Pine EMI

Company: Pine Labs Pvt. Ltd.

Role: QA Consultant

Environment:  Sql Server 2008, Java

Description :  EMI is a comprehensive and reliable solution to facilitate merchants or manufacturers to offer their consumers/ customers instant EMI Payment options.

Responsibilities:

• Developed test cases for Request for Change (RC) and conducted functional testing.
• Conducted a range of testing activities including Black Box, GUI, Functional, Ad-hoc Testing, Smoke & Sanity Tests, and cross-browser compatibility testing.
• Identified and documented errors/bugs using Bugzilla.
• Verified backend defects by analyzing updates in the database tables after each activity.
• Executed POS Testing to validate the transaction engine.
• Collaborated with the Development Team/Test Support Team to clarify requirements.
• Performed Regression & Sanity Testing for newly implemented functionalities and created corresponding test cases.
• Conducted Pen Testing on the backend application/portal.

• Date of Birth: 05th November 1988
• Address: Flat No. B-7/9, Rail Vihar, Niti Khand-3, Indirapuram, Ghaziabad - 201014, Uttar Pradesh
• Gender: Male
• Marital Status: Married
• Passport: Available
• Languages: English & Hindi