Qa Analyst Resume
New, YorkcitY
PROFESSIONAL SUMMARY:
- Seven plus years of dynamic career reflecting pioneering experience in the field of Information Technology as a Quality Assurance Analyst with strong experience in all phases of SDLC involving Requirement gathering, Business analysis, Project Planning, Testing, Tracking and scheduling of multiple software test efforts.
- Experience in verticals – Education, Insurance , Telecommunications, Banking and Pharmaceutical.
- Expertise both in Manual and Automation Testing .
- Hands on testing experience in Sales Force Applications, Data Ware housing testing ,ERP Testing and Oracle CRM Modules
- Hands on testing experience in ETL tools Abinitio and Data stage.
- Experience in testing XML requests and responses of web services using SOAPUI.
- Hands on Testing experience in Wireless Telecommunications applications involving CISCO Routers, Switches,WLAN and VOIP.
- Extensive work experience in Data Base Testing, writing SQL queries and execute in TOAD to test the backend system data
- Extensive work experience using Quality Center to author the Test cases and report and track the defects.
- Expert in Team Foundation Server,Test Director, Team Track, Clear Quest, and CDETS tools.
- Expertise in Functional Testing, Integration Testing, Black box Testing, Security Testing, Regression Testing, Performance Testing, Load and Stress Testing.
- Authors all SDLC related documents, include minutes of meeting, Test Plan, Test Strategy, Traceability Matrix, Test Metrics , Post Implementation Reviews, etc.
- Has knowledge on Object Oriented Programming languages.
- Interacted with Project Managers, Release Managers and Development groups for problem escalation and resolution.
- Has Extensive work Experience in Agile and water fall model Methodology.
- Has good Experience in Microsoft Word, Excel and PowerPoint.
- Highly motivated and adaptive with the ability to grasp things quickly.
- Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.
TECHNICAL CERTIFICATIONS:
Oracle Certified Associate (OCA-SQL and PL/SQL)
HP-M015 (Quality Center Professional)
HP-M016 (Quick Test Professional)
TECHNICAL SKILLS:
Languages : C, JAVA,.NET, XML, HTML,Perl, Visual Basic, SQL, PL/SQL
Operating Systems : Windows 95/98/2000/XP, UNIX.
Management Tools : Team Foundation Server, HPQuality Center 9.2,Test Director,CDETS,SOAP UI,Clear Quest
Databases : Oracle 9i/10g, TOAD, PL/SQL 7.0
Achievements:
CISCO Certificate of Appreciation for Outstanding performance in the year 2009.
Cisco Peer-Peer Award for outstanding performance.
PROFESSIONAL EXPERIENCE:
Confidential, Mar 12 – Present
Sr QA Analyst-New YorkCity
READING TRACKER –
Reading Tracker application is used by New York City school educators to track the 1.2 millions student’s assessment data and growth levels.It is a complete solution that allows educators to enter scores for all students in their classes, arrange their students into groups, and to report on their students’ data.
Responsibilities:
- Understand the Business Requirements, Interact with Business Analysts and QA Managers to clarify the Issues related to the Business Requirements
- Prepared the Test Plan and Test Strategy documents and get the signoff.
- Have daily meetings with the Business Analysts and Project Manager and prepare the status report.
- Involved in weekly Project meetings along with the QA Manager and submit the status report and discuss the priority issues in the meetings with the Project Manager, Business Analyst and developers.
- Verify that all the requirements, test cases and defects are available in the Team Foundation Server Tool.
- Verified the objects data loaded by the Source Data core Team against the data in Reading Tracker application.
- Checking the database by executing the SOQL queries through Force .com Explorer whether the data loaded correctly to the database (or) not.
- Involved in testing the application in multiple browsers viz., IE 8.0 ,Safari and Firefox 3.0 to ensure the cross-browser support.
- Develop and automate Web Services API testing using SOAPUI frameworks.
- Validated Test case data in XML data files
- Tested feature by feature, verified Date Core Team Table structure, Web Services, Data validation and Front end testing.
- Performed Regression and Functional Testing.
- Prepared the Test data for UAT testing.
- Logged defects in Team Foundation Server tool to assign to the developer.
- Giving Signoff from the QA after completion of the Testing.
- Prepared Testing Documents for each Functionality of the Application which includes what we need to test, how it should be tested etc and get the signoff from the Business Users.
- Prepared Test Evidence Documents for the Business to get the signoff
Environment: Windows XP,Eclipse with Force.com Explorer, SOAPUI,XML,Apex Data Loader, Team Foundation Server, ,SOQL, Microsoft Excel.
Confidential, (New Jersey) Sep 11 – Feb 12
QA Analyst
Sales Force –
SalesForce.com was implemented for Chartis in Domestic Brokerage Group to enable the company to more effectively manage current business and drive new business, while at the same time enabling the cross-selling and up-selling of DBG products. The SalesForce.com implementation helps the Domestic Brokerage Group in the below manner:
Easier access to Customer data (accounts, brokers, initiatives, and submissions)
Ability to have a single view of the customer
Intuitive, user-friendly interface
Enhance initiative management capabilities
Better visibility for management into DBG’s activities
Enhanced “day-in-the-life” user productivity, relationship
Enhanced capabilities to up-sell and cross-sell.
Responsibilities:
- Understand the Business Requirements,Design documents and provided input from attest and end-user prospective.
- Designed and developed Test Plan document, Test Completion Reports, etc.
- Designed and developed Test Scripts based on System Requirements and executed Designed and developed Test plans, by reviewing the Business Requirement documents.
- Verify the data loaded by ETL Abinito team is properly reflecting in the Sales force.com front end.
- Involved in Abinitio test cycles while loading data from various source systems into Sales force.com and also
from sales force to Oracle for Cognos Reporting
- Checked the Data table records by executing the SQL Commands in TOAD.
- Executed the sql queries in Sales force explorer to verify the data is properly loaded into oracle or not for cognos reports.
- Performed Regression and Functional Testing.
- Prepared the Test data for UAT testing.
- Logged defects in Quality Center tool to assign to the developer.
- Giving Signoff from the QA after completion of the Testing.
Environment: Eclipse with Force.com Explorer ,Ab Initio 3.0,Data Stage 7.5, Apex Explorer,Apex Data Loader, Quality Center,Oracle 10g, Microsoft Excel.
Confidential,CA Jan 10 – Aug 11
QA Analyst
TACPAC-
It is web based tool which help CSE’s address customer issues knowing better the Customer Sentiment, SR history and also to provide the complete information like SR Type, Access to tools , CAP information etc regarding the SR’s to CSE engineer for which a new url is launched and also access to tools like CKT, CSE WB are provided.
Responsibilities:
- Involved in the development of Test cases and Test plans , by reviewing the Business Requirement documents,
- Interacted with Business analysts and QA Managers to clarify issues related to requirements.
- Arrange the meetings with Business analyst and clarify the issues related to requirements.
- Developed the test plans and test strategies to facilitate the process of testing
- Ensured traceability of test cases back to the Business requirements.
- Created different types of Service Requests in Oracle App’s.
- Manually check the Data base records while executing the SQL commands with TOAD.
- Performed positive and negative test cases to test the response of the application under test by
- Creating data driven tests.
- Performed manual testing of application using Quality Center to develop test cases, test scripts,
executing the scripts and logging the defects.
- Provided a weekly Defect report status to Team that includes test metrics and status of defects.
- Prepared the Exit Report in Power Point after the completion of each release.
Environment: Java, JSP ,SQL,Windows XP ,Oracle Apps, HP Quality center9.2, XML ,TOAD, Oracle 9i,.
Confidential,Sanjose Jul 08 – Dec 09
QA Analyst
Smart Services Dashboard-
Uses various ticketing systems through which the partner/customer issues are logged. These include RNT, Remedy and TSRT tools. The dashboard is being enhanced to provide better view into trends related to these different cases. The project goal is to deliver a dashboard that will help track the cases which have been escalated and have traversed the different customer service applications – Remedy (Alliance), RightNow and TSRT.
Responsibilities:
- Understand the Business Requirements, Interact with Business Analysts and QA Managers to clarify the Issues related to the Business Requirements.
- Involved in the development of Test Plans and Test cases by reviewing the Business Documents.
- Arrange Daily meetings with QA Testers to get the status of the Day and to assign the work for thenext day
- Develop the test plans and test strategies to facilitate the process of testing
- Ensured traceability of test cases back to the Business requirements.
- Performed Manual Testing on front end web application and logged defects in both Quality Center and Cisco Defect Enhancement Tracking Tool.
- Performed Functional, Integration, Regression, System and User Acceptance Testing of Smart services dashboard application.
- Checked the Data table records by executing the SQL Commands in TOAD.
- Created various types of service requests in Right now tool(RNT), Alliance tool,TSRT tool and adding notes to each and every request.
- Verifying the back end oracle table test data to make sure that it is properly reflecting in the dashboard after night batch cycle completes.
- Involved in Daily and Weekly Over All Project status meetings from Testing side.
- Involved in Training the Off shore team and the new members in the team with the front end web application and also checking the database table records manually.
Environment: Windows XP ,Quality Center, CDETS , Oracle 10g, TOAD,, MS Office, , Remedy Tool,RNT
tool,TSRT tool.
Confidential,Sanjose Mar07–Jun08
QA Analyst
Confidential, (CSC)
Is a web based application and its service space is presented to consumers in distinct, non-integrated and disjoint delivery
systems, such as MySDN, PSIRT, IPS Signature, TAC and Intellishield Alert Manager, Advanced Services, and BU sites.
CSC has two distinct parts such as Admin tool and End User (Consumer).End User (Consumer) can access the CSC application from Non Cisco networks like internet but whereas Admin tool should be access from Cisco intranet.
Admin has the capability to administrate the CSC application in two ways such as Choose a page to administer and Edit functionality on landing page. End User (Consumer) can view credible information about threats and vulnerabilities that may affect their environments. Intellishield Alert Manager allows organizations to spend less effort researching threats and vulnerabilities, and focus more on a proactive approach to security.
Responsibilities:
- Involved in developing test plans from business requirements by interacting with end-users and
developers related to production problem fixes.
- Ensured traceability of test cases back to the Business requirements.
- Involved in testing the application in multiple browsers viz., IE 6.0 and Firefox 3.0 ,Safari to ensure the cross-browser support.
- Involved in modeling QA process workflow using Team Track.
- Involved in Manual testing using Team Track to develop test cases, test scripts, executing the
scripts and logging the defects.
- Worked on MS Access.
- Involved in Functional, Integration, Regression, System and User Acceptance Testing of CSC
application using Quick Test Pro (QTP).
- Interacted with developers to explain where required, software bugs and re-tested the fixed issues.
- Identified and documented all issues and defects to ensure application software functionality.
Environment: Java, HTML, Java Script, PL/SQL, Windows XP,Safari browser, TOAD,Oracle 9i ,QTP,Team Track.
Confidential,PA Jul06 – Feb 07 QA Analyst
Confidential,is a global research-driven pharmaceutical company dedicated to putting patients first. Merck discovers, develops, manufactures and markets vaccines and medicines to address unmet medical needs. Merck recognizes that Healthcare professional schedules can be demanding and they need Merck product information and services in spite of these demands. To solve for this, Merck has developed Merck OnCall®, an innovative electronic product presentation solution. Merck OnCall® allows customers to connect with a Merck Representative at their convenience to get the product information and resources they need. Merck OnCall® also provides an easy way to request samples for Merck products, request educational materials for patients, etc.
Responsibilities:
- Involved in manual testing and Automation testing of web application.
- Performed Functional, System, Integration and Regression testing.
- Analyzed system requirements and created test cases and test scenarios.
- Manually traced test cases to requirements using Requirements Traceability Matrix.
- Timely updated the test cases with the modified/newly added requirements from Change Control Board (CCB).
- Verify the requirements from the system against the expected results documented in the test cases using both normal/valid and abnormal/invalid input and conditions (negative & positive testing).
- Involved in writing SOPs
- Involved in Data driven Web Service testing.
- Involved in executing QTP Scripts.
- Extensively used Page, Image, Text Check points in Quick Test Pro
- Developed the VB scripts in Quick Test pro to support the verification of Conditional statements, looping statements.
- Used clear quest for reporting defects.
- Involved in writing SQL queries to test the data stored in Merck On Call database.
- Prepared Test Metrics on a weekly basis to know the status of the application.
- Attended project meetings, release meetings, and QA status meetings.
Environment: Windows NT, Oracle 9.x, Java, JSP, SQL Nav, Flash, Flash Action Script, Flash Media Server, Web services, SOAP, VB Script, Siebel, Quick Test Pro and Clear Quest.
Confidential, Jul 05 – Jun06
QA Engineer
GL Migration:
The goal of the GL Migration is to achieve a \'like for like\' migration into SAP, of the existing GL processes and functionality within: Millennium Australia accounting environment for Australian Financial Services (AFS) Millennium Treasury Sub Ledger accounting environment for Australian, UK and USA Wholesale Financial Services.
Responsibilities:
- Involved in the development of test requirements from business use cases by interacting with business analysts and developers.
- Involved in the development of test plans and test strategies to facilitate the process of testing .
- Ensured traceability of test cases back to the Business requirements.
- Created various test account numbers in SAP for various regions (Aus,US ,UK) and checked whether they are reflecting in the database.
- Performed System Testing, Integration Testing, Regression Testing.
- Performed SAP Interface Testing to validate source data.
- Performed manual testing of application using Test Director to develop test cases, test scripts, executing the scripts and logging the defects.
- Extensively used Test Director, for test planning, defect tracking and reporting.
- Performed backend testing on Oracle, executed various DDL and DML statement.
- Responsible for executing all kinds of testing methods such as compatibility, regression, performance
and end-to-end testing.
Environment: SAP, Test Director,Windows XP, TOAD, Oracle 9i, UNIX, Excel Sheet.
EDUCATION:
Bachelor of Technology in Electronics and Communications.