Testing Sql Server

KUMAR KONDURU

abl3ui@r.postjobfree.com

Mobile: (**4) 300- 6476

Summary:

. More than 9 years of experience in Manual & Automated testing on

client-Server applications.

. Excellent team player with very good logical reasoning ability and

coordination and interpersonal skills

. Good experience in design and execution of Test Cases, Test Scripts

and Scenarios.

. Well versed with various test strategies like Integration testing,

System testing, Acceptance testing, Stress testing, Load testing,

Regression Testing etc...

. Expert in preparing test plans and cases covering "Black Box Testing".

. Expert in Manual Testing and Automation Testing using Mercury

Interactive Tools such as: (Quick test Pro, Load Runner, Test Director

etc.) and Quality Center

. Extensive testing experience in Financial Domain such as Trading,

Bonds, Fixed Income, Securities etc.

. Experience in testing the customers to check their portfolios online,

get breaking financial news, real time access to accounts, electronic

copies of statements, trade the stocks- along with providing real time

quote information etc

. Developed/Modified subject area graphs based on business requirements

using various Ab Initio Components like Filter by Expression,

Partition, reformat, join etc for mocking test files and performing

negative validation testing.

. worked on Abinitio GDE testing various graphs and also tested Abinitio

graphs deployed as shell scripts in Unix server

. Worked with various Abinitio components such as Reformat, Filter by

expression etc

. Remarkable experience in SDLC (Software Development Life Cycle) and

Testing Planning Process and Well versed with different phases of

Project Life Cycle.

. Expertise in Data Warehouse, ETL Verification, BO reports and Universe

testing.

. Experience in Dimensional Data modeling, Star/Snowflake schema design,

Fact and Dimensional tables, Physical and Logical data modeling.

Complete understanding of Ralph-Kimball and Inmon approaches to Data

Warehousing.

. Automated Test Case scenarios using QuickTestPro.

. Used MS project for Project Scheduling during the entire life cycle.

. Extensively used TSYS/TS2 and Host System for Account Conditioning to

help System and Integration Testing

. Enhancing Test scripts using VB Script language.

. Expert with Multiple Data bases like Oracle & SQL server

. Having Very good knowledge in TSYS

. Extensively used PL/SQL queries to interact with ORACLE database.

. Expert in planning and executing Functional Testing, Compatibility

Testing, Link Testing and Negative Testing.

. Strong working experience in Windows NT/2000/XP and UNIX environments.

. Involved in Project Planning, Coordination and Implementing various QA

methodologies

. Expert using Test Director and Quality Center for reporting bugs.

. Knowledge of quality standards like IEEE/ISO/CMM

. Proven ability to work efficiently in both independent and team work

environments.

. Expert in Web testing, Client/Server testing and Back-end Testing.

. Proven experience delivering high quality product solutions utilizing

Agile methodology best practices

Educational Qualification:

. Bachelor's Degree From Gulberga University, India

. Post Graduate Diploma in Computer Applications.

Technical Skills:

Languages :JAVA, C, COBOL, CICS, TSL, JCL, PL/SQL, VB, XML, PERL Shell

scripting and Apache ANT 1.6.2.x.

Operating System :Windows 95/98/NT/2000/XP, UNIX, Linux and MVS/ESA.

Internet Technologies :ASP, HTML, JavaScript and VB-Script

RDBMS :MS SQL Server 7, DB2 and Oracle

Tools :Merant Tracker 8.0,SSH Secure Shell 3.1, Putty

Configuration Tool r 0.58,Visual Source Safe, VB

6.0,ClearQuest, Dream Weaver, ISIS Draw, ChemDraw Pro, MS

Office 97/2K/2002 and VISIO.

Graphic User Interface :Ms FrontPage 97, Visual Interdev and VB6.0

ETL Tools : Informatica Power Center 8.5/8.1/7.1, Business Objects

and Power exchange

