Customer Service Sql Server

PROFESSIONAL SUMMARY

Six years experience in analyzing and reviewing Business Requirements, System Requirements and Functional Requirements documents

Strong experience in developing Test Plans, Test Cases and Test Scripts from Requirements, Use cases and HLD

Strong testing experience in Web based and Client Server applications

Strong knowledge of Software Development Life Cycle (SDLC) like CMM, Iterative and Agile

Proficient in both Manual and Automated testing

Experienced using HP QualityCenter, Clear Quest and QTP

Specialized in testing on both WINDOWS and UNIX environments

Experienced in performing different types of testing including System Testing (ST) System Integration Testing (SIT),Functional, Regression & User Acceptance Testing (UAT)

Experienced in testing backend applications by writing SQL and PL/SQL statements

Extensively worked in validating GUI front end and back-end databases like SQL Server and Oracle

Experienced in testing environments like Java, .NET, ASP, HTML, DHTML, XML, JavaScript and VB Script

Experienced in working with Project Managers, Business Analysts, Developers in analysing BRD, SRD and FRDs

Excellent analytical and problem solving skills with strong oral and written communication skills

TECHNICAL EXPERTISE

Testing Tools Quality Center, ClearQuest and QTP

Processes Agile, CMM and Iterative

CRM Clarify CRM, Oracle on Demand

Databases Oracle & SQL Server

GUI Visual Basic

Languages SQL & PL SQL

Internet Technologies HTML, Java & VBScript, .NET and ASP

OS Windows XP, 2000 and UNIX

MS Office Word, Excel and Power Point

EDUCATION

Masters of Science in Information Systems and Management

Periyar University, Chennai, India

Bachelors in Commerce and Information Systems

Nagarjuna University, Hyderabad, India

PROFESSIONAL EXPERIENCE

AT&T, Alpharetta, GA Jan 2009 – Apr 2011

Sr QA Analyst

Amdocs Clarify CRM is a Customer Interaction Management application used by Customer Service Representatives to create Interactions for customers to track issues for support and resolution. It is a web based application built using Java and J2EE Technologies and Oracle as its backend database.

Responsibilities:

• Analyze and review Business, System and Functional Req documents

• Review HLDs to understand the new functionality

• Participate in developing Test Strategy and Test Plan

• Design Test plan and Test cases

• Develop Requirement Traceability matrix (RTM) between Requirements and Test Cases to cover the complete coverage of the functionality being tested

• Conduct internal and external reviews with internal QA and external teams respectively

• Involve in QA shakeout activities

• Perform Manual testing of the application

• Perform Functional testing on new functionality

• Perform extensive System Integration and regression testing to make sure existing functionalities are intact

• Perform web based testing on different browsers like IE, Firefox and Mozilla

• Participate in User Acceptance Testing (UAT) to assist business users

• Perform backend testing using TOAD to run queries against Oracle database

• Perform Interface testing

• Perform logs testing using XML and UNIX commands

• Track defects and report to the development team using HP QualityCenter

• Re-test defect fixes and perform regression testing around the functional of the fix to make sure nothing is broken due to the new fix

• Participate in bug review meetings to triage bugs based on their severity and priority

• Develop Test Summary Reports to the management

• Crete high level validation steps for production support team for prod day validations

• Support deployment planning activities and post prod fixes testing

Oracle Mar 2007 – Nov 2008

Hyderabad, India

Sr QA Analyst

Project: Oracle CRM on Demand

Oracle Contact on Demand is one of the modules in Oracle CRM on Demand. This module is basically used by call center agents to interact with customer on daily basis for trouble shooting and resolution of issues. Oracle Contact on Demand captures every interaction and provides a unified view of customers across all customer-facing organizations. So that organizations can resolve service requests in one call and enhancing customer satisfaction.

Responsibilities:

• Analyze and review Business Requirements, System Requirements and Functional Requirement documents

• Determine the goals and objectives of the testing with combined Business users needs and requirements

• Design Test Plan and Test Cases

• Conduct Internal reviews with test team for their feedback on functionality being tested

• Conduct External Test plan and Test Case review to solicit feedback and approvals

• Develop Requirement Traceability Matrix (RTM) between Requirements and test cases to cover the complete coverage of the functionality being tested

• Perform System(ST), System Integration (SIT) and Functional testing for the new functionality

• Performed Regression testing on existing functionality to make sure nothing is broken due to the introduction of new functionality

• Track and prioritize defects based on severity levels in Quality Center

• Interact with development team to reproduce the defects for easier resolution

• Interact with Business Analysts and Project Management team to clarify ambiguity in requirements

• Report daily Test Summary to the Management on daily basis

• Participate in User Acceptance Testing (UAT) on behalf of QA team

• Prepare high level production validations for deployment team

• Participate in Go/No Go meetings

• Support post deployment production fixes

Environment: Java, J2EE, Web services, XML, Oracle, QTP and Quality Center

Virtusa Aug 2005 – Feb 2007

Hyderabad, India

Test Engineer

Project: E-tivity enhancements

The E-tivity product is built using .Net Framework using technologies like .net remoting, Microsoft Message Queuing (MSMQ) and SQL server 2000 as its backend database. E-tivity assists in preparing the work schedules for collecting the time worked and delivering the interpreted results to payroll department.

Responsibilities:

• Analyze and review Business Requirements, System Requirements and Functional Requirement documents

• Design Test Plan and Test Cases which specify testing overview and testing approach depending on the Business and Functional requirements

• Conduct Internal reviews with test team for their feedback on functionality being tested

• Conduct External Test plan and Test Case review to solicit feedback and approvals

• Develop Requirement Traceability Matrix (RTM) between Requirements and test cases to cover the complete coverage of the functionality being tested

• Perform System Integration (SIT) and Functional testing for the new functionality

• Perform Regression Testing on the application by creating Automated Test scripts using QTP and by repeated execution of recorded test procedures to identify errors in each modified build

• Participate in meetings with developers to discuss new enhancements/scope changes

• Check for data integrity by executing SQL queries to the database

• Performed configuration testing of web pages with different browser versions of Internet Explorer and different operating systems such as Windows 2000/XP

Environment: .NET, PL/SQL, SQL Server and Windows 2000/XP

Contact this candidate