SUMMARY:

• Around 7 years of experience in the Information Technology industry with a focus on Quality Assurance, ETL Testing, Data Testing, Manual and Automation testing. Good knowledge in Software Development Life Cycle (SDLC) models like Waterfall, V - Model and Agile Methodology. Proficient in validating data by executing SQL queries on various relational databases as part of ETL Testing. Excellent knowledge in QA efforts like defining Test Plans, Test Estimation, Status Reports, test case scenarios, writing and executing manual and automated test cases and managing User Acceptance Testing (UAT) and documentation. International Software Testing Qualifications Board (ISTQB) Certified.

• Business domain knowledge in Mortgage Insurance and Media Portal.
• Expertise in defect-tracking tools like Quality Center and Bugzilla for finding and reporting bugs to release software successfully.
• Good knowledge in working with Agile methodology, Scrum sessions, and Sprints.
• Good experience in writing test cases for black box testing.
• Expertise in querying and testing RDBMS such as Oracle, MS SQL Sever using SQL, PL/SQL for data integrity.
• Developed UAT scenarios including expected inputs, expected results and test data.
• Efficient in writing Test Cases based on business requirements and use cases.
• Performed Integration testing, System testing, and Black Box functionality testing.
• Expertise in documenting, tracking, communicating test plans, test cases, test results, analysis. Tracking the functional queries to closure. Understanding of complex test requirements and able to formulate test planning and design approaches to support requirements.
• Good experience QTP tool to test functional testing,data driven testing .
• Good knowledge of DB concepts and working knowledge on different databases like MYSQL5.0, DB2 and Oracle Databases.
• hands on experience with selenium IDE tool
• Strong experience in java programming, Selenium web Driver, Junit and testNG
• Hands on Experience with ALM tool/Quality Center.
• Good knowledge with Unix commands and shell scripts.
• Validation of reports against source data.
• Good experience working with agile environment
• Good under standing of logical and physical data models
• Backend testing experience in writing and executing SQL Queries for verifying the ETL Job execution.
• Good Knowledge on PL/SQL .
• Tested store procedure, functions and trigger with sample input data.
• Prepared test data in the source systems to cover all requirements and scenarios
• Experience in testing web applications developed in JavaScript, HTML, and JSP/Servlets and J2EE technologies.
• Excellent analytical, communication and interpersonal skills.
• Good team player with the ability to manage and work independently in a time sensitive environment.

Technical Skills:

OS: Windows, UNIX, Linux, Solaris

Databases: MySQL 5.0, Oracle 8i/9i/10g, DB2 (AS 400),Teradate.

ETL Tools: Infosphere Data Stage 8.5, Talend ETL, Informatica Power Center

Database tools : MySQL WorkBench, Oracle SQL Developer, Toad, Win SQL

Test Tools: HP Quality Center, ALM,Bugzilla, Selenium, SOAP UI, HP Quick Test Professional (QTP)

XML Tools: XML Spy

Other Tools knowledge: java, FTP Client(FileZilla),Cognos Reports

PROFESSIONAL EXPERIENCE:

 Confidential, New York City, NY.

QA Tester

Responsibilities:

• Gather requirements and design docs from Business Analyst and Design team
• Review data mappings and create queries/reports based upon business rules for data elements.
• Prepared test plan and test cases based on requirements and mapping document.
• Involved in testing rates and other data in database using Oracle SQLdeveloper and Toad.
• Working with development teams investigating and correcting software bugs and deficiencies based on the testing results.
• Responsible for frent end manual testing of the application to match with application requirements and write user manuals.
• Involving in writing complex SQL queries to verify data from Source to Target
• Prepared test cases for black box testing for various scenarios and executed for the same.
• Perform Functional, Integration, System and Regression testing to check the stability of the Application.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Datastage ETL Tool.
• Comparing the Data between the source files and target databases and validating the data as per the requirements/mapping document.
• Creating the Defects in Quality Center and assigning to the Development Team
• Involved in User acceptance test and performance test
• Generate the test execution reports
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing test metrix to give a better view of testing effort
• Attended the peer meetings, review meetings and walk thought meetings.
• Have done testing the web services using SOAP UI
• Created test cases using element locators and selenium web driver methods
• Created test cases using java programming features and test NG
• conducting data driven testing, cross browser testing and parallel test execution.
• Involvement in solving environmental problem along with technical support people
• Involve in regression testing using selenium
• Preparation of weekly and monthly status reports

