OBJECTIVE
To seek an increasingly responsible position as Quality Assurance Analyst/Tester in Software Testing & Quality Assurance

TECHNICAL EXPERTISE:

• More than 6 years of experience in Software Quality Testing, Analysis and Design; worked with various firms to develop QA methodologies, test development and execution, verified and validated application software in web-based, client-server and data warehouse environments for medium to large projects in major industries like Banking, corporate Actions and hedge funds.
• Hands on experience in testing data warehouse projects using databases like SQL Server and Oracle and ETL tools like SSIS and Informatica Powercenter; Reporting and Analysis tools likeSSRS,SSAS.
• Complete understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and test methodologies.
• Proficient in writing SQL queries.
• Proficient in writing, modifying automated scripts using VBscript and executing the automated tests with QTP.
• Have good experience in testing using v-model and agile methodologies.
• Expertise in performing different types of Testing: Functional, Integration, System, database, Regression, Smoke, Negative and Adhoc.
• Proficient in HP Quality center for test designing, requirements mapping, reports, test execution and defect tracking.
• Possess specific experience in creating defects in Serena Team track, Jira.
• Proficient in writing test plans, test analysis, test cases, test procedures and test scripts.
• Experience in cost and duration estimation of new CR (Change request).
• Coordinated with different teams like Development, Production Support, Business Analysts, and third party vendors etc.
• Have hands on experience in using Lotus Notes, Citrix and MS-Outlook
• Have good understanding of different ETL transformations in SSIS and Informatica Powercenter; and reporting using SSRS
• Experience in working in Onsite-Offshore model and lead the offshore team.
• Good Understanding Data warehouse concepts.
• Highly motivated team player with good interpersonal and communication skills.
• Trained on Mainframe technologies.

Certifications:

• ISTQB CTAL-TA (Certified Tester Advanced Level-Test Analyst)
• ISTQB CTFL (Certified Tester Foundation Level)
• Software Testing certification from Brainbench (Transcript #6780358)
• Certified QTP professional
• QC Certification

EDUCATION:
Bachelor of Technology in Computer Science and Engineering

SOFTWARE SKILLS: 
Testing tools : QTP, HP Quality Center, Mercury Test Director, Serena Team Track, and JIRA.
Databases and frontend tools : SQL server, Oracle, Toad, SQL Developer, SQL *Plus, DB2.
ETL tools : SSIS, Informatica.
Reporting and Analysis tools : SSRS, SSAS
Operating Systems : Windows, basic UNIX
Programming Languages : COBOL & JCL.
Front End : HTML, JavaScript, VB Script, XML and CICS.
Packages : MS Excel, MS Word.

PROFESSIONAL EXPERIENCE:

Confidential Jul ’10 to Till Date
QA Analyst

Confidential is an investment management organization with offices and principal financial centers around the world. The client wanted to start the Central Data warehouse to meet its analytical reporting and decision support requirements. The Main objective of the CDW is to Increase business efficiency through a centralized global view of holdings, transactions and trade and facilitate global exposure analysis, global compliance etc. Increase Data Quality by centralized data quality monitoring and understand the different source systems that reside on diverse platforms.

Responsibilities:

• Prepared Test Analysis and involved in preparing Test Plan document.
• Written functional and regression test cases and loaded them into Quality center.
• Verified and validated the Extract, Transform and load logic on the destination/target tables using SQL queries.
• Used the Quality Centre as a Test Management Tool for Test case execution, bug reporting and tracking.
• Raised JIRA logs for the third party application defects.
• Testing the interface files/tables between different applications to make sure all interfaces are working as expected.
• Prepared Test Schedule with 3rd party organization and verified the data sent and received from 3rd party organizations.
• Written traceability matrix to verify the all requirements are tested.
• Prepared estimates of Change Requests for new and amended functionality.
• Generated test data using stored procedures according to the specific conditions to test the functionality.
• Did functional and interface testing with different applications, domestic and International ABMs and POS machines and also performed GUI testing, end-to-end testing and negative testing.
• Assigning work to offshore team and reviewing the work done by them.
• Constant Communication with the Development and BA teams.
• Coordinated with the offshore team regarding the requirements and changes, allocated work to the offshore.

Environment: HP Quality Center 9.0, Oracle, DB2, Informatica, CICS, Windows XP, Test lab with ABM and POS machines, Citrix Presentation Server

Confidential May ’09 to June ‘10
QA Analyst

Confidential provides banking and financial services to its customers in various countries. 
Symphony project is to design and build a data warehouse for query & analysis purpose to take effective decisions and analyzes the business. Data was extracted from different front end applications transformed and loaded to Warehouse.

Responsibilities:

• Worked on manual testing and automation testing using QC and QTP for functional testing, system testing, and regression testing and negative testing.
• Formulated detailed Test Plan, Test Cases and Testing Procedures which included Test Cases/Scripts, capturing Test Results.
• Tested the workflows and packages in SSIS.
• Written SQL queries and Stored procedures.
• Tested SSRS generated reports, SSAS cubes and verified data structure in SQL Server tables.
• Developed and modified Hybrid automation framework and identified naming conventions, script templates, scripting guidelines and results reporting.
• Involved in analyzing the source data coming from different data sources.
• Coordinated Defect Review meetings to ensure that quality is not compromised. Designed workflows in Quality Center for the requirements, Test Plan and Defects module.
• Used QTP to automate the testing of applications. Developed scripts using VB Script in Expert View.
• Executed automated scripts using QC and QTP as a batch, reviewed and reported the results.
• Prepared the documents for the Production support to perform their tasks to achieve and enhance their Quality of Service.

Test Environment: Windows XP and server 2003, SQL Server Management studio, BIDS, HP QC 9.2, and QTP 9.2.

Confidential Jan ’08 to Apr ‘09
QA Analyst

Confidential is one of the leading providers for financial electronic commerce services and products. Event is Corporate Action processing system that enables Custodians, Brokers/Dealers, investment houses, fund managers, and third party administrators to minimize the risk of handling CAs. It is implemented to automate the entire CA process. TradeFlow is a product for Investment managers to keep track of the post trade transactions between themselves, brokers and all involved parties. The product is configurable and takes care of matching the trades after the deal is reached.

Responsibilities:

• Analyzed functional requirements developed and executed Manual test cases.
• Written SQL queries to validate the data loaded into the destination tables.
• Created test cases and performed Black box testing and regression testing of the application.
• Created test scripts using VB Script for keyword driven framework to automate the testing of application.
• Processing different types of input files like CSV, txt, XML.
• Used Serena team track as Defect management tool to raise and track defects.
• Documented test results, identifying and summarizing discrepancies.
• Presented progress of the testing process at walkthroughs and inspections.
• After the User Acceptance Testing process, interacted with the user groups regarding existing defect(s) status/resolution.

Test Environment: Windows XP, SQL Server, Serena Team Track, QTP, VB Script, and XML.

Confidential Oct ’06 to Dec ‘07
QA Analyst

Confidential is a product for Administrators of Hedge Fund management which maintains all the details of Investors, Investment managers, Funds and Fees (Incentive, Management and Administrative fees etc). It produces the report of all the funds Investor, Fund Value, Investment Manger, Fees given, Profit etc.
The product is to automate the accounting and reporting processes, which earlier was time consuming due to manual interference.

Responsibilities:

• Understand the requirements and track the requirement changes in the test cases to ensure that each of the requirements gets mapped to a test case.
• Prepared high level test cases/scenarios to cover each requirement.
• Designed Template test cases to reduce the redundancy of steps in test cases.
• Prepared Traceability matrix to ensure all requirements are mapped to Test cases.
• Design, Developed and Executed Test cases for performing System, Regression and Functional Testing.
• Written SQL queries to test the data in tables to verify the data loaded into the database from front end correctly.
• Participated in walkthroughs and reviews with designers and developers to ensure that all the test scenarios are covered.
• Used Test Director and Quality center to execute Test cases, report and validate the defects.
• Analyzed and Documented test results.

Test Environment: Oracle, Windows XP, Mercury Quality Centre

Confidential May ’06 to Sep ‘07
Developer

Confidential . The purpose of Retail Project is automating the process right from processing department to sales department. The module involves maintaining the details of warehouse and taking the requests from different departments, maintaining the infrastructure and generating reports. 
Responsibilities:

• Analysis of the specifications provided by the client to understand the requirements.
• Prepared SRS (System Requirement Specification) and Database design documents.
• Application development using COBOL, JCL and CICS.
• Resolving the defects in Remedy and adhering to the SLA.
• Created and managed Database using DB2.
• Performed Unit testing & integration testing.

Key Technologies : COBOL, Remedy, DB2, CICS, JCL.
Application Deployment Environment : OS/2, Windows XP.