Lin Dong

Unit ***, *** University Ave W, Waterloo, ON, N2L 3E2

(519)-781- 2099, acqw88@r.postjobfree.com

SUMMARY OF QUALIFICATIONS

• Completed P, FM and MLC for Society of Actuaries with scores of 9, 8 and 10 accordingly

• Proficient in Microsoft Office Suite with working experience in VBA, SQL automation for Excel and Access

• 4GL programming language skills gained through working at Ontario Ministry of Finance

• Advanced skills in R and Python programing obtained from academic studies and projects

• Possess solid knowledge of derivative market, reserves, pensions and statistical models

• Exceptional team work and problem solving skills with ability to work under pressure and tight deadlines WORK EXPERIENCE

Junior Financial Analyst - Health & Benefits Plan, Reformulary Group Inc., Toronto, Canada January 2015 – April 2015

• Assisted in modeling of drug plan design data using Excel

• Performed statistical analysis to interpret trends, correlations using R and Excel

• Provided analytical support for contract negotiations, and business development activities Jr. Financial Analyst, DBRS, Toronto, Canada May 2014 – August 2014

• Collected company financial statements of the US utilities, oil and gas industries

• Performed analysis on the financial ratios, risk exposures and generated report using MS Excel and Word

• Captured and documented equity and fixed income securities information using Bloomberg for Compliance project

• Updated Commercial Mortgage Backed Security files from downloaded Bloomberg extracts Quantitative Analyst Assistant, Everbright Securities Co., LTD, Shanghai, China May 2013 – December 2013

• Conducted data analysis using Excel formulas and pivots; fitted statistical models using R

• Completed research on linkages and causal relationships between various financial indicators and the stock performance

• Analyzed and summarized company’s annual reports of the insurance industry

• Researched on the new solvency standards for Europe, China and America as well as assets management for Chinese Insurance company

Special Projects Co-ordinator, University of Waterloo, Waterloo, Canada September 2012 – December 2012

• Completed research projects including average salaries and 8-month engineering pilot jobs

• Held bi-weekly meetings with the management of Student Faculty Relations to present progress on projects

• Gathered resources and complied Engineering and Math Co-operative Accreditation Binders

• Contributed to multiple projects and met all demanding deadlines with high quality of work Database Programmer, Ontario Ministry of Finance, Toronto, Canada January 2012 – April 2012

• Updated FAME database with labour force data, housing statistics and quarterly current accounts data feeds

• Automated Excel based desktop solutions using VBA which increased operating efficiency significantly

• Developed database program and a hundred series for the Labour Force Survey project for Ministry of Training and Colleges and Universities

EDUCATION

Candidate for Bachelor of Mathematics, University of Waterloo, Waterloo, ON September 2010 - present 4A Actuarial Science (Finance option) and Statistics Double Major Project: Utah Pension System, November 2013 – December 2013

• Collected data from Comprehensive annual financial report and related Actuarial report

• Analyzed on the data collection, calculated the actuarial accrued liabilities and recommended some policy alternations AWARDS

• Term Dean's Honours List, 2014 and 2010

• Certificate of Retirement and Pensions online course by Stanford University, 2013

• Certificate of Distinction of Euclid Mathematics Contest (top 25% of the all contestants overall average of 84%), 2010

• Certificate of Distinction of Sir Isaac Newton Exam (finishing in the top 7% of all contestants), 2010

• Certificate of Distinction of Sun Life Financial Canadian Open Mathematics Challenge (top 25% of all contestants), 2009

• University of Waterloo President’s Scholarship and Rene Descartes Scholarship, 2010-2011

Contact this candidate