(｡･∀･)ﾉﾞ嗨！我是黄澜 Hi! I'm Huang Lan
SEO优化师 | 内容创作者 | AI+语言学研究者 SEO Specialist | Content Creator | AI Researcher
关于我 About Me
教育背景 Education
• 发表Springer国际会议论文 • Published Springer conference paper
专业技能 Professional Skills
- 外语能力优秀。书面特别好：大学英语六级652分（前0.2%），英语专八，雅思8分；英语口语流利，长期用于工作语言；德语书面 Language Skills: Native Mandarin; fluent English: IELTS 8.0, CET-6 652 (top 0.2%), TEM-8; German literacy
- 自媒体0-1起号2万粉，擅长内容创作与社媒运营（孵化过26w+粉达人，协助他一年半内涨粉18w+） Social media expertise: Grew a personal audience to 20K+ followers and developed an influencer with 260K+ followers through strategic content creation and data-driven operations.
- 精通Ahrefs、SEMrush、GSC、GA等SEO工具，常用SQL、Excel、Python等定期数据分析每迭代SEO表现，data-driven制定下一迭代优化动作 Proficient in SEO tools (Ahrefs, SEMrush, GSC, GA) & data analysis (SQL, Excel, Python)
-
熟练使用HTML、CSS、JS进行网站开发；以及Pr、AE、剪映、PS、可画、Figma等视频/图片/UI软件;
懂unity&C#来与开发提需/对接游戏制作 Skilled with HTML, CSS, and media editing software (Pr, AE, CapCut, PS，Canva、Figma)
工作与项目经历 Work & Projects
- 负责英文站SEO全流程管理，实现站点总体UV提升420%，日均订单增长超8倍 Managed full SEO process for English site, achieving 420% UV increase & 8x daily orders
- 制定SEO策略，建立12000+关键词库，带领团队产出150+核心页面 Developed SEO strategy, built 12,000+ keyword database, led team to create 150+ core pages
- 主导商品&博客页面HTML重构、内链优化及转化方案，CVR提升2.78倍，CTR提升32.6%+ Led HTML restructuring, internal linking & conversion optimization, increasing CVR by 2.78x
- 负责X、Discord、Telegram等平台日常运营，部署40+个TG bot，两周内新增80万游戏用户 Managed X, Discord & Telegram operations, deployed 40+ TG bots, gained 800K users in 2 weeks
- 协助8个KOL项目合作对接，策划执行6场社区活动，推特累计涨粉14万+ Facilitated 8 KOL collaborations, planned 6 community events, gained 140K+ Twitter followers
- 作为游戏策划&营销，参与MMORPG游戏的立绘制作、本地化以及关卡/世界观/角色等设计策划（熟悉Unity，C#与开发提需对接） As game planner & marketer, participated in MMORPG artwork creation, localization, and level/worldview planning (Unity, C# development coordination)
- 设计并组织76位意向出国的大学生，参与为期一个多月的实验，研究AI对大学生口语提高的作用，受试者雅思平均提高0.8分 Designed & organized experiment with 76 participants, studying AI's effect on oral English, average IELTS improvement of 0.8
- 利用SPSS、AMOS分析实验数据，撰写发表论文，刊登于SCI一区-顶级期刊（RELC）；以及Springer国际会议期刊（关于AI语言学领域综述） Analyzed data using SPSS & AMOS, published papers in SCI Q1 journal (RELC) & Springer
学术发表 Publications
AI for Language Learning (RELC Journal)
研究AI对大学生英语口语学习的影响和效果... Research on the impact and effectiveness of AI on college students' English speaking...
AI Applications in Language Education
探讨人工智能在语言教育中的应用和前景... Exploring applications and prospects of AI in language education...
SEO部分作品展示 SEO Portfolio
自媒体经历 Media Experience
XX MCN有限公司 XX MCN Company
作为B站音乐区UP主，发布2条视频粉丝达2w，首条视频播放量40w+ As a Bilibili music creator, gained 20K followers with just 2 videos, first video 400K+ views
微博粉丝2k+ 2K+ Weibo followers
小红书粉丝1k 1K Xiaohongshu followers
KOL孵化成果 KOL Development
协助孵化B站生活区26w+粉丝UP主，负责视频剪辑、选题调研、脚本策划、商单PR建联等工作 Helped develop a Bilibili lifestyle creator to 260K+ followers, responsible for video editing, topic research, script planning, and business cooperation