Test Cases Project

Chandra Shekar Aitha

Mobile : +1-302-***-**** Email : *************.********@*****.***

Profile

Over 14+ years of experience in IT industry with 9+ years in both manual and executing automated test scripts for software Quality Assurance Testing on client-server and web-based applications with in-depth understanding and 4+ years as business analyst in Mortgage, Recruitment, financial, supply chain and distribution domains.

Vast experience in working off-shore and On-shore models across all the regions.

Experience in managing Scrum projects, including blending Agile practices with existing processes as well as gaining executive and organizational support for transitions to Agile practices

Experience in testing functional requirements of the application along with the non-functional requirements as provided by the client and in general.

Strong experience in Requirement Analysis, Test Plans, Test Strategy, Estimations, Traceability Matrix and Risk Analysis

Experience in various types of testing like Black box, unit testing, integration testing, regression testing, User acceptance testing, security testing, mobility testing, browser compatibility testing

Preparing Release notes for every sprint which includes the functionalities of the user story which has been developed.

Experienced in API testing using Rest Client and SOAP UI

Strong experience in web content management system Sitecore, efficient in verifying configurations, templates, settings for different business units and different environments.

Managing agile projects using Visual Studio Team Foundation Server, JIRA and Rally for requirements management, project management, test cases management and reporting

Experience in defect management using Microsoft Test Manager, TFS, Rally, PractiTest and HP ALM (HP Quality Center)

Helps development team in resolving bugs by troubleshooting code from browser console and also provide correlation id’s to pinpoint the bug by checking the logs.

Ensure to adhere to the test execution criteria mentioned in the test plan

Delivering the test results metrics to the management on the agreed frequency to monitor the status on periodic basis to understand the project health Index and take the appropriate steps for better delivery. Involved in Internal Quality Audits

Preparing the test summary report to the management at the end of each build depending upon the requirements at each environment like Dev, Test, Integration, Stage and UAT

Ensuring the team meets the objectives in terms of writing test cases, executing test cases, creating bugs, validating bugs, and keying the right information in the systems.

Vast experience in developing and maintaining library of test scripts for re-use across projects and as regression test beds

Experience in scheduling and work allocation to the team members of team size – 5 to 15 resources in different scrums

Facilitating root cause analysis for the bugs which were created by the team with management and developers.

Cascading the Criticality and Priority metrics to the team by discussing the same with the business analysts.

Maintaining the automation scripts which are written for performance testing.

Coordinating with the scrum team (Developers, Business Analysts and testing team) to close the bugs created on a timely manner

Good experience in writing SQL queries for data validation as part of data base testing

Strong written and verbal communication skills & interpersonal skills with proven abilities in Customer Relationship Management & Team Management

Experience in using Microsoft Office suite to prepare reports in excel and present the same in power point to the higher management.

Experience in using Business Objects 6.5 and BOXI, SQL, pgAdmin III, HeidiSql and Oracle for data validation.

Certifications

“Scrum Master Accredited Certification” from International Scrum Institute

ITIL V3 Certification: Completed ITIL V3 Foundation course from Quint

Green Belt Certification: Completed a GB project titled “Optimization of reports”. The goal of the project is to reduce the number of sales and financial reports by 40% and save 4HC. Procedure used to do this project is ‘DMAIC’.

Green Belt project member of the project title – Centralization of Internal Orders Process.

Best Kaizen of Quarter: Awarded with best Kaizen for the quarter for avoiding the printing of no charge invoices for shipment clearance.

Project Details

Client : DRB (Darien Rowayton Bank)

Project : POS Application – Point of Sale

Role : Lead Quality Assurance Analyst

Location : Bridgeport, CT

Tenure : Feb 2016 to till date

Description:

DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

DRB is a market leader in providing low rate student refinance loans to working professionals with graduate degrees and undergraduate degrees is venturing into mortgage industry and thus building a new application called POS.

My role as a Lead QA analyst includes –

Participate in all the activities of the Scrum as the project is driven by Agile methodology

Understanding and analyzing the requirements / user stories which are available in Rally and JIRA

Estimating the testing tasks for the user stories

Authoring test scripts for the user stories and executing the same when the stories are deployed for testing

Logging defects and validating the same once they are resolved by developers. Rally is used for defect tracking

