Robert Liu

Robert Liu Email and Phone Number

Senior Manager, Business Analytics and Reporting @ BMO
Markham, ON, CA
Robert Liu's Location
Markham, Ontario, Canada, Canada
Robert Liu's Contact Details

Robert Liu personal email

n/a
About Robert Liu

• Analytical thinker and detail-oriented person with practical experience and deep understanding of data analysis, policy analysis, and database management• Proven ability to analyze multiple data analysis projects at a short period of time • Demonstrated exceptional multitasking ability by delivering key projects with competing deadlines• Strong ability to work both independently and in team environment with a keen focus on driving execution of secondary and primary client-level research projects• Proficient in Microsoft Suite (Excel, PowerPoint, Access), statistical software (STATA, SAS) and VBA programming skills• Superior SQL proficiency in query creation, data validation and manipulation, ability to perform data mining to answer business questions• Fluent in English and Mandarin along with excellent oral and written communication skills

Robert Liu's Current Company Details
BMO

Bmo

View
Senior Manager, Business Analytics and Reporting
Markham, ON, CA
Website:
bmo.com
Employees:
58030
Robert Liu Work Experience Details
  • Bmo
    Senior Manager, Business Analytics And Reporting
    Bmo
    Markham, On, Ca
  • Bmo Financial Group
    Reporting Manager - Channel Analytics
    Bmo Financial Group Mar 2021 - Present
    Toronto, Ontario, Canada
  • Bmo Financial Group
    Senior Analyst, Salesforce Analytics & Optimization
    Bmo Financial Group Jul 2017 - Mar 2021
    Toronto, Canada Area
    • Design, build and execute various scorecard performance reports for different line of business for ad-hoc use purposes• Provide various of Spotfire/Power BI reports to senior executives based on business needs• Create automated and ad-hoc reports to analyze front-line performance and provide insights for senior executives• Process improvement – identify opportunity to automate weekly/monthly scorecard performance reports• Provide support and analysis for North America Customer Contact Centre (NACCC)• Co-ordinate with business and other departments to provide support on urgent ad-hoc requests
  • Bmo Financial Group
    Campaign Analyst
    Bmo Financial Group Jul 2016 - Jul 2017
    Toronto, Canada Area
    • Design, build and execute various marketing campaigns to generate customers’ lists for different channels such as email, direct mail, online banking messages/banners and optimizer calls• Working closely with Leads Management team and marketing partners to develop and execute campaigns end to end• Process improvement – identify opportunity to automate monthly/weekly campaigns and improve efficiency• Solid data analysis – Analyze customers’ data to provide insights for opportunities within campaigns• Create automated and ad-hoc reports to analyze campaign performance and gain insights• Using combination of SQL/SAS and IBM Unica to develop campaigns
  • Government Of Ontario, Ministry Of Community And Social Services
    Policy Analyst
    Government Of Ontario, Ministry Of Community And Social Services Apr 2014 - Jan 2016
    Toronto
    • Led research on adults waiting for developmental services supports and collects information from 9 DSOs to analyze unduplicated count of residential waitlist and residential in-service status. Prepared monthly/quarterly/annually residential waitlist report using SQL/SAS queries • Provided support for Developmental Services Labor Funding Project; played a key role in over 30 million investment on front line workers’ salary increase; organized database with MS Access and VBA programming • Completed Developmental Services Consolidated Information System (DSCIS) Client Profile Report on caseloads, assessment wait time and demographic information; provided support on DSCIS profile report. Conducted regression analysis with database to predict any future changes• Provided expertise on Ontario Passport Funding Client-Level Report; collected client level information from 11 passport agencies• Co-ordinate with other ministries and MCSS branches to provide support on ad-hoc requests
  • Bell Mobility
    Associate - Market Analyst
    Bell Mobility Aug 2013 - Apr 2014
    Mississauga, Ontario
    • Conducted market research analysis to support quantitative data analysis and answer business questions from executives• Completed monthly/quarterly market analysis presentation of retail flyers from major national retailers, highlighting major telecommunication products, plans and prices. Applied data management to MS SQL and MS Access database • Performed market segmentation analysis to understand the behavior and lifestyle for various target markets• Utilized superior knowledge about a wide range of customer data in ad-hoc demographic and segmentation profiling• Participated field researches in order to collect primary data from different source, and increase the first-hand exposure to data collection process • Collection of multiple advertisements and flyers for market segment analysis
  • York University
    Teaching Assistant
    York University Sep 2012 - May 2013
    Toronto, Ontario
    • Demonstrated exceptional attention to detail by accurately grading student essays and examinations• Communicated effectively with professors to obtain goals and requirements of the course; provided students with accurate information on advanced level economics courses• Held weekly discussions with students on course material

Robert Liu Skills

Economics Stata Gauss Data Analysis Finance Accounting Accounts Payable Quickbooks Econometrics Marketing Research Microsoft Excel Marketing Strategy Managing Database Data Mining Microsoft Sql Server Teamwork Analysis Research Market Research Sas Microsoft Office

Robert Liu Education Details

Frequently Asked Questions about Robert Liu

What company does Robert Liu work for?

Robert Liu works for Bmo

What is Robert Liu's role at the current company?

Robert Liu's current role is Senior Manager, Business Analytics and Reporting.

What is Robert Liu's email address?

Robert Liu's email address is ro****@****live.ca

What schools did Robert Liu attend?

Robert Liu attended York University, The University Of Western Ontario.

What skills is Robert Liu known for?

Robert Liu has skills like Economics, Stata, Gauss, Data Analysis, Finance, Accounting, Accounts Payable, Quickbooks, Econometrics, Marketing Research, Microsoft Excel, Marketing Strategy.

Who are Robert Liu's colleagues?

Robert Liu's colleagues are Shanaz Dain, Pouria Malekzadeh, Ting-Yu Chou, Emmanuel (Noel) Cristobal, Urmi Munshi, David Kirkwood, Xiaoyue Wang.

Not the Robert Liu you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.