Senthil Priya Marthandan Mobile: 404-***-****

Email: acqhl0@r.postjobfree.com

Professional Summary:

Over 8+ years of experience in manual testing and data warehousing applications.

Having Good Knowledge on SDLC and STLC.

Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.

Knowledge in Database Testing.

Versatile experience in Cognos reports, cubes, extracts and DWH tables testing.

Good knowledge in Data Warehousing and Business Intelligence Testing using different tools like SQL, DataStage, Cognos.

Expertise in writing and executing test cases based on given software requirement specification and developed detailed Test Plan.

Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase.

Performed Functional testing, Integration testing, System testing, Regression testing, and Smoke Testing.

Experience in Manual Testing.

Experience in Problem solving and Bug reports using Defect Tracking Tools MQC (Mercury Quality Center) and Prolite.

Having Experience in Domains Banking-Finance.

Highly motivated, organized, able to work independently and able to switch between projects quickly.

Technical Skills:

Testing : Manual Testing, DWH-Testing, Report testing and ETL Testing.

Manual Testing : Functional testing, Integration testing, System testing and

Regression testing.

Defect Tracking Tool : MQC, Testdirector (Beginner), JIRA and Prolite.

Data Warehousing : SQL Server 2008, Teradata7.2, Cognos 10, Mainframe, Business Objects (Beginner) and DataStage (Beginner).

Operating Systems : Windows NT, 9x, 2000, XP, 2003 Server

Educational Qualification:

M.C.A (Computer Application) with 83% Avinashilingam Deemed University.

B.Sc (Information Technology) with 75% Bharathiar University.

Professional Experience:

Sr. ETL Tester

Genworth, Richmond, VA Nov`13 - Till Date

Genworth is one of the world’s largest leading mortgage banks. The primary objective of the project was to construct an aggregated data warehouse. As an ETL Tester I used to run the test cases for the end to end process in that data warehouse. Involved in Functional Testing, User Interface Testing, Multiplatform Testing.

Roles & Responsibilities

• Identifying field and data defects with required information in ETL process in various jobs and one to one mapping.

• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

• Created the test environment for Staging area, loading the Staging area with data from multiple sources.

• Extraction of test data from tables and loading of data into SQL tables.

• Validated the data in the reports by writing simple to complex SQL queries in the transactional system o

• Executed the Test cases for Cognos.

• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns.

• Oversaw the historical loads in UAT and PROD environments.

• Also worked on Integration of all the processes in UAT/PROD.

• Optimizing/Tuning several complex SQL queries for better performance and efficiency.

• Prepared the test cases after thorough analysis of each requirement.

• Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.

• Conducted and actively participated in reviews, walkthroughs of test cases.

• Reviewed the ETL mappings to ensure the transformation rules are applied correctly.

• Created and executed SQL queries to perform source to target testing on Oracle database. Performed the following tests:

DATA COMPLETENESS

VALIDITY

UNIQUENESS

DATA INTEGRITY

DATA TRANSFORMATION

DATA QUALITY

INITIAL AND INCREMENTAL LOAD TESTS

• Coordinated with different users in UAT process.

• Performed Unit testing for all reports and packages.

Environment: Oracle9i, HP QC 9.0/11, SQL, Cognos 7.0 Series, WindowsXP/2000 and UNIX

ETL/SQL Tester

JP Morgan Chase, Wilmington, DE May`11 - Aug`13

JP Morgan Chase is one of the world’s largest leading mortgage banks. The primary objective of the project was to construct an aggregated data warehouse for analytics and reports used by business, risk management, asset management groups.

Roles & Responsibilities

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.

• Defined data requirements and elements used in XML transactions.

• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.

• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.

• Validating the reporting objects in the reporter against the design specification document.

• Validating the data files from source to make sure correct data has been captured to be loaded to target tables

• Extensively used Cognos to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata

• Reviewed Cognos mappings and test cases before delivering to Client

• Written Test Cases for ETL to compare Source and Target database systems.

• Extracted data from various sources like Oracle, flat files.

• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos .

Environment: Oracle8i, SQL, Cognos 7.0 Series, WindowsXP/2000 and UNIX

DWH/SQL/ETL Tester

Allstate Insurance, Chicago, IL Feb`10 - Mar`11

The application is to get online quotes and purchase for auto and property insurance in different states of US. It involves both commercial and personal insurance. It is a complete online e transaction application involving customers, agents and call center through direct or mutual interaction.

Roles & Responsibilities

Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.

Analyzing requirements and creating and executing test cases

Involved in ETL process testing using Cognos ETL tool.

Test Case Execution and Adhoc testing

Performed Integration, End-to-End, system testing

Involving in Functional Testing & Regression Testing

Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using LoadRunner

Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews

Performed data validation testing writing SQL queries.

Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.

Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.

Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Cognos.

Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results

Environment: SQLServer 2000, Teradata V2R6, Crystal Reports, Oracle 8i, Microsoft Business Intelligence, MS Excel, Flat Files.

QA Tester

UBS, Weehawken, NJ Feb`09 - Jan`10

UBS is one of the world`s leading financial firms comprising of wealth management, global investment banking and global asset management tools. It is used for creating journals for both cash and security transactions. Service Works is a web-based application developed for managing bank services for clients. It provides investment banking and global asset management tools. It is used for creating Journals for both cash and security transactions

Roles & Responsibilities

Involved in the meeting with business analysts and Marketing team for requirement gathering in Definition Stage.

Gathered and Analyzed Functional and Performance requirements.

Involved in project planning, coordination and implemented QA methodology.

Extracted test data by understanding relational database design diagrams Created.

Designed, Created and executed manual Test Cases.

Reviewed Test cases for automation and provided inputs about the scope of Automation.

Prepared documentation about the automation suite architecture.

Peer Review of the scripts and made recommendations for updates if any.

Performed extensive backend testing by writing Complex SQL queries.

Setup the Performance test environment with the support of technical team.

Response time, throughput, hits per second, etc were studied by graphs and reported.

Created manual & automated test cases for testing web services.

Used Test Director for storing, maintaining the test repository, bug tracking and reporting

Prepared documentation for some of the recurring defects and resolutions and business comments for those defects

Assist QA Team with defining and implementing a defect resolution process including defect priority, severity, next steps, and assigned owner

Environment: Windows XP, SQL*Plus, Oracle 8i, MS Office Suite, SQL Navigator.

ETL Tester

Lloyds TSB Banking Group, Accenture, India June`08 - Jan`09

Roles & Responsibilities

Analyzing the user specification/Client requirement documentation

Prepared and reviewed detailed test scenarios and test cases covering the mappings and Reports.

Reports creation and data validation.

Execution of test cases and defect tracking through Quality Center

Involved in collection of test metrics

Participated in review meetings and status meetings

System testing of the application and raised maximum number of defects.

Identified design flaw and got good appreciation from client.

Update testing status to client in client meeting on daily basis.

Environment: SQL, PL/SQL, UNIX and Mercury Test Director.

Manual Tester

Sterling Integration Factory, IBM, India Jan`07 - May`08

Roles & Responsibilities

Proof of concept development for Back Ground Reports Module.

Involved in preparation of test cases.

Involved in Functionality Testing and Regression Testing.

Testing manually all the Screens for Privileges of user.

Effective Coordination between Development team and testing team.

Environment: Spring - Hibernate, JBoss Application Server, SQL and Mercury Quality Center 9.0

Contact this candidate