Summary

• Over 12+ years of experience in Software QA Testing / Development/ Analysis / Design / Project Onsite Coordinator / QA Lead (Data Warehousing) using Manual and Automated testing procedures in Department of Human Services, Environmental, Educational, Financial and Industrial, Business to Business, Medical/Health,Airlines applications.
• Expertise in Testing different kind of applications like Developed in Data Stage/Informatica(Data Warehouse),Business Objects,MQ Series,.Net, Web, E.R.P, Client/Server(Two/Three/N tier), Crystal Reports and Mainframe applications using Mercury Interactive,Rational and with extensive experience doing manual Testing for the applications developed in .Net,Visual Basic, Asp, Java/JSP, Mainframe, Crystal Reports, Unix, Teradata,Db2, Oracle, SQL Server, MS Access, Data Warehousing.
• Experience in writing Test Plan/Test Strategy, Decomposition of requirements, build Test Conditions and Test Scenarios/Test Cases, developing and maintaining test scripts, creating test data, analyzing bugs, interacting with development team members to fix errors. Developed several Test cases to cover both positive and negative functionality.
• Experience in validating & verifying and testing the ETL based Data warehousing applications.
• Experience in validation and verifying and creating input/output files for SOAP / MQ Series based applications.
• Responsible for ETL testing for GMAC-RFC and St. Paul Travelers data warehouses.
• Experienced in performing Business functionality tests at various stages like build Verification, Functional, GUI, Database, Load, Stress, Black Box, White Box, User Interface, Performance, Regression / Integration/Smoke/Sanity and User Acceptance, Data Migration / Mapping testing.

• Used Quality Center/Test Director/ClearQuest/Rumba PVCS Tracker, JIIRA for reporting the defects, Querying the Reports and Developed the Graphs / Reports using Quality Center.
• Ability to maintain the Project Plans using ITG.

• Worked on Business to Business Applications using Microsoft BizTalk Server 2002/2000.

Architecture:

.Net Applications / N-Tiered applications / Web Applications / Client Server(Two, Three) / Data Warehouse

Databases:

Teradata7.1,Db2,SQLServer2000/7.0/6.5,Oracle 9.i/8.i/7.2/7.0,MS Access, MSFoxPro.

.Net Frame Work, Visual Interdev 6.0, VB 6.0/5.0, Asp2.0, Html, Xml.DataStage 7.2.1, Informatica

Web Server:

IIS, App Server, iPlanet

Reporting Tools:

Business Intelligence Reports, Crystal Reports 8.5/8.0, Oracle SQL* Reports

Testing Tools:

QTP, Win Runner, Load Runner, Test Director, Quality Center, Rational Robot, Rational Clear Quest, Test Manager, Hercules, Gtest, EOS, PVCS Tracker,PVCS Version Manager.

Application Server/Integration Server:

MTS, BizTalk Server 2002/ 2000

VB Script/ Java Script

C++ / C

Com+ / Com, Dcom, Ado, Ado.net, ODBC

VB.net, Asp.Net, Ado.net

Toad, AQT, Teradata SQL Assistant 7.1, Visual Interdev 6.0, ERWIN 2.5,Visual SourceSafe, ODBC Administrator, Install Shield, MS Package & Deployment Wizard, MS Project, Team Connection, ITG,XMLSpy

Operating System

Windows XP, Windows 2000, NT 4.0, Windows 98/95, Unix, AS 400.

DataStage7.5.1,Informatica,MQ Series/Security

Confidential,MN, Sr QA, Feb 2008 – Till Date
Description: The Narita Irregular Operations (NRT IRROPs) project meets the need to inform passengers and agents of flight cancellations for Pacific Division departures. For passengers that are automatically rebooked via Automated Flight Rebooking (AFR), modifications to the domestic notification process will support cancellations out of the Pacific Division. For passengers not automatically rebooked, the reservation automation team will create a new process so that passenger name records (PNRs) can be manually rebooked.

For both types of rebooking, passengers and agents will be notified via voice, e-mail, or text message. NWA has partnered with West Corporation to deliver the notifications via a new Outbound Notification (OBN) system. The OBN will send all the required information to West to notify passengers and agents.

