Professional Summary:

• Over 7+ years of experience in IT as Quality Assurance Analyst. Proficient in Manual/Automation Testing of Client/Server and Web based applications using HP ALM(Application Life cycle Management), Quick Test Pro
• Domain competency includes finance, mortgage and Insurance sectors.
• Expertise in writing Test Plans, Test Strategies, Test Cases, Test Scripts, Test Scenarios, Test Reports and Defect Metrics.
• Scripting and test automation using QTP.
• Possess excellent skills in Bug Reporting using Test Director
• Involvement in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model and Agile methodologies.
• Strong understanding of QA Principles, QA Process, Use Cases, and Software Development Life Cycle
• Having Good Knowledge in Object Oriented Design and Analysis (OOAD).
• Used Test Director for test documentation management and defect tracking
• Extensive experience in developing Test Procedures and Test Strategy for Web and Client/Server applications.
• Interacted with the developers on various technical issues and resolved the reported bugs.
• Excellent understanding of the Software Development Life Cycle and role of QA
• Excellent skills in client relationship management, interaction with business partners, subject matter experts, portfolio architects and technology partners
• Worked with all stages of testing namely Unit Testing, Integration Testing, System Testing and User Acceptance testing manually as well as using automated test tools
• Back-end testing using SQL, PL-SQL, Oracle.
• Well versed in testing Methodologies, Web testing, Product Development cycles and software Deployment/Release processes.
• Very Strong skills, including the use of nested table expressions, unions, Multi-table joins and outer joins
• Supported the defect resolution process by prioritizing the severity level of defects.
• Self Motivated, Team Oriented with ability to handle multiple tasks and efficient in meeting deadlines.
• Participation in design reviews with the Development team
• Good team player and have ability to work independently
• Possess excellent communication skills along with verbal and written skills

Technical Skills:
Languages
C, C++, Java, J2EE, VB, COBOL, C#, .Net, ASP.Net
OS/Network
MS-DOS, UNIX, Linux, Mac, Windows 2003/XP/NT/Vista
Testing Tools
Quick Test Pro 10, Quality Center 11(ALM)/Test Director 7.x, TAO, Load Runner 9.0, Win Runner, Rational Clear Quest, Clear Case, Rational Test Manager, Rational Functional Tester, Rational Manual Tester, Doors
Databases/ETL
Oracle 9i/10g, SQL, PL/SQL, DB2, TOAD, ODBC, MS-Access and SQL Server 2005,OBIEE,Ab Initio GDE 1.13/1.14
Web/Protocols
HTML, DHTML, PHP, HTTP, SOA, SOAP, SOAP UI, XSL, XSLT, XML Spy, UDDI, WSDL, CSS, XML, ASP and JSP.
Scripting Languages
VB script, Java script, AJAX, Perl Script and Shell script
Min Frames
TSYS-TS2,MVS,CICS,
Professional Experience:
Confidential, VA
Role: Senior QA Analyst
Confidential is a web based application accessible to both internal and external users to support CTM in setting up Single-Family Credit Enhancement agreements and administering them in an efficient and controlled environment. Key CTM responsibilities include: Coordinate with the deal makers (e.g., Risk Managers, Customer Account Managers, and Credit Transaction Managers), and with Counterparties, to set up Credit Enhancements on our systems, once agreements are negotiated and executed. Administer Credit Enhancements. Track and report the status of Credit Enhancements. Forward key data to interface systems for further processing and analysis (e.g., General Ledger and Relational Database Warehouse).
Roles and Responsibilities:

• Identifying business requirements, process improvements and new processes.
• Coordinated with the business partners in conducting System Testing.
• Performed Functional Testing and Regression Testing
• Worked closely with Business and Development team to clarify requirements and resolve defects.
• Troubleshoot the system error using log files
• Defect Management – Opening, closing the defects using Clear Quest.
• Extensively used SQL queries to test backend data and data validation.
• Used QTP for automating the testing scenarios using Business Components. Included SQL queries in the QTP scripts to verify data in the source databases and also the reports generated with the data during the testing process.
• Review and analyze source data, data flows, validate mapping specifications and business rules from data source to target
• Develop SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data within an ETL process testing cycle.
• Extensively worked on backend testing using simple and complex SQL Queries, to validate the data loaded from legacy systems, data on outbound files, and interfaces.
• Extensively worked on UNIX to restart the UI and Web services
• Participated in SIT and UAT reviews and provided support to testing team and UAT team.
• Creating the Metrics and monitoring the System Test activities.
• Experience in using Quality Center (ALM) for maintaining QTP scripts.
• Responsible for creating Requirements Traceability Matrix using Quality Center and Doors for all releases.
• Responsible for creating Test data and documenting Test results and checking them in clear case.
• Participated in System Test reviews.

