Mayuri Shewatkar

Automation QA Analyst/Certified Scrum Master

acxtcb@r.postjobfree.com

201-***-****

Summary Over 5 years of experience as a QA and Scrum

Master in Web/ Windows, Salesforce and mobile

applications developed in .Net and Java technology

Organized test suites for both Automation and

integration testing using Selenium RC, Web driver,

IDE, TestComplete and CUIT automation tools.

Assist with execution & tracking of program Agile

deliverables for Technology across Lines of

Business, Functional Areas and crossfunctional

teams

Prepare & review program dashboard, performance

metrics, scorecards including weekly & monthly

program status updates, Executive Sponsor

Updates, key business metrics, Issues & Risks and

periodic program updates & communication decks

Assist, participate and monitor, backlog analysis

and management, work stream planning and to

help mechanize project plans & endtoend

timelines

Interact with business product owners in

understanding and helping to groom requirements

backlog

Extensive experience in developing SQL scripts to

validate the databases tables and reports data for

backend database testing.

Performed the Backend Database testing along

with the ETL Validation.(for database MS SQL,

Presto, HIVE, PostgreSQL, Oracle,)

Proficient in troubleshooting database issues and

experienced in using performance monitor/profiler

to solve dead locks/ long running queries.

Responsible for regression (using Selenium and

CUIT tools), System Integration Testing (SIT) and

Endtoend testing of newly developed and existing

applications.

Coordinate multiple projects and guides project

team member including developing estimates.

Responsible for ontime delivery of work including

monitoring of external and internal dependencies,

tracking and monitoring of project milestone

accomplishments.

Extensive experience and knowledge on Amazon

web services, ETL Validation, validating APIs and

APIdriven applications and database testing.

Experience of creating test plans, scenarios,

scripts, test cases, procedures, monitoring defects

in various defect tracking tools.

Extensive experience and knowledge on various

steps involved in SDLC, STLC and defect life cycle

and release management

Responsible for quality and timeliness of work by

other team members.

Well versed with manual, Salesforce, mobile,

database, automation, Agile, regression, functional,

system integration, regression, black box, system,

exhaustive, stress, compatibility, performance and

usability testing.

Excellent verbal and written communication

skills to coordinate with team to get efficient

results and also capable to learn new tools,

techniques and approaches

Knowledge and Skills Tools &Technologies: Microsoft Test Manage

C#, VB Scripting, ALM

Amazon web services

Scripting, TDD, Hive, P

VB Scripting, Java Scr

Oracle, Aqua data stu

Putti, Unix, ALM, WC

Developer data Model

Professional, Selenium

VISIO.HP/Mercury Inte

VSTS 2010, Confluenc

REST APIs, Team Fo

Agile(Scrum),Test Man

Word, MS Excel, MS P

Outlook

FrontEnd GUI: Visual Basic 5.0/6.0, Developer

FrontPage, Power Builder

Page 2

Mayuri Shewatkar

Dbase, MS Access, Hive, Presto

Databases:

MS SQL, Oracle 7.x/8.x/9.x/10g

6.5/7.0

Unix, Linux, Windows XP/NT/20

Operating Systems:

Internet Explorer, Safari, AOL, F

Browsers:

Chrome

Certifications Brain Bench Certified in Quality Assurance

Certified Scrum Master

IBM Intelligent Operations Center Technical

Professional v1

IBM Rational Collaborative Lifecycle Management for

IT Technical Professional v1

AWS Technical Professional (Released September

2015)

AWS Business Professional (Released September

2014)

Selected Project Experience Essex Technology Group

Client FINRA, New York, NY

10/2015 Present

Worked with project managers and business

users to formalize a business idea and define

requirements

As a Scrum master, responsible for overall

management of assigned projects, including

coordination across departments/divisions, status

monitoring and reporting, and stability of projects.

Establishes and implements project

management/agile processes and methodologies.

Ensures projects are delivered on time, within

budget, adhere to quality standards and meet

customer expectations.

Determines IT personnel needs for projects,

assigns and monitors project work and provides

input into performance appraisals for all staff on

assigned projects.

Tracks key project milestones and adjusts project

