Summary:

Over 7 years of professional experience in Information Technology with extensive skills in Software Testing, Integration Testing, Functional Testing, Regression Testing, System Testing, Software Design, Development, and Quality Analysis.

• Extensive experience in the entire application Software Development Life Cycle(SDLC), which includes Requirements, Design, Development, System Testing, Configuration, Installation, Release Authorization, and Maintenance Phases.
• Over 4 yr’s experience in the field of Health Care, Pharmaceutical & Insurance Domain.
• Experience in analyzing Business Requirements and Specifications. Worked with Development and Business Analysts to define, write and execute test cases.
• Experience in Testing Methodology and Test Plan Formulation.
• Complete understanding of QA methodologies. Expertise and experience in performing different kinds of testing like black box testing, functional testing, GUI testing, integration testing, Back-end Testing, System Testing, regression testing and bug tracking system.
• Experience in testing Web, Client/Server and Stand-alone Windows applications.
• Extensive experience in writing Test plans, Test cases/scenarios, Test procedures and analyzing test results for manual and automated tests.
• Extensive experience in manual testing in various environments and using automated testing tools of HP (formerly Mercury interactive) Quick Test Professional (QTP), Win Runner and Quality Center.
• Expertise in problem solving and Bug Reports using Quality Center.
• Strong experience in client interaction and understanding business application and data relations from Product development group.
• Experience in Manual and Automated testing, test schedule planning, test case design, Documentation and Execution. Editing and playback the scripts after fixing the bug.
• Good exposure to RDBMS, SQL and PL/SQL, writing SQL scripts for backend/database testing.
• Extensively involved in Back-end Testing and manual testing using SQL and PL/SQL statements for data manipulation
• Good communication, analytical skills and flexible to learn advancements in the IT industry. Capable of performing multi-tasking and meets deadlines.

• Bachelor of Engineering in Computer Science & Information Technology.

Technical Skills:

Testing Tools:

Quick test professional 11.0, Win Runner7.0, Quality Center ALM

Databases

Oracle 8i/9i/10g, SQL Server 2000/05,DB2

Languages:

C, VB Script, SQL, PL/SQL, HTML

Reporting Tools

Crystal Reports 9.0/10.0

GUI

Window Forms, Web Forms

Operating System:

MS-WINDOWS XP/7/2003/2008/2008R2, UNIX

Hardware:

IBM, Dell Compatibles

Packages

MS Word, MS Excel, MS Power point

DB Tools

TOAD, IBM®DataStudio 2.2.1.1

Professional Experience:

Client: Confidential,Charlotte, NC
Project: Symphony
Role: Sr.QA Analyst
Tenure: Oct 2011 Till Date

Premier is about Collecting and analyzing clinical and financial data to improve efficiency of healthcare facilities. Includes company details, and membership information.
Project: Safety Surveillor
Safety Surveillor is to improve infection prevention efforts and reduce costs associated with HAIs. Safety Surveillor is the comprehensive Web-based solution infection prevention professionals rely on for automated infection control, surveillance and medication management. Safety Surveillor Project helps Hospital to better manage their Patient data (Personal Information, Admission, Pharmacy, Surgery, and Infection related information). Premier has the data feed from Hospitals in the form of flat files and real time data Feed. User can opt for different features such as Real time reports, Scheduled Reports and can also create customized alerts

Responsibilities:

• Analyzed User requirements and documented test requirements, Test Plans, Test Cases using Quality Center.
• Followed Agile Methodology in Project Life Cycle. Participated in stand up meetings and weekly status meetings.
• Managed and conducted System testing, Integration testing and Functional testing.
• Tested the Real Time and Scheduled reports based on the requirements specified by business analyst.
• Extensively used the AutoSys jobs for the entire project.
• Extensively used XML’s for all types of messages to load data in to CDW for verifying ETL logic.
• Automated the test cases for the data loads using QTP.
• Created the store procedures for exporting the results in to Excel sheet’s to data comparison.
• Responsible for designing Framework and executing automation scripts using QTP.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Extensively used the XMLSPY for PXsd data mapping validation.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Execute batch processing and verify the jobs status and data in database tables.
• Created the Xml’s for all the HL7 messages types to load the data in to the CDW tables.
• Prepared status summary reports with details of executed, passed and failed test cases
• Worked closely with the business analyst, Pharmacist and Clinical validation for validating the requirements.
• Validation of the reports using SQL queries
• Test data creation is one of the daily tasks to better validate the reports to cover more number of different scenarios.
• Responsible for designing Framework and executing automation scripts using QTP.
• Created QTP scripts to validate the Layout of the report in the regression, by standardizing the input file.
• Participated in business requirements reviews and software system (application) designs for testability.
• Written SQL Queries and executed them using IBM®DataStudio and AQT.
• Attended application walk-through and reviewed Requirements to understand the scope of the project and Attended project meetings as needed and Coordinated with the Developers to resolve the issues/defects
• Uploaded Requirements and Excel Test Cases into Mercury Quality Center. Executed Test scripts from Test Lab manually.
• Involved in System Testing, Regression Testing and Integration Testing
• Worked as a part of team in creating test database and generation of the test data based on different scenarios.
• Created XML Framework for generating xml files from the data sources.
• Created QTP scripts to create and load XML files for bulk loading of Test Database
• Worked on research for finding suitable tool for parsing HL7 Message and loading into database.
• Created Store Procedures to validate the field to field mapping validation.
• Initiated the process for Creating test cases in quality center using reusable modules
• Involved in analyzing functional requirements documents for multiple projects.
• Attended daily meetings, status meetings and defect tracking meetings
• Interacted with developers, Business & Management Teams and End Users.

