Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Frankfort, KY, 40601
Posted:
November 29, 2017

Contact this candidate

Resume:

Preeti Shukla

615-***-**** ac3jbr@r.postjobfree.com

Professional Summary

About 7 Years of Extensive experience in IT Industry with emphasis on Quality Assurance & Software Testing.

Strong knowledge of Software Development Life Cycle (SDLC) as well as Software Testing Life Cycle (STLC) and the Role of QA in different testing methodologies like Agile (Scrum) and Waterfall.

Experienced in defining Testing Methodologies, Designing RTM, Test Plans and Test Cases, Verifying and Validating Web based applications.

Skilled in communicating requirements/processes based on standards for Software Development with effective QA implementation in all phases of SDLC.

Excellent work experience in Functional, Integration, GUI, Regression, System, Performance, Acceptance, Security, Stress, Black Box Testing etc.

Proficient in conducting UAT and verifying performance, reliability and fault tolerance issues.

Experience in working with Business and Development teams to coordinate & schedule testing efforts and resolve issues

Proficiency in documenting Business Process Design, authoring Business Requirements Document (BRD), Use case Specifications other related artifacts.

Proficient in analyzing and creating Unified Modeling Language (UML) Diagrams such as use case diagrams, Business flow diagrams and Screen Mockups, using MS Visio.

Experienced in tools as VersionOne, HP Quality Center and JIRA

Experienced in retrieve test data from SQL Server, MYSQL and Oracle database using Toad.

Experienced with Health Care terminologies.

Experienced in Web Services testing through SOAP UI tool.

Involved in post implementation support and training of end users.

Composed, professional and a well-balanced individual with strong understanding of business relationships and business requirements.

Education

Masters of Commerce (M.Com.) from University of Allahabad (Allahabad, INDIA)

Bachelors of Commerce (B.Com.) from University of Allahabad (Allahabad, INDIA)

Bachelor of Education from Kanpur University, India.

SKILLS SUMMARY

Business Management Tools:

MS Visio and MS Excel

Methodologies:

Waterfall, Iterative, Incremental and Agile (Scrum)

Application Packages:

MS Word, MS Excel, MS Power Point, MS Outlook, Adobe Reader

Operating Systems

Windows XP/Vista/7,8,10, Mac OS

Databases

MS Access, SQL Server, Oracle 10g, MYSQL and used TOAD tool to retrieve test data

Testing Tools

VersionOne, Quality Center and JIRA and Share Point

Professional Experience

North America Med Tech Group (USA) Jun’2017 - Present

Role: Quality Assurance Analyst

Project: Manage My Patient (MMP)

Description: Manage My Patient is a Hospital Management System (HMS) that allows the patients, doctors, and hospital administrators to work together more effectively and efficiently at their convenience. In the HMS system, patients can view and schedule appointments, pay outstanding fees, view policies and procedures, check their health reports, see their medical history, and send messages to doctors. Patients can also search for their symptoms and find treatment options. The HMS system will allow doctors to organize the patient records, view and update medical information for each patient, view and add prescriptions, view scheduled appointments, and manage many other options. The Hospital Administrators can use this system for submitting and viewing the insurance claims. Overall, the HMS System brings in more transparency and convenience to patients, doctors, and hospital administrators.

Responsibilities:

The project is developed using Agile (Scrum) methodology.

Software Test Life Cycle (STLC) methodologies to software development as per Agile (Scrum) methodology.

Extensively worked on user story, Test Case and Defect organization using VersionOne.

Used JIRA for tracking defects back to specific requirements and creating ad-hoc reports based on the outcome.

Created and executed Detailed Function test scripts based on the business requirements.

Wrote, Inspected and Executed System Test Cases using VersionOne.

Updated test cases and retested the application after requirement changes using VersionOne.

Performed System testing, Regression testing and Functional testing.

Prepared Testing document for passed test cases as well for failed cases.

Created requirements traceability matrix (RTM) to evaluate requirement impacts on specific change control.

Extensive knowledge of QA methodology, standards and procedures such as creating test

strategy, test plans, test cases, test result documentation for User Acceptance Testing (UAT).

Extensively evaluated and conducted requirements analysis using VersionOne in order to match requirements with specific system functionality and to conduct defect analysis if needed

Worked with the development team to ensure testing issue resolution and performing User Acceptance Testing

Experience in writing SQL queries to extract data from MYSQL database using TOAD.

Experienced in web services testing through SOAP UI.

Have worked in the fast pace environment and can adapt to the new conditions fast.

Environment: Windows, MYSQL, TOAD, MS Word, MS Excel, VersionOne, JIRA.

Wisync Technologies Pvt. Ltd. (Mumbai, INDIA) Mar 2010 – Oct 2016

