SUMMARY

• Over 7 years of IT experience as Quality Analyst (Manual & Automation) and Developer/Analyst (C# .NET & SQL Server) in Insurance, Banking, Healthcare and Retail IT Industries.
• Strong knowledge of Business Intelligence and Data Warehousing (SQL Server, SSIS, SSAS, SSRS).
• Experience in testing of Client Server and Web based applications using Manual testing techniques and Automation Tools (QTP, VSTS).
• Involved in entire Software Development Life Cycle (SDLC) - Requirement Design and Analysis, Development, Testing, Deployment and Support phase and also in QA Life cycle which includes Designing, Developing and Execution of the entire QA Process.
• Expert in Black-box, white-box, functional, negative, regression, system integration (SIT), User acceptance (UAT), end-to-end (E2E) application testing including Front-end testing (GUI), Back End (DB) and Browser compatibility testing.
• Experience in test case creation, test execution, bug reporting & bug tracking using test management tools such as Visual Studio - Microsoft Test Management (MTM) and HP Confidential Quality Center (QC)/ALM.
• Hands on experience in Manual and Automated testing using Quick Test Professional, Visual Studio - Coded UI Framework and Exposure on Load Runner, Rational Tools.
• Proficient in Automation testing using automation testing tool - QTP and Performance testing using the performance testing tool - Load Runner.
• Used Visual Source safe (VSS) and Team Foundation Server (TFS) as a version control system.
• Expertise in Database Testing which includes data testing, data types, database performance, stored procedures, joins, views, aggregate functions etc.
• Experience in creating Requirements Traceability Matrix to ensure comprehensive test coverage of requirements.
• Experience in .NET development environment. Worked in .NET/C#/JavaScript/HTML/ Visual Studio/ SQL /VSS/IIS environment as developer.
• Good working knowledge of major Operating Systems and tested applications on Windows and UNIX environments.
• Excellent communication skills, self-motivated, detail oriented, time bound, responsible team player and ability to coordinate in a team environment.

TECHNICAL SKILLS

Test Management Tools: VSTS 2010/2012 - Team Foundation Server (TFS), MTM, HP Confidential QC 9.2, ALM, Test Director

Languages: C, C#, ASP.NET, ADO.NET, XML, HTML, Java Script SQL/PLSQL & VB Script

Database Tools: Oracle 9i/10g, Sybase, SQL Server 2008/2010/2012 , DB2, HP3K, MS -Access, TOAD, MS-Excel

Project planning: MS-Project, MS-Office, MS-Visio, and Windows Share Point

Web/Application servers: Internet Information Service (IIS), Web Sphere, Citrix, Tuxedo 8.1, Apache Server

Operating System: Win XP/Vista/7/8, Server 2003/2008/R2, UNIX, Linux

PROFESSIONAL EXPERIENCE

Confidential, CA

QA Analyst

Responsibilities:

• Involved in analyzing the Business requirements and System specifications to understand the Application.
• Developed Test Plan and Test Strategy document.
• Involved in extensive DATA validation using SQL queries and Database testing of different modules of the application.
• Involved in Automation testing for Quick Silver application to perform Regression testing for every modification in the application & new builds using QTP.
• Extensively worked with GUI, Functional testing, Regression testing, System Integration Test (SIT), Regression, smoke testing of the modified build, and Load Testing.
• Prepared the Test Scenarios and Test Cases for the AUT using Quality Center.
• Used UNIX commands to access and update files.
• Performed Data Base testing to verify data integrity after every transaction using SQL query in SQL Server.
• Checked database to determine successful transaction of test data from the application by establishing database connectivity and by using T-SQL commands.
• Conducted bug triage meetings with developers and business teams.
• Created and managed the bugs found in the application using Quality Center (QC).
• Attended sprint review with BA, DEV & SCRUM MASTER to understand the functionalities of the stories and give estimation on testing.
• Categorized defects based on severity and reported them assigning the appropriate priority to developers for resolution and followed through and Interacted with Developers in fixing the bugs and logging them in Quality Center.
• Recorded and plays back test in Fire fox using Selenium IDE.
• Used Selenium tool (selenium IDE is a plug-in to Firefox) to record and playback tests and then export the recorded test in other language e.g. html, Java.
• The Exported test can be run in any browser and any platform using "Selenium Remote control".
• Interacted with end users for UAT and further modified the application based on user requirements. Assisted in documenting the user manual for end users.
• Prepared weekly status on Testing with the help of QC 9.0 to show the progress of testing effort.

Environment: QTP, Load Runner, PVCS Tracker, Java, ASP, .NET, UNIX, Oracle, Windows NT/2000, SQL Server 2008.

Confidential, TX

QA Analyst

Responsibilities:

• Involved in analyzing the Business requirements and System specifications to understand the Application.
• Developed Test Cases based on the requirements and documented Test Cases corresponding to business rules and other operating conditions.
• Carried out Smoke Test to judge the software acceptance criteria for testing.
• Wrote T-SQL Commands and SQL queries to check the contents of the MS SQL Server tables.
• Initially performed Manual Testing for functionality testing and developed automated execution of test cases using QTP for Regression testing.
• Involved extensively in code review, checking code standards and mentoring process of different modules in .NET environment.
• Checked database to determine successful transaction of test data from the application by establishing database connectivity and by using T- SQL commands.
• Participated time to time regression testing after each monthly build.
• Involved in Database testing by writing and executing SQL queries to ensure that data entered has been uploaded correctly into the database.
• Worked with Data warehouse developers in database design and modeling.
• Created stub files using XML, to test the interface between the systems
• Documented and performed defect tracking
• Analyzed, reported and kept track of defects using Quality Center.
• Provided testing results and weekly status report to QA lead, provided test summary report once project was finally completed.

Environment: Quick Test Professional 9.0,Quality Centre 9.0, JAVA, J2EE, Web Sphere MQ,VB, Query Analyzer and Enterprise Manager, SQL Server, Apache 2.0,UNIX,LINUX,Windows NT.

Confidential, RI

QA Tester

Responsibilities:

• Designed and Documented Test Procedures and Test Cases for user acceptance, functional and integration testing.
• Identified and segmented the application into various “zones” to check partial functionality of the application and search for errors and/or performance improvement.
• Identified test data based on specifications (example. user interface, compatibility with browsers/environment, database response, security, network criteria) of the product.
• Developed and executed automation test scripts using VSTS C# - Coded UI framework
• Parameterized the scripts to avoid code redundancy and avoid hard coding of frequently changing values.
• Used the Coded UI Test Builder to add the Web UI Objects (Controls) and Validation Code (assertion methods) to verify the dynamic output values and validate the test results.
• Performed database testing using SQL DML commands to test the state of data in the DB after front end operations using SQL queries and Stored Procedures in SQL Server 2008.
• Extensively created Data Driven Test scripts to read data from text files for data validity testing. Checked for data boundaries/limits, incorrect input of data.
• Got experience in web services testing with XML and SOAP-UI for information exchange across applications for the functionalities like Login Credentials validations etc.
• Automated performance test scripts and verified the response time under different load conditions using Load Runner.
• Parameterized and Correlated the Virtual User Script and simulated the real user environment.
• Analyzed the reports and graphs in Load Runner controller to understand and remove bottlenecks.

Environment: QTP, VSTS C# - Coded UI framework, Load Runner, PVCS Tracker, Java, ASP, .NET, UNIX, Oracle, Windows NT/2000, SQL Server 2008.

Confidential

QA Analyst

Responsibilities:

• Analyzed the requirements and design documentation.
• Prepared functional test plans for different modules of the application.
• Analyzed use cases and specifications to identify the test cases.
• Assisted other developers while their functionality achieving process
• Involved in unit testing of the created application independently.
• Involved in functional testing database/backend testing, black box testing and UAT testing.
• Experience in conducting white box testing using Microsoft Visual Studio 2008 tool.
• Reviewed the code and mentoring.
• Involved in documentation of migration process from ASP to .NET environment
• Involved in debugging code related bugs assigned to me in different modules.
• Did code verification and checking code standards as per technical aspect
• Involved in complete lifecycle of the application SDLC and STLC both.
• Reporting issues and tracking them through the bug life cycle process into Test Director bug tracking tool.
• Performed Functional, System, Regression, Performance and User Acceptance testing (UAT), database/backend and black box testing.
• Developed complex SQL queries to perform Database testing.
• Documented and performed defect tracking
• Used JIRA as a bug tracking tool.

Environment: VB, SQL Server, WinNT, Oracle 8.0, Java, Web logic 7.0, SQL Navigator, Toad, Test Director 7.2, Win Runner, QTP, Load Runner.

Confidential

Software Trainee

Responsibilities:

• Understanding Business Requirements and Functional Specifications of the Application and wrote the technical specification.
• Worked initially on the development of various modules of the Asurion Handset Protection Application (ASP.NET 2.0, C#, HTML, ADO.NET, XML, and Oracle).
• Integrated StyleCop analysis into the MSBuild process (StyleCop, MSBuild, TFS), helping to improve the quality of all code checked in to source control.
• Worked on creating a deployment process (MSI) and undertook the deployment of new features and bug fixes to streamline the maintenance
• Later was involved in the testing of the application.
• Decomposing Test Conditions/Scenarios to Test Cases
• Prepared Test Data for positive & negative testing to check functionality of the application
• Developed and executed test cases & verified actual results with expected results
• Defects were tracked using Test Director.
• Involved in Functional Testing and Integrated System Testing
• Manually performed Security Testing of the application.
• Attended Walk through, Meeting with Project manager & QA team.
• Responsible for sending Daily & weekly status report using MS-Office tools.
• Involved in the code review process with other developers.
• Defect tracking and reporting used by Test Director.
• Participated in weekly meetings for status updates and changes on the project.

Environment: ASP.NET, HTML, Oracle, Windows NT, XML, Quick Test Professional, Test Director, Bugzilla, MS Word & Ms Excel