Summary

Over 7+ years of IT experience, in Manual and Automated testing on web applications. skills, Data warehouse testing, Client-Server, Database migration and Database testing.
Good understanding of ETL Test Processes and Test Methodologies.
Extensive experience with the Bug tracking systems, source code/version control systems, bugs reporting, root cause analysis, documenting the test results, meeting the delivery schedules.
Proficient in Data warehouse and Backend application Testing Life cycle.
Proficient in SQL, PL/SQL, Procedures/Functions, Triggers and packages
Strong understanding of Test Methodologies and Test Plans in Project Life Cycles.
Experience in preparing Test strategy, Developing Test plan, Test cases, Writing test Scripts by Decomposing business Requirements and Developing Test scenarios to support quality deliverables.
Experience in UNIT Testing, Integration Testing, System Testing Functionality, Regression, Performance Testing and User Acceptance Testing.
Good Knowledge in Financial, Health, Insurance and Telecom Applications.
Excellent knowledge in Mercury, Rational automated testing tools like Win Runner, Test Director, Load Runner and Clear Quest
Good at Unix Shell scripting and Automation of ETL process.
Involved in Integration Testing, System Testing, Performance Testing, Functionality Testing and Regression Testing.
Proficient in Data Warehouse testing like Control Mechanism of batch loads, Error/ rejected records processing, testing of SCD implementations and process dependencies.
Hands on experience in Cognos BI Suite Cognos Report Net, Cognos Impromptu, Access Manager, Cognos Power Play, Power Play Enterprise Server, Cognos Query, Cognos Upfront, Cognos Visualizer, Impromptu Web Reports, Cognos Scheduler.
Solid and hands-on experience in designing, developing and maintaining test plans.
Good sense of teamwork, leadership quality, integrity, aptitude to learn and ability to put in sustained quality effort consistently.


Employment

July, 2007 -  July, Present
Quality Assurance Analyst

The objective of Humana Enterprise Data Warehouse is to provide a holistic picture of its customers, target sales and marketing efforts and to equip business users with complete information by integrating data from all the divisions.

Responsibilities :
Reviewed business requirement documents and technical specifications.

Documented Test Cases corresponding to business rules and other operating conditions.
Carried out ETL Testing using Informatica.
Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
Executed sessions and batches in Informatica and tracked the log file for failed sessions.
Write SQL queries to validate that actual test results match with expected results
Check the naming standards, data integrity and referential integrity.
Responsible for monitoring data for porting to current versions.
Analyzed and tested various Hyperion reports for Hierarchies, Aggregation, Conditions and Filters.
Checked the reports for any naming inconsistencies and to improve user readability.

Compared the actual result with expected results. Validated the data by reverse engineering methodology ie backward navigation from target to source.

Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Preparing Defect Reports and Test Summary Report documents.

Checking the status of ETL jobs in UNIX.
Interacted with Business Analyst, Database Administrators, development team and End Users.

Environment : Teradata V2R5, DB2, Hyperion, SQL, PL/SQL, Flat files, Informatica 8x/7x, Quality center 9.0, SQL Assistant 7.2, UNIX, Autosys, Test Manager, Clear case, ClearQuest.

October, 2005 -  June, 2007
Backend Tester

Nielsen Media Research provides media ratings for local and National TV channels by their patented methods for gathering viewing information. The goal and movement of data from enterprise Data warehouse EDW various data marts and generation of various data warehouse Reports.

Responsibilities :
participated in meetings with business customers to gather the requirements and business naming conventions.
Responsible for testing multiple projects Financial, Sales, Retirement and Savings, Campaign and Marketing in the Enterprise Data Warehouse.
Involved in project planning, coordination and implementation of QA methodology based on the Business requirement and Design documents.
Used the most comprehensive approach of data warehouse testing. ie, validating the data at each transformation ; first the Source tables staging tables, then the loading tables and finally the destination tables.
interacted with System Analysts and the Development team on system-investigated requirements and in resolving issues
Incremental development/testing of Enterprise Data Warehouse.
Debugging and Scheduling Informatica Jobs/Informatica Mappings and monitoring error logs.

Wrote complex SQL s validate target data based on the business requirements.
Used PL/SQL programs for performance testing.
Implemented data verification procedures for ETL processes in load testing.
used SQL and PL/SQL scripts to perform backend database testing.

Used Test Director for bug tracking and reporting, followed up with development team to verify bug fixes and update bug status.
Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings

Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
Effectively distributed responsibilities, arranged meetings and communicated with team members in all phases of the project.
Involved in Integration testing, Functional testing and Regression testing.
Checked for any inconsistent joins and resolved loops in the catalog.
Involved in the validation of the OLAP Unit testing.
Involved in the System Testing of the OLAP Report Functionality and data displayed in the reports.
Validating fields present in the reports are as agreed in the specifications.
Validated drill down features of reports.
Arranged meetings with business customers in better understanding the reports by using business naming conventions.
Analyze system issues and prepare business and technical requirements documents using established CMM level 2 standards.

