Sql Server Management

Francy J Tharakan

**** *** ******, ***********, ** bec, H9H 4W7.

Mob: 514-***-****, E mail : **************@*****.***

Skill Summary

Software Quality Assurance

Rich experience in software QA industry, worked in different roles,

different business domains

Prepared test plans, test scenarios, test cases, estimates, test reports,

defect management.

Tested Desktop and Web based applications [ERP/MIS]

Worked in Agile and Water Fall methodologies, involved in various SDLC

phases.

Managing Offshore team and reporting to client.

Participated in process audits and took initiative in adding new process

Did performance review and annual appraisal of of team members.

Test automation software: Mercury Quality Center,Test Track Pro, Team

Foundation server.

Platforms: Windows Platform

Programming languages: ASP, ColdFusion, HTML.

Database systems: Oracle, MySQL, Microsoft SQL Server

Other software: Microsoft Office Tools, Microsoft Project,Soap UI

Professional Experience

Test Lead [Genoa QA Team]

Employer : Oceanwide Inc, Montreal.

Period : November 2011 to May 2013

Responsibilities :

QA activities in Genoa Core QA Team

Leading a team of six QA Analysts

Active role in Sprint grooming sessions, providing complexity ranks to each

functionality based on effort.

Taking part in Sprint planning meeting providing estimates and adding QA

tasks in dashboard

Creation of QA Test Plans, Test Case and Test Data.

Test Execution of Test cases in UI and verification of Data in SQL server

Actively participating in Scrum meetings and triage meeting to track

progress and prioritize defects

Defect management and test verification in Team foundation server

Review of test cases and test results document created by QA team members

Testing in different browsers and smoke testing test readiness of test

environment.

Tracking progress of all testing activities and status reporting to Sr.

Manager and VP

Preparing Test Summary report per Sprint

Presenting the new functionality to the stake holders in the Sprint Review

meeting

Discussing the risks, issues and process improvement in the Sprint

Retrospective

Causal analysis of defects and steps for improvement.

Management tasks for Genoa QA Team

Set Short and long term goals for the team members

Help employees plan career objectives within team and organization

Performance review and salary appraisal of team members

Define and implement testing methodology [Waterfall / Agile]

Meet with team members to go over project Goals and status

Discuss Project time lines with project Managers.

Review current test plan status with management.

Training and Mentoring of new employees and doing KT session after each

release to update the team knowledge on what was implemented and test

verified

Attended Requirement Analysis meeting to provide QA effort, risks and

impacted areas to senior management before signing the SOW with the client.

Senior QA Analyst

Employer : Oceanwide Inc, Montreal.

Period : January 2010 to October 2011

Responsibilities :

Preparation of Testing estimate per functionality.

Preparation of Test Plan, Test Cases, Test Scenarios, Impact analysis,

Traceability Matrix

Presenting test scenarios to stake holders and review of test cases created

by team members.

Execution of Test Cases and Test Results document

Test verification in Database SQL server

Defect Management in Test Track Pro / Team Foundation server

Test verification of Defects and closure of defects

Test verification in multiple browsers, languages and environments.

Interaction between other groups and reporting status to QA Manager.

Web Service testing.

Causal Analysis of defects

Training new employees and providing KT sessions

Attending Account director meeting to provide status per functionality and

to raise any risks identified.

Web based MIS Application : Genoa - Marine Insurance application in ASP.NET

/ MS SQL Server.

Project Lead - Testing

Employer : Cognizant Technology Solutions Ltd.

Period : May 2007 to September 2009

Responsibilities :

Experience in leading a testing team of fifteen members

Involved in preparation of Project estimate, Project plan, Test plan, Test

Scenarios and Test cases

Involved in the resource estimation and management for a release.

Preparation of requirement analysis documents and clarification sheets

Review Test scenarios, Test cases and Unit test cases for the team and

other Release teams

Test case Execution and test log preparation of test cases in HP Quality

Centre.

Test verification test results in Oracle Database

Preparation of requirement traceability matrix (RTM) and risk management

plan

Defect management and Test verification of defects to closure using HP

Quality Centre (QC)

Working along with development team to investigate the defect cause and

address defect resolution.

Experience in system testing, regression testing, installation testing and

performance testing.

Verifying installation in different versions of windows OS and

availability remote desktop application like Citrix, VNC etc..

Preparation of Test summary report / Performance testing report and Causal

analysis of defects.

Preparing knowledge repository and learning document for each release.

Daily status reporting to onshore delivery manager and fortnightly reports

to Client director (projects)

