SUMMARY

• 13 + Years of Experience in IT industry Covering all stages of SDLC having Domain expertise in Banking, HealthCare, Manufacturing, Automotive and Insurance industries
• 10 + years of experience in QA/Testing with expertisein Web, CRM, DWH,BI, ERP ,Mainframe and Client server applications
• Proven track record of handling different QA teams working on Manual, Functional Automation , Performance and data warehouse testing projects
• Expertise in Test planning, Estimation, Scheduling, ,Resource allocation, Vendor management Onsite and Offshore coordination
• Expertise in Setting up Test Environments
• Extensive Experience in Database testing using SQL queries for Oracle, Teradata,DB2 and SQL server.
• Experience in Requirement analysis, Data Analysis use-case analysis, configuration management and change management.
• Proven track record of handling Automation projects using Performance Center Load Runner. Quality Center, SOAP UI,SOA Test and QTP
• Knowledge in SOA and Web Services.
• Excellent troubleshooting and Analysis skills
• Experiences in different testing techniques include White Box and Black Box Testing. Black box testing include Sanity, Functional, Integration, System, Regression, End to End, Security, Acceptance, Compatibility and Data base testing
• Hands on experience in CMMI and ITIL processes
• Expertise in dealing with cross functional team include developers, project managers, Program Managers ,product management and other stake holders
• Experience in preparation of Test report Metrics,Defect Analysis & Management, Release management, Traceability metrics using Quality Center

TECHNICAL SKILLS

Testing Tools: Quick Test Pro , Load Runner , Performance Center, SOAP UI,SOA Test, JIRA, Rational Quality Manager, Clear Quest, Clear Case
Languages:VB script, Shell script, JCL,Java,SQL
Database :DB2, Oracle , MS SQL Server,MS Access
Web:VB.Net, ASP, ASP.Net, JSP, XML, XSL, HTML
GUI :Visual Basic, Toad, SQL Developer
Web:ASP, Java , HTML, XML, DHTML, JavaScript, VBScript
Bug Tracker/CM:Quality Center, HPOpenView, PVCS,VSS,WITS, Harvest, Dimensions
ETL/BI:Informatica,BusinessObjects,SQLServerAnalysis/Reporting Services,Hyperion,Proclarity,Microstrategy,Cognos,Initiate MDM
CRM/ERP:Siebel 7.x/8.x, Siebel Analytics(OBIEE), PeopleSoft, SAP
Tools:Tidal, Maestro, Clarity, HP PPM, Remedy, Reflection,
OS:Windows, Linux, Sun Solaris ,MVS

EXPERIENCE

Confidential , Columbia, MD June ‘11 – till date 
QA Lead
MMH Plus 
Member Medical History contains Membership, Group, Claims ,Case management and disease management data. This application is used by Providers, Clinical and Nurse practitioners for assessing member health history. MMH Plus UI uses web services to fetch the data from Integrated repository 
Responsibilities:

• Prepared Test Plan and Test strategy
• Design , review and execution of test cases
• Reviewed Requirements ,Data Model, Data Dictionary and ETL Mappings
• Involved in System ,Integration and Regression Testing
• Worked on SOAP UI tool for validating the XML request and responses.
• Wrote and Executed SQL Queries to ensure data accuracy for the data.
• Extensively tested Informatica jobs and reports.
• Performed data profiling for data quality validation
• Verified correctness of data after the transformation rules were applied on source
• Coordination of UAT with business users
• Assign and coordinate tasks with offshore test team
• Conducted Defect triage meetings
• Provided Test and defect status reports

Environment: Informatica 8.x, Teradata, SQL Server, Java, Tibco,DB2, Oracle,SQL Assistant,Quality Center, SOAP UI, Unix

Confidential, Owings Mills, MD Jan ‘09 – May ‘11 
QA Lead
Primary Care Medical Home (PCMH)
PCMH Program is built on a new set of incentives to primary care physicians (PCPs) that reinforce the central role of the primary care physician in helping members to understand and manage their health risks as well as guide their care when they experience chronic disease. The data will include a wide range of member related clinical and administrative information including member demographics, medical history, diagnosis, authorizations and referrals, prescription drug history, immunization history and member lifestyle. Worked on the following projects
Member and Employer Portals
This project is intended to extend and secure the Member, Employer and Benefit Manager portion of CareFirst.com with an eye toward a unified user experience, and more personalized account specific functionality for existing clients
CF Enterprise DataWarehouse
ODS Audit Balance and Control
ODS Billing and Payments
CBI reporting
Facets 4.3 to 4.5 Migration 
Responsibilities:

• Prepared Test Plan and Test strategy
• Design , review and execution of test cases
• Reviewed Requirements ,Data Model, Data Dictionary and ETL Mappings
• Coordination with Infrastructure team for environment setup and data refresh
• Involved in System ,Integration and Regression Testing
• Tested data migration from EDWARD to MCP
• Front end validation for MMH Plus UI
• Used SOA Test for Web services testing
• Extensively tested Informatica jobs and reports.
• Performed data profiling for data quality validation
• Worked with XML feeds from multiple sources systems and validated the same in Enterprise data warehouse
• Verified correctness of data after the transformation rules were applied on source
• Conducted Defect triage meetings
• Tested informatica ETL full load and incremental loads by running the Jobs
• Provided Test and defect status reports

Environment: Informatica 8.x, Oracle 9.0, Java, DB2, Cognos, Oracle, Facets 4.3/4.5, Clarity, TOAD, Quality Center, QTP, Parasoft SOA Test, SQL Server, Unix