Environment: Quality Center11.0, Quick Test Pro (QTP11.0), AQT, IBM®DataStudio 2.2.1.1, Business Objects, DB2, ETL, Data warehousing, UNIX Sun Solaris, Java, ASP, XML/SOAP UI Web Services.

Client: Confidential, NJ
Project: SAW, AEGIS
Role: Sr.QA Analyst
Tenure: March 2010 Sep 2011

Q.STAR Automation testing team will identify the specific tests that will be performed on SAW 5.20 V2.0 Build’s Components and AEGIS Builds Components, to ensure the quality of the delivered product to the Field/Production. Q.STAR will perform automated testing (using Mercury tools) on the SAW 5.20 final Image and AEGIS final Image. This testing scope is intended to ensure that the Components like Operating System & Service Pack, System Settings, Calculator, Notepad, Paint, Taskbar and start menu, Windows Explorer, Windows Search, Control panel, Command Prompt, Quick launch bar, WordPad Internet explorer & service pack are verified and able to perform basic functions as mentioned in the SAW 5.20 Q.STAR Automation Test Case document. The Q.STAR testing goal is to identify the quality of the SAW 5.20 and AEGIS Image structure, content, accuracy, consistency and performance of the SAW Components as defined in the requirement and RFC documents.
The scope of testing is to Test the Components in SAW 5.20 final build. Each component will be covered by a test case, which will describe the objective of the component and different hardware platforms for testing. A unique Test Case ID will identify each component.

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC).
• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
• Developed QTP Scripts using VB Script and Descriptive programming.
• Involved in Customization of Defect Module as per the requirement.
• Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
• Extensively Used QTP to develop the Regression Test Suite.
• Extensively involved in the installation and configuring QC and Quick Test Pro.
• Installed QTP and QC on Client machines installing using exe file and Silent installation.
• Installed QTP11.0 patches on the Client machines.
• Creating new projects and copying the existing Projects in the Quality center.
• Assigning (read/write) permission users to the projects in the quality center.
• Creating users in the Quality center.
• Extensively used Quality Center for Bug Tracking ,Test case development

Performed Data Driven Testing using QTP to test the application with different sets of data.
Extensively used Share point for the project tracking and assigning the tasks for the team.

• Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries.
• Created Entities in the defect module and enhanced the code in the Quality Center11.0 as per the requirement.
• Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
• Actively participated in Design Reviews and Weekly Status Meetings.
• Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
• Responsible for providing Testing Efforts, Estimates & Timely status.
• Coordinated with business team and facilitated for successful completion ofUAT.
• Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
• Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
• Tested Security Module Role Based security for Access Control.
• Involved in developing and generating the Crystal reports for Test cases, Requirements, Execution Summary report.

Environment: Quick Test Professional 11.0, Quality Center ALM, Sprinter, Windows XP, Windows7 & Oracle 11g, SQL 2000/05, HTML, MS-Office 2003/07,10,Toad, Business Objects Crystal Reports ,VB Script, Share point.

Client: Confidential,, NJ
Project: AERS (Adverse Event Reporting System)
Role: QA Analyst
Tenure: July 2009 Feb2010

Confidential,|certainly leads the pack of health and personal care companies. While medicine accounts for some 69 percent of the company\'s total profits, beauty care, medical devices, and nutritionals also comprise large slices of the total sales pie. In fact, many of BMS\'s most successful brand names include beauty products such as Herbal Essence, Daily Defense, Redmond Aussie, and Nice \'n Easy hair products. Steady performers in the consumer medicines department include Bufferin and Exedrin. Various modules involved in testing this project are...

Modules:

