JAYAKANTH N

Results-driven Senior Analyst with extensive experience at HCL Tech, proficient in SQL and JIRA. Expert in data validation and quality assurance, successfully enhancing data integrity and system functionality. Adept at collaborating with cross-functional teams, ensuring seamless project execution and timely issue resolution. Committed to delivering high-quality outcomes in fast-paced environments.

Project 1, Investment Banking - Capital Markets, Bank of Ireland (HCL Tech), Oracle 12c, SSIS, SQL, UNIX, JIRA, IICS, Tableau, Evaluate mapping documents to create detailed test cases for data validation., Construct test scripts and execute them to verify data accuracy and system functionality., SQL queries were tested to ensure the database's performance and data integrity., Perform data quality validation involving row counts, sample data validations, and full data reconciliation to ensure accurate data transformation and migration., Confirmed the mapping of columns between the source and target environments to ensure proper data mapping., Strong knowledge of the software testing life cycle (STLC) processes involved in various testing stages, from requirements analysis to defect management., Create documents for tracking, reporting, prioritizing, and bug logging using tools to ensure thorough issue resolution and project progress. Project 2, Investment Banking - Asset Management, Revolut Bank, Oracle 12c, SSIS, SQL, UNIX, JIRA, IICS, Tableau, Examined and tested the project's source, staging, and target data to ensure accuracy and completeness., SQL queries with subqueries, joins, group functions, and analytical functions were written to carry out complex test cases., Verified the number of records in the source and target environments to ensure data consistency and transformation accuracy., Created and documented test findings, defect lists, and test reports to track progress and facilitate issue resolution., Used SQL to analyze application data and determine the required ETL procedures., Modified and created SQL queries for data processing, and stored the data for analysis and quality control., Reported any defects found in the testing environment to the development team for prompt resolution., Attended Scrum Meetings and provided updates on the daily activities' status using Agile methodologies. Project 3, Health Care, Garnet Health, Oracle 12c, SSIS, SQL, UNIX, JIRA, IICS, Tableau, Compiled and evaluated the client's new change request's business requirements to ensure alignment with project objectives., Tested the data migration environment to ensure that the transferred data met the specified requirements., Involved in data validation and database testing following the completion of the migration process, ensuring data consistency and accuracy., Identified bugs, categorized them based on priority and severity, and recorded them for tracking and resolution., Informed developers of any flaws or issues discovered in the testing environment to ensure prompt resolution., Implemented various Slowly Changing Dimensions (SCD) types to extract data files according to the project specifications.

• English
• Tamil

• Date of Birth: 06/21/89
• Nationality: Indian
• Marital Status: Married