Sql Server Test Cases

Krishna B

Email: *****.****@*****.***

Phone: 905-***-****

EXPERIENCE:

Over 1 year of experience as a Tester with expertise in application, mobile testing.

Over 1 Year of experience in automation testing, created and maintained test scripts based on

the requirement using Selenium Web Driver, TestNG suite.

Experienced in Mobile testing and Responsive, Adaptive Web application testing

Experienced in both Manual and Automation testing

Worked in both Waterfall methodology and Agile methodology

Involved in all phases of Software Development Life Cycle (SDLC) with major emphasis in Software Testing Life Cycle (STLC)

Created regression testing suites using Selenium web driver for test automation using MAVEN,

JENKINS, created and enhanced the test scripts for the application

Expertise in preparing test planning, test design and execution and defect management using

tools like HP ALM, TFS and Jira.

Proficient in different phases of testing like Smoke, Sanity Testing, Functional Testing, GUI

Testing, Regression Testing, SIT, Integration Testing, Performance Testing, User Acceptance

Testing (UAT)

Performed web services testing using SOAP UI tool as part of Integration testing

Expertise in writing SQL Queries for data validation and report testing by writing joins and basic

SQL Commands using tools like TOAD for Oracle, SQL Server Studio, SQL Developer.

Experience using query tools for MS SQL Server to validate reports and

troubleshoot data quality issues

Experience in Mobile testing (Android; I Phone mobile applications)

Coordinated with QA lead to create UAT Test Plans, Test Scenarios and Test cases based on

business, functional requirements.

Excellent analytical, interpersonal, written; verbal communication and project management

skills

Possess good analytical and dynamic troubleshooting skills and have proven ability to work

efficiently in both independent and team oriented environments

EDUCATION:

Bachelor's Degree in Computer Science Engineering, JNTU, Hyderabad, India, 2010

Mohawk College of Applied Science and arts, Hamilton, Ontario, 2015

TECHNICAL SKILLS SUMMARY

Operating Systems: Windows, Mac, Linux.

Test Management Tools: HP Quality Center, ALM, TFS, Jira, Selenium.

Database: Oracle, SQL Server, MySQL

Utility Tools: MS Office, MS Project, MS Outlook, MS SharePoint

Programming Languages: XML, SQL, Java, VB Script

PROFESSIONAL EXPERIENCE:

Publicis Modem, Toronto, ON, Jan2016- Till date. QA Tester.

BMO BOOST:

This is an Interactive Credit Cards Education responsive website for Canada BMO Bank Employees developed using jQuery, Java scripting, AJAX Requests, REST web services, CMS based on .Net, SQL server as Backend Database for the Client-BMO to educate their customers about managing personal finances better. Each time they use the website and read the activities and complete the Modules will save all the user data based on their answers and selections they make during the sessions.

Mobile site is completely Responsive developed for all platforms iOS, Android, Blackberry Devices and Tablets. Selenium used for Automation testing.

LG Data Segmentation: Publicis involved with Vigorate (LG Email Deployment partner) to segment the LG Customer User data based on LG Business rules and create the required data cleansing, transformations and extract the result data for Vigorate to do the emails deployment and Analytics Reporting for LG. Responsive emails are developed by Publicis. Tableau 9.0 is used for developing Reports and Dashboards.

RESPONSIBILITIES:

Participated in daily scrum meetings, developed test cases and test scenarios for the BMO BOOST Web and Mobile Application.

Performed testing on Responsiveness of Web and Mobile Application.

Performed database testing using sql server studio, sql developer

Performed data validation and verification for financial reports and check control reports

Perform Test Execution (INT and System), Regression testing on Agile sprint model of Web

application, End-End Testing using IDB (Integration database) and support on UAT.

Performed database testing as part of report validation and Responsible for document validation

by validating the outgoing XML data with documents

Managed and executed test cases, testing check list on multiple devices as part of cross platform testing on the physical devices like iPhone, Blackberry Curve, Torch, Bold, Samsung Galaxy mobile devices, Tablets and iPads.

Performed System integration testing for Westjet, Paypal, LG Clients with multiple vendors like Infotech, Exact Target, Vigorate.

Performed webservice testing for the policy search and retrieval, Address Search using SOAP UI

Responsible for developing automation framework for the application using Selenium Web driver

using Java.

Performed emails testing on various O.S platforms and different browsers.

Tested different mobile devices to test the emails deployed from Vigotare tool.

Performed database testing for LG Segmentation project.

Coordinated with project sign off documentation.

Participated in team meetings under Scrum master in Agile environment.

Initiate defect triage meetings to monitor and track all system, integration and regression defects.

Created User documents for training various groups such as Super users, Change agents, Trainers and Change Management Consultants.

Generated testing reports and presented to the management as part of scrum meetings.

Provided planning and execution, post implementation verification status reports to the management.

Provided onsite and offsite support along with testing for upgrades and maintenance projects.

Generating QA status report and defect status report daily

Environment: HP ALM, Java, J2EE, Selenium Web driver, TestNG, JUnit, XML, HTML, Soap UI, Oracle, SQL, MS Office, MS SharePoint, Scrum, Agile

Contact this candidate