ETL/Back end tester Resume Reston, VA - Hire IT People

SUMMARY

Highly motivated, results oriented, Test Engineer with over 7 years of experience as QA analyst.
Strong work experience in ETL testing, backend testing, web application testing. Expertise in manual as well as automated testing..
Expertise in Data warehouse concepts, Data Mart, OLAP, OLTP, Star schema and Snowflake schema,
Good experience in Informatica power center and Microsoft BI (SSIS, SSAS, SSRS).
Strong writing skills in SQL, PL/SQL (stored procedures, triggers and functions) and TSQL
Proficient in writing test strategies, test plans, test cases, test scripts, test scenarios, Requirement trace ability Matrix (RTM) and test summary reports.
Experience and good understanding of SDLC, Agile/Scrum Methodology, Testing Life Cycle, Bug/Defect life cycle.
Very good experience in Defect tracking and Reporting using test management tools
Experience in Insurance, Banking, Financial and Health care domain projects.
Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.

AREAS OF EXPERTISE

Oracle, MySQL, Microsoft SQL Server, IBM DB2 Informatica, Abinitio, Autosys, Microsoft BI (SSIS, SSAS,SSRS) Selenium, SoapUI, Load runner, HPALM, HP QC, QTP, DOORS XML, WSDL, SOAP, HMTL
JAVA, C, C++, C#, Python, Unix shell scripting, VB scripting
Windows 95/98/2000/XP, Unix, Linux, MvS

PROFESSIONAL EXPERIENCE

Confidential, Reston , VA

ETL/Back end tester

Responsibilities:

Developed test cases based on test matrix including test data preparation for Data Completeness
Verified data transformations and validated various data reports.
Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations.
Performed data quality analysis using advanced SQL skills.
Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration
Ensured Error logs and audit tables are generated and populated properly
Performed UAT and Regression Testing.
Tracking and reporting the issues to project team and management during test cycles.
Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
Contribute in the development of knowledge transfer documentation

Confidential , Dallas, TX

ETL/back end tester

Responsibilities:

Developed Test plans, test cases and test data for each test phase, detailed analysis of negative test conditions to ensure complete coverage
Maintained Trace Ability Matrix to track the requirements to the test cases to ensure complete test coverage.
Developed SQL Queries/Scripts to validate data mapping, Integrity and Accuracy of Data within an ETL process., Developed Data Mapping documents for EtL (SSIS) projects.
Performed Unit Testing, Integration Testing, User Acceptance Testing and Requirement Testing.
Validated reports based on Functional Requirements. Analyzed various reports generated by SSRS.
Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
Worked with Development team to ensure feasibility of design and clarify user requirements.
Used Mercury IBM Rational Clear quest for Bug Tracking, Reporting and Analysis

Confidential, concord, NH

Quality Analyst

Responsibilities:

Analyzed Business Requirement Specification (BRS), Software Requirement Specification (SRS).
Developed Test scenarios, Test Cases, and Test steps for various Business services covering both Positive and Negative testing requirements.
Extensively worked with all the Quality Center Modules Management, Requirements, Test Plan, Test Lab, Defects and Dashboard and versioning of test scripts and resources in QC/ALM.
Involved in the project from the requirement analysis phase till the completion of UAT (Testing Lifecycle).
Performed User Interface Testing on the web Interface.
Involved in Functional, Regression, System, Positive, Negative, Black Box, and Integration Testing.
Developed and executed SQL queries to validate data reports.
Determined test cases using equivalence partition followed by boundary value analysis during black box testing.
Attended weekly Project Status Meeting with Development Team, QA Manager, and worked closely to define Test Scope, Risk, Dependency and Constraints.

Confidential

Web tester

Responsibilities:

Involved in Functional Testing, end - to-end testing, GUI testing, Database testing, Regression Testing and cross browser testing.
Performed Back End Testing by executing SQL statements.
Used SOAPUI tool to test WSDL files
Performed Integration testing of various modules to verify the interfaces and control flows between the modules.
Identified, Documented and Tracked software defects using Quality Center and coordinated with the development team for fixes.
Was responsible for Smoke testing every new build and system enhancement.