Praphulla Deshmukh

adu8z3@r.postjobfree.com

+91-855*******

Valid H1B Petition Approved for Seattle (WA)

Profile Summary

Over 15 + Years of IT experience in Software Quality Testing

Over 2 years doing Project Management Activity.

Over 7+ years of experience in leading QA team and Provide estimates for all QA activities, as needed

Testing Experience in mobile application both in android & iOS.

Experience in working under various process models like Agile Methodology (Scrum) & V model.

Testing Experience in ETL Testing, Report testing & Database testing in the field of Data Warehousing and Business Intelligence in Health Care & Life science domains.

Hands on experience in Talend tool in ETL projects.

Performed the data transfers from one database to another database through ETL & Tested sample reports through ETL process.

Expertise in Database Testing & Ability to perform backend data validation/testing

Sound knowledge in Test Scenario preparation, Test Cases Design, Test Case Review, Test Case Execution, Analyze the Result and Defect Management.

Sound knowledge in GUI/Usability Testing, Functionality Testing, UI Validation, Regression Testing, UAT Testing, Soap UI API Testing & Mobile App Testing.

4+ years of experience in Salesforce application testing.

An enthusiastic team oriented and project-oriented Team Lead with excellent technical skills to develop creative for challenging client needs.

Worked as a Testing Lead on Knipper, Cycle30 & First American QA Project.

Expertise domain knowledge on Cloud Computing, Telecom, Title Insurance, ERP System, Knowledge Management

Experience in handling and participated in Status Report meetings and Bug Triage meetings.

Resolving conflicts among team members.

Maintaining cordial relationships between cross functional teams like development, configuration management, program management, product managers etc.

Ensure that Rewards are given for each achievement in the team.

Seeking feedback from management when and wherever necessary.

Roles & Responsibilities

Handling Project Activity like Profile shortlisting for QA Resource onboarding

Creation of Indent for new resources

Coordination with Clients for any requirement clarification

Resource On-boarding for project/Account

Creating indents for project, Discussion with HR and RM, Leadership

Task Estimation, QA project deliverables

Creating monthly billing in MBS & Invoice raising

Walk through the QA Test Results with the QA Team and communicate status to Project leader/State holder

Participate in developing and maintaining good working relationships with peers in product development, project management and client services

Work closely with Business and Application Development stakeholders in a demanding work environment

Prepared Test Cases, Test Strategy and Planning.

Designed, Reviewed & Executed Test cases.

Identified Test cases for Regression testing

Data gathering, cleansing and import/export in different formats.

Verifying the data in target database by ETL process

Verified column mapping between source and target

Prepared test data for functional & Integration testing

Interactions with BA & Dev teams to resolve the issues.

Reporting Daily/Weekly testing status.

Understanding test plan and test data generation.

Writing test script and executing those test scripts.

Inserting, Updating, Editing and deleting the records by using SQL statement.

Defect Analyzing and Reporting in QC

Communication with client for Data management.

Identification and review of test cases and test scenario.

Going through specification, technical documents.

Report testing using Tableau & Power BI Tool.

Work Experience

Project 1 (IDFC Saving and Salary Account Opening Website)

Organization

IDFC Bank

Role

Project Lead

Responsibilities

1) Handling Project Activity like Profile shortlisting

2) Solving Project impediments

3) Coordination with Clients for any requirement clarification

4) Resource On-boarding for project/Account

5) Creating indents for project, Discussion with HR and RM, Leadership

6) Task Estimation, QA project deliverables

7) Creating monthly billing

Team Size

40

Duration

Jan 2021 To till Date

Project Description

IDFB bank needs to create online Salary and Saving account opening where user can open account through website.

Tools Used

ReactJS, Java, Browser Stack, JIRA

Environment

Android and iOS

Project 2 (IDFC Saving Account Opening App)

Organization

IDFC Bank

Role

Team Lead – QA/Testing

Responsibilities

1.Understanding of business and the infrastructure and scenarios.

2.Responsible for determining and managing the work of other QA representatives, plus coaching and mentoring junior members of the team to best practices

3.Provide vision and direction for the client site test team which will include functional and embedded testers working alongside the development team

4.Work closely with Business and Application Development stakeholders in a demanding work environment

5.Creating, Enhancing, Debugging and Running Test Cases.

6.Involved in analysis of Use Cases, written and test scenario, test cases

7.Defect Logging

