Professional Summary:

• Over 9 years of IT experience in complete software life cycle analysis, design, development & quality assurance activities across different verticals such as Banking, Health Insurance & Telecom.
• Wide exposure to cumulative Software Quality Assurance & testing experience in the area of Manual Testing, Web & Client/Server based applications & ETL Data warehouse applications
• Complete understanding of QA methodologies. Expertise & experience in performing different kinds of testing like black box testing, unit testing, security testing, functionality testing, GUI testing, unit testing, negative testing, integration testing, backend testing, performance testing, load testing, stress testing, regression testing, User Acceptance testing(UAT) & System testing on Windows & Unix environments.
• Proficient experience with Manual & Automated Testing of GUI & Functional aspects of the Client-Server & Web based Applications on multiple levels of the SDLC & STLC
• Experienced in manual testing & defect tracking using Mercury Quality Center (Test Plan Creation, Test Scenarios, Test Steps, Test Execution Schedule, Test Summary Report)
• Involved in doing the System testing, Regression testing & Integration testing for various projects which involves ETL Validations in the Data ware house.
• Validated the source to target transformation mappings (ETL transformations ) for various projects which extracts & loads from different & multiple sources & targets like Oracle, Teradata, SQL server, Sybase databases & flat files.
• Involved in developing Test Plans, Test Scripts, Test Cases & Test Data using requirement specifications & design documents.
• Well-versed with all stages of software development life cycle (SDLC) & Software Test life cycle (STLC)
• Excellent experience in Oracle, SQL Server, Tera Data Data Bases
• Experience in writing test scripts designing test procedures & test cases.
• Conversant with all phases of Project Life Cycle including Requirement gathering, Analysis, Design, Development, Implementation, Testing, Software quality standards & configuration management & change management & Quality procedures.
• Extensively use Test Director/Quality Center, Clear Quest & PVCS tracker to report bugs
• Experienced in back-end testing using SQL queries, generating reports to ensure Data Integrity & validate business rules.
• Pretty good experience in EBCDIC, ASCII, EDI & CSV File Formats
• Excellent knowledge of VB script & Descriptive Programming for developing test script & Functional libraries
• Effective leadership skills with good written, verbal communication & presentation skills. Self-motivated with result oriented approach.
• Experience working Individually & in Team environment
• Trained less experienced testers/Junior level testers & worked as Lead/Sr. Analyst/QA Analyst
• Able to work collaboratively with testers, developers & other team members in testing high quality, critical complex projects & in the overall enhancement of software product quality.

EDUCATION:
M.C.A (Master of Computer Applications)

Technical Skills:
TESTING TOOLS : Win Runner 9.x; Quick Test Pro 10.0, Load Runner 7.x,  Test Director 7.x/Quality Center 9.x/10.0, Rational Clear Quest, Rational Quality Manager. 
PLATFORMS : MS-Dos, UNIX, Windows 95/98/2000/NT/ME/XP
APPICATIONS : Microsoft Outlook, Word, Excel, Visio & Power Point.
DATABASES : Oracle, TeraData, SQL-Server, DB2 & MS Access
LANGUAGES : C, C++, C#, Visual Basic,COBAL, JCL,SQL, PL/SQL,.NET JAVA,J2EE,
SERVER SIDE : Servlets, Jdbc, Jsp, Ejb, JavaBeans. 
GUI : Developer 2000,V.B5.0/6.0 & POWER BUILDER 5.0.
MARKUP LANGUAGES : HTML, DHTML, XML (XSL, DTD, DOM), & WML
SCRIPT : JavaScript & VBScript.
VERSION CONTROL : WinCvs, Clear Case, PVCS tracker, AbInitio EME 
ETL Tools : Abinitio, Informatica 
WEB/APPLICATION SERVERS: Web Logic Server, IBM Web Sphere & IIS 
OPERATING SYSTEMS : Windows 95/98/NT/2000/XP, UNIX
REPORTING TOOLS : Crystal Reports 5.0/6.0, Data Reports & Reports 9.0/10.00.

PROFESSIONAL EXPERIENCE 

Confidential,Richmond,VA Feb’12 – Present
Sr. QA/Lead
Confidential set out to improve the tools & processes that our Buyers use to purchase vehicles off-site. Part of this initiative was to immerse IT & Corporate Merchandising associates into the Merchandising & Strategy organizations to better understand the Off-site Acquisition Process & help identify areas of opportunity.

