Sql Server Project Manager

Sujatha Ayyappan

Bellevue, WA (H): 425-***-**** (C): 717-***-**** Email: *************@*****.***

CAREER OBJECTIVE: QA Automation Engineer

SUMMARY OF PROFESSIONAL EXPERIENCE:

• Having 5+ years experience in QA with full life-cycle testing, writing test plans, developing

test cases and implementing test strategies

• Experienced in testing software applications in various diversified domains like Health Insurance,

Real Estate, Automotive based on the requirement specifications to verify the functionality of the

application code using automated testing tools

• Well experienced in Software Development Life Cycle (SDLC) and Software Testing Life Cycle

(STLC): Including Risk Analysis, Process Planning, Test Design, Performing Test, Defect Tracking,

Management and Test Reporting.

• Extensive experience in Functional Testing, Unit Testing, Integration Testing, Regression Testing,

Black Box Testing, GUI Testing, Back-End Testing, browser compatibility (cross browser) testing, in

different stages of Software Development Life Cycle (SDLC).

• Extensively involved in Manual Testing and Automated Testing.

• Around 1+ years’ experience in Automation Testing using Selenium.

• Experience in web applications automation testing with TestNg, JUnit, Selenium WebDriver,

Selenium Grid, SVN and Maven.

• Moderately worked in Selenium WebDriver & Grid, Selenium Data driven Automation framework.

• Experience in testing Web Services both SOAP and Rest Based testing using SoapUI.

• Strong experience in writing/running manual test cases to pinpoint software defects, track

bugs, close open defects and validate functionality

• Coordinating the Testing activities with Development Team

• Go-getter, Good team player with excellent communication and interpersonal skills

TECHNOLOGY PROFICIENCIES:

Operating Systems : Windows XP, Windows 7, Windows 8.0/8.1, Windows Server

2008, Sun Solaris

Testing Methodologies : Functionality Testing, System Testing, Regression Testing,

Acceptance Testing, GUI testing, Database testing

Languages : Java, VBScript, Java script

Databases : Microsoft SQL Server 2005, Microsoft SQL Server 2008 R2

Web Technologies : HTML, XML, DHTML, Internet Explorer, Firefox, Google

Chrome

Testing Framework/Tools : Selenium (Selenium WebDriver, Junit, Javascript, Selenium

Grid), QC, Selenium Server, Eclipse IDE, ANT, TestNg, Maven,

Microsoft SQL Server Management Studio, SVN

Management Tools : Quality Center, JIRA, Microsoft Excel, MS Office Suite

PROFESSIONAL EXPERIENCE:

Client: Schakra Inc. Redmond WA Jan 2013 – Till date

Project: Appraisal Management Solution.

Role: QA Selenium/Test Engineer

Description: This is a web application that helps Lenders and Appraisal management companies

to streamline their appraisal process for Real Estate business in compliance with the UAD

regulations.

Responsibilities:

• Worked with the business analysts to understand the user stories, functional requirements for

the system

• Actively involved in the preparation of test plans and test cases documents.

• Created test conditions and test scripts. Identified and captured test data to support the test

cases defined for the application.

• Created automated scenarios using Selenium for regression and Data-Driven testing.

• Developed unit test scripts using Eclipse IDE and JUnit framework. Performed data driven

testing using Microsoft EXCEL and JUnit framework.

• Actively worked in the functional and regression testing and proactively worked to improve

the software quality

• Performed web testing and automated testing using Selenium in the test environment and

opened bugs in the bug tracking tool. Prepared the test summary report.

• Interacted with the development team to resolve the defects and tracked the defect

resolutions.

• Performed database unit testing using T-SQL queries in SQL Server for data quality in GUI

and the backend. Created SQL queries for searching, creating and updating test data and ensured

data quality.

• Used Selenium Grid to test the compatibility of the tests across multiple servers to save time.

• Interacted with DBA's, developers, systems engineers and network engineers during testing and

isolated bottlenecks at different levels.

• Agile scrum methodologies followed for development

• Performed Web services testing using SOAPUI framework

• Performed defect tracking and bug closures. Created code coverage reports

• Created test reports using ANT

• Responsible in providing regular test and defect status reports to the QA manager.

Environment: Selenium WebDriver, JUnit, Javascript, Eclipse IDE, JIRA, Windows 8, IE,

Firefox, Chrome, HTML, XML, XML Web services, Microsoft SQL Server 2008 R2, Microsoft

SQL Server Management Studio, SOAPUI Test automation framework, ANT, Apache Tomcat

Server

Client: Schakra Inc. Redmond, WA May 2012 - Dec 2012

Project: Employees Health Insurance Benefit Enrollment System

Role: QA Tester

Description: This is an intranet web application that is used by the employees of the Fujifilm

Co. to enroll for the Medical, Dental, and Vision Insurance in the appropriate benefit schemes

