Celeste Li Email & Phone Number

New York, Ny, Us

New York, New York, United States

● Analyzed historical engagement data from past event databases, LinkedIn analytics, and Instagram impressions to identify trends and opportunities for outreach optimization● Increased event attendance by 20% through dynamic social media campaigns, including event countdowns, branded content, and targeted messaging● Conducted user interviews and focus groups with students and faculty to better understand audience preferences, iterating branding and marketing strategies based on feedback

New York City Metropolitan Area

● Conducted A/B testing on marketing channels to refine a go-to-market strategy for B2B sales, focusing on Asian restaurant owners via WeChat campaigns, trade shows, and bundled magazine promotions, resulting in a 15% increase in qualified leads● Designed a data-driven product roadmap for a ZIP-code-based restaurant insights tool, incorporating real-time ZIP code validation, intuitive user flows, and interactive data visualizations, boosting user engagement by 25% during beta testing● Led cross-functional collaboration with engineering and marketing teams to enhance restaurant profitability matching feature, using A/B tests on algorithm adjustments and user input analysis, increasing recommendation accuracy by 30%

New York City Metropolitan Area

● Designed and prototyped "Five One Hub", a high-tech mobile application using Figma, to support global networking and collaboration among Five One Labs’ key stakeholders, including entrepreneurs, staff, and prospective members● Conducted user research and incorporated feedback to iterate on app design, ensuring alignment with Five One Labs' objectives of facilitating learning and global expansion● Contributed to Five One Labs' global expansion strategy by leveraging design and communication skills to deliver a scalable digital solution tailored to its community's needs

Chicago, Illinois, United States And And Shanghai, China

● Conducted international market research for L'Oréal’s venture department, using regression and cluster analysis to segment target markets and identify opportunities for product innovation and regional expansion● Designed interactive dashboards in Python and Tableau, visualizing product performance metrics such as market share, revenue growth, and consumer satisfaction, reducing reporting turnaround time by 30%● Provided detailed market-entry recommendations by integrating industry trend analysis, competitive benchmarking, and survey data, directly influencing client product strategies

London Area, United Kingdom And Shanghai, China

● Conceptualized and designed promotional materials used by 30+ media outlets, aligning visual elements with strategic objectives for the China International Import Expo, showcasing proficiency in visual communication and design thinking● Interpreted user behavior and market trends with Python to analyze product launches and social media sentiment, driving a 25% rise in visitor engagement by identifying customer needs and influencing the evolution of consumer products● Cultivated 100+ relationships with key influencers, securing featured interviews and PR initiatives to connect with users● Contributed insights in cross-functional meetings, collaborating on refining product strategies and go-to-market approaches

Shanghai, China

● Analyzed financial statements to extract insights on operational efficiency for informed business strategy decisions, assessing key ratios such as liquidity, profitability, and solvency to provide insights into operational efficiency and financial stability● Utilized SQL for database querying and analysis, extracting relevant data to assess Net Realizable Value (NRV), perform duties segregation, and conduct variance analysis on revenue trends● Translated SQL-derived insights into actionable recommendations, communicating financial performance improvements to stakeholders while developing project management skills

Beijing, China

● Defined and managed short and long-term finance and data model roadmaps for clients, aligning objectives with key results and translating them into actionable requirements to structure investment portfolios● Utilized Pandas and APIs (e.g., Yahoo Finance, Alpha Vantage) to retrieve financial data, manipulate and clean data, and calculate key metrics such as returns, volatility, and Sharpe ratio for historical performance analysis of assets and portfolios● Tracked key quantitative performance indicators (KPIs) for the portfolio, focusing on metrics related to operational efficiency, stock price movements, and relevant business strategy news to provide insights for investors● Integrated valuation models, incorporating Discounted Cash Flow (DCF) analysis and Price-to-Earnings (P/E) ratios

London, England, United Kingdom

● Crafted a robust social media strategy, converted research findings into data-driven marketing proposals, and utilized data visualization to convey key insights, resulting in an 89% increase in conversion rate over six weeks● Launched youth engagement initiatives by creating marketing posters and videos using Adobe Photoshop and Premiere, resulting in a 25% increase in student participation and strengthening Blue Education's position in academic consulting● Operated quantitative competitor analysis to extract insights on market trends, pricing strategies, and areas of differentiation, strategically utilizing this information to enhance product positioning and effectiveness during client interactions● Utilized Python-based data analytics in the Ed Tech sector to optimize consulting strategies, resulting in a 15% increase in client engagement and 20% improvement in tailoring educational recommendations

Guiyang, Guizhou, China

● Implemented data-driven strategies through diverse channels, including bank stations, telemarketing, and referrals, resulting in a significant 25% increase in customer retention and market presence enhancement● Streamlined financial transactions for clients by guiding them in executing trades through electronic platforms, conducting product demonstrations, and staying abreast of market trends to propose enhancements aligning with evolving client needs

Master Of Public Administration - Mpa, International Finance & Data Analytics & Lid (Leadership, Innovation, And Design)

Activities and Societies: President of Women in STEM

Bachelor Of Science - Bs, Management, First Class Honours

Activities and Societies: Teaching Assistant of Strategic ManagementDual Bachelor's Degree Program

Bachelor Of Science - Bs, International Business, 3.9

Activities and Societies: Director of the Design Department in SWUFE Student Experimental Advertising Agency; Head of the China Household.