Post Job Free

Resume

Sign in

Analytics Intern Associate Consultant

Location:
Chicago, IL
Posted:
January 19, 2023

Contact this candidate

Resume:

Wanyue Deng

Chicago, IL 614-***-**** adusfg@r.postjobfree.com

EDUCATION

Cornell University, SC Johnson School of Business Ithaca, NY Master of Professional Studies in Management, (STEM) Dec. 2022

• Associate Consultant, Cornell Graduate Consulting Club

• Vocal (Soprano), REAL A Cappella

Ohio State University Columbus, OH

Bachelor’s Degree in Arts, Strategic Communication, Business minor May 2021

• Cum Laude, Dean’s List

• Vice President, Oriental Dance Troupe

WORK EXPERIENCES

MERIDIAN CAPITAL (venture capital firm in TMT industry) Beijing, China Portfolio Management and Investor Relations Intern May 2021 - Jul. 2021

• Published 20+ success stories on company’s social media account to update investment growth of portfolio companies

• Established an interactive tableau dashboard to monitor performance metrics by analyzing engagement metrics such as pageviews, resulting in a 30% increase in pageviews per article, and made one article hit 3500+ viewers in 2 days

• Supported launch of a governmental ceremony of Small and Medium sized Enterprises (SME) Development Fund aimed at collaborating and attracting potential new investors; interviewed 15+ CEOs to understand their financing needs and identify opportunities to streamline and improve the investment process

• Researched, collected, and assessed portfolio companies’ financial data including development history, competitors, trend and entry analysis; built industry reports and presented funding strategies to management levels

• Reviewed financial statements of 10 target companies, assessed value of their investments, appraised progress of fund investment, recalculated cash flows and performance to ensure proper compliance DIDI CHUXING TECHNOLOGY CO. (biggest ride-sharing firm in China) Beijing, China Marketing Research and Analytics Intern Jul. 2020 - Sept. 2020

• Examined technology products and cases from 10+ ride-sharing competitors like Uber, and presented findings of their marketing methodologies on internal meetings

• Conducted market and customer research to identify client needs, and developed partnership strategies and media relations tactics to broaden users base

• Brainstormed advertising, new media and onsite marketing tactics; developed and pitched co-branding marketing plan and creative promotional plan to fulfil KPI and daily active user indicators

• Created briefs and interacted with product team to design and implement DiDi’s navigation application system ACADEMIC PROJECTS

DataVisualizationIndividualProject,Cornell University Jan. 2022 - Mar. 2022

• Researched, extracted and filtered data such as registering property scores by region to performed year-over-year analysis

• Utilized advanced inter-visualization charts, such as tree maps and bubble charts, to develop dynamic interactive tableau stories and dashboards that recommended the best location to start a business Go-To-Market Consulting Project in Healthcare, Cornell University Aug. 2021 - Oct. 2021

• Developed a recommendation for a medical devices company that sells ePCR systems (Electronic Patient Care Reporting) to EMS agencies which aimed to achieve business expansion and increase profits

• Conducted primary interviews with client executives and local clinics, analyzed EMS survey database, understood product life cycles, evaluated and mitigated risks in business processes, developed actionable strategies and recommended that firm focus on high revenue generating segments such as urban market and small-sized agencies to maximize firm value Operation Consulting Project in Hospitality, Cornell University Aug. 2022 - Dec. 2022

• Conducted primary interviews with restaurant owners to identify project’s goal and scope, defined cooking and operation process flow, assessed the utilization of current resources, and developed a road-map to optimize operation

• Created financial models to forecast and analyze weekly capacity of a restaurant, leveraged investment analysis; proposed and compared 4 development options, and suggested that restaurant should upgrade lentil and packing machines to improve operation efficiency while maximizing profits

• Designed an efficient on-campus batch delivery plan for restaurant by conducting primary research with students about delivery locations and preferences as well as analyzing foot-traffic trend records on AlphaMap LEADERSHIP

Lead of Sponsorship Department, Chinese Student and Scholar Society (CSSS) Sept. 2017 - May 2019

• Successfully negotiated partnership with restaurants to provide 20% dining discount for OSU students and obtained a $500 sponsorship to promote restaurant within CSSS networks SKILLS

Software: Proficient in Tableau, Excel, PowerPoint; Intermediate in SQL, Python and Alteryx Certificate: IBM Databases and SQL for Data Science with Python Language: Fluent inMandarin



Contact this candidate