Sql Server Test Cases

CAREER PROFILE

Over *+ years of experience as Quality Assurance Engineer in Client server and Web-based application.

Solid Knowledge of Software Development Life Cycle (SDLC) like Waterfall, Agile/Scrum, and V-Model.

Extensive knowledge of Software Testing Life Cycle (STLC) and Defect Life Cycle.

Excellent skills in front end manual testing by managing, executing tests and reporting defects using Quality Center and Jira.

Knowledge of Automated testing by executing scripts for regression testing using automation test tool Quick Test Professional and Selenium IDE.

Experience in testing applications developed in .NET, C#, PHP.

Proficient in writing and maintaining Test Plan, Test Cases, Requirement Coverage Matrices and Traceability Matrix.

Experience in conducting walkthrough and reviews to examine and discuss the validity of the proposed solutions and gather feedback.

Expert in creating test cases using Black box test design techniques like boundary value analysis, equivalence partitioning, and decision table.

Proficiency in performing Back end testing for data integrity by executing complex SQL queries for validating the data.

Team Player with excellent communication skills.

EDUCATION & CERTIFICATION

MS in Computer Application

Scrum Team Member Accredited Certification Certificate Id 025***********

TECHNICAL SKILLS

Testing Tools : QuickTestPro10/11, Selenium IDE 2.5

Defect Tracking Tool : Quality Center 10/11, Jira Agile 6, Workfront

Operating Systems : Windows 2000/2003/XP/Vista, Windows 7, Windows 8

Databases : MS SQL 6.5/7.0/2000/2008, Microsoft Access 97, Oracle10g

Languages : Visual Basic 4/5, XML, VBScript, HTML 5, CSS

EXPERIENCE

Client : Inland Empire Health Plan, Rancho Cucamonga, CA

Role : Quality Assurance Engineer

Duration : January 2015 – August 2016

Project : Provider Portal 2.0

Provider Portal is a web based application for the providers to review the IEHP Members’ Health Records, for eligible Providers submit preventive care data through our Pay for Performance (P4P) program, review your claims status and remittance, and obtain authorizations. Provider Portal 2.0 replaces the existing IEHP website used by the IEHP Provider network with improved professional look and feel, new web technologies, and will expand on the features and functionality of current web application.

Responsibilities:

Created Test data and performed validation for various functionality within the web application.

Reported any defects discovered during test execution and worked closely with project team to ensure defects are resolved on a timely manner to manage the defect lifecycle.

Performed Security testing to ensure the accessibility system protects data and maintains functionality as intended.

Environment: IIS 7.0, Windows 2008, SQL Server 2008, MS SQL Server Management Studio 2008, .NET, C#, Angular JS, Workfront

Project : Electronic Face Sheet

Electronic Face sheet project is designed to replace the manual process of faxed face sheet for inpatient admissions authorization request, with automated interface from hospital EMR systems. These files will be loaded into MedHOK for Authorization Request.

Responsibilities:

Created Test data files to ensure structural and data validation check is performed as per the validation rules.

Verified the Validated files to check if data is accepted for all fields or all errors are found.

Recorded problems, issues and defects in the defect tracking system and worked with the team to identify the root cause of the issues, and implement measures to continually improve quality.

Validated the Medhok application to ensure the data mapping of Authorization request.

Environment: SQL Server 2008, MS SQL Server Management Studio 2008, Workfront

Project : Web Forms

Behavioral Health Autism Forms

The Autism Behavioral Health Treatment Application has been requested with the goal of monitoring the services and treatments administered to autistic patients, who are IEHP members, from providers. This form is utilized as a means of tracking the autistic patient’s progress and growth over time. The Autism BH Treatment Application gives access to three types of forms that are to be filled out and submitted. These forms are known as the Initial Functional Behavioral Assessment Form, ABA Progress Report Form, and 6 Month ABA Request for Additional Services Form.

eAuthorization Request Form

eAuthorization Request Form allows PCPs, Specialists and Vision providers to submit referral authorization requests to IEHP for processing. These referrals are submitted to the MedHOK application for Authorization Review.

Prescription Drug Prior Authorization Request Form

Prescription Drug Prior Authorization Request Form allows providers to submit Drug request to IEHP for processing. These drug request are submitted to MedHOK application for review and processing.

