Summary

• 7-years of diverse experience in IT with emphasis on Quality Assurance Testing of Web, Client/Server and N-tier applications on Windows and UNIX environment.
• Strong understanding of Software Development Life Cycle SDLC and ability to work as the primary interface between Business Users and Developers/System Analysts.
• Experience in software development methodologies like Waterfall, and Agile
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, SQL Server, Oracle, and ETL.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Strong experience in extended validation of report functionality developed, using Business Objects, by writing complex SQLs at the backend.
• Strong knowledge of ETL, Warehouse and SAP BI applications integration
• Proficient in analyzing business requirements, functional and technical specifications and user requirements
• Expert in creating Test Scenarios from Requirements and Use Cases, Test Planning, Test data Preparation, Test Case Execution, Defect Reporting and status reporting
• Created automation testing framework using Selenium and QTP
• Extensive knowledge on test and defect management tools like Quality Center and Jira
• Experience in Smoke, Black Box, White Box, Functional, Integration, Regression, UAT, Database and backend testing with strong Knowledge of Performance Testing concepts
• Experience in VB Script and demonstrated the ability of creating, maintaining and enhancing Functional Test Scripts using Descriptive Programming on Quick Test Pro
• Extensively used various features of automation testing including checkpoints, parameters, Output values, regular expressions, reporting mechanism and script debugging using VB Script for business process testing using QTP
• Proficient in designing, developing, implementing and documenting test cases for back-end testing in Oracle, SQL server for Data comparison and Data validation by writing complex SQL queries.
• Expert in indentifying the reusable code and creating reusable actions, functions and libraries to integrate with the framework
• Developed test strategies for GUI, Web Applications, Web Services, Client-Server, Database/Data Warehouse applications.
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and provided system solutions using new approaches
• Excellent skills in overall Defect Management/Problem Solving including tracking bugs, reporting using Quality Center, Test Director , and Jira
• Exceptional ability in writing Test Plan, Test Cases, design Automation Test Scripts, review Test Cases, Test Execution Result Analysis and creating Traceability Matrices
• Deep understanding of technology with focus on delivering business solutions
• Excellent communication and presentation skills, self starter, quick learner and team player

Technical Skills:

Professional Experience:

Confidential

QA Analyst

Responsibilities:

• Involved in gathering requirements and maintained requirements in Requirements tab of Quality Center.
• Involved in creating Test Plans, Test Cases and Test Scripts by using Quality Center.
• Automated the test scripts for the Functional, Data Driven and Regression testing using QTP.
• Followed monthly sprint cycle iterations during Testing Agile-scrum methodology .
• Script enhancements and Data Driven Testing for large amount of data were implemented with QTP.
• Review of manual methods to design, develop and execute automated test cases using Quick Test Pro.
• Performed Regression testing, security testing, Volume testing, Positive and Negative testing.
• Performed recording of tests using checkpoints like Standard, Text, Bitmap and Database, to check the behavior of the application using QTP.
• Tested application, logged bugs, monitored progress and verified their fix using QC.
• Categorized bugs based on the severity and interfaced with developers to resolve them.
• Actively participated in enhancement meetings focused on making the product more effective in real time scenario
• Prepared test execution daily schedule.
• Performed manual and automation testing of web-based application.
• Performed data driven testing using QTP.
• Performed Cross Browser Testing using Google Chrome, Internet Explorer 8.0/9.0/10.0
• Developed execution Plans and tested, and documented the results using Excel. Used MS Team Foundation Server TFS for controlling the versions of excel files.
• Prepared the traceability matrices to fill the gap between the requirements and test cases covered
• Used Production data to reproduce and analyze the problems from the production environment
• Wrote SQL Queries to retrieve the data from various Tables and to test the database using SQL Server 2008 R2 and for back end data validations
• Tested Canned/Ad-hoc reports using SAP Business Objects XI R3.1 functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects

Environment: Quick Test Pro 9.2/ 11, Quality Center 10/ 11, MS TFS, SQL Server 2008 R2, SAP Business Objects XI R3.1, VB Script, XML, SOAUP UI, Windows 7, and UNIX

Confidential

QA Analyst

Responsibilities:

• Reviewed Business Requirement Documents and the Technical Specification, Test plan, Implementation Specifications.
• Developed test plans, test cases based on functional specifications and design documents.
• Perform the testing based on Web application and parallel worked with developers and other QA team members.
• Generate Automation test Script in order to test Web applications Windows and UNIX/Linux Environment.
• Involved in developing functional test scripts using QTP as a part of automated testing.
• Maintained requirements and created Traceability between Requirements and Test Cases.
• Developed test automation scripts using QTP for Regression, Functionality, and GUI testing.
• Created the sample data with the required modifications to ensure both positive and negative testing of the guiding operations.
• Created GUI files using QTP performed Data Driven Testing DDT .
• Developed keyword and hybrid frameworks using QTP.
• Extensively used PL/SQL queries to verify the data against backend data in Oracle database.
• Involved in Defect review meeting and Interacted with developers to resolve technical issues and investigated the bugs in the application.
• Developed Manual and Automation Testing Framework for QC QTP.
• Involved in coordinating with SME to discuss different scenarios at the time of scripting Test Cases.
• Used Quality Center to track, report defects and Email notifications to appropriate teams.
• Developed and executed manual test scripts using test plan and test lab sections of Quality Center for System testing, Integration testing and Regression testing of the application.
• Bugs that would enhance the usability of the application were logged using Quality Center.
• Documented test results and provide status updates to the QA Team Manager and Test Coordinator.
• Maintained different versions/documents on MS Share point framework
• Worked on Calyx Point Software, It is the 1 provider of mortgage solutions for banks, credit unions, mortgage bankers and brokers.

