Suganthini Durairaj

• Developed test plans and strategies for ETL testing processes.
• Created and executed automated scripts to validate data accuracy, integrity and consistency between source systems and target databases.
• Analyzed requirements documents to determine the scope of testing activities.
• Performed back-end database testing using SQL queries to verify data accuracy in target systems.
• Identified issues related to ETL process and provided recommendations for improvement.
• Developed detailed test cases based on functional and non-functional requirements.
• Conducted validation of data mapping rules, transformations, stored procedures, functions.
• Documented all defects found during testing phases and tracked them until closure.
• Worked with business users to ensure that their expectations are met through successful implementation of projects.
• Coordinated with development teams in resolving technical issues related to ETL processes.
• Participated in project meetings to discuss issues related to ETL development lifecycle.
• Monitored performance metrics and identified areas for improvement in the existing system architecture.
• Provided support in production environment by troubleshooting any issue related to ETL processing or data migration from source systems into target databases.
• Assisted developers in developing complex SQL queries for extracting data from various sources such as Oracle, MS Access.
• Evaluated new software products and enhancements against defined requirements before they can be implemented into production environment.
• Collaborated with other departments such as operations, development and infrastructure teams while performing integration tests across different components.
• Maintained accurate records of all test results including performance metrics, defects found.
• Designed automated regression tests using scripting languages like Python or JavaScript.
• Reviewed test reports prepared by team members and ensured that they meet quality standards set forth by the organization.
• Worked with Agile and Scrum methodologies to accomplish project milestones and meet demanding timelines.
• Tested functionality, performance and compliance of each product against design specifications to maintain strong development standards and high customer satisfaction.
• Participated in product design reviews to provide input on functional requirements, product designs, schedules, or potential problems.
• Wrote and updated manual test cases for team use, maintaining optimal organization for maximum productivity.
• Completed unit and regression tests on software and individual modules.
• Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
• Monitored and facilitated bug resolutions to optimize software.
• Met project scope and delivery dates by planning optimal testing schedules.
• Worked with off-site teams to complete timely tests and facilitate smooth product releases.

⮚ Done test case execution manual and performed defect logging in Azure. Performed web testing, and application testing.

⮚ Have done testing in Power BI reports and dashboards based on the SQL database.

⮚ Power BI reports testing is covered with UI and database testing validation.

Power BI dashboard testing was done by recreating the DAX queries into SAP HANA/SQL queries for the data testing.

⮚ Made sure to have the proper communication between testing and dev teams to get the inputs to proceed with the QA testing.

⮚ Conducting various types of testing like Smoke, Functional & Regression Testing.

⮚ Interacting with Clients and updating the status and getting the updates if any changes in the requirement.

⮚ Sent the Daily, Weekly, and Monthly status reports on all the applications to clients and managers.

⮚ Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing, and integration testing.

⮚ Extensively interacted with developers, and business& management teams to understand the project business requirements and design document specifications.

⮚ Participated in regular project status meetings and QA status meetings.

⮚ Extensively used and developed SQL scripts/queries in backend testing of Databases.

⮚ Written test cases to test the application in ALM 11.0

⮚ Prepared daily status reports with details of executed, passed, and failed test cases and defect status.

⮚ Executed testing processes and reported findings.

⮚ Collaborated with all stakeholders.

⮚ Responsible for Preparing Test scenarios, Test Cases, and execution of the test cases.

⮚ Perform the tasks of tracking the execution of test status.

⮚ Perform the tasks of reviewing documents by coordinating with software developers.

⮚ Identified bugs in the database created reports for modification requests and resolved all issues.

⮚ Requirement Analysis and Query log creation with Traceability.

⮚ Defect Management approach and Test Closure Report creation.

⮚ Daily Execution Plan for the team by deciding the scope of each phase.

⮚ Participating in Defect triage meetings daily to coordinate the defect retest activity and the issues.

⮚ Liaising with the Business and functional team for any requirement-related issues.

⮚ Providing daily and weekly status Reports.

⮚ Designing Test scenarios and test conditions whenever required.

⮚ Reviewing Test scenarios designed by the team.

⮚ Prepared Test data for Execution

⮚ Suggestions given during the project to the clients on improvements and challenges faced

⮚ Effective communication with the clients

⮚ As part of the QA team was involved in the implementation of ETL best practices.

⮚ Involved in performing various levels of testing like Unit Testing, System testing, Integration testing, and Regression testing.

⮚ Performed Manual Testing of the application as well as identified the critical test scripts to be automated.

⮚ Test Cases Execution and defect tracking if any.

⮚ Supporting the Code release during production implementation.

⮚ Compared the code by running it in both UNIX and LINUX boxes