Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
San Jose, CA
Posted:
September 26, 2017

Contact this candidate

Resume:

Durga

Santa Clara, CA ***** 510-***-**** ac2g69@r.postjobfree.com

SUMMARY

6+ years of diversified experience in IT environment with expertise in Software Quality Assurance and Software Testing of various Web-based and Client/Server application systems using Automation testing techniques.

Experience with QA Methodology and QA validations to ensure the Quality Assurance.

Experience generating, enhancing and executing automated testing scripts using Selenium Web driver with TestNG and excellent knowledge on Jasmine, Protractor and Appium

Extensive experience in Functional Testing, System Testing, Integration Testing, Regression Testing, and User Acceptance Testing.

Experience in testing Extract Transfer and Load Process [ETL] using Data Stage.

Expertise in ETL/DWH testing concepts, Informatica power center 8.6.2, TOAD and experience in ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from different sources.

Proficient in writing SQL queries and worked with PL/SQL for back-end testing.

Expertise in creating Test Plan, Test Scenarios, Test Cases, Review, Execution, Defect management and Tracking.

Extensive work experience in Black Box testing, White box testing, Automation, API Testing.

Extensive experience in developing automation scripts using Java and Python.

Excellent knowledge in Web services, SOAP and RESTful.

Experience with Test Management tools such as HP Quality Center/ ALM, JIRA and TFS.

Experienced in using Version Control System Git.

Experience in Waterfall, Scrum and Agile Methodologies. Had successfully executed projects for United Health Group.

Self-starter with strong work ethics and skills in time management, client relationship and ability to adapt and learn new things quickly.

SKILL SET

Testing tools/Frameworks

Selenium Web driver, TestNG, SoapUI, Appium, Jasmine, Protractor

Management Tools

HP Quality Center / ALM, JIRA, TFS

Programming Languages

Java, C++, C, SQL, PL/SQL

Scripting

Python, Shell

Operating Systems

Windows, UNIX

RDBMS

Oracle 11g/10g, SQL Server, Cassandra(NoSQL)

Web App Servers

Apache Tomcat, Web Logic Server

Web Services

SOAP, RESTful

Web Browsers

Internet Explorer, Mozilla Firefox, Chrome.

Source Code Management

GIT

Tools

Eclipse, Netbeans

Continuous Integration

Jenkins

Big Data Technologies

HDFS, Map Reduce, Pig, Hive, Sqoop, Flume, Zookeeper, YARN, Spark

PROFESSIONAL EXPERIENCE

United Health Group – USA SEP 2016 – Till date

QA Engineer

United Healthcare International (UHCI) desires to have a secure Self-Service portal for its Global Solutions business that can be accessed by both providers and members. This would allow the Providers has easy access to clear and concise information about their patient’s coverage and verify treatments that are covered at point of service. The Providers and Members will also have the ability to visually see the process and status of each health care claim. System involves functionalities like Landing screen (MP), Request Guarantee of Payment (MP), Review Guarantee of Payment (MP), Search Member (P), View Benefits (MP), Search Provider (M), View and Edit Profile (P), View Profile (M), Submit Claims (MP), 013-View Claim Status (MP).

Responsibilities:

Performed manual and automated tests using Selenium WebDriver for the enhancements in Self Service Portal application.

Responsible for Test Strategy, Test Plan, Test Scenario, Test Case documents, Defect Report, Test summary reports.

Enhancing the Test cases using Java programming features and TestNG annotations.

Develop Data driven framework using TestNG and Selenium Web driver.

Develop, manage and maintain automation framework that can retain reusable automation test cases and test data.

Enhancement to the existing test scripts and adding new test scripts for the changes in the application using Selenium.

Writing advanced SQL queries for database testing with respect to SQL Server.

Performed browser (IE, Firefox, and Chrome) and platform (Windows 7) compatibility testing.

Responsible to verify Web services API request, response data validations in REST protocol, API Testing.

Integrate Automation Scripts Selenium WebDriver API on continuous integration tools Jenkins for nightly batch run of the Scripts.

Responsible for updating Regression tests and Issue documentation.

Perform Test Execution and log the defects in JIRA.

Involved in Task effort estimation for testing activities of team, and track in Team Foundation Server

Preparing Weekly and Daily status reports and sending to Client.

Responsible for maintaining Requirement Traceability Matrix to show the test coverage in terms of requirement vs. Test scripts.

Organize the daily status meeting with the team to discuss the project status.

Worked in Agile Development and SCRUM process throughout the project.

Environment: Selenium WebDriver, Test NG, SoapUI, Java, Jenkins, JIRA, SQL Server, SQL, Git, Windows 7, Eclipse.

Cognizant Technology Solutions – Hyderabad, India

Client: United Health Group – USA MAR 2014 – May 2015

QA Engineer

United Healthcare International (UHCI) desires to have a secure Self-Service portal for its Global Solutions business that can be accessed by both providers and members. This would allow the Providers has easy access to clear and concise information about their patient’s coverage and verify treatments that are covered at point of service. The Providers and Members will also have the ability to visually see the process and status of each health care claim. System involves functionalities like Landing screen (MP), Request Guarantee of

Payment (MP), Review Guarantee of Payment (MP), Search Member (P), View Benefits (MP), Search Provider (M), View and Edit Profile (P), View Profile (M), Submit Claims (MP), 013-View Claim Status (MP).

Responsibilities:

Performed both manual and automated tests (using Selenium WebDriver) to conduct functional and regression tests on the application.

Generated test scripts in Java to test the web elements using Eclipse IDE and enhanced the scripts when the requirement changes.