Have testing experience in both web based and desktop applications (.NET

and Java)

Involved in documentation for process audit of the project

Member of core group for decision making, planning of work, and process

improvement.

Actively participated in recruitment process and performance appraisal of

team members.

Mentoring new joinees in the team and conducting knowledge transfer

sessions.

Web based Application :

Portable People Meter Web application - Tool used by Arbitron to measure

and tabulate the radio ratings, which is generated from each individual

who participate in the survey by wearing the PPM and hears radio

programmes. Developed in Java and Oracle as DB

Desktop Application [VB with MS SQL Server ]

SmartPlus : Application to manage advertisement slots based on clients

budget and Program ratings for radio and TV media.

PrintPlus : Application to manage advertisement slots based on clients

budget and media ratings for Print media.

TST : Application for integrating data from an obsolete applications TV

Scan and Tap Scan to SmartPlus

C.T.O and Patner

Company : Ivory Infotech.

Period : April 2002 to May 2007

Responsibilities :

Create Project estimate, Project plan, Test plan, Test scenarios, Test

cases, Test scripts

Review of test cases from the test team and providing unit test scenarios

for Development team

Execution of test cases for system testing, regression testing.

Installation testing of desktop application in different versions of

Windows OS

Preparation of requirement documents, system study of existing process,

Comparing functionality of competent products & prioritizing new

requirements for development.

Preparation of requirement traceability matrix (RTM) and risk management

plan.

Defect reporting and tracking using Customized tool in MS Excel and porting

into HP QC

Working along with development team to investigate the defect cause and

address defect resolution.

Preparation of Test summary report / Performance testing report and Causal

analysis of defects.

Preparing knowledge repository and learning document for each release.

Technical support after software implementation and preparing user manuals

Helping the pre-sales team to present the software product demo

Status reporting to the senior management of client.

Worked in application from SCM / Accounts and Finance domains

Implemented QA Process based on waterfall SDLC

Training new QA / Development Employees in the team, Writing training

documents and schedule

Web based Applications [ASP.NET and MS SQL Server or My SQL]

msgwire.com : This is a newsletter application in which campaigns can be

created and sent to recipients.

Ivy-Business Suite : IvyOne Business Suite is an ERP solution customized

for SCM domain.

Ivy-Projects : The project was done to keep track of the project

development in Ivory Infotech.

Gates Millennium Scholarship Programme : This is student management project

done for GMSP, USA.

Ivory Talk : Web based chat application, Developed in Java and My SQL

Materials Management MIS : This software automates the functions in the

purchase department of CDAC.

HR Management MIS : This software automates the functions in the personal

department of CDAC..

e-School : e-School is an comprehensive online student management system.

Desktop Applications [Visual Basic and MS Access]

Ivy-Voyager : Travel & Tour Company management software.

Ivy-Finity : Accounting software for charitable / non profit organization.

Java and My SQL

Ivy-Realtor : Real estate company software . .

Ivy-Message : CRM software for automobile service centres.

Ivy-Entrack : Sales automation software & Sales lead tracking.

Memory Module Software : Serial port communication software for reading

data of external devices

Medical Image Creator : Serial port communication software for taking

snaps of CT Scanner video output

Quality Assurance Engineer

Employer : Zanchu Inc.

Period : November 2000 to March 2002

Responsibilities :

Actively involved in the requirement analysis meeting

Create Test plan, Test scenarios, Test cases, Test Estimates

Execution of test cases for system testing, regression testing, and

performance testing.

Test verification of test results in MS SQL Server

Preparation of requirement analysis documents and clarification sheets

Defect reporting and tracking using excel sheet

Working along with development team to investigate the defect cause and

address defect resolution.

Status reporting to Senior Management and Dev Team

Worked in QA process for Waterfall SDLC

Web Developer

Employer : Elton Web Solutions Pvt Limited.

Period : November 1999 to October 2000

Responsibilities :

Coding of web based application [Oceanfreights.com] in Coldfusion and MS

SQL Server.

Execution of Unit test cases for unit testing and its log.

Preparation of process flow diagram and creation Database tables

Defect reporting and tracking using excel sheet

Education

MBA with marketing as major from Indira Gandhi National Open University in

2005

Diploma in Oracle and C Programming from NICT in 2001

Diploma in E-Commerce in 1999

Bachelor of Science with Chemistry as major from Mahatma Gandhi University

in 1995

Achievements

Represented the employer for CMMI Level 5 audit in Requirement - Analysis &

Design module.

Achieved ISTQB certification in 2008

Language Preference

English

Contact this candidate