Niral Gandhi

** ***** ****** ******

Brampton, ON L6Y 0K8

647-***-**** ac7vq6@r.postjobfree.com

SUMMARY

Two-plus years of experience with manual testing in web applications, desktop applications and mobile applications as well as data testing and developing

Experience with SQL Programming and Database Testing such as writing SQL queries to retrieve data from multiple database tables to test results from application Front-End

Good understanding of the software development life cycle (SDLC) and software testing life cycle (STLC)

Experience in Black Box Testing including: Sanity, Ad hoc, Regression, System integration, Browser compatibility testing, Functional testing, Migration testing

Experience in SQL Server Reporting Services (SSRS) for report generation

Experience in SQL, T-SQL (Tables, Views, sub-queries, joins, group, Constraints, UNION Operators, Aggregate Functions, Stored Procedures, Trigger)

Apply team collaboration tactics and problem solving and communication skills TECHNICAL SKILLS

Languages: C#, ASP.NET, HTML5, CSS3, SQL

Database: Oracle, MS SQL, MySQL, MS Access

Reporting: MS SQL Server Reporting Service (SSRS), Crystal Report

IDE and Tools: Visual Studio 2015, MS SQL Server 2016, Oracle 11g, Oracle Data Modeler 4.1, MS SQL Reporting service 2014, QTP / UFT, Crystal Reports 11, MS Visio, Mantis WORK HISTORY

Quality Assurance Analyst Aug 2017 - Present

Cascades Recovery, Toronto, ON

Tested mobile and window based applications using DSI mobile platform and MS SQL.

Created Test Scenarios and Test cases by requirements for Mobile and Window based Projects and performed Functional, Integration, GUI, Positive & Negative, Regression and Ad hoc testing.

Developed and executed SQL queries to verify the proper insertion, deletion and updates into the mobile and window apps supporting tables.

Tested new and enhancing the existing Crystal Reports using MS SQL and FoxPro database

Performed SQL queries (Join, Grouping, Aggregate function) to extract data from MS SQL Database.

Environment: MS SQL Server 2016, FoxPro, Crystal Reports 11, DSI Mobile Platform, Visual Studio 2012 IT Application Developer (Co-op) May 2017 - Aug 2017 SOCAN, Toronto, ON

Exported Forms, BAQ (Business Activity Query), Reports using Epicor ERP system

Updated existing and created new reports using Microsoft SQL Server Reporting Services (SSRS)

Developed BAQ (Business Activity Query) for SSRS Report

Created SQL stored procedures and views to improving reports speed and data layout. Environment: EPICOR 10.0, MS Report Builder 3.0, MS SQL Server 2014, Visual Studio 2015 Quality Assurance Analyst Dec 2014 - Nov 2015

Provoke Aero, Mississauga, ON

Developed Test Case documents according to the software requirement specifications

Worked onsite and co-coordinated with offshore development team

Performed testing on various module of web base travel application

Performed various types of testing, such as Functional, Positive & Negative, System Integration, Browser Compatibility, Regression, GUI Testing

Attended daily Scrum meeting as part of the Agile (Scrum) development process

Performed regression testing on new builds using QTP / UFT

Performed database testing using SQL queries

Environment: Windows 7, QTP / UFT, ASP.NET, SQL Server, Mantis Web Developer, (Internship) Jan 2014 - Apr 2014

Saikrupa IT Software Solution, India

Project: Airlines Management System

Performed requirement analysis and database design

Developed template based web site using 3 tire architecture

Used .Net validation controls for server-side validations and JavaScript for client-side validation

Used Grid view control extensively for data display, dynamic generation of rows and columns Environment: C#.Net, SQL Server, HTML, CSS, ADO.NET CERTIFICATES

Microsoft Technology Associate: Database Fundamental

Oracle Database 11g: SQL Fundamentals I

EDUCATION

Computer Applications Development (Co-op) Program Sep 2016 - Aug 2017

Maintaining a 3.77 GPA

Capstone Project for Intrigue Media - Guelph, ON: Continue Online Training Module

Worked in a team of 3 to develop the online training module project.

Designed ERD (Entity Relationship Diagram) using Oracle data modeler and generated DDL.

Created tables, indexes, constraints based on the design.

Design and development of Web Pages using ASP.NET and C#. Environment: MS SQL Server 2014, Oracle Data modeler, Visual Studio 2015, Bitbucket Post-graduate Certificate in Database Fundamentals Jan 2016 - Aug 2016 Seneca College, Toronto, ON

Graduated with a 3.50 GPA

Bachelor of Computer Application Sep 2011 - May 2014 Veer Narmad South Gujarat University, India

Graduated with a 7.0 CGPA

References available upon request

Contact this candidate