Post Job Free

Resume

Sign in

Sql Server Testing

Location:
Chicago, IL, 60656
Salary:
70000
Posted:
July 20, 2010

Contact this candidate

Resume:

Kumar Setty

Senior QA Analyst

E-mail: i7wc5y@r.postjobfree.com

Phone: (R) : 520-***-****

Career Summary

Over 7 years of experience as a Software QA Tester/ Analyst/ Engineer in Manual and Automated testing of Web and client-server applications and 2 years of experience in .NET development. Have strong abilities in software testing involving setting up of test environment, creation of test scripts / cases, execution of GUI, functional, regression, smoke, system, integration tests and tracking of defects using various tools. Self motivated, dedicated, eager to learn and grow. Have great team building skills, excellent problem solving skills, great analytical and organizational skills, strong oral and written communication skills, Excellent experience with a Software Development Life Cycle, ability to work independently and as part of a team, ability to handle multiple assignments, excellent customer interfacing experience and strong background in Financial, Insurance.

WORK EXPERIENCE SUMMARY:

 Over 7 years of diverse experience in Information Technology with emphasis on Quality Assurance, design and development of client server and web applications.

 Extensive Knowledge of Quality Assurance methodologies and strategies with good understanding of Software Development Life Cycle (SDLC).

 Worked in various data integration projects and helped to automate them as appropriate

 Expertise in Software integration testing and User Acceptance Testing phases of SDLC.

 Proficient in using Automated Testing tools such as QuickTestPro, TestPartner, Selenium, LISA, QALoad, WinRunner, Load Runner, Mercury Quality Center / Test Director.

 Expertise in documenting and executing Test Plan, Test Strategy and Test cases for Manual and Automated testing.

 Proficiency in Excel reporting, formulas and pivot tables.

 Proficiency in Developing, Designing, Reviewing, Executing, and Preparing Test cases.

 Performed Smoke, Integration, System, Functionality and Regression Testing.

 Proficient in Load testing with automated tools like QA Load

 Very good expertise in User Acceptance Testing of various online applications

 Experience in documenting Defects with high level of detail, accuracy and informative recreation steps.

 Experience in software Verification, Validation and testing methodology.

 Experience with testing on Windows, Unix.

 Developing Bug reports, Build Certification and test data preparation.

 Expertise in writing SQL queries to fetch test data from RDBMS such as Oracle and SQL Server.

 Testing on various browsers like Internet Explorer, Netscape and Mozilla.

 Solid in communicating at all levels of management with experience in coordinating various client meetings, seminars, presentations and group discussions.

 Ability to work in-groups as well as independently with minimum supervision and initiative to learn new technologies and tools quickly.

 Efficient team player with excellent communication skills and good interaction with users.

EDUCATION:

Bachelor of Engineering in Electrical, JNTU, India

TECHNICAL SUMMARY:

Databases Oracle 10g/ 7.3.4/ 6.0, DB2, SQL Server, MySQL

QA Tools Selenium, TestPartner, LISA, Bugzilla, QALoad , QTP, Mercury Test Director, Quality Center, WinRunner, Load Runner

ENVIRONMENT/PLATFORMS Windows 1998/2000/XP/NT,UNIX, Mainframe

Programming .NET, Java, C, C++, SQL, PL/SQL, Visual Basic and HTML

Other Tools WinSQL, Informatica 7.1, Toad, Visio, Microsoft Office, JCL, XML, Squirrel SQL, BD Visualizer, Win SCP, Putty, SVN, Hudson, Team foundation server, SVN, Rational Clear Quest, Rational Clear case.

PROFESSIONAL EXPERIENCE:

Client: Fiserv Oct’09-Till Date

Project: XP Systems – Investor Processing

Role: Senior QA Analyst

XP Systems is part of Fiserv now. Investor processing is entirely designed using legacy i.e. using assembly language. The project is aimed at enhancing the current application along with migration to .net framework. Real estate loans granted by credit unions to the borrowers are sold under some predefined contracts. These contracts have lot of parameters related to yield, servicing fee, mortgage margin, commitment amount etc. The existing system supports only fixed loans as ARM loans are in place now-a-days they were also introduced in the new system. We followed the agile methodology for deliverables.

Responsibilities:

• Prepared Test plan and Test Approach Documents.

• Debugged and Modified the testing tools as per functionality change.

• Prepared various Post migration testing documents and used to perform all the post migration and also various system level testing.

• Prepared detailed testing documentation covering testing strategy, traceability matrix, test plans with test cases and results and various reports on defects.

• Developed a traceability matrix from the requirements.

• Participated in various meetings with users to get the business requirements.

