Professional Summary ::

• Around 7 years of experience in Automation/Manual Testing.
• Possess good analytical and programming/testing skills with versatility.
• Good team player and task accomplisher against timelines.

Certifications ::

• Certified in Equity Derivative Module ( NSE Certification on Financial Markets )
• Sun certified Java Programmer (SCJP)
• Oracle Certified SQL Expert (OCE)
• Oracle 10g Certified Professional (OCP)

Qualifications ::

• Masters in Computer Science
• Bachelors in Computer Science

Roles and Responsibilities ::

• Prepared Test case and Test Plan reviews
• Performed Functionality testing and Regression Testing
• Tested Java based web applications
• Good experience in using Black box testing for web based applications.
• Well versed in writing PLSQL queries and good understanding of database concepts.
• Good knowledge of SDLC, Agile methodology concepts
• Created reports and involved in defect tracking analysis

Technical Skills ::

Functional testing tools

HP QTP 10.0

Test Management tools

HP QC 10.0

Databases

Oracle 8i-10g

Languages

Java ,C, C++ ,SQL , PL/SQL

Operating systems

Windows 98/NT, 2000, Microsoft Project, XP,Linux

Projects ::

Investment Tracking System

Organization

Confidential,Hartford,CT

Role

Duration

Description :

Confidential has three lines of business - Single-Family, Multifamily and Capital Markets - that provide services and products to lenders and a broad range of housing partners

Investment Tracking System allows Investment Managers to maintain stocks and fund portfolio investments for their investors. This system also has the feature of investing in Capital Market by providing options like Bonds, securities to their investors, also they can sell those bonds to others in trading market for affordable price. This system allows the user to create new accounts, update account information, add/modify transaction information. The system also provides Search and Reporting functionality. The investment information is stored in Oracle database. The application was built and deployed on Cold Fusion Web Application Server. 

Contribution :

• Participated in review of functional and planning Test strategies
• Wrote test plans, scenarios, scripts and test cases based on the business requirements in Quality Center
• Performed regression and user acceptance testing.
• Maintained Test plan document, RTM in Quality Center
• Identified software errors and interacted with developers to resolve issues.
• Parameterized automation scripts in Quick Test Pro to test the multiple sets of data.
• Enhanced Quick Test Pro scripts by using different check Points.
• Provided weekly management status reports and coordinated meetings between test team and development team to review defects.
• Performed functional testing, user interface testing and user acceptance testing.
• Performed back-end testing using SQL queries to validate the data in the database.
• Defect logging, Issue Tracking and Status Reporting
• Review the bug fixes and retest and updated the same in Quality Center.
• Established quality metrics and reported progress on a daily basis.

Online Banking Application

Organization

Confidential,Hartford,CT

Role

Duration

Description :

The online banking application was developed for the customers to enable them to manage their finances through internet and perform various transactions like accessing personal accounts, checking account balances, payment of recurring bills, such as mortgages and loan payments, transfer funds, and other products and services. The application has different modules such as online banking, online insurance, and online mortgage.
Each of the modules stated above provides different features to the bank customers as well as non-customers. Non-customers can apply for and get the rates for any type of insurance given by the bank and also apply for the home mortgage. One can find out about the interest rate for the home mortgage before getting the mortgage approved. Also, one can apply for the credit card and can find out if they have been approved within sixty to ninety seconds

Contribution :

• Involved to create Business Risk Levels to determine Test Priorities.
• Analyzed Test Plans and Test Cases based on Requirements and General Design Documents involved in both Manual and Automation Testing.
• Performed negative testing ,boundary value analysis as per the functional requirements
• Performed Regression testing using QTP.
• Extensively used SQL Queries to verify and validate the Database Updates.
• Created User Defined Functions in QTP Functions Library to re-use them in different tests.
• Used Clear Quest for Defect tracking, monitoring the bugs and reporting.
• Performed bug retest and involved in issue tracking
• Participated in test case review meetings and requirements walkthroughs.
• Responsible for Reviews and documentation for reporting the status to the project manager.
  

Payment Handling

Organization

Confidential, Bethesda, MD

Role

Duration

Description :

Confidential delivers development. : many of the world\'s most demanding environments, by integrating a broad range of disciplines.

The Payment Handling component handles the incoming payments and disbursements of a particular payment transaction. There are different types of payments that are taken into account, electronic, payments over the phone, internet payments, disbursement of the payment once the transaction is accepted. Once a payment is initiated different transactions such as acceptance, reversal, refund and cancellations occur on the transaction.

Contribution :

• Developed test plans and test cases using requirements documents in Test Director.
• Automated the functionality and interface testing of application using Quick Test Professional (QTP).
• Involved in black box testing and regression testing
• Maintained Test plans and the results in Quality Center(QC)
• Documented and reported defects to developers using Test Director.
• Used checkpoints to check properties of various objects using QTP.
• Checked for the broken links using Quick Test Pro.
• Used verification points and conducted data driven testing with test data sets and verified the contents using Quick Test Pro.
• Performed regression testing and user acceptance testing.
• Used Test Director for bug tracking and maintaining test documents.
• Checked the data flow by using SQL queries to extract the data flow from the database.

