Mangesh Bhawtankar

Contact No.: +1-804-***-**** Email: ac6bct@r.postjobfree.com

Experience Summary

** ***** ** ** ********** as Quality Assurance & Business Analyst in Banking and Finance domain. QA experience both in Management and ‘hands-on’ level, with a proven/track record of delivery, strong strategic vision and ability to inspire/mentor teams.

Good exposure and knowledge in test delivery management, estimation, planning and scheduling tasks and testing methodologies. Experience in setting up and managing offshore teams and establish processes for effective executions.

Domain Expertise in Investment Banking – Clearance settlement, Collateral Management, Triparty Repo, Prime Brokerage business.

Expert in managing and conducting different types of QA testing including Functional & Automation, Integration testing, Regression testing, System Testing, DB & ETL testing, Batch testing, Swift message testing, Accessibility testing and Acceptance testing for Web and Mainframe applications, both manually and through use of automated testing tools.

Experienced in executing project with Agile and Waterfall methodologies.

Strong knowledge of Software Development Life Cycle, Software Test Life Cycle and Defect Life Cycle.

Hands-on experience in test automation using JAVA, Selenium Web driver, QTP for web applications & Reflections for Mainframe application.

Well-versed in creating Test Plan, define Test Strategy and ensure complete test coverage.

Outstanding ability to interact with all levels of management, cross-functional business end-users and peers. Strong ability to forge solid working relationships with developers, project managers, subject matter experts (SME), stakeholders and application end-users.

Hands-on experience with UNIX & SQL.

Strong analytical and planning skills with excellent communication and interpersonal skills.

Experienced in managing Migration/Technology upgrade project including Migrating OS from UNIX to Linux, Upgrade of Oracle DB from 10g to 11g, WebSphere upgrade, Java version upgrade, Aix UNIX version upgrade, Oracle Form & Reports version upgrade.

Proven track record of successful delivery of Quality Assurance Programs by effectively managing critical risks and stringent timelines.

Successfully drove delivery with large teams across the globe with 20+ Associates.

Proven experience as effective liaison between functional/Automation/performance testing teams & business teams for Requirements and Deliverables.

Effective skills of Communication and Coordination with multiple stakeholders to ensure project success.

Ability to analyse and understand requirements and communicate effectively with functional/Automation/performance testing teams.

Comprehensive understanding of SDLC & STLC: Closely involved in the phases of Requirements Analysis, Test Planning, Test Design, Test Execution and Defect Management.

Other Skills:

Functional

TECHNOLOGY

SDLC & STLC methodologies

Requirements, functional specifications, gap analysis and Estimation.

Test Management, Test Strategy and Planning

Risk analysis, Defect Management, Status reporting

Functional, Automated, Regression, DB, Acceptance, ETL, Batch, Accessibility testing

Agile & Waterfall methodologies

Exposure to Performance Testing

Languages – J2EE, SQL

Databases – Oracle, DB2

Test/Defect Management Tools – HP Suite of Test Management Tools(QC,ALM etc.), JIRA, and Bugitt.

Test Automation using Java, Selenium webdriver, QTP for web applications and Reflections for mainframe application.

Web services testing: SOAP UI

Scripting: Shell scripting.

Professional Experience

Cognizant Technology Solutions Dec 2003 – Till Date

Client: J. P. Morgan Chase Location: NY/NJ Jan 2004 – Till Date

Project I: Trade Manager Re-engineering Jun 2016 - Till date

Role: Senior Quality Assurance Lead

Client: J. P. Morgan Chase Location: NJ

Tools/Software: MS Project, MS Visio, MS Excel, ALM, JIRA, SQL, UNIX, Linux, Reflections, Win SCP, Putty, Macro, Java, Selenium.

Description: Trade Manager is a Prime Brokerage application in Corporate IB (CIB) Line of Business. Trade Manager allows users to create trades and allocations for downstream processing. Users have the ability to report trades manually via online Trade Entry screen, or systematically via file upload. The Trade Status sections are used to provide the user processing and settlement statuses of the reported trades and allow for user interaction in the form of online cancels and corrections. The Settlement Exceptions within Trade Manager streamlines the process of exception resolution by highlighting those trades that are in need of attention. Information is updated intra-day and the steps required to resolve an exception have been simplified. Using the Settlement Exceptions application can eliminate common errors inherent in manual and verbal communications such as faxes and phone calls.

Roles/Responsibilities:

Manage Quality Assurance activities for the Trade Manager Re-engineering project.

Perform Requirement and Gap analysis.

Active Participation in Scrum meetings and provide inputs/status from QA stand point.

Execute Functional, Regression, Accessibility testing, DB testing in Test environments using HP ALM & JIRA.

Interact with the key stakeholders to understand impact of the change and ensure testing activities progress as per defined plans.

