Professional Summary

• 6 years of experience in testing software applications with major emphasis on products related to Banking domain, Insurance domain and Quality Assurance activities using Manual and Automated testing procedures and ETL Testing.
• Experienced in System, Functional, Regression, Integration, Performance, Stress ,User Acceptance Testing (UAT) and database testing
• Strong experience in Test Methodologies, Browser Based Web testing, performance testing Data Migration testing, Application testing (in web environment), Cross Browser testing ,Client Server testing and Database testing.
• Extensive testing experience in all phases of testing life cycle (Integration Testing, Regression Testing, Functional Testing, System Testing, Risk based testing, Load Testing, Adhoc testing and UI Testing)
• Good knowledge on database concepts (RDBMS), writing SQL queries and PL/SQL statements to check for data integrity
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution
• Expertise in Mercury Test Director, HP Quality Center, Load Runner, Win Runner and QTP
• Good knowledge of Informatica for ETL Testing
• Proficient in QTP Script Language, check points, parameterization (Data-Driven test)
• Good Scripting Knowledge of Shell and VB
• Responsible for the whole test life cycle including review and analysis of test basis documentation, business requirements, technical specifications, use cases, user stories, test scripts and test basis documentation
• Developed test cases (both positive and negative testing, boundary conditions), writing test scripts and execution of test cases based on functional specification documentation and feature description
• Experience in Black box testing with a complete QA cycle – from testing, defect logging and verification of fixed bugs
• Experience of working in Agile, V-Model and Waterfall software life cycles
• Solid knowledge of Software quality assurance processes and procedures that includes test planning, design, development, execution and evaluation phases, set up and execution of automated testing
• Developed and generated performance test scripts using Load Runner and functional test scripts using clear quest
• Practical knowledge on QTP, Load Runner, Rational clear quest and good knowledge of using Win Runner
• Good experience in handling client calls and working with offshore test teams
• Good practical experience in using Microsoft Word, Excel and MS Access.
• Good knowledge in Documentation Skills, Analyzing Information, Problem Solving, Process Improvement and Presenting Technical Information, Able to work under pressure, Good Time management skills
• Multi-task oriented professional for flexibility, adaptability and Good Team player

Technical Summary

Programming HTML, C, Java, Visual Basic.net, ASP.net 
RDBMS Oracle 11i/9i/10g, MS Access, SQL, PL/SQL, SQL Server, TOAD
Operating systems MS-Dos, Windows XP/2000, UNIX, LINUX
Software Adobe Suite, MS office
ETL /BI Tools INFORMATICA, TOAD
Defect tracking tools Clear Quest and HP Quality Center 
Testing tools QTP, Win Runner, Load Runner, Quality Center

• Bachelor of Technology in Computer Science

Work Experience

Confidential, Malvern, PA Jul’10 – Dec’11
Role: QA Engineer 
Confidential is an integrated Health Information Solution (HIS) that helps the organizations proactively manage clinical, financial, and administrative process from beginning to end. Soarian Medsuite facilitates increased efficiency, productivity, and quality of care across healthcare continuum easily and effectively. This product contains several modules including Patient administration, Clinical Management System, Billing System, Laboratory System, Pharmacy System and Common Features.
This application is developed using XNET Flex framework, J2EE and JBoss server. XNET is Flex and Java Framework developed by THRASYS. 
Environment: QTP 9.5, Quality Center 9.5, Manual testing, Oracle, TOAD, Java, J2EE, Flex, XML, JBoss, XNET Flex Framework, Eclipse, Ant, Perforce, CVS, 
Responsibilities:

• Participated and be an active contributor in daily scrum meetings, requirements/story review meetings, and design reviews and preparing release notes for each sprint
• Highlight to test manager and the scrum master about the risks and issues that can or impacting the test phase
• Maintained sprint backlogs and product backlogs based on the development and testing
• Developed the test cases using quality center for each sprint
• Created requirements in quality center for each user story
• Testing is done on the daily basis by using agile methodology
• Developed SQL Queries and Procedures to perform database testing using SQL Plus and TOAD.
• Design of Test Cases, review of Test Cases, Execution of Test Cases and Logging of defects
• Involved in designing the QTP scripts using Manual Test Cases.
• Participated in Walkthroughs and defect report meetings
• Performed front end as well as back end testing.
• Implemented various checkpoints for data validation and synchronization and developed reusable functions using QTP9.5
• Responsible for test preparation, execution, estimates in handling multiple scrums and successfully delivered the deliverables with best results

Confidential, State Street, Boston, MA 
Mar’09 – Jun’10
Role: QA Engineer
Confidential is a financial service provider. It offers instance benchmarking, investment management and security administration. This project is part of the Global Performance Analytics initiative where users will be able to create reports, queries and multidimensional analysis (Cube) using the GPA Business Intelligence (GBI). This is wrapper application to Cognos interface. This application is developed using Adobe Flex, Cognos SDK, Java & J2EE technologies, Oracle 9i and Web Sphere.
Environment: Quality Center,QTP9.2, Rational Clear Quest, Clear Case, Load Runner, Java, Adobe Flex , iText ,Flex Builder 3.0, RAD 7.0, Web sphere, Oracle 9i, Unix.
Responsibilities:

• Performed Functional, Regression, Install, GUI and Configuration testing on both Unix as well as windows platforms
• Involved in designing the QTP scripts using Manual Test Cases.
• Implemented various Checkpoints for data validation and synchronization and developed Reusable functions using QTP9.5.
• Developed SQL Queries and Procedures to perform database testing using SQL Plus and TOAD.
• Usage of Rational ClearCase to generate performance builds.
• Automation of new test cases using shell and debugging the test failures of the existing test suites.
• Customer Bug verification and preparation of test cases for the new bugs.
• Design of Test Cases, review of Test Cases, Execution of Test Cases and Logging of defects
• Manual testing for few test cases which were not automated and for all the new features coming in
• Bug Logging, Bug tracking, Test Result analysis and reporting was an implicit task all the time.
• Responsible for performing performance, System testing, Regression testing and UAT
• Extensively involved in writing the scenarios and test cases
• Perform all aspects of testing to ensure the quality release of new versions and service packs Mentoring junior team members with new integration modules of the project
• Participated in Walkthroughs and defect report meetings
• Performed front end as well as back end testing.
• Involved in performing risk based testing and ensuring to test all risk factors mentioned in test plan
• Develop and execute effective test strategy plans for quality management

Confidential, Allstate, Northbrook, IL Mar’08 – Feb’09
Role: ETL Tester
This project involves the maintenance of Confidential and Alliance Endorsement Application. The application is to get online quotes and purchase for auto and property insurance in differentstates of US. It involves both commercial and personal insurance. It is a complete online e transactionapplication involving customers, agents and call center through direct or mutual interaction. Alliance is a group of web-based applications include Legal Trailing Documents (T-Docs), Commercial Auto Quote, Auto New Business (ANB) and Property New Business (PNB), Integration Components for external systems such as IRMS, HRM, IPS, etc., Web Services such as Get Quote, Save Quote, Get Policy Data, Get Billing Data, Get Claims Data
Environment: Rational Test Manager, Rational Clear Quest, QTP, Quality Center, Java, J2EE, XML,Flex , RAD (Rational Application Developer), WAS (Web Sphere Application Server),Oracle 10G, TOAD, PL/SQL ,DB2 ,Unix Shell scripting MS-Project, SQL Navigator, Windows XP, Ascential, INFORMATICA
Responsibilities:

• Involved in gathering requirements and analysis for applications.
• Developed Test Plans, Test Cases, Test Scripts for UAT tests
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
• Involved in Developing Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Used Shell scripts extensively for automation of file manipulation and data loading procedures.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Run the Informatica Workflows for ETL Process
• Execute batch processing and verify the jobs status and data in database tables
• Responsible for designing Framework and executing automation scripts using QTP.
• Tracked the defects using Clear Quest and Quality Center and generated defect summary reports
• Modified Configuration file according to space constraints
• Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP).
• Wrote shell scripts to run PL/SQL programs and job scheduling.
• Prepared status summary reports with details of executed, passed and failed test cases
• Interacted with developers, Business & Management Teams and End Users
• Participated in regular project status meetings related to testing

Confidential Feb’07- Dec’07 
Role: Test Engineer 
Confidential plans to implement a Web based Customer Access Systems (CAS) system exclusive to its corporate Trade Finance Customers. This is a major E- Trade initiative undertaken by the bank to provide its customers and its one of the first in the country to extend this Value Add to its esteemed Trade Finance Customers.
Environment: QTP, Test Director, Windows 2000/Unix, SQL Server, Java, struts, JSP.
Responsibilities:

• Preparation of test cases, test scripts and Traceability matrix
• Developed and executed automated test scripts using QTPfor Regression testing
• Experienced in handling Data Driven Tests using QTP
• Backend end testing UsingSQL and Toad
• Created test data to test the business functions supported by the application, conducted comparison of the output reports generated from the application
• Performed the back-end testing to ensure data consistency on front-end by writing and executing SQL queries on the database
• Implemented various Checkpoints for data validation and synchronization and developed Reusable functions using QTP

Confidential Aug’06- Jan’07
Role: Test Engineer
This application is a client/server accounting package targeted for the retail paper industry. This package includes all accounting modules such as AR, AP, GL, and SOP (Sales Order Processing).This will give all the accounting information for the complete application.
Environment: Test Director 8.0, Load Runner 8.0, Win Runner 8.0, Windows NT, Oracle, Visual Basic, Ms-Access, SQL Server
Responsibilities:

• Framing of Test conditions, Test cases and test scripts
• Executing the test cases and logging the defects.
• Defect reporting and analysis, test plans and test cases were organized using Test Director.
• Preparation of Traceability Matrix to ensure the test coverage at various levels
• Updated existed test cases, created new test cases as well as executed them and logged bugs found, using Test Director (Defects Module, Test Lab Module and Test Plan Module).
• Involved in developing and executing automated test scripts using Win Runner for Regression testing
• Created GUI checkpoints to test GUI functionality in the application
• Created synchronization points to avoid test failures resulting from synchronization problems.
• Created data-driven test to test the application behaviour with multiple data-sets
• Assisted in load testing of the application by generating V-user test scripts.
• Performed data integrity testing by executing SQL and Used different joins on the tables to retrieve information from different tables in database to check the database updates on a regular basis using SQL queries
• Running of performance test scenarios and analyzing graphs

Confidential Jan’06-Jul’06
Role: Test Engineer
Confidential is the next generation management system for today’s health care industry. It is highly automated system for patient registration, maintain patients treatment history, hospital billing, patients record, complete diagnostic reports, inventory and accounting with detailed reports generated about the patients, fees collection and accounts. The HIS system with its powerful features it is ready to meet requirements of all types of hospitals ranging from small to medium sized hospitals. 
Environment: WinRunner8.0, Test Director ,Java, Jsp, Oracle 
Responsibilities:

• Prepared Test conditions, Test cases and test scripts
• Preparing Test Cases, Specifying what is the input & expected Value.
• Test Activities included Smoke, Sanity, functionality and Regression Testing
• Involved in Test Automation using Win Runner
• Involved in bug report generation
• Involved in generation of test reports.
• Involved in Test execution to detect defects.
• Updated existed test cases, created new test cases as well as executed them and logged bugs found, using Test Director (Defects Module, Test Lab Module and Test Plan Module).
• Conducted Regression Testing on modified builds.
• Prepared SQL queries for Database Testing.