EXPERIENCE SUMMARY:

• Over Nine years of Experience in both Manual and Automation testing in Client-Server, Data warehouse, Web based and IBM Mainframe Applications.
• Strong experience in analyzing and testing on Finance, Banking and Health Care applications.
• Well acquainted with the Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) of applications.
• Experience in Software Quality Assurance Process Models like RUP, ISO and CMM.
• Competent in Mercury & Rational Automation Testing tools like QTP, WinRunner, Load Runner, Quality Center, Test Director, Rational Robot, Rational Administrator and Rational Test Manager.
• Experience in Preparation and Execution of appropriate business test scenarios based on Functional & Technical Requirements.
• Expertise in implementation of Automation Tests and Manual Tests.
• Involved in Requirement Management, Peer reviews, Inter group coordination and Training Programs.
• Experience in Functional, Grey Box, Stress, Performance, end to end, Regression, Unit, Smoke, Integration, Sanity, GUI, Database and System Testing.
• Experience working in Agile, Waterfall and SCRUM Methodology.
• Good understanding of Netezza database architecture, trained by IBM Netezza.
• Generation of Manual Test Cases and automated them using WinRunner, QTP, Rational Robot for Functionality and Regression Testing.
• Experience in creating and executing test scripts in keyword view and Expert view in QTP.
• Good understanding knowledge of system design and translate requirements into Test Cases.
• Experience in Defect Tracking and Reporting using Test Director, Quality Center, JIRA and Remedy.
• Experience in preparation of Requirement Traceability Matrix, Defect Report and Weekly Status Reports.
• Experience in testing different environments including Java, J2EE, EJB, Java Beans, JSP, .NET, ASP.NET, IBM Mainframe, Unisys, VB Script, ASP, XML, Java Script and SQL.
• Experience in UNIX and Windows platforms.
• Experience in coordinating work on off-shore on site model.
• Extremely dedicated, self motivated and willing to assume responsibility.
• Personal skills include Excellent Communication, strong sense of Organization and Effective Time Management and have the Ability to work in a team as well as independently.

TECHNICAL SKILLS:

Operating Systems : Windows XP/2000/NT/98/95 and UNIX (Linux & Solaris), MAC
Testing Tools : WinRunner, Quick Test Professional, Load Runner, Performance Center, Rational Robot, Rational Rose, Test Director, Test Manager, Requisite Pro, Clear Quest, Clear Case.
ETL Tools : Informatica Power Center/ Power Mart 7.1.4/6.2/5.1,Ab Initio GDE 1.15, 3.0
BI Tools : Cognos, Micro strategy, Business Objects, Crystal Reports
Performance Testing Tool: Load Runner, QA Load
Version Control Tool : VSS, SOS, PWR
Defect Tracking Tools: Quality Center, JIRA, Remedy, Defect Manager, Test Tracker, PVCS
Rational Clear Quest
Languages : C, Java 1.3
RDBMS : Oracle 11, Netezza 6.0.3, MS Access and MS SQL Server 2000
Web Technologies : HTML, VB Script, JavaScript, ASP2.0, Front Page,
Dream Weaver, Flash, Visual Studio.
Data Models : Star schema, Snowflake schema.

EDUCATION:
Master of Sciences.

PROFESSIONAL SUMMARY:

Client: Confidential,NJ Mar 10 –Present
Sr.QA Analyst
Confidential,Institutional Clients Group saw a need to build a single, global platform within Global Markets for trade data capture. Successfully built Global Equity Data Warehouse (GEDW) to cater all regulatory reporting and business intelligence needs. GEDW comprises of Order and Execution trail for one of the most complicated equities trading flows in the world. Successfully managed the regulatory requirements while providing the best analytic abilities for decision support.

Responsibilities:

• Attended walkthroughs for reviewing the software requirements and Test Plan proposal.
• Defined Test Objectives by analyzing the software requirement documents.
• Responsible for Writing Test Plans, Test strategy and Test cases.
• Created Test Plans for Functional testing, Grey Box testing, white box testing, System and Integration testing.
• Created and maintained Traceability Matrix to ensure the coverage of Test Cases is complete.
• Responsible for writing test cases in Quality Center for sanity, regression and performance testing based on the High-level design documents and Technical design documents.
• Executed the test cases and updated the test results in Quality Center.
• Proven analytical skills in executing any assigned task such as creating Test case scenarios and using workarounds to test any given functionality or defect.
• Performed extensive back-end testing and functional testing.
• Involved in testing batch jobs and also jobs run in Autosys.
• Involved in production support testing and validating production issues.
• Conducted database testing using TOAD and SQL PLUS to query the database and validate the data in various database instances.
• Extensively involved in testing PL/SQL stored procedures in Netezza database.
• Performed end to end testing of ETL process for all regulatory reporting for equities including OATS (Order Audit Trail System) and Trader Surveillance
• Performed extensive backend testing by writing sql queries against the database.
• Modified and debugged the scripts used in production environment to be feasible with the test environment.
• Checking the UNIX environments, running jobs and debugging shell scripts.
• Created mock test data to test various test scenarios.
• Checking the log files for bug/issue root cause analysis and reporting the problem areas to the concerned developer.
• Resolved open issues by coordinating with developers and client during QA and UAT testing.
• Worked in Agile environment with close interaction with Development team and BA
• Worked in off-shore on site model to complete the project on time.
• Presenting daily status reports of the testing activities for the day.

Environment: Unix-HP, Oracle 11, QTP 10, Quality Center 10.0,JIRA, TOAD,SQL,Ab Initio GDE 1.15, GDE 3.0, Netezza, Autosys, MS Excel.

Client: Confidential,NC Feb 09 – Mar 10
Sr. ETL Tester
Confidential,introduces program to better align hospitals and physicians to improve quality and patient outcomes, control costs and increase profitability. SendAE ETL is responsible for moving all HOP patients per hospital queued in XFORM database
Responsibilities:

• Involved in Reviewing the Requirement document along with the Business Team and development team.
• Written and executed test cases from Business and Functional Requirements documents.
• Performed Business functionality testing and System integration testing of the application.
• Involved in automating the test scripts utilizing QTP.
• Worked with business and development teams to resolve various requirement issues.
• Responsible for Regression testing after bug fixes and verified the fixes.
• Done load and stress testing for the application using Load Runner.
• Directly worked with the development team and the business team.
• Performed user check-outs, i.e. validating the functionality in Production.
• Extensively involved in functional testing of application.
• Executed SQL queries to evaluate the data in the Front end matches with the data in the Database.
• Performed extensive grey box testing.
• Performed extensive back-end testing by writing SQL queries.
• Involved in testing the Informatica mappings created in Informatica.
• Participate in System Integration testing to UAT turnover meeting.
• Share the System Integration Testing execution status report with the development teams.
• Executed integration, sanity, white box, smoke, functionality, ad-hoc, regression and UAT testing for multiple products usingvariable browser/operating systems.
• Tested the functionality of the application with multiple data including positive and negative data for multiple times.
• Categorized defects based on severity and communicated with developers to resolve them.
• Involved in creating data files in UNIX.
• Verified the Test results and logged the defects using rational tools.
• Done the Quality center admin part like creating new users and providing the user access to the projects.
• Worked in Agile environment, participated in scrum meetings to update the testing status.

Environment:QTP10.0, QualityCenter10.0, .Net, UNIX, Java, SQL, Sharepoint, LoadRunner 8.0, JIRA, Flex SDK 3.4, Oracle 10g, Autosys, Informatica Power center 8.0, Rational Clear case, Rational Robot

Client: Confidential,Washington DC Jun 07 – Jan 09
Sr QA Analyst

• Confidential, has established a Voluntary Data Sharing Agreement (VDSA) with the Centers for Medicare & Medicaid Services (CMS) to perform Medicare entitlement data exchanges for our FEP Members (Federal Employee Program). A VDSA allows the insurer to electronically query CMS for Medicare entitlement information about any covered individuals or dependents that have GHP benefits. Access to this information will tell an insurer when Medicare is the primary payer for non-working covered GHP beneficiaries or their dependents. This mutual data exchange helps to assure that claims will be paid by the appropriate organization at first billing.

