ETL tester

Visalakshi Manikandan

Experience Summary

Visalakshi has over 10 years of experience in the software industry and has over 5 years of experience in ELT Testing. She is well versed in taking the responsibility and delivering the product. Over the years, she has played a major role in all the phases of software Testing life cycle. Visalakshi has proven abilities in areas of requirement gathering, Test case designing, Quality Reviews, functional testing, and Data migration testing. She has experience in ETL/database testing particularly on core data warehousing projects using Informatica and other ETL tools like Microsoft SSIS.

She has worked very closely with customer stakeholders, development teams, and end users during her experience. She has worked on clients such as TRS (Teachers Retirement System),Bank of Tokyo (MUFG), Yum Brands, JPMC, Citizens Bank and Mylan India (erstwhile Star Drugs).

Work Authorization

US Permanent Resident - Green Card Holder

Education and Certifications

Title of the Degree with Branch

College/University

Year of Passing

B.Sc., (Computer Science)

AKC College / Madras University

2002

MCA (Masters in Computer Applications)

IGNOU

2007

SAS Base Certification

SAS

2015

Technical Skills

Hardware / Platforms

Win XP, Windows server 2003, Windows server 2008, Windows server 2010, Windows 7

Database

Oracle 9i/11g,SQL Server 2000/2005/2008,

Programming / Scripting Languages

T-SQL, PL/SQL Programming, DB2,UNIX shell scripting, Visual Basic, C#.Net

Databases Tools

PL\SQL Developer,TOAD, Informatica PowerCenter 8.6

Other Utilities

Business Objects XI3, Cognos Reporting, Quality Centre 10.0,HP ALM

Relevant Project Experience

PROJECT # 1:-

Client

Teacher’s Retirement System – New York

Project Name

Pension System Modernization

Location

New York City, NY, USA

Duration

From September 2015 to Till Date

Tools and Technology

SSIS, SQL, Trillium

Project Description

Teachers Retirement System of the City of New York is a public pension fund that provides New York City educators with retirement, disability, and death benefits. TRS is currently the second largest New York City pension system.

TRS was using AS400 for their pension system and wanted to migrate to a more robust application with enhanced reporting capabilities. TRS decided to develop an enhanced ASPEN (Agile Straight through Processing PENsion) system and migrate the data to MS SQL Server by utilizing the MS SSIS package.

Data was planned to be migrated from UPS (Old system) to ASPEN in various phases and various forms of migration and bridging.

Role

ETL Tester

Responsibilities

Involved in design and development meetings with the design team and the development team.

Extensively used SQL to test the enhancements to the current ETL programs based on the new and changing requirements.

Developed SQL queries on data staging tables and data warehouse tables to validate the data results.

Develop SQL queries to validate if the actual test results match with expected results

Tested various job sequences by identifying flows with proper rollback strategies incorporated in the sequences.

Developed Trillium queries and tested Trillium reports

Reported the bugs to developers and tracked them to closure by using TFS

Performed ETL testing, validating jobs statistics in SQL database.

Created Job Sequencer for dependency jobs and to run the jobs by using parameters.

Executed the project using Agile (Scrum) methodologies

Developed SQL Stored Procedures and Queries for Back end testing.

Reviewed the Log for the jobs and tracked the status of jobs.

Detailed repeatable end to end test cases for application, interviewed developers to gain detailed information on complex calculations and backend exception processing in order to validate the back end utilizing SQL Plus.

Experienced in creating the SSIS packages, DTS packages.

Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules.

Used the partitioning techniques in most accurate way for increasing the speed of job execution

Played a key role in UAT. Tested jobs running in production environment with min downtime.

Verified the result by writing complex SQL queries on various databases.

Tested and run the test cases using HP ALM

Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.

Coordinated with QA Testing Team to test various test scenarios involving Test Plans, Test Cases, and Test Scripts.

Performed all aspects of verification, validation including functional, structural, regression, and system testing.

Created and managed regression suites for all projects.

PROJECT # 2:-

Client

Bank of Tokyo (MUFG)

Project Name

Core Banking Replacement

Location

Jersey City, NJ, USA

Duration

From December 2014 to September 2015

Tools and Technology

Business Objects, Informatica, Oracle 11g, Toad, SQL

Project Description

MUFG had its Core Banking System on legacy technology and it was unable to architecturally scale to accommodate the new features and functionality requirements arising with the growing business demands. MUFG decided to modernize the Core Banking System with a centralized platform for Treasury, Loans, and Deposits. The solution is OVS Hybrid+. OVS is the global overseas system of BTMU that has already gone live in European and Asian branches.

OVS was planned to be implemented as the core application of the US Core Banking System in a fully integrated environment e.g., GPP, Loans, Trade360, Oracle G/L, Data Warehouse, Payment Processing, Check Processing, Treasury.

Role

ETL Tester

Responsibilities

I perform the role of an ETL tester in the project and my responsibilities includes the following:

Requirement Analysis of the Project Documents provided by client and Understanding the Functional Specification.

Contributed towards developing test plan and test cases

Used HP ALM for Test Planning, writing Test Scripts, creating Test cases, updating Test Results, generating Reports, tracking and analyzing Defects and bug reporting.

Involved in Functional System Testing, Data Validation, and Regression Testing.

Developed complex SQL queries for ETL testing

Used Informatica Power Center Workflow manager to create mappings, sessions, Worklets & workflows to Test the business logic.

