Yu Wei Email and Phone Number

• Conducted data-driven analysis to complete a Q2 2024 credit bond quarterly report, covering municipal andindustrial bonds, using Ifind data. Managed data cleaning, model building, and created data visualizations inExcel.• Led credit risk assessments for 37 convertible bonds, analyzing refinancing potential, debt servicing abilities, andthe financial backing of major shareholders. Utilized metrics such as pure bond YTM, EBITDA/total debt ratios,and monetary fund allocations to evaluate financial stability.• Synthesized and extracted key findings from case studies on municipal bonds, compiling insights into PPTpresentations for senior management.• Researched and evaluated the impact of monetary policies on credit spreads. Analyzed historical defaults andstructured a comprehensive report on key determinants influencing credit spreads over time.• Completed a regional economic report for Xiangyang, which included a detailed analysis of listed companyresources, population demographics, industrial composition, and growth forecasts for the area’s key industries.

●Constructed Email Marketing plans to target over 5,000 recipients by performing thorough market research andanalysis to effectively deliver the company's value preposition. Developed and implemented a marketingcampaign that covered 8,000 customers and enriched the company's image.● Designed a model to compare different recruitment companies with Python and provided a complete marketresearch report. Operated the business social media channels by editing content for the different channels,resulting in a 30% increase in the number of followers.● Hosted three live streams with guest speakers to help college students do mock interviews and practice careerrecruiting skills.● Tracked project timelines and budgets to ensure timely completion of tasks within allocated resources.● Identified advertising gaps through consumer surveys and sales analysis

• Conducted the Junpa brand initiating project by designing market research questionnaires for the company's products• Analyzed 1,193 questionnaires and completed a survey report using Excel and Word for the supervisor, visualizing data• Contributed to online promotion: collected and researched data to analyze consumers' preferences on mushroom products, generated consumer profiles• Created a Wechat Official Account for the brand and wrote three promoted tweets for Junpa, leading to a 200% increase in subscribers.• Monitored competitors' pricing strategies and recommended adjustments as needed.