Test Cases Project

SATHISH KUMAR MOHAN

Professional Snapshot

A dynamic ISTQB (International Software Testing Qualifications Board) certified engineer with over 11 years of Software testing experience working on Web based, ETL, Data warehouse and GUI applications.

Extensive experience in performing Black box, Functional Testing, Regression Testing, Negative Testing, Usability testing, UI Testing on Web based applications.

Strong experience in creation of Test Plans, Test Conditions Matrix, Test Scripts, Test execution and defect management.

Involvement in various stages of Software Development Life Cycle (SDLC), STLC and defect lifecycle.

Experience with SQL to query the oracle database.

Proficient in Mercury’s Test Director and Quality Center, ALM for Test Designing, requirement mapping, Reports, Test Execution and Defect Tracking

Expert in creating requirements trace ability matrix as well as mapping requirements in HP Quality Center

Experience in automation testing using Selenium and Jenkins to schedule jobs.

Experience working in Agile and/or Scrum environments

Experience in Web services testing using SOAP

Experience in testing ERP- CRM applications

Experience in designing and executing exceptional modularized re-usable automated scripts using - Quick Test Professional (QTP)

Experience in XML, XSD, XPath, HTTP, HTTPS, JSON

Experience in ETL testing, Data Migration Testing, Database Testing, Data Validation & Data Comparison Testing with Hand on experience in IBM Datastage tool (v8.5)

Experience in visualization tools like Tableau, Cognos reports

HP certified accredited integration specialist in HP Quality center

Experience in Globalization testing & Localization Testing

Technical Profile

Operating Systems: Windows 7, Windows XP

Database: Oracle 11g, MySQL

Defect Tracking: JIRA, Bugzilla, Clear Quest

Test Management tools : Quality Centre, Test Link, and Team Foundation Server, HP ALM

ETL Tools: IBM Datastage

Other tools: Soap UI

Tracking Tools: Bugzilla, JIRA, Team Foundation Server (TFS)

Automation: Selenium, Winrunner

Project Experience

Client: Tesla Motors, CA Feb 2014 – Till date

Project: Tesla Warp Service

Technology: Microsoft VSTS, JIRA, TestLink, SQL

Role: Test Lead

Project Description:

Tesla Motors is an electric car company that designs, manufactures and sells electric cars and electric vehicle powertrain components. Its product portfolio includes Roadster, Model S, and Model X.

Warp Service is our business management system and resource planning tool for the 2500 Tesla Service department users

• It is the single system of entry for capturing a large number of needs, including customer interactions and concerns, recording vehicle issues and repair documentation, invoicing and tracking payment, inventory management, executive reporting and resource planning, etc.

• Warp Service is fully built in-house and growing rapidly regarding features, users, data volume captured, and ultimately, in strategic importance to the company and mission of Tesla

• Warp is a strategically vital business strategy tool to align Service and Tesla in general globally, and to gather data from all owners, and entities within Tesla

Responsibilities:

Responsible for offshore Coordination including the efforts, billing and resource utilization.

Gather and interpret the functional requirements of the work items

Prepare test estimates and revise if applicable, Escalate issues/risks to Test manager / Project Manager, ensure quality of deliverables meet expectations.

Handled the team of 8 members in the project including the offshore lead. Track and monitor their work items and the progress till the end of the release.

Preparing Test Approach document, Test conditions and detailed Test Script Development based on the design documentation.

Build Validation, End of Day Validation, Smoke Testing and Functional testing of the Next Gen application.

Performed Test Script Peer Review and Knowledge sharing to the team.

Running the Automation scripts on demand

Performing End 2 End testing

Defect Reporting and follow up in JIRA and conduct Defect Triage meeting

Developed training manuals and conducted cross training session for the team

Maintaining the test deliverables of each phase in Windows SharePoint.

Involved in preparation of RCA. DSR, risk assessment of the work items and report the same to client.

Interaction with the Business Partner’s, External Vendors, BA’s and the customer

Client: Biogen Idec, USA Aug 2013- Jan 2014

Project: FieldLink

Technology: SharePoint, Microsoft Team Foundation Server

Role: Test Lead

Project Description:

