SUKHPAL BRAR
CIBC
Brampton,ON
10
years of professional experience
3
Languages
Results-driven Senior Data Analyst with 5 years of experience in SAS, Tableau, and SQL for data analysis and reporting. Specializes in data procurement and interpretation, developing insightful dashboards and reports to uncover trends. Expertise in streamlining processes through collaboration with cross-functional teams and automating data workflows to enhance customer experience.
Skills
Javascript
Python
Sql
Java Programming
Data visualization
Unix
Spark SQL
Data visualization tools
Accomplishments
- Knowledge Badge - SQL Analytics on Databricks
- Academy Accreditation - Databricks Fundamentals
- Azure Data Fundamentals
- SAS Certified Specialist: Base Programming Using SAS 9.4
- Tableau Desktop Specialist
Work History
Data Consultant
4 Years 5 Months- 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
- 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
- Assisted Business Development team to evaluate national events' effectiveness and strategize future events by analyzing registration data and preparing visualizations in Tableau.
- Evaluated CMS for private banking clients moving segments by analyzing customer summary tables.
- Streamlined validation process for CIBC Business Operating Account and Credit Card Bundle offer eligibility by creating a workflow in Alteryx and SAS to identify new accounts for onboarding clients and closed accounts after offer rollout.
- Automated NPS data stream generation for private banking advisory survey by collaborating with Research and Private Banking teams and developing code on SAS EG platform.
Senior Data Analyst
5 Years 3 Months- Interpreted data, analyzed results, and created reports and dashboards to identify trends and patterns
- Procured data from database structures to deliver timely reporting and solutions for client requests
- Procured data from database structures to report and provide solutions to client requests in a timely manner
- Documented and maintained operational procedures for analytical and reporting processes to ensure consistency and accuracy
- Created BI and reporting solutions to utilize data marts and external data sources
- Developed business intelligence solutions to improve data visualization. and reporting solutions to utilize data marts and external data sources
- Organized and compiled data into structured formats for analysis. into multi-dimensions with various granularities
- Integrated information from multiple sources to streamline reporting and enhance analysis capabilities
- Worked independently as a senior lead to guide developers and support analysis, design, and data management solutions on larger projects
Education
Post Graduate Certificate - Information Technology
Certificate in Technical Studies - Data Science
Bachelors of Technology - Information Technology
Languages
English
Full Professional
Hindi
Full Professional
Punjabi
Full Professional
Affiliations
- Association of Information Technology Professionals
Software
- Sas Studio
Personal Information
Title: Data Consultant
Timeline
Data Consultant
CIBC
04.2022 - CurrentRead More
Senior Data Analyst
CIBC
01.2017 - 04.2022Read More
University of Toronto
Certificate in Technical Studies from Data Science
Read More
Punjab technical University
Bachelors of Technology from Information Technology
Read More
Humber Institute of Technology and Advanced Learning
Post Graduate Certificate from Information Technology
Read More