Environment:Windows7,DB2,Datastage8.5,Oracle,DBclient,WINSQL,Filezilla, TFP,QualityCenter 10.00,autosys,cognos report, Unix, Java,, SOAP web services,Unix,HTTP,ALM, Vistual studio.

Confidential, Detroit,MI

QA

Responsibilities:

• Review data mappings and create queries/reports based upon business rules for data elements.
• Review, analyze and evaluate detailed business and functional requirements, documentation, process flows and data models to contribute to the development data quality reports/queries.
• Develop test plans, test cases, perform testing on data elements.
• in executing the ETL Test Jobs from the Informatica power center workflow Manager to verify different test cases and validate the data.
• Verified data across Source and Target databases.
• Verified weather transformation rules applied according to mapping Documentation.
• Have done Oracle database testing by testing store processor, functions, Triggers
• Verification of the Report data against the database.
• Raised the defects in Quality Center and assigned to development team.
• Used Quick Test Professional (QTP) for regression testing and running the automation suite.
• Inserted checkpoints where needed, to compare the current behavior of the application being tested to its behavior in the earlier version using Quick Test Professional (QTP)

Environment: Windows 7, Oracle 10g, DB2, Unix, Informatica powerCenter version 8.6,DB Client like Oracle SQL Developer, WinSQL, HP Quality Center and OBIEE Reports,Autosy,HP QTP 11.5,VB script.

Confidential, Pittsburgh PA

ETL/DB Tester:

Responsibilities:

• Interacted with the Business Analyst team to get the requirements clarified.
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases
• Prepared several test scenario for the work flow of the entire ETL cycle
• Prepared test plan and test cases based on requirements and mapping document.
• Prepared the Test data bed for testing the ETL jobs in QA environment for verifying different test scenarios.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the requirements by the business teams.
• Review the test cases written based on the Change Request document.
• Testing has been done based on Change Requests and Defect Requests.
• Comparing the Data between the source files and target databases and validating the data as per the requirements/mapping document.
• Writing SQL queries to verify the data from different databases.
• Executed and managed test cases and reported bugs in Quality Center.

Environment: Oracle 10i, Oracle SQL Developer,Toad, Quality Center, Talend 3.4 ETL Tool, MS Word, MS Excel

Confidential, New york city,NY

QA tester

Confidential Media Portal

Responsibilities:

• Planning and attending the Daily Scrum meeting and getting updates about the Sprint Status.
• Review requirement document (SRS) from application development team.
• Worked with Agile environment with frequently changing requirement and feature set.
• Understand the Functional requirements and involved ambiguity analysis.
• Attended the Requirements Meeting to understand the requirements and translate them to test case scenarios.
• involved in prepare RTM’s (Requirement Traceability Matrix) assuring complete test coverage to each requirement in conversion scope.
• Written black box testing test cases according to requirement document.
• Preparation of test data according to the scenarios of the applications.
• Run the test cases and logged the defects in Quality Center.
• Involved in Regression and Re Testing to verify the bug fix.
• Created test scripts for selenium IDC and verified result.
• Involved in UAT testing for the UAT environment to support the Business Users for testing and defect tracking...
• Prepared the QA related Process documents like Test plans, Test Estimation, Requirement Traceability Matrix (RTM), Test Cases documents.

Environment:Java, SpringFramework, MySql 5.0, Quality Center, MS Word, MS Excel,Selenium IDC

Confidential, Dublin,OH

QA Tester

Roles / Responsibilities:

• Preparation of Test Plan and Functional Test Cases.
• Preparation of test data according to the scenarios of the applications.
• Ran the test cases and logged the defects in Bugzilla.
• Prepared test cases for most of black box testing and executed same
• Involved in SOAP UI testing for the web services testing for external services.
• Involved in Regression and Re Testing to verify the bug fix.
• Involved in UAT testing for the UAT environment to support the Business Users for testing and defect tracking.
• Have done coordination with off shore regards update on testing statues.
• Prepared the QA related Process documents like Test plans, Test Estimation, Requirement Traceability Matrix (RTM), Test Cases documents.

Environment: Java/DotNet Web application, Oracle 9i, PL/SQL, Bugzilla, SOAP UI, MS Excel and MS Word.