SUMMARY

• 9+ years of rich experience as a Test Analyst / Quality Assurance Tester experienced in Manual,ETL and Automated Testing.
• An effective leader with proven abilities in leading larger teams during the project phase and guiding team members and enabling knowledge sharing among the team
• Experienced in Web, Client - Server Applications and Edward for Banking, Insurance, Financial and Logistics.
• Expertise in analyzing Business Requirements, Technical Requirements and High Level Design Documents for all kinds of project.
• Expertise in manual and automated software testing using tools such as (QTP) Quick Test Professional/UFT, HP Quality Center (Application Lifecycle Management).
• Experience in preparing Test Plans, Test Strategy, Test Cases, Test schedule planning, Test Traceability Matrix, Defect Reports, Test results documents.
• Have strong knowledge in Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) concepts and its implementation in projects.
• Experienced in Functional testing, Integration testing, System Testing, Regression testing, Black Box testing, web services Testing, UAT, Smoke Testing, Recovery Testing and GUI Testing.
• Experienced in planning, scheduling and tracking, reporting status, providing test estimation, identifying gaps and managing issues in execution phase.
• Extensively used ETL methodology for supporting data extraction, transformations and loading, in a corporate-wide-ETL Solution using DATASTAGE and Informatica.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch and executing the batch jobs .
• Worked with wide variety of sources like Relational Databases, Flat Files.
• Have solid experience on database query tools such as, TOAD, SQL Navigator.
• Strong knowledge of SDLC and Software Test Life Cycle(STLC) and highly proficient inSQAmethodologies for agile scrum, V Model and Waterfall.
• Experienced in writing automation test scripts using UFT/QTP environment using VB script.
• Involved in preparation of test data
• Strong understanding of QA Process, Use cases and can work through different releases of product.
• Proficient in Defect tracking, Defect analysis and metrics collection. •
• Expertise in using ALM/Quality Center for defect tracking, organizing, managing, planning, Writing and Executing the Tests Cases.
• Experienced performing planning and development of Test Plans, Test Strategies, Test Cases, Test Scenario, Test Execution and Defect Reporting, Defect Tracking.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements
• Expertise inDefect management,Bug tracking,Bug Reportsand generating the graphs using Test Management Tools such as ALM,TFS(Team Foundation Sever), clear quest and JIRA.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading
• Involved in testing the batch jobs, using UNIX and Autosys
• Strong experience in UNIX platform.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, UNIX, SQL, PL/SQL, OLAP, XML, SQL Server, Oracle, and ETL.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end, Performed end-to-end testing.
• Good experience in working with onsite-offshore team model projects.
• Have ability to work independently as well as leading a team with strong analytical and organizational skills.
• Experienced on web services testing using SOAP.
• Tracking of Project Activities from Development to Production
• Experienced in VSS,SVN for version manager for documentation
• Good knowledge and experience in Property & casualty insurance, Prime Brokerage, Capital markets, Trading, Mutual funds, SWIFT messages, Equities, Futures and Options and Payments Applications
• Lead the Quality Assurance team during a major release of the application by assigning testing responsibilities and reporting metrics to management and clients.
• Good coordination with Project manager, Development team, Business Analysts and End-users
• Experienced in working with Scrum Master, Product Owner, team members, Business Analysts and End-users with agile scrum methodology.
• Having experienced in Risk based analysis testing.
• Having good leadership qualities to run the meetings and to maintain the team members.

PROFESSIONAL EXPERIENCE

QA tester/Test Lead

Confidential - Green bay, WI

Environment: Manual Testing, Database testing, (UFT), .Net, Oracle 10g, ALM, Toad, XML, MS Office Suite, Agile

Responsibilities:

• Review business requirements, functional specifications and gathering application knowledge from business analysts, designers and developers to identify and understand the project needs.
• Developed and reviewed test strategy, test plan, test scenarios and test cases for manual testing from the user stories and tasks.
• Prepared requirement traceability matrix to map the business requirements with the test cases.
• Responsible for Smoke, Functional, Regression, User Acceptance testing and escalate bugs discovered during testing into the defect tracking system and track them until they are closed.
• Participated in bug triage meetings with developers to validate the severity of bug and responsible for defect tracking.
• Performing automation regression testing to make sure that existing functionalities are not impacted by the changes.
• Developed and reviewed regression test scripts to ensure best practices are followed.
• Used HP ALM as repository for requirement analysis, design test cases, Execute test cases, Bug tracking and reporting.
• Actively Participated in UAT helping business teams on test flows and test data support.
• Involved in planning daily test case development and execution for the team and sending the test execution report to the stakeholders by the end of the day.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Involved in Defect Triage calls with scrum master, product owner and team.
• Validate end-to-end business processes.
• Verification of webservice WSDL using SOAP.
• Tested the validity of the Quote Premiums and Purchase Premiums while comparing the entered Quotes and Purchases with backend systems.
• Responsible to perform the Quotes and Purchases operations from the front end
• Written SQL scripts for performing data validations as well as for inserting test data into the tables.
• Participated in SCRUM and SPRINT meetings.

QA tester /Test Lead

Confidential - New York, NY

Environment: (QTP) Quick Test Professional 10.0, Manual Testing, HP Quality Center 9.0, VBScript, C#.Net, Microsoft SQL Server 2005/2007, NET 3.0/3.5 framework, Toad, Microsoft Visual Studio 2005, MS Visio,Mainframes