Create Estimation, test plan, test strategy documents.

Test cases design, Test case automation, defect tracking using JIRA.

Developed Test automation using Java & Selenium webdriver.

Identifying and reporting project risks with plan to mitigate the identified risks.

Drive defect triage with AD/Business teams and ensure defects are being prioritized for resolution based on defect severity/priority and track them to closure.

Project II: BDAS QA Sep 2012 – May 2016

Role: Senior Quality Assurance Lead

Client: J. P. Morgan Chase Location: NY

Tools/Software: MS Project, MS Visio, MS Excel, ALM, SQL, UNIX, Linux, Reflections, Win SCP, Putty, Macro, Reflections, VAX/VMS, QTP.

Description: BDAS QA is a project in US Broker Dealer Business of Treasury & Security Services (CIB) Line of Business (LOB). This project objective is validation of all projects/applications in BDAS(Vax/VMS) and GCH areas.

Roles/Responsibilities:

Managed Test Delivery for Global Collateral Finance (GCF) Phase 1, Phase 2 and Phase 3 changes, Rolling Settlement for Tri-Party, FATCA, and Risk Based Margin projects in Broker Dealer services area.

Preparing regression packs for all BDAS/GCH projects using HP ALM & JIRA.

Communication & Risk Management: Scheduled meetings with the Program Managers and other stakeholders on a regular basis to disseminate the status of the projects and ensure that any risks currently in place or forecasted are discussed and mitigation plans agreed upon.

Design & Execute Functional, Regression, ETL, Database, Batch, Swift Message Testing, Automation, Performance, Volume testing for Mainframe and Web application in test environments.

Test automation using QTP for web application and & Reflections for Mainframe application.

Ensuring the delivery of the testing artifacts like Estimations, Test Strategy, Test Plans, Test Scenarios, Test Cases, Test Logs, and Defect Logs etc. to the relevant level within client team structure and ensuring timely review / sign-off of the deliverables.

Ensure prompt tracking and reporting of project and testing activities including daily status reports, weekly status reports, monthly dashboards, testing results, test case coverage, defects discovered and their status.

Project III: GCH Tech Upgrade Sep 2011 – Aug 2012

Role: Senior Quality Assurance Lead

Client: J. P. Morgan Chase Location: NY

Tools/Software: MS Project, MS Visio, MS Excel, ALM, SQL, UNIX, Linux, Win SCP, Putty, Macro.

Description: GCH (Global Collateral Hub) technology upgrade. Technology upgrade include OS migration from AIX Unix to Linux, Oracle DB upgrade from 10g to 11g, Java version upgrade.

Roles/Responsibilities:

Manage QA activities for the GCH Tech upgrade project using HP ALM & JIRA.

Perform Requirement and Gap analysis.

Interact with the client to understand impact of the change and ensure testing activities progress as per agreed plans. Also developed resolutions to risks proactively.

Create Estimation, test plan, test strategy documents.

Identifying project risks and plan to mitigate the identified risks.

Prepare environment readiness check list. Follow up for environment (SIT/QA/UAT/PROD) readiness.

Ensure delivery of test scenarios, test cases, test data, test execution logs and defects logs.

Functional, Regression, ETL, Database, Data load, Automation, Performance, Volume testing in Test AND PROD environments.

Schedule daily/weekly status meeting with Client PM and all stake holders to update the current status of project and ensure that all risks are highlighted.

Schedule defect meeting with PM and AD team and ensure defects are being prioritized for resolution based on defect severity/priority.

UAT/Prod testing: Track UAT/Prod issues and follow up for issue resolution.

Project IV - JPMC WSS USBD FNR MIGRATION Mar 2011 till Sep 2011

Role: QA Manager

Client: J. P. Morgan Chase Location: NY

Tools/Software: MS Project, MS Visio, MS Excel, SQL, Toad, UNIX, Reflections, Putty, QC

Description: Migration of J. P. Morgan’s Broker Dealer Services transactional applications in GCH (Global Collateral Hub) platform from an Oracle Forms and Reports platform to a J2EE platform.

Roles/Responsibilities:

Managed QA for JPMC WSS USBD FNR MIGRATION project.

Understand project requirements by reviewing of BRD and FSD documents for the project.

Requirement and Gap analysis.

Create test plan, test strategy describing the methods, techniques and tools used for testing and ensuring that plan meets business requirements, goals and addresses all the risks.

Prepare Project schedule & effort estimation.

Determine test data requirements and prepare test data set up for all environments.

Build and review test cases according to established Test Case Development Standards in Quality Center (QC) tool.

Verify the build deployed in the required test environment and perform sanity test.

Perform Functional/Regression testing for all applications/modules.

Verify Batch jobs functionality- evaluating batch job status, verify logs and querying database to validate the data loaded in database.

Defect triage call with project teams/stake holders/customers.

