Mo.No.: 838******* Education: B.E (Electrical & Electronics Engg, 2015-2019)

Email _id: adxwj0@r.postjobfree.com Languages: English, Marathi, Hindi WORK EXPERIENCE

Project_1 Name: Verizon Billing System

Client: Verizon, USA

02/2020 - 08/2021 Bengaluru

Tasks:

• Understanding the requirements by using SRS.

• Converting test scenario into test cases.

• Performed Manual testing to validate

functionality detect the bug.

• Executing testing activities and working within

deadlines.

• Participation in Reject analysis with the

Developers team.

• Reporting and Closure of Defects submitted in

the Defect Tracking tool.

• Identified and created issues and bugs in Jira.

• Involved in testing the backend Database;

retrieved the data from the tables using SQL

Queries.

• Performed Database testing at the application

level and analyze data types and sizes.

Project_2 Name: Salesforce CRM

Client: Johnson & Johnson, USA

06/2021 - Present Bengaluru

Tasks:

• Understanding the Requirement Document.

• Participated in preparing test strategy, and

identifying the required Test scenarios and Test

Cases.

• Followed Agile testing methodology, participated in daily Scrum meetings, and tested each Sprint.

• Writing the test case from requirement document

and reviewing it.

• Execution of test cases from excel.

• Identified and created issues and bugs based on the User Stories in JIRA.

• Performing ETL / Data Validation Testing, Smoke, Sanity, Retesting and Regression Testing.

• Validation of Expected Output Vs Actual Output.

SKILLS

PROFESSIONAL SUMMARY

• 3.0 years of experience in Functional Testing and Data Validation / DWH / ETL Testing for the Salesforce and Telecom domain.

• Having good technical expertise in ETL, Database, Manual Testing, UNIX Testing, and Functional Testing.

• Technical experience in ETL testing using the SSIS package.

• Performed Database Testing Using SQL Queries and used Database utility tools as an Oracle SQL Developer.

• During Database Testing Involved in Table Structure Validation and Manipulation.

• Good Experience in tools like Oracle SQL Developer, SSIS, and Jira.

• Expertise in performing Functional, System, Regression, Sanity Testing, and STLC.

• Experience in Agile/Scrum testing methodology, and strong expertise in functional, regression, UI, and system testing.

• Very good at writing/reviewing test cases, test Scenarios, and test summaries.

• Executing and monitoring jobs through SSIS for checking the job.

• Written Test Cases for ETL to compare Source and Target database.

• Validate the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules.

• Experience in Metadata and Star schema/Snowflake schema.

• Analyzed Source Systems, Staging area, Fact, and Dimension tables in Target DWH.

• Having good experience in various types of ETL transformation.

• Strong Knowledge of OLTP and OLAP.

• Experience in ETL process consisting of data transformation, sourcing, mapping, conversion, and loading.

• Good experience in File to Database Validation Using Unix command.

STLC

Oracle +

SQL Server

Bhushan Umbarkar

Software Test Engineer

An Independent, self-motivated and Analytical Software Test Engineer Having 3.0 Years of Experience in the Software Industry, specializing in Functional Testing, Manual testing, Database Testing, ETL Testing, And Unix Testing. In My Current Role I Have Been Responsible for Understanding Customer Requirement, Designing Test Scenarios, Test Cases and Test Execution and Maintain Defects in Jira, and Co-ordinating with Team Members. I am Proud of My Solid Track Record of Delivering Project on Time. I am Now Looking to Take on Greater Responsibility, which will Shine My career and Make me More Productive. Manual Testing Unix

ETL Testing

SSIS

Jmeter

Testing

Smoke/Sanity

Database Testing SQL

JIRA

Retesting Regression

Contact this candidate