SUMMARY:

• QA Tester/Analyst (with focus on ETL, Datawarehouse, Reporting and Testing), with around 7 years of diversified experience in Information Technology including System Analysis, Quality Assurance (Manual/Automated), Strong Database and Testing concepts, System Testing, Functional Testing, Integration Testing, Database Testing and Regression Testing of Web based and Client/Server applications on Unix and Windows XP environment.
• QA and QC experience in ETL, Data Warehousing (DW), Reporting, OLTP, OLAP, Data Integration and Data Migration Projects
• Worked on ETL tools like: Informatica & Reporting tools like: Business Objects
• Tested data validations, data conversions, data transformations, report metrics and row counts between legacy systems, OLTP & OLAP systems
• Expert in writing complex SQL Queriesto check the integrity of data to perform database testing.
• Certified in Teradata V2R5 for the level 1(basics) and level 2(SQL specialist)
• With Strong Knowledge in all phases of Software Development Life Cycle (STLC)
• Usage of Testing Tools such as HP Quality Center, Test Director, QTP
• Experience in preparing test schedule planning, designing test strategy, test cases and test plans. Editing and playback the scripts after fixing the bug
• Experienced in Functional testing, System testing, Load testing, Integration testing, Regression testing, Black box testing, White box testing, Boundary testing.
• Trained non - Technical Business Users. Excellent Communication and Interpersonal Skills in interacting with Clients and Business Users
• Experienced as QA Test Lead in an Onsite-Offshore model includes project planning, estimates, resource assignment based on estimations
• In depth knowledge of Testing methodologies, Concepts, Phases, and Types of testing, developing Test Plans, Test Scenarios, Test Cases, Test Procedures, Test Reports and documenting test results accordingly after analyzing Business Requirements Documents (BRD), Functional Requirement Specifications (FRS), Mapping documents and Technical Specs.
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Understanding of Data Models, Data Schemas,ETLand created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Strong analytical, dynamic trouble-shooting and requirement traceability skills.
• Experience in testing reconciles (initial) and delta (daily) ETL loads.
• Performed testing based on Transformation Rules using STM (Source-to-Target) Mapping document.
• Extensively worked with batch scheduling tool Control-M monitor to run and monitor the ETL workflow jobs.
• Extensive experience in executing Test Strategy, Master test plans and Traceability matrix based on business requirements
• Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS) and developing Test Plan
• Experience in working with different SDLC models like Agile, V-Model & waterfall.
• Strong experience in organizing & conducting different reviews meetings throughout the Testing Life cycle especially in agile method.
• Setting up environment for testing purpose and data load through control-m and monitor the same in Informatica
• Performed back tracking of data in depth from source till the target and reporting all the issues upfront
• Strong experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch
• Experienced in basic UNIX shell scripting and basic commands
• Worked on BO report testing which is completely web based, analyzing the migrated reports between two environments
• Review of SQL queries, test cases & results, defect management, daily & weekly status
• Experience in working with defect management tools like HP ALM 11.0 & Test Director, Rational Clear Quest Web 7.0.1
• Excellent analytical, problem solving, interpersonal, and communication skills
• Hands on experience in automation tools for executing regression test cases

TECHNICAL SKILLS:

ETLtools: InformaticaPower Center 9.1/8.X/7.X

Databases: MS SQL, DB2, Teradata V2R6/V2R5, SQL Server

Agile, V: Model & waterfall

Reporting Tools: Business Objects report testing

Test Management Tools: HP Quality Center 10.0/9.0/8.2 , Rally, TFS, QTP

Data Access Tools: TOAD, SQL Navigator

Programming Languages: SQL, PL/SQL

Requirement Tools: Rational Requisite Pro

Version Control Tools: Rational Clear Case,SharePoint

Control: M Monitor, Informatica Job Scheduler

Incident/Defect Management Tools: Clear Quest, Quality Center

Operating Systems: UNIX

Other Tools: Win SCP, PuTTY, Text Pad

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, Ohio

Responsibilities:

• Design, develop and execute test strategies/plan, debug and troubleshoot, perform impact and gap- analysis and give inputs for status reporting, issue resolution, defect tracking and defect triage activities
• Analyzing the requirements document, specification document.
• Worked with Development & Business team on building system requirements & design based on the business requirement.
• Planning, Preparing & Executing Database ETL testing.
• Involve and provide inputs for Defect triage meetings on regular basis.
• Logging and managing all the defects (QA & UAT) till closure.
• Documenting all the testing needs & status and reporting the project management on regular basis or on need.
• Validation and verification of the test results using Macros in excel spread sheets.
• Analyzing the work flow in informatics and providing required inputs for the defect fixes
• Setting up environment and data loading through control-m and Informatica
• For user migration, primary task is to analyze the SQL queries and digging the base tables for source issues or data issue
• Extensively involved in business user meeting and defect triage for all the defects raised and providing appropriate justifications
• Tracking all the defect in ALM and tracking to closure with valid comments
• For BO migrations, testing and reviewing the BO reports as per the technical specifications, guiding and overseeing the work of development team.
• Executing user acceptance testing and interfacing with the users to resolve testing issues with data as well as with SAP BO code.
• Back tracking all the issues related to BO reports and also the SQL queries in-built
• Querying the SQL captured from BO reports and validating the same in the databases

