Post Job Free

Resume

Sign in

Test Cases Sql Server

Location:
Toronto, ON, Canada
Salary:
60-65k
Posted:
September 04, 2015

Contact this candidate

Resume:

Ana Gunja

Phone: 902-***-**** Email: acrjon@r.postjobfree.com

Address: * ***** ******, *********, **** Scotia, B2W 1L3

SUMMARY

A dynamic IT professional with 6+ years of rich experience in the arenas of Software Quality Assurance.

Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete

In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle, Teradata and ETL.

Extensive experience in reviewing and analyzing Business Requirements and writing detailed Test Plans, Test Cases, and Test Scripts

Experience includes the testing of Client/Server, ETL, SOA and WEB applications using Manual and automated testing tools like Selenium, Quality center, Rational Suite, Load Runner and Quick Test Professional.

Experience on Test management tools like TMS, Quality Center and RallyDev.

Expertise in implementing RUP (Rational Unified Processes), Agile and SCRUM Methodology by analyzing requirement specifications and responsible for developing Test Objective, strategies, Scope, Test procedures and Test Matrices.

Extensive experience in conducting different kinds of tests such as Integration, Regression, Functional, System Testing, Black Box, UAT and Sanity Testing.

Experience in working with scenarios related to Banking, and finance Web portal applications

Experience in leading the testing effort for Mainframe, java, J2EE, .NET applications.

Sound knowledge and exposure in working with the various relational databases like Oracle, SQL Server etc.

Sound knowledge of java application testing, quality centre, and mainframe application testing

Extensive knowledge of mainframe tools and techniques as well as Unit regression testing

Comprehensive knowledge of mainframe programming, test plan, regression testing, and techniques

Extensive expertise in Business Intelligence and Enterprise Application Integration.

Expertise in Back end database testing with database Oracle, DB2, and SQL Server.

Proficient in executing SQL queries and strong in security backend testing.

Excellent Scripting Knowledge of VB Script for QTP.

Excellent working knowledge of designing and implementation of QA test strategy and Test plansmanually and automated test solutions for client/server, ETL, SOA Process, ERP and Web applications.

Well in testing of the web services using the SOAPUI testing tool.

Worked with the build/release management teams to validate the system setup and configurations at pre-deployment stage.

Good verbal and written communication skills.

SKILL SET

Operating Systems: Windows XP/Vista/7, MS-DOS.

Languages: Java, C, C++, SQL, PL/SQL.

WEB: HTML, JavaScript, VB Script, ASP and XML.

Bug Tracking Tools: Mercury Quality Center 10, HP ALM, Bugzilla, Jira and RallyDev.

Databases: SQL SERVER, SYBASE, ORACLE, UNIX, EXCEL, MS-ACCESS 2000.

Rational Tools suites: Rational requisite pro, Rational Test Manager, Rational Robot.

Mercury Automated Test Tools: Quick Test Pro/UFT, Load Runner 11, TD, Quality Centre ALM

GUI Tools: Data Stage, Micro Strategy, DB2, MS SQL Server & PL/SQL Tool.

Test Strategies: Integration, System, Regression, User-Acceptance, Smoke, White Box, and Black Box.

ERP/CRM: Salesforce, SAP ECC 6.0, SAP CRM, SAP MM, SAP Bank Analyzer.

ETL Tools/Reporting Tools: Informatica, Abinitio, Cognos, Crystal, SAP BO

Methodologies: Agile SCRUM, Waterfall (SDLC), Rational Unified Process

GSK, Toronto (ON) July-2013 to April-2015

Project: inVentiv CAST

Role: QA Analyst

Project Details: inventive CAST is a Sales Force Automation project, which is used by a high voluminous pharmaceutical marketing company that does marketing and sales for various other pharmaceuticals products.

Analyze requirements specifications and create test plans and test cases.

Break down requirements into manageable functional areas and assign tasks to team members.

Estimate work effort for testing lifecycle.

Track testing progress and produce progress charts for project and risk management.

Create and manage requirements traceability matrix for coverage/gap analysis.

Install and configure software applications.

Conduct manual and automated functional, regression, integration, end-to-end, and capacity testing.

Participate in and support production and user acceptance testing.

Identify issues and report them in defect tracking and management tool.

Perform defect analysis in collaboration with business analysts and assign priorities for developers to fix and QA to test.

Brainstorm outstanding issues with QA Analysts, Business Analysts, Developers and Operators and seek resolution to problems.

Perform impact and root-cause analysis for new change requests and production/environmental issues.

Provide feedback to team members after reviewing requirement specifications, design documents, source code and test cases.

Identify process inefficiencies and make improvements for higher productivity.

Train onshore and offshore staff on SDLC procedures, deliverables, system architecture and functionality.

Ensure that required deliverables are produced in accordance with SDLC requirements.

Generate and maintain training material on Wiki and SharePoint.

Host and participate in project status meetings.

