Professional Experience Project

RYAN RUAN

#**-**** ******** ******, *******, BC, V5H 0E6 778-***-****

****.**.****@*****.*** https://www.linkedin.com/in/ryan-hd-ruan/

PROFILE

Master of Management in Operations Research graduate with strong analytical, data mining and modeling, management, business operations, communication, and computer skills. Ability to work effectively in both individual and team oriented environments.

KEY SKILLS

Computer Skills: MS Office Suite including advanced Excel skills and VBA programming

Data Analytics: Simulation programming with Arena; Supply and Demand Forecasting with R; Optimization with Excel and GAMS; Data mining with R and MS SQL; Database Query with MS SQL and Access

Business Intelligence: Tableau and Rapidminer

Communication: Fluent in English, Mandarin, and Cantonese

Business Analysis: SDLC methodologies, Business Process Model and Notation, Business Process Mapping

Programming Language: HTML, Python, MS SQL, R

EDUCATION

Master of Management in Operations Research Sep 2015 – Dec 2016

University of British Columbia (Sauder School of Business), Vancouver, BC

Worked with Fraser Health on a workforce management planning project – further enhanced advanced Excel, VBA, database design skills and mastered forecasting methodologies.

Mastered strong analytical skills including forecasting, optimization, regression, simulation.

Utilized consulting techniques and practices.

Completed a simulation project on analyzing the queueing problem of the C18 UBC shuttle bus.

Bachelor of Science

(Honours Program in Economics with Finance Option) Jan 2011 – Jun 2013

University of Victoria, Victoria, BC

Rising Starts 2012 – in recognition of outstanding scholarly achievements.

President’s Scholarship – Scholarship awarded to students who achieved excellent academic accomplishment.

Excellent quantitative research background – Honours thesis: “Impact of U.S. Quantitative Easing Policy on Chinese Inflation – A Vector Autoregression Analysis”

PROFESSIONAL EXPERIENCE

Operations Analyst Apr 2016 Nov 2016

Centre for Operations Excellence, UBC, Canada

Performed conceptual analysis and developed a model framework for workforce capacity planning.

Interviewed subject matter experts to collect data of the workforce capacity planning model and collaborated with the experts to analyze the data.

Designed and built an Excel-based tool to assist Fraser Health for better decision in staff capacity planning.

Planned and scheduled project timelines and milestones and contributed in completing the project within time.

Assistant Manager Oct 2013 – Jul 2015

Intertran Holdings Ltd., Richmond, BC, Canada

Assisted in the day-to-day operations to coordinate the loading and transportation of BC lumber to the ultimate export destination in the most efficient, cost-effective and timely manner.

Managed scheduling, order processing, inventory storage, warehousing control and security; supervised the loading of lumber for export.

Monitored the tracking of lumber in transit to ensure that shipping schedules were met in a timely fashion.

Communicated with customers and all personnel within the supply chain on a regular basis, and responded to their needs to improve services and ensure efficient operations.

Analyzed and evaluated transportation methods to implement systems that attained the most efficient and cost-effective ways for storage, packaging, loading and transportation of lumber.

Research Assistant May 2012 – Aug 2012

University of Victoria, Victoria, BC

Data mining - dealt with numerous business plans of various B.C. companies, transferring the original company structures and business information into quantitative values for economic analysis.

Enhance research skills by using various databases to locate the most updated information and status about different B.C. companies.

Developed strong critical thinking skills to solve difficult coding problems.

Worked in a fast-paced team environment and completed daily quotas promptly.

Observed strict protocols for confidentiality and to safeguard research materials.

Contact this candidate