Data Analyst

• Jul 2022 - Present

Data Analyst

• Jul 2022 - Present

ACP (Analytics Consulting Project) Consultant, cooperated with CIBC Data Science Team

• Nov 2021 - Apr 2022

CIBC branch sentiment analysis based on Google Map reviewsCarried out CIBC branch sentiment analysis by coordinating with data science team. Established dimensional database with 1 fact table and 4-dimension tables within PostgreSQL. Utilized Tableau to visualize sentiment scores and star ratings on heat-maps throughout Canada. Extracted topic words of positive and negative reviews at city and province levels by training LDA models and writing regular expressions.• Investigated driven words of positive and negative reviews as well as to explore word phrases with highest and lowest sentiment scores while performing fine-grained sentiment analysis.• Achieved 90% accuracy in predicting sentiment scores of CIBC branch reviews while training TD-IDF based and embedding-based sentiment models with SVM, LSTM, and CNN.• Raised recommendations by performing comparative analysis against a main competitor in Canada. Show less

ACP (Analytics Consulting Project) Consultant, cooperated with CIBC Data Science Team

• Sep 2021 - Oct 2021

Connections of ultra-high net worth people in CanadaDeveloped and deployed web scrapers on AWS EC2 instance to collect Canadian listed company management team profile information from Yahoo Finance and name pairs search frequency from Bing. Bypassed scraper detection by applying dynamic proxy IPs and random pseudo headers.• Created interactive connection graphs of 126 executives from listed Canadian companies with salaries higher than 2 million CAD through pyecharts.

Claims Administrator

• Apr 2019 - Mar 2021

• Maintained claims information in insurance database. • Investigated circumstances surrounding insurance claims to determine validity of claim. • Determined amount of loss covered by insurance policies. • Built the master list searching tool, the unit price statistics table, and the unit price auto-filling tool in Excel VBA. These tools saved months of time, according to colleagues. • Audited more than 200 bulk invoice spreadsheets from 8 different providers and located more than $20,000 duplicate reimbursements, with the help of Excel VBA. • Located and fixed errors on cost containment report exported from insurance database. Show less

Intern Data Analyst

• Nov 2018 - Feb 2019

• Built the portfolio performance visualization tool and the customer questionnaire visualization tool in Python. • Deployed web scrapers to collected stock market data from DataStream and Yahoo Finance for stock selection system. • Ran the stock selection system based on different criteria to support the stock portfolio optimization process. • Collected and prepared portfolio performance data to support portfolio fact sheet. • Supported other stock market research projects. • Built the portfolio performance visualization tool and the customer questionnaire visualization tool in Python. • Deployed web scrapers to collected stock market data from DataStream and Yahoo Finance for stock selection system. • Ran the stock selection system based on different criteria to support the stock portfolio optimization process. • Collected and prepared portfolio performance data to support portfolio fact sheet. • Supported other stock market research projects.

Tax Department Intern

• Jul 2016 - Aug 2016

• Prepared documents to support cross-border merger and acquisition projects. • Built the government contact information database by using PowerBuilder. This database allowed users to add, delete, edit, and retrieve the duties of different government departments, the working hours of them, and the phone records with them. • Prepared documents to support cross-border merger and acquisition projects. • Built the government contact information database by using PowerBuilder. This database allowed users to add, delete, edit, and retrieve the duties of different government departments, the working hours of them, and the phone records with them.