Quality Assurance Sql Server

Surender Koorathota

407-***-**** / *********@*******.***

SUMMARY

Over twelve years of experience in Quality Assurance Testing and Software Development. Around 7 years of professional experience as Quality Assurance and Automated/Manual Tester using Quick Test Pro/WinRunner/ Quality Center/ TestDirector/Load Runner for testing Client Server, Web and Mainframe applications. Involved in all phases of System development and Testing life cycle. Have good analytical, problem solving, communication and interpersonal skills.

TECHNICAL SUMMARY

SOFTWARE/TOOLS: WinRunner, Quick Test Pro, Quality Center, Test Director, Load Runner, Bugzilla, Starteam, ClearQuest, ClearCase, Caliber, Borg, Xpeditor

LANGUAGES: Delphi, C, Visual C++, Visual Basic, JAVA, JSP, Servlets, XML, Microsoft Visual Studio, HTML, Cobol, SQL, CICS, PVCS, Visual Source Safe, JCL, VSAM

RDBMS: DB2, IMS DB/DC, MS SQL Server, Oracle

O/S: Windows NT/XP/2000/98/95, UNIX, IBM 3090/ES 9000 and AS400

APPLICATIONS: MS Word, Excel, Power Point, IE, Mozilla, Safari

PRACTICES: Actively participated in SQA Practices and working towards Certified Software Quality Analyst (CSQA) exam.

EMPLOYMENT HISTORY

Progress Energy, St. Petersburg, FL 08/11 to Till Date

Veredus Corporation, Orlando, FL 01/10 to 07/11

Bonnier Corporation, Orlando, FL 01/08 to 12/09

Davita HealthCare Inc, Deland, FL 12/05 to 12/07

Tek Systems, Orlando, FL 08/05 to 11/05

Korbis Group Solutions Inc, Miami Lakes, FL 09/04 to 04/05

Covansys Corporation, Columbus, OH 07/98 to 06/04

Hindustan Computers Limited, New Delhi (India.) 02/96 to 06/98

VISA STATUS:

US Citizenship

EDUCATION:

Bachelors Degree in Engineering

Post Graduate Diploma in Systems Management

PROFESSIONAL EXPERIENCE

PROJECT SUMMARY:

Progress Energy, St. Petersburg, FL

08/11 to Till Date

Senior Test Analyst

Progress Energy headquartered in Raleigh, N.C., is a Fortune 500 energy company with about 22,000 megawatts of generation capacity and approximately $10 billion in annual revenues. Progress Energy includes two major electric utilities that serve about 3.1 million customers in the Carolinas and Florida.

Working on their DSDR-DSCADA enhancement project.

The DSCADA implementation will install the Telvent OASyS DSCADA system in Florida. This includes the separation of the DCC control environment, from the existing ECC Areva EMS. The project is required to support the installation of DSDR which will reduce peak demand and maintain consistent voltage to all customers served by the feeder, without increasing peak generation capacity.

Responsibilities:

Experience mainly includes manual testing of the software applications.

Reviewing functional requirements and requirements tracking matrix.

Extensively involving in writing the Testcases using Quality Center.

Breaking the Big Requirements into Little Requirements which are convenient for writing

Testcases.

Capturing the Requirements in Caliber. Integrated Caliber and Quality Center.

Carrying Requirements based testing by tracing back the test results in Caliber.

Involve in writing and verifying defects that accurately reflect any problems or errors

encountered while testing using bug tracking tool Quality Center.

Involved in back-end database testing (MSSQL, Oracle).

Actively Participating in the team meetings to discuss the issues arising out of testing.

Environment/Tools: Quality Center 10.0, Caliber 9.0, .Net, Java, C, Oracle, MS SQL Server 7.0, Developer 2000, JDBC.

Veredus Corporation, Orlando

Walt Disney World, Orlando, FL

01/2010 – 07/2011

Senior Software QA Analyst

Walt Disney World Resort is the most visited and largest recreational resort in the world, containing four theme parks; two water parks; twenty-three themed hotels; and numerous shopping, dining, entertainment and recreation venues.

Walt Disney World Resort need the ability to create and update individual Character ‘appearance’ times and distribute the information to multiple systems.

The business is looking for a quick, easy to use interface that will allow for template definition, immediate updates, including addition of character appearances, removal of character appearances, and the changing of appearance times.

The business also needs the ability to display the information to Guests and Cast Members.

My Role as the Senior Quality Assurance Analyst involved mainly in Manual and Automated Testing of the software applications.

Accomplishments:

Testing responsibilities include Requirements Gathering, Test Planning and Test

Preparation.

Involve in all stages of testing process-Performing Functional testing, Regression Testing, System Testing & Integration Testing of the applications.

Involve in writing and verifying defects that accurately reflect any problems or errors

Encountered while testing using bug tracking tool Quality Center.

Involved in back-end database testing (MSSQL, Oracle).

Participate in the team meetings to discuss the issues arising out of testing.

Creation of test plans, test cases and multi browser testing.

Environment/Tools: C, Java, JSP, HTML, Oracle8i, Quality Center 9.2, XML,