Data ware Housing :Brio Report builder, Query Designer, Brio

Technologies and EIS

Web Application Server :IIS, Apache, iPlanet, Web logic, Web sphere,

Sunone.

Testing tools :WinRunner, LoadRunner, SiteScope, Quick Test Pro and

Test Director. Quality Center

Sr. QA Engineer, Capital One Financial, Richmond, VA Nov '05 -

Present

Project 1: PSIT is a group that supports the implementation of the helix

program. As a part of PSIT I am involving in testing the implementation of

the helix statements and letters. The objective of this testing is to

verify and validate the new functionality incorporated for helix.

Project 2: ProphIT is a contact center workflow based system, which

facilitates agents of contact center in accessing the credit card account

details stored in TS2 system. The various users of this system could be

customer service, collections, and fraud agents. Depending on access

privileges agents of contact centers can access various account information

and workflows. ProphIT has a web browser and is also integrated with VRU

and OAS net banking platform, in the front end. ProphIT is fully integrated

with TS2 in the back end and also with other OTS and decision-making

systems through various interfaces.

Project 3: In the current environment, Deposit Statements (account

statements for Checking, Interest Checking, Rewards Checking, Money Market

Demand Deposit, Savings, Certificate of Deposit, and Individual Retirement

Accounts) are composed on the Fidelity Host System and sent to an external

vendor, FDR (First Data Resources), for rendering. There are different

statement formats for accounts based on region, i.e., statements in the

South look different than statements in the North.

With the onset of the Chevy Chase Bank (CCB) Integration, the Consumer

business decided to create a Nationally Branded Deposit Statement that

would meet the needs of all Capital One branch accounts, North, South and

eventually the integrated CCB. Creating a new, dynamic statement template

on the Fidelity Host seemed to be inordinately difficult, so the decision

was made to "rehost" the Deposit Statement composition and archiving

process to the Capital One platform (currently used for Credit Card and

National Direct Bank statements). Commercial and Small Business statements

were subsequently added to the scope, further to take advantage of the

National Branding initiative.

Responsibilities:

. Participated in business requirement, design walk through and analyzed

business requirements.

. Developed the test plan and was involved in the preparation of Test

schedule.

. Developed the test environment, based on the design documents and

collecting the information from developers.

. Performed risk analysis to determine the focus of the testing and

prepared Business Assurance Strategy.

. Analyzed the business, Functional and data requirements and identified

the test scenarios

. Tested the web based application which provides various financial

services like Brokerage Services (Trade Stocks), Mutual Funds (Scan

for mutual funds using criteria such as performance, risk parameters,

fees and expenses, Buy, Sell, Exchange Mutual Funds), Fixed Income

Investments, Annuities etc.

. CONA developed the application which serves the clients by providing

information about stocks, agents, analysis and trading. The services

included various modules: Analysis, client information system and

stock information system.

. Created test cases for the identified scenarios and executed.

. Assigned priorities to all the detailed business requirements in order

to prioritize the test cases

. worked on Abinitio GDE testing various graphs and also tested Abinitio

graphs deployed as shell scripts in Unix server

. Created and modified the Account Data Using TSYS for System and

integration testing.

. Provided Efforts Estimate and coordinated the test schedule using

Agile testing methodology in UAT phase.

. Creating/Executing/Troubleshooting QTP automation test scripts

generated from test cases.

. Automated ProphIT Regression test case scenarios using QuickTestPro.

. Enhanced Test scripts using VB Script language.

. Parameterized test scripts for Data Driven testing in Quick Test Pro.

. Generated test data using Capital One Test data generator.

. Created and modified the Bank Account Data Using HOST System for

system and integration testing.

. Prepared pre-conditioned data for negative and positive testing of the

applications.

. Participated in internal review and walkthroughs of test cases and

procedures

. Involving in manual testing of MVS Mainframe application.

. Testing of letters application in UNIX environment.

