Jacey Wang

Canada

@jaceywangwork

Data Analysis/Business Intelligence/Data Management Expert

Badges

Python

Certifications

Work Experience

  • SENIOR STARTEGY CONSULTANT

    OpenText Corporation•  January 2019 - Present

    ● Provided advance analytics, insights and reports to Regional Managers and Vice Presidents, helped with understanding the opportunity of business growth and planning the future quarterly strategic direction ● Transformed existing reports to new visualized and interactive dashboard for business users, developed clear KPI and metrics for better decision making from leadership team, and automated over 95% existing reports and manual processes ● Partnered with different key stakeholders gathering their requirements and implementing the business / technical solution ● Conducted regular, on-going evaluation of current processes and provided guidance and recommendations to enhance the team’s overall performance ● Provided training and knowledge sharing session with Regional renewal managers/reps and operation team Corporate Projects: automation billing, customer outreach, data flow& reporting automation, C360 customer projects Achievements: Employee Recognition at OpenText in 2019/2020/2021 each year

  • DATA ANALYST

    PointClickCare•  September 2017 - September 2018

    ● Analyzed business needs and met requirements with accurate and analytical reports by supporting Business development, Sales and Customer Success Team ● Designed dashboard and improved business reports in BI application, helped with finding the key drivers of business development ● Prepared the forecasting revenue by running prediction model based on sales pipelines ● Designed and developed CPQ (Configuration, Price, Quote) tools for Sales and Implementation team to improve business revenue and generate deals easier Corporate Projects: HR Pulse, Ability Partner Integration, Market Timelines Project

  • DATA SPECIALIST

    DHL EXPRESS•  January 2017 - April 2017

    ● Accomplished ETL process of 3000 clients account information into the BQM system, developed quality control processes including monitoring data quality and finding root cause ● Collected over 1000 clients’ geographic information, implemented into SAP and other business systems, and guaranteed customers receive billings on time ● Generated the aggregation report for dummy accounts, designed chart analysis and prepared presentation deck in the Global meeting ● Handled objections from customers to explain patiently about the information collection purpose and interpret the project disclosure and scope Corporate Projects: BQM, automation invoicing process Project

  • ANALYST

    BMO•  January 2015 - June 2016

    ● Managed 400,000 wealth management client accounts with operational support on transactional and performance data, provided fund performance methodology, insights, and reports to the investment counselors ● Designed more than 10 automated reports (wrote VBA and SQL code, established relational database) to improve data accuracy, corrected code of existing reports to improve the efficiency ● Designed, developed, and implemented business process solution to improved teamwork efficiency through identifying on issue and lag of regular base work ● Worked with technology initiatives team and business team in multiple projects on systems developments, finance regulation changes and data transformation Corporate Projects: systems developments, finance regulation changes and data transformation projects

  • PERFORMANCE MEASUREMENT ADMINISTRATOR

    BNY Mellon•  June 2014 - November 2014

    ● Created and supported reporting and operational management established the consistent process of monthly and quarterly reporting ● Identified the anomalies and discrepancies by analyzing the historical performances trends, and developed the solution and delivered to clients with their investment portfolio performance returns ● Participated into the database system transitional project, assisted with data transformation and data mapping process from old system to new system Corporate Projects: database system transitional and data transformation projects

  • ANALYST

    SHINY STAR CANADA LTD•  September 2013 - February 2014

    ● Built the inventory database and designed the reporting template based on the business needs ● Liaised sales representatives about products information and prices, customers about Canada food tax clarifications and communicated logistic companies about oversea delivering time and tracking records.

Education

  • University of Waterloo, Waterloo

    STATISTICS, BS•  September 2009 - June 2013

Links

jaceywangwork has not updated links details yet.

Skills

jaceywangwork has not updated skills details yet.