• Data entry screens for Events, Claims.
• Interfaces with third Party Vendors Reports.
• Rule Engines (Product Pricing, Program Eligibility).
• Broker Administration (Broker Creation, Broker Administration)
• Loan related letter & Management Reporting.

Responsibilities:

• Involved in different phases of Software Development Life Cycle (SDLC).
• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business & Functional Requirement documents.
• Extensively involved in conducting the System integration testing, Regression Testing, Backend Testing and GUI Testing.
• Extensively Used QTP to develop the Regression Test Suite.
• Extensively used Quality Center for Bug Tracking ,Test case development

Performed Data Driven Testing using QTP to test the application with different sets of data.

• Extensively used SQL Query Analyzer, PL/SQL Developer to do the Backend Testing by writing the SQL Queries (Select Statements and JOINS)
• Created and maintained a Requirement Traceability Matrix (RTM) for the applications under test and Customized the RTM as per the Team’s Needs.
• Actively participated in Design Reviews and Weekly Status Meetings.
• Responsible for Coordination with business analysts & developers to discuss issues in interpreting the requirements.
• Responsible for providing Testing Efforts, Estimates & Timely status.
• Coordinated with business team and facilitated for successful completion ofUAT.
• Prepared the System Test Plans and Test Cases for all the Production & Change Management releases.
• Tested Data transmission from SQL Database to Excel, Text & CSV Files and also tested various kinds of Reports based on external vendor requirements.
• Tested Security Module Role Based security for Access Control.
• Extensively used Configuration management using VSS(Visual Source Safe)

Environment: Quick Test Professional 9.2, Quality Center 9.2, Windows XP, Oracle 9/10, SQL 2000/05, HTML, C#.Net, ASP.Net, MS-Office 2003/07, VSS(Visual Source Safe)

Client: Confidential, NJ Tenure: Mar 08 July 09
Project: ARES
Role: QA Analyst
Confidential,| is an innovation-driven, science-centered global health care company. Our combination with Organon Biosciences is a transformational step on Schering-Plough’s continuing journey as we build a high-performance company for the long term. Schering-Plough’s closely linked global animal health business is a leader in its industry, serving veterinarians, farmers and pet owners with important products and services.
Responsibilities:

• Analyzed the user/business requirements, functional specs and Use Case documents and created the Test Plans, Test cases for System testing.
• Preparation of Test Cases and Automation scripts Extensive testing Using QTP and Quality Center.
• Extensively used Quality Center for Bug Tracking
• Actively participated in System testing, integration testing and coordinated UAT.
• Performed validation of links, browser compatibility.
• Participated in Enhancements meeting to distinguish between bugs and enhancements.
• Documented all test activities as per the organizasition standards.
• Used all necessary checkpoints of QTP to make the reusable scripts on enhancements.
• Performed Functional testing and Regression testing using Quick Test Pro.
• Performed GUI Testing, Smoke testing, System testing, and White box testing.
• Extensively involved in testing core module “Claim processing Data loading”.
• Exported test cases from MS Excel to Quality Center by Manually.
• Performed the Back end testing by using SQL and verified the data integrity.

Environment:Quality Center 9.2, QTP 9.2 (Quick test pro), DB2, VB Script, Java, J2EE, VB, .Net, XML, Oracle, SQL, MSOffice, UNIX and Windows XP

Client: Confidential,CO Tenure: Jan 07 Feb 08
Project: Premia Lite
Role: QA Analyst

Confidential,| is a fully integrated, Intel based, single entry, processing system, designed to meet the complex data processing needs of Insurance companies, Managing General Agents, Program Administrators, Brokers and Retails Agents. With PREMIA Lite, we provide small and mid-market insurance enterprises our rich industry-specific expertise and knowledge gained from many successful global Insurance solution implementations. PREMIA Lite supports all the major lines of business and can be used by Insurance Carriers, Managing General Agents, Program Administrators, Brokers and Retail Agents.
Beta Health Association, Inc. is a Denver, Colorado based company specializing in both voluntary (employee paid) and contributory (employer paid) dental insurance, dental services, and dental plans since 1990. Beta Health Association, Inc offer individual dental plans and group dental plans as well as group dental insurance. Beta Health Association, Inc is affordable in dental services and dentist offices throughout Colorado and strives to provide customer service and value.

Responsibilities:

• Developed & Implemented Test cases, Test scripts, and Test approach documents based on Business Requirement documents.
• Actively participated in System testing, Integration testing and also active role in coordinating with Business groups.
• Preparation of Test Cases and Automation scripts Extensive testing Using QTP and Quality Center.
• Responsible for Preparing the Bug Reports for every test cycle.
• Responsible for analyzing bugs and reporting to the higher management.
• Automating the Functionality for Regression Testing.
• Responsible for testing the Production Builds.
• Wrote SQL test scripts for Back end testing and verified the data integrity.
• Performed manual testing, automated testing, defect tracking.
• Performed GUI testing, Functional testing, Smoke testing and System testing.

