SUMMARY

• Over 5+ years of experience in manual testing on web based, Client/Server, database and data warehousing applications
• Experience in development & Testing of microprocessor - based products and solutions.
• Well versed with all the phases of the Software Testing Life Cycle, Software Development Lifecycle (SDLC) and Test Methodologies
• Sound Knowledge and Experience with Waterfall, V-Model and Agile/Scrum Software Engineering Methodologies and experience with Capability Maturity Model (SW- CMM).
• Expertise and experience in performing various phases of testing such as smoke, Black box, GUI, functional, regression, Database, Usability, Compatibility, integration, system testing, User Acceptance Testing (UAT) of Web and client/server applications.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Designed test case based on the ETL mapping document.
• Experienced in running and validating the logs in Informatica tool.
• Expertise in Business Object (BO) Reports Testing.
• Experience in creating Requirement Traceability matrix (RTM) using Quality Center (HP ALM) tool.
• Experience in using Bugzilla, Jira and HP Quality Center (ALM) for Bug Tracking and Defect Reporting.
• Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Server, Teradata Database using SQL, PL/SQL for data integrity.
• Motivated team player/contributor with professional written, verbal, documentation and presentation skills.
• Proven ability to work independently or as a member of a team. Skilled in adapting to rapidly changing work environments.
• Have valid H4 EAD visa

TECHNICAL SKILLS

Testing Tools: Quality Center(ALM), QTP,Test Director, Bugzilla, Jira, SOAP UI, WinSCPLanguages C, C++, VBScript

Web Technologies: JSP, HTML, XML, J2EE .Net

Databases: Oracle, SQL Server, Sybase

Operating Systems: WINDOWS, UNIX

Data Base Tool: Toad, SQL developer, Business Objects, Informatica

Version Control Systems: VSS, SharePoint

PROFESSIONAL EXPERIENCE

Test Engineer

Confidential, New York

Responsibilities:

• Worked with users in understanding the business requirements and involved in creation and execution of the test scenarios and test approaches.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Developed Test Scenarios/Test cases according to the Requirement and Mapping document.
• Worked in Agile Technology with Scrum. Attended Daily Scrum Meetings and updated testing status, New development and issues. Also, Invoved in Sprint Plan & Rectrospection meetings.
• Developed data quality test plans and manually executed ETL and BI test cases.
• Prepared and executed test cases using ALM(Quality Center) tool
• Worked with the co-testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project.
• Involved in Integrating and Functional System Testing for the entire Data Warehousing Application.
• Used ALM(Quality Center) for defect tracking.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Coordinate and helped in testing the reports using Business Objects functionalities.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Involved in data warehouse testing by checking ETL procedures/mappings.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Provided test estimates for test preparation and execution.
• Prepared test data to meet all the business rules and requirements. Also tested for negative data to check that the job fails on any critical error.
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.
• Analyzed the data and applied relevant transformations and verified that the source data types are correct.
• Maintained the Traceability Matrix between Requirements, Design Components, Test Cases and Defects.
• Participate in weekly meeting with the management team and walkthroughs
• Developed Test Strategy, Test plan, Test cases, and Test scripts and various other project documentation
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules

Environment: Informatica 9, Beyond compare 3.3.7, Business Objects, SQL, XML, HP ALM/Quality Center 11.0, T-SQL, SQL, Teradata V2R6, TOAD, Oracle 10g, PL/SQL,Sybase, MS Access/Excel/, Win SCP, UNIX, Rally, SharePoint.

Sr.Test Engineer

Confidential

Responsibilities:

• Involved in the entire software development and Testing Life Cycle of the projects from Initiation to Implementation.
• Create test plan and test cases for manual testing from the business requirements.
• Created and executed detailed test cases with step by step procedure and expected result. Maintained the test logs, test reports, test issues, defect tracking using Test Manger tool.
• Verified defects and Perform database functional, integration and regression testing as needed to minimize defects. Responsible for gathering requirements from the Subject Matter Expert (SME).
• Attended Daily Scrum Meetings and updated testing status, New development and issues. Also, Invoved in Sprint Plan & Rectrospection meetings.
• Used Microsoft Visual Studio Team Foundation Server(TFS) for Agile Management.
• Performed execution phased: Executing test cases, identified products issues, wrote detailed bug reports and participated in bug review during the product development stages.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Tested the data which loads from Source to staging, Staging to warehouse and warehouse to mart.
• Involved in SCD2 type dimension testing with start date and end date logic.
• Test the data which loads Weekly and Monthly.
• Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD.
• Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Carried out and oversee test execution for Business scenario, User acceptance and Regression testing.
• Performed database validation according to the business logic by comparing the source to the target. Tested Data Warehousing application on Oracle Database.
• Written several complex SQL queries for validating Cognos Reports.
• Tracked bugs using Test Manger and generated the defect reports for review by the client and the management teams.
• 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.
• Participated in Risk Management to help determine best use of development and testing resources. Used Quality center, to manage the entire process and log in defects. Provide update to management on testing status and some other issues
• Participated in weekly meeting with the management team and walkthroughs
• Participated in various meetings and discussed Enhancement and Modification Request issues
• Submitted weekly bug or issue report updates to the Project Manager.

Environment: Informatica Power Center 9.0, Oracle10g, Teradata, SQL Server, Cognos8.1/10, DB2 8, Test Manager, TFS, Windows NT/2000/XP, UNIX, Agile, MS Office Suite 2010, SQL Navigator, Toad, SharePoint.

Test Engineer

Confidential, St.Louis, MO

Responsibilities:

• Involved in preparing Test Plans based on Business Requirements Document (BRD) and prepared the Test cases and Test Procedures using Quality Center.
• Identified lab specific issues relating to application and interface/ Completed Integrated Testing
• Provided issues by level of severity to corporate lead team
• Mapped requirements with Test Cases in Quality Center and executed them reporting a pass or fail status.
• Exported Test Requirements and Test Cases from Excel and Word to Quality Center.
• Involved in functional and Regression testing.
• For each feature positive and negative test cases were written using Quality Center.
• Extensively used SQL queries for data validation.
• Generated the detailed reports of the Defect and Assigned defects using Quality Center (QC).