JEYABALAKUMAR ANNARAJ

***, ******** ***** *****, **********, CT-

06042

Mobile: acgl4u@r.postjobfree.com

CAREER OVERVIEW:

Experienced ETL Testing Analyst with diverse industry experience in INSURANCE and

HEALTHCARE. The Overall 6.8 years of experience with professional expertise includes project

estimation, Requirement Analysis, Test Strategy preparation, Test design, and Business scenario

preparation for data analysis, Test execution, defect management and support in all facets of Data

warehouse testing Lifecycle.

CAREER KNOWLEDGE:

Strong knowledge of Software Development Life Cycle (SDLC - Requirements Analysis,

Design, Testing, Implementation, Support).

Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence

reports testing.

Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies,

Defect Management to ensure Quality Assurance and to test all the business requirements

Experience in preparing test reports from Quality Center and prepared daily test status

reports to communicate the test status with the team.

Extensive testing ETL experience using Informatica (Power Center/ Power Mart)

(Designer, Workflow Manager, Workflow Monitor and Server Manager).

Excellent Knowledge of Database Systems – Oracle 11g, SQL server and Data ware

house concepts.

Extensive experience in developing SQL scripts to validate the databases tables and

reports data for backend database testing.

Proficient in troubleshooting database issues and experienced in using performance

monitor/profiler to solve dead locks/ long running queries.

Extensive Working experience in applying Relational Database Concepts, Entity Relation

diagrams and Normalization concepts.

Experience in Business Intelligence testing in various reports using Business Objects

Excellent Knowledge in Ms-Office (Word, Excel, PowerPoint), Ms-Access, MS Visio.

A very good team player with excellent Communication (Verbal and Technical),

Presentation and reporting skills.

TECHNICAL QUALIFICATION:

ETL Tools Informatica using UNIX

Business Intelligence Tools Business Objects

Database Teradata, Oracle

Test Management Tool HP Quality Center

Bug Tracking Tool HP Quality Center

Database Interface Tools SQL Developer, Toad

Database Languages SQL, PL/SQL

PROJECT EXPERIENCES:

Project Title New Business Vision

Duration May 2010 - Till date

Location Windsor, CT, USA

Role DWH/ETL Tester – Lead

Technology and Tools XML, Oracle DB, Informatica and Business Objects

Company Cognizant Technology Solutions

CLIENT DESCRIPTION:

The Hartford Financial Services Group, Inc. (NYSE: HIG) is one of the largest investment and insurance

companies based in the United States and is ranked 78 on the 2006 Fortune 100 list. The Hartford is a

leading provider of investment products – annuities, mutual funds, college savings plans – as well as life

insurance, group and employee benefits, automobile and homeowners' insurance, and business insurance.

PROJECT DESCRITION:

This project was initiated by Select Customer to drive more new business quotes and issues from engaged

and unengaged agents by providing an improved user experience. It includes; Deliver Real-Time

Bindable Quotes (Automated Underwriting) at an increasing rate over time while maintaining

profitability, Deliver an Easy, Predictable experience for Underwriter Referred Quotes Provide support for

proprietary and non-proprietary access, enabling anticipated business strategies. In addition to an

improved agent experience, the project will reduce new business processing costs, overall, inclusive of

responsible architecture choices to realize short and long-term objectives to maximize delivery, stability

and lower total cost of ownership

PROJECT RELEASES:

May 2011 - This new product was released for Workers compensation Line of business

April: 2013 - This new product was released for Spectrum Line of Business

May: 2014 - This new product was released for AUTO Line of Business

DATAWAREHOUSE IN PROJECT:

The major source data comes in XML format. All the transactions happening in Front End application by

users will be stored as XML CLOB in a relational table. As part of Data and Reporting perspective,

warehouse team has to stage raw Source into staging tables and then move it to Dimension/Facts models

to generate BO reports out of it.

Validating XML data by parsing it and comparing it against staging table History data.

