Sukhpal Brar
14 Junior Rd, Brampton,ON
Summary
Experienced Senior Data Analyst with 7 years of expertise in utilizing SAS, Tableau, and SQL for data collection, analysis, and reporting. Proficient in procuring and interpreting data, creating reports and dashboards to identify trends and patterns. Skilled in maintaining operational procedures and collaborating with cross-functional teams to streamline processes. Proven track record of improving customer experience, implementing initiatives, and automating data streams.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Consultant
CIBC
Toronto
05.2022 - Current
- Optimized client data processes by designing, testing, and deploying custom ETL pipelines.
- 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.
- 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.
- 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 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.
Senior Data Analyst
CIBC
Toronto
12.2016 - 05.2022
- Developed complex SQL queries to analyze large datasets for trends and insights.
- Created data visualizations in Tableau to present findings to stakeholders.
- Performed statistical analysis on customer data to identify patterns and correlations.
- Designed, developed and implemented ETL processes for data integration from multiple sources.
- Optimized database design and queries for improved performance of analytics operations.
- Developed dashboards in PowerBI to provide real-time business intelligence insights.
- Prepared reports, briefings and instruction manuals for software solutions and data assets with concise language and clear document design.
Education
Certificate of Technical Studies - Data Science
University of Toronto
Toronto, ON04-2020
Post-Degree Certificate - Information Technology
Humber Institute of Technology And Advanced Learning
Toronto, ON04-2016
Bachelor of Technology - Information Technology
Punjab Technical University
Punjab, India04-2013
Skills
- Python Programming
- Business Intelligence
- NoSQL Databases
- Relational databases
- Advanced Excel
- Data Modeling
- SQL processing
Languages
English
Full Professional
Punjabi
Native/ Bilingual
Hindi
Full Professional
Certification
- Microsoft Certified Azure Data Fundamentals - Nov 2023
- Microsoft Certified Azure Data Engineer - May 2024
- SAS Certified Base Programmer for SAS 9 - May 2022
- Tableau Desktop Specialist - Nov 2020
References
References available upon request.
Timeline
Data Consultant
CIBC
05.2022 - Current
Senior Data Analyst
CIBC
12.2016 - 05.2022
Certificate of Technical Studies - Data Science
University of Toronto
Post-Degree Certificate - Information Technology
Humber Institute of Technology And Advanced Learning
Bachelor of Technology - Information Technology
Punjab Technical University
Similar Profiles
Rita DeFazioRita DeFazio
CSR at CIBCCSR at CIBC
PREETHU NANJAPPAPREETHU NANJAPPA
Contact Center Representative at CIBCContact Center Representative at CIBC
Nidhi ParikhNidhi Parikh
Universal Banker/FSR at CIBCUniversal Banker/FSR at CIBC
Kevin ChangKevin Chang
FINANCIAL SERVICE REPRESENTATIVE at CIBCFINANCIAL SERVICE REPRESENTATIVE at CIBC
Upneet LubanaUpneet Lubana
Senior Fund Administrator, Hedge Funds at SS&C Technologies. IncSenior Fund Administrator, Hedge Funds at SS&C Technologies. Inc