Environment: QTP ,QC, Remedy 4.5, Application Server 4.5, JavaScript, Html, Developer 2000,Oracle forms, Oracle reports.

Client: Confidential, NV Tenure: Oct 06 Dec 06
Project: PREMIA
Role: Sr. Oracle Developer

Confidential,|is a product for insurance companies. It provides great flexibility to insurance companies to handle their activities. This basically contains four modules. They are Underwriting, Claims, Re-Insurance, and Accounts. Underwriting involves the process of raising the quotations, proposals, Risk Analysis, Covers, and Policy Issuing. Claim Deals with Process like Claim Intimation Details, Estimation of Loss, FIR Details, and Survey Reports. Re-Insurance is a process of sharing losses among different insurance companies, usually when the risk is very huge the insurance companies prefer this approach. Finally, Accounting Deals with the monetary issues of the insurance companies Business.

This Product PREMIA10i is used for a wide variety of products like Fire, Motor, Marine Cargo, and Aviation along with the general insurance. Any Insurance company can easily configure this product according to their requirements.

Nevada Division of Insurance granted Nevada Mutual a Certificate of Authority authorizing it to offer medical professional liability insurance to Nevada doctors. Nevada Mutual is the only doctor-owned insurer domiciled in Nevada and only insures Nevada doctors.

Responsibilities:
Created the detailed Test cases from the business requirements document and meetings with the Business Finance Analysts.
Conducted functionality testing using Win Runner.
Generate TSL Script using Win Runner for Automation Testing.
Parameterized the login and password ids to simulate unique users accessing the application.
Identifying Test Cases to be run for Regression Testing and conducting Regression Testing as and when new builds were made.
Customization of Test Director to suite the requirements of the testing effort.
Reported Bugs using Test Director
Involved in writing SQL statements to extract data from the database
Environment: Win Runner, Test Director, Manual Testing, SQL 2000, VB.Net

Client: Confidential,DC Tenure: Jan 2005 Oct 2006
Project: PREMIA
Role: Sr. Oracle Developer

Oracle Forms/Reports Developer

Project: Auto Insurance
Formed as the Mutual Fire Insurance Company of Carroll County in 1870, Confidential,|originally wrote only local home and farm owners’ policies. Now, WAIC is a leader in the property and casualty insurance industry in Maryland, Washington, DC, and Pennsylvania.
Responsibilities

• Writing Custom Packages to implement various functional areas
• Schedule jobs via Oracle jobs using DBMS_JOB.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views in Development and Production environment using PL/SQL and SQL*Plus
• Responsible for Detail Design, Coding, Customization of Reports and coordinate with Onsite Implementation.
• Worked on enhancing both paper and web based reports to have dynamic parameter form, conditional formatting at the Group or Field Level and adding charts.
• Hands-on experience with Oracle Forms/Reports, SQL, PL/SQL.
• Keen focus on performance tuning, testing, and quality assurance.
• Modified database structures including table spaces, tables, views, triggers, stored procedures.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Providing code fixes as well as data fixes for bugs raised in SSP Premia QC Calls
• Written extensive SQL, PL SQL code as needed
• Involved in Internal Unit Testing.
• Use of various DBMS packages to reuse code and automate scripts.
• Use of DBMS packages to implement scheduling, Dynamic SQL and Extensive Usage of Ref Cursors DBMS_SCHEDULER, DBMS_PIPE and utilities.
• Extensive use of Oracle 9i features
• Extensive use of TOAD for extracting scripts from the dictionary
• Extensive use of PL/SQL Collections and Records.
• Created numerous web based Forms and Reports using Oracle Developer 6i.
• Responsible in writing Perl and Unix Shell scripts for customization.
• Responsible System Analysis & Preparing Use cases for the enhancements of the Application.
• Business analysis & Solution Designing for the new enhancements of the Application.
• Creation of Synonyms to create read only objects to maintain the security to give access to specific users.
• Use of Sequences to automate number generation
• Use of different Exception Handlers and also Create Some User defined Exception Handlers.
• Keen focus on performance tuning, testing, and quality assurance.
• Use of Bit map and Function based indexes to improve performance of queries
• Design and development of Interfaces to Integrate modules.
• Use of LOVs, RG, Alerts, Object groups and other important features of D2K

Environment: Oracle 9i, SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL * plus. Windows 98, UNIX.