Sign in

Test Cases Sql Server

United States
April 12, 2018

Contact this candidate



Email : Ph : 925-***-****

Technical Summary

Over 8 years of experience in performing Manual Testing with emphasis on Quality Assurance including test planning, test cases and test executions of web based and client-server based applications.

Done extensive Manual Testing, Black Box Functional Testing, Regression Testing and Test case documentation and automated manual test cases where applicable.

Proficient in Manual Testing in Client /Server, Web, Mobile and Database applications.

Good understanding of SDLC and various software testing methodologies.

Extensive experience in User Acceptance Testing and System Testing.

Experienced in the analysis of functional, Business requirements, specifications and developing and executing Test Cases and Test Procedures.

Experience in writing defining test cases, developing and maintaining test scripts.

Experience in both Agile and Waterfall methodologies

Experience in testing database applications of RDBMS, MS SQL Server and MySQL.

Familiarity with Automation Testing using Selenium Web driver.

Experience with API Testing using Postman tool

Good understanding in testing Web Services using SOAPUI tool

Become familiar with new technologies, Operating Systems, applications in order to maintain an awareness of technological advance.

Experience with Microsoft Development and Office Tools.

Excellent Analytical, problem solving and communication skills.

Technical Skills:

Operating Systems :

Windows10, Windows XP/2000, XP professional, Unix/Linux, iOS

Databases :

MS Access, MS Excel, MS SQL server, Oracle

Office Applications :

Microsoft Office suite (Outlook express, MS-Word, Excel and Power point, Visio)

Tools :

Selenium, SoapUI, Postman

Management Tools

Rally, Jira, Quality Center

Languages :


Browsers :

Edge, IE, Firefox, Chrome, Safari

Old Republic Home Protection, San Ramon, CA

Sr. QA Analyst

August’15 – Till Now

Old Republic Home Protection's Home Warranty Plan offers Plan Holders comprehensive protection against the high cost of repair or replacement of their home's major systems and appliances. The parent company, Old Republic International Corporation, is one of the nation's 50 largest publicly held insurance organizations.

Working as a primary QA, responsible for managing entire testing lifecycle from initial planning of the projects through releases.

Frequently meets with Business teams to get proper requirements.

Responsible for huge regression process and created good documentation for the existing legacy systems.

Proven record of reducing hotfixes up to 90% on continuous releases.

Responsible for the new UI testing.

Actively participated in User Acceptance Testing.

Actively participated in ongoing business training.

Actively Participated in agile Daily stand up meetings and weekly sprint meetings.

Reviewed requirements, specifications documentation to gain a thorough understanding of the programs, Processes and Work flow.

Requirement Analysis from the demand of clients, verify the scenario as per demand of application.

Created detailed test plans and attributes to verify the compatibility of different web based applications.

Created the scenarios for testing and validation according to specifications and presentment spreadsheet.

Used Postman tool for API testing.

Used the excel spread sheet to create test cases.

Used Bug tracking tool Jira to report issues.

Used Slack and Confluence team collaboration.

Used SQL Server for back end testing by writing T-SQL

Environment: ColdFusion, Java, Test Script, JavaScript, AngularJS, Micro Services, Windows 10, SQL Server 2008, MS Office 2013, JIRA, REST API, Manual QA, Postman, JSON

Awards: Outstanding Performance Award for the year of 2016 for the exceptional work on continuous releases.

UTI Worldwide, San Francisco, CA

QA – Web Services

Jan’14 - July’15

UTI Worldwide is an industry-leading, non-asset-based supply chain management company that delivers competitive advantage to clients' supply chains with innovative, integrated solutions configured to specific requirements within any major vertical market; design, manage and service supply chain efficiently and cost-effectively. The project was about the Freight Forwarding System, the Web-based application that allows UTi clerk to create shipments, maintain and track shipments records, create invoices for the shipments created. This application also keeps the record of all the transactions occurred and provide profit and loss information to the concerned party


Tested the UI functionality of the application, Mobile applications and coordinated on the same with Web testers and mobile testers for both positive and negative scenarios.

Validated SOAP, XML responses using different assertions for web services testing using SOAPUI.

Created the Data Driven Framework for the Test Automation and wrote Groovy Scripts for the test cases validation in SOAPUI.

Configured and used JDBC connection property in SOAPUI for test data and for Test Validation.

Configured and used Hermes JMS in SOAPUI in order to monitor and analyze the XML queues and topics for each requests sent from UI and SOAPUI.

Used Encrypted and Decrypted Messages for Web Security Testing in SOAPUI.

Exclusively worked on SOAP/HTTP and XML requests for the Webs Services.

Logged defects and maintained the defect cycle in JIRA and get reviewed them with Test Lead.

Executed different SQL queries using RDBMS MS SQL Server by using joins commands in order to fetch the matching information about the Shipment Records from multiple numbers of tables.

Used SQL Server for data validation, data integration and data duplication.

Participated in Daily Scrum Meeting for daily updates and reported Weekly Status Report.

Environment: SoapUI, SQL, Oracle, Windows, UNIX, JIRA.

McKesson, San Francisco, CA

Mar’12 – Dec’13

QA Analyst

McKesson is a Health Care Information Technology Medical-Surgical Supplies and Pharmaceutical Distributor. McKesson is made up of many businesses, all serving the health care industry. Their businesses fall into one of two primary categories: distribution solutions or technology solutions.


Tested SQL queries to validate Stored procedures using SQL Server 2008

Created Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

Modified existing Stored Procedures as per new business requirements.

Creating Test cases, Test scenarios and queries to improve the performance and to maintain the accuracy of the script according to business needs.

Validation of the stored procedures based on the test cases to check the accuracy of the script.

Involved in Technical Writing and Tech design documentation of the script by making control flow charts using Visio diagrams.

Involved in writing Operational Documentation for customer/user understanding purposes.

Testing internal web applications using Selenium by record/play technique

Reporting bugs and review device issues using JIRA tool

Tested on multiple browsers like Chrome, Firefox and IE

Environment: SQL Server 2008, MS Office 2007, JIRA, Manual QA

Liberty Mutual Insurance Group, Pleasanton, CA

Sep’ 09 – Feb’ 12

Manual QA

Liberty Mutual Insurance Company is one of the leading insurance companies providing auto and home insurance. The scope of the project includes Web based application and tools developed for Underwriting Workstation, policy quote generation for Workers Compensation, Automobile fleet validations and endorsements for Commercial as well as business market lines of Insurance.


Excellent knowledge of using AST, Underwriting workstation, liberator, Docs, SPI net, Risk meter, WCIRB, NCCI, and much more software applications .

Reviewed requirements, specifications and documentation to gain a thorough understanding of the programs and Processes to be certified.

Requirement Analysis from the demand of clients, verify the scenario as per demand of application.

Created the test plan and attributes checking to verify the compatibility.

Created the scenarios for testing and validation according to specifications and presentment spreadsheet.

Used the excel spread sheet to create test cases.

Used Bug tracking tool, HP Quality Center to reopen, fix and respond to intimate.

Used SQL Server for back end testing by writing T-SQL

Environment: SQL Server 2008, MS Office, SSRS, Visual Studio 2008, Windows XP, Manual QA.

Awards: Outstanding Performance Award for all three years - Bronze and Silver awards.


B.S. – Andhra University, INDIA

Training in Web Design using HTML/DHTML/CSS/JavaScript – Las Positas College, CA

Contact this candidate