Summary
Overview
Work History
Skills
Timeline
Generic

Sasi Mohan

Chennai

Summary

Over 7 years of experience in Information Technology on Software Testing/Quality Assurance. Experience in using Quality Assurance for ETL and Manual. Good understanding of QA methodology and Software Development Life Cycle (SDLC). Involved in analysis, design and quality assurance of Client/server applications for Healthcare, Insurance and Banking. Extensive experience with testing multi-Tier application architecture. Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual. Diverse experience in Information Technology on Quality Assurance, Manual Testing. Excellent knowledge in ETL validation, Data Model Validations. Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica. Experience in Dimensional Data Modeling using Star and Snow Flake Schema. Extensive experience in client/server using System Testing, Functionality Testing (White &Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Data base Testing and User acceptance testing. Extensive experience with Data warehouse applications. Strong knowledge in Quality Centre. Experience in End-to-End testing with Jupiter Tool Expertise in Problem solving and Bug Reports using Bug Tracking Tools. Strong skills in backend (in both Relational & Hierarchical database) testing. Writing SQL queries, generating reports to ensure data integrity and validating business rules Experience in working with Databases and using SQL, SQL Server, Oracle Ability to handle multiple tasks and work independently as well as in a team. Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time. Has good knowledge in Selenium Python.

Overview

7
7
years of professional experience

Work History

ETL Tester

Citi Bank- Oasys Financial Services
01.2023 - 01.2024
  • Comparing the files from Sybase to Oracle by using Unix Commands
  • Copying the files From Sybase to Oracle
  • Running the Shell Scripting to compare the Files from Sybase to Oracle
  • Preparing the Consolidated document on compared Sybase and Oracle Databases.

ETL Tester

TIMS(Treasury Investment Management System)
01.2022 - 01.2023
  • Prepared and ran SQL queries
  • Designed & executed test cases
  • Verifying the data in target database after ETL process
  • Performed column data mapping between source & target database
  • Prepared test data for testing
  • Preparing RTM Document

ETL Tester

Pacific Life(USA)
03.2021 - 12.2021
  • Prepared and ran SQL queries
  • Designed & executed test cases
  • Verifying the data in target database after ETL process
  • Performed column data mapping between source & target database
  • Prepared test data for testing.

ETL Tester

Sephora
03.2019 - 02.2021
  • Running the Jobs/Workflow for ETL process
  • Prepared and ran SQL queries
  • Designed & executed test cases
  • Verifying the data in target database after ETL process
  • Performed column data mapping between source & target database
  • Prepared test data for testing
  • To compare the test results with the expected results
  • Defect analysing and reporting in QC
  • Reporting daily testing status report
  • Interactions with Dev teams to resolve the issues.

ETL Tester

UWT Water Flood
01.2017 - 02.2019
  • Understanding and analyzing the client requirements
  • End to End ETL Test execution for all the Test Data given
  • Test Case creation for End-to-End Testing, Business User Validation, Transnational Testing, defect logging and tracking
  • Monitoring the ETL Jobs scheduled and tracking in case of any issues with the Jobs
  • Adhere to the ETL Process used for getting the related source information from the various system like EC(Energy Components) and IWMCAC
  • Validating FIELD, RESERVIOUR, ZONAL, AREA, WELLS data in Source and Target
  • Validating the source and target tables along with the Landing and staging areas involved in the data Flow
  • Preparation of defect report and monitoring the defect statistics in the defect report
  • Reporting to the onsite coordinator about the status of the test activities on a daily basis.

Skills

  • Good understanding of QA methodology and Software Development Life Cycle (SDLC)
  • Extensive experience with testing multi-Tier application architecture
  • Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual
  • Excellent knowledge in ETL validation, Data Model Validations
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema
  • Extensive experience in client/server using System Testing, Functionality Testing (White &Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Data base Testing and User acceptance testing
  • Extensive experience with Data warehouse applications
  • Strong knowledge in Quality Centre
  • Experience in End-to-End testing with Jupiter Tool
  • Expertise in Problem solving and Bug Reports using Bug Tracking Tools
  • Strong skills in backend (in both Relational & Hierarchical database) testing Writing SQL queries, generating reports to ensure data integrity and validating business rules
  • Experience in working with Databases and using SQL, SQL Server, Oracle
  • Ability to handle multiple tasks and work independently as well as in a team
  • Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time
  • Has good knowledge in Selenium Python
  • Testing Tools: Quality Center100/90, Jira, Jupiter data validation studio tool, Beyond Compare tool, Note
  • Languages: HTML, SQL, Snowflake, Oracle, Sybase
  • Operating Systems: Windows 9x/2000/NT/XP, DOS, UNIX
  • Methodologies: SDLC, Agile
  • Databases: Oracle (SQLPLUS), SQL Server, MS Access
  • Data warehousing Tools: Informatica, Autosys

Timeline

ETL Tester

Citi Bank- Oasys Financial Services
01.2023 - 01.2024

ETL Tester

TIMS(Treasury Investment Management System)
01.2022 - 01.2023

ETL Tester

Pacific Life(USA)
03.2021 - 12.2021

ETL Tester

Sephora
03.2019 - 02.2021

ETL Tester

UWT Water Flood
01.2017 - 02.2019
Sasi Mohan