Organize the status meetings and send the Status Report (Daily, Weekly etc.) to all project stake holders.

Coordinate with offshore team members for all testing activities. Review all deliverables to ensure the quality of deliverables.

Create QA metrics like Effort Variance, schedule variance, productivity, defect density etc. to measure efficiency & effectiveness of testing.

Report task progress - daily status, weekly and monthly status reporting.

Support UAT testing: Track UAT defects, data load in UA environment for testing, track UA test progress.

Project V: Private Client Workstation QA Testing Jan 2010 – Feb 2011

Role: QA Lead

Client: J. P. Morgan Chase Location: NY

Tools: MS Excel, QC, TOAD, Putty, QC

Description: J. P. Morgan’s web-based workstation, MORCOM, utilizes the latest technology to provide access to a powerful set of integrated tools. Leas QA for Trade Manager, Customer Reports and Fee Billing.

Roles/Responsibilities:

Requirement analysis for all change requests.

Create Test plan and estimation.

Identifying testing risk areas and devising mitigation plans

Identify test scenarios, Create requirement traceability matrix, test case design, reviewing test cases and test data creation.

Test case execution (Functional testing, Regression testing, Smoke testing, Acceptance testing).

Test Status Reporting, Defect Reporting, Defect Tracking.

Create test data.

Project VI: GCH FNR Migration Requirement Oct 2009 till Jan 2010

Role: Business Analyst

Client: J. P. Morgan Chase Location: NY

Tools: MS Project, MS Visio, MS Excel, QC, TOAD, Putty, Oracle Forms & Oracle Reports

Description: Gathering requirements for Migration of J.P. Morgan - Broker Dealer Services applications in GCH (Global Collateral Hub) platform from an Oracle Forms and Reports platform to a J2EE platform with minimal changes to the functionality.

Roles/Responsibilities:

Discuss with Business the changes required in functionality for each application in GCH platform.

Prepare the Scope document and detailed business requirement for each application in scope for migration.

Review the Scope and Business requirement with all stake holders (Business, AD, PS and QA).

Follow up and get the sign off on scope and business requirements

Project VII: Data Centre Migration Jul 2008 to Sep 2009

Role: QA Lead

Client: J. P. Morgan Chase Location: NY

Tools: MS Project, MS Visio, MS Excel, QC, QTP, TOAD, Putty, Oracle Forms & Oracle Reports, Autosys, Macro.

Description: GCH Data Centre Migration projects objective was to migrate the GCH servers to new data centre, AIX Unix version upgrade, Java version upgrade, Oracle DB upgrade (9i to 10g), WebSphere upgrade, Oracle Forms & Report version upgrade.

Roles/Responsibilities:

Manage all QA activities for the Data Centre Migration project.

Requirement and Gap analysis.

Identify the impact of the change/upgrade and finalize the testing approach for the project.

Prepare environment readiness check list. Follow up for environment (SIT/QA/UAT/PROD) readiness.

Create test plan, test strategy documents, test estimation and identify project risks.

Create/Identify scenarios, test cases and test data, also review the test cases.

Functional, Regression, Database, Data load, Automation, Performance, Volume testing and sanity testing in QA/UAT AND PROD environments.

Prepare daily/weekly status reports for all stake holders.

Defect Management and Tracking

Drive status and defect calls with all project stake holders.

Support UAT/Prod testing: Track UAT/Prod issues and follow up for issue resolution.

Project VIII: GCH (Global Collateral Hub) Jan 2004 to Jun 2008

Role: QA Lead Analyst

Client: J. P. Morgan Chase Location: NY

Tools: MS Excel, QC, TOAD, Putty, Oracle Forms & Oracle Reports

Description: J. P. Morgan BDAS group planned to migrate some of the legacy applications to state of art technology, applications to migrated to GCH (Global Collateral Hub) platform. Applications migrated to GCH: FIERCE, PNI, INA, DOD, UEA, CAG, Bookkeeping; develop a new application for customers: Profile Seeker.

Roles/Responsibilities:

Requirement analysis, Create Test Plan, Test Strategy, Test scenarios, Test cases and RTM

Test execution - Functional testing, Regression testing, Sanity, DB and Acceptance testing

Test case walkthrough to SME’s.

Application walkthrough to SME’s and UAT team.

Create and load test data in test environment.

Defect Tracking and Reporting to all stake holders.

Reporting to top Management on the Progress, Publish Management reports on daily/weekly/monthly basis.

QA/UA environment management.

Automation testing using QTP.

CoVisible Solutions, India Pvt Ltd. - QA Analyst Jun 2001 – Dec 2003

Shivam Infotech - Project Trainee Jan 2001 – May 2001

Education

Bachelor of Engineering – Instrumentation.

Diploma in Engineering – Instrumentation.

Contact this candidate