SUMMARY

• Over 5 years of Software Quality Assurance (QA) experience testing Data Warehouse, Database ETL, Web, Client - Server Systems and Applications, Reports for various Industries.
• Possess excellent knowledge & experience in providing data warehousing solutions and data warehouse concepts.
• Professional Experience in HealthCare and Retail.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Extensive experience in Requirement’s Analysis, Documentation, Testing, Implementation and Maintenance.
• Good Back End Testing experience by writing and executing complex SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Database/ ETL/Reports testing -- Validated the data derived in the target table if it is adhering to the standards and business rules.
• Extensive experience working in Agile and waterfall environments.
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
• Experience in testing XML files and validating the data loaded to staging tables.
• Extensive experience in testing and writing SQL and PL/SQL statements.
• Strong working experience on Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Good experience in testing Business Objects and SSRS reports
• Experience in writing Test Plan and Test Strategies for Data Warehousing Applications.
• Extensively performed System, Integration, Performance, Sanity, Security, Load, Database, UAT, Usability and Regression Testing.
• Strong Problem Analysis & Resolution skills and ability to work in Multi-Platform Environments like Windows and UNIX
• Reporting daily status to daily SCRUM meetings and discuss about the progress and issues faced
• Experience in working in fast pace environment including managing multiple offshore resources

TECHNICAL SKILLS

ETL Tools: Informatica Power Center, SQL Server Integration Services

Testing Tools: Quality Center, QTP, TFS

Languages: Java, .NET, XML, HTML, SQL, TSL, Java Script, VB Script, C++

Operating Systems: WindowsNT/2000/XP, UNIX, LINUX

Databases: MS Access, Teradata, SQL Server, Oracle, Sybase, DB2

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla, TFS

GUI Tools: Visual Basic 5.0/ 6.0, Crystal Reports 4.6/

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

QA Analyst

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Involved in developing detailed test plan, test cases and test scripts using Test Director for Functional, Security and Regression Testing.
• Validated all kinds of transformations used in every work flow used to transform data.
• Validating the data flow from source to target.
• Checking the data flow from one end to another by using SQL queries.
• Worked with technical staff to create, interpret and implement business requirements into technical specifications.
• Executing ETL - Informatica Workflows for updating test Databases from the Production servers.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Worked rigorously with developers to create test scripts in regard to the Informatica ETL.
• Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Confidential

ETL QA Analyst

Responsibilities:

• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Involved in Regression testing by playback
• Involved in Functionality testing
• Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Tested data warehouse ETL process using SSIS (Integration Service)
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Involved in creating both positive and negative test data to cover all business scenarios
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Clear Quest to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.
• Performed quality assurance reviews on all System Development Life Cycle.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Confidential

Jr. QA Analyst

Responsibilities:

• Prepared Test Plan and Test Cases according the business requirements.
• Participated in setting up testing environment.
• Developed test cases after analyzing the specifications document.
• Writing test cases to test the Performance of the application manually.
• Conducted Functionality and Regression testing during the various phases of the application.
• Worked with System Administrator closely in setting up QA and testing environment
• Involved in the gathering of Business Requirements, Functional and System Specification.
• Created Test cases and Test matrices for integration and system testing
• Performed usability testing and Back End Testing manually.
• Coordinating with Lead in gathering requirements, tasks and updates on the project.
• Created and executed Manual Test scripts to verify complex system requirements and database testing. Transaction Verified through Data Verification of Backend Database using SQL Queries
• Used various techniques like Ramp up, Ramp down, Transaction Point in Load Runner.
• Performed Manual Testing for Screen Navigation.
• Created and maintained test matrix and tractability matrix.
• Performed manual testing on different modules of the application.
• Reported problems/bugs found using Quality Center
• Performed load test to check the system behavior and resolved the performance issues.
• Wrote Test scripts for the Data Integrity Testing and Back End Testing
• Participate in various meetings and discussed Enhancement and Modification Request issues.
• Conducted result analysis and interacted with developers to resolve bugs.
• Participated in the walkthroughs and project meetings.