Windows (NT, XP, 2000), MS SQL Server 2000, IE, Firefox Mozilla, Safari.

Bonnier Corporation, Orlando, FL

01/2008 – 12/2009

Senior Software QA Analyst

Bonnier Corporation is one of the largest consumer publishing groups in America. Awards for their writing, design, photography and journalistic coverage. Providing participants with information, entertainment, knowledge and inspiration through appropriate interactive media. The company produces quality custom publications, television, websites, events and marketing programs in all of its market. Currently the company is mainly focusing on websites development instead of printing the magazines.

Responsibilities:

Experience mainly includes manual testing of the websites and applications.

Created test plans, test scenarios, test cases and multi browser testing.

Reviewed functional requirements and requirements tracking matrix.

Identified defects and entering them into bug tracking tool Quality Center.

Performed the back-end testing of the Databases using SQL statements.

Reported QA team status to executives.

Participated in the team meetings to discuss the issues arising out of testing.

Developed Stress Test Plan

Measured response times for various critical business transactions using Performance/Load

Testing Tool

Environment/Tools: Java, JSP, Servlets, HTML, Oracle, Quality Center 9.0, Load Runner 9.0,

Windows (NT, XP, 2000), Bugzilla, Linux, MS SQL Server 2000, IE, Firefox Mozilla, Safari.

Davita HealthCare Inc, Deland, FL

12/2005 –12/2007

Senior Software QA Analyst

Davita provides dialysis services for those diagnosed with chronic kidney failure, serving nearly 1,52,000 patients in 40 states from over 1011 outpatient dialysis centers that currently operate. Davita also provides acute inpatient dialysis services in over 1400 hospitals across the country.

Accomplishments:

Performed Integration testing and System testing. Integration tests focus on functionality and regression testing. System testing includes performance, stress, operability, usability and installation testing.

Involved testing the applications (Snappy, Duck) manually as well as using automated

testing tools(Quick Test Pro and Quality Center) in establishing the standard test suite of scripts for User Interface, Business Rules, Database objects in automating and maintaining the testing suite.

Involved in writing and verifying defect reports that accurately reflect any problems or errors

encountered while testing.

Involved in back-end database testing (MSSQL, Oracle).

Extensively used Configuration Management tool Starteam for tasks assigned and closing them after verifying.

Environment/Tools: Delphi (Object Oriented), WinRunner 8.0, Quick Test Pro 9.5, Quality Center 9.0, Test Director 9.0, MS SQL Server, Oracle, Starteam, Windows NT, MS Access, NetMeeting.

Tek Systems, Orlando, FL

Siemens Westinghouse Power Corporation, Orlando, FL

08/2005 – 11/2005

Software QA Analyst

Siemens Power Corporation is one of the world's leading specialists in planning, construction and upgrades of power plants; development, production and supply of components and systems. Worked on their CSTS project. SWPC Component Serialization & Traceability System (CSTS) facilitates a means of creating, recording, and storing information on critical turbine components which are traceable. Involved mainly in Web testing of the application and to see the expected results are achieved. Also to verify the quality standards are met during all stages of parts creation, assembling and shipping.

Accomplishments:

Testing responsibilities include Requirements Gathering, Test Planning, Test Preparation

Test Execution and Test Results interpretation

Developed Test Scripts, Test Cases for CSTS with the help of WinRunner 7.5.

Manual and automated execution of Test cases/Test scripts. Comparison of Actual Results with Expected Results.

Built an inventory of automated test scripts through WinRunner 7.5. The scripts are made to be very robust, as they can handle both positive and negative input data

Extensively used Quality Center for Defect Tracking.

Environment/Tools: WinRunner 7.5, Quality Center 8.0, Oracle, Java, ASP, MS Access, MS SQL Server 7.0, MSVC++, PVCS, IDL, DCOM, NetMeeting.

Korbis Group Solutions, Inc

Wildcard Systems, Orlando, FL

09/2004 – 04/2005

Test Engineer

WildCard Systems is a technology leader for electronic host based stored-value cards, virtual stored-value accounts, and Internet payment. Its many applications include payroll products, gift card products, travel products, insurance products, membership products, student products, and incentive/promotion products.

My Role as the Quality Engineer involved mainly in Manual Testing. The testing areas include the proprietary web-enabled services CardWiz and MyAccount applications for Payroll and Travel products. Testing the websites in the QA, Production environments validating the customer for the personal and transactional information. Mainly working to see all the expected design requirements of the web sites are met. Defect Tracking was taken care by using Clear Quest tool.

Environment

• Microsoft .net technologies to wrap new and legacy components in a web services framework for internal and external consumption.

• SQL 2000 database

• Borg Tools and PERL Reporting(Data Files)

• 2 production data centers

• Redundant and diverse Visa and MasterCard connectivity

• Regular security scanning and firewall review schedule and policy

Covansys Corporation

VERIZON Communications Bedminster, NJ

09/2002 – 06/2004

SQA Consultant

Verizon Wireless is the nation's leading provider of wireless communications. The company has the largest nationwide wireless voice and data network and 32.5 million customers. Verizon was developing a Global Base Solution (GBS). GBS was a client/server application based on Oracle8. Front-end application is developed with Oracle Developer 2000. It interfaces with a web application. Involved with all phases of Testing life cycle for additional new Features.

