工作经历
洛阳尚贤科技有限公司Luoyang Shangxian Technology Co., Ltd. — 数据分析实习生Data Analyst Intern
2025.06 – 2025.08
- 使用 Python (Pandas/NumPy) 与 SQL 清洗、汇总并分析业务日志与运营数据，处理 10 万+ 条结构化记录。
- 搭建并维护核心 KPI 体系（活跃、转化、留存），统一指标口径。
- 使用 Tableau 与 Excel 产出周报/月报，监控趋势与异常，支持产品与运营决策。
- 优化关键 SQL 查询（索引与查询结构），运行时间缩短约 20%。
- 与产品、运营协作，将结论转化为可落地的数据建议。
- Cleaned, aggregated, and analyzed business logs and operations data using Python (Pandas/NumPy) and SQL, processing 100,000+ structured records.
- Built and maintained a core KPI system (activity, conversion, retention), standardizing metric definitions for consistency.
- Produced weekly/monthly analysis reports with Tableau and Excel, monitoring trends and anomalies to support product/ops decisions.
- Optimized key SQL queries (indexing + query structure), reducing runtime by ~20% to improve reporting efficiency.
- Collaborated with product and operations teams; translated findings into actionable, data-driven recommendations.
![]()