Guangting Sun

Build an LLM-driven web scraping pipeline and designing a GraphRAG system to extract insights from publisher–advertiser interactions

Authored 4 technology sector equity research reports focused on earnings releases, forecasting long-term trends by evaluating internal advantages and external macro factors, contributing to company ratings. Co-drafted 2 thematic reports on autonomous driving, analyzing market policies and business models, and estimating investment scales. Created cost models for leading companies like Baidu Apollo’s “Robocar” and assessed key technical paths (e.g., end-to-end systems) to support investment recommendations.

Supported an HR optimization project for a global pharmaceutical company by conducting interviews, analyzing privacy compliance across regions, and visualizing results in 30+ qualitative reports. Contributed to a digital HR transformation plan for a major manufacturing client by researching China’s digital policy impacts, evaluating SAP SuccessFactors, and projecting an 8% increase in HR efficiency. Delivered market analysis and pain-point mapping for a global energy firm, using Tableau to visualize HR workflows and design tailored digital transformation strategies that enhanced organizational automation.

Visualized tens of thousands of investor-related data from research to ensure data richness and credibility. Adjusted the research idea and direction with reporting the new findings of the data to the professor. Discussed the details of the research report with professor and PhD to ensure that it’s practical and meaningful.