8.Weekly QA Status to Client

Team Size

23

Duration

Oct 2020 To Jan 2021

Project Description

IDFB bank needs to create Native app for online Salary account opening where user can open account through app and able to open salary account.

Tools Used

react native 0.63, Java

Environment

Android and iOS

Project 3 (First American- Web Scrapping (160)

Organization

First American

Role

Team Lead – QA/Testing

Responsibilities

1) Understanding of business and the infrastructure and scenarios.

2) Validate the response, response time, error code

3) Able to validate the xml and Json body by using Json parsers.

4) Able to derive sizable number of test cases and scenarios based on the API testing.

5) Creating, Enhancing, Debugging and Running Test Cases.

6) Involved in analysis of Use Cases, written and test scenario, test cases

7) Defect Logging

8) Weekly QA Status to Client

9) DTS & Title Chain Integration Testing

Team Size

20

Duration

May 2020 To Sep 2020 Date

Project Description

First American Title helps homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers. Web scrapping was short term project, scrapping government tax sites for respected county and give details to FA customer.

Web Scraping (also termed Screen Scraping, Web Data Extraction, Web Harvesting etc.) is a technique employed to extract large amounts of data from websites, whereby the data is extracted.

Tools Used

Rest API Testing with Postman, Excel

Environment

Windows 10

Project4 (First American- Rainer QA)

Organization

First American

Role

Team Lead – QA/Testing

Responsibilities

1. Involved in analysis of Use Cases, written and test scenario, test cases

2. Defect Logging

3. Weekly QA Status to Client

4. DTS & Title Chain Integration Testing

Team Size

5

Duration

Oct 2019 to April 2020

Project Description

First American Title helps homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers, title agencies and legal professionals’ close transactions. Find out more about our products and services, and how First American can help you streamline your transaction and protect your investment.

Tools Used

SQL Server, TFS, Manual Testing

Environment

Windows 10

Project 5 (Snowflake Connector)

Organization

Snowflake

Role

Team Lead – QA/Testing

Responsibilities

1. Participating in daily scrum meeting.

2. Involved in analysis of Use Cases, written and test scenario, test cases

3. Defect Logging

4. Tableau Report Testing

5. Weekly QA Status to Client

Team Size

8

Duration

Feb 2019 to Apr 2019

Project Description

configuration of the VM based on the tool for which connector is to be tested. (ETL and BI tools have a recommended hardware configuration to run on so the VM configuration will depend on those) VM’s will be created for minimum configuration defined by the tool. However Persistent recommend that size of HDD to be considerable so as to do the bulk testing. Certify the Connector

Tools Used

Tableau Desktop & Server. Informatica, ETL

Environment

Windows Server 2012

Project 6 (MSKCC)

Organization

MSKCC

Role

Team Lead – QA/Testing

Responsibilities

1. Participating in daily scrum meeting.

2. Involved in analysis of Use Cases, written and test scenario, test cases based on requirement documents.

3. Defect Logging & Verification

4. ETL & Salesforce Testing, SQL DB Testing

5. Daily/Weekly QA Status to Client

6. Understanding entire model and its functionalities.

7. Data gathering, cleansing and import/export in different formats.

8. Verifying the data in target database by ETL process

9. Verified column mapping between source and target

10. Prepared test data for functional & Integration testing

11. Interactions with BA & Dev teams to resolve the issues.

12. Reporting daily testing status.

13. Understanding test plan and test data generation.

14. Inserting, Updating, Editing and deleting the records by using SQL statement.

Team Size

5

Duration

Oct 2018 to Jan 2019

Project Description

Setup of the data repository (on-premises or on cloud)

Setup of the reporting tool

Load the datasets (external and SF) currently being used for reporting on Wave into the data repository with required transformations

API required for Salesforce reporting

Tools Used

ETL, API & Salesforce Testing, Talend, MySQL

Environment

Windows10

Project 7 (Convercent - Concur Integration)

Organization

MSKCC

Role

Team Lead – QA/Testing

Responsibilities

1. Participating in daily scrum meeting.

2. Involved in analysis of Use Cases, written and test scenario, test cases based on requirement documents.

3. Defect Logging & Verification

4. ETL & Salesforce Testing, SQL DB Testing

5. Daily/Weekly QA Status to Client

6. Understanding entire model and its functionalities.

7. Data gathering, cleansing and import/export in different formats.