. Extensive backend testing using UNIX Scripts and SQL quires to

validate and ensure data integrity.

. Execution of Shell scripts to run data files for generating the

required AFP file.

. Using test director as a test management tool for creation and

execution of test cases and mapping the test cases to the

requirements.

. Using Clear Quest as a defect tracking tool. Categorized bugs based on

the severity and interacted with developers to resolve issues.

. Performed Functional, regression, system, Integration, end to end

testing and User Acceptance Testing ( UAT)

. Prepared weekly status report to track the progress of the project and

participated in meeting and discussions related to issues.

Environment: AIX UNIX 5.1, Quality Center 10.00/ 9.0, Test Director 8.0,

Clear Quest 6.14, Test data generator, SQL, Toad, Java, JSP, HTML, MS

Excel, QTP, TSYS, HOST system

Sr. QA Engineer, MedPlus Inc. Mason, OH.

May '05 - Nov 2005

As a Care360 solution, the eMaxx Physician Portal is a modular, practical,

and affordable patient-centric electronic health record that grows with the

needs of your practice. The eMaxx Physician Portal includes modules that

enable physicians and their staff to order diagnostic tests and review

laboratory results online, prescribes medications electronically, verify

patient demographic information, and file documents received electronically

or in hard copy into a patient-centric health record that may be securely

shared with other clinicians.

eMaxx collects clinical data from a wide variety of sources and delivers it

to providers at the point of care. The result: greater efficiency, more

time with patients and overall superior care.

Responsibilities:

. Created LoadRunner Scenarios and Scheduled the Virtual user to

generate realistic load on the server using LoadRunner.

. Created and implemented performance tests using Mercury Interactive

LoadRunner.

. Involved in developing the test strategy, build the test client and

test environment.

. Enhancing the scripts using Generator and performed Parameterization

and Correlation to meet the requirements.

. Written Test Plan, Test Scenarios, Test Matrix to follow the IEEE, CMM

2 Level standards.

. Involving in reporting the system defects using Merant Tracker 8.0

. Involved in various testing types like GUI testing, User acceptance

testing, Integration testing, Navigation testing and Regression

testing on the application

. Extensively used Test Director for test planning, maintain test cases

and test scripts for test execution.

. As a QA analyst carried out testing, to check whether the application

is functioning as per the design documentation and functional

requirements.

. Involved in performing load and stress test on the application and

server by configuring Loadrunner to simulate hundreds of virtual users

and provided key metrics to the management.

. Configured and Using SiteScope Performance Monitor to monitor and

analyze the performance of the server by generating various reports

for CPU utilization, Memory Usage etc.

. Conducted all tests in the Controller by creating 100, 200, 400

virtual users for load,

Stress and Steady state test respectively

. Involved in conducting stress test and volume test against the

application using LoadRunner.

. Participating in developing Documents like Test Strategy Document,

Down Time Document, and Test Status Document.

. Extensively used SQL Queries for interacting with the SQL Server

database.

. Extensively wrote SQL Query to extract data from various database

tables for testing purpose.

. Involved in creating Requirements Traceability Matrix for CMMI Audit.

. Ran UNIX Shell scripts to see the output

. Used Test Director to invoke the scripts and initially performed the

baseline testing and organized all the scripts systematically and

generated reports.

. Extensively involved in performing the Backend testing of the

application to be developed and executed various SQL queries to

perform the validity of the data.

. Managed developing source code using PVCS and database management

using Toad tool.

Environment: LoadRunner, Manual Testing, Test Director, SiteScope, HTML,

J2EE, Merant Tracker 8.0, IE 6.0 and UNIX/Windows 2000.

ETL Tester, Hilti International, OK.

Jul '04 - Apr '05

The Hilti Group is a world leader in Developing, Manufacturing and

Marketing Added-value, top-quality products for professional customers in

the Construction Industry and building maintenance.

Responsibilities:

. Analyzed business requirements and module-specific functionalities to

