Sr QA Analyst
Resume:
MADHUSREE BANERJEE
**********@*****.***
SUMMARY
• Four years of experience in Software Testing and Quality Assurance
• Extensive experience in System, Functional and Integration Testing
• Excellent knowledge and hands-on experience in writing Test Cases, Test Execution and Defect Tracking
• Have extensive working experience in Agile Methodology like Scrum
• Have extensive experience in Web Based, Client Server and Order Management Product Testing
• In depth knowledge and work experience on Quality Center, StarTeam
• Extensive experience in designing test cases in Silk Test
• Highly Proficient in writing SQL queries for Database Validation using SQuirrel and Toad
• Have extensive experience in Siebel testing
• Excellent domain knowledge on Fleet Cards and Order Management Systems/Products
• Good Experience on preparing Test Plans, Approach and Strategy
• Have knowledge on various Test Metrics
• Excellent team player, quick learner with strong communication skills and willing to take initiative always.
• Undergone training on Test Automation techniques and QTP 9.2.
CERTIFICATION
• ISTQB Foundation Level Certification
• Certified Course in Business French
COMPUTER SKILLS:
Test Management Tools Quality Center, StarTeam
Scripting Language/Tools SQL, VB Script, XML, HTML, SQuirreL, APITester, Toad
Testing Tools Quick Test Professional, Silk Test
Database Oracle 9i, MS Access
Operating Systems Windows Vista/XP/2000/NT/98
CRM Tool Siebel 7.5
WORK EXPERIENCE:
Cognizant Technology Solutions Jul 2005 – Nov 2009
Client: Staples (Offshore) Nov 2008 – Nov 2009
Staples, Inc. invented the office superstore concept in 1986 and today is the world's largest office products company. With 69,000 talented associates, the company is committed to making it easy to buy a wide range of office products, including supplies, technology, furniture, and business services. Staples serve consumers and businesses ranging from home-based businesses to Fortune 500 companies in 21 countries throughout North and South America, Europe and Asia.
Project Description
Staples Promotional Products (SPP) and Customer Order Management (COM) Integration project is one of the project tracks of the YOMS BR3 initiative. The purpose of this project is to get the SPP orders for Staples Business Delivery (SBD) customers from SPP OMS system (aiLinc) to Staples OMS system (COM). Managing only SBD, SPP Orders is a risk mitigation strategy adopted by Staples.com business team to manage a subset of SBD orders with a subset of functionality before they can use COM system for Staples.com order volume. This new system will also provide an automated invoicing functionality on COM upon completion of shipment.
Roles & Responsibilities:
• Understanding and analyzing the System requirement specifications
• Designed test cases using Silk Test
• Test Case Execution for the application and Database
• Logging, analyzing and managing defects in StarTeam
• Designed SQL queries for database testing using the tool SQuirreL
• Prepared and managed Test Data for the entire Order Life Cycle using XMLs
• Giving KT to newly joining team members
• Prepared Daily/Weekly Status Reports
• Attending the status call meetings with the onsite counterpart
Client: Baker and Taylor (Offshore) Oct 2008 – Nov 2008
Baker & Taylor is the world's largest distributor of books and entertainment, in business for over 180 years. Based in Charlotte, North Carolina, and privately owned, in 2006 it had $2.2 billion in sales, employed 3,750 and was # 181 on Forbes list of privately owned companies. Baker & Taylor's core business distributes media - books, calendars, music and DVDs to libraries throughout the world. Its retail unit distributes approximately 1 million book titles and 311,000 CDs and DVDs to retail booksellers - both physical stores and internet operations.
Project Description
The Customized Library Services (CLS) unit of Baker & Taylor provides cataloging and processing services to libraries all over the world. In order to improve the efficiencies of the operations area of CLS and reduce the cost, a new approach to cataloging material needs to be developed. That is the purpose of the Online Routing System (ORS). The Online Routing System will replace the paper system for providing order information to the copy cataloger. Instead of working directly with the material (Book, DVD or CD), the Online Routing System will provide title information for the copy cataloger to perform their work. The web-based system will allow copy catalogers to perform their work from anywhere and not be restricted by the location of the material.
Roles and Responsibilities
• Understanding of the System requirement specifications
• Designed the test cases for the Customer module as well as UPH calculation.
• Executed Test Cases for Sanity, Functional and Regression Tests
• Logging, analyzing and managing defects
• Co-coordinated with the development team members to understand and fix the defects
• Attending the status call meetings with the onsite counterpart
• Providing support during User Acceptance Testing
• Giving KT to newly joining team members
Client: Wright Express (Onshore/Offshore) Oct 2005 – Sept 2008
Wright Express (WEX) is one of the premiere companies working on the Fleet card application in USA. WEX has helped invent the fleet card market and pioneered the industry starting in 1983. Today, WEX is a leading provider of payment processing and information management services to the commercial and government vehicle fleet industry in the U.S. and Canada.
Project Description
WEX fleets using the services with detailed transaction data, analysis tools and purchase control capabilities. The applications are linked to a variety of environments that caters to the security and robustness of the applications. The front-end applications are tied to a CRM package developed in Siebel 7.5. There are various online applications developed in J2EE for WEX clients and partners e.g. Exxon Mobil, Tesoro Oil Corporation, Sinclair & Pacific Pride. A Fleet-pilot user provisioning application is the admin interface to the online applications. Oracle is used as the backend and LDAP is used for the user authentication. Massive size of the data involves DW and SQL tuning as well.
Roles and Responsibilities
• Developing test cases, test design specifications for functional testing, regression testing and sanity testing
• Responsible for designing and Implementation of Test Strategy, Test Plan and Test Approach
• Maintaining Traceability (Requirements to Defects) in Quality Center
• Prepared and managed Test Data
• Execution of functional, regression and sanity test cases from Quality Center
• Defect Logging and Tracking in Quality Center
• Designed SQL queries for Database validation using TOAD
• Participated in client meetings
• Weekly and daily status reporting to Online Onsite coordinator
• Giving KT to newly joining team members
EDUCATION:
Bachelor of Science (Physics Major) from Calcutta University, India in the year 2005.
Date of Birth: 29th April 1984
Work Authorization Status: Employment Authorization Card (EAD)
Contact this candidate