Data Quality Assurance

SUMMARY

. *+ years of experience in the IT industry including manual testing, ETL

testing,

. Good understanding of various SDLC (Software Development Lifecycle)

methodologies such as Waterfall and Agile.

. Expert in writing SQL for data validation.

. Good understanding of entire Data Warehouse Architecture, data models

such as Star Flake, Snow Flake Schema and Data Marts. All types of Slowly

Changing Dimensions and ETL testing Workflow process.

. Experienced in DW projects ETL testing against DW testing with

Informatica, Ab Initio and Data Stage tools.

. Experience in testing web applications using Quick Test Pro (QTP).

. Experience in testing XML files and validating the data loaded to staging

tables.

. Extensively used ETL methodology in testing for supporting data

extraction, transformations and loading processing, in a corporate-wide-

ETL solution using ETL tools like Informatica

. Extensive experience in Analyzing Functional Specifications and

developing Test plans, Test cases, Test estimation, execution of Test

scenarios, analyzing the Test results.

. Expertise in testing EDI Transactions 834, 837, 835, 270/271 & 276/277 .

. Experienced in querying the databases by developing and running SQL

queries using utilities like TOAD and SQL Query Analyzer.

. Involved in all types of testing including System, Functional,

Integration, Regression, and helping out with User Acceptance Testing.

. Experience in testing XML files and validating the data loaded to staging

tables.

. Experienced in testing Cognos, Crystal Reports, and Business Objects

Reports.

. Hands on experience in writing test scripts, preparing test data, testing

Data Stage.

. Extensive experience with Utility Tools like SQL Developer, SQL*Plus,

TOAD.

. Familiar with managing the defects and change requests using testing

tools like Quality Center, Clear Quest.

. Proficient in creating UNIX Shell Scripts

. Strong experience in writing complex SQL Queries for different Databases

such as DB2, Oracle, Teradata, and SQL server (T-SQL).

. Good Experience in QA Methodology and Validations to ensure industry

standards.

. Strong problem solving, interpersonal and communication skills.

SKILLS:

Operating Systems :Windows 2000/NT/7, UNIX, LINUX

Defect Management Tools :HP Quality Center 10/9.2/Test Director, QTP,

Remedy,

Clear Quest

Databases :Oracle 8i/9i/10g/11i, MY SQL, DB2, MS Access,

Teradata

Language :PL/SQL, SQL, HTML, XML, Java, JSP, AWK,

C

Data Warehousing :Informatica, Data Stage, Ab Initio, Business

Objects, Cognos Report

Net,Crystal Reports

Oracle Products :Developer 6.x, Designer 6.x, SQL Plus

Version Control tool :PVCS, CVS

Cigna Health Care, Bloomfield, CT FEB-12

- Nov-13

QA Analyst/ETL Tester

Responsibilities:

. Designed and Created test plan, test scenarios and test cases for Data

warehouse and ETL testing.

. Responsible to translate business requirements into quality assurance

test cases. 

. Review of test scenarios, test cases and Data warehouse Test

Results. 

. Developed test scripts using SQL queries to validate data.

. Prepared Regression Test Plans, Requirements Traceability Metrics (RTM),

positive and negative test scenarios, detailed oriented Test Scripts,

Test Kickoff documents, Test Scorecard for test progress status, Test

Results, Release Check list, Lessons Learned documents and Regression

Test Suite for future use.

. Extensively ran the Informatica workflows and mappings through workflow

monitor, monitored the log files and involved in find the root cause of

the failures.

. Responsible in testing Initial and daily loads of ETL jobs.

. Interacted with design team to decide on the various dimensions and facts

to test the application. 

. Tested Informatica workflows for various ETL data mapping requirements.

. Followed HIPAA implementation guides for preparing the EDI files

. Used Desktop Validation tool to check the EDI files for HIPAA errors .

. Involved in preparation of Requirement Traceability Metrics (RTM),

Software Metrics, Defect Report, Weekly Status Reports

and SQA Report. 

. Involved in validating the data profiling and data analysis performed

using data flux.

. Participated in enhancement meetings, investigated software bugs, and

helped the developers to resolve technical issues. 

. Planned ahead of time to test the mapping parameters and variables by

discussing with BA's. 

. Extensively used  Rational Clear Quest  to track defects and

managed them.

. Tested several reports detailing price/volume trends and expense variance

over previous periods by using financial reporting and through the

Interactive Reporting.

. Extensively tested several Business Objects Reports for data quality,

fonts, headers, footers, and cosmetics.

. Validated SSIS ETL Packages as per the data mapping requirements.

. Involved in testing SSRS Reports according to report specification

documents.

. Extensively involved in testing the ETL process of data

sources, SQL Server, Oracle, flat files into the target file, Oracle

database as per the data models.