Environment: Java Script, VB Script, Sybase , XML, Web Logic, Java Web Server, Quality Center 11(ALM), QTP 11, Clear Case, Clear Quest, DOORS, Oracle, PL/SQL,TOAD 7.5,Unix,Humming Bird,WinScp,Remedy
Confidential , MD
Role: QA Lead
Description: The Confidential is used to order animals for research purposes. The investigators on behalf of researchers from ICs across the NIH order the animals. The system, a component of the Administrative Database (ADB), was written using legacy technologies such as COBOL and IMS and runs on an IBM Mainframe computer. CAPS interfaces with several internal and external systems. Those interfaces allow for the complete processing of the animal procurement and vendor invoices, reconciliation of the General Ledger in NBS, and billing the ICs. This document outlines the design for modernizing CAPS and migrating it to a web based system which has its own data in Oracle and streamlining the interfaces with NBS and other systems such as nVision.
Roles and Responsibilities:

• Review requirement documents ,functional specifications, and involved in preparing Test Plan document
• Actively Participating in Scrum meetings, Reviews and developed test scenarios.
• Working in Agile Development Environment with frequently changing requirements.
• Performed Back end testing by writing SQL statements using TOAD.
• Generated Reports in Front end and validated Reports in Backend to ensure data integrity and validate Business rules.
• Maintained Traceability Matrix to track the requirements to the test cases to ensure complete test coverage in the Mercury Quality Center.
• Clearly communicated defects with developers and updated comments in Mercury Quality center.
• Involved in testing Web Services and XML using SOAP UI in order to interact with OPE(Oracle Project Enhancements)
• Participated in System Test ,User Acceptance Review

Environment: Oracle E-Business Suite, Oracle Application Express (APEX), Oracle, PL/SQL, TOAD, Quality Center

Confidential
Role: Senior QA Analyst

• Description: The Servicer/Investor Reporting(S/IR) System is the system of record for Single Family Servicing Book of Business. The system represents 18.4 million loans and their corresponding pools/pool pieces (627,193 pool pieces).S/IR performs the following activities:
• Maintenance of our loan and pool servicing book of business.
• Disclosure generation for all MBS pools, including Multi-Family and MEGA’s
• Management of loan level Sub-Ledger and auto reconciliation to General Ledger.
• Automation of Cash Management as related to payments and disbursements of MBS and Cash Loans.

Roles and Responsibilities:

• Identifying business requirements, process improvements and new processes.
• Coordinated with the business partners in conducting System Testing.
• Performed Functional Testing and Regression Testing
• Worked closely with Business and Development team to clarify requirements and resolve defects.
• Troubleshoot the system error using log files.
• Defect Management – Opening, closing the defects using Clear Quest.
• Extensively used SQL queries to test backend data and data validation.
• Used QTP for automating the testing scenarios using Business Components. Included SQL queries in the QTP scripts to verify data in the source databases and also the reports generated with the data during the testing process.
• Review and analyze source data, data flows, validate mapping specifications and business rules from data source to target
• Develop SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data within an ETL process testing cycle.
• Extensively worked on backend testing using simple and complex SQL Queries, to validate the data loaded from legacy systems, data on outbound files, SIR Business Reports, Exports and interaces.
• Extraction, Transformation and Loading was done using different Components and different expressions using Ab Initio to create test data for system testing.
• Extensively worked on UNIX to restart the UI and Web services.
• Participated in SIT and UAT reviews and provided support to testing team and UAT team.
• Involved in writing test cases and executing them for modules like Loan Payment Processing, FS (Financial Services), Book and Tax Accounting, Cash Processing, Cash Recon.
• Creating the Metrics and monitoring the System Test activities.
• Experience in using Quality Center (ALM) for maintaining QTP scripts.
• Responsible for creating Requirements Traceability Matrix using Quality Center and Doors for all releases.
• Responsible for creating Test data and documenting Test results and checking them in clear case.
• Participated in System Test reviews.

Environment: Java Script, VB Script, AbInitio (GDE 1.15), XML, Web Logic, Java Web Server, Quality Center 11(ALM), QTP 11, Clear Case, Clear Quest, DOORS, Oracle, PL/SQL,TOAD 7.5,Unix,Humming Bird,WinScp,Remedy