Changes to the My_NWA_Info site will be made in order to allow the passengers to enter their preference for contact channel, language, and hours for contact. The vendor, West, will send responses to the OBN with the status of the notification. The OBN will then update the PNR with the contact status.
Role:

• Created EVT Test data using MY NWA site, Created PNR test data using PARS.
• Created Test data and xml for all the Modules(Create Notification, Disposition and PNR remarks, Language, Persist Contact, PNR Contact, Travel Agencies, Send Notification to West).
• Involved in Test Execution System / Integration / Regression / UAT of all the Modules.
• Involved in Smoke testing the most crucial functions of a program work
• Involved in Sanity testing when minor changes to the application.
• Involved in verifying the data in END to END testing.
• Participated in the requirement and design walkthroughs verifying the testability.
• Prepared testable assumptions and scenarios.
• Enhanced and modified the Test Cases according to the test case scenarios.
• Provided weekly status updates to QA lead/project management with estimated time to complete for remaining work.
• Involved in writing test cases, prioritize requirement and Test execution for Fly Together Project and also involved in Validation and verifying the data and logging security for Fly Together project.
• Involved in writing test scenarios and manual validation and verification for different credit cards for NWA-Delta employees and their buddies.
• Experienced in creating XML files and Input text files and validated output file and database field by field validation and verification in MQ Transaction NWA-Delta Project.
• Coach and mentored other QA team members in OBN / Fly Together / MQ Transaction Projects – Delta.
• Worked with developers to resolve defects and environment issues.
• Used Quality center to track the defects.
• Extensively involved in testing ONDEMAND / Loyalty cutover testing for NWA and DELTA.
• Created test data using sky miles for SM Accounts and Used Delta term to create test data from delta PNRs.
• Involved in preparing test data and testing all the modules in Loyalty cut over.(Persist Contact, Notification, PNR Updates, On demand.
• Involved in preparing test data and testing all the modules in Inventory cut over.(Persist Contact, Notification, PNR Updates, and ONDEMAND.)
• Involved in testing Dress Rehearsal 3,2,1 overall the integration system – NWA + DELTA).

Environment: Java,JSP,J2EE,XML,WebSphere,DB2,Windows,Ultraedit,QualityCenter,QTP, 9.0,Oracle10g,MQ Series, Pars, Delta term, Mainframe, BRIO, Auadata Studio.

Confidential,Eagan, MN, Sr QA, Aug 2008 – Dec 2008
Description: Prime Therapeutics a pharmacy benefits solutions company providing clinically based, cost-effective pharmacy solutions for its clients and their members. Providing services to Blue Cross and Blue Shield plans, employers, union groups and third party administrators. Prime Therapeutics a pharmacy benefits solution integrated with health management for clinical, financial, member gain pharmacy with existing client programs. Applications are developed for Medicare, Commercial & Call Center Customer service representatives for access to Member Information, Claim History, RxRefill processing based on health plan & health plan types.
Role:

• Created and Executed Test Plans,Test Cases and Test Scripts.
• Involved in Functional Testing, Regression Testing and Performance Testing IPS XML Messages, text files MQ Series application for Medical and Account and Pharmaceutical.
• Participated in the requirement and design walkthroughs verifying the testability.
• Prepared testable assumptions and scenarios.
• Coordinated, prioritized and executed software re-testing of defects using Test Director 8.0 & Quality Center 9.0.
• Involved in executing IPS based test case for different clients using AS400.
• Involved in validing the Medical / Accounts files coming from the client & validating pharmacy files from IPS.
• Enhanced and modified the Test Cases according to the test case scenarios and Use Cases.
• Involved in traceability matrix, test summary result, defect summary reports, and defect summary graphs; ensured the effective use of the QA testing process and best practices using Prime Therapeutics Guidelines.
• Tracked and reported on defects and project status and prepared test reports.
• Provided weekly status updates to QA lead/project management with estimated time to complete for remaining work.
• Credit card validation and verification experience in RX Applications.