8. Verifying the data in target database by ETL process

9. Verified column mapping between source and target

10. Prepared test data for functional & Integration testing

11. Interactions with BA & Dev teams to resolve the issues.

12. Reporting daily testing status.

13. Understanding test plan and test data generation.

14. Inserting, Updating, Editing and deleting the records by using SQL statement.

Team Size

5

Duration

Oct 2018 to Jan 2019

Project Description

Setup of the data repository (on-premises or on cloud)

Setup of the reporting tool

Load the datasets (external and SF) currently being used for reporting on Wave into the data repository with required transformations

API required for Salesforce reporting

Tools Used

ETL, API & Salesforce Testing, Talend, MySQL

Environment

Windows10

Project 8 (J Knipper and Company)

Product

Title Insurance DTS Application

Organization

J Knipper and Company

Role

Team Lead – QA/Testing

Responsibilities

1. Understanding the business requirements, application and its components.

2. Create and perform thorough automation test strategies to ensure comprehensive code coverage, and

3. write test cases that cover all areas.

4. Developed Keyword Driven and Data Driven frameworks to retrieve test actions, test data from Excel

5. files and SQL Databases.

6. Writing scripts, executing test cases and debugging.

7. Grouping Test cases, Prioritizing Test Cases, Executing Test Batches and generating Test Reports using

8. TestNG.

9. Worked in a highly dynamic AGILE environment and participated in scrum and sprint meetings

Team Size

6

Duration

Aug 2017 to Jan 2018

Project Description

Knipper is a company where they simplify client’s life as a service partner that could manage all product sampling need. They provide one source for direct marketing, order processing, fulfillment, compliance, data management etc. At Knipper they refer to all these services as ‘The Art of Simplicity’

Tools Used

Manual Testing & MileStonePM, Chrome

Environment

Windows10

Project 9 (Title Insurance – First American QA)

Product

Title Insurance DTS Application

Organization

Persistent Systems Limited

Role

Team Lead –QA/Testing

Responsibilities

1.Involved in analysis of Use Cases, written and test scenario, test cases based on these artifacts.

2.Created status reports for the whole team & send to Client on daily basis

3.Involved in execution of functional, system, and regression test execution process & Mobile app testing.

4.Identifying and preparing the test data required for the Test Case execution by analyzing the database specifications, writing SQL queries & Execution of database queries.

5.Assigning Task to team member & interaction with Client

Team Size

5

Duration

Nov 2015 to Dec 2016

Project Description

First American Title helps homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers, title agencies and legal professionals’ close transactions. Find out more about our products and services, and how First American can help you streamline your transaction and protect your investment. Show different images regarding particular property.

Tools Used

Manual Testing & TFS, SQL Server 2012,

Environment

Windows

Project 10 (Cycle30)

Product

Cycle30

Organization

Persistent System Ltd

Role

Module Lead.

Responsibilities

1. Designed Test cases from the system requirements specifications (SRS) for different new features

2. To execute test cases against the latest package in the local machine.

3. Reporting issue into JIRA

4. Regression testing of bugs

5. Execution database queries & verifications

6. Client interaction & Daily Status update

Team Size

20

Duration

Nov 2013 to March 2015

Project Description

Cycle30 is a different kind of billing company, offering a completely cloud-based order-to-cash platform for communications and M2M services.

Tools Used

Manual Testing & JIRA,

Environment

Windows

Project 11 (Sales force Cloud-Kennedy ERP System)

Product

Kenandy.

Organization

Persistent System Ltd

Role

Module Lead

Responsibilities

1. Designed Test cases from the system requirements specifications (SRS) for different new features

2. To execute test cases against the latest package in the local machine.

3. Report issue into JIRA

4. Regression testing of bugs

Team Size

5

Duration

Feb 2012 to Oct-2013

Project Description

Its Cloud based ERP system. Designed specifically for the realities of today's distributed manufacturing operations and global supply chain networks. Built 100% natively on the highly evolved Force.com, salesforce.com's enterprise cloud computing platform, leverages the platform's amazingly flexible social, mobile, and open features, bringing a use-just-what-you-need approach together with social media capabilities to meet today's challenges of inventory management, engineering, purchasing, production, and resource planning for better manufacturing management. Configures images of these applications on top of physical or virtual infrastructures. PUPPET Implemented.

Tools Used

Manual Testing, JIRA,

Environment

Salesforce, Windows