during enrollment period based on their preference.

Responsibilities:

• Extensively involved in all phases of SDLC (Software development Life cycle) using agile

methodology (SCRUM).

• Collaborated with subject matter experts to prepare test conditions that properly test the

application end to end.

• Involved in preliminary meetings with core project team to discuss Business Requirement Document

(BRD) and worked closely with product manager and Scrum master for Sprint Demo.

• Worked on preparing the Test plan, Test scenarios, Test Cases and identified the test

deliverables

• Prepared traceability matrices to fill gaps between requirements and test cases covered.

• Worked on writing the T-SQL scripts for backend testing, verified the data quality in the UI against

the database using SQL queries

• Performed manual testing by using the test cases and test scenarios and logged defects in defect

reporting tools

• Worked with the development team to explain the bug and test scenarios and retested once the bug is

resolved by the developers.

• Prepared Test metric reports and shared the current status report with the manager regularly

• Defects management using Test Director

Environment: Java, J2EE, Windows 7, IE, Firefox, TOAD, Microsoft SQL Server, SQL Server

Management Studio, Microsoft Office Suite, Test Director

Client: Schakra Inc. Redmond, WA Dec 2011 – May 2012

Project: Inside-out Tracker

Role: QA Tester

Description: This is an intranet web application that tracks the efforts entered by onsite and

offshore vendors and FTEs who work on various ongoing projects and also used to monitor the

progress status over time. It also generates various statistical reports for the management.

Responsibilities

• Prepared the Test plan and Test scenarios for the application

• Prepared test cases that properly test the application end to end

• Identified and created test data and loaded them for testing.

• Performed manual testing on the web application. Tested the User Interface, data quality and integrity

of the application

• Performed database testing using T-SQL queries

• Executed test cases and opened bugs in the bug tracking tool. Worked with the developers to resolve

the issue and performed regression testing after fixing the bugs

• Managed defects and test results & metrics reporting.

Environment: Java, JDBC, Windows 7, JIRA, IE, Firefox, SQuirreL, Microsoft SQL Server, TOAD,

Microsoft Excel, XML, HTML

Client: Social Interest Solutions, Sacramento, CA May 2010 – Nov 2011

Project: Health Insurance App

Role: QA Functional Tester

Description: This is a web application that facilitates online enrollment for health insurance for the low

income people in the California & Arizona state. The application provides the individuals and families to

efficiently identify, access, and enroll in eligible public and private health and social services.

Responsibilities:

• Collaborated with the SME to understand the various health insurance benefit schemes and the

business rules and prepared the Test plan and test strategies

• Identified the various test scenarios and prepared the test cases

• Working closely with development and business teams to implement the business rules and validated

the workflow of different process involved in the web application

• Prepared the traceability matrix document to correlate the test cases with the business requirements.

• Performed integration testing, system testing, functional testing and raised bugs for tracking the

issues

• Worked with the developers to explain the test scenarios and resolve and close the bugs on priority

basis

• Communicated testing status to QA lead, project managers, and cross-functional teams who are

involved in User Acceptance Testing.

• Tracked and updated the bugs using JIRA.

• Generated the test results reports and published

Environment: JAVA, J2EE, JDBC, Tomcat 6, QC, Windows XP, Microsoft SQL server, Toad, Windows

Server 2008, IIS, IE, Firefox, SOAP, XML, HTML, Web Services, Test Director

Client: TRW Automotive Feb 2009 - Apr 2010

Project: Concern Tracking System

Role: QA Tester

Description: This is a web application that manages the raw materials supplier information of

the client and manages the rating and quality of materials supplied by its various suppliers. The

application monitors the contingent and corrective actions taken by the suppliers who were

earlier identified as defective material suppliers or defaulters to supply materials as per the

agreement with the suppliers.

Responsibilities:

• Participated in the Requirement gathering meeting with the Client managers, Project manager

and Test team

• Collaborated with the business analysts to understand the business rules and workflow

scenarios

• Involved in the test plan, test cases documents preparation.

• Involved in the test environment setup and test data generation for testing the application

• Performed manual testing in the UI and verified the data quality in the backend by writing T-

SQL scripts

• Executed the testing on multiple browsers to verify the expected application behavior and

consistent look and feel of the application

• Created test summary reports and shared with the team members

• Defect tracking using JIRA

Environment: Java, JDBC, Microsoft SQL Server, JIRA, QC, Microsoft Excel, Windows XP,

Webservices, IE, Firefox, XML, JIRA

Education Qualifications:

• Master Degree in Computer Applications (3 years), Bharathidasan University, India

• B.Sc. (3 years), Madras University, India

Training Course Completed:

• STC Technologies, Chennai, India – Software Testing Training Program

• SRM Radiant Infotech Ltd, Chennai, India – Advanced Java Programming

Contact this candidate