Bonnie Chan

Bonnie Chan

Systems Engineer

Followers of Bonnie Chan200 followers
location of Bonnie ChanToronto, Ontario, Canada

Connect with Bonnie Chan to Send Message

Connect

Connect with Bonnie Chan to Send Message

Connect
  • Timeline

  • About me

    Senior Data Analyst

  • Education

    • York University

      2000 - 2004
      Bachelor of Arts (B.A.) Specialized Honors in Information Technology

      Bachelor of Arts Specialized Honors of Information Technology (2004)

  • Experience

    • PricewaterhouseCoopers

      Aug 2004 - Jun 2006
      Systems Engineer

      • Provided helpdesk support on Windows XP desktop and applications for internal• Experienced in end-user support for Lotus Notes• Documented knowledge base of How-To’s• Data recovery management

    • PCCW

      Jun 2006 - Feb 2007
      Account Executive – Corporate Mobile Sales

      • Presented to corporate customers on PCCW services and mobile products (include: Blackberry email solution, Location based service, Satellite fleet management system, Mobile broadband on 3G data card, SMS gateway, M-marketing solution, M-ordering solution)• Offered customer customization on Telecommunication solutions• Managed and maintained customer relationship

    • Jardine OneSolution (HK) Limited

      Feb 2007 - Jun 2009

      • Provided consultancy to customers on IT hardware and solutions (security, storage, networking)• Managed and maintained good relationship with customers • Drove IT product business on Cisco, H3C, Symantec, VMware, Trend Micro, CA, EMC• Worked closely with vendors and distributors on growing their business with marketing programs • Coordinated logistics, budget and venue management for events, such as seminars, workshops, exhibitions and channel gatherings.• Developed incentive programs to create momentum in the sales force• Handled salesman inquiries on pricing and product information

      • Account Manager (Commercial Sector)

        Jul 2008 - Jun 2009
      • Assistant Product Manager

        Feb 2007 - Jun 2008
    • Version 2 Limited

      Jul 2009 - Oct 2009
      Channel Manager

      • Responsible for promoting security software to Commercial Market• Developed and explored new channels to achieve the company sales target• Maintained good customers relationship with reseller partners and end users

    • Jardine OneSolution (HK) Limited

      Oct 2009 - Aug 2019

      • Proposed tailored IT solutions to high profile clients, including: RPA, ERP, CRM, PeopleSoft, Oracle Hyperion. • Submit contract variation to the HKSAR government for Standing Offer Agreement PC bulk, Server bulk and Network bulk.• Data visualization of sales data with Power BI: identified key areas for sales figure improvement in management meetings. • Analyzed customer’s environment and needs, propose cost effective IT solution accordingly• Oversaw project progress and coordinated with related working parties to keep the project on track • Worked with customer on requirement gathering and gave recommendations on the tender write-up tender, specifically in the technical requirements and professional requirements.

      • Senior Account Manager

        Apr 2019 - Aug 2019
      • Inside Account Manager (Government Sector)

        Jan 2017 - Mar 2019
      • Senior Account Manager (Government Sector)

        Oct 2009 - Dec 2016
    • HKBN JOS

      Aug 2019 - Feb 2022
      Consultant

      • Worked on various data projects (different clients) on data from financial budgeting systems, video content streaming, CRM, mall footfall analytics, and sales figure management.Business Analyst• Gathered business requirements and design specifications for a new data platform on AWS; enabling clients to self-service ad hoc reports with Business Intelligence tools.• Provided consultation on data storage structures, data preparation/cleansing and ETL processes. • Documented business requirements, functional specifications, and how-to documentations. Data Analyst• Took the lead and managed data initiatives from end to end that included analytics, executive presentation, development and executive pre/post dashboard and reporting requirements.• Ensured data outcomes were as intended: investigated into ETL programs, enforced processes, reported on abnormal data patterns, made feedbacks on program bugs, architected data monitoring programs, and resolved data issues.• Handled data from over 1000 IoT devices: People Counting Cameras, Demographics Cameras, Wifi Logins, and Device Detection devices.• Supported data stakeholders on dashboard report/data enquiries.BI Developer• Gathered and consolidated data requirements with the use of Agile storyboarding.• Created visually-impactful, insightful dashboard solutions for strategic decision making.• Maintained and supported Tableau dashboards and provided bug fixings.• Implemented Power BI dashboards over client’s CRM systems, providing holistic view on member activities: property selling/prospects, customer demographics, loyalty programs, and Mall spending transactions.• Developed new dashboards analyzing Malls’ footfall traffic data from IoT devices. Show less

    • RBC

      Jun 2022 - now
      Senior Data Analyst
  • Licenses & Certifications

    • Certificate of Attainment in Digital Forensics, Audit and Control Management (2009)

      Sun Wah-Pearl Linux Training and Development Centre
      Nov 2009
    • Certified Call Center Professional

      Hong Kong Customer Service Consortium
      Mar 2006
    • Microsoft PowerApps & Flow: Build Business Apps Without Code

      Udemy
      Aug 2019
      View certificate certificate
    • Microsoft Power BI - Up & Running With Power BI Desktop

      Udemy
      Mar 2019
      View certificate certificate
    • Data Science A-Z: Real-Life Data Science Exercises Included

      Udemy
      Nov 2018
      View certificate certificate
    • Automate the Boring Stuff with Python Programming

      Udemy
      May 2018
      View certificate certificate
    • Learn Python GUI with Tkinter: The Complete Guide

      Udemy
      Jun 2018
      View certificate certificate
    • Master Tkinter By Building 5 Fully Functioning Apps

      Udemy
      May 2018
      View certificate certificate
    • Complete Python Bootcamp: Go from zero to hero in Python 3

      Udemy
      Apr 2018
      View certificate certificate
    • ITIL Foundation Certificate in IT Service

      AXELOS Global Best Practice
      Apr 2015