Test Cases Microsoft Office

Chirag Shelat

Email- ************.**@*****.*** US Citizen 614-***-****

Professional Summary

* ***** ** ********** ** Automation and Manual Testing in the Web applications in Agile/Waterfall Methodology.

Good knowledge in various phases of SDLC, STLC and QA methodologies

Strong understanding of the Waterfall, Agile, Lean methodologies

Conducted several types of testing – System, End-To-End, Functional, Security, and Usability Testing

Worked closely with Architects Developers, BA, QA, users to ensure developed functionality meets requirements

Performed all levels of testing including Integration, Smoke, System, Regression, User Acceptance Testing

Knowledge of SQL queries, PL/SQL to validate the data for Oracle, SQL Server and MySQL databases

Experience to analyze Business Requirement Documents, Functional and Technical Specifications

Strong understanding in Microsoft Office Suite with Advanced Formulas, Tables & Formatting, Conditional Formatting, Advanced Charting, Pivot Tables, Pivot Reporting, VBA & Macros

Excellent understanding of testing approaches/methodologies, Black Box Testing with in-depth knowledge and experience in using Black Box Testing Techniques – Functional Analysis, Boundary Values Analysis, Use Case Analysis, and Equivalence Class Partitioning

Experience in Design Test Cases, Traceability Matrices, write manual scripts in Excel templates, Test Plan Module of HP Quality Center, ALM

Thorough knowledge of Defect Life Cycle and hands on experience in tracking defects with Defect Management using Quality Center, ALM

Experience in Rational Requirements Composer (RRC) and Rational Team Concert (RTC)

Experience in eliciting, grooming Requirements, Requirements Analysis, developing a Story Card in Gherkin

Mentored Junior Testers

Experience in testing complex Java, .Net applications., excellent knowledge in Ruby, VBA programming

Technical Skills

Testing Tools : Ruby, Cucumber

Defect Tracking Tools : Quality Center, ALM, SharePoint, JIRA

Scripting : VBScript, XML, VBA Scripting/Macro

Operating System : Windows, UNIX

Languages : PL/SQL

Databases : MY SQL, SQL Server, Oracle, Teradata, MS Access

Applications : Microsoft Office Suite, Visio, RRC, RTC

Communication and Personal Skills

Excellent written, oral and interpersonal communication skills.

Excellent documentation and presentation skills.

Ability to communicate effectively with both technical and non-technical people.

A very good team player but can also work independently with minimum or no supervision.

Ability to meet deadlines and have flexibility in a fast-paced environment.

Professional Experience

Nationwide Insurance Dublin OH Sept 2016 - Present

Test Analyst Project: Prefix Life Insurance System

Read and comprehend technical documentation and glean requirements from it

Prepare detailed specifications, requirements, scope documents and get approval from business

Groom defect or enhancement requirements, create user story for team

Creates Test Cases and Scripts in ALM Test Plan Module and linked them with requirements, executed Scripts from Test Lab Module, Logged and Managed defects in Defects Module of ALM

Planning and conducting a wide range of Quality Control tests including End-To-End Testing and analysis to ensure that all application products and services meet organizational standards and end-user requirements

Help drive skill uplift through coaching team members

Participates in Test Planning, Test Design, Story Card writing, JAD and Executes Test script

Works with Prefix, ServiceNow, Life Support, Switchboard applications

Follows Agile/Scrum practices - Leads Story Card Review meeting, Iteration Planning-Estimation Session for sizing cards, Participate in Daily Standup, Parking Lot, Retro, 3 Amigos, Show & Tell

Environment: Ruby, Cucumber, ALM, Agile/Scrum, RRC, RTC, SOAP UI, SQL, SQL Server, .Net

Discover Financial Columbus OH Mar 2016 - Sept 2016

Sr. UAT Analyst Project: Referral Management System

Participated in updating requirements, Developed Requirement Traceability Matrices, Managed all facets of UAT

Defined all system level requirements and support documentation resulting from new development including Technical documents, System Manuals, and Mockup screens.

Ensure all changes are communicated and agreed upon internally with Business and Client facing teams

JAD, Developed Test Case, linked them with requirements, executed Scripts manual, Logged, Managed defects in ALM

Worked closely with Developers, BAs/functional analysts in resolution of the bugs

Environment: Manual Testing, UAT, ALM, IBM BPM, Oracle 12 C, Teradata, Microsoft Excel, SQL, Tableau, Agile

J P Morgan Chase Columbus OH Oct 2015 - Mar-2016

UAT Tester Project: Wealth Management System

Participated to test if Pre-Trade Checks are generating appropriate messages as per requirements

Created mandate to set certain types of restrictions on account and test the application in restricted environment

Developed and Maintained Test Cases in ALM

Worked with off shore team and participated in meeting over the conference call

Environment: Manual Testing, ALM, Agile Methodology

AmTrust Financial Services Cleveland OH Aug 2014 - Oct 2015

Testing Analyst Project: Commercial Package Policy (CPP)

Executed test cases in an automation tool, Performed System, Regression, Integration Testing and reviewed results, logged defect

Participated in production implementation, verification and accountable for validating enhancements

Plan, Document, Evaluate and Tracked testing results, Rated the policy to determine if generated correct premium.

Developed and Debugged complex SQL scripts/queries for data verification

Environment: Agile, SharePoint, JIRA, Microsoft Excel, SQL Server Management Studio, Java, C#

QA Analyst at Express Scripts from May 2013 to Aug 2014

QA Analyst at Humana from April 2012 to April 2013

Education/Training

MBA, American InterContinental University, USA

Post Graduate Diploma in Computer Science, Sardar Patel University, India

Contact this candidate