Environment: HP Quality Center ALM, HP Quick Test Professional 11, HP LoadRunner 11, Jira, Salesforce, Crystal Reports, HTML, DHTML, XML, Oracle 11i, SQL, UNIX, SharePoint and Windows XP.

ATB Financials, Edmonton (AB) March - 2011 to June - 2013

Project: eSwitch/Mobile Banking

Role: QA Analyst

ATB customers have the option to sign up for eSwitch, If they would like to take advantage of this free service, you will be asked to fill out the Authorization Form at your branch and designate a time to be contacted by phone to confirm the pre-authorized transactions they would like to transfer to ATB. ATB Mobile banking can be used by the ATB customers who switched to ATB Bank to perform banking activities like payments, transfer and statements.

Involved in the review and analysis of Business design summary, Use case document and Screen definition documents.

Analyzed the functional requirements of the application and developed Test strategy for the application.

Developed various Test plans and Test cases and analyzed Test results.

Responsible for tracking defects using Quality center and made sure those defects are efficiently passed from one layer to another.

Developed automation of test cases using Quick Test Pro to perform Regression Testing for different versions of application.

Analyzed and documented the test results for each build of testing.

Enhanced and modified the scripts according to the test case scenarios.

Created modular tree for global use.

Performed GUI Test, System test, and Performance test.

Performed Black box and White box testing.

Conducted Data Driven Tests using a wide variety of data that included positive, negative and boundary data.

Created QTP scripts to insert checkpoints like GUI, Bitmap, Database and Synchronization checkpoints.

Environment: SQL Server, SAP Bank Analyzer, SAP CRM, SAP ECC 6.0, SAP BO, QTP 11, HP ALM, Quality Centre 10, Informatica, Java, Java Script, Oracle, SAP, SQL, UNIX, Mainframes, and Window XP.

Telus Health, Ottawa (Ontario) July-2010 to March- 2011

Project: Telus EMR – Electronic Medical Records

Role: Validation Engineer/QA Analyst

Project Details: TELUS Electronic Medical Records (EMR) is a powerful, intuitive clinical-management system. Customized to specific doctors practice, it captures, organizes and displays patient information in a user-friendly manner, helping the physicians to manage their practice effectively.

Analyzed system specifications and involved in the development of Business Specification Documents (BSD), Software Requirement Specification (SRS), and Design Specification Documents (DSD) and involved in technical writing of traceability matrix. Preparing the new and improved SOPs in place to reach Part 11 compliance.

Involved in requirement analysis and documentation of functional specs.

Identified Test Scenarios for required system and functional testing.

Provided support in the preparation of Test Plan specifying an overview of testing approach, testing strategy, and scope.

Developed Test Cases as per to the Requirement Specifications.

Maintained the Requirement Traceability Matrix using Mercury Quality Center.

Executed test cases and test scripts manually and using automation tools.

Performed Functional, Regression and Integration testing.

Involved in unit, integration, system testing of the application using Visual Studio Team System

Used QTP automation tools for Functional, Regression and Data Driven testing.

Performed ETL testing based on the Data conversion document.

Used SQL tools such as SQL Query Analyzer for creating SQL queries to verify the integrity of the data.

Performed extensive back-end testing and database auditing using SQL Server.

Used Quality Center as a release management tool.

Provided production support for the releases.

Used Mercury Quality Center and JIRA to house all test documentation, report/track all issues and defects.

Provided clear concise feedback to development team on recurring errors both on an individual and team basis.

Environment: HP Quality Center 10, HP Quick Test Professional 10, HP LoadRunner 10, Ab-Initio, Crystal Reports, Java, Java Script, EJB, SOAP, HL7, XML, Websphere, SQL, SQL server, Windows XP.

Department Of Nova Scotia Transportation & Infrastructure, Halifax (Nova Scotia) January-2009 to June-2010

Project: Global Material Control System (GMCS)

Role: QA Tester

Project Details: GMCS is an SAP application developed for Department of Transportation & Infrastructure. The system aims to compute the material management for specific departments. This application is also connected to Inventory Management System. There are multiple analytics reports that can be generated for specific departments using SAP BO.

Reviewed functional and design documents to meet the business requirement

Responsible for functional testing, regression testing & integration testing.

Involved in preparing the Test scenario's, Test cases for complete application Testing.

Responsible for preparing the matrix for Test case development and execution status.

Responsible for creating functional test cases as per the functional specifications.

Involved in reviewing and ensuring that all functional cases are covered as per the functional specifications.

Involved the execution of the test cases manually

Documenting and tracking defects in Issue Log in MS Excel

Prepared bug reports.

Coordinated with the Developer till the assigned bugs were resolved

Involved in all phases of testing.

Successfully handled the testing assignment at team level and as an individual.

Extensive use of SQL queries to test Backend (DB)

Environment: Jira, MS Test Manager, Team Foundation Server, ASP.NET, VB.Net, SAP MM, SAP CRM, SAP BO, SQL server 2000, IIS, Windows XP, MS Office 2003.

EDUCATION

ISTQB Certified Professional

Bachelors of Technology – Spoorthy College Of Engineering



Contact this candidate