Accomplishments:

Developed Test Scenarios, Test Cases for GBS with the help of Test Director 7.0

Manual and automated execution of test cases/test scripts thru Test Director. Comparison of

Actual Results with Expected Results.

Built an inventory of automated test scripts thru WinRunner 7.0. Customized the

automated test scripts to conduct unit testing, regression and system testing.

The scripts are made to be very robust, as they can handle both positive and negative data.

Lent technical support to team members in the use of Mercury Tools.

Worked as TestDirector Administrator overseeing the defect management, test plans,

integrating tests across the modules to build test sets.

Worked with Configuration Management and Change Control.

Environment/Tools: WinRunner 7.0, TestDirector 7.0, Caliber, ClearCase, ClearQuest, Rational Robot, Visual Source Safe, Oracle, Java, UNIX, MS SQL Server 7.0, Developer 2000, JDBC.

Mettler ReactIR (ASI) Mettler Corp Columbus, Ohio

05/2000 – 08/2002

Quality Assurance Analyst

To develop a next generation software application for ASI’s ReactIR project and testing the software. Covansys was given the responsibility of developing and testing an Infra Red Scientific application for Mettler Toledo. The Scientific application is developed using MSVC++, IDL and DCOM. It consists of Spectroscopy, Experiments, Reactions etc.

Accomplishments:

Testing responsibilities include Requirements Gathering, Test Planning, Test Preparation, Test Execution and Test Results interpretation.

Used Test Director for Test Planning, execution of scripts developed in WinRunner, analyze the test results and tracking the defects from the results.

Bugs-tracked and reported through TestDirector and Managed entire Testing Process.

Manual and automated execution of test cases/test scripts through Test Director. Comparison of Actual Results with Expected Results.

• Captured the Requirements in Caliber. Integrated Caliber, TestDirector and WinRunner.

Carried Requirements based testing by tracing back the test results in Caliber.

• Built an inventory of automated test scripts through WinRunner 6.0. The scripts are made to

be very robust, as they can handle both positive and negative input data.

Environment/Tools: WinRunner 6.0, TestDirector 6.0, Caliber, MS Access, MS SQL Server 7.0, MSVC++, PVCS, IDL, DCOM, Microsoft Visual Studio, PC Any Where, PC Pentium

Ohio Public Employees Retirement System (PERS) Columbus, Ohio

09/1999 – 04/2000

Programmer/Analyst

The PERS Savings System Rewrite project is being implemented in a phased approach with the first two phases already completed. The purpose of the phase III Savings System Project is to re-host the mainframe and PC-based subsystems that supports functions within the Savings System business scope from the current PL/1, RPG, IMS to COBOL, DB2.

As the member of the Business Support team, which is a Savings System’s subsystem, worked primarily on business support functions that touch member and employer processes. Mainly involved with the analysis of the current system, wrote code specs, and coded and tested to completion portions of a complete subsystem.

Accomplishments:

Analysis, Design and coding of new applications to keep track of Employer contributions and member benefits

Analysis, modifying existing applications to run in the post conversion environment

QA Testing of new applications

Environment/Tools: COBOL, CICS, DB2, JCL, XPEDITOR, DESIGN1, ENDEVOR, QMF, SPUFI, IBM 3090, IBM ES/9000, IMS, AS400

Fred Meyer Inc., Portland, Oregon

09/1998 – 08/1999

Programmer

Fred Meyer Inc. is one of the largest food and drug retailers in the U.S. The company's five subsidiaries -- Fred Meyer, QFC, Ralph's, Smith's and Fry's-- operate 781 stores in a variety of Food and drug and multi department formats located in 12 western states from Alaska to Texas. The purpose of this project was to merge all Smith's, Ralph's, Fry's and QFC systems to run in Fred Meyer environment and maintain all Food applications.

Accomplishments:

Maintenance of the Food Production Support System

Analysis, design, and coding new applications required for merger related activities

Analysis, modifying existing applications to run in the post merger environment

Testing new applications for Quality Assurance

Environment/Tools: COBOL, CICS, DB2, JCL, XPEDITOR, FILE-AID, PLATINUM, QMF, IBM 3090, IBM ES/9000, IMS

Hindustan Computers Limited New Delhi India

02/1996 – 06/1998

Software Engineer

Developed Corporate Maintenance (CM) product for American Stores Company through

British American Consulting Group (BACG). Contribution includes Analysis, Design, Development, System Testing, QA and Documentation.

Worked on an application for Myer Grace Inc., Australia. Tested the application system for Y2K compliance. Analyzed and converted the application system for Y2K compliance.

Worked on designing, developing and testing different custom applications for domestic clients. Some of the applications include Insurance, Order Entry/Inventory management, Sales Coordination/Movement System, Payroll / Accounting etc.

Environment/Tools: COBOL, CICS, DB2, JCL, XPED, DB2GE, MAPGEN, EASY-EXPLAIN, FILE AID, IMS, COB TEST, IBM 3090, IBM ES/9000, AS400.

Contact this candidate