The Field Portal is about streamlining communication to the field and improving the feedback loop between the field and headquarters. The business drivers are:

1. Email is overused to communicate between HQ, field managers, and field force (best practices, brand updates, success stories, objection handling, and positive feedback, evolving themes)

2. Too much brand information is in silos. Many in the field want more visibility into other brands.

3. Feedback loop between field and HQ is inefficient and overly cautious (the field holds back their honest opinions and doesn’t always know where to turn)

4. Groups share responsibilities to update certain files; emailing back and forth leads to email “paralysis” and lack of version control

Responsibilities:

Provide Test Manager with the detailed estimates of the work effort required for testing

Involved in understanding business requirements and translating them to software requirements

Involved in preparation of test plan document and delegating testing team tasks

Review and approve the test artifacts(test cases, test results, defect reports etc.,) developed by the test team

Collaborate with the development team and business partners to ensure the scope of tests is comprehensive, and to mitigate defects prior to testing

Performing End 2 End testing

Create a full length Requirements Traceability Matrix (RTM) to test cases and identified gaps

Creation/Execution of test cases to verify software functionality and adherence to business requirements

Tracking, reviewing, analyzing the defects by conducting review and defect meetings

Generate Test Summary Report (Exit Criteria) with following detailed information

oTest Scope and summary

oVariances

oSummary of Results showing all the defects found by functional area with severity, description and resolution

Client: Govt. India, India Feb 2013 – July 2013

Project: Nuclear Fuel complex

Technology: Java, Postgres, Selenium and HP ALM

Role: Test Lead

Project Description:

The purpose of this project is to migrate existing Legacy grown up in house system at NFC towards a comprehensive Material Management & Finance System (MMFS) will cover the following modules:

Organization Setup

User Administration

Employee Management

Leave Management System

Setup Reports

Personnel Reports

Responsibilities:

Responsible for all Core activities around planning and executing System Integration and User Acceptance testing tasks, which includes creating Test Plan, Test case development, defect management and test execution

Attended design reviews, requirements sessions, core team meetings, and technical team meetings to understand business requirements and business operating processes/procedures in order to identify test scenarios

Performing End 2 End testing

Identified the Test requirements based on business requirements

Interacting with Business Analyst, Development team to understand business requirements

Involved in the review & preparation of the Test cases and Test Scenarios

Execution of test cases on development & production server

Identifying defects and tracking to closure using Bugzilla defect tracking tool

Client: AIG. USA Apr 2012 – Jan 2013

Project: Chartis - Global Exposure Solution (GES)

Role: Test Specialist

Technology: ETL, Datastage, Oracle, Quality Center, Data warehouse

Project Description:

The purpose of this project is to create a centralized global exposure data warehouse software application combined with a data capture and workflow management solution. The solution will include a global data warehouse containing location and exposure information and a data transfer mechanism to facilitate automated catastrophe modelling runs. The streamlined workflow will optionally encapsulate the pre-quote/pre-bind and policy renewal processing, thereby increasing customer’s data management capabilities.

Responsibilities:

Developed Test Cases and Test Scripts for SIT and support for UAT tests

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Datastage

Developed the ETL and BI testing strategy

Performed Sanity, system, Integration, Regression Testing

Supported Performance, Load and UAT testing

Created requirements traceability matrix for the test cases developed

Reviewed Test plan and Test cases with the team

Used Quality center for documenting the test cases

Executed the Test cases in Test lab and Logged the defects and linked the same with the respective Test cases

Effectively communicated the Defect status within the team for clear idea on issues affecting the release timeline

Developed Shell scripts and successfully executed the scripts

Performed Positive and negative Testing for all the data fields

Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database

Worked on SQL scripts to load data in the tables

Extensively worked with DS (Designer, Director and Manager)

Used the DATASTAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions

Tracked the defects using Quality Center and generated defect summary reports

Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality

Client: Travelodge, UK July 2011 – Mar 2012

Project: Travelodge Customer Site

Role: Test Specialist

Technology: Dojo, EJB 3.0, Oracle, RTC, HP ALM, Putty, WinSCP

Project Description:

The purpose of this project is to develop a new web platform and implemented for the Travelodge e-commerce site. The following drivers have been identified:

For stability and to enhance user experience of the web site