Confidential, Columbus, OH Sep ‘08 – Jan ‘09 
QA Lead
RADS
Reporting and Data Services helps to identify and represent the needs of entire NF community for quality reporting data from the consolidated Nationwide Finance data marts and benefited Individual Annuities, NDC Retail, Pensions, Compas Retail, etc., 
Responsibilities:

• Prepared Test Plan and strategy
• Design , review and execution of test cases
• Coordinating with different Project Managers for QA schedules
• Worked on database testing approach and guided the team for the different data flow checks
• Involved in System ,Integration and Regression Testing
• Extensively tested Informatica jobs and reports.
• Tested informatica ETL full load and incremental loads by running the workflows
• Defects management using defect tracking tool and worked with cross functional team for early fixes.

Automation Tools: Quality Center
Environment: Informatica, Oracle 9.0, Netezza, Business Objects,DB2, JCL, Maestro, Unix

Confidential, Detroit, MI Jul’07 – Aug ’08 
QA Lead
Projects:
Global Advisor Workbench 
GAWB provides end-to-end solution incorporating OnStar equipped vehicles, wireless and wire line communications, OnStar call center infrastructure including; PBX/ACD, vehicle communications middleware, database applications – including the Advisor (agent) call center desktop application.

• QIC
• GMACFS
• One HR(PeopleSoft)

Responsibilities:

• Involved in Requirements and Design reviews
• Prepared Effort estimates and schedules
• Defining the test plan and strategy for different projects
• Participation in test cases creation, review and execution
• Managed Test lab environment
• Guiding the QA team for System testing, Data base testing, Load Testing and Regression testing.
• Automated test cases for GUI, Functionality and Regression testing using QTP
• Performed regression testing for fixes using QTP and closed the defects in Test Manager
• Tested informatica ETL full load and incremental loads by running the workflows
• Created Test Scenarios and detailed Test Scripts using Load runner
• Quality Center and Performance center Administration
• Managing issues and working with PMs & Developers to get early fixes
• Working with client on UAT effort
• Defects management using defect tracking tool and worked with cross functional team for early fixes
• Conducted QA Process audits for multiple projects

Automation Tools: QTP, Performance Center, Load Runner, Quality Center
Environment: JSP, ASP.net, VB.net, Java, Microsoft Dynamics, Peoplesoft, SQL Server 2005, Oracle, Informatica, DB2,Unix

Confidential, Boise, ID May’ 05 – Jun’ 07
QA Manager 
Rainbow
Rainbow is set of applications which include web and Data Warehousing tools for supporting HP Imaging and Printing group’s operations. 
Responsibilities:

• Prepared Test Plan and strategy
• Design , review and execution of test cases
• Coordinating with different Project Managers for QA schedules
• Involved in System ,Integration and Regression Testing
• Extensively tested Informatica jobs and reports.
• Tested data migration to ensure the integrity of data
• Setup informatica test environment
• Wrote complex SQL queries to validate Target and source data including identification of duplicate records and quality of data based on Mapping/Transformation rules.
• Automated test cases for GUI, Functionality and Regression testing using QTP
• Performed regression testing for fixes using QTP and closed the defects in Test Manager
• Created Recovery Files using Recovery Scenario Manager, associated the recovery scenarios to tests to instruct QTP with specified trigger action on unexpected event/popup.
• Generated automated performance test scripts for load testing using Virtual User Generator
• Supported Web and Informatica Applications such as Usage ,Street Price ,Rocet
• Release management and deployment

Automation Tools: QTP, Load Runner , Test Director,
Environment: Java, Informatica, ASP, JSP, Oracle 9.0, Java, SharePoint, SQL Server 2005, Remedy, Hyperion,Unix

Confidential, Littleton, MA Jan’ 04 – Apr ‘ 05 
QA Lead
Partner Pro 
Partner Pro is global PRM platform that includes core PRM Capabilities such as Partner Management and Profiling. This system helps Business partners manage business more efficiently and effectively over the web. 
Responsibilities:

• Involved in Requirements Gathering and Gap Analysis
• Involved in analyzing System specifications and design documents
• Prepared Effort estimates and schedules
• Prepared test strategy and test plan for multiple projects in the program
• Extensively used check points in QTP fore testing purposes and also performed batch testing
• Worked with Business Analyst extensively for End to End scenarios identification
• Configured Test Server Environment
• Execution of Test Plans and Test Cases for automated testing Setup
• Involved in System, Regression, Integration and UAT Testing
• Reviewed progress of Test Activity with Program Manager on regular basis
• Release management and Deployment planning
• SLA Adherence & Management
• Provided updates and escalations to senior management on a periodic basis

Automation Tools: QTP, Load Runner , Test Director
Environment: ASP, Siebel 7.5, Siebel Analytics , Oracle 9.0, Quest, Test Director, Informatica, Business Objects , Cold Fusion, Java, HP Open View

Confidential Dec’ 02 – Dec’ 03
PIONEER
QA Lead 
Pioneer is a system that supports business process and information requirements across multiple go to market strategies spanning multiple customer interaction channels.
Responsibilities:

• Preparation of the Test Strategy
• Preparation of the Test Plan
• Reviewed System Requirement Specification (SRS) and User Requirement Documents (URD)
• System, Regression, Integration and UAT Testing
• Monitored the schedules with varying Loads and conditions.

Environment: Java , JSP SAP, Oracle 8.1.7, Quest, Tidal

Confidential Apr ‘99 – Jun’ 02
Sr Application Developer
Direct Access/Web INA 
This project is for Citibank’s Direct Access service being offered for Online Banking
Responsibilities:

• Analysis and Design.
• Coding and testing

Environment: ASP, Visual Basic, JavaScript, VB Script, Oracle, NTDS