Environment: Java, J2EE, XML, .Net, MQ Series,WebSphere,DB2,Ms-Sql Server,AS400,QTP,
Windows,SOAP UI,QuickTest Pro9.0,XMLSpy,Quality Center 9.0 and Test Director 8.0.

Confidential,MN, Sr QA, May 2007 – July 2008
Description:
Boston Scientific has advanced the practice of less-invasive medicine by providing a broad and deep portfolio of innovative products, technologies and services across a wide range of medical specialties. Major part of the project involved in development of automated test tools for Frontier.
The client Boston Scientific develops wireless enabled implantable Cardio Vascular devices for heart. Communicator(An in-home monitoring unit) automatically and wirelessly reads implanted device information at scheduled interval specified by the physician and uploads data on server in-order to view data on-line by Physician/Clinicians, thereby helping drive device follow-up compliance.

Role:

• Involved in test plan, traceability matrix, test summary result, defect summary reports, and defect summary graphs; ensured the effective use of the QA testing process and best practices using Boston Scientific Guidelines.
• Participated in the requirement and design walkthroughs verifying the testability; prepared testable assumptions and scenarios.
• Created and updated the protocols to ensure protocol traced all the requirements.
• Performed requirement traceability and validation in the protocol.
• Executed protocol test as defined in the test plan using GTest, EOS for dry run and formal.
• Involved in MQ Transaction /MQ Series system and Regression testing in Pacemaker ,Device order subsystem
• Tracked and reported on defects and project status and prepared test reports.
• Maintained protocol version using PVCS version manager.
• Created and executed SQL queries to do the data validation and verification.
• Collected and analyzed testing results and metrics.
• Utilized defect-tracking tool (PVCS Tracker, JIIRA) to ensure compliance with the defect-reporting process. Worked with developers to resolve issues.
• Provided weekly status updates to QA lead/project management with estimated time to complete for remaining work.
• Tracked defects and project status and generated the managerial reports to the management.
• Coached and mentored other QA team members.

Environment: IBM RAD 7, MQ Series,IBM Web sphere 6.1, J2EE (JSP/Servlets), Struts 1.1, Jasper-reports for developing reports in pdf format, iReport(GUI tool for jasper-reports development), Ant for Build, Oracle 10g Database and PL/SQL, TogetherJ for UML designing, HTML, Javascript, SVN, PVCS,Hercules 2.14,GTest 2.6,PVCS Tracker,TOAD 9.0,TMS+.

Confidential, (Bloomington –MN) Aug 2006 – May 2007
QA Lead
Description: The ValueMart project objective is to consolidate various property valuations from many disparate sources in the company into one centralized data repository and associate together valuations that have been done on the same property. The challenge in associating valuations on the same property together is that no one primary key spans all of the valuations in all the systems over time. In this environment, the property address becomes a critical piece of information to match valuations from differing systems or even the same system over time. Since addresses can be entered in different ways, one of the objectives of this project is to standardize property addresses to increase the matching success.

Role:

• Developed the test plan, traceability matrix, test summary result, defect summary reports, and defect summary graphs for ValueMart iterations 1, 2, 3.
• Ensured the effective use of the QA testing process and best practices.
• Ensured the requirements decomposition and development of the validation matrix (ces) for ValueMart iterations 1, 2, 3.
• Responsible for system / Integration / Regression / UAT and Production Verification and validation in iterations 1,2,3.
• Involved in creating system test scripts and UAT test cases for VM.
• Tested and Verified Migrating and populating the data into DataWarehouse.
• Work with the different source systems of the data in VM.
• Created SQL Queries, test scenarios, and test cases according to the requirement and specifications within Test Director for all iterations 1, 2, and 3.
• Executed test cases as defined in the QA test plan (project duration).
• Involved in supporting UAT activities performed by business user in VM 1,2,3.
• Tracked and reported on defects and project status and prepared test reports.
• Executed SQL queries and performed data validation and verification/record count from source to dimensional database and visual verification of the health check process for all iterations.
• Assisted in user acceptance testing (UAT) for verification and validation of the data coming from different sources and lading on Oracle dimensional target tables.
• Assisted in the execution UAT and created related user documentation for iterations 1, 2, 3.
• Collected and analyzed testing results and metrics to present to the manager.
• Utilized defect-tracking tool to ensure compliance with the defect-reporting process.
• Worked with developers to resolve issues.
• Provided weekly status updates to QA architect/project management with estimated time to complete for remaining work.
• Tracked defects and project status and generate the managerial reports to the management.
• Coached and mentored other QA team members.

