Summary
Overview
Work History
Education
Skills
Certification
Work Availability
Timeline
Hi, I’m

Abid Khan

Calgary,AB

Summary

Professional Summery Recent graduate from Southern Alberta Institute of Technology with a strong passion for data analytics and 1 year of hands-on experience in IT Data Analysis with a focus on Enterprise Data Governance. Detail- oriented, self-driven problem-solver with excellent communication skills and a customer-focused mindset. Proficient in SQL, Python, Excel (V-lookup, pivot table), Power BI, and Tableau.

Overview

5
years of professional experience
1
Certification

Work History

Analysis of Virgin Train, Virgin Rail Group

Data Analyst
10.2022 - 12.2022

Job overview

  • Analyzed large datasets to identify patterns and trends, using statistical methods and machine learning algorithms
  • Developed interactive visualizations to present the insights to the management team
  • Technologies: Python, R, Tableau, SQL
  • Project Link: https://github.com/abidcro/-Virgin-Train-Virgin-Rail-Group-analysis-.git
  • Enterprise Data Governance Project: The Canadian Disaster Database (CDD), As part of the CDD project, I was responsible for ensuring that the data used was compliant with relevant industry and government regulations, and that appropriate data catalogs were established to govern the use of data
  • This included implementing data monitoring processes to proactively maintain a high and consistent standard of data quality
  • To analyze the data, I used SSIS and SQL Server 2019, and leveraged simulation modeling to run000,000 simulations for disasters
  • Additionally, I utilized APRIORI modeling to determine whether any disasters occurred at the same time, helping to identify potential correlations and inform disaster response strategies
  • Project Link: https://github.com/abidcro/-Canadian-Disaster-Database-CDD.git

Scotiabank, Calgary , Canada

Customer Representative
09.2018 - Current

Job overview

  • Resolved concerns with products or services to help with retention and drive sales
  • Served 40+ customers every day for their daily routine banking needs
  • Provided primary customer support to internal and external customers
  • Maintained customer satisfaction with forward-thinking strategies focused on addressing customer needs and resolving concerns
  • Conducted surveys to determine customer opinion of products and services.
  • Helped large volume of customers every day with positive attitude and focus on customer satisfaction
  • Responded to customer calls and emails to answer questions about products and services
  • Maintained courteous, friendly atmosphere for guests to increase overall satisfaction and customer service standards

Education

Data Analytics, Southern Alberta Institute of Technology , Calgary, Alberta

Post-Grad Diploma from Business Analytics
06.2023

Institute of Management Sciences , Pakistan

Maters from Business Administration (Management information system
2010

Skills

  • SKILLS & COMPETENCIES
  • Data warehousing, including data extraction, cleaning, transformation, loading, & refreshing
  • Performance optimization using Power BI Performance Analyzer
  • Understanding of data catalogs that govern the use of data in compliance with industry
  • Data monitoring to proactively maintain a high and consistent standard of data quality
  • SQL Server (SSIS, SSRS, SSAS)
  • Visual studio, IBM Cognos, IBM SPSS
  • MS Excel (DAX, Power Queries, Pivot Tables, etc)

Certification

IBM-Business Intelligence Analyst - Oct 2022

IBM-Predictive Analytics Modeler - Oct 2022

AWS Cloud Practitioner Essentials - Aug 2022

Availability
See my work availability
Not Available
Available
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse

Timeline

Data Analyst

Analysis of Virgin Train, Virgin Rail Group
10.2022 - 12.2022

Customer Representative

Scotiabank, Calgary , Canada
09.2018 - Current

Data Analytics, Southern Alberta Institute of Technology

Post-Grad Diploma from Business Analytics

Institute of Management Sciences

Maters from Business Administration (Management information system

IBM-Business Intelligence Analyst - Oct 2022

IBM-Predictive Analytics Modeler - Oct 2022

AWS Cloud Practitioner Essentials - Aug 2022

Abid Khan