ARUN PRASANTH VELUSAMY

Client Name: Assurant Technologies

Project : Reinsurance

• Documented, triaged, and managed defects in software and worked with developers to facilitate timely resolutions.
• Analyzed source-to-target mappings provided by developers to ensure that data is being transformed correctly as per business requirements.
• Collaborated with developers in resolving issues identified during testing phases of projects.
• Performed data analysis and validation on source and target data sets for accuracy of transformation rules in ETL processes.
• Produced test scripts for new automated software testing rounds.
• Created detailed documentation of all findings from ETL application tests performed.
• Conducted unit, integration, system, regression, and performance testing for ETL applications.
• Developed test plans and scripts to validate ETL jobs.
• Investigated existing production issues related to ETL process by analyzing logs files generated by various components involved in the process.
• Remarkable experience in designing ETL processes and developing source to target mappings Proficient in SQL Queries, and SSIS validations
• Experience in Unix commands, SQL Joins, group functions, analytical functions, and subqueries.

Client Name: Cayuse Technologies.

Project Name: E-Series Application.

• Extensively used and developed SQL scripts/queries in backend testing of Databases
• Prepared daily status reports with details of executed, passed, and failed test cases, and defect status.
• Test case creation for ETL mappings and design documents for production support.
• Setting up, monitoring, and using the Job Control System in Development, QA, and Prod.
• Effectively communicate testing activities and findings in oral and written formats.
• Extracted data from various sources, like Oracle and DB2 servers.
• Worked on issues with the migration of data from the development to the QA-Test environment.

1. Client Name: The Home Depot, Inc.

Project: The Home Depot. Inc

2. Client Name: The NiSource

Project: NiSource.

3. Client Name: The Columbia Pipeline Group.

Project: Columbia Pipeline Group

• Strong experience with projects related to operational data stores, data warehouses, and data marts in a testing role.
• • Experienced in developing and implementing a comprehensive SDLC, proven hands-on experience with quality assurance.
• Creative problem solver with advanced analytical, planning, and scheduling skills, with a focus on timely delivery and utmost quality.
• Experienced in planning and executing tests from large system-wide testing (SIT, Functional, Regression, UAT, Performance, etc.).
• • Extensive experience in working with both agile methodologies.
• Throughout the project, in various iterations and sprints.
• • Conducted system testing, integration testing, functional testing, and integration testing.
• Defects identified in the testing environment are communicated to the developers.