Demonstrating the functionalities of a user story delivered at the end of the sprint to the stake holder

Extensive exposure to the integration testing as there are 20+ integration services used in the application

Accountcheck DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

Using Postman and Poster for the API testing

Using PostgreSQL and HeidiSQL for backend testing

Experience in user role based testing for application administration purpose

Coordinating with offsite QA team – Conducting requirement elaboration sessions, defect triaging, performance metrics preparation, reviewing the test cases written by the team

Interact with Business Analysts and Development team for clarifications and cascading the same to the team

Involved in testing the application during the product release.

DRB is a market leader in providing low rate student refinancing loans to working professionals with graduate degrees, has expanded

its offerings to include loan refinancing for undergraduate degree holders and for parents who took on loans to finance their child's

education

Client : Stonegate Mortgage Corporation

Project : TPO Connect (Third Party Origination) and Work Queue

Role : Lead Quality Assurance Analyst

Location : Indianapolis, IN

Tenure : Sep 2015 to Jan 2016

Description:

Stonegate Mortgage Corporation is a leading mortgage company that originates, finances and services agency and non-agency residential mortgages through its network of retail offices and approved third party originators.

My role as a QA analyst involved testing of various web based applications of Stonegate Mortgage Corporation like –

TPO Connect - Third Party Origination Connect application is a loan origination application which is available for Brokers and correspondents.

Work Queue Application – It’s an internal SGM application to track the flow of a loan application in case, if there are any changes made after the final file submission. Loan application is moved across different stages where different teams’ works based on the business rules.

Automated File Intake – It’s an internal SGM application where various teams can access all the documents available against the loan number based on their access levels

Roles & Responsibilities:

Adhere to the ‘Agile’ software development lifecycle methodology during the complete course of the project.

Participating in Sprint Planning meetings, Scrum meetings, Task review meetings along with the developer, business analysts and product owner to understand the user stories, development status of the story and discuss if there is any ambiguity in the requirements of the story.

Defining test cases, test matrices, and writing test scripts from business requirements (User Stories) to confirm that systems meet business objectives

Reviewing existing Test Design, Test Approach, and Test strategy documents and updating the same whenever there is a change.

Creating, customizing and tailor the test reports as per business needs by extracting the data from MTM and TFS.

Experience in working with off-shore and on-shore teams.

Worked with Architects and Developers to understand the system being built and develop a test plan that focuses particular attention on potential areas of vulnerability.

Performed Positive and Negative testing against requirements.

Performed Manual Testing of the application Front-End and Functionality.

Wrote SQL Queries in SQL Server Management Studio to validate backend data.

Executed the regression test cases along with testing new enhancements by using MTM and TFS.

Logged and tracked defects in MTM and TFS and assigned to developers to fix the issues

Fit - Gap Analysis for old system to new system requirements

Executed SQL queries for back end data base testing

Experience in testing web services using Rest client

Client : Adecco group.

Project : Candidate Integration Solution

Role : QA Integration Lead

Location : Melville, New York

Tenure : Oct 2013 to Aug 2015

Description:

The Adecco Group is the world's leading provider of HR solutions with more than 5,000 branches in 60 countries. They provide services for broad categories of temporary staffing, permanent placement, career transition and talent development, as well as outsourcing and consulting. CIS project has 4 major applications, Candidate Management System (CMS), Self Service Portal (SSP), Recruiter Work Place (RWP) and Search and Match (SaM).

Migrating other BU’s (business units) data to CIS application using multiple ETL’s developed by Informatica team. As part of data migration testing, written test scenarios to test the data integrity, consistency based on the migration mapping structure provided by functional team.

Candidate Management System (CMS) - It is an individual site of a brand within its operating region. Adecco has around 9 brands in different regions expended in different countries. Build all these sites in CIS using Sitecore as a content management tool

Self Service Portal (SSP) – It is a complete candidate profile and requirements portal. Where in candidate can register, sign in, search for jobs, apply for jobs, set alerts and manage profile

Recruiter Work Place (RWP) – This application caters to the functionalities of recruitment team like job posting, candidate search, managing interview process, job fulfillment, etc

Search and Match (SaM) – This application is used an integrated application with RWP or as a standalone application. This helps in searching a job/candidate with the criteria and matching the same with a suitable candidate/job

Responsibilities:

Analyzed the Business Requirements Document, created the test plan and prepared detailed test cases for INT and UAT

Updating Framework functions when needed in an Agile and Test Driven Development

Using Microsoft Visual studio suite (TFS, MTM) for writing manual test cases, executing testing test cases and logging defects

Strong experience in web content management system Sitecore, hands on experience in verifying configurations, templates, settings for different business units and different environments

Helps development team in resolving bugs by troubleshooting code from browser console and also provide correlation id’s to pinpoint the bug by checking logs

Implemented Data-Driven test cases to verify the functionality with multiple sets of data

Create Test Strategy, Traceability Matrix and other testing related documents.

Executing the project in Agile Scrum model and well versed with sprint model

Involved in daily stand up, Sprint planning, sprint review and retrospective meetings with Scrum Master and product owner

Participating in planning poker game with scrum team for estimating the effort required for each user story

Used Team Pulse and Version One to go through the user story details like description, tasks, acceptance criteria

Analyze the requirements and identify the features and functions to be tested by discussing with business analysts and subject matter experts

Maintaining regression suite from all the sprints and executing them after completing the testing of current sprint

Analyze the test results to identify the bottle necks that affect the applications performance

Involved in Reviewing, Enhancing, Executing Test scripts according to new features

Closely worked with developers and Business Analysts to nail down the defects

Participating daily defect review meeting with scrum team to discuss all open defects

Used Data Driven Testing methodology to test the application with multiple sets of data

Escalating any issues/concerns related to Project Requirevironment/ Connectivity/Showstopper defects.

Conduct root cause analysis of identified defects, providing development / business analysts with sufficient detail to understand, replicate and resolve

Used HP ALM 11.0, Microsoft Test Manager for Test management and defect tracking, generated different status reports for management to understand the project status

Prepared status reports to track the test status progress and to check if there is any slippage in timelines

Participated in the project status meetings with all the stake holders of the project

Document all the project related documents in the share point site

Environment: ASP.Net, VB.Net, Sitecore, TIBCO, SQL, MS Visual Studio, TFS, MTM, Informatica 9.5, Oracle 11g, Window XP, MS-Office, ETL, Soap UI, Web services, Jira, Version One, ALM 11.0

VMWare, Inc.

Project : Global Partner Strategy & Operations

Role : QA Lead

Location : Bangalore, India

Tenure : May 2010 to Aug 2013

Description:

This project involves define, analyze, modeling and deployment of the onboarding and termination processes of various types of channel partners into distribution channel of VMware. Inc. These processes help the organization to build a strong distribution channel by which they can reach out to potential customers and spread to other potential markets

Responsibilities:

Created the Test plan by including the test approach and test strategy

Involved in daily Scrum meetings, Iteration/Sprint planning meeting to plan the stories that needs to be developed and tested in the upcoming sprint based on the priority and estimated effort.

Used Team Foundation Server (TFS) for understanding the Product Back Logs (PBI), task creation and assignment, burning hours on daily basis for an accurate burn down chart to track the sprint performance

Executed test cases manually and identified mismatches by performing manual testing

Perform GUI, Integration, Functional, Regression, Positive and Negative, End-to-End and User Acceptance Testing for the application

Developed new methods and procedures for implementing test plan and schedules

Reported and tracked the defects using Quality Center

Attended JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to a solution

Preparation of documents that includes estimation and planning, writing test plans, test cases, test, scripts, and generating test data which involves all the phases of the QA process

Writing of test cases for manual verification of GUI Functionality of the Application

Creation of data driven tests for data input validations of text fields in the Claims Application Module

Captured GUI Map files for Automation of Testing Process using QTP Tool

Writing of test plan for implementation of testing process to meet deadlines and schedules

Creation of testing scenarios for cross functionality verification

Regression testing of the application for identification of bugs arising after initial fixing of bugs

Documentation of test results in error logging tool and customization of VB Script for automation of the testing process and enhancement of test scripts for use in subsequent builds of the application

Strong knowledge in loading the flat files, xml feeds, data from IMS mainframes into databases such as Oracle 10G, SQL server 2005

Escalated and communicated with development lead, business units, and cross-functional teams with project status and concerns/issues

Environment: IBM Mainframes and Oracle 9.2, TFS, Quality Center, ALM 11.0

Hewlett - Packard.