• Logged, tracked and verified the defects using Clear Quest and followed up with development team.

• Created a plan and developed a testing process for the integration project.

• Involved in running and verifying the backend processes.

• Used to analyse User stories to understand the system and Objectives of Agile Testing.

• Used Rational query analyzer to write DB2 queries to check the data loads, updates in the backend databases.

• Created QTP test scripts for testing system functionality.

• Developed and generated test cases covering negative testing, database testing, UI testing and backend processes.

• Created scripts to load the more volumes of data into databases for load and performance testing using Loadrunner.

• Conducted reviews and lessons learnt meetings for continuous improvement of the process

• Involved in creating the field level mapping document for the data integration/migration projects.

• Helped in developing and creating testing standards and standard testing documents

• Performed User Acceptance Testing(UAT) and maintained the required documentation.

• Involved in decision making with regards to identifying and prioritizing high impact improvements through the analysis of current processes.

Environments: Microsoft Visual Studio 2008, DB2, Rational Clear Case, Rational Clear Quest, Microsoft Visio, QTP, Loadrunner, QTODBC.

Client: Microsoft, Redmond Jan’08 – Sep’09

Project: Wiki Open Source (www.docmentinteropinitiative.org)

Role: Senior QA Analyst

Wiki open source is a site initiated by Microsoft to enable the interoperability of office related documents. It includes the specifications from ECMA, ODF that are needed to be followed to develop interoperable office applications. Notes are implemented for various sections of the specification; Forums and RSS feeds are included to enhance the user experience. Users for the site includes Admin who administers the whole site with major functions like uploading spec and notes, Moderator and Office Moderator maintain the site especially forums, Implementer implements the notes to various sections of the specifications apart from participating in forums with Contributor.

Responsibilities:

• Involved in testing of online application developed in .NET.

• Extensively involved in testing the interfaces with different browsers.

• Responsible for Test Planning, Designing Tests and Execution of the test cases in different test cycles.

• Analyzed the applications and created the test data required for functional testing and regression testing.

• Performed extensive data validations and error checking on online credit card applications

• Performed regression testing with automated test scripts and manual validations

• Executed Functional Test Cases and Regression Test Scripts on different staging environments for each Build/Release with Selenium, Microsoft test framework.

• Performed repeat load tests with varied system configurations to achieve optimum performance.

• Designed and created various load testing scenarios to control the conditions for the test and created the virtual users to simulate the load, initiated and monitored test and reported the results by using load tests of Microsoft test framework.

• Executing and monitoring the scripts and analyzing test results using QALoad Analyze and reporting the results.

• Interact with Business users to gather Business Test scenarios, to confirm any discrepancy between the requirement and the development.

• Performed Load and stress testing using QALoad.

• Involved in batch application testing for Data feeds and File feeds for various partner’s systems.

• Performed regression testing for new builds.

• Extensively used SQL and PL/SQL to retrieve the data from databases to perform data validations and comparisons for regression testing.

Environments: Visual Studio Team System 2008, SQL Server 2008, Umbraco, Ms Excel, Ms Word, Ms Visio, XML, UNIX, Webservices, Microsoft test framework, Team foundation server.

Client: Microsoft, Redmond Sep’07 – Mar’08

Project: HCCB

Role: Senior QA Analyst

The project is mainly developed using SQL Server, Asp.Net, Ajax and WLID. The aim of this project is to provide brows-able interface to the Advertisers, marketers or information provider who will visit the Microsoft site to register their details such as company information and account/billing information they wish to use for their campaigns. They will then be able to register each entity they wish to tag with interactive web based content by specifying an endpoint URL and receive a barcode which they can then integrate into their print material whether it be advertising/packaging/etc, they will also choose what pricing model they wish to use.

 Involve in the meetings with Business Analysts, Technical Architects, SMEs and Technical Designers for the understanding of the requirements and the design decisions

 Responsible for Test Planning, Environment Setup, Designing Tests and Execution of the test cases in different test cycles.

 Prepared System Test Strategy, UAT Test Plan, Test Procedures, Traceability matrix, Unit Test cases based on project Requirements.

 Development of system test plan which included scope, objective, approach, resources, timelines etc of the testing effort

 Peer review of the documents like Test Plan and Test Scripts developed by the team.

 Reviewed the final test report to make sure that all the requirements in the Traceability Matrix has been tested.

 Involved in the Requirements gathering and having day to day meetings with business users.

 Co-ordinate with Business Users and Technical team for the smooth process of UAT (Includes coordination for test data, Bug reporting and tracking, conducting the daily status meeting on the testing).

 Involved in analyzing System specifications, design, development and execution of Test Cases for Manual Testing and Automated testing.

 Verified performance testing of the application using Load tests of Microsoft test framework.

 Created scripts so that all the unit test cases as well as GUI tests are performed soon after the check in by the developer to ensure that existing functionality doesn’t break.

 Performed cross Browser testing to ensure compatibility of the application on IE and Netscape (Testing of different versions of Browsers).

 Retesting and Regression Testing after fixing the problems.

 Extensively used Quality Center for Bug Tracking.

 Worked extensively with PL/SQL to pull data from ETL tool Informatica for testing.

 Reported, stored, and maintained Defect Reports within Quality Center Defects Tracking.

 Developed test scripts and scenarios using QTP.

 Performed Data driven tests using QTP.

 Used different validation check points in test scripts using QTP.

 Created Action template and customized the Actions using QuickTest Pro. Created Regular Actions and Reusable Actions and called the Reusable Actions by another Action.

 Updating the test cases using TFS which acted as repository.

 Performed Functionality testing, Smoke and Regression testing, Upgrade, Integration testing, GUI testing.

 Logging, tracking and generating Bug status reports using Team foundation server.

 Performed manual testing of various batch and online applications.

 Used SQL Queries and Excel extensively to validate the data in the relational databases.

