Test Cases Sql Server

V. Matt Abraham

Lewisville Texas ***** Cell Phone # 469-***-**** Email – ****.********@*****.***

Sr.QA/ Lead Analyst with expertise in all phases of testing for client/server,

Web applications, POS and UAT testing

SUMMARY:

Over 12 years of extensive experience in ITES and IT industry in software development life cycle, analysis, design, development and Testing and integration of various applications. Worked as QA Analyst/Tester and Trainer (Process training, communication and business etiquettes). Experienced in creating and executing Test Cases, test plans and possess good knowledge of QA Methodologies. Sets standards and identifies, recommends and implements changes to enhance the effectiveness of quality assurance strategies. Experienced in documentation and automation of testing using Quick Test Professional in the client/server and web-based applications. Used Quick Test Professional for regression/functionality testing of .NET applications.

Experienced in Integration, Sanity, Regression, Functional, System-testing, Performance testing, End-to-End testing, GUI testing, Web services testing, Compatibility testing, User Acceptance testing of web-based and client/server applications. I have worked on several QA tools like Quality Center, ALM, Clear Quest, Agile Craft, SOAPUI, Load Runner etc. Used in Requirements, Test Plan, Test Lab and Defect Management. Holds strong ability to handle multiple priorities and prioritize workload. My strengths include excellent communication skills, a quick learner, excellent analytical and problem solving skill and a good team player as well as an individual contributor.

TECHNICAL SKILLS:

Testing Tools: ALM, Quality Center, Quick Test Pro (QTP) 9.2, Selenium, SOAPUI, ClearQuest 7.1, Load Runner, Etalk, Nice Player, Click2Coach, QM Tool, Ranorex, Perfecto.

Languages: .Net, C++, VB Script, Java Script, Visual Basic, PL-SQL

Database: MS SQL and Oracle

Documentation: MS Word, MS Excel, MS PowerPoint, Visio

Operating Systems: MS-DOS, MS-Windows 95/98/NT 4.0/2000, Windows 7 Enterprise, LINUX, UNIX

EDUCATIONAL PROFILE:

Bachelors in Business Management.

WORK EXPERIENCE:

Think Finance (Contract – Intersect Group)

Sr.QA Analyst Sep 2015 – Dec 2016

Create and execute tests based on the business requirement documents and functional specification documents for Loan origination.

Create mobile application test cases for iOS and Android devices

Execute test cases for iOS and Android using Perfecto

Create various edge cases.

Defect tracking.

Assist in creating the test data and maintenance of data

Create Test strategy documents

Help in executing test cases using wiki page in Fitnesse

Monitor the queues and handler behaviors.

Help in creating and modifying wiki pages for automation testing.

Lead and drive the development of test schedules, resource plans

Escalate risks and issues.

Managing offshore activities and assigning tasks

Support and help mobile testing.

Close interaction with the development team and project managers to communicate requirements, change request, timeline changes,

Attend Sprint planning sessions

Attend defect triage meeting to prioritize the severity of defect from business perspective.

Verify fixes provided by developers to software issues found during testing.

Environment & Apps: TFS, Microsoft Test Manager, SQL Server 2014 Management Studio, NLS, Fitnesse, Ranorex, Perfecto.

Blue Cross Blue Shield (Contract - Galmont)

Lead QA Analyst Apr 2015 – Sep 2015

Prepare complex test cases / scenarios

Review and approve manual test scripts and capture results.

Report defects found during test execution through defect tracking system.

Test fixed defects and move towards closure

Assist in creating the test data and maintenance of the data

Drive preparation and verify readiness of test environment

Escalate risks and issues as needed

Communicate requirement, change request, timeline changes, and prioritization impacts to project team, project leads, supervisors and managers

Participate in discussions and process improvement activities Comply with corporate, departmental and other applicable policies

Create and execute tests based on the business requirement documents and functional specification documents.

Reports testing.

Verify fixes provided by developers to software issues found during testing.

Support test case development and update activities.

Assist UAT testing and documenting business scenarios.

Environment & Apps: Microsoft .NET, MS SQL Server 2008, Win 7 Enterprise, HP ALM.

Rent A Center (Contract- RCG Global Services)

Sr.QA Analyst (POS) Sep 2014 – Mar 2015

Attend scrum meetings and scrum of scrum meeting.

Attend triage meetings to discuss the business requirement and defects priority.

Help create test plans and execute test cases.

Create and execute tests based on the business requirement documents and functional specification documents.

Attend grooming session for new epics, features and user stories.

Validating the deployment changes into production environment

Verify fixes provided by developers to software issues found during testing;

