Abhijeet Gavhale

Software Test Engineer

Profile

● More than 3+ years of experience in the field of QA/Testing with specialization in testing of healthcare & telecom billing -BSS applicationsand testing of web based & Client- Server applications, effective use of QA and Testing practices.

● Experience in validating checks like Record count Check, Reconcile records with source data, No Junk data loaded, Key or Mandatory Field not missing, duplicate data, Data type and size check on Stage table.

● Experience in validating checks like Business data check like telephone no can’t be more than 10 digit or character data, Record count check for active and passing transformation logic applied, Derived Field from the source data is proper, Check Data flow from stage to intermediate table, Surrogate key generation check if any when Business transformation logic applied.

● Experience in validating checks like Record count check from intermediate table or file to target table, Mandatory or key field data not missing or Null, Aggregate or derived value loaded in Fact table, Check view created based on target table, Truncate and load table check, CDC applied on incremental load table, dimension table check & history table check, Business rule validation on loaded table, Check reports based on loaded fact and dimension table

● Worked on SCD1 and SCD2.

● Experience in writing SQL queries to validate source and target tables.

● Very good experience in various types of ETL transformation.

● Strong Knowledge on OLTP and OLAP.

● Extensive experience in ETL process consisting of data transformation,sourcing, mapping, conversion and loading.

● Reviewed mappings and test cases before delivering to Client.

● Written Test Cases for ETL to compare Source and Target database systems

● Good Experienced of various types of testing like Functional testing, Database testing, Integration Testing, Regression Testing,

● Well versed with SDLC, STLC, Testing Concepts and Methodologies.

● Strong experience in analyzing requirements (SRS) and identifying Test Scenarios, Test cases, Test case execution and Defect analysis.

● Worked on Agile methodology and participated in scrum meeting to discuss test operation activities with Scrum Master. Skills

ETL Testing

BI Testing

Database Testing

API Testing

Manual Testing

JIRA

Tableau

SSIS

Postman

Agile Methodologies

● Prepared Weekly status Report and Daily status Report send to higher authority.

● Performed Database Testing Using SQL Queries and used Database utility tool as SQL Developer.

● During Database Testing Involved in Table structure Validation and Data Manipulation.

● Checked server status, Send file to server and verify Response file and prepare report using UNIX commands Via PuTTY Terminal

● A results-driven, customer-focused, articulate and analytical Software test Engineer who can think "out of the box".

● Good communication, collaboration with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

● Experience in API Testing using Postman.

● Experience in Dashboard and report testing using Tableau.

● Execute SQL queries to compare the data in database with GUI and web services.

● Strong experience in all phases of software testing life cycle such as requirement analysis, test scenario and test case design, test case execution, defect tracking and managing defect lifecycle. Participate in Scrum Meeting to discuss issues and work activities.

● Identify Defects during test case execution Using JIRA as test management tool, analyzing bugs to find out RCA and interacting with development team members and Business Analysts in fixing the defects.

● Extensive experience in coordinating testing effort, responsible for client interaction, daily dashboard preparation & issue escalations between different teams in different geographical locations.

● Strong written and verbal communications.

● Have used Azure Databricks for querying database.

● Executed Queries in Azure Databricks, Azure synapse and compare with Dashboard.

● Run the SQL Queries in Azure and validate the data.

● Knowledge on Azure Data factory for checking pipeline runs Employment History

Software Test Engineer at Cybage, Pune

March 2020 to Till date

Education

BE, Suresh Deshmukh College of Engineering, Wardha PROJECTS

Truphone - Billing, Truphone, UK

Description:

Truphone is a GSMA accredited global mobile network that operates its service internationally. The company is headquartered in London and has offices in ten other countries, being spread across four continents. Truphone offers eSIM-based GSM mobile services to both businesses and individuals, mobile phone calls and SMS recording services for businesses, remote SIM provisioning and related services, and has a customer base that includes more than 3,500 multinational enterprises in 196 countries. Responsibilities:

Review of SRS, and User Interface Specifications documents

Analyse User stories, and User Interface Specifications documents

Prepare and Execution of Test cases from test scenarios to meet Business Logic

Writing SQL queries, Data validation testing.

Done the review and send review comments to others.

Executing testing activities and working within deadlines.

Performed Database Testing at Application level and analyze data types and length from LLD

ETL testing, validating data from source and destination

Testing the mappings which are based on SCD-1 and SCD-2

Reporting and Closure of Defects submitted in Defect Tracking tool

Participation in Reject analysis with Developers team CRM Billing- Pfizer, Pfizer, USA

Description:

Pfizer develops and produces medicines and vaccines for immunology, oncology, cardiology, endocrinology, and neurology. The company has several blockbuster drugs or products that each generate more than US$1 billion in annual revenues. In 2020, 52% of the company's revenues came from the United States, 6% came from each of China and Japan, and 36% came from other countries.

This makes customers to manage the entire health life cycle effectively. Responsibilities:

Understanding the Requirements and Functional Specifications of the application.

Analyze User stories, and User Interface Specifications documents

Participated in identifying the required Test scenarios and Test Cases.

Prepare and Execution of Test cases from test scenarios to meet Business Logic

Writing SQL queries, Data validation testing.

Done the review and send review comments to others.

Field size validation, checking constraints

Executing testing activities and working within deadlines.

Run the SQL Queries and validate the data.

Perform ETL testing, validating data from source and destination.

Count Validation, Data Model Validation, Duplicate data validation, Data Model Validation.

Testing the mappings which are based on SCD-1 and SCD-2.

Interaction with Onshore team in defect fixing process

Reporting and Closure of Defects submitted in Defect Tracking tool

Participation in Reject analysis with Developers team.

Perform BI testing by comparing data in the report and the data in the DWH

Executed Queries and compare with Dashboard.

Involved in team meetings in regular intervals of time to monitor the Quality of application in daily, weekly status report meeting. Details:

Pune, India, 918*********

adxs0a@r.postjobfree.com

Contact this candidate