Page 3

Mayuri Shewatkar

plans and/or resources to meet the needs of

customers

Coordinates communication with all areas of the

organization that impact project scope, budget, risk

and resources of work effort being managed.

Assists other members of management to identify

and prioritize opportunities.

Manages one of more cross functional projects of

medium to high complexity.

Oversees the work of project management staff;

schedules and monitors work; authority to approve

or deny time off for assigned staff based on project

schedules and demands.

Performed the ETL, functional, system integration,

validating APIs, APIdriven applications( REST

APIs) and regression testing for MRWS and EXV

applications

Prepared the Test Plan and Testing Strategies

document.

Developed ETL test scripts based on technical

specifications/Data design documents and Source

to Target mappings.

Coordinate multiple projects and guides project

team member including developing estimates to

support existing and new projects.

Recording work status information and generating

reports by ensuring all activities are recorded

accurately.

Participated in review of functional specification,

technical analysis, gap analysis and test planning

activities.

Responsible for ontime delivery of work including

monitoring of external and internal dependencies,

tracking and monitoring of project milestone

accomplishments.

Organized Automation test suites for both unit

testing and integration testing

Maintain the old Automation scripts built in Beta (in

house automation tool and Junit framework) over

PowerBuilder application.

Assists QA Manager in reviewing Resource

Management forecast reports, to optimize teams

supply/demand planning, maximizing resource

utilization.

Page 4

Mayuri Shewatkar

Created new User stories and Change Requests

based on Gap Analysis.

Performed the TDD, ETL validation along with the

CSR (Consolidated Surveillance Repository)

registration for all patterns.

Performed the Backend Database testing along

with the ETL Validation.(Database SQL, Presto,

HIVE, PostgreSQL, Oracle)

Tracking and reporting the issues to project team

and management during test cycles.

Updating and maintaining existing test Matrix and

test cases based on code changes and

enhancements to assigned applications.

Documented use cases, user stories, test plans

and test cases which ensure that the software

solutions developed and tested are fit for purpose,

meet business needs and are operationally

sustainable

Environment: AWS Services, Aqua data studio, Amazon

web services, Agile (Scrum),Putty, Linux, SQL, JUnit,

Quality Center, Oracle 9i, DB2, SQL Server, Business

Objects JSON, HTTP, REST, APIs,Java, XML, MSOffice,

Windows, HIVE, Scrum, Agile, ALM, MS Visio, Python,

Shell scripting, Jira, Presto, PostgreSQL, Excel.

Essex Technology Group

Client Prudential Financial Inc., New York, NY

01/2014 09/2015

Raise issues, identify obstacles, and recommend

options, right from inception till maintenance to

ensure successful system implementation

Participated in Design reviews, ensure design

meets Functional and Operational needs

Organize and conduct daily Stand Up meetings

Partner with Product Management to achieve

maximum project return on investment and meet

project objectives

Manage sprint planning and execution which

includes the management of project progress and

provide status & visibility

Participate in release planning and scheduling by

providing empirical Scrum team statistics,

Page 5

Mayuri Shewatkar

identifying project dependencies, and creating

velocity forecasts

Identify and manage crossteam dependencies

Ensure high throughput of development teams by

identifying potential issues and roadblocks and

working on preventing or eliminating them

Converted manual, functional and regression

scripts to keyword datadriven automated scripts

using Selenium webdriver.

Design and Execute automated tests on multiple

environments using Junit framework. (i.e. different

browsers & mobile devices).

Implement Automated Tests for new features as

well as basing them off existing Manual Regression

Tests.

Experience building and maintaining an Automated

Testing Framework.

Developed SQL scripts to validate relational

database tables.

Provided automation training to manual testers and

offshore resources.

Created Test Plans, Cases and Scripts for UAT,

functional and regression testing.

Produced Quality Center and Excel metrics/reports

from scheduled execution test runs.

Studied, analyzed and documented asIs business

process and performed the gap analysis

Extracted data from various sources like Oracle, flat

files and DB2 server.

Worked on issues with migration of Data from

development to QATest Environment

Created new User stories and Change Requests.

