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
Dehradun08-2021
Senior Secondary School -
IS Dev Samaj Sr Sec School
Chandigarh01.2018
Secondary School -
M.R.A Sr Sec School
Chandigarh01.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