Environment:

QTP 9.2, Quality Center, HTML, C#, Asp.Net, Ajax, SQL Server 2008, MS Excel, Windows NT, VB script, TOAD, SQL Server, Visio, Visual Studio Team System 2008, Team Foundation Server.

Client: Microsoft, Redmond Nov’06 - Aug ‘07

Project: IVA (www.interopvendoralliance.com)

Role: Senior QA and Software Analyst

Interop vendor alliance is a Microsoft initiative to create a common platform to share, discuss about the implementations of their corresponding companies. It includes various features like Labs, RSS, and Blogs. It’s about new initiatives from Microsoft in coordination with other companies, which might is a part of the lab.

Responsibilities:

• As a team member, I was involved in developing QA test plan covering functional, integration, regression and end-to-end testing.

• Analyzed court requirement documentation and prepared Test Cases, written Test scripts for various test scenarios.

• Automated test scripts, inserted verification/check points such as GUI, Text and Bitmap to perform regression tests on various builds using QTP.

• Verified the application screen for design issues as well as data population.

• Participated in system testing and integration testing.

• Tested the data loaded into the Data Mart from the Data Source.

• Posted defects on application screens, forms and reports using Quality Center.

• Interacted with functional and database people for clarifications regarding application.

• Improved flexibility of application by Parameterizing and ran the scripts for multiple sets of data by Quick Test Pro.

• Conducted Positive testing and Negative testing.

• Generated Test Metrics showing number of Test Cases executed, passed and failed.

• Extensively involved in Database testing by writing the SQL Queries Manually.

• Participated in weekly status meets giving updates on ongoing work status.

Environment: Quick Test Pro (QTP) 8.0, Test Director 8.0, Load Runner 8.0, C#, ASP.Net, MS Internet Explorer, MS Excel, Proclarity, Reporting services 2000, Team Foundation Server, Rational Purify, Rational Clear Quest, Microsoft SQL Server 2000, Microsoft DTS, Microsoft Analysis Services, Visual Studio 2005.

Client: Moodys, New Jersey Dec’05 – Oct’06

Project: RAST (Rating Application Storage and Tracking)

Role: Software Engineer

RAST (Rating Application Storage & Tracking) manages all aspects of Rating namely My Events, Create New Event, Create New Rating Application, and Preview Rating Application for Moody’s Investors Service .This System addresses number of inefficiencies and also provide new tools and functions to facilitate the analysis of business exposure, unification of company information, elimination of manual process and standardization of information Entry.

The architecture follows the conventions of a layered, distributed model. The distributed model allows the application to be deployed across several physical tiers. The System being developed is based on a multitier architecture using Asp.Net/C# for Web Application and .NET WCF for communication.

Responsibilities:

• Created Web pages based on the functional specification document.

• Preparing unit test cases.

• Created scripts to test the application using the Microsoft test framework.

• Identified Class Diagrams and developed Use Cases & Sequence diagrams Using Microsoft Visio.

• Implemented the whole module and did the unit testing.

• Generation of Reports using MDX queries.

• Translated design documents and flow diagrams into functional specifications and unit test plans.

• Designed the user authentication module completely.

Environment: Microsoft SQL Server 2005, Microsoft DTS, C#, Asp.Net, Visual Studio 2005, Microsoft Test Framework, Microsoft Visio, MKS(Source Repository).



Contact this candidate