Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Sukhpal Brar

Toronto

Summary

Experienced Senior Data Analyst with 5 years of expertise in utilizing SAS, Tableau,and SQL for data collection, analysis, and reporting. Proficient in procuring andinterpreting data, creating reports and dashboards to identify trends and patterns.Skilled in maintaining operational procedures and collaborating with cross-functionalteams to streamline processes. Proven track record of improving customerexperience, implementing initiatives, and automating data streams.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Consultant

CIBC
04.2022 - Current


  • Enhanced data-driven decision making by developing and implementing advanced analytics models for clients.
  • Improved customer experience in collaborating with Enterprise Process Engineering team by analyzing more than 8 million personal client data records to update them with correct conditioning messages and get right offers
  • Led an initiative with client experience team to implement end to end‘ CIBC Client Appreciation Day’ lucky draw by selecting eligible clients,collaborating with third party vendor to perform the unbiased draw, rolling out client communication for the winner
  • Assisted the Business Development team of CIBC to measure the effectiveness of national events and strategize for future event by analyzing the registration data & preparing visualization presentation using Tableau
  • Assisted the Private Wealth Management team to evaluate CMS for private banking client moving from and into the segment by analyzing customer summary table and automating the generation of monthly reports
  • Streamlined validation process of CIBC Business Operating Account and Credit Card Bundle offer eligibility list by creating a workflow in Alteryx and SAS to find out new opened accounts for newly onboarding clients and monthly closed accounts post offer roll out data
  • Automated the NPS(Net Promoter score) data stream generation for the private banking advisory survey by collaborating with Research team and private Banking team and developing robust code on SAS EG platform

Senior Data Analyst

CIBC
01.2017 - 04.2022
  • Improved data accuracy by implementing stringent data validation processes and quality control measures.
  • Applied technical skills using SAS, Tableau, and SQL in data collection, data analysis, and reporting
  • Interpreted data, analyzed results, and created reports and dashboards to identify trends and patterns
  • Documented and maintained operational procedures and processes relating to analytical and reporting processes
  • Created BI and reporting solutions to utilize data marts and external data sources
  • Integrated information from multiple sources to enable more efficientprocesses, enhanced analysis, and streamlined reporting

Education

Certificate of Technical Studies - Data Science

University of Toronto
Toronto, ON
05.2020

Post Graduate Certificate - Information Technology Solutions

Humber Institute of Technology And Advanced Learning
Toronto, ON
05.2016

Bachelors of Technology - Information Technology

Punjab Technical University
Punjab, India
05.2013

Skills

  • Data Collections
  • Data Manipulation
  • Data Science
  • Systems Analysis
  • Critical Thinking
  • Effective Customer Service
  • Microsoft Azure
  • Microsoft Visual Studio
  • SAS
  • Programming
  • NoSQL
  • SQL
  • Python

Certification

Microsoft Certified Azure Data Fundamentals
Nov 2023
SAS Certified Base Programmer for SAS 9
May 2022
Tableau Desktop Specialist
Nov 2020

Timeline

Data Consultant

CIBC
04.2022 - Current

Senior Data Analyst

CIBC
01.2017 - 04.2022

Certificate of Technical Studies - Data Science

University of Toronto

Post Graduate Certificate - Information Technology Solutions

Humber Institute of Technology And Advanced Learning

Bachelors of Technology - Information Technology

Punjab Technical University
Sukhpal Brar