TIM YE

Toronto, Ontario, CANADA 416-***-**** adg68o@r.postjobfree.com

PROFESSIONAL PROFILE

• Over 3 years of leadership skill, with relevant experience in team leading, team building and team management

• Clear understanding of Data pipeline, Statistics, Cloud Service(SAAS/PAAS), ETL and Business Reporting/ Dashboard

• Experience with ETL large databases using SSMS, NoSQL(MongoDB/Cosmos DB), Amazon web services (AWS), Microsoft Azure. Focusing on Microsoft Azure DevOPs and Azure BI Stack (ADFv2, Azure SQL DB, Azure SQL Data warehouse, Azure Data Lake, Azure Databricks, analysis services). As well as statistical analytical tools including Python, R, SSAS and SAS.

• Strong CRM and ERP techniques, including salesforce (front and dev), financial force, Microsoft dynamic 365, NetSuite, SAP ERP

• Hands on experience with Business Intelligence tools such as Tableau, Power BI, SSRS, Qlik, and SAP Analytic Cloud EDUCATION

Bachelor of Science, Applied Statistics, University of Toronto June 2018 Honors: Entrance Scholarship at University of Toronto, 2013 Leadership: CPA Ontario Manager of Business Intelligence (May 2019 – Present), Team lead of Easy Career Consulting

(July 2018 – May 2019)

WORK EXPERIENCE

Business Intelligence Manager (Client Insights) –CPA Ontario May 2019- Present

• Responsible for data migration, UAT, reporting for PDx project, website live agent project, and including extracting Restful API on PowerShell, ETL from OLTP to OLAP; Performed KNN (K-nearest neighbor) and K-mean clustering on Microsoft Azure Cloud with census information from Stats Canada on marketing segmentation project.

• Gained strong experience on Power BI, including coding power query, DAX, building data models, setting data gateway and making visualization, and extracted business insights on analyzing CSC operational data and marketing data.

• Directly reported to vice president, using Power BI Service and SSMS to extract data and applied to statistics software R to build machine learning models, and essentially presented using Power BI service. Applied Powrer BI APIs .NET SDK v3 on self-serve reporting (PAAS).

• Built and used data pipeline on Microsoft azure cloud platform, including data bricks, azure data factory and data lake, with ETL data from google analytic, salesforce, and on premise data, designed data pipeline on Azure logic apps

• Interpreted bi-weekly presentation to the director and VP, generated monthly reports, investigated marketing and operational trends, SWOT analysis and focused on KPIs

• Applied Erlang C Model on call center to optimize the number of agents required on multiple channels, including calls, emails and live chats, saved up to 12% on CSC labor cost Data Analyst -Project Lead, Easy Career Consulting Jun 2018 – May 2019

• Led a team of 4 members, tasked with improving the company’s revenue through analysis of customer data, conducted analysis of company database using SQL and R to summarize and model data; insights found through analysis to minimize marketing budget and efforts from one online platform to a more effective one, increased revenue by 8%

• Discovered opportunity to assess course appeal to different types of students based on broad categories of characteristics; after performing segmentation of customers, visualized the analyses in Tableau dashboards, and graphical representations of insights; provided deep insights for future company initiatives in growth

• Utilized python to gather data using the site’s API key, improving the company’s access to a large dataset that had previously not been at its disposal; deeper website analysis resulted in optimization of some webpages, increasing conversion rate of visitors and improving average time spent on the site by 10% Data Analyst, Canadian Cancer Analysis - Scarborough General Hospital Sep 2017- May 2018

• Tasked on Canadian Cancer Project Analysis at Scarborough General Hospital, used SQL to extract data and applied statistics software R to build machine learning models, assisted team find an efficient way to help patients

• Built several Machine Learning models, including Poisson, Logistics and Binomial, efficiently provided many useful suggestions to doctors and assisted them to make medical and pharmacies’ strategies

• Interpreted statistical results to the doctor weekly, and wrote a final report, investigated trends in cancer surveillance – incidence, mortality, prevalence, net survival rate, potentially reduced the incidence rate by 0.8% in a year RELEVANT EXPERIENCE

Founder, TurnUp IOS App May 2015 – Jun 2016

• Entrepreneur in the business-to-customer field, designed and founded an IOS app to serve nightclub market in Asia

• Created, lead the team and launched to IOS China app store and achieved 10000 downloads in one month