To enable changes to the business in a more efficient manner

Cope with predicted business growth

Re-platform on to a more scalable technology

Resilient architecture

Responsibilities:

Preparing effort estimation, planning and delegating tasks to the team, and tracking team activities including test case coverage, defects discovered & their status, test results, etc.

Identified the Test requirements based on business requirements

Interacting with Business Analyst, Development team to understand business requirements

Involved in review, Test Case creation and Test Data from High-level Scenarios

Involved in creating End-to-End flows for User Acceptance Testing

Performed Report testing and Data validation of reports with SQL’s, referencing through database schemas

Involved in the review & preparation of the Test cases & Scenarios

Performing system integrated testing and UAT support

Identifying defects and tracking to closure

Client: eBay, USA July 2009 – June 2011

Project: Dynamic messaging in Seller Limits

Role: Test Specialist

Technology: Java/J2EE, Oracle, Eclips, Clear Quest, CERT, eBART, SOA, eLVIS

Project Description:

eBay is a largest online market place in which people can buy and sell their goods. Now it has more than 100 million users all around the world. It has its global presence in 33 international markets, including the US. eBay features fixed-price items and auction items sold on eBay by experienced sellers. Shoppers on eBay Express can buy from multiple sellers in a single session.

To provide access to eBay, Real Estate DE is now developing a middleware which provides market standard interfaces and bulk uploads listings to eBay via API. By offering this access we aim to offer broker sellers an advertising format that fits their needs and provides eBay buyers with the abundant offer they are looking for. By moving into this market as quickly as possible we can take advantage of the still remaining competitive window of opportunity in a strong and consolidating market

Responsibilities:

Coordinate with onsite and Client team on clarifications on the PRD

Assess the critically of the feature and its dependency to provide estimation of train seat if it seems to exceed

Preparing Test Plan and Test case document based on the PRD

Responsible for Cord Hardening completion, DEV to QA hand off, Merge Approval and Automation

Preparing Effort estimation and providing Inputs to Domain Manager on the Resource and effort allocation

Review the Test cases internally and organizing External review meeting with client

Execute testing in the most efficient manner since deadlines in eBay is very stringent

Prepare for the risks in the execution and escalate timely

Coordinate with various teams for the environmental issues

Prepare for regression and International testing subsequently

Identifying the Test cases to be automated and getting functional Approvals from EDLs

Automate the scripts using Selenium for the feature, get it approved

Automate the Service Test cases using LISA tool

Prepare RCA for the production bugs

Identifying Risk and its mitigation

Performing Production Smoke Test for feature roll out

Used SOAP UI, Web Logic ANT task to test Web Services running on Web Logic Server

Client: Road transport Authority of Dubai

Project: Road and Transport Authority

Role: Test Specialist

Technology: Java/J2EE, Bugzilla

Project Description:

Road transport Authority of Dubai implemented some eServices in the RTA Website for its customers. The main objective and focus of the project is to test all the eServices implemented by RTA for checking the correctness of the functionality and user interface of the website

Responsibilities:

Raising the bugs and assigning the same to the respective developer

Generating the test results and publishing the same to stake holders

Capture and maintain the review comments from the service delivery team/business people in review report document and follow up till closure, also used the same to generate metrics

Client: NFUM, UK Feb 2009 – April 2009

Project: STEP – System Transformation to Enable People

Technology: Java/J2EE, Oracle, Quality center

Role: Test Specialist

Project Description:

NFUM - A “Mutual” Insurance Company catering to Life and General Insurance needs. STEP program is a project aimed at launching new applications for NFU Mutual General Insurance needs. NFU Mutual General Insurance is migrating to a new Insurance package called “Harlosh” - a worldwide leader in insurance packages. Harlosh provides NFU Mutual with its Insurance Faces (I Faces) solution, a technology platform which consolidates NFU Mutual’ s existing legacy systems into a Single, Flexible application across the whole of the general insurance business process. The I Faces solution supports end-to-end business processing throughout the lifecycle of a General Insurance policy - from issuance to claim.

Responsibilities:

Identified the Test requirements based on business requirements

Involved in the review & preparation of the Test cases and Test Scenarios

Performed system integrated testing

