Melanie Yang Email & Phone Number

Toronto, Ontario, Canada

• Engage and build effective partnership with various functional groups in the organization (such as Social Response team, People and Culture division) by providing performance data and insights through enhanced measurement, analysis, testing and reporting• Promote positive play and reducing harm for OLG customers to support Responsible Gaming, and ensure players’ health play within their limits and risk level by providing regular reports and enhanced analytics solutions.• Enhance relationships with OLG functional and support teams in terms of addressing their KPI reporting needs and develop dashboards in Power BI where applicable.• Collaborate with the Land Based Gaming team on monitoring and reporting on product performance, customer behavior and validate Service Provider’s business plans in order to provide directional insight and assist with decision making.• Analyze customer behavioral changes and the associated financial impacts that these changes will have on OLG Financial performance• Assist with organizational projects to evaluate the impact of marketing sponsorships, and identify new opportunities to drive financial performance• Develop and maintain automated reporting to improve analytics capabilities• Utilize the Data Lake and different data sources to achieve analytical goals of providing directional insight and improving business confidence

Toronto, Ontario, Canada

- Analyze and query on large sets of data representing digital play behavior to provide insights about user actions that help business partners uncover potential relationships that can be exploited to drive future profitability within the organization. - Present post promotion analysis and provide recommendations to acquisition and retention marketing groups to effectively use corporate resources for more strategic target marketing, improving online playing experience as a result.- Implement operational efficiencies associated with evaluating business performance by developing various dashboards, including visualized Qlik/Power BI dashboards for senior management and marketing team.- Collaborate closely with key stakeholders to understand customer needs and relevant business opportunities, aid Research and Strategy initiatives with their business decision making. - Enable retention-based targeted marketing by developing value-based segments through machine learning algorithms (i.e., k-means clustering); allowing for more effective budgeting allocation. - Prepare weekly, monthly and ad-hoc analytical reports on PlayOLG players’ Casino and Lottery playing metrics, and provide analytical reports implementing budgeting, planning, trend analysis and analytical solutions based on Executive management and Financial needs using analytical tools including Python, R, SQL,VBA, SAS Enterprise Guide and Alteryx. - Design new and automated processes using R and Python that effectively improved the delivery of post campaign analysis by reducing turnaround time, increasing ability on completion of analytical projects.- Monitor all operational data, and take ownership to ensure accuracy, consistency, relevance and timeliness of the information in Data Lake.- Coach and train new team members from various departments to get familiar with data structure and marketing promotional procedures.

Toronto, Ontario, Canada

- Prepared monthly analytical reports on personal and commercial loans, mortgages for Accounting Department using SQL and MS Excel.- Analyzed customers’ financial activities following FINTRAC’s anti-money laundering regulation, provided FINTRAC with monthly suspicious customer reports. - Created batch job to categorize monthly website usage and generate reports for Marketing Department using SQL.- Generated queries and reports using SQL and MS Access for management and outside audit.- Provided technical training and support for Credit Union staff on database usage, desktop applications such as MS Excel spreadsheet and MS Word document preparation.- Designed and maintained all internal and online application forms using Microsoft Office Suite and Adobe Creative Suite.- Prepared company executives' presentation slides for board meetings and annual meetings.- Updated and maintained Credit Union’s website.- Set up workstations, user accounts, e-mail accounts, printers, Ovation and WealthView banking system for Credit Union staff.- Trouble-shoot through teleconferencing and remote desktop connections on PC, printer and banking system problems encountered at branches.- Analyzed inventory and track IT equipment as it moves through its lifecycle.- Conducted interviews with candidates applying for positions at subsidiary Credit Union branches.

College Diploma, Computer Information Systems

Bachelor'S Degree, Genetics And Breeding Of Plants