Qa Analyst Resume
CA
SUMMARY
- Having 8 years of professional experience in Quality Assurance with Manual as well as Automation Testing of Web Based and Client/Server Application.
- Hands on experience in all phases of SDLC and QALC - requirement analysis, Gap analysis, use case decomposition, test planning, estimation and strategy.
- Experienced in testing & verifying Business functionality, Database and Security Standards for different client/server applications in the areas of Finance, Banking, Security Trading System, Insurance System and Healthcare Systems
- Knowledge about Software Development Methods like Waterfall, V-Model, Agile and Rational Unified Process (RUP).
- Excellent experience in writing Test Plan, Test Strategy, Test Cases, Test Scenarios, Test Scripts, Test Matrix and Bug Reports.
- Good exposure in performing verification and validation activities, including preparation of test scripts, step-by-step execution of test scripts and consolidation and reporting bugs.
- Worked extensively on Mercury testing tools like QTP, Quality Center, Test Director, and Win Runner, also Having familiarity with Rational Tools like Rational Requisite Pro and Rational Clear Quest.
- Extensive experience in GUI, System Integration (SIT), Functional, Integration, Regression, Unit, Performance, Load, Stress and User Acceptance Testing (UAT).
- Writing complex SQL queries and PL/SQL procedures to extract data from various source tables to perform database testing.
- Excellent understanding of Object Oriented Programming, UML concepts, design patterns, and different Web Technologies.
- Worked with Star Schema, Snowflake Schema, Multi Dimensional Databases
- Knowledge of cross browser testing, Log Analysis and Interim release testing.
- Excellent Problem Solving, Analytical, Communication and Interpersonal skills and a proven Team player with a good track record.
TECHNICAL SKILLS
Operating Systems: UNIX/LINUX, Windows 98/2000/NT/XP/Vista/Windows 7
Databases: SQL Server 2005/2003/2000 , Oracle 11g/10g/9.x/8.x, Sybase,MS-Access 5.0
Web/Scripting Languages: VB Script, XML,HTML, Shell Script, XSL, ASP.NET, Java Script
Testing Tools: QTP 11.0/10.0/9.2/8.2 , Quality Center 10/9.2, Test Director 8.0, Winrunner 7.6/8.0, Loadrunner 7.0, Bugzilla 3.0.3, Clear Quest
Programming Languages: VB,, ASP.NET 2.0, .NET 3.0, SQL,PL/SQL, PowerBuilder, C#
Tools: MS Office 2010/2007,FrontPage 2007, HTML
Version Management: PVCS, Visual SourceSafe, Rational Clear Case
DB Tools: SQL Developer, iSQL, Toad, iSQL,SQL Navigator, Erwin
PROFESSIONAL EXPERIENCE
Confidential, CA
QA Analyst
Responsibilities:
- Thorough understanding of Business requirements from user prospective
- Designed Test Plan, Test Cases, Test Scenarios, Test Scripts and Test Data
- Performed Manual Testing using Quality Center including Negative Testing
- Performed Functionalities Testing of Business requirements and application modules
- Conducted Parameterization in Check Points using Quick Test Professional
- Performed Data Validation, Database testing, Database schema testing, Data Migration Testing between Sybase and Oracle using Quick Test Pro
- Performed Regression testing after bugs have been fixed to validate product fixes
- Developed automation scripts for data comparison, data validation, Index validation for Oracle migration project
- Responsible for writing scripts which involved some advanced programming of scripts using QTP
- Involved in Database Migration from Sybase to Oracle and also Application Migration
- Performed SQL Queries for retrieving data from Sybase and Oracle database
- Scheduled Scripts for reporting, data transferring, data validating in the night cycle
- Interacted with Business Analysts, Developers and QA team members in different defect raising situations
Environment: Quick Test Professional 11/10, Quality Center 10/9.2, PowerBuilder, C#, .Net, UNIX, Oracle 11g, Sybase, SQL Server 2005,Windows 7/XP, SharePoint, Visual Studio
Confidential, DE
QA Lead
Responsibilities:
- Prepared high level Test Plan based on Business Requirement Document and System Requirement Specification to test Order Execution, Fund Allocation, Account Summary workflows of Order Management and Trading System Application.
- Developed Test Cases, Test Scripts, Test Scenarios, Test Data and Traceability Matrix
- Performed regular Regression Testing of all the builds in the order management module
- Understanding the equity order management system from the portfolio managers perspective
- Tested the default values assigned for fields when the Portfolio manager logs in
- Developed VB Scripts for error handling using On Error/Goto function in QTP
- Worked on Requirement Management, Test Planning, Test execution and Defect Tracking using Quality Center for Manual Testing
- Involved in Security Testing of the Application for data encryption and prevention of unauthorized Access
- Created and Executed Automated Test Scripts for GUI and Functional Testing using Quick Test Pro, Also Performed Data Driven Tests and Action Based Recording
- Worked in SQL and UNIX Shell Scripts for data integrity and data Validation
- Performed SQL and PL/SQL queries to access data from database & other sources
- Analyzed and interpreted reports and graphs for the test cases generated through Quality Center.
- Performed Performance Testing and analyzed the performance graphs in LoadRunner.
- Conducted Load Testing for various sub modules in the application by generating Virtual Users using LoadRunner
- Performed GUI, Functional, Regression, Smoke, Boundary and User Acceptance testing of Order Management & Trading Application, its interfaces and Client-Server Utilities
- Participated in feasibility study meeting and JAD sessions
Environment: Quality Center, Quick Test Pro, ASP.NET, C#.net, UNIX, VB Script, MS Office, MS SharePoint, MS SQL Server, SQL, PL/SQL
Confidential, NY
QA Analyst
Responsibilities:
- Understand all the requirements for the insurance call center administration
- Developed Test Plan based on Technical Specifications and Functional Specification
- Create test cases to be used across for multiple projects (Online & IVR)
- Field level Validation rules for each screen. This was done by taking multiple inputs for the business users
- Business rules write-up. Provided grid for various combinations of the business rules to the testing team which was used as a template for testing
- Tested the Beneficiary Information for Insured and Premium pertaining to it
- Analyzed system requirements and developed Test Plan, Test Procedures and Test Cases using Quality Center.
- Automated the functionality and interface testing of application using Quick Test Pro, also used checkpoints to check properties of various objects.
- Used verification points and conducted data driven Test with the Test Data sets and verified the contents of the website.
- Used Test director for bug tracking and for maintaining the test documents
- Worked on QTP for Functional and Regression Testing
- Porting of Test cases from Excel to QTP
- Reported the bugs, Email notifications to the developers using the Test Director
- Performed back end testing by design and executing complex SQL Queries to extract data from different data sources to validate the corresponding reports.
- Monitored Test Director to close the bugs/cases as and when developers fix the bugs
- Load Test was conducted for the Database, also Conducted Performance, Stress and Volume testing using Load Runner
Environment: Quality Center, QTP, C#, ASP.NET2.0, ADO.NET, LINUX, XML, XSLT, HTML, SOAP, IIS, T-SQL, Crystal Reports, MS SQL Server
Confidential, NY
QA Lead
Responsibilities:
- Examined the business requirements for Fixed Income Trading System
- Tested the Security find feature in New Order Entry Screen
- Tested alter feature i.e. alert sent to broker about the order, performed end to end testing
- Understood the functionality “Done Deal” and tested for the screen transitions
- Verified Maturity orders to be roll over functionality
- Involved in testing the security authenticity for the application
- Performed Manual Testing of the Application, Interacted with developers and discussed technical problems, reported bugs
- Performed Regression and functionality testing against new builds using WinRunner
- Analyzed user requirements and developed Test Plans, Test Cases using Test Director
- Tested for the compatibility of the Browser (IE and Netscape)
- Involved in Performance, Load testing using LoadRunner
- Enhanced the load testing scripts by adding parameterization and correlation statements to pass the unique and valid data to the server
- Reported Defects using Test Director
- Involved in meetings to identify the new structure and modify existing structure as and when necessary for the application under test
- Conducted Integration testing between different modules of the application under test.
Environment: Quick Test Pro, Test Director, Clear Case, Java, JSP, Oracle, JSP, Swing, Servlet, Windows Server, SQL, HTML, VB Script
Confidential
Programmer/QA Analyst
Responsibilities:
- Developed the screens to manage overall functionalities of hospital
- Involved in creating the required tables and queries
- Involved in testing wage calculations if the employee is Waged Labor
- Tested the database for any updates made form the user end
- Executing the Test Cases and Updating the Test Cases for new Builds
- Implemented the data validations required
- Involved in authoring the test plan and test cases
- Involved in performing unit testing, functional testing, system testing
- Developed and executed test cases to check the functionality of Tax and Patient Benefit modules and written Winrunner TSL test scripts to automate execution for all the test scenarios
- Checked the Functional Flow of the system
- Involved in making the required code changes and retested the application after the bugs were detected
Environment: Test Director, Win Runner, ASP, MS Office, HTML, XML, Windows NT, MS SQL Server, PowerBuilder, Oracle 9.x
Confidential
Resort Explorer
Responsibilities:
- Study existing flow of order intakes and formulate workflow for online booking
- Designed Front-end screens Member Log-in, Deals Information, Room availability, Billing Information
- Written SQL Connections strings and written SQL procedures
- Design deal management sub system use cases, test cases
- Trained in SQL Server to verify and validate all the test cases run
- Tested the Room availability and checked the number of rooms reflect in the database
- Followed up with development team to verify bug fixes, and update bug status
- Worked with developers, project Lead to achieve project goals timely and effectively.
- Finding Defects and Preparing Defect Reports
- Used QTP to validate requirements and submit RAW documents into the workflow and identify RCNs to compare.
- Experienced in coding maintainable independent QTP VB scripts, calling a framework of user defined functions to automate assigned test cases
Environment: Test Director, Java, HTML, Java Script, HTML, MS Excel, MS Access