Responsibilities:

• Reviewed & Analyzed the System Requirement Specs (SRS) & design documents.
• Participated in all phases of the IT Project Delivery Framework, including review of complex business & functional requirements.
• Involved in Estimating Time Efforts based on test plans & business requirements
• Write & execute manual, functional test cases during multiple phases of SDLC
• Mentoring and leading a team of juniors and new hires or knowledge transfer and implementing QA process.
• Worked on Test Case Design, Test case writing, Test case writing, Test case reviewing & Test case approval.
• Work with developers during iteration testing phases to build software that match requirements.
• Extensively used Quality Center for test planning, & reporting.
• Mapped Test Cases to Requirements (traceability Metrics)
• Worked with developers during iteration testing phases to build software that match requirements.
• Performed Functional, Integration testing, Black box ,User Acceptance Testing & System Testing
• Conducted Regression Testing using QTP
• Prepared the Test data (Input files) for interpreting the Positive/negative/regression results based on the design requirements
• Executed test cases & logged defect in Quality Center/ Documented requirements in Quality Center.
• Excellent working experience in Agile software development life cycle
• Involved in Issue Tracking & Reporting to Project Manager & Discussed with Team Members
• Defects were tracked, reviewed, analyzed & compared using Quality Center
• Conducted GUI Testing using Quick Test Professional –QTP
• Logged defects in Quality Center, re-tested defects, analyzed defect with Users & Developers
• Served as the Liaison between Test & Development
• Created complex SQL queries to access SQL Server database as per the business requirements.
• Performed database verifications using SQL queries to modify & validate the test data using SQL tool.
• Verified the Back end data using SQL Queries.
• Created Regression Testing Design Document & Conducted Regression Testing
• Conducted the Defect Tracking Team meeting to identify the defect source & allocated to concern person
• Worked with developers, business & release managers to discuss the ways to fix the defects.
• Worked collaboratively with other teams to coordinate testing efforts across multiple releases of the application

Environment: Quality Center 10.0, QTP 10.0, SQL Server 2008, SQL, C#, .Net, VB.Net, MVC 3, JQuery,VB Script,Entity Framework, Power Builder, Windows Communication framework (WCF),IIS 7.5, Web services, Teamcity, Subversion, MSMQ,Teradata,Word, Excel, & Windows XP

Confidential,Richmond, VA Mar’11 – Dec’11 
Test Lead
Confidential is largest general merchandise retailer; Capitalone will support both Private Label & Co Branding cards for HBC. As part of this IT project, Capital One is working towards bringing all the historical data from GE, daily acquisition data from Zoot & all other account level data from FD to load into new PDW Warehouse to support different Card Servicing.

Responsibilities

• Participated in Business Analysis, Technical Requirements & High level System Design Document Reviews.
• Validated the source to target transformation mappings (ETL transformations ) for various projects which extracts & loads from different & multiple sources & targets like Oracle, DB2,Sybase, SQL server databases & flat files.
• Involved in writing SQL queries with joins & filters to validate the Referential integrity & Data integrity between different related tables in the Data ware house.
• Used TeraData to write the SQL quries
• Involved in mocking & manipulating the source data to validate complex ETL transformations to do negative testing scenarios & to validate the data quality checks.
• Validated the data in the Analytical reports with the back-end data in the database for different user permission levels.
• Worked with serial & multi file system(mfs)
• Created System & Integration Test plans (BAS) & Test scenarios based on the System Requirements & the High-level design documents.
• Communicated with offshore Development team.
• Wrote DB2 SQL queries to query the target database (DB2 on MVS) & compared the expected results with the actual results for data validation
• Created positive &
• Used Testing with Agile Methodology
• Participated in reviewing & validating the Source to Target (S2T) transformations mapping document.
• Created System Test cases in Quality Center based on the System Requirements & the detail design documents & Source to target mapping documents.
• Worked on EBCDIC, ASCII & EDI File Formats
• Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases. The tracing of requirements to the test cases was done in Quality Center.
• Involved in doing the System testing, Regression testing & Integration testing for various projects which involves ETL Validations in the Data ware house.
• Supported the extraction, transformation & loading process using Abinitio for the data warehouse from various heterogeneous sources.
• Conducted defect tracking team meeting to identify the defect source & allocated to concern person
• Wrote SQL queries using the Teradata SQL Assistant 6.1 to query SQL server & Teradata
• Coordinated with various upstream & downstream systems to do integration & end to end testing for different projects.
• Used Clear Quest for opening & maintaining defects found during system & integration testing.
• Worked on regression testing of all the system test cases for re-testing out the functional system requirements.
• Supported & participated in UAT (User acceptance testing) by loading the data into the data warehouse for the users to do UAT & to clarify the technical related questions during the UAT.
• Trained less experienced testers & worked as liaison between testers & developers
• Worked with SQL queries for cross verification of data.
• Used Quality center as defect tracking tool.
• Involved in generating reports from Quality center regarding the defect & testing status updates & send to the teams an the time of system & integration testing .