Validating the dimensional and Facts data against the Staging data tables as per the business and

Functional Requirements

Validating the BO reports by running it against the Dimension area to ensure the BO reports data

are matching the End Business Customers need

ROLES AND RESPONSIBILITIES

• Assist Client project manager to define the project scope and schedule

• Manage end to end testing work for the DW distribution portfolio and lead the project team of

15 members to assign module/activity/tasks/deliverables

• Administrate project review, escalations, quality assurance, tasks’ completion, project

deliverables, customer interface & project status reporting for the project

• Provide technical know-how, support, mentoring & coaching team members on technology,

business & other project specific aspects

• Analyze and understand testing requirements from business requirement document, technical

requirement specs

• Analyze and review Informatica (ETL) mappings to understand the technical implementation of

business rules

• Design and document Data warehouse (EDW) testing strategy covering the test cases for

validating the data completeness and correctness, system performances of the ETL processes etc.

• Prepare test plan and work breakdown estimate

• Prepare the test cases for Summary/Detail testing, functional testing, regression testing,

performance testing, Stress, and End to End testing

• Construct test queries with multiple joins, indexes, temporary tables, analytical functions, and

sub queries linking by unions, intersection, and minus operators etc.

• Schedule and monitor the test cases execution

• Scheduling triage meetings to keep track and level of severity defects and communicating it

Project Managers with Execution Score Card with defect Status

• Run Business Objects Reports and validate Report data as per the Business user Requirements

• Log and publish the test results and raise the defects to the mantis defect/change management

system

•

Project Title Account Management Conversion

Duration May 2014 - Till date

Location Windsor, CT, USA

Role DWH/ETL Tester – Lead

Technology and Tools Oracle DB, Informatica and Business Objects

Company Cognizant Technology Solutions

•

PROJECT DESCRITION:

The Hartford Select customer User Interface application maintains all their USER Account and customer

related information in DB2 environment. As part of this project the all the Account information in DB2

are migrated into ORACLE environment. All the existing account information will be migrated in batch

process manner, and the customers with active policies in last five years are the key business data which

will be migrated immediately followed by others.

DATAWAREHOUSE IN PROJECT:

The DB2 data are loaded in Oracle Staging tables based on business requirements, and then data staged in

oracle tables are moved into various conversion tables. Initial bulk load have all the business priority

customers which would be migrated all the way from DB2 to Oracle Staging tables and then into

conversion tables. The data migration between oracle staging tables to conversion tables are extracted and

transformed using Informatica.

•

•

ROLES AND RESPONSIBILITIES

• Prepared QA estimation document and Test strategy document

• Creation of new queries based on requirements from users.

• Validated the data in Target and analyzed Business concepts in depth.

• Reporting the Validation errors to ETL team.

• Ensures the quality of data in Target from Source with multiple business scenarios.

• Reported Risks then and there to ensure the quality of data.

• Communicated with Clients & Users directly to understand the Business Requirements.

• Involved in Rebuilt of critical source systems and proposed many code changes.

• Reconciled data between existing DB2 and New oracle staging tables.

• Created Macros to automate the manual process like file & Table data comparison and

Referential integrity check based on primary key.

• Reconciled data flow between DB2 and Oracle new staging and reported the flaws.

• Conducted Defect walk through with the development team for clear understanding for defects

and to make it to closure.

• Responsible for providing the technical direction and guidance for the team members in

handling test scripts and software environments

•

Project Title Exadata Migration

Duration Nov 2010 – April2011

Location Chennai, India

Role DWH/ETL Tester

Technology and Tools Oracle DB, Informatica and Business Objects

Company Cognizant Technology Solutions

•

PROJECT DESCRITION:

The Data and Reporting Architecture inside Hartford was maintaining all the user level data and Policy

level transactions of various Line of Business in different environments like SuperDome and Teradata

until 2010. At 2010, The Harford Information Management team decided to move all their warehouse

