Overview
Work History
Education
Skills
Accomplishments
Certification
Awards
Websites
Timeline
Generic

Abhas Bhatt

Dehradun

Overview

3
3
years of professional experience
1
1
Certification

Work History

DATA ANALYST ASSOCIATE

Telus International
12.2022 - Current
  • Writing complex SQL queries for data retrieval, filtering & validation
  • Optimizing SQL queries and database performance by analyzing query execution plans
  • Managing database security by creating user accounts, and assigning permissions
  • Troubleshoot and resolved database access issues by analyzing diagnostic information
  • Collaborated with stakeholders, and provided SQL-based solutions for data needs
  • Implemented ETL processes using inbuilt tools for seamless integration
  • Mentored new team members, and ensured a smooth onboarding process
  • Applied Domain knowledge of Defined Benefit solutions
  • Built a custom business analytics dashboard for internal and external use by extracting, transforming, and visualizing data from different sources
  • Enhanced application performances by up to 10-20% via gathering and updating requirements, resolving bugs, and maintaining/testing scripts
  • Writing and presenting performance test reports to project stakeholders to communicate test results, findings, and recommendations using Power BI.
  • Involved in Creation of dummy data in SQL for Unit Testing of script & validation.

Quality Assurance Analyst

TELUS INTERNATIONAL
10.2021 - 12.2022
  • Performed automation testing using IBM Ignite tool for HOOP,IMRF clients.
  • Created comprehensive test scenarios and test cases; executed test cases effectively.
  • Managed bug and defect tracking using Azure DevOps and HP ALM.
  • Conducted detailed analysis of business requirements to develop thorough test plans and ensure quality assurance.
  • Developed, documented, and executed manual tests for web-based applications.
  • Collaborated with team members to streamline workflows and improve productivity.
  • Worked within Agile and Scrum methodologies to meet project milestones and deliver results on tight schedules.
  • Experience in smoke testing, regression testing, user acceptance testing, and performance testing.
  • Provided knowledge transfer sessions and trained new employees, enhancing their understanding of the tool and business processes.
  • Collaborated with the IBM team on a proof of concept (POC) to enhance tool productivity and reusability.
  • Actively involved in resolving XPath issues, optimizing test scripts, and reviewing execution reports.

Education

Bachelor of Computer Science - Bachelor of Computer Application

Graphic Era Hill University
Dehradun
08-2021

Senior Secondary School -

IS Dev Samaj Sr Sec School
Chandigarh
01.2018

Secondary School -

M.R.A Sr Sec School
Chandigarh
01.2016

Skills

  • Programming Languages: C, Java, MySQL
  • Defect tracking Tool: Azure DevOps,HP Alm
  • Software Tools: IBM Ignite,JMeter, BlazeMeter, Power BI, MS Word, MS Excel, MS PowerPoint, Eclipse, VS Code,Erwin
  • Soft Skills: Communication skills, Leadership, Teamwork, Documentation Management, Quality Assurance, Requirement Analysis

Accomplishments

  • Dignified with "C GRADE" Certificate in National Cadet Corps(NCC)

Certification

  • Certified in SQL from Udemy Platform.
  • Certified in Jmeter from Udemy Platform.
  • Certified in Erwin data Modeller from Udemy Platform.
  • Certified in Xpath,SlectorHub from Udemy Platform.
  • Certified in PowerBi from Udemy Platform.
  • Certified in Java from Coding Ninjas.

Awards

  • LifeWorks Pat On The Back Award
  • LifeWorks Bright Beginning Award
  • Lifeworks Shining Star Award
  • Lifeworks Gladiator team Award

Timeline

DATA ANALYST ASSOCIATE

Telus International
12.2022 - Current

Quality Assurance Analyst

TELUS INTERNATIONAL
10.2021 - 12.2022

Bachelor of Computer Science - Bachelor of Computer Application

Graphic Era Hill University

Senior Secondary School -

IS Dev Samaj Sr Sec School

Secondary School -

M.R.A Sr Sec School

Similar Profiles

CREATE PROFILE
Abhas Bhatt