Responsibilities:

• Reviewed the Business Requirements document with the business team to understand the functionality of the application.
• Involved in all the phases of Project development Life cycle.
• Prepared the Test Plan and Test Metrics.
• Involved in writing test plan and test cases by reviewing requirements document and use case models.
• Worked closely with Product Management and Development Team to ensure testing is comprehensive.
• Involved in System testing, functional testing and Configuration testing.
• The following methodology was adopted:

i) Test Scripts were created from the business perspective.
ii) Testing was done through different phases i.e. Functional and Regression Testing iii)All bugs identified during the process were submitted using Quality Center.

• Involved in writing customized functions based on the application functionality using QTP.
• Involved in testing the ETL functionality in Informatica.
• Performed Positive, Negative, grey box, black box, white box, regression and integration testing.
• Extensively involved in doing system integration testing using QTP 9.0.
• Developed and executed various Visual Basic scripts using QTP for automated testing of individual functionality & Regression Testing of the applications.
• Maintained log of defects during testing phase.
• Involved in validating the data in UNIX environment.
• Involved in executing Test cases and logged the defects in Quality center.
• Worked closely with development team to fix the defects raised during the testing phase.

Environment: UNIX,.Net, Oracle, QTP 9.2, Linux, SQL, Informatica Power center/ Power mart 8.0, TOAD, PL/SQL, Quality Center9.2.

Client: Confidential,VA Feb 06 – May 07
QA Analyst

Confidential,provides multifamily financing and affordable and market-rate rental housing. Fannie Mae operates nationally, in all multifamily markets and under all economic conditions. Fannie Mae realized the lack of Loan and Property information of same customer being associated to each other. Fannie Mae wanted to build a Housing and Community Development-Core Integrated Database (HCD Core IDB) through which it wanted to bring together all associated Loan and Property details under a single Asset. Data from HCD Core IDB is copied forward to RDW (Reporting Datawarehouse). This enabled Fannie Mae to generate reports across all subject areas.
Responsibilities:

• Analyzed Functional Requirements and Business Requirement Documents to get a better understanding of the system on both functional and business perspectives.
• Involved in creating the Test Plan for the Functional testing and Performance testing.
• Developed Test Cases as per the requirements and specifications.
• Defined Test Objectives by studying the software requirements documents.
• Involved in writing the Test plan and Test Strategy documents.
• Analyzing the process of Application and preparing framework for Automation.
• Managed the overall testing effort, including coordination of testing personnel and test lab resources.
• Created SQL queries in oracle database to retrieve data and to validate the input data.
• Prepared Test data for the inputs of the test cases.
• Performed extensive white box, grey box and black box testing.
• Involved in data ware house testing using ETL tool Ab Initio
• Involved in regression and smoke testing after each build of the application.
• Attended walkthroughs for reviewing the software requirements and Test Plan proposal.
• Created and maintained Traceability Matrix to ensure the coverage of Test Cases is complete.
• Involved in testing the Flat files during the Extraction, transformation and loading process in Ab initio.
• Executed test cases and documented bugs found during the process of testing.

Environment: QTP 9.2, Quality Center9.2, Java, .Net, SQL, Oracle 9i, Clear Quest, Ab Initio GDE 1.14, Load Runner 8.0.

Client: Confidential,NY/TX May 05 – Feb 06
ETL QA Tester

The Customer Profitability project is one of the initial Data Warehouse projects of the worlds leading financial institution of US division’s Commercial Banking and Leasing Group. The Commercial Banking and Leasing Group business has identified this as one of its highest priorities. There was a lack of credible customer information and measurement processes across the entire Commercial Banking and Leasing Group business. Consequently, the business was unable to identify customers, measure customer performance and identify opportunities to improve profitability through customer cross-selling. The Customer Profitability project enabled management to assess overall profitability of client relationships and prospective clients. There are two other projects that are occurring concurrently that the Customer Profitability project is highly dependent upon -- the Customer Hub and Business Intelligence projects.
Responsibilities:

