Quality Assurance Sql Server

Priya Konam

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

Professional Summary:

• 4 Years of extensive experience as IT Professional specializing in Quality Assurance Testing.

• Experience in both manual and automation Testing.

• Experience with LoadRunner (11.0, 9.5), QTP and Selenium tool.

• Experience on Black Box and White Box Testing.

• Previously worked with banking, communication, Management and Warranties Domain and also worked with web application.

• I have very good testing experience in c#, java and .net application.

• Great process knowledge of Software Development Life Cycle like Waterfall, Spiral, Rational Unified Process and understanding of various Test methodologies

• I am good in SQL Query like writing all types statement and also joins

• Experience in UNIX.

• Extensive experience in Functional, Regression and Performance testing.

• Experience in Office Word, Excel and Access.

• Experience in Web Services applications.

• Extensive experience in reviewing and understanding business and testing requirements and writing detailed test plans, test cases, test scripts, test metrics and defect reports.

• Experience with Test Director and Quality Center for maintaining and executing test cases, Defect Management and Bug Tracking.

• Experience in Agile/SCRUM software development process.

• Ability to understand business rules quickly.

• Good documentation experience in creating Technical Reviews, Reports & Strategy (Summary Report).

• Ability to work under strict deadlines & high pace environment.

• Worked independently as well as in team and experienced in coordinating with different groups in projects.

• Excellent Communication, Interpersonal and Leadership skills. Self-motivated, quick learner and a team player.

Technical Skills:

Operating Systems Windows XP, NT, 2003, 2000, 98, 95, Linux.

Project Methodologies Rational Unified Process, OOD, UML, SDLC, Waterfall, Agile, Spiral.

Databases Oracle 8i/9i, SQL Server 2000, MS Access.

Computer Skills SQL, PL/SQL, Advance Excel (Data functions, Pivot tables, Reference Lookups etc), Access.

Scripting Languages VBScript, Java script.

Documentation Tools MS Office, Excel, MS Visio Pro, MS Project,PowerPoint

Testing Tools and Bug Tracking QTP, QC,Bugzilla,Loadrunner, TestDirector,Selenium (IDE,RC,GRID)

Languages .NET, C#, ASP, C, C++, Visual Basic, Java.

Professional Experience:

Client Name: Chevy Chase Bank, VA

Role: QA Tester Duration: April 2009 –Dec 2010

Description:

Chevy Chase Bank, F.S.D is the largest locally-based banking company in the Washington Metropolitan Area . Despite its name, it is a federally chartered thrift regulated by the Office of Thrift Supervision, rather than a bank. It was formerly held and controlled by the B.F. Saul Real Estate Investment Trust; B. Francis Saul II, who founded the REIT and is the grandson of the founder of the BF Saul Company, served as its chairman.

This is Online Banking with .net and #c , project is the bank’s primary fund transfer system that enables fast and secure processing and transfers of multi-currency payments. Bank customers can do online registrations, electronic payments, can make purchases at merchant locations or can withdraw money around the globe at VISA supported ATMs.

Responsibilities:

• Reviewed the Business Requirement Document, Software Requirement Specifications and Use cases in the initial phase QA process

• Involved in Developing VU Script and test scenarios, executed and monitored that scenario and analyzed the test result using Load Runner.

• Independently developed LoadRunner test scripts according to test specifications/requirements.

• Involved in Functional Testing verify that the system behaves correctly from the user / business perspective and functions according to the requirements and models.

• Involved in the software product development lifecycle.

• Developed Test scripts and Scenarios depend on Non-functional requirement.

• Involved in Correlation to find dynamic values.

• Involved in Text, image check using checkpoints.

• Involved in Manual Testing in developing stage of the application

• I work with parameterization for all modules.

• Used to identify the queries which taking too long and optimize those queries to improve performance.

• Performed Performance testing to check the application, modules like download link and monitoring the result.

• Diagnose of performance bottlenecks.

• Responsible for preparing Weekly/Monthly Status Reports for upper management.

• Involved in meeting for get the information of the application.

• Preparing click path document and summary report.

• Actively participated in Status reporting meetings and interacted with Development to discuss the technical issues.

• Wrote Complex Sql Queries to retrieve the data from various Tables and to test the database.

Environment: Windows NT/2000, .NET, C#, UNIX, VB 6.0, Oracle, SQL Server, TOAD, IIS, Quality Center and QTP, load runner 9.5.

Client Name: Verizon, Tampa

Role: QA Tester Duration: October 2008-February 2009

Description:

