ETL TEST LEAD
Resume:
JEYABALAKUMAR ANNARAJ
***, ******** ***** *****, **********, CT-
06042
Mobile: *****************@*****.***
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