Used VSS (Visual Source Safe) to manage files and directories and their versions

Identifying defects and tracking to closure

Client: Travel Click, USA April 2008 – Jan 2009

Project: HTK 3.0 Project

Technology: Java/J2EE, Oracle, Quality center, Jira

Role: Test Specialist

Project Description:

Hospitality Toolkit is a revolutionary hotel Internet marketing solution, including next generation content management, website design and search engine optimization. This project aims at rewriting the Hospitality Toolkit application in an even stronger technical platform which will enhance scalability and maintainability for the application and will align it for better integration with Travel Click’s other products

Responsibilities:

Analysed and updated business requirements, wrote and implemented the Test Plan, various Test cases and Test Scripts in VBScript to test various functionalities using the automated tool QTP and also wrote manual Test Cases using Quality centre according to functional documents and requirements

Analyse the requirement documents and get it clarified in requirement analysis meeting with BA/Business head

Perform Peer Reviews Business Scenarios/Test Case

Execution of Manual Test Cases

Raise the bugs in Quality Center and assigning the same to the respective developer.

Generate the test results and publishing the same to stake holders.

Review the Mapping of all the requirements to the functional documents in the requirement

Traceability Matrix.

Involve in defining various templates such as test case, etc.

Conduct weekly meeting within the team and publish the MOM document

Client: HSL July 2007 – Feb 2008

Project: Mobile Banking System

Technology: Java/J2EE, Oracle, Bugzilla

Role: Test Engineer

Project Description:

The project was developed to provide a felicitation for the user to access his bank account through his Mobile. The system also enables the user to pay his EB bill, Telephone Bill through the Mobile as well as pay for some other services, which he has availed. The Mobile banking system is not just for payment but a user of the system can also transfer money through the system. He can receive from his bank or from his business associates or friend or other person who is also connected to the system.

Responsibilities:

Analyzed Business requirements and interacted with software developers to understand applications functionality and navigational flow

Performed Regression, System, and Integration testing

Maintained the Traceability Matrix to track all the requirements

Client: Sun life, USA Feb 2006 – June 2007

Project: Health care & Coverage’s in Insurance

Technology: Java/J2EE, Oracle, Bugzilla

Role: Test Engineer

Project Description:

This project mainly involves in entering claim data for the client M/S Sun life Health Insurance of U.S.A. This project was developed to verify the claims and generate reports. It contains different modules such as Providers, Procedures, Diagnosis, Patient details, Verifications and Report generation. These claims mainly used for further claim processing to the insurance company. In this project we have followed regression-testing process.

Responsibilities:

Developing Functional Test Cases for the modules

Executing Test and sending Issue Logs to Bug Tracker

Review of change control Test Cases.

Client: Alcon, USA June 2005 – Dec 2005

Project: Alcon Case Management

Technology: Java/J2EE, Oracle, Bugzilla, Winrunner

Role: Test Engineer

Project Description:

The project involves the design and development of a web application that will help the client organize their case studies which are ultimately assigned to doctors. Doctors will be authorized to view the case studies and work on them.

Responsibilities:

Creation of detailed test cases by understanding the end user requirements for manual testing Developing Functional Test Cases for the modules

Executing Functional, GUI, Unit and Regression Testing.

Interacting with the developers for fixing of bugs.

Executing Test and sending Issue Logs to Bug Tracker

Client: SRM, Chennai Dec 2004 - May 2005

Project: Corporate Information System:

Technology: Java/J2EE, Oracle, Bugzilla

Role: Test Engineer

Project Description:

The Corporate Information System is developed for automating the complete operation of SRM Systems and Software Private Limited. The project comprises of five major modules namely Training Management, Library Management, Marketing Management, Administration and Financial Management.

Responsibilities:

Developed & executed detailed Test cases for testing the Functionality, GUI application

Extensive use of SQL queries to perform Back End testing

Involved in User Acceptance Testing (UAT) to test whether it meets the User Requirement Specifications.

Training / Continuing Education Summary

Program or Course

Coverage

Certification

ISTQB

Certification

HP Quality Centre

Education Summary

Degree and Date

Institute and University

Percentage Obtained

BE.MECH (1999 – 2003)

Madras University

69%

Contact this candidate