Confidential
Role: BI Tester
Description: Confidential is a single, integrated enterprise-wide source for financial and project related data. It includes re-implementation of Oracle Financials and Oracle Procurement and the implementation of Oracle Projects. Project 1 includes the implementation of Oracle Business Intelligence Enterprise Edition (OBIEE) to support data ware housing, reporting capabilities for dashboards, adhoc query, alerts and data downloading into standard desktop tools
Roles and Responsibilities:

• Involved in BI Report Testing using Oracle SQL Developer.
• Supported the entire Testing Phase of the project by creating and executing manual test cases to support OBIEE.
• Developed Test Cases via business Report Specs, Report layouts, Test plan, request a review approval from Manager.
• Used Quality Center, MS Word and Excel to create the test plan, test cases and RTM.
• Performed System Testing, Integrating testing, End to End Testing.
• Involved in Adhoc Query Testing, Report testing and validating the data for FIN-AP(Account Payable),Fin GL(General Ledger) and PA(Project Analytics)
• Validated the reports by writing SQL Queries using Joins, Case Statements.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document.
• Logged the defects in EBSS Defect Log and tracked them through Resolution.
• Categorized bugs based on the severity and interacted with developers to resolve them.
• Created test results, reports/metrics for Project Management and Quality Services teams.
• Interacted with all the project team members to report daily testing status, identify and escalate critical issues and risks.
• Actively attended meetings with fellow testers and other groups to evaluate the progress and performance of the application.

Environment: OBIEE, Quality Center 10.0, Oracle SQL Developer, Microsoft Office Tools, Share Point, Unix, Ab Initio GDE 1.13/1.14, EBSS Defect Log.
Confidential, VA
Confidential mission is to create, load, and maintain test data for use in functionality and system performance testing. Test data may be created from scratch or queried and extracted from production and then sanitized per data policies. Test Data Management team will provide Test Data to Various Testing Teams in Capital One. TDM will Create New Data and preconditions the existing data as per the requirements provided by Testing Teams, using which they will execute their Test cases.
Role and Responsibilities:

• Interacted with Different Testing Teams and Gathered the Test Data Requirements.
• Developed test cases collaboratively with other testers to test the functional requirements.
• Attended various meetings with Business Customers and Support Teams.
• Used Mercury Quality Center for updating the status of all the test cases & test scripts that are executed during testing process.
• Involved In Data Creation and Data Conditioning.
• Created and conditioned Test Data in TSYS TS2,Prophit and Vault Center by Excel Macros
• Used QTP for modifying and comparing data in Excel files and used for running Excel Macros in background.
• Extensively worked with Excel Macros to create and conditioning Test data and for posting transactions.
• Maintained and Retrieved Test Data using TA Web and DB2(QMF)
• Used Clear Quest and HP Service Desk to track the Test Data Requests.
• Extensively worked on Quick Test Pro to run Automation VB scripts for Test Data Conditioning.
• Worked closely with Testers and QA Managers to resolve issues.
• Tracked defects and bugs using Quality Center and maintained the bug reports.
• Experience with setup of Test Data for Regression Testing for various teams like prophit, Probe, Training, Core Billing, EOS, RTM, Performance Testing, Cordiant and Offer Management.
• Experience Master Card and Visa Simulators to simulate Authorizations based on given specifications.
• Extensively worked on UNIX in order to transfer the files from Count Server to Grover server.
• Extensively used multi file commands in Unix Environment in order to validate the data.
• Experience with Vault Center Application for maintaining Rewards.
• Experience in using Quality Center for maintaining QTP scripts.
• Attend daily meetings to update status on various requests

Environment: TSYS TS2, Quality Center, Quick Test Professional 9.0 , Rational Clear Quest, TA Web , QMF, MS Access, HP Service Desk, Unix, Microsoft Office Tools.
Confidential
Role: QA Analyst
Description: This project will expand several key card-marketing capabilities that will drive additional revenue and bridge a competitive gap. Bank of America consumer card currently processes on TSYS, which provides unlimited balance categories at the account level. The existing disclosure infrastructure only supports fifty promotional offers across the portfolio at any given time. Legacy MBNA currently has the capability to support 999 promotional offers per month; and is constrained at the account level to four balance categories. Therefore, pricing flexibility is limited because the four existing balance categories are static and every transaction within a balance category receives the same treatment.
Roles and Responsibilities:

