SUMMARY

• Over 7+ 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.
• Hands on experience onETLtools inETLprocess development,testingand in maintainingETL codes.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Experience testing on .Net and Java applications.
• Managed/lead/performed test planning, test execution, test data, test coordination, configuration management and defect management areas for the web based, middleware and mainframe applications
• Excellent experience in Quality Assurance andtesting, worked asETLTester, BI Tester, Data Tester and QA Analyst.
• Solid Back EndTestingexperience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Creation of Standard Guidelines for User InterfaceTesting
• Database/ETL/Reportstesting Validated the data derived in the target table if it is adhering to the standards and business rules
• 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.
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analysed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• 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.

TECHNICAL SKILLS

Testing Tools: RQM,RTC,Quality Center(ALM), Selenium WebDriver,Test Director, Bugzilla, Jira, SOAP UI, WinSCP, Confluence, TFS,Sharepoint,Clearquest, VersionOne

Languages: 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, OBIEE Reports

Version Control Systems: VSS, SharePoint

PROFESSIONAL SUMMARY

Confidential, Pittsburgh, PA

QA Analyst

Responsibilities:

• Prepared Test Strategy for each release.
• Communicating with BSA’s, MIS and Product Owner for requirements clarifications.
• Preparing Test scripts &Test Evidence documentation and helping automation scenarios in Selenium.
• Uploading test scripts in ALM and maintaining traceability
• Developed new Automation test cases (Fill forms, drop down page, upload file) using Selenium WebDriver
• Communicating with Performance team for Performance testing for the releases
• Testing the user stories once MIS team completed development
• Validating database with respect to the tables
• Log the defects in ALM for tacking.
• Performed Data driven testing using Selenium WebDriver, JUnit functions and JDBC Connections which reads data from scripts using property and XML files.
• Retest the impacted test scripts once the bug was fixed and closed the defects attaching artifacts.
• Communicating with Integration & OBIEE Projects with other systems
• Communicating with LOB team for any help for their validation during testing in QA
• Participating in Regression testing for each release
• Prepared & Discussed on Test Summary Report for User stories execution.

Confidential, Pittsburgh, PA

QA Consultant

Responsibilities

• Involved in Daily Stand up meetings with the team.
• Involved in preparing Test Plans based on Business Requirements Document (BRD) and prepared the Test cases and Test Procedures using RTC.
• Configured Selenium WebDriver, TestNG, Ant tool and created selenium automation scripts in java using TestNG prior to agile release.
• Preparing Test scripts &Test Evidence documentation and helping automation scenarios in Selenium
• Involved in Flow4 and Flow 2 data workflow as per mapping requirement document in Oracle.
• Mapped requirements with Test Cases and executed them reporting a pass or fail status..
• Involved in UAT meetings and updating status of test cases in RQM, uploading test cases in RQM.
• Preparing Test Plans, Test execution documents, UAT document, Test results document.
• Extensively used SQL queries for data validation.
• Responsible for designing, building, and supporting advanced cloud automation workflows and tools used to support automated CI/CD pipeline application deployments
• Generated the detailed reports of the Defect and Assigned defects.
• Involved in Sprint grooming, Sprint review, Retrospective, UAT, and Regression meetings.
• Writing data scripts with respect to the functional requirements for data validations and coordinating with dev team and BA’s for clarification on functional requirements.

Confidential, Pittsburgh, PA

QA Tester

Responsibilities

• Involved in Multiple projects and multiple environments functional testing, KT from SME's.KT to Offshore team.Actively involved in discussion with Dev team, Database team, BA's.
• Involved in preparing Test Plans based on Business Requirements Document (BRD) and prepared the Testcases and Test Procedures using TFS, Communicating with Offshore/Onshore.
• Created automated scenarios using Selenium for regression testing and executed Selenium test scripts on different browsers and checked for compatibility using Selenium Grid Followed Agile methodology was part of sprint planning and attended daily stand-up meetings.
• 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 and executed them reporting a pass or fail status.
• Involved in Scrum,Sprint planning,Retrospective,Regression meetings.
• Involved in functional and Regression testing.
• For each feature positive and negative test cases were written using TFS.
• Extensively used SQL queries for data validation.
• Generated the detailed reports of the Defect and Assigned defects
• 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.4

Confidential

Sr.Test Engineer

Responsibilities:

• 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, Involved in Sprint Plan & Retrospective 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, jira, MS Access/Excel/, Win SCP, UNIX, Rally, SharePoint.

Confidential

Sr.Test Engineer

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 Manager 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, Involved in Sprint Plan & Retrospective 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 oversaw 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 Manager 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.

Confidential

Test Engineer

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