Sign in

Data Analyst Marketing

South Hadley, MA
May 16, 2020

Contact this candidate


Di Guo

+1-413-***-****;; ** College St., Mount Holyoke College, South Hadley, MA 01075 EDUCATION

Mount Holyoke College South Hadley, MA

Bachelors of Arts Major: Mathematics; Minor: Computer Science, International Relations Sep 2017 – May 2021

• GPA: 3.77/4.00 Major GPA: 3.85/4.00 Standard Test Scores: SAT2 Math: 800/800; Physics: 800/800; Chemistry: 800/800 Recognition and Invitational Events:

• Selected as 2019 Forbes Under 30 Scholar (1000 scholars globally) and awarded to attend annual Forbes conference Sep 2019

• Awarded $250 to participate at 2019 Harvard Peek Weekend Program to represent Mount Holyoke College Jul 2019

• Attended as a speaker at the Women in Mathematics in New England (WIMIN) conference at Smith College Sep 2018 PROFESSIONAL EXPERIENCE

180 Degrees Consulting (world's largest consultancy for social enterprises operating in 35+ countries) Massachusetts, US Consulting Director & Co-Founder of the MHC Chapter Sep 2018 – Present

• Established the MHC Chapter, built the operating models, recruited and trained a team of seven student consultants, reached out 10+ potential business clients, and successfully contracted three clients from different industries

• Conduct an economic impact analysis for a $7 million construction project of a non-profit organization, analyze massive data from federal, state, and local sources, and summariz a five-page report that helps the client gain future investment MassMutual (Fortune 100 company) Connecticut, US

Internal Consulting Intern, Client Management Engaging Department Jun 2019 – Aug 2019

• Launched a business expansion proposal to analyze past efforts, evaluate the current situation, identify key stakeholders, restructure marketing strategies, and provide a plan to solve the inefficient marketing bottleneck

• Present stage findings in meetings with McKinsey consultants, Marketing Advisor, Client Management Engaging and Virtual Education teams to collaboratively design new marketing strategies and yield a highly integrated and actionable proposal Data Analyst Intern, Pricing Department

• Analyzed over 140,000 entries of financial data gathered from multiple databases, built excel models of 50 spreadsheets, and calculated 1,600 contract lapse rates to inform future pricing models

• Compared over 4,000 contract lapse rates, built dynamic financial models, conducted scenario analysis, discussed insights with professionals from different department, and provided business suggestions on improving retention rate The Illuminera Consulting Group Shanghai, China

Strategy Consulting Intern, Healthcare Division May 2018 – Aug 2018

• Supported a Launch Tracking Study in product pricing, portfolio strategy formulation, market opportunity assessment; performed policy research, industry investigation, competitor analysis, and market segmentation studies with senior analyst

• Travelled to Beijing, Wuhan, and Hangzhou to interview 10+ industry key opinion leaders (KOL), summarized interview minutes, and compiled 10+ pages qualitative summary report to support the design of quantitative research questionnaire

• Participated in three different pharmaceutical strategy consulting projects, including product launch tracking study, market assessment & forecasting model study, and pricing strategy study to understand relevant analysis methodologies LEADERSHIP International Student EXPERIENCE Organizing AND Committee PROJECTS (ISOC) Massachusetts, US Co-Chair Jan 2018 – Jan 2020

• Led a team of 15 members to organize the Global Cultural Festival to manage four subcommittees, coordinate with 10+ student organizations and 5+ school departments; obtained $4,500 funding and attracted 300+ participants

• Held meetings with the Director of International Students and served as the representative for international students in meetings with the President of MHC and the MHC Board of Trustees to ensure international student’s needs were heard

• Facilitated bi-weekly ISOC meetings to ensure the smooth operation of ISOC events, including bi-weekly newsletter, monthly Citi Bank dialogue, international student orientation, and annual journal publication to enrich international students’ lives New York, US Markets and Securities Services – Quantitative Analysis, CitiBank Early ID Program Jun 2019 – Aug 2019

• Selected as one of 600 participants from thousands of applicants globally to participate in a five-week virtual mentorship program at CitiBank on the markets and securities track for quantitative analysis

• Enhanced the understanding of equity and bond through training and meetings with the mentor INTERESTS & SKILLS

• Language: English; Chinese

• Computer: Microsoft PowerPoint; Excel: PivotTable, VLOOKUP; LaTex; Java (intermediate); Python (basic); R (basic)

• Interests: Skiing; Singing (certificated singer in China); Badminton

Contact this candidate