Project : Partner Knowledge Management Assets

Role : Quality Assurance Analyst

Location : Bangalore, India

Tenure : March 2008 to April 2010

Responsibilities:

As a Quality Assurance analyst in a global PKM team managed various projects. To name a few, PKM First Line Support Transition, Standardization of Reports, HP Share of Business, Return on HP Business, Migration of Flash Pro from BO 6.5 to BOXI.

Conversion from a Legacy Mainframe Application to Web Application

Responsible for Scope definition, Estimations, project planning work Allocation and people management.

Monitoring and controlling project progress, and ensuring quality deliverables.

Involved in Defect Management and Test Management activities.

Review weekly Test Execution report, Status report and preparation of Metrics report

Weekly status report meetings with the client

Created the Integration and Functional Test Plans.

Wrote Test cases from SRS and BRS for both Integration and Functional Testing.

Created Traceability Matrix between Requirements and Test Cases.

Peer Review of Test Scenarios and Test Cases and worked on the modifications.

Created different customers and verified if the customer data is correctly populated from Global Customer Database.

Performed the end-to-end integration testing of all the involved systems to test if the data is following correctly.

Coordinated in setting up the test environment and ensured all the services are up and running during the test process.

Executed the test scripts on different releases as well as in different modes and validated the actual results against the expected results.

Participated in bug review meetings and weekly status calls

Performed Regression testing and retesting after bug fixes and verified those fixes.

Documented all the Test Procedures and Test Scripts and placed them on a Shared Drive.

Hewlett-Packard Business Process Delivery Organization

Project : SPO reporting team

Role : Business Analyst

Location : Bangalore, India

Tenure : March 2006 to February 2008

Responsibilities:

Extracting the Sales and Financial reports requested by the Sell-Out Specialists across the EMEA region.

Handled the remote transitions for the UK, Germany and France reports from the Business Analysts.

Documenting the procedure to extract all the reports using Business Objects for UK, Germany and France.

Delivering the reports as per the SLA’s.

Calculation of the sigma scores of the team.

Presenting the volume metrics during the country calls and the PKM review meeting which held monthly.

Preparation of Monthly metrics and ascertaining the TAT, Key performance indicators, Accuracy percentages, Deviation analysis, Completeness of information and Pareto charts showing various statistics.

Worked as a first level escalation contact for the follow-ups which requires immediate attention.

Archival of required documents in Odyssey system as per GRS (Global Retention Schedule) policy.

Updating Process documentation, ISO documentation and preparation of JOB aids to the team members. Owner of CAPA document.

Worked on the Non-value added activities in the process and followed up with the clients to scrap them.

Hewlett-Packard Business Process Delivery Organization

Department : Vendor Payables – Centralized Duplication Identification and Recovery Team

Role : Senior Business Process Analyst

Location : Bangalore, India

Tenure : November 2005 to February 2006

Responsibilities:

Analyzing and extracting the reports on duplicate bookings/payments from SAP.

Identifying duplicate bookings/payments and recover the same.

To ensure visibility and control over the duplicate payments made across API and APNI.

Communicate the duplicate payment to the vendor with valid proofs and ensure to get the refund.

Creation of debit notes to set-off the duplicate payments.

Ensuring the recovery of the identified duplicate payments from the vendors within the specified deadlines as per the standard guidelines.

Keeping a close eye on the vendors who are raising duplicate invoices and highlighting the same to the business controllers for the further actions.

Hewlett-Packard Business Process Delivery Organization

Department : Vendor Payables – Purchase Administration Team

Role : Nov 2003 – May 2005: Business Process Analyst; Jun 2005 – Oct 2005: Sr. BPA

Location : Bangalore, India

Tenure : Nov 2003 – Oct 2005

Responsibilities:

To ensure on timely and quality creation and regular maintenance of internal orders, purchase orders and invoices.

To ensure vendor information is promptly and proactively updated in vendor records.

To ensure prompt authorizations on the PO related invoice discrepancies.

Preparation of Dashboard and Extraction of reports for the number of invoices created and follow-ups done by the team members

Handling escalations for the Invoice discrepancy issues which includes excess debit and credit to the requestor’s

Work allocation, Quality check on the Invoices prepared by the team members, Archival of Work copies / records / Confirmation mails.

Contact this candidate