Xiangyu（Alan） Guo
Sydney
Summary
Data Engineer with extensive experience at Eversec and Byhealth, specializing in data analysis, industrial research, and machine learning. Developed a robust data warehouse from inception, significantly improving data governance and supporting business development initiatives. Proven project management capabilities and strong communication skills contribute to effective business intelligence and user data modeling outcomes.
Overview
5
5
years of professional experience
Work History
Big Data Engineer
Eversec (Beijing) Technology Co., Ltd.
04.2023 - 08.2024
- Process big data for business and establish relevant analysis models
- Complete the installation and cluster setup of Hadoop under single machine pseudo distribution, use Hadoop and Hive to participate in log data cleaning and integration, and participate in data warehouse planning and design
- Perform statistical analysis on user log data, and develop user data models based on age, region, preference and other feature tags.
- Assist in establishing a data warehouse, designing order dimension data tables, order basic data information tables, order incremental data information tables, order and service related information tables, etc, and building a data system consisting of ods layer, dim layer, edw layer, cdm layer, and adm layer for big data governance
- Independently complete the construction of the business data warehouse from 0 to 1, including the collection of core data, hierarchical processing of the data warehouse, and the development of regular daily and weekly reports, mainly using hive/spark.
- Use scala language to establish business models and deploy them independently and automatically
- Core Technology Stack: Hadoop, HDFS, Yarn, Spark, Python, Hive, Kafka
Investment Manager
Huazhang Kaifeng Asset Management Co., Ltd.
10.2022 - 03.2023
- Preliminary research on different industries, industry analysis, macro policy analysis, explore investment opportunities, and write investment letters of intent
- Mainly collect industry information through various channels and explore market trends
- Collect industry data and conduct data analysis
- Make corresponding investment value estimates based on the corporation's financial report
- Make reasonable judgments on market expectations and write relevant investment letters of intent
Health Project Manager
Guangzhou Weichen Health Technology Co., Ltd.
11.2021 - 10.2022
- Responsible for coordinating sports nutrition category development, analyzing market trends, and negotiating cooperation opportunities with suppliers and partners.
- Nutrition course development, responsible for professional and sales training of front-end sales personnel, empowering comprehensive business capabilities
- Health manager project coordination, responsible for one-to-one customization of product solutions for different types of people according to customer needs
- Negotiate with partners, responsible for cross-field business cooperation discussions and negotiations, and explore business cooperation opportunities
- Establish a user data pool, integrate data based on user purchasing behavior, age, hobbies, etc., and formulate and optimize transaction links
Sports Nutritionist
Guangzhou Maiyou Network Technology Co., Ltd.
02.2020 - 11.2021
- Responsible for customizing cycle management solutions for user sports and nutrition, developing corresponding sports and nutrition courses through online education, and tracking user data to improve user portraits
- Nutrition course development, responsible for front-end sales staff training, empowering comprehensive business capabilities
- Core members of the health steward project, responsible for one-to-one customization of sports product packages according to customer needs to ensure service experience and efficiency
- Head of the sports section of Yingyang Tiantuan, responsible for establishing a complete sports system and developing Qianren Qianmian sports programs
- Plan IP project and integrate data analysis, storage through big data warehouse, establish and analyze user profiles through big data tools
Sports Nutrition Trainer
Zhongjian Liliang Academy
08.2019 - 12.2020
- According to the needs and current status of users, specify long-term and effective health management plans, provide exercise and nutrition guidance, and train relevant professionals, etc.
- Provide targeted corrections to the user's physical fitness and posture during work
- Conduct statistical analysis on user movement data, develop user data portraits based on age, region, preference and other feature tags, improve the corporation's user database data, and derive potential user portraits for delivery.
Education
Master of Science - Artificial Intelligence
University of New South Wales
Sydney, NSW08-2026
Bachelor of Science - Computer Science and Technology
Jilin University Zhuhai Campus
China06-2019
Skills
- Data analysis and machine learning
- Time management
- Business acumen
- Team collaboration
- Effective communication
- Project management
- Critical thinking
Translator Declaration
CPN5MY00K, 03/10/24
Languages
English
Professional
Chinese (Mandarin)
Native/ Bilingual
Chinese (Cantonese)
Native/ Bilingual
Affiliations
- 10 years of fitness and over 20 fitness awards
- Passionate about tennis, golf, and skiing
- Passionate about socializing
Timeline
Big Data Engineer
Eversec (Beijing) Technology Co., Ltd.
04.2023 - 08.2024
Investment Manager
Huazhang Kaifeng Asset Management Co., Ltd.
10.2022 - 03.2023
Health Project Manager
Guangzhou Weichen Health Technology Co., Ltd.
11.2021 - 10.2022
Sports Nutritionist
Guangzhou Maiyou Network Technology Co., Ltd.
02.2020 - 11.2021
Sports Nutrition Trainer
Zhongjian Liliang Academy
08.2019 - 12.2020
Master of Science - Artificial Intelligence
University of New South Wales
Bachelor of Science - Computer Science and Technology
Jilin University Zhuhai Campus
Similar Profiles
Yufei LiYufei Li
Ski Instructor at BeijingSki Instructor at Beijing
Brady (Yihong) DuBrady (Yihong) Du
Sales Assistant at Beijing Blue Dot Internet Technology Co., Ltd.Sales Assistant at Beijing Blue Dot Internet Technology Co., Ltd.
Changcheng LiChangcheng Li
Localization Editor at Beijing Qite Technology Co., Ltd.Localization Editor at Beijing Qite Technology Co., Ltd.