Performed configuration /Edit Shared Settings

changes in WCM (Web Content Management

System).

Facilitated training for Content and Site Authors.

Worked on Architecture Document and

Configuration/Edit Shared settings Instructions

document.

Documented use cases, user stories, test plans

and test cases which ensure that the software

solutions developed and tested are fit for purpose,

meet business needs and are operationally

sustainable.

Page 6

Mayuri Shewatkar

Environment: WCM, SQLworkflow manager, workflow

monitor), TOAD, HTML, Agile (Scrum),Selenium IDE,

CMM, Quality Center, Oracle, Java, XML, MSOffice,

Windows, Astah Professional tool, MS Visio.

Essex technology Grp/Gemini Systems, LLC., New

York 10/2013 1/2014

Analyze and prioritize customer requirements from

scope definition through detailed system

requirements

Created effective use cases and integrated high

level use case scenarios to create "Use Case

Model/Diagram and identification of

Basic/Alternative flows

Created Data Flow diagrams with "Functional

Primitives"

Responsible to create "EntityRelationship(ER)"

Diagram for Logical Modeling

Responsible for System Integration Testing (SIT)

and EndtoEnd testing of newly developed

applications.

Design and Execute automated tests on multiple

environments.

Created test frameworks from scratch using Java.

Identify and troubleshoot issues with Test stability

Implement Automated Tests for new features and

Manual Regression Tests.

Verifying the data in target database by ETL

process along with column mapping between

source and target

Environment: Use Cases, SQL, Agile (Scrum), UML,

JIRA,HTML, Quality Center, Oracle, XML, MSOffice,

Windows, ER studio, Selenium Webdriver/RC, Junit, Astah

Professional tool, MS Visio

CMS Global Services

Page 7

Mayuri Shewatkar

Client Teach For America, New York

01/2013 10/2013

Created requirements document, test plan and test

strategies

Analyzed and evaluated system requirements to

design test plan and test procedures

Design and Execute automated tests on multiple

environments.

Implement Automated Tests for new features as

well as basing them off existing Manual Regression

Tests.

Experience building and maintaining an Automated

Testing Framework TestNG.

Designed, developed and executed test scripts

Tracked, identified and logged bugs using JIRA,

and worked with developers to ensure bugs are

fixed, as well as being responsible for automation

of features.

Worked closely with application

designers/developers to resolve documentation,

design & functional issues with various

applications.

Executed test cases in QC and logged defects

Prepared testing progress and test coverage

documentations and provided status to Project

Manager

Involved in retest and regression, Automation, UI,

and functionality testing

Helped the business team in carrying out the user

acceptance testing

Environment: Quality Center 11.0, JIRA, Cloud, Selenium

Web driver, TestNG, HTTP, HTML, and XML, SQL Server.

Cavalier IT

Client Corcoran Real Estate Group, New York, NY

12/2011 11/2012

Analyzing the requirement specifications and

development, peer review and execution of test

cases

Defect reporting and tracking by using Test

Manager

Performed backend testing by creating and

executing SQL queries

Page 8

Mayuri Shewatkar

Performed positive and negative testing on the

application

Understanding of creation and execution of manual

and automated test cases

Performed automation regression testing using

Visual studio tool on webapplication with C# and

VB Scripting.

Automated all functional test cases using Coded

User Interface Testing (CUIT)

Analyzed user requirements, attended change

request meetings to document changes and

implemented procedures to test changes

Interacting with analysts and developers for the bug

fixes and problem resolution

Provides leadership to projects during early stages

to establish plans, standards, and procedures that

will add value to the development effort and satisfy

the constraints of the project.

Supports and coordinates endtoend testing efforts

to ensure adherence to software quality standards.

Performed mobile testing on Blackberry and

Android simulator

Performed manual, mobile, regression, integration,

system, database, exhaustive, compatibility and

user acceptance testing

Environment: Microsoft Test Manager 2010, Visual Studio

2010, SQL Server Management Studio, TFS (Team

Foundation Server), CUIT.

Education Bachelor of Technology

Amravati University, Pusad, India.

Page 9

Mayuri Shewatkar

Contact this candidate