Customer Service Sql Server

Manisha Khanduri

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

Cell: +1-202-***-****

PROFESSIONAL SUMMARY

• 7 Years of IT experience as a QA Analyst / Test Coordinator with strong test coordination

experience, excellent communication skills, along with excellent problem solving and analytical

skills.

• Areas of expertise include Test Strategy, Resource Management, Test Planning, Defect

Management and Test Execution. Have worked with Onshore (UK), Onshore (US) and Offshore

(India) teams.

• Proficient in testing multiple applications, coordinating and managing test efforts on complex

multi-site delivery projects.

• Possess a diverse portfolio of domain experience by working with industry leaders in Financial

Services, Publishing Media, Investment Banking, Equity Trading, Health Care, and E-commerce.

• Proficient in using Quality and Performance Center Suite (Quality Center) Source Forge, and PVCS

Tracker.

• Involved in entire STLC (Software testing life cycle) and SDLC (Software development life cycle) –

Requirement, Design and Analysis, Development, Testing, Deployment and Support phase.

• Hands on Functional, Agile and Automation (QTP) testing experience.

• Self-starter and comes up with Innovative strategies for optimizing existing Testing processes and

defining new testing processes which were successfully implemented in the Organization.

• Interacted with developers, system engineers, business analysts to identify applications defects.

• Skilled in preparation and review of key testing deliverables like Requirements Traceability

Matrix, Test plan, Test Scenarios, Status reports, testing processes and metrics.

• Expertise in Databases like MS SQL Server 2000/2005/2008, Oracle including T-SQL.

• Experience in Software development Methodology such as Agile process, Waterfall Model and

Prototype.

• Highly proficient on test and defect management tools like Quality Center, ALM.

• Skilled in Testing Client Server, Desktop and Web-based applications.

• Analyze business and system requirements, mange development of specifications to create and

execute detailed test plans, and verify bug fixes.

• Determined testing requirements developed and reviewed scripts for positive and negative test

scenarios, conducted baseline testing, and generated reports. Tested server and Web Portal.

• Analyzed application, system, and security errors. Escalated issues to developers and verified

fixes.

• Designed test plans and defined cases for functional, integration system, and user acceptance

testing.

• Attended weekly defect report meetings and presented progress updates

• Prepare, maintain and share lessons learnt documents to use knowledge derived from past

experiences.

• Experience with source code management system VSS (Visual Source Safe),TFS (Team

Foundation Server).

TECHNICAL SKILLS

Testing Tools: HPALM, QTP, JIRA, Clear Quest, LoadRunner, HP Sprinter

Requirements Tool: MS Office Suite, MS project, MS Visual Studio, ADOBE Captive, Windows

Share point

Languages: C, C++, VB Script, XML, HTML

Browsers: Microsoft Internet Explorer, Firefox, Safari, Chrome

Database Technologies: Oracle 8i/9i/10g/11i, MS-SQL Server 2000/2005/2008

Operating System: Windows (9x, 2000NT, 2000, XP, 2003, Win 7), UNIX, Mac

Manisha Khanduri

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

Cell: +1-202-***-****

PROFESSIONAL EXPERIENCE

Bank of Santander Sep 2013 to Till

date

Project: Latin America Conference

Role: Test Engineer

Description:The Santander Conference is an annual conference held at Acapulco, Mexico. The

Conference scheduler application was developed in order to automate the annual Santander

Conference scheduling process and to help the conference administrators to efficiently run the

conference. This system is built as a website that is used by Santander Clients (Investors and

Issuers) and Santander Employees to register for the Conference. The registrants provide their

details like arrival, departure, one to one meeting request, panel requests and other details

upon registration.

Responsibilities:

• Reviewed & analyzed BRD, SRS and study the AUT

• Organized training and knowledge sharing sessions for the team

• Decide and implemented the test approach to be adopted

• Provided Ballparks for System test and UAT

• Developed System and UAT Test Plan, formulate the Test Cases and develop Test Data

Spreadsheets for basic, alternate, and exceptional flows

• Conducted all the phases of System Testing (Smoke, Functional, Regression, Data Validation) and

lead UAT

• Maintained the traceability matrices - RTM & FRM

• Provide Execution Time Estimation to the Project Team

• Ensure the System & UAT Test Environment is available for test execution

• Carry out extensive Data Validation by querying the SQL server database

• Performed Risk Analysis - priority & severity of each of the business requirements

• Log defects found during the execution phase and track their progress

• 8AM Publish of the action items/test cases to be executed on each day of the test cycles

• Attended daily 3pm Test Checkpoint Meeting with all the testers

• Published Test and Defect Scorecards on daily & weekly basis

• Consolidated the Test Result Summary at the end of each Cycle, detailing the pass-fail and

execution percentages and the known defects deferred to the next test cycles or to production

• Perform Root Cause Analysis for all the defects found & classify them under the categories of

Application related, Environment related, Test Data related, Missed/New/Change in requirements

related, Product Configuration related or Process related defects

Environment: Quality Center 9.0, Windows XP/2000/2003, SQL Server 2008, MS Project, MS-Office Suite

2003/07, MS Visual Studio

T Rowe Price Jan 2013 to Aug

2013

Project:Touch Point CRM

Role:Test Engineer

Description:T Rowe Price, a global investment management that mutual funds, sub advisory services,

and separate account management for individuals, institutions, retirement plans, and financial

intermediaries.

TouchPoint CRM implementation is a business strategy, supported by a defined set of processes and

technologies designed to capture, integrate, and analyze information that will boost the effectiveness of

customer-facing functions.