Environment: Abinitio (ETL), UNIX, Teradata 13.0, Accord tool, Quality Center, Service Manager, SQL, PL/SQL, TOAD, Oracle, XML, DB2 8.0 on MVS, Clear Quest, MS Office & Windows XP

Confidential,VA Nov’10 - Feb’11
Sr.QA Analyst
HRS (Healthy Returns System) A clinicalmanagement system that allows users to interact with the members of WellPoint Inc. Helping them to get enrolled in different HealthCare programs. It provides a flexible way to manage health of WellPoint member & helps in betterment of there lives.

Responsibilities

• Extensive experience with Test Case Management Creating, executing, & managing test cases with or Without business requirements design documents
• Test cases review & Test Execution as per System & Business requirements.
• Performed Data Migration Testing for MRT Tables to new set of Tables for Improved Scalability.
• Analyzed Different Data models to retrieve data from Multiple Tables as per theMigration Rules.
• Extensive experience with Interface Testing, Black-box, Web services, & GUI, Smoke testing, Integration, Regression testing & UAT.
• Extensively used Clear-Quest for reporting/tracking bugs.
• Extensively involved in Backend Testing writing SQL Queries to Validate the Data, Store Procedures.
• Performed various types of testing, such as Black box, Functional Testing, User Acceptance & System Testing & Regression Testing.
• Prepared documentation, Involved in preparing Requirement Traceability Matrix
• Wrote complex SQL queries to test ETL data from DDM->TMP, TMP->STG & STG->TDL.
• Development of various SSIS packages responsible for migrating data from various source systems to the Target system.
• Used Requisite-Pro & RQMas repository for requirement analysis, designing test cases.
• Developed Traceability matrix, mapping test cases to the requirements.
• Used Testing with Agile Methodology
• Ability to manage multiple efforts simultaneously. Ability to prioritize workload.
• Created positive & negative scenarios for test suites.
• Trained less experienced testers/Junior level testers & act as lead for Junior level testers.
• Prepared documentation, Posted in SharePoint, Involved in Traceability Matrix & mentor team
• Conducted walk through, & reviews of the documentation & Involved in daily scrum meetings.
• Excellent troubleshooting & problem resolution skills

Environment: SQL Server 2008, Java, Structs2,Spring, Soap, Java Script, JBoss(DROOL), C#, .Net, Web services, Hibernate, EJB’s, SQL Server, Web Sphere, EXTJS, Maven, Hudson & WindowsXP, Word, Excel, Clear Quest, Rational Quality Manager(RQM) & Test Director

Confidential, VA Aug’05 –Oct’10
QA Analyst
Project name: Web F & A
Web F & A deals with the financials & accounting of VDH.Vendors to VDH raise invoices for the services provided to VDH. VDH in turn sends payments to vendors by raising electronic vouchers against those invoices. The electronically keyed vouchers are sent to DOA, which then sends the payments to vendors. The vouchers are also raised to pay travel advances, petty cash advances for employees. Another type of voucher is deposit certificates where deposits are made as part of receivables.
Project name: Web vision:Web Vision aims at automation of various activities of the health department like registering & maintaining the details of all the clients, capturing & maintaining the information of the encounters of the services that the clients receive through the department, & automation & integration with other legacy systems like accounts-payable & accounts-receivable.

Responsibilities:

• Analyzed business requirements & developed test plan, test objectives, test strategies, test cases & created & executed Manual test cases.
• Analyzed requirements received from the development group regarding new development, enhancements, modifications or maintenance
• Generated TSL Test Scripts using Win Runner for Regression Testing & the additional scripts are generated for each version.
• Developed Test cases & Test Scripts for both Manual & Automation testing using Quality Center
• Used & managed Quality Center as repository for requirement analysis, designing test cases, bug tracking & reporting
• Developed & conducted face to face training with users on new or existing applications
• Report & documented bugs in Quality center that were found during testing.
• Wrote both Functional & Regression QTP scripts for Web Applications
• Developed QTP scripts from scratch using Descriptive Programming
• Executed Regression Suite, which was developed in Win Runner & QTP. Prepared requirement traceability matrix for mapping test cases to the requirement.
• Performed various types of testing, such as Black box, white box, & Integration & Negative testing
• Testing, User Acceptance Testing (UAT) & System testing.
• Executed manual & automated testing of J2EE –based applications running on BEA Web Logic Servers.
• Created appropriate test cases, test scenarios, logged defects in Test Director
• Generated automated scripts for testing Oracle Developer & Designer 2000 applications in an Oracle 8i data base on Sun Solaris servers & analyzed the results.
• Created appropriate test cases, test scenarios, logged defects in Test Director/Quality Center.
• Escalate the issues about project requirements (Software, Hardware, Resources) to the Project Manager
• Experienced in back-end testing using SQL queries, generating reports to ensure Data Integrity & validate business rules
• Regression test scripts were executed after bug fixes
• Used Toad to run the queries for the oracle database
• Developed test scripts, cases & data to validate the system from multiple aspects
• Written several complex sql queries for validating Cognos Reports
• Wrote SQL statements to extract data from the Tables.
• Used UNIX shell scripts to run batch Jobs.
• Involved in the conversion of data from Legacy system to the New System for over 33 districts.
• Log project related issues in the defect tracking tool identified for the project
• Good Analytical & documentation skills & ability to perform in a team environment

Environment: WinRunner 9.2, Quality Center 9.2, Quick Test Pro 10.0, Manual Testing, Java, J2EE, JSP, Struts, Oracle Developer & Designer 2000, Oracle 8i/10g/11g,SQL Server, SQL Plus, PL/SQL, Data ware house3.0,Cognos,LogiXML, Web reports, Java Script, VB Script, TOAD, HTML,AJAX, Oracle Application server, Unix, Word, Excel, Visio & Windows 2000/XP.

Confidential, TX Nov’04 -Jul’05
QA Analyst
Confidential is a unified front-end system used in Verizon call centers for ordering DSL, FTTP, Dialup, domain & web hosting services. The SSP Ordering application resides within the iCONsole Shell as a thick client on a Windows based PC with hundreds of reps working simultaneously. It\'s a high orders volume performance oriented .net framework application & is in production for more than a year. Application takes care of ordering, tracking & billing. It also has Content Management & User management with high performance & functionality orientation. Application functionality changes based on users & their own user profile.

Responsibilities:

• Written Test Cases & Performed Manual Testing like Positive testing, negative Testing & Black Box Testing
• Prepared Test Data for Test cases based on Test Plan & requirement document
• Createdtest cases based on Functional Requirement.
• Used Mercury Test Director to create, maintain & execute component test plan & test procedures.
• Performed Functional testing , Sanity testing & Regression testing
• Worked on Single Sign on (SSO) enabled applications for integrity.
• Checking services & their functionality by going through xml trace files & database tables was done as a part of testing
• Created appropriate test cases, test scenarios, logged defects in Test Director
• Conducted Positive & Negative testing on various data entry screens
• Performed Functional & Regression testing using Win Runner
• Upload manual test scripts into Test Director
• Assisted programmers in identifying programs and/ or system errors.
• Developed various reports & metrics to measure & track testing effort
• Extensively used Test Director for reporting/tracking bugs & for document control
• Assisted in running automation scripts using WinRunner. Wrote Test scripts using TSL language

Environment: WinRunner, Test Director, Manual Testing, CMIS, Clear Case, VC 6.0, .NET Framework, C#, XML, Web Sphere, Web Services, .NET Remoting, ASP.NET, ADO.NET, .NET Enterprise Solution, Word 2003, Excel 2003, SQL Server 2000, Clear case 2003, Windows XP.