Summary
Overview
Work History
Education
Skills
Roles & Responsibility -
Certification
Accomplishments
Disclaimer
Languages
Timeline
Generic
Vikas Gupta

Vikas Gupta

Pune

Summary

10+ yrs. years of experience in ETL/Report testing/Database testing and manual testing in telecommunications/life science domain. QA Lead with in-depth software testing experience. Expertly planned testing projects by fully reviewing intended functionality and establishing test parameters. Effectively identifies and resolves root problems. Proven leader talented at training new teammates, monitoring progress and boosting morale.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Test Lead (BI Report/ETL Tester)

IBM India
Pune
08.2021 - Current

Project Title: - Lash Group (Client Analytics)

Client – AmerisourceBergen Co.

BI Report/ETL Tester

Amdocs India LLP
Pune
11.2016 - 07.2021

Project 1 : - Sunrise

Client – AT & T

Project 2 - Globe Telecom

Client – Philippines

ETL Tester

Cognizant Technology Solution
Pune
05.2016 - 10.2016

ABBVIE (United State)

ETL Tester

Experis IT Pvt Ltd(Amdocs DVCI)
Pune
03.2015 - 04.2016

Rogers Canada

Software Test Engineer

Senate System Pvt Ltd
Pune
08.2013 - 02.2015
  • Roblox Studio
  • RS (United State)

Education

B. Tech (CSE) - CSE

Arya Institute of Engineering & Technology
Jaipur
08-2012

Skills

ETL Testing

BI/Reports Testing

Database testing

Unix

Manual testing

Informatica testing

Data modelling

Databases - Teradata, Toad (Oracle), Snowflake, MS SQL Client on Azure cloud

Reports Tool – Tableau, Qlik View, Power BI, SSRS, IBM Cognos

Test management Tools - HPQC, TDP, Jira Align, Erwin, Microsoft TFS, ADO

AZ-900 Microsoft Certified - Azure Fundamental, Basic Aws knowledge

Roles & Responsibility -

1. Involved in Test Planning ,Test Strategy, and Test Data Preparation in Salesforce CRM and Test Execution.

2. Involved in identifying defects in the application, tracking them and finally closing the defects after appropriate resolution in ADO tool.

3. Interaction with client on clearing exact requirements.

4. Providing Daily Status to Client and the Senior Leadership for Reporting purposes.

5. Using ADO for Test cases/plans and execution.

6. Report testing on Power BI, Tableau and Qlikview against MS SQL database in Azure env.

7. Responsible for gathering the requirements and creating scenarios related to testing needs. Working with Scrum Masters and  PM’s & gathering scope and information’s of the projects.

8. Responsible for running the Jobs in UNIX to load the data into SIT environment.

9. Responsible for ETL/Sql validation, including the business rules and transformation logics.

10.Reporting daily progress status and providing support during E2E production releases.

11. Production Code refresh (DDR) into testing/QA environment, Deployment Guide Validation and production deployment readiness check.

12. Performed BA role for sometime  – (Call setup handles with clients and Dev /DA/Testing).

13. Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.

Certification

AZ-900 Microsoft Certified - Azure Fundamental

Accomplishments

  • Assisted team members in understanding the overall process via KT sessions
  • Received good remarks from offshore supervisor and onshore stakeholders
  • Participated in singing competitions in Office events

Disclaimer

I hereby certify that all the information provided here is correct to the best of my knowledge.

Languages

Hindi
First Language
English
Proficient (C2)
C2

Timeline

Test Lead (BI Report/ETL Tester)

IBM India
08.2021 - Current

BI Report/ETL Tester

Amdocs India LLP
11.2016 - 07.2021

ETL Tester

Cognizant Technology Solution
05.2016 - 10.2016

ETL Tester

Experis IT Pvt Ltd(Amdocs DVCI)
03.2015 - 04.2016

Software Test Engineer

Senate System Pvt Ltd
08.2013 - 02.2015

B. Tech (CSE) - CSE

Arya Institute of Engineering & Technology
Vikas Gupta