MAHENDRA KUMAR KANDASAMY

Result-driven professional with over 15 years of experience in Software Testing, Test Manger for 2 years and ETL Functional testing for 6 years and Mainframe Testing for 1 year. Expertise in the domains of Insurance, Payments, Mortgage, and Healthcare, with hands-on experience in Web applications, Standalone applications, and Mainframe applications. Having experience in Insurance applications, Policy administration, Wealth Management, Advisor Portal, Annuities, Pension, Retirement & Income Protect Plan. Proficient in Reporting tools such as OBIEE and Business Objects (BI). Experience in Data Warehousing, and ETL testing. Well-versed in the entire software testing life cycle. Good experience in Data Migration, Data ingestion and Data integration. Resource planning, Test strategy and developing effective test plans tailored to business needs. Well-versed in traditional Software Models (V & Waterfall Model) and Agile methodology. Exposure to automation testing with tools like selenium web driver TDD and BDD frame work. Good experience in Big data, Spark and Hadoop tools. Good exposure in AWS cloud migration project. Actively involved in organizational activities like quality assurance, interview panels and career development programs.

• Member of ISTQB – ISEB Certified Tester Foundation Level (CTFL), UK Testing Board.
• Certificated AWS Data Engineer associate.
• Automation Specialist Level 1 and Level 2 for Tricentis Tosca 12.x.
• Received Spot Ovation and Best Team Player awards at RBS.
• Received various awards from HCL, including employee of the month, live wire, etc.

• Proven track record in Insurance applications, including Policy administration, Wealth Management, Advisor Portal, Annuities, Pension and Retirement & Income Protect Plan.
• Prepared Test planning, estimations and Resource Planning on various projects.
• Review and testing of data maps between legacy systems and relational databases.
• Proficient in Back-End Testing/Database Testing, specifically in developing and executing SQL queries.
• Lead defect triage meeting and classification of defect.
• Responsible for task allocation and monitoring to track the status to meet the deliverables on time. Ensure timely escalations of critical issues to the test management.
• Responsible for building the team by providing training for new arrivals to take up the project work in short scale of time.
• Defect management using ALM, ADO and Jira tools.
• Conducted root cause analysis on post-release defects and implemented corrective actions.
• Responsible for team building, training, and task allocation to meet project deliverables.
• Extensive experience in software development and testing methodologies.
• Involved in Sprint plan, Story grooming session and sprint retrospective meeting.
• Build the queries, create Regression/functional test suite to automate the feasible scenarios.
• Reviewed the Business Requirement Document to understand the process and write Test scenarios and Test Cases.
• Performed data validation testing writing SQL queries as per the transformation logic available in the Business Requirement.
• Support and manage the Testers (IT, Business User) in day-to-day deliverables.
• Ensure quality of deliverables by review, test process adherence and monitoring.
• Developed SQL queries to verify data from Source to Target.
• Performed validation on flat file against to table and table to table validation.
• Prepared Test readiness report, Test summary report and share to stakeholders.
• Manage overall testing deliverables for reviews and signoff.
• Ensuring defects are identified, recorded, prioritized and managed to closure per organizational standards.
• Tracking progress of the project, scheduling and monitoring, documenting and reporting the current status of projects to client and higher management.

AWS Data Engineer associate