Role: Quality Assurance Analyst

Project: Edsync Application

Description: Edsync is a unique and comprehensive web-based platform that manages all the functions of educational institutions. The multifunctional platform functions as an integration of large number of inter-connected modules that completely manage critical information for the institute. With the powerful backend and database managed on its dedicated servers. Edsync facilities student information management, student and parent intimations, student performance tracking as well as all information required by the faculty and internal administration. Edsync also enables students, parents, faculty, and internal administration staff to secure access the system independent of place and time. The system runs 24x7 operations with ease and presents updated data to each of the users at their fingerprints. Over the years, Edsync has widened its functionalities by integrating various hardware and device and other business critical software there by presenting a one-stop solutions for all customers.

Responsibilities

Software Test Life Cycle (STLC) methodologies Traditional Waterfall Model and iterative approach to software development as per Agile (Scrum) methodology.

Some part of project is developed using Agile (Scrum) methodology.

Reviewed product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

Participate in analysis and requirements gathering by having meetings with the clients.

Extensively worked on user story, Test Case and Defect organization using HP Quality Center.

Created and executed Detailed Function test scripts based on the business requirements.

Wrote, Inspected and Executed System Test Plan and Test Cases using HP Quality Center.

Creating and validating the Test data.

Ensuring Test environment is ready.

Participate in walk through of Unit Testing results.

Performing the sanity test to verify the builds.

Updated test cases and retested the application after requirement changes using QC.

Performed System testing, Regression testing and Functional testing.

Performed build acceptance testing and smoke testing.

Prepared Testing document for passed test cases as well for failed cases.

Preparing RTM to ensure all the requirements are covered.

Responsible for designing Test plan and Test cases and review peer test cases

Responsible for designing Test plan and Test cases and review peer test cases.

Extensive knowledge of QA methodology, standards and procedures such as creating test

strategy, test plans, test cases, test result documentation for User Acceptance Testing (UAT).

Extensively evaluated and conducted requirements analysis using QC in order to match requirements with specific system functionality and to conduct defect analysis if needed

Worked with the development team to ensure testing issue resolution and performing User Acceptance Testing

Experience in writing SQL queries to extract data from SQL Server database using SQL Client.

Have worked in the fast pace environment and can adapt to the new conditions fast.

Environment: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Visio, Adobe Reader, HP Quality Center, SQL Server Client, Share Point.

Project: EStudent Cafe

Description: It is an online portal for students where they can track own performance in tests & compare with friends. They can also keep track of attendance and future schedules. It also displays fees details. With the powerful backend and database managed on its dedicated servers. It also enables students, parents, faculty, and internal administration staff to secure access the system independent of place and time. The system runs 24x7 operations with ease and presents updated data to each of the users at their fingerprints. Over the years, EStudent Cafe has widened its functionalities by integrating various hardware and device and other business critical software there by presenting a one-stop solutions for all customers.

Responsibilities

Software Test Life Cycle (STLC) methodologies Traditional Waterfall Model and iterative approach to software development.

Reviewed product requirement documents, functional specifications, and involved in developing test strategy, test plan and test case documents.

Participate in analysis and requirements gathering by having meetings with the clients.

Extensively worked on user story, Test Case and Defect organization using HP Quality Center.

Created and executed Detailed Function test scripts based on the business requirements.

Wrote, Inspected and Executed System Test Plan and Test Cases using HP Quality Center.

Creating and validating the Test data.

Ensuring Test environment is ready.

Participate in walk through of Unit Testing results.

Performing the sanity test to verify the builds.

Updated test cases and retested the application after requirement changes using QC.

Performed System testing, Regression testing and Functional testing.

Performed build acceptance testing and smoke testing.

Prepared Testing document for passed test cases as well for failed cases.

Preparing RTM to ensure all the requirements are covered.

Responsible for designing Test plan and Test cases and review peer test cases

Responsible for designing Test plan and Test cases and review peer test cases.

Extensively evaluated and conducted requirements analysis using QC in order to match requirements with specific system functionality and to conduct defect analysis if needed

Worked with the development team to ensure testing issue resolution and performing User Acceptance Testing

Experience in writing SQL queries to extract data from SQL Server database using SQL Client.

Have worked in the fast pace environment and can adapt to the new conditions fast.

Prepared weekly Review and Status Reports, which included Test Case Standings, Metrics, QA Issues and Defects.

Performed Functionality testing of the web application using different browsers.

Conduct System Testing and Regression Testing, identified application errors and interacted with developers to resolve technical issues.

Conducted User Acceptance Testing (UAT) with users and project team members.

Environment: Windows, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, Microsoft Visio, Adobe Reader, Quality Center, SQL Server Client.



Contact this candidate