Sign in

Test Cases Sql Server

Oakville, ON, Canada
March 12, 2018

Contact this candidate


Baljeet Saini 647-***-****

OBJECTIVE: A challenging, rewarding Quality Assurance Analyst position in a reputable company where my skills and experience will allow making a tangible contribution to the growth and on-going success of the company.


•Over 7 years experience in the field of Software Quality Assurance and Testing in a wide variety of domains like Financial, Banking, Technology, CRM, Insurance and Broadcast Industry

•Involved in all phases of Software Development Life Cycle (SDLC) like Requirements, Analysis/Design, Development and Testing.

•Proficient in developing Test Plan, Test Script, Test Scenarios, Test Cases, Test Design, Test Coverage Matrix’s for Manual and Automated Testing along with ability to conduct non-functional testing including operability, failover and negative testing.

•Experience in performing testing on Front-end and Back-End Applications

•Developed and executed test cases for various types of testing like Functional, Smoke, Data-driven, End to End, System Integrated Testing (SIT), User Acceptance (UAT), Regression and Security Testing.

•Experience using HP tools such as Unified Functional Testing (QTP), HP ALM (Quality Center) and Test Director

•Good Knowledge of RDBMS (Relational Database Management System)

•Strong analytical, problem solving, excellent inter-personal communication skills and flexible to learn new technologies in the IT industry towards company's success.


Operating Systems: Windows 7/Vista/XP/2000 and Mac OS

Testing Tools: UFT (Quick Test Pro), HP ALM, Jira, Bugzilla, SOAP UI, Test Manager, Accessibility

Browsers: Internet Explorer (IE), Firefox, Safari, Chrome

Web Servers: IIS, Apache

Programming Languages: C, C++, C#, SQL, .Net, Visual Basic 6, JavaScript, VBScript

Web Scripting Languages Databases: Oracle, SQL Server, MS Access, MySQL

Mobile Devices: Android, iOS, Tablets and iPads.


CIBC, Toronto July 2016- Present

QA Analyst

CIBC is a leading Canadian-based global financial institution. Through our three major businesses – Retail and Business Banking, Wealth Management and Capital Markets Banking. CIBC has a long history of technology first and has been recognized for excellence in online and mobile banking functionality and innovation in payments by leading industry organizations. As a QA tester, I have acted in a team lead capacity creating test plans, strategies and providing estimates and have assigned and overseeing the execution of the test cases reporting on any defects.


•Analyze, define, and translate business and functional specifications into testing requirements

•Manage and coordinate end to end testing activities for medium to large projects including the test strategy, test plan

•Oversee the test case creation and execution ensuring they meet the business requirements

•Execute tests when required and ensure results achieve documented goals and objectives

•Report and manage software concerns and test activities throughout the software development lifecycle using HPALM

•Ensure client needs are being met with highest quality

•Coordinate testing activities with onshore and offshore teams ensure testing activities meet the project schedule

•Provide coaching and guidance to the team helping development and motivate them

Environment: Windows Server 2003, SQL Server 2003, Internet Explorer, HP ALM

BELL MEDIA, Toronto March 2014 - June 2015

QA Analyst

Bell Media is Canada’s premier multimedia company with leading assets in television, radio, out-of-home advertising and digital media. Worked on a web-based application accessed by potential customers to purchase Bell TV Services, Accessories, and Plans online and this application is integrated with “Bell TV” mobile app.


•Analyzing Test Plan, Designing and executing the Test Cases, Regression, Sanity and preparing the Defects Report and re-testing scrupulously system test planning, regression planning and requirements mapping activities.

•Analyzed test results to make sure that application was according to the specifications and all critical as well as non-critical areas were covered as per specifications for Client/Server testing or web testing.

•Database Testing using Oracle Discoverer, and application tools like IBMS, Media Maestro.

•Test Management and Defect Management till closure, using HPQC

•Involved in meetings with Clients and conducted meetings to discuss the scope of testing and to verify the testing process with all the team members.

•Worked with development team to ensure testing issues are resolved.

•Strong Coherence with SDLC process focusing on Agile and Waterfall Methodologies.

•Participated in BA and team meetings for Defect calls to discuss the issues raised during testing.

•Created test suit for Bell TV mobile app

•Tested all functionalities of various mobile devices like Android, iOS, Tablets and iPads.

Environment: Windows Server 2003, SQL Server 2003, Internet Explorer, Quality Center

SCOTIA BANK, Toronto Oct 2012 - Aug 2013

QA Analyst

Scotia Bank is a leading multinational financial services provider and Canada's most international bank. This application dealt with online customer interaction in credit card application process. Applications are received through mail and files from third party vendors, partner system etc. and these applications are loaded into the system. The system uses the various decision rules, credit policies and the fraud check to approve or reject an application.


•Determined test strategies based on requirements and developed and executed test cases for Manual Testing.

•Review status of defects, including those found in production, to improve effectiveness of existing sets of test scripts

•Worked on Functional, Integration and Regression testing.

•Executed End to End and Functional test cases using Quality Center.

•Worked on Test Data for interpreting the negative/positive results.

•Managed defects through the formal Defect Management Life Cycle.

•Log defects and work with development team towards bug resolution.

•Perform back-end and front-end testing to ensure data consistency on front end by writing an executable SQL queries.

•Analyze project or requirement documents to identify test requirements.

Environment: Windows Server 2003, SQL Server 2003, Quality Center

ENBRIDGE, Toronto July 2010 - Aug 2012

QA Analyst

Enbridge Group is a leader in the energy sector offering green energy solutions, retail and commercial energy, and home services solutions. I was assigned to work on GBASS (General Billing and Settlement System), a .net based application developed to provide complete functionality of enrolling, maintaining and billing and settlement using Electronic Data Transfer.


•Participated in the BRD (Business Requirement Document) review with the QA Team.

•Tested all the table structures and field values for the Data Migration.

•Hands on experience in developing Test Plans and Strategies for Testing Web Applications.

•Participated in all aspects of Testing, including Functional, Regression, End to End testing.

•Created Test Plan and Test Cases for Manual Testing.

•Manually executed Functional, GUI, Integration, Database Testing and UAT testing.

•Prepared Summary report of overall Testing Status & Defect Status.

•Prepared Test Documentation and participated in walk-through meetings.

Environment: Win XP, .Net, Microsoft Visio, Microsoft Project, MS Office, Quality Center

ROGERS COMMUNICATION INC, Toronto July 2009- April 2010

QA Analyst; Automation Tester

WIPRO, Mississauga Jan 2007- July 2009

Software Tester


Sheridan College

Bachelor of Science (B.S.), Computer Science - 2006


QA Certified - 2006

REFERENCE: Available upon Request

Contact this candidate