Jun Yang Email & Phone Number

Edmonton, Ab, Ca

Edmonton, Ab, Ca

• Lead testing and refinement for Alberta’s economic activity index and price of labour models• Lead processing and regular reporting for Alberta’s personal income tax data• Lead literature review and dashboard development for Alberta’s infrastructure investment• Solve issues and participate in User Acceptance Testing (UAT) for the Fiscal Activity Tracking system (FATS)

Edmonton, Ab

. Led multiple projects on transportation economic analysis. Supervised staff in conducting literature review on transportation economics and modelling, including cost-benefit models, input output models and general equilibrium models. Oversaw the research, compilation, analysis, interpretation, and preparation of transportation economic data . Built spatial economic models including economic growth, travel demand and land use planning, to evaluate both macro and micro economic impacts of transportation investments/improvements. Developed presentations and project reports for senior decision-makers

Edmonton, Ab.

. Conducted queries and performed statistical analysis over the long-term care and home care data from the Alberta Continuing Care Information System (ACCIS), by SAS (Classic/Enterprise Guide). Validated data about residential profiles and quality indicators from client/resident assessments (more than 50 million observations). Automated the reporting procedure for ACCIS long-term care and home-care data submissions . Developed monthly and quarterly data reports for internal and external partners

Edmonton, Ab.

. Taught 41 students in the course “Introductory Macroeconomics". Designed course syllabus, teaching PowerPoint slides, quizzes, term and final exams. Supervised and marked exams and quizzes, compiled students’ grades. Applied real world examples to facilitate students’ understanding, actively sought feedback fromstudents

. Updated financial models based on the Bank’s balance sheets, income statements and cash flow statements; performed stress testing for market risk, operational risk, credit risk and concentration risk . Modeled agricultural credit card and agricultural finance products sales by R, forecasted market penetration rates in different regions. Conducted market campaign analysis and evaluated effectiveness of campaign strategies . Developed Excel/VBA codes to automate credit risk tracking

. Maintained and updated a database about Canadian household food consumption (panel data with more than 4 million observations) by Excel and SPSS. Simulated an Excel-based financial model for a large Alberta farm with crop and livestock operations . Predicted discounted cash flows of the farm in a 20-year period under different beneficial management practice scenarios by Palisade @risk . Completed three project reports and one working paper, presented results to internal and external clients

Edmonton, Ab.

. Summarized literature about impacts of mad cow disease on consumers, producers and beef industry, risk perceptions and Bayesian econometrics. Designed a household survey for the ACNielsen HomeScan(TM) panel in Canada and a farm survey . Managed two large databases by SAS and SPSS, extracted data for internal and external stakeholders . Constructed statistical models by TSP, SAS and Stata; forecasted Canadian household meat consumption, cattle supplies and the North American beef sector under mad cow disease impacts . Completed one project report and five journal articles, presented 10 papers in Canadian and US conferences

. Collected time series data from Statistics Canada; performed data verification, validation and description . Modelled productivity growth in the Canadian logging and wood pulp operations by Limdep and Stata . Finished three project reports and one journal article, explained results to the project leader