SUMMARY

• Around 7 years of experience in testing software applications with major emphasis on products related to DMV applications, financial domain, Insurance domain, Healthcare domain and Quality Assurance activities using Manual and Automated testing procedures
• Experienced in System, Functional, Regression, Integration, User Acceptance Testing (UAT), Backend Testing, Performance and Stress Testing
• Expertise in Batch services testing using SQL stored procedures in SQL Server2008
• Strong experience in Test Methodologies, Browser Based Web testing, performance testing Data Migration testing, Application testing (in web environment), Client Server application testing, Database testing and backend testing.
• Experience in testing Extraction, Transformation and Loading (ETL) mechanism using Informatica
• 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)
• Expertise in database concepts (RDBMS), writing complex SQL queries using joins, group by, aggregate functions and PL/SQL statements to check for data integrity
• Extensive experience in reviewing Business Requirement Documents, System Requirement Documents and preparing Test Cases, Test scripts and Execution
• Expertise in Application Lifecycle Management(ALM), Mercury Test Director, HP Quality Center, Load Runner and QTP
• Expertise in ALM for maintaining the Test Plans, Test Cases, Test Execution, test metrics preparation using dash board and defect tracking and involved in triage calls for defect management
• Proficient in VB scripting programming
• Experience in working with SOA Environment
• Experienced in Web Services testing using SOAPUI tool
• Proficient in QTP Script Language, check points, parameterization (Data - Driven test), functions(key word driven), synchronization point and descriptive programming
• 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 and UAT support
• 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
• Hands on experience with QTP, Load Runner, Rational clear quest, ALM and SOAPUI
• 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 SKILLS

Programming: HTML, C, Java, XML, VB script

RDBMS: Oracle, MS Access, SQL, PL/SQL, SQL Server 2008 and TOAD

Operating Systems: Windows 7/XP, UNIX

Software’s: Adobe Suite, MS office

ETL /BI Tools: INFORMATICA

Defect tracking tools: Application Life Cycle Management11.0, JIRA, Clear Quest and HP Quality Center

Testing Tools: Quick Test Pro 11.0, ALM 11.0, SOAP UI 4.0 and Load Runner

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Senior QA Analyst

Responsibilities:

• Expertise in performing Smoke, Functional, Regression, Integration and UAT testing
• Performed Batch Jobs testing using SQL procedures in SQL Server
• Experienced in collecting Positive and Negative test data by executing SQL queries against the database
• Involved in testing interfaces using SOAP UI to validate the WSDL files from outbound services
• Tested Interfaces in Confidential using SOAP UI by creating the data source, data source loop using data driven framework
• Involved in reviewing business requirements during walkthrough meetings and clarification session meetings for each HLD assigned to me
• Prepared test cases by analysing the functional requirement documents (HLD) using excel and exported the test cases to ALM by creating standard mapping
• Expertise in writing complex SQL queries using joins, aggregate functions and group by clause to perform Report Testing and validate the data
• Prepared requirement traceability matrix (RTM) to verify the test case coverage according to the business rules
• Expertise in exporting defect to ALM using Excel ALM add in and importing defects for defect management
• Expertise in preparing the Reports for test case metrics, defect metrics by using Dash board in ALM
• Participated in WPR (work product review) meetings conducted to review the test cases and provided WPR comments for the test cases
• Involved in UAT testing and defect management using JIRA
• Key role in the Vehicle module related to Vehicle title and registration, operator control and business partners
• Participated in daily stand up meetings, Triage calls conducted for defect management
• Performed Batch services testing and Report testing by writing complex SQL queries for data validation.
• Expertise in writing SQL queries using Joins, aggregate functions in SQL server
• Developed VB scripts by using descriptive programming and functions (key word driven frame work) in QTP
• Automated Smoke test cases and regression test cases and executed them during the execution time.
• Performed smoke, Integration and Regression testing using QTP 11.

Environment: ALM 11.0, QTP 11.0, VB script, JIRA, SOAP UI 4.0, SQL Server 2008 and VB.NET

Confidential, Malvern, PA

Sr. QA Tester/Analyst

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
• Developed VB scripts by using descriptive programming in QTP
• Created variables in VB scripting for descriptive programming by using option explicit, dim
• Used IF condition, While loop, for loop in VB scripting for checking the data multiple times while using data driven frame work in QTP
• Used Import statements in VB scripting for getting a data table in QTP data driven frame work
• Used Invoke application of VB scripting to start the application in QTP
• Created requirements in quality center for each user story
• Involved in mapping test cases to requirements
• Testing is done on the daily basis by using agile methodology
• Developed SQL Queries 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.
• Active participant in Walkthroughs and defect report meetings
• Involved in testingWebservices with SOAPUI for load performance
• Used SOAPUI tool to locate XML WSDL file on internet, create Test cases, run them, do load testing, backend testing, security testing
• Performed backend testing to validate the data according to the front end operations
• 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

Environment: QTP, Quality Center, Load Runner, SOAPUI, Oracle, TOAD, Java, J2EE, Flex, XML, JBoss, XNET Flex Framework, Eclipse

Confidential, Boston, MA

QA Tester

Responsibilities:

• Performed Functional, Regression, Install, GUI and Configuration testing
• Prepared test cases by analysing the business requirements
• Verified the coverage of requirements in aspects of test cases by preparing requirement traceability matrix (RTM)
• Created Data driven frame work for data validation and performed check point validation using QTP
• Performed regression testing using QTP
• Used Recovery scenario manager in QTP to handle the unexpected errors and to continue the execution of the scripts
• Involved in developing the SQL queries for data validation.
• Involved in design of Test Cases, review of Test Cases, Execution of Test Cases and Logging of defects
• Defect Logging, tracking, Test Result analysis and reporting was an implicit task all the time
• Involved in performing performance, System testing, Regression testing and UAT
• Extensively involved in writing the scenarios and test cases
• 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

Environment: Quality Center, QTP9.2, Rational Clear Quest, Clear Case, Oracle 9i, Unix, Java, Servlets, Hibernate, Adobe Flex, Flex Builder Plug-in with eclipse, Tomcat Server, CVS.

Confidential, Northbrook, IL

ETL Tester

Responsibilities:

• Involved in gathering requirements and analysis for applications
• Developed Test Cases, Test Scripts for UAT tests
• Used Informatica as an ETL Tool for testing the data from different systems
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in QC.
• 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.
• Analysed the data from source, loading the data into schemas SA (Staging area), DW (data warehouse) by using the ETL Tool informatica.
• Testing the new mappings which are created for changes in the source to load in to the target.
• Tested various transformations used in the mappings by using ETL tool.
• Testing the Reports generated by Business Objects manually and by using load runner (Hits for refresh, edit and view, Partial data, data errors and data quality checked against the source using TOAD
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Run the Informatica Workflows for ETL Process
• Tested the ETL process for both before data validation and after data validation process.
• Tested the messages published by ETL tool and data loaded into various databases
• Execute batch processing and verify the jobs status and data in database tables
• Tracked the defects using Quality Center and generated defect summary reports
• 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

Environment: Quality Center, Informatica, Load runner, 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.