System migration and implantation testing.

Production support.

Support system integration and testing.

Support test case development and update activities;

Support other test, development and professional services team members on testing activities

Assist UAT testing and documenting business scenarios.

Regular interaction with the stakes holders, developers and BA’s.

Conducting demo sessions to the business before the end of sprint.

Environment & Apps: Microsoft .NET, XML, MS SQL Server 2008, OfficeXP,

Win 7, HP ALM, SOAPUI, Agile Craft, FTP.

Retalix

Sr.QA Analyst (POS) Sep 2013 – Sep 2014

Reviewing, developing, and following test processes based on industry and best practices

Developing and executing end-to-end test plans, scripts and cases.

Reviewing the business requirement documents and functional specification documents.

Evaluating test results and work with the POS programmer to resolve any defects

Maintain a traceability matrix document to track test cases to the requirements.

Documentation of business scenarios.

Building and developing knowledge of available test practices and tools; Develop and maintain product knowledge

Validating the deployment of POS changes into production environment

Verify fixes provided by developers to software issues found during testing;

Update and install the software patch

Communicate testing status to management and technical leads/key developers.

Coordinating with offshore teams for testing.

Support system integration and testing.

Support test case development and update activities;

Support other test, development and professional services team members on testing activities

Leading the UAT testing.

Environment & Apps: Microsoft .NET, MS SQL Server 2008, XML, HTML, OfficeXP,

Win 7, Win 2000, HP ALM, SOAPUI, StorePoint, FTP.

Wells Fargo (Abeam Consulting)

Consultant – Sr.QA Analyst Sep 2011 – Sep 2013

Responsibilities and Accomplishments:

Review all the application documents-BRD, FSD and MTP; create test plans and test cases.

Manage and maintain test strategy, test plan and test cases.

Manages the creation of all project level test plans, detailed test plan, or phase level plans such as system, integration or user acceptance test plan.

Contributes to the initial project design phase of a project(s), providing input on test plans, estimates, and test strategies for a project(s).

Execute tests independently.

Manage and coordinate with offshore teams.

UI Usability analysis testing and GUI testing

Web services testing.

Report testing on database server.

Attend Business review meetings with the Business Analysts and operations team.

Status reporting.

Develop test strategy for the online portal.

Supporting and help UAT testing.

Manage QA process and workflow

Help identify the key business processes within the project.

Helps in building and establishing a QA practice, leveraging best practices, configuring tools, defining processes, etc.

Performed database testing to verify the results generated by the batch applications.

Interact with the Business and provide support.

Review the BRD, FSD and create Master Test Plan.

Environment & Apps: VB, Microsoft .NET, SQL Server 2008, HTML, XML, QTP, Office XP, Win XP, Win 2000, Quality Center 11, ClearQuest, SOAPUI, Sharepoint.

RealPage Inc.

QA Analyst/Tester April 2010 – Sep 2011

Responsibilities and Accomplishments:

Review all the application documents; create test plans and test cases.

Write test plans, test cases, test results reports.

Create test cases to perform functional and regression testing

Execute tests independently.

UI Usability analysis testing and GUI testing

Report testing on database server.

Attend Business review meetings with the Business Analysts and operations team.

Use compiled modules to perform certain operations.

Certification of test scripts.

Develop test strategy for the online portal.

UAT testing.

Performed database testing to verify the results generated by the batch applications.

Interact with the Business and provide support.

Environment & Apps: VB, Microsoft .NET, SQL Server 2005, HTML, QTP, Office XP, Win XP, Win 2000, Quality Center.

Ali Alghanim & Sons

QA Analyst/Tester Jan 2007 – May 2009

Project: Product Item Usage

Duration: 11 months

This project is a GUI based application, which enables the users to check the status of the products in stock, the price of the product, landed cost, retail price, whole price etc. GUI, Database, Integration, User Authentication & credentials testing was performed. This project followed the Scrum methodology of Agile.

Responsibilities and Accomplishments:

Review all the application documents, created test plan and test cases.

Performed GUI testing.

Performed web based testing, using check-points.

Created test cases to perform functional and regression testing

Performed automation testing using the test cases developed and reported to developers.

Used compiled modules to perform certain operations.

Wrote user defined functions in Quick Test Pro.

Developed test strategy for the load test for the online portal.

Created the automated load test scripts for performance testing of the online portal.

Performed database testing to verify the results generated by the batch applications.

User Interface usability analysis

Tested front end POS application with various hardware interfaces.

Environment & Apps: VB, Microsoft .NET, QBasic, SQL Server 2000, HTML, QTP, Load Runner, Office XP, Win XP, Win 2000, Quality Center.