Responsibilities:

Participated in requirement gathering & impact analysis with business users for each Forms.

Documented functional Requirements traceability matrix, and test cases for each Forms.

Designed and developed validation protocols to ensure the Forms performs as intended and according to design.

Created Test data and executed test cases to identify the defects for functional and regression tests.

Executed SQL queries to ensure that accurate is data loading into the Forms.

Validated each Forms to ensure the data in the Forms are stored properly in the SQL database and in MedHok application after submission.

Recorded problems, issues and defects in the defect tracking system and worked with the team to identify the root cause of the issues, and implement measures to continually improve quality of the application

Performed cross-platform and cross-browser testing using Virtual Machine

Performed Web service Testing to verify the inbound and the outbound data.

Environment: IIS 7.0, Windows 2008, SQL Server 2008, MS SQL Server Management Studio 2008, .NET, C#, Angular JS, Workfront

Project : MedHOK (Medical House of Knowledge)

MedHOK, is a cloud based medical management system demonstrating how medical, pharmacy, quality and compliance teams can work from a single platform to compliantly and completely manage member needs to provides healthcare solutions for care, quality and compliance. The module include Utilization Management, Case Management, Pharmacy and Grievances.

Responsibilities:

Participated in requirement gathering & impact analysis with business users for various enchancements.

Created manual test scenario, test cases and test data based on requirements to ensure all scenarios are covered.

Recorded problems, issues and defects in the defect tracking system.

Developed and executed SQL queries to verify the proper insertion, deletion and updates into the database supporting tables.

Environment: IIS 7.0, Windows 2008, SQL Server 2008, MS SQL Server Management Studio 2008, .NET, C#, Angular JS, Workfront

Client : CPI Solutions, Camarillo, CA

Role : Quality Assurance Test Engineer

Duration : September 2012 – December 2014

Project : ATSP Management System

ATSP Management system is modern aesthetic, easy to use web based system for Admin, Teacher, Student and Parents. This has iconic user interface for easy access which will seamlessly interact among all modules. Admin module helps to reduce bottlenecks in front office with easy registration process to efficiently manage student data. The student module often stands as the keystone to efficiently manage students themselves with accurate data. This system has appropriate role based security levels. Teacher module facilitates the student’s daily activities like class schedules, attendance, events and activities. The parents module gives web-based access to their student's academic records, their progress and payment option.

Responsibilities:

Participated in Sprint Planning meeting to analyze User stories and for Sprint estimation along with Product Owner, Scrum Master and Team Members.

Attended and provided feedback in Daily Sprint meeting to discuss work progress, open issues to be resolved and to update daily tasks.

Created effective Manual Test Scripts using different testing techniques to cover various testing scenarios to ensure accurate and productive test execution.

Created Test data and executed test cases to identify the defects for functional and regression tests.

Recorded problems, issues and defects in the defect tracking system Jira Agile and worked with the team to resolve any issues and defects on-schedule.

Developed and executed SQL queries to verify the proper insertion, deletion and updates into the database supporting tables.

Involved in review meetings to review various deliverables such as test case, and test report to ensure that all aspects of the system have proper testing coverage and overall system reliability, performance and quality.

Helped other Team Members to meet their objective and resolve issues.

Environment: IIS 6.0, Windows 2003, SQL Server 2005, MS SQL Server Management Studio 2005, .NET, C#, Jira Agile

Client : Dream Warrior Group, Winnetka, CA

Role : QA Test Engineer

Duration : February 2011 - July 2012

Project : Medicine Ordering System

Medicine ordering system is an application to enable users for setting up the Order workflow, generating allocations for medicine, place/ change/ cancel/return order for the medicines. My Account section of the MOS allows users to view profile information and to look up current or past orders. It automatically sends an order confirmation to the configured email address for the user when the order is created. This is equipped with a suite of standard reports that are available to view on-screen and can also be printed. Various custom reports can provide information on orders, products and billing details.

Responsibilities:

Participated in various Requirements/ Design analysis meetings with BA, developers and helped eliminate ambiguities.

Provided recommendation and feedback to the lead as to the acceptance or rejection of any new or changed system components.

Implemented Test plan for application enhancements and maintenance releases using the industry best practices.

Analyzed business requirements and created Test scenarios and Test cases that are well-structured, easy to maintain, and easily understood by team members.