Responsibilities:

• Analyze the Requirements Document and creation of Test plan.

• Created a daily agenda, facilitated test meetings, captured action items and followed up on

issues.

• Preparation of Test Scenarios, Test scripts and Data conditioning based on the test scripts.

• Plan and categorize tests. Execute scripts using Quality center.

• Executed the test case manually in Mainframe applications.

• Report, monitor and track defects to closure in Quality Center.

• Facilitate coordination between development team and testing team.

• Schedule weekly status meetings with clients.

• Prepare, maintain and share lessons learnt documents to use knowledge derived from past

experiences.

• Identified ideal automation scenarios for the application.

• Involved in choosing the suitable test automation frame work.

• Prepared the automation test scripts using QTP tool.

• Received sign offs for developed automation script and maintained them for further release.

• Ensured that automation test scripts are reviewed, approved and uploaded to Quality Center.

• Involving in preparation of data to execute the test conditions in order to complete the project

within time schedule.

• Executed automation test scripts for regression using the QTP tool. Analyzed test results.

• Prepared Gap Analysis documents for Manual scripts and did feasibility study in order to

determine the candidature for automation.

• Maintained a gap analysis document to track performance.

• Effort analysis for automated testing and manual testing.

• Prepared, maintained and shared lessons learnt documents on the QTP tool and automation with

my team.

Environment:HP Mercury Interactive QTP 9.5, Quality Center 9.0, SQL Server 2008/ Oracle, XML, HTML,

Java Script, MS Project, MS Visio, MS Access, MS-Office Suite 2003/07

Lowe’s Companies, Inc. Oct 2011to Aug 2012

Project:My Lowe’s Lowes.com

Manisha Khanduri

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

Cell: +1-202-***-****

Role:QA Lead

Description:Lowe’s is a FORTUNE 100 company with 1,745 stores in the United States, Canada and

Mexico. At Lowes.com we help create a unique customer experience where customers can not only just

place orders online, but can get a 100% customer service and manage all of their purchase history by

themselves. MyLowe's is the area that we concentrate on for providing our customers with the best

possible post-purchase experience. Manage purchases, online return and cancellations, request, register

and manage MyLowe's Cards, manage accounts and home profiles are a few amongst the several

services that are at disposal of our online customers.

Responsibilities:

• Work extensively with SPOs, APOs to understand business and technical requirements.

• Work with the onsite/near shore team members while leading two offshore testers.

• Facilitate creation and documentation of User Stories; define high level acceptance criterion as

per the business needs.

• Participate in the story review sessions twice a week to groom the stories in the backlog.

• Participate in the story sizing and estimation sessions using planning poker game.

• Participate in the sprint planning sessions to go over the user stories.

• Coordinate the testing efforts with different teams.

• Track and maintain all test metrics over the sprint and report the status.

• Update the QA tasks for each story on daily basis in Version One.

• Maintain and update the list of blocking issues and work with the team to alleviate the

impediments.

• Participate in the demo for the POs and PMs at the end of each sprint.

• Provide feedback during the retrospective sessions.

• Identify potential risks to the sprint and work with POs and Developers.

• Coordinate with the services platform teams.

• Understand how we need to handle various types of orders.

• Work with the UAT teams for release testing.

• Work with fellow test leads on test suite optimization and the ongoing automation.

Environment:Version One, Quality Center 9.2, Quality Center 11, JAVA, QTP, MS-Office Suite

BT Company, UK July 2010 to Sep 2011

Project: Bt.com

Role: Quality Analyst

Description:BT is one of the world’s leading communications services companies, serving the

needs of customers in the UK and in more than 170 countries worldwide.The intension of this

application was to create an Online Community that empowers people in building successful

businesses. This community allows its members to exchange ideas and information and benefit

from the experience of others

Responsibilities:

• Responsible for testing of the new version of the company website.

• Wrote reports for ambiguous or missed project requirements to QA team and customers.

• Created traceability matrixes to understand which requirements or documents need to be

change and how much time it will take.

• Performed Black box testing such as exploratory, functionality, regression, compatibility and

usability testing.

• Planned and wrote test cases in MS Excel for major features and functional areas.

• Performed GUI testing (buttons, fields, font, spell check, label etc)

• Maintained database of documents and reports with help of MS Excel.

• Analyzed software failures and reported bugs by using MS Excel, Element tool.

• Tested functionality of company intranet system such as links, access level, editing, downloading,

searching, notification, deleting protection, etc.

• Attended in QA team meetings.

• Wrote weekly reports to lead QA manager.

Environment: Windows XP/2000/2003, MS-Office Suite

Feel Good Contacts, UK Sep 2007 to Jun 2010

Project:Feelgoodcontacts.com

Role: Quality Analyst

Description:Feel Good Contacts is the UK's leading online contact lenses portal.

Feelgoodcontacts.com is 100% dedicated to make the contact lenses purchase as convenient and cheap

as possible.

Responsibilities:

• Responsible for testing of the company website.

• Performed Black box testing such as exploratory, functionality, regression, compatibility and

usability testing.

• Planned and wrote test cases in MS Excel for major features and functional areas.

• Performed GUI testing (buttons, fields, font, spell check, label etc)

• Analyzed software failures and reported bugs by using MS Excel, Element tool.

• Tested functionality of company intranet system such as links, access level, editing, downloading,

searching, notification, deleting protection, etc.

Environment: Windows XP/2000/2003, MS-Office Suite, Visual Studio, SQL Server

EDUCATION

Bachelor in Business Management - University of Sunderland, London, UK

Contact this candidate