Vivian Li

Business Development Executive

Canada10 yrs 5 mos experience
Most Likely To SwitchHighly Stable

Key Highlights

  • Senior Manager in Business Intelligence with strong analytical skills.
  • Expert in data visualization and manipulation using advanced tools.
  • Bilingual professional with a Master's in Data Science.
Stackforce AI infers this person is a Data Science and Analytics expert in the Fintech industry.

Contact

Skills

Core Skills

Data VisualizationData ManipulationAnalyticsAutomation

Other Skills

Python (Programming Language)Ad TechAzure DatabricksExtract, Transform, Load (ETL)TableauSQLRdbtMicrosoft ExcelPowerPointTeamworkAnalysisData AnalysisStatisticsFinancial Analysis

About

• ASA, ACIA Designation • Completed Exam ILALP • Fully bilingual in French and English • Interests: Cooking, Fitness, Travelling, Computer Skills: • Advanced: Excel, Word, PowerPoint • Intermediate: SQL, VBA, R, AXIS, Access • Basic: MATLAB

Experience

10 yrs 5 mos
Total Experience
1 yr 5 mos
Average Tenure
5 yrs
Current Experience

Stackadapt

3 roles

Senior Manager Business Intelligence

Promoted

Jan 2024Present · 2 yrs 5 mos · Toronto, Ontario, Canada

Manager, Business Intelligence

Promoted

Jun 2022Apr 2024 · 1 yr 10 mos · Toronto, Ontario, Canada

Python (Programming Language)Ad TechAzure DatabricksAutomationExtract, Transform, Load (ETL)Data Visualization+4

Senior Analyst, Business Intelligence

Jun 2021Jun 2022 · 1 yr · Toronto, Ontario, Canada

Ad TechAutomationExtract, Transform, Load (ETL)Data VisualizationData ManipulationAnalytics

The co-operators

Actuarial Insights Analyst, Actuarial Insights

Oct 2019Jun 2021 · 1 yr 8 mos · Toronto, Canada Area

  • Performed unguided data exploration and investigated profitability concerns
  • using regression, clustering, and classification algorithms in R
  • Created reports to monitor the impact of rate changes across all product lines
  • and presented actionable findings to team leaders
  • Wrote SAS programs to manipulate data required for projects aimed at
  • improving the organization’s profitability
  • Improved efficiency for report validations and created documentation to track
  • new processes
Data VisualizationData ManipulationAnalytics

Rbc

Data Management Analyst

May 2019Sep 2019 · 4 mos · Toronto, Canada Area

  • Support AML analytics team to enhance data governance in an Agile environment
  • Perform data profiling and exploratory data analysis
  • Identify and evaluate data elements required for AML purposes

Munich re canada

2 roles

Actuarial Associate - New Business Pricing

Promoted

Aug 2017May 2019 · 1 yr 9 mos · Toronto, Canada Area

  • Set assumptions to determine competitive Life and Living Benefits rates for Request for Proposals from clients under tight deadlines while considering profit targets
  • Modelled and analyzed cash flows in AXIS for various projects to develop reinsurance solutions for clients
  • Demonstrated an understanding of reinsurance structures, treaty provisions, and Munich Re’s risk tolerance while assisting with drafting treaties
  • Automated profit reports using VBA to optimize review and approval of metrics
  • Provided guidance to and trained interns on reinsurance and actuarial concepts

Data Management Analyst

Jan 2017Jul 2017 · 6 mos · Toronto, Canada Area

  • Investigated and resolved complex data issues by communicating with other team members and internal departments to deliver accurate treaty-related data to internal stakeholders and business partners
  • Accurately interpreted treaty agreements while implementing process improvements to automate and optimize reinsurance processes during the setup of treaties with SQL
  • Created various macros to analyze reports efficiently and provide timely responses to non-routine work requests
  • Mentored a team of 3 members to abide by data quality standards while meeting stakeholder deadlines and requirements
AutomationExtract, Transform, Load (ETL)

Milliman

Actuarial Intern

Jan 2016Apr 2016 · 3 mos

  • Worked in a team to create an efficient procedure to decrease losses, prevent legal action, and retain customers through quicker processing of policy requests during acquisition
  • Ensured UL/EIUL policy requests were processed correctly by reviewing the requirements and terms to understand how each policy functions
  • Gained knowledge of M&A in the insurance industry by assisting with model building and companies’ cash flow testing using MG-ALFA

Just energy

Risk Analyst

May 2014Dec 2014 · 7 mos

  • Facilitated reporting procedures by assisting in the automation of daily volatility and power position reports using Microsoft Visual Studio, saving 2 hours each day
  • Optimized daily processes by utilizing SQL, VBA and macros to automatically prepare data files to upload into databases
  • Generated and analyzed daily controls reports to ensure data sent to the Supply team is accurate and within limits

Ontario ministry of economic development, trade and employment

Program Assistant

Aug 2013Dec 2013 · 4 mos

  • Performed research and economic analysis to compile relevant data on industry specific trends, employment, and growth patterns for lead generation campaigns
  • Prepared and developed research reports for the Investment Lead Generation Team to support IBDRs and potential clients
  • Collected data promoting Ontario to develop presentation materials to attract foreign direct investment

Haivision

Accounting/Administration Intern

Jan 2013Apr 2013 · 3 mos

  • Implemented a new asset tracking system by meeting 200+ employees and the senior management team in a professional manner
  • Trained employees on using the asset database and documented the asset database maintenance process
  • Honed knowledge of financial accounting and Sage Accpac while assisting with quarterly commissions reports, order entry, invoicing, and accounts payable

Grote industries, llc

Order Coordinator/Purchasing Assistant

May 2012Aug 2012 · 3 mos

Education

University of Waterloo

Bachelor’s Degree

Jan 2011Jan 2016

Ryerson University

Masters of Science — Data Science and Analytics

Jan 2018Jan 2020

Marianopolis College

Honours Commerce

Jan 2009Jan 2011

Stackforce found 100+ more professionals with Data Visualization & Data Manipulation

Explore similar profiles based on matching skills and experience