databases into a Single Warehouse environment called Oracle – Exadata. This initiative step was initiated

then to improve daily load in warehouse 10 times faster than normal by utilizing 10 times more space in

new exadata server than earlier storage methodology.

DATAWAREHOUSE IN PROJECT:

All the Pricing and Policy premium details of Hartford were maintained in Teradata warehouse called

BKF-Business Knowledge Facility. All the databases objects like tables, views etc of BKF warehouse

were migrated oracle Exadata.

•

•

ROLES AND RESPONSIBILITIES

• Involved in Test strategy preparation and Test case Preparation

• Prepared a checklist having the count of tables, views and constraints of Source Database BKF

and had it ready before the migration schedule

• Uploaded all the business and Fucntional Requirements in Quality center

• Uploaded the test design documents in Quality center and Mapped it against the business

requirements

• Test execution involved validation of count and data between both Source Old database and

New database

• Create processes to ensure the data quality of the information collected

• Conducted Defect walk through with the development team for clear understanding for defects

and to make it to closure.

• Responsible for providing the technical direction and guidance for the team members in

handling test scripts and software environments

• Reported Risks then and there to ensure the quality of data.

• Involved in Rebuilt of critical source systems and proposed many code changes.

• Created Macros to automate the manual process like file & Table data comparison and

Referential integrity check based on primary key.

Project Title SITRIS PHARMA – SRT2104-007

Duration Feb 2008 – April2009

Location Chennai, India

Role Oralce Pl/Sql developer and Tester

Technology and Tools Open Clinica, Oracle Pl/Sql

Company ZIFO technologies Pvt ltd

CLIENT & PROJECT DESCRITION:

Sirtris is focused on discovering and developing proprietary, orally available, small molecule

drugs with the potential to treat diseases associated with aging, such as Type 2 Diabetes. The

project involved developing electronic Case Request Files, processing the data through UI,

Staging data in Oracle Tables and generating Business Case Reports

ROLES AND RESPONSIBILITIES:

• Involved in Preparation of LLD and HLD documents

• Involved in creating electronic Forms using Open Source Open Clinica.

• Involved in creating Pl/sql procedure and Functions as per the business conditions ensure the

user Data comes through electronic form is correct and accurate

• Creation of new queries based on requirements from users to ensure the data stored in database

are reliable and reportable

• Front end Validation Checks and Provide basic navigational & functional support to users

• Day-to-day Incident & Problem Management to ensure UAT satisfaction.

•

Project Title SHANTHA PHARMA – SHP2104

Duration MAR2009 – APR2010

Location Chennai, India

Role Oralce Pl/Sql developer and Tester

Technology and Tools Open Clinica, Oracle Pl/Sql

Company ZIFO technologies Pvt ltd

•

•

CLIENT & PROJECT DESCRITION:

The first Indian company to launch an r-DNA vaccine in 1997, Shantha heralded a new

beginning for biotechnology in India. In this project, we had managed an Entire Clinical

trail from Initial form design to Final Data Validation and t his project also involved

developing electronic Case Request Files, processing the data through UI, Staging data in Oracle

Tables and generating Business Case Reports

ROLES AND RESPONSIBILITIES:

• Involved in Preparation of LLD and HLD documents

• Involved in creating electronic Forms using Open Source Open Clinica.

• Involved in creating Pl/sql procedure and Functions as per the business conditions ensure the

user Data comes through electronic form is correct and accurate

• Creation of new queries based on requirements from users to ensure the data stored in database

are reliable and reportable

• Front end Validation Checks and Provide basic navigational & functional support to users

• Day-to-day Incident & Problem Management to ensure UAT satisfaction.

•

ACHIEVEMENTS:

• Cognizant Awarded ‘Act of Awesomist’ in 2013

• Harford Insurance Awarded ‘The Next Big Idea’ in 2012

• Harford Insurance Awarded ‘Best Team Player’ for NBV program in 2011

•

•

Contact this candidate