PROFESSIONAL SUMMARY:

• Around 7+ years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments and Data Warehousing solutions.
• Strong knowledge of SDLC and Software Test Life Cycle and highly proficient in SQA methodologies for Waterfall, Agile.
• Expertise in Writing, Executing and Maintaining Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases.
• Have solid experience on database query tools such as TOAD, SQL Navigator, and SQL Assistant.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
• Extensive experience in using Tableau functionalities for creating different Reports, Interactive Dashboards with page and dashboard Prompts.
• Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3Used SOAPUI for web services validation for SOA architecture.
• Hands on experience in Automation testing using QTP.
• Involved in Data Extraction from Teradata and Flat Files using sql assistant.
• Used Quality Center for defect tracking.
• 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.
• Involved in testing the batch jobs, using UNIX and Autosys.
• 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 HP Quality Center/ALM, Clear Quest, TFS - Team Foundation Server, Rally.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local global filters according to the end user requirement.
• Expert in writing complex SQL queries for back-end testing.
• Experience in interacting with Clients, Business Analysts, UAT Users and Developers.

TECHNICAL SKILLS:

Defect Tracking: ALM / Quality Center

Databases: SQL Server 2005/2008, Oracle, MySQL, Access

Scripting languages: Java script, VB Script, HTML, XML

Application environments: C#, .NET Framework, .NET Web Services, SSIS/ SSRS/ SSAS, SOA, CSS, Java, J2EE

MS Suite/ Project Tools: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project, MS SharePoint

Operating Systems/ Products: Windows, UNIX, UBUNTU, LINUX

DWH/ETL Tools: SSIS, Informatica, SSRS, Cognos, Tableau, etc….

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Sr. ETL QA Tester

• 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 Functional Testing as documented in the test plan.
• Prepared Test Cases and Test Plans for the mappings developed through the ETL tool from the requirements.
• Good experience in web related technologies including HTML, XML, SOAP, JavaScript, ASP, VB, VB.NET,ASP.NET
• Experienced in working in Agile Scrum and Waterfall SDLC methodology environments
• Created the Regression Test cases and automated them for the purpose of regression testing using QTP.
• Tested complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Verified session logs to identify the errors occurred during the ETL execution.
• Created Test Cases, traceability matrix based on mapping document and requirements.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
• Verified the logs to identify the errors occurred during the ETL execution.
• Written several complex SQL queries for data verification and data quality checks in SCD Type 2 and SCD Type 1 Tables.
• I have tested SCD Type 2 initially with History Load and Incremental load and verify the inserts and updates of data.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Tested the ETL Informatica transformation and other ETL Processes (DW Testing). 
• Tested Cognos reports to check whether they are generated as per the company standards
• 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.
• Exclusively used test plan module to write and test lab module to execute the test cases in HP Quality Center/ALM.
• Exclusively used requirement module for requirement and defect module for entering the defects in HP Quality Center/ALM.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Validated various transformations of SSIS data flow and control flow.
• Developed UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. 
• Involved in testing the Cognos reports by writing complex SQL queries
• Provided the management with weekly QA documents like test metrics, reports, and schedules. 

Environment: Oracle 11g, Informatica Power Center 9.1 (power exchange, Informatica DVO), Clear Case, Cognos 8.0 Series, Teradata SQL Assistant,Agile, Clear Quest, SQL, PL/SQL, TOAD, UNIX, TFS, Putty, SharePoint, Flat files, XML files, DB2, Netezza, Tableau (Desktop, Server),SOAPUI, QTP,HP Quality Center/ALM, Autosys, SQL Server 2012

Confidential, Eden Prairie, MN

ETL QA Tester

• Designed and Created test plan, test scenarios and test cases for Data warehouse and ETL testing.
• Worked with business team to test the reports developed in Cognos
• 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.
• Preparing Dashboards using advance table calculations, parameters, calculated fields, groups, sets, forecasting and hierarchies in Tableau.
• 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.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Testing the ETL data movement from Oracle Data mart to Netezza Data mart on an Incremental and full load basis.
• Hands on experience in Automation testing using QTP.
• Generated reports using SOAPUI.
• 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. 
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• 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.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report. 
• Manually tested the applications and handled Test Cases through Test Management tool Quality Center/ALM.
• Analyzed Test Results and generated Defect Reporting and tracking via Quality Center/ALM 11. Consolidated and presented regular updates to project team management.
• Generated Test Execution and Defect Summary reports from Quality Center to the management and Product owners
• Involved in testing the Cognos reports by writing complex SQL queries
• 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.
• Executed automated test scripts using QTP for Regression testing.
• Created test cases and Scripts to test the Performance of the application using Load Runner.
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: HP Quality Center/ALM, Informatica 9/8.1, Cognos 8 Series, Rational Clear Case, Rational Clear Quest, Teradata SQL Assistant, Teradata V2R6, QTP, Agile,Rational RequisitePro, Netezza, Autosys, Rally, TOAD, Putty, Tableau (Desktop, Server), Oracle 11g/10g, QL Server 2012, SSIS, SSRS, SOAPUI, TIBCO, PL/SQL, Linux

Confidential, Tampa, FL

ETL QA Tester

• 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
• Tested complex SQL scripts database for creating BI layer on DW for tableau reporting.
• Worked with SOAPUI for testing Web Services
• Used DOORS for reading/analyzing the requirements for the project.
• Performed extensive manual testing on critical functionalities of the application.
• Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server and flat files and loaded them in to Oracle. 
• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements. 
• Involved in running various informatica workflows and mappings to validate them according to functional specifications.
• Worked in Agile technology with Scrum and waterfall models
• Hands on experience in Automation testing using QTP.
• Involved in testing the ETL 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; whether the mapping work correctly in relation to other processes in your data logistical flow.
• Used Rapid SQL tool to query the DB2 data and verified the results.
• Tested reports in Cognos using Analysis studio, Report studio and query studio.
• Experienced in analyzing the issue by checking the log files in the AIX environment. 
• 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 
• Performed Unit and functional testing for all the Mappings and Sessions.
• Implemented automated Processes & scheduling using Autosys.

Environment: Informatica, Oracle 9i,Agile, SQL Server 2008, QTP, SSIS, SSRS, SQL, PL/SQL, Autosys, TOAD, IBM AIX, Tableau (Desktop, Server), Teradata SQL Assistant, Teradata V2R6, MS Access, SOAPUI, DB2, Cognos, Unix, Quality Center

Confidential, Atlanta, GA

DW BI QA Tester

Responsibilities:

• Analyzed system requirements and developed detailed test plan and test cases for testing.
• Performed functionality, Data integrity and Data validation testing manually.
• Performed system testing and logged results.
• Performed manual testing for usability testing.
• Involved in analyzing Business requirements, studying the application and collecting information from developers.
• Involved in Inserting Checkpoints to check for broken links, Text and standard properties of an object using QTP
• Tested user interface and navigation controls of the application using HP ALM
• Conducted back end testing in QTP by inserting database checkpoints
• Performed Sanity and Smoke Testing.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle.
• Core responsibility involved complete manually testing of the User Acceptance Test (UAT)
• Reported and tracked defects using Test Director.
• Created Rendezvous points to create intense Virtual User load on the server.
• Created reports using online monitors and graphs.
• Participated in Walkthroughs and Inspections.
• Performed Regression testing to ensure that bugs fixed did not generate new bugs.
• Interface with developers to solve software problems.

Environment: Windows XP, SQL, Rational Tools, MS Visio, MS Word, Excel, PowerPoint, Access, Rational Team Test, Clear Quest