• Reviewed the Business Requirements document with the business team to understand the functionality of the application.
• Actively participated in Code Reviews.
• Automated the test cases using QTP, mapped the automated scripts to the corresponding test cases to do the test coverage.
• Performed load testing according to the scenarios using Load Runner.
• Involved in testing the application using FIX protocol.
• Uploading the Test Cases from Excel Sheet into Test Director.
• Involved in preparing E2E test cases and Regression Testing.
• Developed automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing of the application.
• Performed the White Box and Black Box testing for functionality and structural flow of an application code.
• Responsible for Automation of Test Cases using QTP for performing the GUI Testing.
• Executed SQL Queries to retrieve data from the data base and validate the data.
• Used SQL Server to run Queries and validate from the database.
• Importing and exporting database tables using TOAD and SQLPLUS among different database instances.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.

Environment: UNIX, Test Director,WinRunner,QTP8.2,Oracle, Rational Functional tester, Business Objects,Load Runner,SQL.

Client: Confidential,CA Feb 04 – Apr05
QA Analyst

Confidential,the Farmers Insurance Group of Companies is the country\'s third-largest writer of Life, private passenger automobile and property insurance. Farmers deals with both Commercial and Personal Lines of Insurance. It involves in various insurances like Property and casualty, Group Benefits for Small Business, Large Business The online web enabled integrated system, which can be accessed through Internet and intranet for Farmers underwriters and by producers for Farmers Insurance lines of business. It handles rating scenario’s, reinsurance etc. The different rating scenarios will help compare strategic information such as insurance premium, limits and loss over different policy years etc
Responsibilities:

• Prepared the test plans for the change requirements and enhancement requirements.
• Prepared use cases and test scenarios for the manual and automation testing.
• Modifying the existing Test cases and writing New Test cases based on the BRD and CR\'s.
• Modified the existing QTP Scripts using change requirements documents.
• Mapped the requirements from the Requirements module to the Test Plan module in Test Director.
• Prepared test cases in Test plan module of Test Director.
• Used Test Lab module of Test Director to execute the manual and automated test cases.
• Created the test instances for the project in the Test Lab and Test Plan module of Test Director.
• Moved the test cases from the Test plan to the Test Lab before the test execution Test Director.
• Written the new QTP test scripts based on the new functional specifications.
• Performed regression testing using QTP and generated scripts for functional testing.
• Executed manual test cases and automation test scripts.
• Written the sql queries for the database testing.
• Document test results and report test results using Test Director.
• Conducted Functionality Testing, Regression testing, Retesting and System testing.
• Prepared the test data for the data driven tests and database testing.
• Conducted the GUI and Usability testing.
• Log into production implementation calls and provide support for the respective projects.

Environment: Test Director, QTP, Oracle, SQL, UNIX, TOAD, Java.

Client: Confidential,CA Jun03-Dec 03
SQL Developer Intern
Confidential,is a comprehensive suite of software specifically designed for the changing needs of higher education institutions. It offers the best end-to-end solutions for managing the entire student lifecycle. Campus Solutions provide on-line, self-service tools that enable students, faculty, school staff, and alumni to access and update academic and administrative data such as student enrollment, financial aid, student grades and personal contact information. These tools make school services such as student admission status, registration, loan application, class scheduling, grading, and transcripts.
Responsibilities:

• Created PL/SQL stored procedures for reusability.
• Close interaction with DBA to understand data structures, updates and user supports etc.
• Extracted data from Oracle database and the extracted date is used to populate the Data Warehouse tables.
• Convert the date formats from yymmdd to oracle standard date format.
• Responsible for creating test cases to make the data originating from the source was making it into target properly in the right format.
• Responsible for making sure that data is clean, consistent, and synchronized across platforms.
• Used Rational Robot to perform automated testing of the application.
• Worked closely with Data Analysts team to resolve the defects logged in Test Director

Environment: PeopleSoft 7.0, Rational Robot, Test Director, Oracle 8, Forms 4.5, Reports 2.5, UNIX, Windows 95