Recorded the sequence of actions / inputs that lead to a test case failure for quick debugging

Performed System and Integration Testing, Regression Testing, and UAT

Collaborated with the development team and Data Warehouse teams to explain the failed test cases

Interacted with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Closely worked with the reporting team to ensure that correct data is presented in the reports.

Wrote SQL queries for various test cases based on the mappings, verified and validated the data values

Tested several Business object and DVO (Data Validation Option) reports

PROJECT # 3:-

Client

Yum Brands

Project Name

Saba LMS Migration

Client Location

Louisville, KY

Working Location

Srushti Solutions, Chennai, India

Duration

From July 2012 to September 2014

Technology

Informatica, Oracle 11g, Cognos, HP ALM, Saba Learning Management System (LMS), SQL, PL/SQL, Toad

Project Description

Yum Brands had implemented Saba LMS to manage their enterprise learning needs. They had different instances of LMS implemented for each of the brands such as Pizza Hut, KFC, and Taco Bell. Saba decided to consolidate the individual instances of the LMS into a consolidated Saba platform. The project involved migrating large volume of user data and training history data.

Role

ETL Tester

Responsibilities

I performed the role of an ETL tester in the project and my responsibilities included the following:

Requirement Analysis of the Project Documents provided by client and Understanding the Functional Specification.

Provided inputs for creating test plan and test cases

Used HP QC for writing Test Scripts, creating Test cases, updating Test Results, generating Reports, tracking and analyzing defects and bug reporting.

Followed Agile / Scrum process

Involved in Data Validation, Regression Testing, and dip-stick functionality testing to confirm effective multilingual data migration.

Developed SQL queries and PL/SQL for ETL and backend testing

Performed System and Integration Testing, Regression Testing, and UAT

Used Informatica Power Center Workflow manager to create mappings, sessions, Worklets & workflows to test the business logic.

Recorded the sequence of actions / inputs that lead to a test case failure for quick debugging

Collaborated with the development team and Data Warehouse teams to explain the failed test cases

Interacted with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

Closely worked with the reporting team to ensure that correct data is presented in the reports.

Developed simple reports using Cognos for validation purposes

PROJECT # 4:-

Client

JPMC

Project Name

Card Linked Marketing Platform

Client Location

Columbus, OH

Working Location

Srushti Solutions, Chennai, India

Duration

From October 2011 to June 2012

Technology

Informatica Power Center 8.6/9, HP ALM, Business Objects, Oracle 10g, PL SQL, Toad

Project Description

The project involved developing Macro programs to gather data based on marketing campaigns for various card products. These datasets were directed towards being used for capturing new customers through direct mail and telemarketing. Credit card representatives used it for giving specifically directed offers to various sects of new and existing card members. My role was to test the data that is being migrated from different pointed applications into a common Data Warehouse.

Role

ETL Tester

Responsibilities

Understanding the requirements and the Functional Specification provided by the client.

Used HP QC for recording Test cases, Test Results, tracking and analyzing defects and bug reporting.

Involved in Data Validation and Regression Testing

Developed SQL queries and PL/SQL for ETL and backend testing

Performed System and Integration Testing, Regression Testing, and UAT

Recorded the sequence of actions / inputs that lead to a test case failure for quick debugging

Ensured that the quality of data flow from multiple systems is retained in the target

Collaborated with the development team and DB teams to explain the failed test cases

Interacted with the client on various forums to discuss the status of the project, clarify any queries regarding the functionality etc.

PROJECT # 5:-

Client

Citizens Bank

Project Name

Money Markets Platform

Client Location

East Providence, RI

Working Location

Srushti Solutions, Chennai, India

Duration

From July 2010 to September 2011

Technology

Informatica, Oracle, SSIS, MS SQL Server 2005/2008, BO Reporting /Functional Testing

Project Description

This project involves extracting huge amount of data from different databases and text files, performing business rule validation on data and loading valid data into database.

There are number of applications which form part of the system to collect, analyze and report business data into databases and various files. The Technologies involved are Informatica, Oracle, and SQL Server 2008.

Role

ETL Tester

Responsibilities

Created test cases to validate mappings and sessions for enhancements of data warehouse by extracting data from sources like Oracle and Delimited Flat files.

Testing of ETL using Informatica Power Center.

Validated slowly changing dimensions like Type 1 and 2 effectively to handle the delta Loads.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Used various transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Lookup, and Update Strategy.

Written documentation to describe, testing, changes and corrections.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Identified problems in existing data migration and tested fixes through one time scripts.

PROJECT # 6:-

Client

Mylan, India (erstwhile Star Drugs before acquisition)

Project Name

Multiple Projects (Custom CRM Application, Manufacturing Practices Reporting, Financial Reporting, etc)

Location

Hosur, India

Duration

From August 2003 to January 2008

Technology

Visual Basic 6, Crystal Reports 8, SQL Server, C#.Net,

Project Description

Involved multiple small custom application and reporting development activities pertaining to pharma protocols and financial aspects

Role

Programmer

Responsibilities

Understanding business requirements and creating Requirements and Functional Specifications document

Creating detailed design document, application architecture, and database design based on requirements and specifications

Developed multiple custom applications to cater to business needs using Visual Basic, C#.Net, and SQL Server

Developed multiple business, financial, and manufacturing practices-related reports using Crystal Reports.

Created test cases and test scenarios and executed them to ensure quality of deliverables

Created detailed test reports for pharma compliance needs

Contact this candidate