Jiayi Li

Collected and cleaned macroeconomic datasets from NBS, PBoC, IMF; structured large datasets using Excel and automated scripts. Conducted time-series analysis of GDP, CPI, PPI and PMI to identify leading indicators, integrating results with policy and market contexts. Produced research reports with data visualizations to communicate insights to portfolio managers.

Analyzed semiconductor industry value chain, identifying competitive advantages of market leaders through technology benchmarking and market share analysis. Verified financial documents including accounts receivable confirmations, sales contracts, and invoices, ensuring accuracy for IPO due diligence.

Modeled financial performance of a retail company using DCF and scenario analysis, incorporating 6-month historical data into valuation models. Researched revenue drivers and cost structures of 20 new retail companies via Wind database to inform strategy reports for senior management.

Scraped and analyzed industry and company data for designer toy and beauty sectors; assessed IPO filings for business growth logic and capacity. Contributed to three in-depth research reports on consumer goods, cosmetics and recombinant collagen industries.

Collected and processsed tender and industry data for a Fortune 100 pharma diagnostics client, enabling a successful bid for digital product manager training. Created and refined client-facing presentations, ensuring clarity, professional formatting and impactful visual design.

Prepared monthly, quarterly and annual P&L statements and balance sheets; analyzed trends to support operational decision-making. Reviewed 200+ expense and invoice vouchers monthly for compliance and accuracy.