Created Requirement Coverage matrix and Requirement Traceability Matrix which helped to create a snap shot to identify coverage gaps and issues.

Created test scripts for use on automated testing tools using Selenium IDE.

Developed and executed test cases and prepared test log that provide summary of the results performed on daily basis.

Reported and validated any defects discovered during test execution and worked closely with project team to ensure defects are resolved on a timely manner to manage the defect lifecycle.

Performed cross-platform and cross-browser testing to check both the client side and server side behavior of application.

Created and executed SQL queries to ensure data is populated into the correct tables and data integrity is maintained.

Organized and scheduled regular work while accommodating emergency situations that may arise in-between.

Environment: Apache 2.2, PHP 5.4, Oracle 10g, Oracle SQL Developer 4.0, Selenium IDE, Quality Centre 11.0

Client : New Century Mortgage, Irvine, CA

Role : QA Test Engineer

Duration : December 2008- January 2011

Project : Century Loan Origination System

The CLOS was developed as part of a business reengineering process to simplify the loan application and tracking process, guarantee security and privacy, and to reduce approval and close time for loans. The function for this application was to minimize the manual input and maximize the automated steps. The functions include automated credit checks, perform all calculations, communicate electronically with the third party, pull underwriting and merge information and generate required documents.

Responsibilities:

Evaluated and analyzed the requirement document and developed system test scenarios and test cases to validate each software component under test.

Evaluated and provided feedback for various deliverables Test Plans, Test cases and Test Report.

Created and executed functional test cases to detect defect using various testing techniques like error guessing, decision table, boundary value analysis, equivalence partition, positive and negative testing.

Recorded all defects in the defect tracking tool Quality Center as soon as it was identified.

Reported and validated any defects discovered during test execution and worked with teams to diagnose and resolve test issues.

Created and executed automated test script for Regression Testing and Functional Testing using QTP.

Created and executed scripts for regression and functional Testing using QTP.

Performed Data Driven Tests with positive, negative and dynamic data sets using external files and Data Tables in QTP.

Generated QTP scripts using Regular Expression to identify the object which changes the object value dynamically.

Created various checkpoints in QTP to validate if the current and expected values of an object match during runtime.

Created Test Data and executed SQL queries to verify the integrity of data in database.

Prepared release/rollout support materials in Excel spread sheet and communicated with teams on the usage of testing processes and tools for release and rollout.

Environment: Windows 2003, .NET, C#, IIS 6.0, SQL Server 2005, MS SQL Server Management Studio 2005, QTP 10.0, Quality Centre 10.0

Client : Co-operative Bank, India

Role : Software developer/Tester

Duration : December 1999 - August 2000

Project : Bank Automation Software

The Bank Automation software keeps the day by day record as a complete banking system. It can keep the information of bank employee, transactions, loan solution, and account information. It also displays the customer details, payment details, loan details and transaction details. The system generates various reports regarding employee, customer, loan, transaction, and payment.

Responsibilities:

Analyzed system requirements and participated in developing/coding the system.

Involved in Design, develop, test user interface using Visual Basic.

Performed Unit testing, Functional testing, Integration testing and System testing.

Created and executed Test scenarios and queries using SQL.

Attended meetings with other team members to evaluate the progress and performance of the application.

Environment: Windows 98, Visual Basic 5, Crystal Report, Microsoft SQL Server 7.0

Client : Brahma Softek, India

Role : Software developer/Tester

Duration : January 1999 - November 1999

Project : Automobile Maintenance System

Automobile Maintenance System is windows based desktop application for the maintenance of the automobile. This system consists of managing the automobile details, customer details, inventory and stock up details of part, complaints and reports. The customer can make any complaints regarding the products or the maintenance work and it can also be stored in the database. The company will provide the necessary actions to the complaints. And finally all the reports regarding to the maintenance, customer and stock can also be obtained.

Responsibilities:

Designed forms, performed coding, testing and report generation using Visual Basic and Crystal report.

Worked with customers and internal teams to diagnose and resolve test issues.

Created and executed Test scenarios and queries using Access.

Performed Unit testing, Functional testing and Adhoc testing.

Environment: Windows 98, Visual Basic 4, Crystal report, Microsoft Access 97

References Available Upon Request

Contact this candidate