Confidential Advanced Test Automation Framework Solutions

Organization

Role

Duration

Description :

Confidential advanced test automation framework is a hybrid framework which is application independent, effective and ideal that is developed and being used in US. An excel macro tool was developed in order to generate test data, which is required for automation script execution. At a high level, the uniqueness of test automation suite lies in the test data definition and generation approach. Various combinations of business scenarios of the application can be tested based on the test data generation using the test data macro generation tool. This framework and the macro generation tool for test data are unique to Confidential. Functional Test automation framework is a hybrid framework designed to accomplish functionality and GUI Testing needs. The advantage of this framework is its modularity, reusability and maintainability. It is a set of assumptions, concepts, and practices that provide support for automated software testing. This test automation framework is a collection of procedures and function libraries. These form part of any functionality test automation framework. When the specific artifacts are generated and plugged-in to the framework, then the framework becomes ready/enabled to execute the regression testing. This test automation framework has unique features that makes easy to maintain and with minimum modification the framework can be used for testing different applications

Contribution :

• Identification, selection and evaluation of the key characteristics of Confidential Advanced Test Automation
• Process and Problem Analysis Risk Analysis Loss Function, Statistical Variation Analysis, Historical Data Analysis, and Case Studies etc);
• Participated in designing plans and assigning resources to the task and monitoring them using Quality Center
• Involved in creating groups and monitoring the user access using Quality Center
• Optimize the key process parameters
• Studying DTCC financial applications modules
• Development of proof of concepts;
• Implementation of Advanced Test Automation Framework solutions and release coordination
• Report generation
• Test the workflow Lifecycle, Document technical design specifications and conduct diagnostic and evaluation testing etc

Reference Data Collection

Organization

Role

Duration

Description :

DTCC is working with regulators, market participants and industry bodies such as ISDA to provide greater transparency into the derivatives market. We are working with two levels of transparency-our service for the public and for regulators. In regard to public, DTCC publishes data on their site with key information on position sizes across different exposures, CDS indices, top names for single positions and more. This will help in boosting the market confidence and helps investors understand the depth of these markets. Broadly we are working with three regulators namely Banking supervisors, Market Regulator and Central Bank regulators. The bottom line is confidence in the market. Regulators always had access to this information from individual regulated entities and markets. We are assisting regulators more easily access accurate information in a useful format on a timely basis

Contribution :

• Prepared the test scenarios and test cases
• Guided and Coordinated the offshore team related to this project
• Active participation in process related activities like PSR, CAM, Metrics, Internal Audit, Sub Processes
• Review of test scenarios and test cases prepared within team members
• Test Approach preparation as part of test plan
• As a part of regression tested all the functionalities of previous phases
• Test Cycle Summary and Test Cycles updating in test plan
• Test case Results updating for all the passes (Pass1, Pass2, Pass3) in test plan
• Reporting Test Cycles Statistics to onsite team on daily basis
• Post Test Report preparation at the end of system integration testing
• Providing Training to new resource
• Query Clarification with respect to any functionalities to the team members
• Defect logging and Reporting
• Issue Tracking and Status Reporting
• Review the bug fixes

Copper Reporting

Organization

Role

Duration

Description :

Industry regulators have focused attention on the quality of data that is available from universal reporting of non-electronically confirmable transactions that began in the recent copper releases. Although all OMG firms are currently submitting. One focus of regulator attention is on the usefulness on the data in assessing systemic risk given limited information in the reports. In addition to few fields, the absence of common identifies leads to many broad assumptions in the preparation of reports. The major functionality of this project is to enhance the data in those records. To improve transparency, additional fields will be added and some fields will be modified.

Contribution :

• Understanding of Functional Specification and analysis
• Coordination with onsite team by attending onsite calls
• Preparation of Test Scenarios and Test Cases for System Integration Testing
• Prepared Test data for verifying different scenarios
• Execution of Test Cases for System Integration Testing
• Defect logging and Reporting
• Issue Tracking and Status Reporting

EOD Processing and Adhoc Reporting

Organization

Role

Duration

Description :

The TIW (Trade Information Warehouse) have a concept of an end-of-day (EOD) that delineates positions ‘as of’ a certain day. Trades are continually received throughout the day from the confirmation service and other than the Full TRI reports, there is not a stored set of data that can be used for various reporting functions. Requests for Warehouse positions as of a certain day is increasingly becoming more important for service providers, regulators, clearers, and other interested parties for reconciliation and market risk exposure identification. In order to provide this snapshot of information for any given day, the information needs to be stored and referenced centrally to ensure requests for the last confirmed positions for a specific day x is fixed, accurate and consistent on all output mediums. This project outlines the data set and requisite Warehouse jobs that feed into an EOD snapshot for Warehouse. This project will focus on the automated regularly scheduled provision of the required data to the Data Reporting group to streamline the process of creating Ad Hoc reports.

Contribution :

• Test case preparation &Execution.
• Involved in creating manual test cases.
• Prepared Test data
• Preparing and maintaining reports related to testing activities as per the organization standards.
• Coordinated with onsite team
• Reported defects for my module