Environment: TestDirector8.0/Mercury Quality Center ,Informatica,DataStage7.5.1, Unix, Windows XP Professional Oracle 9.i,TOAD, SQL, Quality Stage, Cass, MQ Series,Agile Methodology.

Confidential, (ST.Paul –MN) Feb 2006 – Aug 2006
QA Lead / Onsite Coordinator
Description: The Claim MI ETL Project is a sub-project of the larger Enterprise Program. Its focus is to transform transactional claim data from Conversional/Preload/Data Throwing process through MQ’s and load into Teradata Data Warehouse. Using TPump / Fast Load
Scripts.
Role:

• Leads QA / Testing for the MI ETL(CIAP) Project.
• Assists in the development of the Overall Test Strategy for MI ETL(CIAP)
• Develops the ETL Test Plan / Test Strategy MI ETL(CIAP).
• Verified and Validated all the Imported claims data into Data warehouse.
• Defines, Directs and Oversees Development of Test Scenarios and Test Cases
• Estimate QA / Testing Resources with the Onsite Coordinator for the Project
• Ensures the effective use of the QA / Testing Process / Best Practices
• Participates in the requirement and design walkthroughs verifying the testability
• Ensures the requirements decomposition and development of the Validation Matrix(ces) for MI ETL(CIAP)
• Involved in creating UAT test cases for MI ETL with help of the business user.
• Responsible for supporting UAT activities in MI ETL, UAT test execution and UAT test summary result and defect Report.
• Coordinates and assists in the creation of test scenarios and test cases within the QC / Test Director Tool.
• May Create Test Scenarios / Test Cases according to the Requirement & Specifications.
• Reviews Quality Center / Test Director Best Practices
• May Execute Test Cases as defined in the QA / Test Plan (Project Duration)
• Tracks and report on defects and project status and Prepare Test Reports
• Visual Verification/Execution of the DataStage Jobs.
• Verification and Validation of the data coming from different sources and lading on Different Teradata Target Tables.
• Collect and analyze Testing results/Metrics present to the manager
• Provide weekly status updates to QA Architect/Project Management with estimated time to complete for remaining work.
• Tracks defects and Project Status and generate the Managerial Reports to the Management.

Environment: Quality Center, DataStage7.5.1, Teradata, Unix, Windows XP Professional Mainframe(Host),TOAD, AQT, DB2, Teradata Sql Assistant 7.1,SQL.IBM MQ’s.

Confidential, (Eden Prairie –MN) Aug 2005 – Jan 2006
Sr.QA Tester
Description: The Genesis project is converting GE Fleet onto a new Business Intelligence (reporting) platform. The platform will deliver over 100 different types of reports to hundreds of internal and thousands of external customers. The reports will allow a multitude of users to analyze all aspects of their fleet operations, including summaries and trends at a high level or detailed information at the transaction level.
Role:

• Currently performing a manual testing role on a fast-paced team project to implement the successful conversion of Micro Strategy data generated reports to Business Objects for General Electric Fleet Services.
• Responsible for writing and executing report test cases using Mercury Test Director.
• Responsible for creating and tracking defects to the end of the software life cycle based upon requirements of the Business Objects system in Test Director.
• Responsible for running the SQL queries using T.O.A.D compare Micro strategy data with the Business Objects data. Make sure Business Objects pull the correct data.
• Developed the Status/Metrics reports using Test Director.
• Used Test Director for defect tracking and Defect Report.
• Responsible for moving Business Objects reports to testing then UAT and Production.

Environment: B.O 6.5,App Server 5.0.2.8,iPlanet, 6.1, Oracle 8.1, T.O.A.D, Unix, Micro strategy 7.2.1,I.E 6.0, Test director 8.0.