. Checked the HIPAA compliance of the manually created 27X transactions

using the Edifecs Analyser tool.

. Created test cases and Scripts to test the Performance of the application

using Load Runner.

. Analyzed the testing progress by conducting walk through meetings with

internal quality assurance groups and with development groups. 

. Responsible for documenting the process for future references. 

. Reviewing the test activities through daily Agile Software development

stand-up meetings.

Environment: Informatica 8.1, HP Quality Center, Rational Clear Case,

Rational Clear Quest, TOAD, Putty, Oracle 10g, SSIS, SSRS, SQL Server 2005,

SQL, Linux

Wells Fargo, CA Oct -10

- Dec -11

ETL Tester

Responsibilities:

. Breaking down the requirements to user & technical requirements for

creating test cases/use cases.

. Creating, consolidating and executing SIT Test Cases and UAT test Cases

using MS Excel or Quality Center

. Extensively used Informatica for extraction, transformation and loading

process.

. Extensively tested several ETL jobs developed using Informatica

. Executed Informatica ETL jobs using UNIX to load the data into target

tables

. Writing complex SQL queries for data validation for verifying the SSIS

Packages and business Rules.

. Prepared status summary reports with details of executed, passed and

failed test cases

. Interacted with developers, Business & Management Teams and End Users.

. Participated in regular project status meetings related to testing.

. Worked with XML feeds from multiple sources systems and loaded the same

into Enterprise data warehouse.

. Queried databases using SQL queries in TOAD and SQL Server Management

Studio to validate the data loaded into target tables.

. Responsible for testing Business Reports developed by Business Objects

XIR2

. Executing both Functional and Regression test cases for Provider, Group,

Subscriber/Family, member and Billing.

. Followed HIPAA implementation guides for preparing the EDI files .

. Used Desktop Validation tool to check the EDI files for HIPAA errors .

. Functionality testing of email notification in Informatica job failures,

abort or data issue problems.

. Involved in testing the XML files and checked whether data is parsed and

loaded to staging tables.

. Used TOAD Software for querying the databases

. Developed SQL queries on Oracle to setup test data and review test

results.

. Performed Backend Testing using SQL plus.

. Created and executed test cases for Informatica jobs to upload master

data to repository.

. Responsible for testing packages using SSIS (ETL) to verify data

completeness, data transformation, data quality, integration testing, UAT

& regression testing.

. Written several shell scripts using UNIX Korn shell for file transfers,

archiving the existing files, catalog creation, error log creations and

log file cleanup process.

. Preparing sample Test Data and executing Test cases using Quality center.

. Logging & re-testing defects and assigning them to the

developers/responsible persons.

. Preparing dashboard reports on a weekly basis using Quality Center

. Preparing sample test data for UAT and assisting end users during User

Acceptance testing.

. Conducting and participating Peer review meetings, Weekly project and

Test Team meetings

Environment: Informatica, UNIX, SSIS,SSRS,SSAS,DB2,Quality Center 9.2,

TOAD, Oracle 10g, Sybase, XML, MS Office.

Liberty Mutual Insurance, Boston,MA

Mar-09 - Aug-10

ETL QA Tester

Responsibilities:

. Designed & Created Test Cases based on the Business requirements (Also

referred Source to Target Detailed mapping document & Transformation

rules document).

. Involved in extensive DATA validation using SQL queries and back-end

testing

. Developed test cases for ETL process and reporting.

. Extracted Data from Teradata using Informatica Power Center ETL and DTS

Packages to the target database including SQL Server and used the data

for Reporting purposes.

. Designing the template and structure for data extraction and processing

using SSIS and its different tools from different sources of Production

server, Excel sheets

. Involved with Design and Development team to implement the requirements.

. Developed and Performed execution of Test Scripts manually to verify the

expected results

. Used Informatica Power Center Workflow Manager to run the workflows.

. Conducted Black Box Testing - Functional, Regression and Data Driven.

. Defects tracking, reviewed, analyzed and compared results using Quality

Center

. Documented and published test results, troubleshooting and escalate

issues. Preparation of various test documents for ETL process in Quality

Center.

. Followed HIPAA implementation guides for preparing the EDI files .

. Compared the data sets resulted from the databases Oracle and SQL Server

using the tool, TOAD for Data Analysts.

. Involved in Test Scheduling and milestones with the dependencies.

. Validated prompts, filters and other features in Business Objects

reports. Tested functionality and non-functionality of reports developed

by Business Objects.

. Created and executed test cases for ETL jobs to upload master data to

repository.

. Responsible to understand and train others on the enhancements or new

features developed

. Create and execute test scripts, cases, and scenarios that will determine

optimal system performance according to specifications.

. Modified the automated scripts from time to time to accommodate the

changes/upgrades in the application interface.