identify test requirements and formulate an effective master test

plan.

. Setup Procedures to Extract, Transform and Load (ETL) data from

Operational and Legacy Systems to

. the data Warehouse by Using Informatica.

. Performed extensive manual testing on critical functionalities of the

application.

. Used ETL to extract and load data from different databases such as

Oracle, SQL Server and flat files and loaded them in to Oracle.

. Design and Development of QA documentation like Test Cases and Test

scenarios from business and functional requirements.

. Ran all the UNIX scripts, ETL Workflows, BO reports and PL/SQL

Packages as part of Regression testing.

. Used Mercury Quality Center 9.0 for Test Planning, Test Designing,

Test Analysis, Test Execution, Defect Tracking and Test Result

. Reduced the complexity out of complex data integration scenarios by

using predefined wizards and templates in Power Center 8.5.

. Used the enhanced testing and monitoring tools in Power Center 8.5 to

monitor the data integration and data quality services.

. Extensive querying using TOAD to run SQL queries and monitor quality &

integrity of data.

. Actively participated in creating requirements Traceability matrices

and Test plans

. Worked on Power Center client tools like Source Analyzer, Warehouse

Designer, Mapping designer, Mapplet Designer and Transformations

Developer

. Performed Unit and functional testing for all the Mappings and

Sessions.

. Implemented automated Processes & scheduling using Autosys. Created

Autosys Scripts for installing

. Autosys Jobs for peculiar scheduling & alerting scenarios.

Environment: Quality center 9.1, Oracle 11i, SQL server, Informatica Power

Center 8.5/8.1, PL/SQL, Autosys, Toad and UNIX.

Test Engineer,

Impact Informatics Solutions & Consultancy Pvt. Ltd, HYD, India Mar '02

- Jun 04

The Product is developed for a Company called Knowledge Alive, which deals

with online Corporate Training. The product is developed using server-side

component architecture in Enterprise Java Beans (EJB). There are two

versions of this application, the ETMS (Enterprise Training Management

System), for the corporate learning, (a) an installed stand-alone product,

and (b) a version for ASP*(Application Service Provider) environment. The

ETMS will provide training for different organizations based on their

nature of work.

The features in the product are Role management, workflow management,

course & certification management, currency, time zone, user account,

budgeting and training management. The site Administrator creates an

enterprise and the relationship between enterprises. At the enterprise

level the enterprise administrator himself models the whole structure of

the enterprise. The reporting hierarchy, Workflow, Internationalization,

Currency etc all will be defined at the enterprise level. The training

module of the site facilitates the planning, implementation, reporting and

tracking of Training. Budgets and grants are allocated for the business

entity for training purpose and also automate the training procedures. The

certification will be given for a specified training based on competency

level. In Role and workflow management, the user is assigned to a

particular role. If any user opts for a training course, the superior of

that business entity should approve it.

Responsibilities:

. Designing of testing standards.

. Developing Test Cases.

. Involving Functional Testing, Integration Testing, System Testing,

Regression Testing and Load and Stress Testing

. Functional testing is done using the WinRunner.

. Analysis of Test Reports and Graphs.

Environment: Windows NT, WinRunner, LoadRunner, Java, Oracle and SQL

Server 7.0/2000

Software Consultant, Raynolds Software Solutions, Hyd - India Apr '01

- Feb '02

This is a Data Ware housing application to generate MIS and Data Analysis

Reports using BRIO OLAP tool. Duncan InfoTech already had the OLTP

application running on Oracle Financials R11 Applications Suite and HRMS

application using ASP & SQL Server. The implementation of this project is

planned in three stages.

. Building of MIS Reports using Developer 2000 and PL-SQL Procedure

. Building the Data Warehouse and ECTL components and using BRIO OLAP to

generate Analysis. The ECTL components extract Data from the Oracle

Financial Database Tables.

. Concentrate in extracting data from the HRMS application and