Verizon is one of the leading telecom sectors in USA eCO Systems project involves three applications namely eCenter/eVisor/eCOT. All the three applications were merged in order to improve the efficiency of Technicians and their Supervisors that work within the Central Office and Operations Centers with less human intervention throughout the business process. E CO Systems will significantly enhance existing capabilities within Verizon Network Operations through the standardization and automation of complex work processes, management and presentation of data used in those work processes, and providing new flexibility to quickly and accurately implement changes in those work processes. This project is targeted to all Supervisors, technicians and NDC dispatchers and it plays a very important role in near future.

Responsibilities:

• Reviewed the Business Requirement Document, Software Requirement Specifications and Use cases in the initial phase QA process.

• Involved in the software product development lifecycle.

• Prepared Click path Document to do the performance of the application.

• Independently Developed Load Runner test script according to test application

• Performed change version control processes to ensure the stability, availability and data integrity of production environment.

• Identified Disk, CPU, Memory, Database usage.

• Verification Text.

• Involved in Flow Diagrams for the application to be tested.

• Used Quality Center for reposting result.

• Maintained defects in Quality Center based on Defect Tracking Life Cycle.

• Performed backend testing using SQL queries and verified data integrity on bulk file status.

• Maintained performed Gap Analysis report.

• Handling Configuration Management Configure for optimal settings and configuration.

• Monitor test environment and maintain version control based on QA standard.

Environment: Java, UNIX, Web Sphere, DB2, Windows 98/2000, QTP, QC, LoadRunner.

Client Name: E-HIMS (Healthcare), CA

Role: Quality Assurance (QA) Tester Duration: January 2008-October 2008

Description: E-HIMS is HIPAA complaint one stop solution for US healthcare market. E-HIMS is J2EE based n-tier application. This application consists of 8 different modules to cater the need of Physician Practices and Hospitals (Providers). The features integrated in e-HIMS are organized under the different modules: Scheduling, Registration, Case Management, Billing, Credentialing, Inventory, Administration and Security.

Responsibilities:

• Reviewed the Business Requirement Document, System Requirement Specifications and use cases in the initial phase of development for J2EE Application.

• Developed and modified complex Test Scripts where Performance, Efficiency, and Reliability were critical.

• Performed integration and regression testing on various platforms and different versions of the application.

• Performed Black Box Testing.

• Developed test script with Transaction points.

• Worked with parameterization.

• Executed regression testing for all Medical claims and critical transactions.

• Identified bottlenecks, data errors and integration problems and revised application to enhance performance.

• Developed strong SQL queries

• Tested HIPAA Transactions & Code Sets HL7Standards like (270,271,276,277,820- Premium Payment for enrolled health plan members, 834– Enrollment /Dis-enrollment to a health plan, 835, 837 ...etc.) for smooth transition into EDI environment.

• Responsible for preparing Weekly and Monthly Status Reports for upper management.

• Actively participated in Status reporting meetings and interacted with Development to discuss the technical issues.

Environment: WinRunner7.1, Test Director5.0, Load Runner 5.0, J2EE, Oracle8.0, Pega PRPC, Windows NT and Toad.

Client Name: Rapid Warranty

Role: QA Engineer Duration: 1 Year 2 month (India)

Description:

This is a web-based project developed for the motor vehicle dealers to facilitate their customers to claim their warranties. It has a sophisticated rule engine to determine and validate the claims based on different criteria and gives the score for automated or manual processing of claims.

Responsibilities:

• Reviewed the Business Requirement Document, System Requirement Specifications and use cases in the initial phase of development.

• Involved in Functional Testing.

• Preparing Test Cases, Test Script based on Business Requirements Document (BRD).

• Developed the test cases to test Functionality, interface of the application.

• Performed Manual and Automated Testing on different modules of the application.

• Tested HIPAA Transactions & Code Sets HL7Standards.

• Tests were planned and managed using Test Director.

• Wrote PL/SQL Queries to retrieve the data from various Tables and to test the database.

• Tracked and reported bugs using Test Director.

• Participated in specification documents reviews, test plans reviews, and daily bug triage meetings.

• Documenting and Reviewing test cases, test results, test defects, and problem resolutions.

• Tested the rule engine for the straight through claims processing and operator processing.

• Logging defects and working proactively with the QA team and developers to resolve any issues that inhibited testing.

Environment: Windows NT/2000, ASP, .NET, IIS, SQL Server, QTP, QC.

Education

• BE (Sathyabama University, Chennai)

Training:

• C, C++, .NET.

• Load Runner.

• QTP.

References:

• Available upon Request.

Contact this candidate