• Identifying the business needs of client and thus proposing them for the new requirements or changed in define requirements.
• Used TSYS application in order to enter the new customer information.
• Involved in Data analysis and back end testing by executing shell scripts to lead data from TSYS source
• Involved in design of Test Plan and Test cases based on the Use cases. Involved in Documenting the Test Plan that defines the Test environment, Testing Scope, Phases of Testing, Environment Validity Analysis, Test Case Inventory, Test Data, Entrance and Exit criteria, Roles and Responsibilities
• Involved in back-end testing by executing Shell scripts to load data from source and validating the data using SQL scripts.
• Used SQL developer to run SQL queries to get test data for various test cases.
• Prepared Expected data in TSYS.
• Involved in writing and executing the Test Cases for Data Validation which involves in testing accuracy of data which is migrated to the target database
• Used Quality Center defect tracking tool to report application defects and enhancements request and discussed with developers to resolve technical issues. Reported the defects to the development team using Quality Center.
• Involved in UAT Testing.
• Involved in documenting RTMs and Test Results.
• Responsibilities include meeting with the Data Architects, Business Analysts to determine Requirements and goals.
• Experience in data validation after running jobs in UNIX environment.
• Used Clear case as the version control tool, to store documents.
• Determined the test strategies based on requirements and architecture
• As a Lead was involved in QA reviews like Peer Review and Functional Review, WALKTHROUGH and audits during Software Development Life cycle
• Coordinated with the development teams to enhance the scalability, performance and tuning of the application.

Environment: Mainframe 3270 and DB2, Quality Center (9.2), SQL, Clear Quest, Clear Case, Doors, UNIX
Confidential , CA
Role: QA Tester
Project: Contract Administration Database
Description: This is a Web based portal which offers whole life, universal life, interest sensitive whole life, survivor life, and term-like life insurance. It includes an agent locator and online quotes with web pages and HTML pages. As a QA consultant was working with management and customers to evaluate alternative procedural and systematic solutions, on a Web-based e-commerce application accessed by potential customers and agents.
Responsibilities:

• Involved in Requirement Analysis, Design Analysis.
• Used Quality Center for Requirements management.
• Analyzed the Requirements and Design documents for the testability.
• Developed & maintained the traceability matrix between requirements and gap analysis.
• Used Serena Dimensions for Requirement and Design Document management.
• Developed test cases for Enrollment, Letters and Reports applications in Quality Center.
• Validated various extracts created on the Mainframe by using File Aid which are sent to the vendor.
• Created Groups and enrolled subscribers in them and validated the Billing Summary generated in the Billing application.
• Validated ID Cards generated for Group Subscribers and Individual Subscribers.
• Validated HIPAA Certificates generated upon termination of a group/subscriber.
• Worked extensively on UNIX servers, UNIX commands.
• Involved in working with files and programs in UNIX.
• Involved in doing installations on servers.
• Extensively worked on UNIX to run shell scripts for weekly jobs.
• Logged defects in Quality Center and tracked them through resolution.
• Used SQL Developer to run SQL queries to get test data for various test cases.
• Extensively Used SQL to validate backend database changes, deletes and update.
• Wrote SQL statements to extract data from the Tables.
• Coordinated User Acceptance Testing and provided the test data needed to business users by running queries on Facets database

Environment: Mercury Quality Center 9.0, Mainframes, File Aid, TRMS, Serena Dimensions, UNIX, Oracle, SQL, Rapid SQL, Advanced SQL, SQL Developer, MS Office.

Confidential, FL
Project: Online Banking System
Role: QA Tester
The Confidential option on the web site enables the customers to access their accounts with the bank via the Internet. All the account holders need to do is enter their User ID and their selected password. This enables them to check their current balances with the bank. The customers are also provided the service of instant transfer of funds between their Checking and Savings Accounts. It also allows the customers to Invest Online. The Customers can also pay their Bills using the Online Banking Services provided by Bank United. The fundamental goal of the project was to enhance the entire Insight product line to be more robust in the current global market segments
Responsibilities:

• Worked with Business analysis team to prepare a detailed Business Requirement document.
• Primarily responsible for interaction with clients to identify requirements and determine the impacts to the various business areas.
• Extensively performed Functional Testing, Regression Testing and UAT Testing.
• Assist Business users with UAT Testing. Involved in documenting Test cases, Test Plans and executing the test cases.
• Responsibilities include meeting with Data Architects, Business Analysts to determine requirements and goals.
• Involved in creating test data/expected results to match actual results.
• Responsible for creating Datasheets/Test data and documenting test results to meet SDLC standards and RTM.
• Worked closely with the development team to clarify system requirements.
• Execute shell scripts to load data. Run SQL queries to check if the data is loaded correctly into database.
• Participated in QA reviews like peer review and walk through during Software Development Life cycle.

Environment: Windows XP, SQL, UNIX, Test Director, Microsoft Excel.