. Dealt with data driven testing using QTP. Analyzed the test results

generated using QTP after running test scripts.

Environment: SQL, Informatica Power Center 7.1, SSIS,QTP 9.2,DB2, Quality

Center 9.0, Oracle 9i, Business Objects, TOAD, XML,Unix, Red Hat Linux,

Windows XP, PL/SQL.

JPMCHASE, Dallas, Texas Jul-08

- Feb-09

QA Tester

Responsibilities :

. Developed Test Plans based on Test Strategies and Developed scripts,

utilities, simulators, data sets and other programmatic test tools as

required to execute Test Plans

. Created MS Word, and MS Excel templates to upload the test cases directly

to Manual Tester using the inbuilt tools

. Prepared traceability matrix for point's requirements from the completed

test cases.

. Tested and worked with Business Objects SDK, Full-client Reports and WebI

SDK.

. Involved with extraction routines to verify all the required data loaded

into target systems..

. Processed reject records for business rules for both dimensions and

facts.

. Conducted walkthroughs with the customer, project management, development

team, and Business Analyst.

. Create detailed test plans based on analysis of requirements and design

documents.

. Analyzed raw points data to ensure the data will meet the business need.

. Prepared test cases and did development level testing of the new Business

Objects version.

. Extensively involved with backend testing by writing complex SQL queries.

. Followed HIPAA implementation guides for preparing the EDI files

. Worked closely with business analyst and development group during the

requirement phase and design phase to find out functional

incompatibilities and software issues early in the QA process.

. Worked closely with the development teams to replicate end user issues.

. Supported Infrastructure Engineers, Network Engineers, Developers in

creating testing checklists and coordinating testing for Projects and

Changes.

. Communicated discrepancies determined in testing to impacted areas and

monitored resolution.

Environment: Informatica Power Center 7.1, Oracle, XML Files, Dat Files, MS

Excel, Flat Files, SQL, PLSQL, SQL Server, Erwin 4.0, Unix Shell Scripting.

United Health Care, MN Aug-07 - May-

08

Role: QA Analyst

Project Description: United Healthcare has a history of developing

innovative programs to facilitate a better, more positive health care

experience for everyone - employees, physicians and employers. The field

agents use the application to enter the data of prospective customers. The

application calculates the amount of insurance required, premium, cash

value and benefit amount for all the years. In this project there are

different modules and as a Tester I worked on the applications such as

Technology impact, Patient safety, Pharmacy, Care coordination etc. This

system permits the registered members with United Healthcare to get the

details of the long term care insurance schemes and benefits.

Responsibilities:

. Analyzed the System specifications, Business requirements for full

understanding of the business.

. Developed a detailed Test Plan for System Testing based on SRD and BRD.

. Prepared test cases using Quality centre.

. Created Test Data in flat files from production data.

. Performed Functional, Regression, and System Testing of the Application.

. Performed regression & Stress testing using negative data.

. Followed HIPAA implementation guides for preparing the EDI files

. Involved in Database testing using SQL queries on Oracle.

. Documenting the test results & changes.

. Involved in the team to adopt QA Testing Standards.

. Involved in cross browsing testing of the application on various Browsers

to ensure that it functions similarly on all browsers.

Environment: Manual testing, Quality Center, Java, SQL, XML, JSP, UNIX,

IIS, DB2, MS-ACCESS, Oracle, Windows, IE, and Netscape, Shell Script.

Guardian Life Insurance, NYC, NY

Mar -06 - Jul -07

ETL/Backend Tester

Project: Agency Economics Program

Responsibilities:

. Written test strategy and all the important test scenarios to be

covered and shared across the QA team.

. Written test cases and maintained them in Quality Center.

. Tested all the ETL processes built for fetching various source data

into data warehouse.

. Performed data validations on the loaded data by comparing against

source data through complex SQL queries.

. Prepared test data files in UNIX box for testing purpose.

. Tested the all the transformation as per the source to target mapping

document.

. Tested the UNIX scripts that were developed for moving the used source

files into archive location.

. Tested the reports generated from the data warehouse according to the

requirement specifications.

. Compared the data in the reports against the data warehouse using SQL.

. Prepared UNIX scripts to run the Informatica ETL jobs from command

line.

. Tested the format of the report and compared against the model

provided in the requirements specification.

. Delegated work to offshore team and helped them understand the

requirements and changes happening in the code.

. Performed End to end testing, Regression testing and sanity testing.

. Participated in business requirements gathering and in modifications

of the requirements based on the scope.

. Tested the migration of reports from Business objects XIR2 to XIR3.

. Raised defects and tracked them to closure by coordinating with dev

team.

Environment: SQL, PL/SQL, Quality Center 9, Informatica 8.1, Business

Objects XIR3, TOAD for Oracle

Contact this candidate