Mangaleswari Sethukarai

Mobile : 551-***-****

Email : adb3rv@r.postjobfree.com

PROFFESSIONAL SUMMARY

●Having 8.5 Years the field of Software Quality Assurance in ETL & Informatica Testing

●Analyzing the Source to Target, Detailed Design Specification Docs, Small Work Request

●Prepared Test Plan for SWR – Projects.

●Experience in analyzing the source data (Source File Validation)

●Experience in Teradata/Oracle SQL.

●Experience in Data warehouse concepts

●Experience in Data integrity between all the ACCT related tables in the Warehouse.

●Conducting meeting with Data Modelers for Discuss the Data Modeling

●Conducting meeting with Source System to discuss the Scenarios which required for System Testing

●Prepared system test cases for Source File Validation

●Preparation of System Test Cases for S2T – Source to Target Transformation Rules

●Prepared Non-Functional Test Cases to test Data Watcher Script, T-Pump load, Multi Load and

AutoSys jobs.

●Doing Shakedown testing and circulating Shakedown report

●Co-coordinating with development team to Set the ST Environment and get the Grants

●Prepared effective SQL’s in order to cover all the business transactions are stored into target database

●Having fair knowledge on Executing the Jobs, Holding Jobs in Unix Server.

●Uploaded Test Cases into HP-QC 9.2 and executed the test cases from QC.

●Prepared Customized reports in HP QC – Analysis Module for Execution Reporting purpose.

●Prepared Defect Analysis Report and Test Recommendation reports.

TECHNICAL SKILLS

Software Testing Tools

Control M, Dialogue, HP ALM, HP QC 10.0, HP QTP V 10.0, Informatica - ETL jobs

Operating System

Windows – NT, Windows – 9X, XP, 20XX, Win7

Languages

C, C++, VB, VBA

Database

Oracle 9i, SQL Server

Bug Tracking Tools

PMSmart

Tools Used

HP-QC9.2,10,11 and Teradata Client, WinScp

Education :

B.Sc in Madurai Kamaraj University, India - April, 2001

BA in Computer Science, HCC, NJ - Dec, 2018

Project 01 : SMART System

Client : DSNY (Department of Sanitation, NYC)

Apr 2015 to till date

Role : DWH Test Analyst

Team Size : 10

Testing Method: : System Testing

Tools Used : HP ALM, SQL Developer, Teradata Client, Informatica Power center

Project Description

●Work closely with software developers/project owners and BAs to develop and execute thorough test suites in all phases of the software development cycle

●Develop Test strategy, test plan/design, execute test cases and defect management for the ETL & BI systems

●Develop and execute detailed ETL related functional, performance, integration and regression test cases, and documentation

●Analyze and understand the ETL work flows developed

●Quality Management - Knowledge of quality management methods, tools and techniques

●Create UNIX shell scripts to access and move data from production to development environment

● Worked as QA engineer and involved in Functional Testing, Regression Testing, System Testing, Defect Triage, Status Reports.

● Proficient in web services testing using SOAP AND REST API and databases ORACLE

● Worked on test management tools like HP QC ALM, JIRA, CONFLUENCE, Bitbucket and to debug logs Kibana-logstash.

● Working on very highly challenging environment with typical agile methodology, application is breaking up the monolithic architecture of SMART

Project 02 : Electronic Cancer Checklists (eCC).

Client : College of American Pathologist – Northfield, Illinois

June-2009 to Mar-2012

Role : DWH Test Analyst

Team Size : 9

Testing Method : : System Testing

Tools Used : HP ALM, SQL Developer, Teradata Client

●Outline how the source extract data file feeds will be managed. Including file validation, file naming convention, data validation and other service level requirements.

●Detail POC Data Mart load process including non-functional requirements

●Providing a simple application process through online and mobile apps – the quickest in the market and minimal paper.

●Allowing customers to choose pre - set bundles of cover or choose levels of cover to suit themselves.

Project 03 : Proactive Outbound Calling – POC Reporting DataMart Load

(Source Table to DIMN & FACT Table)