Responsibilities:

• Analyzed system requirements specifications, developed Test strategy, Test plans, Test cases, Test data fortestingthe functionality, GUI, Compatibility, usability and User Acceptance of the application.
• Interacted with developers and business owners for analysis of the applications.
• Validating the data in mainframes.
• Executing the batch jobs in mainframes.
• Prepared detailed test strategy, test plans, test conditions, test cases and scripts based on requirement documents and functional specifications.
• Conducted system and functional, User-Acceptance (UAT) and Sanitytesting.
• Maintained test logs, Test summary reports and participated in defect review meetings.
• Involved in Manual/AutomatedTestingof applications.
• Executed the automated functional and regression test cases with QTP.
• Performed data validation by comparing the data between two environments.
• Participated throughout thetestinglife cycle from requirements, test design and review to customer implementation.
• Used Quality center to invoke the scripts and initially performed the baselinetestingand organized all the scripts systematically and generated reports.
• Used HP Quality center to trace the requirements, write the test cases in the test plan module, execute the test sets in the test lab and track the defects logged in the defects module.
• Extensively used QC for tracking and reporting bugs.
• Preparing the final test report and reviewed with the Lead and managers.

Test Lead

Confidential

Environment: ETL Testing, Manual Testing, Java,J2ee PL/SQL, Quality Center, XML, Web Services SOAP (SOAP UI), SQL Developer, TOAD, Java Script, Oracle 9i, Share point, Oracle 11i, Informatics, UNIX.

Responsibilities:

• Involved in creation of test plan, which detailed the testing scope, strategy, Exit and Entry Criteria, hi-level test requirements, and necessary resources
• Worked on QC for Loading, Executing and preparing the Test Results.
• Responsibilities included analyzing system and functional requirements and writing test cases.
• Validates input feeds and output extracts
• Performing ETL by running the batches
• Tested the various ETL processes that were developed to fetch data from various feeds coming from Admin System
• Test Case execution, reporting defects using QC
• Validating the data in mainframes.
• Executing the batch jobs in mainframes.
• Generating the DSR using QC
• Involved in Business analysis and requirements gathering.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Extensively tested the Business requirements report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Executing and monitoring jobs through Control-M.
• Executed the UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• File transfers, error log creations and log file cleanup process.
• Reviewed Informatica mappings and test cases before delivering to Client
• Written Test Cases for ETL to compare Source and Target database systems.
• Ensured that the mappings are correct and conducted data validation testing
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Validating the WSDL’s using SOAP.

Sr QA /Team lead

Confidential

Environment: Manual Testing, Java,J2EE, SWIFT messages, Quality Center, TOAD, Java Script, Oracle 9i

Responsibilities:

• Interacted with Business Analysts team for understanding Business logic and Client Requirements
• Developed Test cases as per the functional requirement.
• Created requirements and generated traceability matrices to ensure that all the requirements are covered by the test cases.
• Reviewed the test cases written by team.
• Involved in creation of test plan, which detailed the testing scope, strategy, hi-level test requirements.
• Performed a wide range of quality tests to ensure that software requirement specified Standards and end user requirements.
• Prepared both high level and detailed Test plan and Test strategy for Integration, System and UATtesting.
• Validating the data in mainframes.
• Executing the batch jobs in mainframes.
• Organized walkthroughs and inspections with the Project Manager, Business personnel, Business analyst and developers to decide the scope oftestingand testability of requirements which also resulted in adding new requirements.
• Worked with various teams to resolve environmental issues and have QA instance always up and available.
• Used Quality center for tracking requirement, test coverage and defect status.
• Prepared the functional and end to end business scenarios.
• Active role in designing and creating the hybrid framework.
• During test execution of UAT test cases, worked effectively with the BA and developers to accommodate the frequently changing requirements and sorted out the ambiguities and ensured that maximumtestingwas done.
• Submitted the daily EOD test status report to the project team to communicate the progress of testing.
• Effectively communicated the defects to the developers by doing a root cause analysis hence resulting in a fast turnaround time.
• Single point of contact for othertestingteams (End to End/Performance/UAT) in communication and knowledge transfer.
• Given the demo of the tested product to business group and successfully got the user buy-off to release the product.
• Successfully delivered the product in production as per schedule, meeting the exit criteria.

QA tester

Confidential

Environment: Manual Testing, .Net, Quality Center, SQL Developer, TOAD, Oracle 9i.

Responsibilities:

• Interacted with Business Analysts team for understanding Business logic and Client Requirements
• Developed Test cases as per the functional requirement.
• Created requirements and generated traceability matrices to ensure that all the requirements are covered by the test cases.
• Reviewed the test cases written by team.

QA tester

Confidential

Environment: Manual Testing, Test Director,ASP.ASP .Net, Quality Center, SQL Developer, TOAD, Oracle 9i.

Responsibilities:

• Responsibilities included analyzing system and functional requirements and writing test cases
• Developed test cases with traceability to system and functional requirements
• Responsible for testing, document the business test scenarios, test data and scripts execution in support of the testing approach.
• Development of test case scenarios for functional testing of web application.
• Performed testing to verify back-end database functionality of the application through SQL queries
• Participated in walkthrough and technical reviews all through the testing phase.
• Responsible for preparation of weekly status report.
• Documented software defects using Test director, investigated them through working with software developers to resolve technical issues, and re-tested the application
• Responsible for Regression, User acceptance, Functional, Integration & System Testing including Documentation.