Confidential, Richmond, Virginia

Responsibilities:

• Involved in all phases of project from requirement, design through testing and deployment of the projects into EDWard.
• Performed Data Analysis and Data Profiling with prior knowledge on the Confidential business
• Designed & Created Test Cases based on the Business requirements and mapping documents
• Validated that design meets requirements and function according to technical and functional specifications
• Prepared KT document and had a review with developers and Subject matter experts.
• Developed high level Test Plan / Test Strategy and walkthrough the Test Plan to clients
• Responsible for delivering the Test Plan, Test cases and Test results
• Involved in extensive DATA validation using Teradata queries
• Extensive experience in writing and executing BTEQ scripts for validation and testing of the data integrity between source and target database
• Developed and performed execution of Test Scripts to verify the expected results
• Code and test complex SQLs using Teradata SQL Assistant
• Tuning SQL queries to overcome spool space errors and improve performance
• Developed the strategies for analyzing the data for ETL Team
• Responsible for testing all new and existing ETL data warehouse components
• Involved in all phases and stages of Software Testing Life Cycle including end-to-end system testing and business requirements analysis.
• Involved in identifying defects during the testing, performing defect analysis, suggesting required code changes for fixing defects
• Supported end users for UAT Testing
• Guided the team members in preparing the data validation scenarios, scripts, defect analysis and the automation test suite for executing the test scripts using TeXecutor and Platinum tools
• Experienced at testing flat file data transfers
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Used RM to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements
• Participated in walkthrough and defect report meetings periodically
• Documented and reported various defects and design changes during Systems Integration Testing
• Retesting the resolved defects/issues after the developers fix the defects
• Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
• Involved in preparing the status reports and also coordinating with offshore and onsite to bridge the gap between onsite and offshore
• Participated in status reporting, defect reporting and defect management

Confidential

Module Lead

Responsibilities:

• Responsible for creation of Test Plan document, status reporting, estimation, metrics preparation, preparation of Test Evaluation Summary document
• Responsible for preparing the status reports and also coordinate with the onsite and bridge the gap between onsite and offshore
• Guide the team members in preparing the data validation scenarios, scripts and defect analysis
• Prepare the automation test suite for executing the scripts using the Cognizant proprietary automation tools like Texecutor, Stargate and Platinum

Confidential

Responsibilities:

• Involved in all phases of project from Requirement & Understanding phase, Test cases preparation and Reviews.
• Created, optimized, reviewed, and executed SQL test queries to validate transformation rules used in source to target mapping
• Identified the Test Scenario and documented them to provide a high level view of the testing hot spots and high risk areas
• Co-coordinating with Onsite teams for test execution
• Functional and Regression testing of the existing and new functionalities within the release
• Involved in identifying defects during the testing, performing defect analysis, suggesting required code changes for fixing defects.
• Extensive use of SQL for testing the data that are processed through different layers-LZ, CSA, EDW
• Performing production validation and ensure that there is no defect leakage during production implementation
• Responsible for logging bugs in Bug Tracking Tool like Test Director and tracked the status and daily work in the project and also helped team members in preparing SQL test scripts as well as to analyze and resolve the issue found during test execution

Confidential

Responsibilities:

• Reviewed Business Requirements, Business Use Case and functional documents
• Involved in Writing the Test Cases and Test Plans based on Source to Target Mapping Documents
• Validation of data loaded in Teradata through Informatica and Teradata in EDW
• Validation of Access control restrictions and privileges in Teradata
• Involved in preparing the Test Strategy, Test Plan, Test Cases, Test Scripts, Test Results and Test Summary report as per the test strategy
• Has involved in regular discussions with the various WellPoint Subject Matter Experts for different healthcare subject areas Membership, Claims, Products and Providers to derive the design approach using her specialized knowledge on data warehousing
• Involved in Mapping the Test Cases with the Requirements and Mapping Document
• Involved in writing Test Cases to validate the Enterprise Data Warehousing (EDW) Tables from source.
• Validated data between flat files(UNIX) and LZ tables(source in Teradata)
• Wrote SQL queries for each Test Case and executed them in Teradata to validate the data from flat files(UNIX) to Enterprise Data Warehouse
• Used Test Director 8.0 to state requirements, business components, test cases, and test runs for every iterations, defects. Also link defects with requirements
• Developed test cases based on business requirements document, technical specifications document and functional flow of application
• Worked rigorously with developers to create test scripts in regards to the Informatica ETL
• Designed and documented all the Issues and defects to ensure application software functionality for Present and Future Builds using Test Director
• Performed Retest for the defects raised and Regression testing, to make sure, new defects were not introduced
• Prepared Test Defect Metrics on a Weekly basis to know the status of the application
• Preparation of Test Data for Positive and Negative Test Cases

Confidential

Responsibilities:

• Involved in all phases of project from requirement, design through testing and deployment of the project Confidential
• Played a key role in understanding the data gaps in the data warehouse and the approach for the Confidential project
• Understanding the high level requirements of the WellPoint’s Healthcare Systems and transforming the information in an executable form
• Taken primary responsibilities in understanding and analyzing the mapping specifications using the high level design which was used for further coding
• Developed a level of competency, which helps to anticipate issues and solve them in advance and also involved in imparting domain and technical knowledge to the new entrants
• Coordinated well and played a major role during all the phases in making the application successful and deployable