Test Cases Sql Server

PAVANKUMAR DARJI

*****.*****@*****.*** C: 813-***-****

SUMMARY

Over 11+ years of professional experience in SW Quality Assurance with Manual as well as Automation Testing of Web Based and Client/Server Application

Hands on experience in all phases of SDLC and QALC – Requirement analysis, Gap analysis, Use case decomposition, test planning, estimation and strategy

Experienced with testing & verifying Business functionality for client/server applications in wide Domains like e-Commerce, Healthcare, Finance, Banking, Security Trading System and Insurance System

Experienced working with Software Development Methods like Agile, Waterfall, V-Model and Rational Unified Process (RUP)

Excellent experience writing Test Plan, Test Strategy, Test Cases, Test Scenarios, Test Scripts, Test Matrix and Bug Reports

Experienced performing Web Services API testing for the application using SOAP UI

Worked with CRM systems testing including Salesforce (Cloud), Siebel and Oracle EBS

Experienced performing cross browser testing using Google Chrome, Mozilla Firefox, IE and Safari

Solid exposure performing verification and validation activities, including preparation of test scripts, step-by-step execution of test scripts and consolidation and reporting bugs

Extensive experience on various testing tools like HP QTP, HP ALM (Quality Center), JIRA, Rally, Test Rail, Test Director, and Win Runner

Experienced using configuration Management tools like Jenkins, Bamboo, Hudson etc.

Implemented automation using Selenium Webdriver, Robot Framework, Cucumber BDD, TestNG, JUnit from scratch

Extensive experience with GUI, System Integration (SIT), Functional, Integration, Regression, Unit, Performance, Load, Stress and User Acceptance Testing (UAT)

Experienced writing complex SQL queries and PL/SQL procedures to extract data from various source tables to perform database testing

Excellent understanding of Object Oriented Programming including Java, Python, Ruby, Groovy and Web Technologies

Experienced with different version control tools like Git, GitHub, SVN, Stash, VSS etc.

Experienced with cross browser testing, Log Analysis and Mobile testing using Fiddler

TECHNOLOGY SKILLS

OS

Windows 10/8/7, Windows XP/Vista/98/2000/NT, UNIX/LINUX

Programming

Python, Ruby, Java, Groovy, VB, C#, .NET 3.0, SQL, PL/SQL

Web/Scripting

VB Script, XML, HTML, Shell Script, ASP.NET, JavaScript

Testing Tools

JIRA, Rally, IBM RRC, SOAP UI, Quality Center 12/11/10/9.2, Test Director 8.0, WinRunner 7.6/8.0, Bugzilla 3.0.3, Clear Quest

CI Tools

Jenkins, Hudson, Bamboo

CRM

Salesforce, Oracle EBS, Siebel

Databases

MySQL, Hive, Oracle 12g/11g/10g/9.x/8.x, Sybase, SQL Server 2014-2000

Automation Frameworks

Cucumber BDD/TDD, Robot Framework, Selenium Web Driver, QTP/UFT, Coded UI

Version Management

GitHub, STASH, StarTeam, PVCS, Visual SourceSafe

DB Tools

SQL Workbench, PL-SQL Developer, Toad, MS-Visio, SQL Navigator, Erwin, iSQL

EXPERIENCE

Software Testing Responsibilities:

Performed CRM systems, Web applications as well as Desktop applications testing to validate the business functionalities

Prepared Master Test Plan and Test Strategies/Scenarios and Test Execution for the projects

Experienced working with standard QA methodologies including AGILE, Waterfall, V-Model etc. to deliver the products on time

Actively participated in scrum meetings, IPM and daily standups

Scheduled Demos and Show and Tell with business and Stack Holders to verify the test validation efforts

Migrated legacy test cases to Test Rail and updated as per new enhancements

Performed application Integration Testing across different systems including SOA, Oracle EBS and BI, Salesforce with Siebel and Informatica, Oracle EBS with FileNet and so on

Familiarity with various project requirements and Test cases tracking tools like HP ALM, JIRA, IBM RRC, Rally etc.

Worked with different files including CSV, DAT, Excel, XML files for mocking the test data

Worked closely with Project Manager, Scrum Master, BA/RAs and Developers to understand different Project level Business Requirements

Familiarity with SQL Queries for data validation from and to different databases including Oracle, SQL Server, Hive, Data lake, MySQL etc. using various editors like TOAD, SQL Editor etc.

Performed Web Services API testing for the application using SOAP UI, Postman etc.

