Jiayun Ling Email & Phone Number

Los Angeles, CA, US

Atlanta, Georgia, United States

Durham, North Carolina, United States

• Developed a data-driven strategy that increased LTV (Customer Lifetime Value) by 5% by analyzing payment transaction data from over 100k rows in R.
• Increased conversion rate by 1% by conducting customer retention and duration analysis in Excel to better target customers for sales promotions.
• Created Tableau dashboards that visualized social and economic data, providing valuable demographic insights that informed marketing and sales strategies.

Shanghai, China

• Leveraged Python & SQL to perform trouble-shooting data analysis and dashboard establishment for Porsche Taycan
• Utilized Python to quantify the efficiency of third-party home charging station installers with weekly troubleshooting rate and provided data-driven suggestions to improve customers’ charging satisfaction by 20%.
• Built up XGBoost model to forecast the customer repurchase rate by computing net promoter score(NPS) based on different features such as demographic data and charging experience
• Created data dashboard using Tableau to monitor and track key factors based on feature importance
• Conducted competitive analysis on the Internet of Vehicle and conceptualized intelligent services by comparing 60 functions of 6 competitors’ in-vehicle infotainment systems in 3 realms of remote, access and valet

Shanghai, China

• Evaluated campaign performance for e-commerce platforms and developed insights with business acumen and text analysis
• Provided business analysis report for PG&E Evaluated monthly performance of Gillette and Braun’s shaver products by analyzing the marketing campaign data, KOL promotion data, and the E-commerce festival engagement data.
• Aggregated social media and web data, analyzed the return on marketing investment (RoMI) and customer acquisition cost (CAC) to quantify marketing effectiveness and visualize competitor intelligence
• Identified customer behaviors pattern with content analysis and offered insights for the coming promotion activities based on the patterns

Shanghai, China

• Cleaned and organized financial data using Excel, ensuring accuracy and consistency for analysis and reporting purposes
• Conducted thorough due diligence on various companies, performing in-depth research, analysis, and evaluation of their financial health, market position, and potential risks, resulting in comprehensive due diligence.
• Compiled detailed meeting notes, documenting key discussions, decisions, and action items to facilitate effective communication and follow-up among team members and stakeholders

Master'S Degree, Master Of Quantitative Management, Business Analytics: Marketing

Activities and Societies: Energy in Emerging Markets Case Competition: Researched Africa's energy sector and performed financial analysis.

Bachelor Of Science - Bs, Double Major In Mathematics And Economics

Activities and Societies: • After school tutoring club: Provided valuable academic support and mentorship to primary school students in.