Sandhya Rani Chethi
PROFESSIONAL SUMMARY
Over 9 years of experience in Software Testing & Quality Assurance, worked with major clients like Home Depot, Novell, Blackboard. As part of my assignments, I have been involved in different stages of the Software Development Lifecycle (SDLC), Application Maintenance, Production Support, Functional Studies and Quality Reviews along with Functional maintenance activities. QA EXPERTISE
Extensive experience in Retail domain worked on Cloud App, WCS, Page Builder, Experience Manager, Endeca, Cassandra, API, and OMS.
Extensive working experience in Agile (Scrum) and Waterfall methodologies.
Testing of applications both manually and automation using Selenium & Web driver IO.
Strong expertise in developing and reviewing test documents - test strategy, test plan, test cases and allocation of task, test execution, reporting and tracking status of the test.
Good experience in test data creation and maintenance.
Experience includes Unit Testing, Integration testing, System testing, Smoke testing, Functional testing, Sanity testing, Regression testing, user Acceptance testing and Non-Functional like Compatibility testing, Cross browsing and beta testing in every release.
Analyzed scope, requirement documents and provided detailed estimations.
Experienced in Effort Estimations and Resource Planning & Metrics capturing
Worked closely with the application teams and project managers as programs are developed.
Leading a test team with thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
Proficient in using test tools - JIRA, Pivotal, HP ALM, Quality Center.
Executed the Automation Test Scripts using Selenium & WebDriverIO.
Working experience in UNIX and SQL querying.
Hands on Experience in reporting and analysis.
Browser compatibility testing with different browser versions available in market and on different operating systems.
Performed Non-functional testing like browser compatibility, cross-browsing, external interface testing.
Performed functional testing of SOAP and Restful Web Services using SOAP UI Tool.
Validated request and response XML based web services interfaces using DEV Test and SOAP UI.
Performed the back-end testing to ensure data consistency on front-end by writing and executing SQL queries.
Hands on experience in Mobile, Tablet testing.
Good experience working in Multi-vendor environment. Technical Skills:
Below is a list of important hardware, software products, tools and methods that I have worked with Reporting Tools
JIRA, Testopia, Bugzilla, ALM, QC, Pivotal.
Management Tools
FTP, All Fusion Harvest, SharePoint, CMC, WCA, OMS, Netstorage. Other Tools
Toad, Cisco VPN, Citrix Client, Opera, WinSCP, WinCVS, Putty Application
Servers
Tomcat, Apache
Page 2
Database
Oracle, SQL Server, Oracle, DB2
Internet Tools
HTML, VB Script
Languages
C, C++, Visual Basics
Operating System
Windows 2007, Windows XP Professional, Unix
Management and
Leadership Skills
-Experienced in Mentoring and leading testing teams and projects.
-SQA Process compliance, adherence and implementation for different projects within the Organization.
Training & -Participated in Internal Quality Audits for projects within the Organization. Development
-Involved in training team members and new joiners on different modules of Application - System, Testing methodologies and job-oriented trainings.
-Active Trainings undertaken regularly for different project teams within the Organization.
WORK EXPERIENCE – PROJECTS HANDLED
Project Name: Multi Channel Browse (MCB)
Client: THE HOME DEPOT Jun 2015 – Till date
Description of the Project: Multi-Channel Browse implementation allows business users to define/create Desktop and Tablet Product Listing Pages along with Homepage, Category & Content pages. Business will be able to create PLP [Product Listing Pages] using FETCH tool and promote it to live environment after previewing, the preview action is performed in the FETCH tool while page creation is still in progress, which is an advantage where-in users can visualize the page and thus the contents of the page even before it is being published. Role: QA Lead
Responsibilities:
Acted as a SME for MCB application.
Followed Agile Scrum methodology, Involved in Grooming sessions with the Product Owners and then Planning session by providing the Test estimation points by Scrum Poker for each story and Identifying the stories for the current Iteration.
Creation and maintaining the Test Strategy for each sprint and acts as a single point of contact for project issues and risks escalation working alongside the technical, business leadership and testing teams.
Identify test approaches that optimize the delivery schedule.
Playing a Lead role responsible for coordinating with offshore team that there is no deviation in any of the Iteration deliverables.
Identify test approaches that optimize the delivery schedule.
Used Jenkins continuous integration server to run Selenium automated test suites.
Executed the Automation Test Scripts using Selenium & WebdriverIO
Worked on distributed test automation execution on different environment as part of Continuous Integration Process using Selenium Grid and Jenkins. Page 3
Help teams in issue resolution. Coordinates all test data/environment requirements. Act as the first point of escalation for testing delivery, risk/issues, schedule and budget.
Coordinating the work of test teams and monitoring their performance.
Involved in Peer review of the Test Cases written for each User Story
Analyzed test results, tracked the defects and generated reports using JIRA
Conducting defect Triage meetings on a daily basis to follow the defect status and track them until closure.
Involved in Retrospective meetings providing the feedback to the Scrum masters about each Iteration.
Involved in Preparing Test Documents required for Internal Board Review (IRB) for Project Go-live. Technology/Tools : Agile, Java,Selenium webdriver, WebdriverIO, github, Jenkins, SOAP UI, Firebug, XML Sterling, COM, Java,J2EE, WCS, Cassandra, Internet Explorer, Chrome, Firefox, Project Name: Value Pricing2 - Minimum Advertise Price. Client: THE HOME DEPOT Feb 2015 – May 2015
Description of the Project: This project is to govern price display on HD.com and other affiliates browse pages in adherence to MAP compliance. For any item, browse pages should not advertise (display) any price less than MAP price if MAP price exists and item is MAP eligible. Role: QA Lead
Responsibilities:
Acted as the single point of contact as onshore technical contact.
Involved in Functional Testing with developers, database testing for validating the data.
Allocated work / tasks to the individual team members.
Created and implemented test plans and test Strategy.
Ensure adherence to quality requirements and project schedules.
Maintained and archived project documents and templates that need to be agreed upon.
Provided technical assistance to the team members as and when needed.
Provided project status update by preparing WSR’s and Monthly Metrics of the project.
Interacted with various cross commit teams regarding many issues.
Executed the batch files and pulled the files from Mainframe locations.
Monitored the overall health of the testing project.
Prepared Monthly dashboard.
Process improvement for the regression and gap analysis for each release
XML log file Validation and web services testing
Status report sending daily and participated in defect review / Status / GO-NOGO Meetings
Performing Knowledge transfer to the Team members
Coordination between the client and offshore team and production support for all the releases Technology/Tools: Java, J2EE, XML, Oracle, Quality Center 9.5/10, IBM Web sphere Commerce Server 7.0, Endeca Workbench, Selenium, Pacman
Project Name: In Store Online Experience
Client: THE HOME DEPOT March 2013- Jan 2015
Description of the Project: This project will offer customers create a superior experience starting from research shopping to purchase. The ION work stream portfolio have the following modules Home page, Global Page 4
header/Footer, Contact Us,Sitemap, FAQ, Opinions, Product Recommendations, Recently Viewed, Store Finder, Page per store, localization, Category, Gen3 pages, defects enhancements, new functionality are added by business for the ION portfolio and proweb deferred defects comes under ION project, it’s bi-weekly releases part of scrum methodology.
Role: Sr. Quality Analyst
Responsibilities:
Created and implemented test plans and test scripts based on technical specifications and business requirements.
Analyzed Business requirements and Functional requirements in JIRA
Effectively implemented QA methodologies, strategies and plans all stages of SDLC.
Involved in the creation of test plan, test cases and test procedures required for Manual Testing.
Used Quality Center as the defect-tracking tool to enter defects regarding the issues found during testing.
Using Quality Center to create the test plan, store test cases and run the test sets.
Maintained requirements and created Traceability between Requirements and Test Cases using Quality center.
Developed and executed test suites and operations scenarios to find and report defects using Quality center.
Leading the Offshore testing team.
Reporting the offshore testing status thru daily status call with onsite manager.
Categorized bugs based on the severity and interacted with developers to resolve them.
Actively participated in Status reporting meetings and interacted with development team to discuss the technical issues.
Conducted result analysis and interacted with developers to resolve bugs.
Analyzed software bugs, interacted with the developers on getting the problems fixed, verified and closed the bugs, as they got resolved.
Have exposure to selenium IDE with Firefox plug in, which allows recording, playing back, editing and debugging tests in the browser.
Technology/Tools: Java, J2EE, XML, Oracle, Quality Center 9.5/10, IBM Web sphere Commerce Server 7.0, Endeca Workbench, Certona, Selenium
Project Name: Appliance kiosk
Client: THE HOME DEPOT Oct 2012- March 2013
Description of the Project: This project will offer customers create a superior experience starting from research and shopping to purchase. This phase will build the foundation for bulk pricing, including a single tier of discounts and simplified messaging to customer’s availability flags, in-cart discount calculations and checkout integration Role: Sr. Quality Analyst
Responsibilities:
Requirements Analysis, design, application development, testing, deployment and production support
Leading the Offshore testing team.
Reporting the offshore testing status thru daily status call with onsite manager.
Regular interactions with the client managers about the issues and tasks.
Test management activities using Quality Center tool (preparation, review, Execution and defect reporting)
Preparing and reporting Daily & Weekly status report to client. Page 5
Done extensive testing in external tools like CMC, Accelerator, PACMAN, Setting up the test data
Verifying System log and exception log in Unix system using WinSCP
Verifying Orders in B2B, OMS, CSR and processing its status level. Technology/Tools: Java, J2EE, XML, Oracle, Quality Center 9.5/10, IBM Web sphere Commerce Server 7.0, OMS, POMS, CTC, Sterling,
Project Name: Bulk Pricing
Client: THE HOME DEPOT Jan 2012 - Sep 2012
Description of the Project: Bulk Pricing Project is to offer customers bulk-pricing discounts on selected categories of products. The program is largely targeted toward Pros. It is designed to better support the needs of the Pro community, and to promote bulk purchases through a price discount incentive. The Bulk Pricing Program will be delivered in two releases. Release 1 of the project would offer bulk pricing on the site for BoPIS-only SKU’s in specific markets and will build the foundation for bulk pricing to support the next phase. Role: Sr. Quality Analyst
Responsibilities:
Prepared and reviewed the Test Plan document.
TC preparation, review & Execution and reporting the status to client.
Involved in schedule estimation for the entire Test activities.
Reviewing the created/modified test cases prepared by team members.
Involved in the complete defect management cycle.
Preparing and providing the complete project metrics as per quality process
Preparing the test report, Smoke testing / Build verification testing/Regression testing.
Providing supports in shift hours and stretched during weekends during Production release. Technology/Tools: Java, J2EE, XML, Oracle, Quality Center 9.5/10, IBM Web sphere Commerce Server 7.0, OMS, POMS,CTC, Sterling,
Project Name: WCS 7UP
Client: THE HOME DEPOT Oct 2010 – Jan 2012
Description of the Project: The Home Depot is one among the biggies in retail business in USA. They deal with both in store and online trading of appliances and utilities. WCS 7Up is the project for the upgrade of web sphere commerce server from 5.6 to 7 and few new futures included in 7.0. This comprises of various functionalities e.g. checkout, shopping cart, my account, catalogue etc. Web Sphere Commerce is a software platform framework for e-commerce, including marketing, sales, customer and order processing functionality in a tailor able, integrated package. It is a single, unified platform, which offers the ability to do business directly with consumers, with businesses, indirectly through channel partners or all of these simultaneously. Role: Track Lead
Responsibilities:
Analyze Business Requirements and User Stories to understand the application.
TC preparation, review & Execution and reporting the status to client.
Involved in schedule estimation for the entire Test activities.
Involved in the complete defect management cycle.
Involved in testing Page Builder, which involves creating Pages using Endeca workbench
Cartridges/templates, creating geo-location rules, rules for Homepage, rules for category pages.
Also involved in creating Promotions like % off, coupon codes, IPR, Rebates using Commerce Page 6
management center.
Involved in testing Store finder, localization, pick up in store (BOPIS).
Involved in testing Checkout - Add to cart, Tender type – gift card, visa, master. Bopis, order creation, order cancellation
Tested Certona on Homepage, shopping cart page.
Improve test models, test data, and test processes based on lessons learned.
Regular updates on the iteration status in client dashboard.
Taking the complete ownership of setting up the test data.
Responsible to involving in designing, executing functional, and Integration Test cases.
Extensively involve in review of test cases within the team.
Identify recording and closing bugs through the entire test life cycle.
Interacting with the client for queries resolution, requirements gathering, analysis and scoping Technology/Tools : Quality Center 9.2, Java, IBM Websphere Commerce Server 7.0, DB2, Endeca Workbench, Commerce management tool, Accelerator.
Project Name: Sentinel RD
Client: Novell Inc., Sep 2008 – Jan 2010
Description of the Project: Sentinel replaces the labor-intensive manual processes with automated, continuous monitoring of security and compliance events and IT controls. Sentinel correlates and analyzes security and compliance events from all data sources in an environment that helps to identify security events in real time and respond quickly. Automated incident response management enables to document and formalize the process of tracking, escalating and responding to incidents and policy violations, and provides two -way integration with trouble-ticketing systems. Sentinel enables you to react promptly, resolve incidents efficiently and prove to auditors that an IT controls work as required
Responsibilities:
Perform initial tasks like Installation testing and Build Verification Testing.
Installing the Server and launching sentinel on the client machine using jnlp file validating the build.
Test Case authoring and refinement using Quality Center.
Bug Drafting, peer-to-peer Defect review and Defect Management.
Effective Bug Regression on a sprint basis.
Involved in Scrum process, creating Test plan, Test strategy, Closure reports.
Involved in Sprint Review Meeting, Daily Scrum Meetings.
Product Upgrade Testing involving Service Packs and Hot Fixes.
Authoring Test conditions from the functional specification.
Preparing Test Cases and executing Test Cases in different browsers.
Preparing and reporting daily & weekly status report on testing.
Involved in Functional, Ad-Hoc, Integration and Regression testing at various phases.
Reports testing such as Crystal and Jasper reports and performed Database verification using
Document Reviews of product related ‘Help’ files and online documentation.
Team Coordination, Mentoring, Reporting test execution status and Defect reporting with the onsite and client relationship teams.
Tools & Technologies: Java, JSF, EJB3, Servlets, JSP, JDBC, HP Quality Center 10.0, HP Load Runner, HP QTP 10.0, SUSE® Linux Enterprise Server 10 (32- or 64-bit) Project Name: Novell-OES Open Enterprise Server
Page 7
Client: Novell Inc., Jan 2008-Sep 2008
Description of the Project: Novell Open Enterprise Server (OES) is best thought of as a platform for delivery of – level shared network services (file, print, directory, clustering, backup, storage management, web applications, etc.) and common management tools. OES can run atop either a Linux or a NetWare kernel. Clustered configurations can include nodes with either kernel types, and most services can migrate freely between the platforms. Thus, customers can deploy the platform selection that best suits their needs, as opposed to being locked into a single platform. OES - Linux: When installed using a Linux kernel, the product is known as OES-Linux. This uses SUSE Linux Enterprise Server (SLES) as its platform. Atop the SLES install, daemons are added to provide NCP, eDirectory, NSS, iPrint and other services delivered by OES. Responsibilities:
Performed initial tasks like Installation testing and Build Verification.
Performed Installation testing Using virtualization (VMware) technology.
Developed a Testing strategy before testing.
Involved in developing test cases and test scripts based on the requirements using Quality Center.
Maintained and updated Test metrics on build basis along with defects summary.
Performed load testing using ldappy, I/O tests manually and Automated using Load runner.
Involved in testing whole application to make sure with the free flow of application.
Attending client call on schedules and preparation of MOM (Minutes of Meeting) after the Client Calls
Tools & Technologies: Java, J2EE, Java Scripts, HP Quality Center 10.0,Novell Netware and Open Enterprise Server(OES), Windows XP/Vista, Linux, Test Director/Quality Center Project Name: Novell Client
Client: Novell Inc., Aug 2007- Jan 2008
Description of the Project: The Novell Client workstation software extends the capabilities of Linux and Windows desktops by providing access to NetWare and Open Enterprise Server (OES). Once installed on workstations, Novell Clients enable users to enjoy the full range of Novell services such as authentication via Novell eDirectory, network browsing and service resolution, and secure and reliable file system access all delivered through industry-standard protocols. The Client supports Novell's traditional NCP protocol. Responsibilities:
Reporting test execution status and Defect reporting with the development teams
Review of test cases and query updating.
Test cases authoring / Execution..
Prepared User Guide and Release Notes for the new application releases.
Upgraded the application from the old version to a new version.
Defect logging into Defect tracking tool - Mantis, defect closure and re-testing.
Reporting critical issues and defects to the Dev. team and updating the status.
Attending in daily, weekly status meeting while testing the application.
Demonstrated the product to the customers using eLuminator.
Tested the Application using Novell Client.
Tools & Technologies: Java, J2EE, Java Scripts, HP Quality Center 10.0, Novell Netware and Open Enterprise Server(OES), Windows XP/Vista, Linux, Test Director/Quality Center, Jira, Bugzilla