Performed White Box/ Black Box/Grey Box testing by looking into the Code to validate the defect

Provided risks, corner cases, Test effort estimation to validate and assisted in determining of acceptance criteria

Report test execution status, open/closed issues, blockages and provide support to team members (from QA point of view)

Co-ordinated and worked with On-shore Off-shore model and guided and escalated the issues with off-shore team

Automation Testing Responsibilities:

Worked with multiple combination of Test automation frameworks including but not limited to Selenium Web Driver with Java, Groovy, Python, Cucumber BDD/TDD with Ruby/Groovy and Capybara/Watir, Robot Framework with Selenium Web Driver and Python and HP QTP/UFT with VB Script, CODED UI

Implemented Robot Automation Framework using Python scripts from scratch

Created automated testing API And Service Testing for Salesforce and Web applications

Developed automation scripts and created Test Suite for CRM Apps like Salesforce, Siebel, Oracle EBS etc.

Scheduled and ran the automation regression suits using Jenkins, Hudson and BAMBOO

Performed Mobile Testing using Fiddler on iOS and Android

Developed automation scripts, Test Suite for various applications using Selenium Web Driver with Java

Recently started working and getting familiar with DevOps concepts using Docker, Splunk

Sriven Systems, OH MAY 2017 - Current

Currently, I am working with an insurance client where I am automating the CRM applications and supporting the different CRM systems including Siebel and Cicero. I am using Cucumber BDD/TDD with Ruby and Watir to automate the CRM applications. Also working with API and Service testing. Here I have an opportunity to start working with DevOps tools like Docker, Splunk and Jenkins.

Environment: Cucumber BDD, Ruby, Watir, HP ALM 12(Quality Center), Oracle 12G, Salesforce, Siebel, Web services, SOAP UI, UNIX, SQL, Windows 7, Jenkins, Docker, GitHub

West Coast Consulting, CA Nov 2012 – Apr 2017

During my tenure here, it was a great experience working with well-known domains like Healthcare, Entertainment, Credit service and Retail. While working with these various domains I have learned some new technologies and worked on various automation frameworks and languages. Also, worked with the entertainment, PBM and Retail domain clients and explored really great open source technologies to get familiar with.

Environment: Selenium Web Driver, HP ALM 11(Quality Center), Oracle EBS(APPS), Java, Web services, SOAP UI, UNIX, SQL Server, SQL, QTP/UFT, Windows 7, MS-Visio, Quick Base, Star Team, UC4, STASH, GIT, Confluence, Sales Force, Jenkins, FileNet, Hive, Python, Groovy

24x7 ESI Inc, NJ Nov 2007 – Oct 2012

During this working duration, I have worked with multiple different clients including Healthcare, Insurance and Financial domains and gained valuable domain specific knowledge. Also, worked with different technologies and environments to enhance my career. Got a chance to work on a Database migration project from Sybase to Oracle.

Environment: Quality Center(ALM), QTP, C#, ASP.NET2.0, ADO.NET, LINUX, XML, XSLT, HTML, SOAP, IIS, T-SQL, MS SQL Server, Quick Test Professional 11/10, Quality Center 10/9.2, PowerBuilder, C#, .Net, UNIX, Oracle 11g, Sybase, Windows, SharePoint, Visual Studio 2010

Programmer Analyst (HMS Systems), Cybernet Solutions May 2003 – Jun 2006

HMS is a Hospital Management system developed for internal use by the Hospital Management which includes all the major functions of Hospital. The system developed for a large hospital based in Africa which includes Reception & Billing, Manpower Management & Payroll, Store Management, Financial Accounting and Clinical Data Management.

Responsibilities:

Developed the screens to manage overall functionalities of hospital.

Involved in creating the required tables and queries.

Tested calculation of patient admission charges, medicines based on the service.

Involved in testing wage calculations if the employee is Waged Labor.

Tested the database for any updates made from the user end.

Executed the Test Cases and updated the Test Cases for new Builds.

Involved in authoring the test plan and test cases.

Involved in performing unit testing, functional testing, and system testing.

Developed and executed test cases to check the functionality of Tax and Patient Benefit modules and wrote Winrunner TSL test scripts to automate execution for all the test scenarios.

Checked the Functional Flow of the system.

Involved in making the required code changes and retested the application after the bugs were detected.

Environment: Test Director, Win Runner, ASP, MS Office, HTML, XML, Windows NT, PowerBuilder, Oracle 9.x

EDUCATION

Master of Business Administration (IB), (20007)

Bachelor of Commerce, (1997)

Contact this candidate