Data analysis, Business, Supply Chain/Logistic, Risk

Qiqi Lin

**** ********** ******, *** #* • Berkeley, CA 94703 • *********@*****.*** • 510-***-****

SUMMARY OF QUALIFICATIONS

• Professional experience as Associate Consultant in well-established consulting firm

• Mathematical modeler, team player, fast learner, logical thinker with high technical proficiency and accuracy

EDUCATION

University of California, Berkeley May 2014

Master of Engineering, Industrial Engineering and Operations Research (GPA: 3.64)

Main Coursework: Risk Management & Finance, Data Analysis, Supply Chain Planning, Statistical Finance, Production Planning, Logistics Models, Simulation & Modeling

Sun Yat-sen University, Guangdong, China June 2013

Bachelor of Science in Mathematics & Applied Mathematics (GPA: 3.8)

Honors: 2010, 2011, 2012 SYSU Merit-based Scholarships

Main Coursework: Linear Algebra, Probability, Calculus, Algorithm, Mathematical Software

RELEVANT EXPERIENCE

Associate Consultant, Webster Pacific LLC, San Francisco, CA 06/2014-05/2015

• Assisted clients with market assessment and new market selection. Analyzed neighborhood/block group demographic data, calculated density, supply & demand, average income etc. using complex Excel formulas.

• Provided clients with valuable advice about specific site location. Upgraded road networks of proposed US cities; analyzed catchment rings, transportation distance/time using advanced tools in ArcGIS.

• Evaluated attrition data to help clients reduce customer attrition and improve revenue. Visualized the answer by a combination of color-coded heat maps, tables, scatter plots and bar charts in Excel and Tableau.

• Optimized communication of results through FileMaker database. Wrote scripts and formulas to create FileMaker reports.

• Helped clients identify their competitors. Researched and collected web-based data; structured and analyzed the data using Macro and VBA.

• Helped clients identify target consumers. Conducted research on household/personal income, real estate, tax rate, mortgage rate, cost of living etc. in various US and international markets.

Simulated Investment Fund and Technology Blindside Strategy 09/2013-05/2014 Achieved 150% average annual return by using Google trend data to forecast the future price of specific ETFs and created investment strategy based upon it. Built a user-oriented program using R to help customers make wise investment decisions.

Managerial Trainee, Industrial and Commercial Bank of China 07/2012-08/2012 Forecasted stock trend by doing auto-regression using R/SAS. Analyzed financial statement data. Developed on-going investment projects. Built business relationships with potential clients.

LEADERSHIP

Leader of Sun Yat-sen University Orchestra Performance 09/2009-06/2012 Leader, organizer and performer of piano competitions and orchestra performances, technical assistance of piano performing for SYSU Orchestra

SKILLS & CERTIFICATE

Programming & Modeling: R,SQL, Excel VBA, FileMaker, ArcGIS, Tableau, JAVA, MATLAB, MATHEMATICA

Certificate & Test: SOA Exam P and Exam FM; GRE Verbal 158(23rd %ile), Quantitative 170(1st %ile)

Language: Fluent in Mandarin, conversational Cantonese

ADDITIONAL HONORS & ACHIEVEMENTS

Completed Berkeley Half Marathon 11/2013

Won the first prize of Piano Competition in Shantou Area in Guangdong, China 10/2008

Escort Runner of 2008 Beijing Olympic Games 05/2008

Contact this candidate