Sumit Bhaskarwar Email & Phone Number

Pune, Mh, In

Pune, Maharashtra, India

Pune, Maharashtra, India

Pune, Maharashtra, India

Thorough out the project in various iterations/Sprints – conducted system testing, integration testing, functional testing and integration testing. Document test cases that validate Source-to-Target ETL mapping requirements Conducting UAT and documentation of test cases. Familiar in designing and developing manual and automation test cases and test scripts Developed complex SQL queries for querying data against different data bases for data verification process. Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings. Participated in regular project status meetings and QA status meetings. Extensively used and developed SQL scripts/queries in backend testing of Databases. Written test cases to test the application in Excel, Mantis defect and bug tracker. Defects identified in testing environment are communicated to the developers. Prepared daily status reports with details of executed, passed, and failed test cases and defect status. Creating test cases for ETL mappings and design documents for production support Effectively communicate testing activities and findings in oral and written formats Extensively testing of several BI/MIS (SSRS) Reports – SSRS reports and Dashboards to validate the reports the data and cosmetics of the report.

Pune, Maharashtra, India

• Requirements understanding from business user• Writing SQL queries per transformation logic.• Client communication & reporting• Defect Tracking using JIRA .• Test Execution and Report testing• Testing of DB Views, Transformation logic, DashboardsValidation mainly involves,• Comparison of the table schema for correct table/column names, key constraints, length etc.• To check for the transformation logic according to the defined transformation rule• Verify aggregation, Null, duplicate, data integrity for record count match • Error handling

Pune

• Understanding requirements from the client.• Test Execution and Detailed Report Analysis presentation.• Testing of SQL Jobs created for ETL cycle based upon the condition given from the client.• Testing of BI Merchant Report Tableau Dashboards.• Prepared and updated Data validation and layout validation Test Cases for Dashboards• Involved in Database testing, Regression Testing, UI and Usability testing of Dashboards.• Created and optimized SQL scripts for data validation of Dashboards.• Uploaded Test Cases and executed test case through Test Link and Spira Test Management tool• Defect tracking and reporting through TTPro and Devtrack.• Client communication & reporting.

Mumbai Area, India

• Understanding requirements from the client.• Test Execution and Detailed Report Analysis presentation.• Prepared and updated Data validation and layout validation Test Cases for Dashboards• Involved in Database testing, Regression Testing, UI and Usability testing of Dashboards.• Uploaded Test Cases and executed test case through A2Z GMS Test Management tool• Defect tracking and reporting through A2Z GMS.• Client communication & reporting.