Environment : Oracle 9i, Sybase 12.5 SQL Server 2000, DB2, Test Director, Informatica 7.x, Cognos Series 7.x, SQL, PL/SQL, Windows 95/NT/98/2000/XP, Sun Solaris 8.0, Excel, Access, Word, StarTeam 5.0, Lotus Notes 5.0.8

July, 2003 -  September, 2005
ETL Tester

A 3 - Tier Architecture application that enables customers to view their agreements Insurance, Mutual Fund and Bank on the internet. The application has multiple data stores involved over the entire country. The objective of this project is to implement the Data Warehouse testing life cycle in the Enterprise Data Warehouse which include Unit testing, Integrate testing, Functional testing, System and Acceptance testing, Regression testing and performance testing.

Responsibilities :
participated in meetings with business customers to gather the requirements and business naming conventions.
Converted requirement documents to mapping documents.
Worked with heterogeneous sources from various channels like Oracle, DB2, SQL Server and flat files.

Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like SQL Server, DB2 into the Oracle target database.
Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
Created and scheduled Worklets. Setup workflow and Tasks to schedule the loads at required frequency using Workflow Manager.
worked in the performance tuning of the programs, ETL Procedures and processes.

Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
Implemented various integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships.
Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.

Identified and Documented additional data cleansing needs and consistent error patterns that could diverted by modifying ETL code.
interacted with System Analysts and the Development team on system-investigated requirements and in resolving issues.
Debugging and Scheduling Informatica Jobs/Informatica Mappings and monitoring error logs.
Worked with a team of Systems Analysts and Programmer/Analysts to determine success or failure of tests.

Used Test Director for bug tracking and reporting, followed up with development team to verify bug fixes and update bug status.

Created Test Log Status reports using Test Director.

Environment : Informatica 7.1.2 Oracle, DB2, SQL Server, SQL, PL/SQL, SQL *Loader, Access, Toad, Win sql, Unix AIX, Test Director, Business Objects 6.x.

October, 2001 -  June, 2003
Data Warehouse Tester

Education

Skills
Testing Tools Test Director 7x, Quality Center 9.0, Fitnesse, Bugzilla. ETL Tools Informatica Power Center 8x/7x/6.2/5.1.2, Datastage 7x Reporting Tools Business Objects XI r2/6x/5x Hyperion, Cognos 7x, Crystal Reports XI Databases Oracle, Teradata V2R4, DB2, SQL Server 2000/2005 GUI's Visual Basic 5.0/6.0, Power Builder 5.0 Languages C, COBOL, Java, Perl, Visual Basic, SQL, PL/SQL Scripting Languages Shell Scripting, ksh, Java Script, VB script, XML Operating Systems Sun Solaris 8.0, Windows NT/2003/XP, MVS Utilities TOAD, Dbvisualizer, FTP Explorer, SQL*Loader, Load scripts, Synkronizer for Excel 8x Version Control tools Visual Source Safe, PVCS, Starteam, Rational ClearCase
Unisys is a worldwide information technology services and solutions company. They are present in more than 100 countries. The Systems and Technology Group at Unisys Corporation implemented a data warehousing system to gather all the information related to their sales in different countries in order to track and forecast sales. Extensive reporting was done on queries pertaining to sales revenues and marketing data. Responsibilities : involved in System Study and Business Requirements Analysis. Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations. Tested the data and data integrity among various sources and targets. Associated with Production support team in various performances related issues. Used the Debugger to run Debug sessions setting Breakpoints across instances to verify the accuracy of data. Participated in meetings with developers to improve mapping and session s performance. Tuned and tested the mappings to perform better using different logics to provide maximum efficiency. Checked ETL s for accessing and picking up right data from right source. Performing SQL query optimization using hints, Indexes and Explain plan. Verified whether data transformations are correct according to the business rules and data warehouse is populated with the transformed data. Testing the rejected records that don t fulfill transformation rules. Incremental loading of records at a later date to verify the inserted or updated data. Checked for missing data, negatives and consistency. Field-by-Field data verification is done to check the consistency of source and target data. Provided technical assistance by responding to inquiries regarding errors, problems or questions with programs/interfaces. Checked for data integrity between the various source tables and relationships. Logged defects in Lotus Notes defects database and assigned to the concerned person. Conducted collaborative sessions with developers and business analysts to discuss on open issues. Validated and closed defects after changes were done to the code.
Informatica, Lotus Notes 5.0, Oracle9i, DB2, SQL, PL/SQL, Toad, Test Director, Windows 2003


Miscellaneous
Bachelor of Engineering in Computer Science and Applications.