Test Cases Sql Server
Resume:
Srilakshmi M
Email: ********.**********@*****.*** Cell : 978-***-****
Professional Summary:
* ***** ** ****** ********** with an earned reputation of meeting deadlines and delivering critical solutions in different phases of Quality Process
Over 6 years of rich experience in Scrum Environment
Over 6 years of rich experience in implementing Manual QA Process
Over 2 years of experience in creating Automation Test scripts using QTP
Rich experience in testing the Health Care IT projects developed based on the process guidelines and frameworks of HIMSA and HIPAA
Hands on experience in back end validation techniques (DML, DDL, DCL) using MS SQL Server
Rich experience in testing the REST API and WSDL using SOAP UI
Rich working experience in all the Phases of Software Test Life Cycle and Software Development Life Cycle(Waterfall, Agile Scrum, Agile TDD, Waterfall Agile, JAD)
Extensive experience in implementing Traceability Matrix, generating Test Result Documents and BPT using HP ALM
Good knowledge in performance testing techniques (Load, Stress, Performance and Volume testing) using Load Runner
Education
Bachelor of Technology in Computer Science and Engineering, Jawaharlal Nehru Technological University, India
Technical Skills
Software Testing Manual Testing, Automation Testing, Back End Testing, Web Service & API Testing using SOAP
UI, SAP Interface Testing, Mobile Application Testing, IVR Genesis application testing
Testing Tools QTP, Load Runner, JIRA, HP Quality Center, Rational Clear Quest, Microsoft Test Manager,
Test Complete
QA Methodologies Black Box testing, White Box testing
Databases MS SQL Server
MS Office Excel, Word, PowerPoint, Outlook
Domain Knowledge Health Care, Retailer, Banking, Call Center
Operating Systems Windows, UNIX
Testing Concepts STLC, Testing Levels, Testing Types, Test Planning, Test Scenario Development
Tools & Utilities MS TFS Web Based Tool, EDIFECS Transaction Management, EDIFECS, SpecBuilder, Ultra Edit
Scripting VB Script, Java Script, Data Stage
Specialties
Requirement Analysis ~ Test Governance ~ Test Consultant ~Leading Coordinator~ Documentation & Presentation ~ User Acceptance Testing
Project Profile:
Organization: Strategic Staffing Solutions LLC .,
Client: CMS (Center For Medicare & Medicaid Services(Part C & Part D Appeals, Claims & Grievances)
Role: Sr Onbase QA Testing Analyst Duration: Feb 2016 –June 2016
Environments: OnBase v15, OnBase Client & Onbase Thick Client, Web Based Application
Tools & Technologies: On base, TFS, MTM, .Net, SQL Server 2008, Test Complete
Contribution:
Part of CMS Audit Remediation projects participated in business meetings, analyzed the gaps in the existing business based on the CMS Sanctions and tested the interim applications developed to fill in the gaps identified in the CMS Sanctions.
Provided approvals and sign offs for the Requirements and Test Moves from Unit, Test, UAT & Production in the Change Control Board meetings
Coordinated all the testing activities in different testing phases by closely working with the BSA/Test Coordinators and SMEs to ensure the Working Product with High Quality
Involved in developing and enhancing the test scripts using Test Complete
Analyzed the Potential Project Risks and communicated the Contingency & Mitigation plans in the PPWG Meetings, CCB Meetings, Go-No Go Meetings
Communicated the identified issues are prioritized and all the high and medium priority defects are resolved by the development team in all the different Levels Of Testing by getting daily and weekly bug reports & Defects list with Priority from the Testing Coordinators and Testers
Provided weekly Status on Testing in different Testing Life Cycles and Agile Scrum Projects to the Customer Team, Application Development Manager, Executive Leadership Team Members
Project Profile:
Organization: BCBSSC-CGS Administrators Client: CMS(Center For Medicare & Medicaid Services)
Role: Sr Business Testing Analyst Duration: June 2015 –Feb 2016
Environments: OnBase v15, OnBase Client & Onbase Thick Client, Web Based Application
Tools & Technologies: UFT, Java, HP ALM, HP Sprinter, VMS, Vera Stream, SOAP UI, .Net, SQL Server 2008
Contribution:
Provided approvals and sign offs for the Requirements and Test Moves from Unit, Test, UAT & Production in the Change Control Board meetings
Coordinated all the testing activities in different testing phases by closely working with the BSA/Test Coordinators and SMEs to ensure the Working Product with High Quality
Analyzed the Potential Project Risks and communicated the Contingency & Mitigation plans in the PPWG Meetings, CCB Meetings, Go-No Go Meetings
Involved in developing and enhancing the test scripts using UFT
Involved in developing and enhancing the different frameworks using UFT
Communicated the identified issues are prioritized and all the high and medium priority defects are resolved by the development team in all the different Levels Of Testing by getting daily and weekly bug reports & Defects list with Priority from the Testing Coordinators and Testers
Provided weekly Status on Testing in different Testing Life Cycles and Agile Scrum Projects to the Customer Team, Application Development Manager, Executive Leadership Team Members
Project Name: Entirenet Client: Bridgestone Americas-Nashville TN
Role: Sr QA Analyst Duration: Mar 2015 –June 2015
Environments: Windows 7, Web Based Application
Tools: UFT, Java, HP ALM, RationalClearQuest, Squirrel SQL,SAP, SOAP UI, Loadrunner, HP Sprinter
Contribution:
Involved in automating the application using UFT
Involved in developing and enhancing the test scripts using UFT
Involved in developing and enhancing the different frameworks using UFT
Involved in breaking down the requirements in to Test Scenarios & Test Cases for validating the functionality of the Entirenet Application.
Involved in documenting the detailed Test Approach, Test Planning, Test Case development, Test Case Execution
Provided Weekly Status reports for different projects on the QA Activities to the QA Director and Product Owners
Involved in the Defect Triage meetings
Performed the Admin activities using the Ecommerce App
Involved in implementing the concept of mirroring for the Web Applications using HP ALM Sprinter
Involved in implementing the cross browser testing, security testing for the first Involved in testing the EIV app in ANDROID and MAC OS
Project Name: Cancer Navigation Client: SCRI-Nashville TN
Role: Sr QA Analyst Duration: Feb 2014 –January 2015
Environments: Windows 7, Web Based Application
Tools: Meta Storm, Meditech, Quality Center, SQL Server 2008,.NET,Microstrategy
Contribution:
Worked closely with development teams in investigating and correcting software bugs and deficiencies based on the testing results.
Created new company wide quality assurance strategies and processes.
Involved in task planning, case creation, coverage analysis, automation strategy, and execution during sprint release cycles for newly hired local team & offshore in the Ukraine and India.
Involved in daily stand up meetings, burn down analysis, and report daily sprint status and performance metrics to executive team for multiple products.
Created and maintained bug reporting and test case management system using TFS 2008 and HP Quality Center 10.
Worked directly with IT hosting team to facilitate enhanced quality release processes for our SaaS based customers.
Design and configure general lab and load testing environments utilizing VMware ESX server technologies for shared QA and development use.
Performed hands on testing of multi-tier web based enterprise products founded on .NET, SQL, IIS, Oracle, and Autonomy.
Project Name: ICD 10, Davita Schema Compiler Tool Client: Davita, Brentwood
Role: Sr QA Anyalyst Duration: Aug 2013 – Dec 2013
Tools: Quality Center, SQL Server 2008
Environments: Windows 2000 Server, Client-Server Architecture, SNAPPY & Chair Side SNAPPY
Contribution:
Involved in designing & developing the Test Plans for the Sprints
Involved in testing different features of HLC such as Easy Scan, N2 Curriculums & Equivalents, Report Generations, Report Validations
Involved in designing & developing the excel document templates for implementing Coverage Matrix Using QC
Involved in designing and developing the End To End Test Scenarios
Involved in designing & developing Test Scenarios(General & Complex Scenarios required for Regression Testing & New Code Changes Testing) documents for various Complex features in HLC
Involved in developing the Test cases for the Test Scenario Documents
Involved in ensuring the test plans and test cases developed met the business requirements of the client.
Involved in developing the Automation Scripts for the Test Data used in the Test Cases
Maintained automated test scripts using QTP for Functional, Retesting and regression testing.
Enhanced the test scripts by inserting various checkpoints, synchronization points and parameterized data using QTP
Involved in performing various types of testing, such as Installation, BAT, Functional, Regression, User Acceptance, END-END and GUI on different modules in the released build.
Coordinated with Developers for Defect Tracking and Defect analysis
Tracked, Reviewed, Analyzed and Compared the defects using the Defects tab in Hp Quality Center
Worked on Test Coverage Matrix (Mapping the defects to Test Cases and Test Cases to the Requirements for the Test Cases Tested in different releases during the Sprint Cycle) using different modules available in QC.
Project Name: Interchange Client: HP -TennCare, Nashville
Role: Sr Testing Analyst Duration: Jan 2013 – August 21 2013
Tools: EDIFECS, Oracle, EDIFECS Transaction Management, EDIFECS- SpecBuilder, Quality Center, Ultra Edit, Ultra
Compare,UNIX
Environments: Oracle, SQL, Windows 2000/XP, Microsoft Office Suite, SharePoint, Microsoft Project Server (MSPS), Microsoft
Access, CMOD, HP Quality Center 10.0, Citrix, MS Visio, Business Objects, EdifecsSpecbuilder, Edifecs
Transaction Management, TN Anytime, Agile,QTP
Contribution:
Involved in designing & developing the Test Plans for the Sprints
Involved in designing & developing the excel document templates for implementing Coverage Matrix Using QC
Involved in designing and developing the End To End Test Scenarios
Involved in designing & developing Test Scenarios(General & Complex Scenarios required for Regression Testing & New Code Changes Testing) documents for various Complex features in Interchange
Involved in developing the Test cases for the Test Scenario Documents
Involved in ensuring the test plans and test cases developed met the business requirements of the client.
Involved in developing the Automation Scripts for the Test Data used in the Test Cases
Maintained automated test scripts using QTP for Functional, Retesting and regression testing.
Enhanced the test scripts by inserting various checkpoints, synchronization points and parameterized data using QTP
Involved in performing various types of testing, such as Installation, BAT, Functional, Regression, User Acceptance, END-END and GUI on different modules in the released build.
Coordinated with Developers for Defect Tracking and Defect analysis
Tracked, Reviewed, Analyzed and Compared the defects using the Defects tab in Hp Quality Center
Worked on Test Coverage Matrix (Mapping the defects to Test Cases and Test Cases to the Requirements for the Test Cases Tested in different releases during the Sprint Cycle) using different modules available in QC.
Project Name: HCC EA Client: GSK
Role: Sr QA Analyst Duration: Sep 2010 – Feb 2012
Environment: .Net Workflows, ASP.Net, SQL Server 2008, QTP, Quality Center, Buddy Test, Mud Pit, DR-Site, Live Site
Contribution:
Involved in designing & developing the Tasks for the Sprints
Involved in giving the time estimates to each QA Tasks in every PBI Item
Involved in breaking down the Requirements for various PBI Items to HLBTS & Test Cases required to perform various types of testing
Ensured that the HLBTS and Test Cases developed met the Acceptance Criteria specified for the Business Requirements.
Worked closely with development teams in investigating the root cause of the defect for the various defects logged by both onsite and offshore team
Involved in developing and enhancing the test scripts using QBT%
Involved in developing and enhancing the different frameworks using UFT
Involved in providing the Steps for Reproducibility, Screen Shots and updating the R&D Comments for the defect once the Investigation and Root cause analysis is done.
Involved in performing various types of testing, such as Sanity Testing, BAT/BVT, Functional, Regression, Retesting, END-END Scenarios Testing, Look and Feel/Cosmetic Testing, GUI Testing on the builds deployed to various environments .
Coordinated with Developers for Defect Triage and Defect Analysis and provided the details required by the development team
Tracked, Reviewed, Analyzed and Compared the defects using the Defects tab in Hp Quality Center
Involved in Root Cause analysis if a defect is identified in two different scenarios.
Developed and executed the Adhoc Regression Scenarios and Exploratory Testing Scenarios for several Requirements
Provided the Test Results for different cycles using the Release Module available in QC
Project Name: HLC Client: GSK
Role: Sr QA Analyst Duration: May 2010 – July 2011
Environment: .Net Workflows, ASP.Net, SQL Server 2008, QTP, Quality Center, Buddy Test, Sandbox, DR-Site, Live
Site(Production)
Contribution:
Involved in designing & developing the Test Plans for the Sprints
Involved in testing different features of HLC such as Easy Scan, N2 Curriculums & Equivalents, Report Generations, Report Validations
Involved in designing & developing the excel document templates for implementing Coverage Matrix Using QC
Involved in designing and developing the End To End Test Scenarios
Involved in designing & developing Test Scenarios(General & Complex Scenarios required for Regression Testing & New Code Changes Testing) documents for various Complex features in HLC
Involved in developing the Test cases for the Test Scenario Documents
Involved in ensuring the test plans and test cases developed met the business requirements of the client.
Involved in developing the Automation Scripts for the Test Data used in the Test Cases
Maintained automated test scripts using QTP for Functional, Retesting and regression testing.
Enhanced the test scripts by inserting various checkpoints, synchronization points and parameterized data using QTP
Involved in performing various types of testing, such as Installation, BAT, Functional, Regression, User Acceptance, END-END and GUI on different modules in the released build.
Coordinated with Developers for Defect Tracking and Defect analysis
Tracked, Reviewed, Analyzed and Compared the defects using the Defects tab in Hp Quality Center
Worked on Test Coverage Matrix (Mapping the defects to Test Cases and Test Cases to the Requirements for the Test Cases Tested in different releases during the Sprint Cycle) using different modules available in QC.
Project Name: Aventa Client: GN Resound, Chicago, IL
Role: QA Consultant Duration: Apr 2007 – Nov 2009
Environment: C#.Net, SQL Server 2000, Selenium, Quality Center
Contribution:
Analyzed the Business, Functional Requirements and stream lined the Testing Activities
Involved in developing the Test Plans and Detailed Test cases based on the Use case, Business Requirements and functional specifications documents.
Involved in all the phases of STLC for the assigned components.
Involved in Creating and executing the Virtual User Scripts and Test scenarios using the Load runner
Involved in performing stress, load performance testing using Load Runner
Performed Functional, System, GUI, End to End, System, Installation, Compatibility, Sanity, Retesting and Security testing
Customized the scripts according to the requirements by inserting check points, parameterized the script, conditional statements and loops using QTP.
Analyzed the results, tracked the defects and generated reports using HP Quality Center
Performed Regression test to ensure product integrity after modifications and enhancements.
Executed the queries in the test databases using SQL Queries
Worked with Technical staff to validate test requirements, resolve design issues and software defects
Involved in creating the UAT Test Plan and subset of the Functional Test cases for UAT Test
Project Name: CalCas Client: California Casualty, Denver, CO
Role: Sr QA Analyst Duration: Apr 2006 – Mar 2007
Environment: IBM VC++, VB.NET, QTP,MS Excel, SQL SERVER XML, Load Runner, QTP, Quality Center
Contribution:
Analyzed the Business, Functional Requirements and stream lined the Testing Activities
Involved in developing the Test Plans and Detailed Test cases based on the Use case, Business Requirements and functional specifications documents.
Involved in all the phases of STLC for the assigned components.
Involved in Creating and executing the Virtual User Scripts and Test scenarios using the Load runner
Involved in performing stress, load performance testing using Load Runner
Performed Functional, System, GUI, End to End, System, Installation, Compatibility, Sanity, Retesting and Security testing
Customized the scripts according to the requirements by inserting check points, parameterized the script, conditional statements and loops using QTP.
Analyzed the results, tracked the defects and generated reports using HP Quality Center
Performed Regression test to ensure product integrity after modifications and enhancements.
Executed the queries in the test databases using SQL Queries
Worked with Technical staff to validate test requirements, resolve design issues and software defects
Involved in creating the UAT Test Plan and subset of the Functional Test cases for UAT Test
Project Name: New Buying System Client: TESCO, UK
Role: Test Engineer Duration: May 2003 - Nov 2005
Environment: Abinitio, Unix, SQL Server 2005, QTP, MS Excel, Business Object
Contribution:
Involved in testing the graphs developed using the GDE in Abinitio.
Involved in validating the back end data using SQL queries
Involved in all phases of STLC for assigned components
Worked closely with development teams in investigating and correcting software bugs and deficiencies based on the testing results.
Generated test Cases by covering all the requirements based on the FRS and Use case document for different functional features of the different modules in the application
Involved in performing various types of testing, such as Installation, BAT, Functional, Regression, User Acceptance, End- End Scenario and GUI testing for the different functional features in different modules of the application
Performed Functionality, key word driven and Data Driven Testing for different test scenarios covering all aspects of project functionality using QTP
Enhanced the scripts by inserting various checkpoints, synchronization points and parameterized data using QTP.
Involved in load and stress testing using Load runner
Tracked, analyzed and documented defects using Hp Quality Center
Contact this candidate