Work and Intern Experience

  • Data Analysis Platform Constructer at Wuhan Zhongqin Metal Materials Co. LTD., Wuhan (remote), China, 06 - 08 2024
    • Analyzed current data organization and summaried their vulnerability.
    • Built Postgres cluster on Alibaba Cloud to support data platform.
    • Constrcted the design of database schema and ran the tests (previous years’ data) to ensure its correctness.
    • Managed to translocation the current data management to the cloud cluster.
  • Big Data Analytics & Architecture Intern at Kingdee International Software Group Limited, Shenzhen, China, 05 -07 2023
    • Investigated the existing big data platforms’ architecture and related big data components, and interfaced them with the existing express business. Acquired the basic usages of PostgreSQL, ClickHouse, and Redis.
    • Used CDH6.3.2 and Cloudera Manager to build a big data cluster on the company’s intranet servers through.
    • JumpServer, used Flink, Spark, Zookeeper, Kafka, Oozie, Redis, and other components to build the platform and realized the whole process of the company’s big data platform from zero to one with the guidance of the mentor.
    • Wrote Java and Scala code with SQL queries to complete the new data requirements of the product manager using Spring framework.
    • Used visualization tools power BI to build data dashboard.
    • Optimize the SQL queries the companies previously used (by reducing the depth of sub-queries).