Summary
Overview
Work History
Education
Skills
Accomplishments
Certification
Timeline
Generic

Sathiyanarayanan Udhayakumar

Tiruvannamalai

Summary

Detail-oriented System Analyst with over 4.11 years of experience in Database Testing, including ETL and Manual Testing within the Banking and Insurance sectors. Proficient in SDLC and STLC methodologies, defect tracking, and writing comprehensive test cases. Successfully managed all phases of the testing cycle, consistently delivering results ahead of deadlines. Expertise in testing techniques enhances the ability to identify issues and improve software quality.

Overview

5
5
years of professional experience
1
1
Certification

Work History

System Analyst

Hexaware Technologies
03.2020 - Current
  • Understanding Requirement Specifications, Mapping and Design Documents
  • Involved in preparation of test plan document
  • Involved in writing test cases and execution of test cases
  • Participated in daily scrum call and UAT meetings
  • Retesting the defect when code fix made
  • Test Data preparation to validate all possible scenarios
  • Test plan preparation with detailed test case’s using SQL Queries
  • Verifying the ETL data in target database
  • Verified column mapping between source and target
  • Interactions with BA & Dev teams to resolve the issues
  • Reporting daily testing status
  • Reporting Weekly status report
  • Logging defects in the defect tracker
  • Current Project: Kirkland & Ellis (Cloud Data Platform)
  • Environment: QA, UAT
  • Tools: Azure Data factory, Azure storage Explorer, Azure synapse, SQL server

Sr. Software Engineer

Grant Thornton
01.2023 - 10.2023
  • Company Overview: Grant Thornton LLP provides consulting services
  • The Company offers accounting and business advisory services, covering areas such as audits, taxes, corporate finance, information technology, litigation, strategy, and many more
  • Grant Thornton serves public and private companies in the manufacturing, distribution, service, and other related industries worldwide
  • Unite application - This application serves the business users with the data related to Audit WLA, Advisory and Tax
  • It comes under Engagement delivery ecosystem which consists of - Engage, Convene along with Unite
  • This project describes the Informatica Cloud process for advisory V&M service line which involves event driven file ingestion, storage, upload V&M model in trusted zone and loading to SQL and success/failure communication for ingestion, conversion and loading outcome along with the scenarios we may encounter during the execution of this feed
  • Grant Thornton LLP provides consulting services
  • The Company offers accounting and business advisory services, covering areas such as audits, taxes, corporate finance, information technology, litigation, strategy, and many more
  • Grant Thornton serves public and private companies in the manufacturing, distribution, service, and other related industries worldwide

Sr. Software Engineer

KPMG
03.2022 - 12.2022
  • Company Overview: KPMG is migrating its business model to the cloud using azure data lake (ADL)
  • Analyzed the baseline documents and understood what needs to be tested
  • Developed test scripts based on the mapping document and prioritize testing activities
  • Executed all the test cases and reported defects, define severity and priority for each defect
  • Retesting the defect when code fix made
  • Be ready with the regression suite and carried out regression testing every time when changes are made to the code to fix defects
  • Test Data preparation to validate all possible scenarios
  • Test plan preparation with detailed test case’s using SQL Queries
  • Verifying the ETL data in target database
  • Verified column mapping between source and target
  • Interactions with BA & Dev teams to resolve the issues
  • Reporting daily testing status
  • Defect Analyzing and Reporting in QC
  • KPMG is migrating its business model to the cloud using azure data lake (ADL)

Sr. Software Engineer

12.2020 - 02.2021
  • The Portal is created for brokers and lenders to provide loan services to individuals and companies
  • The broker creates loan application on behalf of individuals or company, fills in details of the applicants – like personal details, Income details, Existing loan details, Property details, bank details and proceeds for loan processing from lender
  • The lender user does credit search valuation of the property for the applicant
  • All these things take place with the integration of the third-party application like Equifax (Credit search), Quest (Property Valuation)
  • There is also an integration with postcode lookup (Valid address), DocuSign of documents where applicants can e-sign documents, EPDQ payment system integration for applicants to pay application fees
  • Once all the stages are successful, Funds are released to the applicant

Sr. Software Engineer

03.2020 - 12.2020
  • The objective of this project is to test the end-to-end data migration and testing on different database Athora & Fidea
  • Insurance policy data migration, namely the process by which insurance policies are transferred from one or more source systems to one target systems
  • Understanding existing business model and BI requirements
  • Experience in Data Analysis
  • Implementing a repeatable & highly reusable framework
  • Coordinating regression test automation activities across all supported applications, reporting defects and escalating issues as needed, and creating QA Status Reports
  • Created different source definitions to extract data from flat files and relational tables for Informatica
  • Working with Transformations like Lookup, Update Strategy, Aggregator, Router, Stored Procedure, Expression and Joiner Using Informatica
  • Load data different 2 systems Athora & Fidea and Manage end to end data migration
  • Managed data load error recovery
  • Evaluated database structure and data movement
  • Took ownership for allocated work order; ETL Testing, SQL, Unix, Informatica read the business requirement documents; designed test scenarios and test cases according to the requirement
  • Raised defects via TFS whenever result did not meet the expectation

Education

MBA - Finance

University of Periyar (Distance)
Salem
05-2021

Bachelor of Computer Applications - Computer Applications

Nehru Arts & Science Collage
Coimbatore
05-2011

Skills

  • Data warehousing
  • SQL proficiency
  • Project management
  • Web services
  • Agile methodology
  • Narrative use cases
  • Data extraction

Accomplishments

Appreciated by Client and Project Manager for outstanding contribution for completing the given task within short span of time.

Received Star Performer of the month for successfully completing the release within the Timelines.

Certification

Certified Tester Foundation Level – ISTQB

Certified Microsoft Azure 900 Fundamentals

Timeline

Sr. Software Engineer

Grant Thornton
01.2023 - 10.2023

Sr. Software Engineer

KPMG
03.2022 - 12.2022

Sr. Software Engineer

12.2020 - 02.2021

System Analyst

Hexaware Technologies
03.2020 - Current

Sr. Software Engineer

03.2020 - 12.2020

MBA - Finance

University of Periyar (Distance)

Bachelor of Computer Applications - Computer Applications

Nehru Arts & Science Collage

Similar Profiles

CREATE PROFILE
Sathiyanarayanan Udhayakumar