Project 12 (Realcom enhancement for CCH)

Product/Client

CCH USA

Organization

Persistent Systems Limited

Role

Module Lead

Responsibilities

1. Designed Test cases from the system requirements specifications (SRS) for different new features

2. Setting up the test environment on the servers.

3. Building application with latest code release and updating the build.

4. To execute test cases against the latest build in the local machine.

5. Regression of bugs and code merging, Reporting issue

6. Browser compatibility testing done on multiple browsers like Internet Explorer and Mozilla Firefox

7. Creation of Hotfixes and deploying in production environment.

Team Size

20

Duration

June 2011 to Jan 2012

Project Description

AskMe provides deep integration with SharePoint so that key capabilities such as expert profiles, search, Q&A exchange and communities are available within SharePoint. AskMe’s integration with SharePoint allows existing documents to be leveraged in communities and included in user profiles to help identify employee expertise. By leveraging AskMe in conjunction with SharePoint, organizations are able to deploy a seamless solution enabling users to: Search robust people profiles and documents simultaneously. Deploy communities to collaborate within and across project teams (horizontal communities) Provide a knowledge network to connect with experts, share knowledge and capture ROI.

This module develops the integration of AskMe with SharePoint to deliver the following features. Structured Q&A system, Expertise Location and Advanced Search, Knowledge Centers or Communities of Practice, Best Practice Management, Extended Profile

Tools Used

Manual Testing, ASP.Net, C#, SQL-Server 2008, SharePoint 2010

Environment

Windows

Project 13 (Askme Enterprise–Knowledge sharing portal- Customization)

Organization

Realcom Technology India Pvt Ltd, Pune

Role

QA Engineer

Responsibilities

1. Analyzing requirements and designing functionality and user interface test scenarios according to Customer requirement.

2. Execution of test cases for assigned modules.

3. Defect Reporting / Recommending enhancements.

4. Reporting progress on daily/weekly basis.

5. Participating in Test cases reviews – peer reviews.

Team Size

25

Duration

Sep 2008- Jun 2011

Project Description

AskMe layers business-ready knowledge discovery tools on top of a solid foundation of knowledge and business process management to build an organization's most strategic asset – knowledge capital. Harness your knowledge capital and innovate faster, reduce costs and improve customer satisfaction

Tools Used

Manual Testing, SQL Server 2005

Environment

Windows

Project 14 (Unicru Talent Search – Web portal)

Client

Kronos Talent Division, USA

Organization

TERA Informatics Pvt Ltd, Mumbai.

Role

QA Engineer

Responsibilities

1. Analyzing product functionality and designing Test cases.

2. Manual test execution for functionality, UI, Security, Navigation etc.

3. Reporting and tracking Defects.

4. Executing regression/ smoke tests.

Team Size

15

Duration

Aug 07- Aug 2008

Project Description

This application was similar to Job search portals where job profiles can be created, and people can search and apply. User can also upload resumes.

Testing Tools

Manual Testing, JIRA

Environment

Windows XP

Project 15 (Online Shopping web portal)

Client

Vidkris, Delhi

Organization

Teknotika Solutions, Pune

Role

Software Engineer

Responsibilities

1. Coding in C#.Net, Form design, GUI & Manual testing and Database handling.

2. Manual test execution and defect reporting.

3. Study Functional Requirement, Requirement Documents

4. Participate and progress reviews

Team Size

4

Duration

March 2006 to Aug 2007.

Project Description

This project involved testing of online shopping portal for Mall. Using this application people can purchase different products online and make payments online.

Testing Tools

Manual Testing, JIRA

Environment

Windows-XP.

Education

Bachelor of Computer Engineer from Pune University

Certifications

Software Quality Testing from SQTL Institute.

Networking and Hardware Course from Y.C.O.U. (Yashawantrao Chavan

Open University)

Key Skills and Knowledge

Manual Testing (Server side, ETL Testing/BI Testing,

Mobile Testing (Android & iOS)

Database Testing, Web Based & Desktop Application), Mobile App Testing Salesforce Testing, Rest API Testing with Postman

Other Skills

Cloud Computing, Telecom, Title Insurance, ERP System, Knowledge Management

Tools

Team Foundation Server (TFS), JIRA,

MileStonePM,

HP Quality Centre, QTP, SoapUI

Database:

MySQL, PostgreSQL, Oracle, Microsoft SQL Server.

Contact this candidate