Sql Server Quality

Chiranjeevi Meka

(QA Analyst)

(: 336-***-****

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

. U.S. Resident holding Work Authorization\EAD.

. Over 6 years 4 months of diverse experience in Software Quality

Assurance.

. Experience in Analysis, Design & Execution of Manual & Automated

testing for Client/Server and Web-based applications.

. Strong understanding of Testing Methodologies and Project Life Cycles

(SDLC).

. Experienced in Integration, System (Functionality, Regression), UAT

and Performance Testing.

. Extensive experience with executing automated test scripts (primarily

with QTP, Quality Center)

. Proficient in creating Test Plans, Test cases, Test Scripts and Test

procedures based on Business Requirements.

. Extensive experience in White Box and Black Box Testing and in

modifying Test Scripts.

. Expertise in Bug search, Bug Tracking Reports using Quality Center.

. Expertise in QA/Testing E-commerce, WEB and Client/ Server

applications with Windows Environment and Oracle, SQL Server databases

as back end.

. Excellent communication skill, self-motivated, detail oriented, time

bound, responsible team player and ability to coordinate in a team

environment.

. Articulate with interpersonal, intuitive, technical, analytical and

problem solving skills.

EDUCATION

Post Graduate Diploma in Computer Applications

Masters Degree in Economics

Bachelors Degree in Arts

TECHNICAL SKILLS

Operating System : Windows 95/98/2000/NT/XP/7, MS-DOS, and UNIX.

Testing Tools : Test Director, Quality Center, ALM, QTP

Programming : C, C++, SQL, PL/SQL, Java, VB, TSL.

Web scripts : HTML, DHTML, XML, XML Spy, JavaScript, VB.

Databases : SQL Sever 2000 & 2005, Oracle 7/8/9i, MS Access.

Others : MS Office (Word, Excel, PowerPoint, Outlook).

WORK EXPERIENCE

Client: Wells Fargo Bank, Charlotte, NC Sep 2013 -

May 2014

Project: PRS\Print Services Overhaul

Department: Wholesale Managed Utilities\Wholesale Strategic Technology

Services\

Wholesale Technology Services (WTS)

Role: QA Systems Analyst

Print work is going outside the organization when capacity exists to

provide in-house which would save 25% of the cost. The purpose of this

project is to enhance the PRS Print submittal tool to reduce duplication of

tasks by customers and operators, incorporate customer required features,

and provide workflow to take a document from customer to printer without

manual intervention. The project involves the purchase and installation of

new software libraries, potentially the purchase and installation of

hardware, and development of work processes. Developing new reporting

processes is included as well as the training of Requestors (internal

customers), operators, and administrators.

Responsibilities:

. Analyzed the PRS Overhaul FSD requirements and prepared the Test

Scripts including test plan formulation from requirements.

. Involved in System testing of PRS application in Dev & UAT

environments.

. Prepared Scenarios and created Test Scripts in ALM\Quality Center.

. Performed Testing to ensure that the data is updated in the SQL Server

database as per the requirements.

. Written Test Scripts and performed Manual Testing like Positive

Testing and Negative Testing.

. Using SQL scripts tested the data populating to the SQL Server

database

. Created Test Scripts, validated requirements with test cases and

generate reports (Requirements and PASS/FAIL) using Quality Center.

. Executed the test cases, analyzed the actual results against the

expected results to each GUI objects.

. Creation and execution of Test Scripts and documenting the final

results.

. Interaction with developers and Business Analyst team to discuss the

design and testing scenarios of the application.

. Used ALM\Quality Center as a defect tracking tool.

. Retested the defects that are in Test status and updated the defect

tracking sheet.

. Generated Daily Test Status reports in ALM\Quality Center & Exported

Various Reports from ALM to Excel, MS Word & HTML.

. Imported Test Scripts from Excel to ALM.

Environment: .NET, Windows 7, ALM\Quality Center, SQL Server, Share Point,

MS-Excel, MS-Word.

Client: Triad Guaranty Insurance Corporation, Winston-Salem, NC

Apr 2011 - Sep 2013

Role: QA Analyst

Through its Mortgage Insurance service offerings, Triad Guaranty Protects

lenders across the United States from losses due to defaults on first

mortgages for single-family residential properties.

ALS (Automated Loan Submission) is one of the Automated Loan Processing

portal added to Triad Guaranty's web online. Lenders like Bank of America,

Countrywide, Wells Fargo, Loan Prospector and Principal will be able to

submit & receive Mortgage Insurance requests, response in the quickest and

most accurate manner available..

Responsibilities:

. Analyze the requirements and prepare the Test specifications including

test plan formulation from requirements and test scenario development

from ALS use cases.

. Involved in manual testing and Automated testing of ALS.

. Performed Black Box testing on various hardware platforms and software

configurations

. Create the environment for automation testing and design the strategy

for complete test coverage.

. Worked with various check points by using QTP

. Prepared Scenarios and created Test Cases in Quality Center.

. Performed stress test and performance test using Quality Center.

. Performed Testing to ensure that the data is updated in the SQL Server

database as per the requirements.

. Programmed scripts according to the internal logic of the ALS

application

. Written test cases and performed Manual Testing like Positive Testing

and Negative Testing.

. Using SQL scripts tested the data populating to the SQL Server

database

. Create test cases, validate requirements with test cases and generate

reports (Requirements and PASS/FAIL) using Quality Center.

. Executed the test cases, analyzed the actual results against the

expected results to each GUI objects.

. Creation and execution of Test Scripts and documenting the final

results.

. Performed manual testing by following the end user business processes

on the entire application to test for real world scenarios along with

the business testers.

. Performed automated functionality testing using Quick Test Pro up to

documents generation part.

. Interaction with developers and Business Analyst team to discuss the

design and testing scenarios of the application.

. Used Star Team as a defect tracking tool.

. Maintain defects in Star Team and participated in defect review

meetings and GO/NO-GO meetings.

. Retested the defects that are in Test status and updated the defect

tracking sheet.

Environment: .NET, Windows 7, QTP, Quality Center, VB Script, PL/SQL, SQL

Server, MS-Excel, MS-Word and Star Team.

Client: CITI BANK, New York May

2009 - Mar 2011

Project: Credit Card Approval (CCA)

Role: QA Analyst

Citibank, one of the largest banks in US is a premier provider of various

financial services to its customers. Tested their Web application

developed with Java Servlets and JSP, for servicing page requests, that was

hosted on a Web Sphere HTTP server. This application enabled the clients

and customers of the bank to apply for various credit cards and get

immediate decisions on their applications online. Applicants could also

apply for Credit Line, a revolving unsecured line of credit that combines a

large credit limit with the convenience and flexibility of a Credit card,

with a low long-term interest rate. During decision process, checks are

made against all booked application to ensure that the product eligibility

rules are enforced.

Responsibilities:

. Involved in Design and Quality Assurance

. Wrote Test Plans, Test Cases, Test Summary Reports

. Conducted Manual Test Execution

. Used Automated Tools -WinRunner, QTP

. Wrote independent Test case-oriented and automated scripts for

Regression Testing in TSL using WinRunner, and VBScript using QTP.

. Managed GUI Map Files and log files of Automated test runs

. Worked in conjunction with the Requirements Analyst and other testers

to create and organize Software Requirements in Mercury Quality

Center.

. Use the Standard, Customization, Context Sensitive and Analog

functions of TSL to create function libraries

. Incorporated image checkpoints to test the functionality of the

signature field

. Conducted Extensive Data-driven tests

. Incorporated SQL in automated tests to Conduct backend (Database)

tests.

Environment: QTP, Quality Center, HTML, XML, CSS, xHTML, WML, Java, J2EE,

JDBC, Servlets, JSP and EJB, Web Logic, MS Visio, Windows XP Prof..

Client: Liberty Mutual Home, Boston, MA

Feb 2008 - Apr 2009

Project: Right Price Web Application (RPW)

Role: QA Tester

Liberty Mutual Home provides Auto and Home Insurance in various parts of

USA. The RPW application is to get the online Quote & Purchase for Auto and

Home Property Insurance. It deals with both Commercial and Personal lines

of Insurances. It enables the customer to get Quick and Full Quotes of new

Businesses for Auto and Home (Home owners, Renters, Condominiums), with

enhancements. The Auto Insurance deals with all details of the Driver's

history and Vehicle history. This is complete online e-transaction

application service involving Customers, Agents and Call centers through

direct or mutual interactions.

Responsibilities:

. Participated in business requirement walk through, design walk through

and analyzed business requirements.

. Developing the software test plan and model activity.

. Prepared detailed test procedures, test scenarios, test scripts and

schedules based on requirements and design documents.

. Validating source code and executables are promoted to the correct

test Environment.

. Participated in preparing Integration test plan.

. Executed integration test by coordinating with external teams.

. Reviewed and suggested improvement to a group of related functions,

the Test Harness.

. Created and executed SQL queries to fetch data from an SQL Server

database server to validate and compare expected results with those

actually obtained.

. Bug tracking was done through Quality Center.

Environment: Windows 2000, XP, DB Visualizer, JavaScript, SQL Server,

Quality Center

Contact this candidate