Ian Yan Email & Phone Number

Guangzhou, Guangdong, China

Develop "Amazon Ad Bot" for Amazon ad operations on the Coze platform, integrating a real-time data dashboard for monitoring ad performance. Automate bidding strategies, optimize keywords, and manage Amazon and Google Search ads by integrating external data sources. -Ad Automation: Create an ad strategy module to handle different ad demands, automate bidding adjustments, and update keywords based on real-time data. Enhance the bot's understanding of CPC, CPM, SP, SD, DSP, and other ad formats, which increased ad management efficiency by 30%. -Real-Time Data Dashboard: Design a real-time data dashboard displaying key metrics like CTR, CPC, and ROAS. Implement API connections to ensure timely data updates, improving the reliability of ad performance insights. The tool reduced manual oversight by 50%.

-Data dashboard: Visualize data through pivot tables and charts, and add slicers and timelines for dynamic filtering. Finally, update data sources regularly and adjust the dashboard design based on feedback to ensure the timeliness and effectiveness of the data.-Consulting Sales: Sold for about 150,000 RMB by managing an online consult group with more than 800 people.-Customer Records: Converted over 100 members to enquire the projects, resulting in 32 orders.-Customer Profiling: Record 100+ personal information and specific needs of potential repurchase customers.

Shanghai, China

-Efficient Output: Produced over 150 daily reports and 20 weekly reports during the internship.-Data Processing: Proficient in using vlookup and xlookup functions for data organization and referencing. Created and maintained Excel spreadsheets, consolidating historical data, and improving internal departmental efficiency.-Data Coordination: Responsible for liaising with upstream data providers, verifying and updating data, and publishing data reports to downstream clients.

Guangzhou, Guangdong, China

-Team Leadership: Led a team of 4 to complete an investment research report on China's AI industry and supported the establishment of a RMB 200 million investment fund in 2024.-Team Leadership: Led incoming intern members through the construction of 7 core investment metrics and 9 derivative metrics. -Corporate Evaluation: Collaborate with team members to complete background checks on proposed public companies and give appropriate valuations. Finally present the results to the client in a roadshow.

Shenzhen, Guangdong, China

Yunfeng Financial Group Limited (Hong Kong listed financial company) Hongkong, China fellow, Asset Management Sector (the Real Estate Industry) 02/2021-06/2021-Report Performance: Consistently ranked in the top 20% of similar funds over a three-month period by authoring 16 industry research reports and analyzing liquidity data trends to forecast future asset price movements.-Data Infrastructure: Established a macro liquidity analysis database containing 13 key macroeconomic indicators of the Central Bank and updated weekly.

Liuzhou, Guangxi Zhuang, China

• Managed the lending of over RMB 20 million in home mortgages and oversaw the loan eligibility and risk assessment for over 50 clients• Visited and researched 2 stone enterprises on site and assisted in recording and analysing their post-loan business status and project progress.

Master'S Degree, Economic Policy

Bachelor Of Science - Bs, Economics

Bachelor Of Science - Bs, Economics

Bachelor Of Science - Bs, Economics