Rylan (Chenxi) Li

617-***-**** adbsmj@r.postjobfree.com https://www.linkedin.com/in/rylanli/

EDUCATION

Boston University Sep 2018 – Jan 2020

• M.S. in Applied Business Analytics, with Enterprise Risk Management Certificate GPA: 3.52/4.0 Heilongjiang University Sep 2013 – Jun 2017

• B.A. in Finance Management GPA: 3.10/4.0

PROFESSIONAL EXPERIENCE

Data Analyst Intern Oct 2019 – Feb 2020

BLDUP, Inc Boston, MA

• Increased 1,000+ projects listings automatically on BLDUP website by scraping construction data from public websites, conducted data cleansing and standardization

• Simplified working processes on data editing and updating by Excel, collected and synthesized business data as required

• Analyzed projects data by using statistical models in R, generated strategic marketing recommendations based on data visualization to enhance users’ experiences Business Analyst Intern May 2019 – Oct 2019

Chuanda Food Process Solution Remote

• Reduced labor hours on data extraction by developing relational database (My SQL), created 47 tables based on locations and products, conducted data manipulation and normalization

• Analyzed 4 years sales data, provided business strategies to decrease costs and presented to senior managers

• Created marketing campaigns monthly in Mailchimp and increased open rate by 12%

• Acquired 3 clients and 2 partners on Chicago workshop, increased annual sales by 9% Business Analyst Intern Jul 2019 – Sep 2019

Hyde Park Investment Services, Inc Boston, MA

• Created Business Intelligence dashboards based on KPIs (revenue, debt, operating expenses, EBITDA), presented findings (trends, risks, overvalued/undervalued) to team members

• Gathered stocks data from primary and secondary sources, generated equity research weekly, presented reports to senior management on team meeting

• Provided ad-hoc data analysis (classification, prediction) in response to requests from the management team and product team

Company Founder - Founded a company which provides educational consultations Sep 2015 – Mar 2018 Chenbei Culture Co. Ltd Beijing, China

• Found education consulting firm with online and offline platform to help high school graduates/senior candidates to choose majors and learn new skills

• Cooperated with city's volunteer association and 12 student’s associations to hold monthly networking information sessions and events in different universities PROJECTS

Airbnb Data Analysis Sep 2019 – Jan 2020

• Worked with 30,000+ data, conducted data manipulation and visualization

• Performed machine learning models (K-means, regression, K-nearest neighbors) to analyze business findings Canada Goose Marketing Analysis Jan 2019 – May 2019

• Investigated Canada Goose’s business model, competitors and retail industry globally by creating surveys

(market research survey & customer preferences survey) to form hypothesis

• Tested hypothesis by analytical models (SWOT, 5 Porters, PESTEL, Conjoint Analysis, Perceptual maps) LANGUAGE & SKILLS

Technical Skills: Python, SQL, R, Tableau, Power BI, Google Analytics, MS Office Languages: English; Mandarin

Interests: Guitar Player (Lili Band), Song Writer, Singer (Top 100 in China 2016 Super Girl TV Show)

Contact this candidate