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
Similar Profiles
Stephanie UllianStephanie Ullian
AI Training/Search Result Evaluator and Safety Rate at Telus Digital FKA Telus InternationalAI Training/Search Result Evaluator and Safety Rate at Telus Digital FKA Telus International
Gerald MakohoniukGerald Makohoniuk
SYSTEM ANALYST LEVEL II at TELUS/TELUS INTERNATIONALSYSTEM ANALYST LEVEL II at TELUS/TELUS INTERNATIONAL
Aqsa HashmiAqsa Hashmi
Sr. Applications Developer at Telus InternationalSr. Applications Developer at Telus International
Sumit KumarSumit Kumar
Sr. Applications Developer at Telus InternationalSr. Applications Developer at Telus International
PRIYANKA DOBHALPRIYANKA DOBHAL
Senior Analyst at Accenture Services PrivateSenior Analyst at Accenture Services Private