Environment: Quality Center 9.5,QTP 9.5, Oracle 9i, TOAD, MS Share Point, MS Office, Version One, Agile, Informatica 6.1, Calyx Point, UNIX, and Windows XP

Confidential

QA Analyst

Responsibilities:

• Perform the testing based on Web application and parallel worked with developers and other QA team members.
• Analyzed the business requirements and functional requirements to prepare test plans, test procedures, test cases and test scripts
• Extensively wrote SQL queries to do backend testing to compare and validation of the data, worked with MS SQL Server to do backend testing.
• Worked with Manual and Automated testing of different Web applications on Windows and UNIX/Linux Environment.
• Involved with Weekly Agile Meeting and discuss about progress, required modification and upcoming work. Discuss about some potential issues and communicate with developer in order to make appropriate solutions.
• To submit each day of work to QA manager as well as QA Lead.
• Worked closely with developers and other QA members to define test requirements and developed test cases based on the Business requirements and System requirements.
• Used JIRA to developed test cases, test plan and Test scenarios execute test cases, analyze any defects or bugs and report to appropriate departments.
• Worked closely with Business teams and participated in Business Acceptance Testing BAT .
• Involved in System-wide Integration, regression and Load testing.
• Used production data to reproduce and analyze the problems from Production environment.
• Actively participated in status report meetings and communicate with other team members for technical issues.
• Maintained different versions/documents on MS Share point framework

Environment: Jira 3.13, MS SQL Server 2008 R2, MS Share Point, Version One, Scrum meeting, UNIX, and Windows XP

Confidential

ETL Tester

Responsibilities:

• Involved in gathering requirements and maintained requirements in Requirements tab of Quality Center.
• Developed and executed software System Test Plans and Test Cases. Developed Scripts by analyzing the business requirements documents, and technical specifications documents.
• Validated all transformation routines and Aggregate values in the target with the non-aggregate values in the source tables.
• Developed the Test Cases to test functionality, and interface of the application.
• Used Quality Center to store all testing results and metrics.
• Planned and managed tests using Quality Center and performed Manual Testing.
• Conducted Functional, Integration, System, and Regression testing
• Tested the data loading, data extraction and transformations in SSIS as part of ETL testing
• Validated the Business Objects reports and SSRS reports by writing SQL Statements
• Wrote SQL Queries to retrieve the data from various Tables and to test the database
• Used MS TFS for version control as part of configuration management.
• Generated automated Test Scripts using Selenium IDE for Regression testing
• Participated actively in the team meetings with the Developers for fixing the bugs.
• Involved in Design and development of complex reports using Multiple Query Providers, Ranking, and Cross Tab using Business Objects XI R3.1.
• Tested Canned/Ad-hoc reports using SAP Business Objects XI R3.1 functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects

Environment: Selenium IDE 1.2.0, Quality Center 9.5, MS TFS, SSIS, SSRS, SAP Business Objects XI R3.1, Oracle 11i, SQL Server 2008 R2/ 2005, Windows NT, UNIX, and MS Excel

Confidential

QA/DWH Tester

Responsibilities:

• Followed Waterfall methodology for larger releases and Agile methodology for interim releases to smoothly guide the SDLC process for the implementation of the projects.
• Analyzed the business requirements and functional requirements to prepare test plans, test procedures, test cases and test scripts
• Worked in Agile software development methodology and used daily scrum meeting to provide the daily updates and collectively document the team updates.
• Extensively interacted with developers, business management teams to understand the business requirements and ETL design document specifications.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Written test cases to test the application in Quality Center 9.0
• Tested a number of complex ETL mappings using Informatica 6.2
• Creating test cases for ETL mappings and design documents for production support
• Extracted data from various sources like Oracle, flat files and DB2 server.
• Worked on issues with migration of Data from development to QA-Test Environment
• Extensively tested several Business Objects XI R1 Reports, SSRS reports and Dashboards to validate the reports the data and cosmetics of the report.
• Developed execution Plans and tested, and documented the results using Excel. Used VSS for controlling the versions of excel files

Environment: Quality Center 8.5, MS VSS, Oracle9i, SQL Server 2008, IBM DB2, Informatica 6.2, SSRS, SAP Business Objects XI R1, Windows NT, UNIX, and MS Excel