Summary:

• About 6 years of experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and ETL, Data Warehousing solutions.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Have solid experience on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus.
• Experience on UNIX commands and Shell Scripting.
• Experienced in Functional testing, Performance testing, Load testing, Integration testing, System Testing, Regression testing, Black Box testing, Stress Testing, Smoke Testing, Recovery Testing and GUI Testing.
• Strong experience in preparing documentation, preparing test environments, executing and analyzing the results.
• Very good understanding of Data warehousing concepts.
• Have experience in testing reconcile initial and delta daily loads.
• Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
• Involved in preparation of Requirement Traceability Matrix RTM , Defect Reports, and Weekly Status Reports.
• Experienced in using the Oracle SQL Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
• Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest.
• Expert in writing complex SQL queries for back-end testing.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Experience in Data Analysis, Data Cleansing Scrubbing , Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

Technical Skills

PROFESSIONAL EXPERIENCE:-

Confidential

ETL Tester

Responsibilities:

• Analyzing business requirement and reporting SME and SA for updating docs.
• Developed Test cases, Test scenarios and Test scripts based on business requirements.
• Involved in coordinating with developers, SA and SME.
• Conducted Bug Review meetings with developers and SME's.
• Responsible for validating different fields of source and target App by monitoring Flat Files and control files on Server.
• Created Test data for validation for Claims
• Participated in defects review and Test Readiness meetings on weekly basis.
• Interacted with business user for any updates on Requirements of these projects.

Environment: Informatica Power Center 8.6, Quality Center, Toad on Oracle. Windows XP, MS Word, MS Project, MS Excel

Confidential

BI Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Presented in stand up meeting, story huddle and other meetings for the updates, suggestion, comments to improve the velocity and refinement in QA Testing Approach
• Prepared Test Cases to validate data from base table to the dataset table.
• Extensively used Micro Strategy, SQL Assistant and edited SQL Query validate and compare the result between the base table to the dataset report from Micro Strategy to run the report .
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Tested data migration to ensure that integrity of data was not compromised.
• Used Jira as defect tracking tool.
• Involved in data masking.
• Done data validation for the Micro Strategy reports.
• Analysis and data digging using SQL to find root cause of defects
• Prepared showcase to business/ client to make sure test is as per the business requirement
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 8.6, Clear Quest, SQL, UNIX, Session Log files, Flat files, XML files, Teradata, Agile, Compare IT, Jira, Micro Strategy, SQL Assistant.

Confidential

ETL Tester

Responsibilities:

• Analyzed the Requirements from the client and developed Test cases based on functional requirements, general requirements and system specifications.
• Prepared test data for positive and negative test scenarios for Data Migration and Business Intelligence.
• Prepared Test Cases and Test Strategy for the mappings developed through the ETL tool from the requirements.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Tested the ETL Informatica mappings and other ETL Processes DW Testing .
• Effectively coordinated with the development team for closing a defect.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Jobs/Mappings and monitoring error logs.
• Have tested reconcile and incremental ETL loads for the project.
• Tested data migration to ensure that integrity of data was not compromised.
• Used HP Quality Center 9.0 as defect tracking tool.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes Inserts.
• Validated the Acknowledgement files, Negative acknowledgement files, Frequency reports generated by data flux.
• Involved in Smoke and System Testing.
• Done data validation for the OBIEE / Micro Strategy reports.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Analysis and data digging using SQL to find root cause of defects
• Worked effectively to meet the deadlines for each release.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions whether the mapping do what the technical design says it should do.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Provided the management with weekly QA documents like test metrics, reports, and schedules.

Environment: Oracle 11g, Informatica Power Center 8.6, Clear Quest, SQL, UNIX, Session Log files, Flat files, XML files, DB2, Agile, Compare IT, OBIEE , SQL Server 2008, and TOAD.

Confidential

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.
• 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.
• 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

Confidential

Backend Tester

Responsibilities:

• Analyzed business requirements and module-specific functionalities to identify test requirements and formulate an effective master test plan.
• Responsible for review of Functional Requirement Specification and System Design Specification documents for testing.
• Performed extensive manual testing on critical functionalities of the application.
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements.
• Used Mercury Quality Center for Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result
• Extensive querying using TOAD to run SQL queries and monitor quality integrity of data.
• Actively participated in creating requirements Traceability matrices and Test plans
• Participated in enhancement meetings, investigated software bugs, and helped the developers to resolve technical issues.

Environment: Oracle 9i, SQL Server 2005, TOAD, MS Access, MS EXCEL, Mercury Quality Center