Project: Qapps

Duration: 12 months

This project is an application which enables the users to transfer stock from one warehouse to another, from one retail store to another, it consists information of the product, shipped date, order placements etc.

Responsibilities, Accomplishments and Achievements:

Analyzing and understanding the Requirement Specification

Created test cases and test plans to perform functional and regression testing

Performed manual testing using the test cases developed and reporting defects.

Performed Integration testing, regression testing.

Back-end testing was done using SQL scripts

Used Quality Center for saving all the test scripts.

Attending Sprint Stand-up meeting.

Supporting UAT

Project Reporting on a day-to-day basis during Test cycle

GUI Testing

Environment & Apps: VB Script, Microsoft .NET, SQL Server, QTP, Quality Center.

Dell International

QA Analyst/Tester Jan 2006 – Jan 2007

Project: Cost Tool

Duration: 10 months

GUI based application, which enables the Buyers to upload the ODM (Original Design Manufacturer) parts & price, Bill of Material (BOM) etc .As well as a Market quoted price analysis report & Price auditing report was also generated. GUI, Database, Integration, User Authentication & credentials testing was performed. This project followed the Scrum methodology of Agile.

Responsibilities, Accomplishments and Achievements:

Analyzing and understanding the Requirement Specification

Created test cases and test plans to perform functional and regression testing

Performed manual testing using the test cases developed and reported defects to developers.

Involved in functional testing of the system, integration, system & regression test cases

UI Usability analysis testing.

Performed Integration testing, regression testing.

Positive and Negative testing was performed for this application

Back-end testing was done using SQL scripts

Used Test Director for saving all the test scripts.

Attending Sprint Stand-up meeting.

Supporting UAT

Project Reporting on a day-to-day basis during Test cycle

GUI Testing

Environment & Apps: VB Script, Microsoft .NET, ASP, SQL Server 2000, Quality Center.

Role as Quality Analyst

Handling the Review Appeal Process for Defect Tracking.

A Bi-weekly business presentation based on the audit analysis & factors affecting CE & compliance issues of the respective segment

Involved in the Call Flow Model (CFM) project to identify the AHT drivers.

Involved in the BBN project to identify the reasons for multiple transfers done in a call (End-End) made by a customer to Dell. As well as feedback for the performance and usability improvement of the tool was made.

Analyzing the audit results of all customer care support department using Nice Player.

Won the award for the Best QA in Dell in 2006.

Environment: Office XP, Win XP, Win 2000, Win 2003 server, Nice Player

Microsoft

Quality Analyst Jun 2005 – Dec 2005

Responsibilities and Accomplishments:

Involved in monitoring and analyzing the case handled by support engineers.

Ensured effective feedback was given with respect to the case handled.

Involved in creating internal quality process documents.

Regular meetings with the team managers and group managers to discuss the support engineer’s performance.

Regular checks of case reviews and process assurance

Ensured that the KPI’s and SLA’s were met.

Involved in recruiting and training the new QA’s.

Quality check on QA’s completed work.

Attended Six Sigma training.

Attend and organize calibration session, internally and externally.

Environment & Apps: Microsoft Office XP, Win XP, Win 2000, Click2Coach, QM Tool.

IBM

Quality Analyst Apr 2004 – June 2005

Responsibilities, Accomplishments and Achievements:

As a QA, I was to make sure that that KPI’s and SLA were met on a monthly, quarterly and yearly basis.

Define and implement the QA process

Involved in call and case monitoring of associates and providing them feedback.

Ensured that all the information provided to the customer was accurate and made sure the customer was called back and provided the right information, in case of wrong information provided.

Attend and run the calibration session with internal and external client

Review QA audits.

Supporting & Developing training sessions and coaching within the team.

Lead the team for meetings and huddle sessions.

Involved in interviewing and recruiting process.

Training the new recruits.

Involved in certification of new employees after the training.

Underwent Six Sigma training.

Received the Best QA award in 2004.

Environment & Apps: Microsoft Office XP, Win XP, Win 2000, E-Talk.

First Ring

Quality Analyst Jun 2002 – Apr 2004

Responsibilities, Accomplishments and Achievements:

Monitoring and auditing cases

Case reviews

Attending calibration sessions.

Ensure that the KPI’s have been met.

Drive towards C-sat scores and drive quality focus.

Provide feedbacks and train the representatives.

Assisting customer with their orders and providing support.

Involved in interviewing and recruiting process.

Involved in the certification process for new hires,

Training the new recruits on the process and products.

Contact this candidate