Client : CommonWealth Bank of Australia, Chennai – Offshore – 8 Months

June-2008 to Jan-2009

Role : DWH Test Analyst

Team Size : 4

Testing Method : : System Testing

Tools Used : HP ALM, SQL Developer, Teradata Client

Project Description

The Purpose of this POC Data Mart Load DDS is to:

●Provide an Overview of Source System

●Provide a complete list of extract files produced from source system to POC Data Mart and their structure including format and metadata

● Define any standard header/trailer records

●Outline how the source extract data file feeds will be managed. Including file validation, file naming convention, data validation and other service level requirements.

●Detail POC Data Mart load process including non-functional requirements

●Provide supporting documentation to S2T mapping which operates at field level

Project 04 : Project Advance Notice Assessment – High Value Accounts into GDW

(SAP ODS data to GDW tables – Existing Load Enhancement)

Client : CommonWealth Bank of Australia, Chennai – Offshore – 8 Months

Oct-2007 to May-2008

Role : DWH Test Analyst

Team Size : 4

Testing Method : System Testing, WinScp

Tools Used : HP ALM, SQL Developer, Teradata Client

Project Description

The Bank introduced a new Advance Notice solution leveraging the existing core banking platform to address the upcoming regulatory changes. The proposal will be to create a new Advanced Notice Account (ANA) product which gives customers the ability to deposit funds for specific pricing, and where the funds can be withdrawn after a specified period (proposed to be 35, 60, 90 and 180 days) and priced at a different rate, depending on the Notice Period. The business will need to track, measure, and report on the usage of the new ANA product. ANA program will agree with each business group for the day to day reporting for ANA.

Project 05 : Project Simple Life – Insurance data into GDW

(SAP Files to GDW tables – Teradata Control Framework)

Client : CommonWealth Bank of Australia, Chennai – Offshore – 9 Months

Jan 2007 to Sep-2007

Role : DWH Test Analyst

Team Size : 4

Testing Method : System Testing, WinScp

Tools Used : HP ALM, SQL Developer, Teradata Client

Project Description

Simple Life is a CommInsure Direct Life initiative that is aimed at revolutionising Direct Life Insurance in Australia through its simplicity of design and speed of purchase. The project will enable the business to launch a new bundle of Life Insurance benefits within a simple and transparent design by:

Developing a simple way to communicate our propositions with customers to remove the mystique and complexity created by the insurance industry.

Providing a simple application process through online and mobile apps – the quickest in the market and minimal paper.

Allowing customers to choose pre-set bundles of cover or choose levels of cover to suit themselves.

Project 06 : ATM Over Drafts – File Extracts

(Source File to Target Table to File Extracts)

Client : CommonWealth Bank of Australia, Chennai – Offshore – 15 Months

Oct-2005 to Dec-2006

Role : DWH Test Analyst

Team Size : 4

Testing Method : : System Testing,WinScp

Tools Used : HP ALM, SQL Developer, Teradata Client

Project Description

GDW is only loading Personal Overdraft data from CommSee. CommSee is sending the data of Branch Personal Overdraft application. PCE is a new Data Source for GDW which will include data of Temporary Personal Overdraft offered by ATM. PCE data is required to be loaded into GDW Integrated Model which will be able to link with CommSee and CTS data. Business Users will access Personal Overdraft data.

Project 07 : Project MRD – Merchant Reference Data

(3 Source Systems + Group Reference to GDW)

Client : CommonWealth Bank of Australia, Chennai – Offshore -17 Months

May-2004 to Sep-2005

Role : DWH Test Analyst

Team Size : 4

Testing Method : : System Testing,WinScp

Tools Used : HP ALM, SQL Developer, Teradata Client

Project Description

Merchant Reference data project has come in scope to build a GDW space to capture the CBA- Clients and their merchant level information. There are 3 different streams are capturing the Merchant level data. CBA wants to be located in one place to see the Merchant Transaction level. So they have built a GDW space to load the Merchant level data from 3 different source using the Group Reference data as one more source.

Contact this candidate