generating integrated Analysis reports using BRIO. Currently in

implementation stage

Responsibilities:

. Developing application and Developing Test Cases.

. As a Test Engineer carried out testing, to check whether the

application is functioning as per the design documentation and

functional requirements

. Performed Acceptance, Unit, Integration and Cross-Platform testing of

various complex applications

. Extensively involved in performing the Backend testing of the

application to developed and executed various SQL queries, PL/SQL

procedures and triggers to perform the validity of the data

. Used MS-Word to export all test Procedures and Test cases in Test

Director.

. Involving Functional Testing, System Testing, Regression Testing and

Load and Stress Testing

Environment: Windows NT, Brio report builder, Brio Query Designer and Ms

SQL Server

Software Consultant, Raynolds Software Solutions, Hyd - India June '00 -

Mar '01

The purpose of the HRMS system is to automate the Employees Information.

The System starts with login screen as attendance is based on the logging

of HRMS system, based on the login id, the user gets different screen's for

HR User's, Project managers and general Employee's. User's of the Different

Heads will have Different security Features. This system allows for

Attendance, Apply of Leaves, Time sheet Calculation, etc

Responsibilities:

. Prepared Test Plan and Test Cases.

. Created test scripts and modified them in accordance with the testing

needs.

. Involved in various testing types like GUI testing, User acceptance

testing, Integration testing, Navigation testing and Regression

testing on the application.

. Checked Stored Procedures and different functions of the database.

. Tested eServices application.

. Providing test estimates, schedules and Run Plan for Test Cases.

. Creation of the Quality Assurance and Test Strategy document that

describes the technical and management approach to be followed for

testing of the entire project.

. Performed post-test analysis and assessment.

. Developed automated scripts using WinRunner for regression testing.

. Extensive usage of SQL queries for validating the Oracle database

results.

. Recorded the bugs and reported using PVCS bug-tracking tool.

. Use SQL & PL/SQL to test backend functionality and Worked with UNIX

shell scripts.

. Participated in Bug reporting using ClearQuest and participated in bug

reviews.

. Checked the navigation and the links of the entire application.

. Attended periodical meeting with developers to resolve technical

issues and investigated

. Create and maintain detailed test logs checklists and weekly status

reports

. Developed Test Summary Reports and participated in GO / NO-GO

meetings.

Environment: Windows NT, ASP, VBScript, JavaScript and Ms SQL Server

Software Consultant, Raynolds Software Solutions, Hyd - India Dec '99 - May

'00

Developed a sophisticated and highly secure corporate Intranet as a

repository of all company-related information (projects, company policies,

employee profiles, HR activities, inventory administration, and company's

newsletters). This is totally intranet application.

Responsibilities:

. Testing activities includes Functional, GUI and Regression testing of

the application.

. Generation and documentation of test cases from functional

requirements and design documents.

. Reporting to Test lead and a daily basis on the new bugs filed, status

of old bugs and follow up the developers.

. Participated and contributed to Test plan meetings, Defect prevention

meetings and Roots cause meetings.

. Writing of test plans and test cases with the help of Software

Requirement Specification Document.

. Worked closely with the Business Analysts, Systems Analysts,

Developers, and DBAs to solve the issues identified during the testing

process in a timely manner.

. Performed Integration, System tests and Customer acceptance testing.

Created new tests based on the review of the customer in the

acceptance test phase.

. Coordinated and controlled testing projects at every step of the

quality cycle from test planning through execution to defect

management.

. Defining and performing the Test strategies and associated scripts for

the verification and validation of the application and ensuring that

it meets all defined business requirements and associated

functionality.

. Performed manual tests in cases the functionality was not covered in

the automated test suits.

. Reviewed test plans to ensure they meet testing requirements and

analyzed test scripts so they meet script completion criteria.

Environment: Windows NT, ASP, VBScript, JavaScript and Ms SQL Server.

Contact this candidate