Develop and Manage system integration and functional testing strategies and subsequent supporting tests plans and cases.

Develop, manage and maintain automation framework that can retain reusable automation test cases and test data.

Develop and maintain reusable automated tests.

Implement automated testing of web applications across multiple web browsers and platforms.

Performed browser (IE, Firefox, and Chrome) and platform (Windows 7) compatibility testing.

Responsible for quality related metrics like unit test coverage and testing progress.

Worked in Agile Development and SCRUM process throughout the project.

Enhancing the Test cases using java programming features and TestNG annotations.

Integrate Automation Scripts Selenium WebDriver API on continuous integration tools Jenkins for nightly batch run of the Scripts.

Responsible to verify Web services API request, response data validations in REST protocol, API Testing.

Develop test framework using TestNG and Selenium Web driver.

Responsible for executing test scripts and logging the defects in JIRA.

Involved in Task effort estimation for testing activities of team, and track in Team Foundation Server

Task Assignment for team members.

Providing the training and support to stakeholders and end clients after each deployment.

Responsible for updating regression tests and issue documentation.

Reviewing the Test documents with Business Analysts.

Organize the daily status meeting with the team to discuss the project status.

Environment: Java, Selenium WebDriver, Test NG, SoapUI, Eclipse, JIRA, Junit, SQL Server, SQL, Git, Windows 7.

Cognizant Technology Solutions – Hyderabad, India

Client: United Health Group – USA Dec 2010 – Feb 2014

QA Engineer

This project is to provide Medical Loss Ratio Engine (aka MLRE) tool to achieve the required MLR Medical Loss Ratio enterprise capabilities at the organizational level. MLRE will achieve in calculating and apportioning the total rebate due among the Rebate Recipients corresponds to an Aggregation Group. It also facilitates the payment process, data retention, audit and regulatory reporting. This project also includes activities associated with the development of a rebate tool to issue payment to the customer in the form of a check or premium credit to be applied to future premiums. The Medical Loss Ratio is based upon calendar year results

plus, three months of run-out and the first calendar year for which a rebate applies is 2011.This project involves many external systems like Financial Data Warehouse (FDW), Policy Admin, Eligibility Systems River Valley, UNET, COSMOS, Sierra, PHS, OXFORD, AARP, STUDENT RESOURCE, UHOne, OHPS and Payment Engines like PE for Check Printing, TRS and Duncan for Check Status and Notifications. MLRE also interacts with Broker

Systems called UeS for Marketing purpose. System also has User Interface where Business can approve/Reject checks so that Checks can be Voided/Redistributed.

Responsibilities:

Prepared Test Plan/Strategy document, Test Scenarios, Test cases, Test data conditions.

Created mock data files as input to ETL jobs and running the jobs/Workflows for ETL process.

Performed data validation in staging tables and core tables after each ETL data load.

Identified defects and errors in data prior to data processing.

Performed schema testing for the data files from different sources.

Verifying the data in target database by ETL process and verifying column mapping between source and target.

Wrote UNIX Shell Scripts to interact with Informatica Server from command mode.

Developed test scripts to automate process of testing in Selenium WebDriver with TestNG to automate user interface of the system.

Created automated Test scripts using automated tools and ran the test scripts on various Builds and instances.

Debugging the test scripts before start of Test execution in each cycle.

Recorded and re-run smoke test suite in various modules using selenium IDE during every patch release.

Executed Automated selenium scripts and reproduced failures manually.

Performed Usability, GUI, Functional and Regression testing of the new builds.

Performed database testing by using complex SQL Queries to retrieve data.

Involved in Test Execution as a primary resource and POC for all modules.

Defect Tracking and closing the defect as they resolved at the time of retest.

Reporting the Bugs using Quality Center/ALM.

Worked with Git for maintaining the source version control.

Responsible for maintaining Requirement Traceability Matrix to show the test coverage requirement vs. Test scripts.

Walkthroughs and peer review participation with team members and Business Analyst team.

Involved in Project plan creation with the client manager and provided estimations like no of cycles required and time for the segments managed.

Coordinating with developers, Release management team and QA team during build deployments to various test environments and to the production.

Involved in preparing Test Summary Report at the end of each quarter.

Environment: Java, Selenium WebDriver, Test NG, Eclipse, HP Quality Center/ALM, ETL, Oracle 10g, SQL, Shell script, Git, Windows 7.

Polycom Technology Centre Private Limited, Hyderabad, India Feb 2010 – Nov 2010

QA Trainee

The 'Pharmacy Management System' aims at providing computerized system for maintaining the transactions of medical distributors. The aim of 'Pharmacy Management system' is to provide user-friendly interface, which can be easily dealt by people who does not have much knowledge in computers. The interface is providing with relevant controls and names right from login screen till to the report generation screen. Four modules present in this project are Purchasing order, Drug Sales, Maintaining stock and Generation of Reports.

Responsibilities:

Understanding the business requirements and Contribution to Test Plan documentation.

Deriving Test Scenarios, Documenting Test Cases and Collecting Test Data for Functional Testing.

Responsible for execution of Test Cases and logging the defects in HP Quality Center.

Involved in different types of Testing - Black box testing, functional testing, GUI testing, System Testing, Integration Testing, Regression Testing, Sanity Testing, Smoke Testing and Database testing.

Tracking Defects and Selecting Test Cases for Regression Testing and Sanity testing on modified Software Builds.

Environment: HP Quality Center, Git, SQL Server, SQL, Windows 7.



Contact this candidate