Sql Server Testing
Resume:
Anuradha
********@*****.***
________________________________________________________
PROFESSIONAL SUMMARY
. About 3 years of professional experience in Information Technology with
extensive experience in Manual and Automated Testing in Health Care,Financial Industries.
. Proficient in Black Box, System, Interface, Functional, White Box, Data
Base, Regression & User Acceptance testing.
. Strong knowledge of Software Development Life Cycle (SDLC) and QA
Methodology Management.
. Expertise in analyzing user requirements, functional and technical
specifications, preparing Test Plans, Test Cases, Use Cases, Test
Scripts, Test Scenarios for both manual and automated testing
. Proficient in both Manual and Automated Testing techniques using Mercury
Interactive tools i.e. WinRunner, Quick Test Pro, LoadRunner.
. Solid experience in writing complex queries in SQL for Back End Testing
in Oracle, SQL Server databases.
. Proficient in database design, programming skills in Java, JSP, Servlets,
ASP.NET, C, C#, VB, XML, HTML and Java script, VB Script.
. Strong experience to work in UNIX and Windows environment.
. Experience in using Quality Center/Test Director for reporting and
tracking bugs.
. Good team player with excellent communication skills along with verbal
and written skills.
. Possess problem solving skills, ability to follow Industry standards and
procedures. Quickly master new concepts and applications.
TECHNICAL SKILLS
Testing Tools Quick Test Pro, Test Director, Win Runner, Silk, Load Runner
,Quality Center
Operating UNIX, Windows 95/98/2000/XP
Systems
Languages Known C, C++, C#, SQL, JAVA, JavaScript, VBScript and PL/SQL
Databases MS Access, Oracle, SQL Server
Front-End GUI Visual Basic, Developer 2000, Power Builder, Power Point, MS
Project
Web JDBC, EJB, Servlets, ASP.NET, JSP, Web Logic, Web Sphere, IIS
Technologies
Other Tools TOAD, PVCS Tracker, MS Word/Excel.
EDUCATION
Masters in Computer Science, University of North Carolina
GPA 4.0/4.0
PROFESSIONAL EXPERIENCE
CareFirst, Maryland
Oct'09 - Till Date
QA Analyst
CareFirst (Blue Cross Blue Shield) is one of the largest insurance
companies in the USA, serving millions of Americans with a wide range of
services including clients such as the Health Maintenance Organizations
(HMOs) and services such as Preferred Portfolio (PPO) and the Point of
Service (POS).It processes different claims like Dental claims, Pharmacy
claims and vision claims from health providers and route the claims into
Batch Adjudication System and Online Adjudication. The project involves
modification in existing claim processing system.
Responsibilities:
. Involved in preparing High Level Test plans based on user requirement
documents.
. Involved in defining Test objectives and performed Manual Testing.
. Involved in cross browser testing using Netscape Navigator and Internet
Explorer.
. Created test scenarios and test cases for the functionality and
integration testing.
. Involved in developing Integration Test Plans and System Test Plans for
the applications.
. Prepared Test Data as per the functional specifications.
. Extensively used QTP 9.0 scripts for claim submission and claim
validation.
. Involved in testing HIPAA EDI (270, 271, 276, 277, 834,835 & 837)
Transactions.
. Worked with healthcare industry administration tool FACETS with various
functionalities involving sales & enrollment, claims processing, customer
service and billing.
. Created and executed automated test scripts using QTP 9.0 for regression
testing.
. Created and used Shared Object Repository for QTP tests.
. Used SQL Queries on Sql Server 2005 and Unix shell scripts.
. Tracked defects using Mercury Quality Center and interacted with the
developers to resolve issues.
. Participated in regular project status meetings related to testing.
. Developed Test Metrics on the weekly basis using MS Excel.
Environment: Windows 2000/NT, UNIX, Quality Center 9.2, QTP 9.0, SQL
Server 2005, Facets, MS Office.
Software Tester
Veer Infotech Jul 2004 -
May 2006
Auto Insurance-ICM,Surat
The application was developed in Oracle and consisted of three main
modules: 'Query', 'Policy' and 'Rate Quote'. The 'Query' model was the
interface with the insurance agent to query the database and generate
customizable reports. The 'Policy' module concerned the various insurance
sectors including Auto, Life and Fire insurance. The 'Rate Quote' module
provided rates and payment terms, funding and protection options, and
coverage details for the various types of insurance.
Responsibilities:
. Involved in System Testing, creating and running scripts
. Manually implemented several test cases and documented the results
. Performed Functionality Testing and GUI testing.
. Involved in testing applications developed using Dotnet framework.
. Developed and executed SQL queries on Oracle database using SQL tool TOAD
to retrieve data and check the tables whether they are loaded or not.
. Tested XML applications.
. Conducted the Unit Testing of .NET applications.
. Wrote and enhanced test cases and test scripts by adding the required
functionality as per the business requirements.
. Automated the scripts using WinRunner.
. Carried out load and performance testing using LoadRunner.
. Involved in measure response time at different pages using LoadRunner.
. Used Test Director as the bug reporting tool.
. Developed Test Plan, Test Procedures and Process for UAT testing and
involved in Installation Testing.
Environment : ASP.Net, ADO.Net, C#, XML, VB script, HTML, IIS, ORACLE,
Microsoft Visualstudio.Net, Windows NT/2000, Test Director, Load Runner,
Win Runner, MSOffice
Global Trust Bank, Surat
Global Trust Bank Transaction Automation System is an integrated
application designed to cater to the needs of day-to-day banking. Involved
in the testing of a banking application to maintain the Current & Savings
A/Cs, Accountholder details, generate deposit and withdrawal slips, and
monthly statements.
Responsibilities:
. Analyzed requirements during the requirements analysis phase of the
project.
. Developed detailed test cases to exercise product functionality
. Performed functionality, boundary values, and integration tests using
WinRunner
. Involved in Backend Testing of the application
. Involved in User Acceptance testing
. Used MS Excel to report the testing status
. Tracked the defects in Test Director and worked with developers to
resolve the issues
. Performed cross-browser tests on Internet Explorer and Netscape
Navigator
Environment: Test Director, WinRunner, J2EE, SQL Server 2000, Windows, MS
Office
Electronic Customer Relation Management
The ECRM Software is built for effective Management of customer enquiry and
product development. ECRM includes enquiry, marketing, technical, system
admin, quality control (QC), Accounts and other Features. The flow starts
from enquiry of product as per the needs of the customer to successful
implementation of customer place. ECRM generates various kinds of reports
required for administration, Departments, Marketing/CSR, Employees,
Technical team It also handles accounting section, which includes the
receivables, payables, balance, payment follow up status etc.
Responsibilities:
. Interacted with end users to obtain specific system requirements.
. Analyzed system requirement specifications and developed test plan, test
cases to cover overall quality assurance testing.
. Performed extensive manual testing of different modules.
. Used Test Director for bug reporting and tracking.
. Communicated about the status and progress of the testing effort with the
management team members using Test Director and MS Office Tools.
. Active participation in creating the Test Summary Report.
Contact this candidate