Snowflake delivers the Data Cloud — a global network where thousands of organizations mobilize data with near-unlimited scale, concurrency, and performance. Inside the Data Cloud, organizations unite their siloed data, easily discover and securely share governed data, and execute diverse analytic workloads. Wherever data or users live, Snowflake delivers a single and seamless experience across multiple public clouds. Snowflake’s platform is the engine that powers and provides access to the Data Cloud, creating a solution for data warehousing, data lakes, data engineering, data science, data application development, and data sharing. Join Snowflake customers, partners, and data providers already taking their businesses to new frontiers in the Data Cloud.

Implementation of the CMU Database BusTub (CMU)                                                       November 2021• Implemented the Buffer Pool Manager, Hash Index, Query Execution and Concurrency Control modules of the database using the programming language C++. These modules worked together to support concurrent execution of transactions in different isolation levels which took full advantage of the disk/memory storage and the disk-backed extendible hash indexDistributed Cloud…
            

    
    

    
        Show more

Carnegie Mellon University - Heinz College of Information Systems and Public Policy

Activities and Societies: IGV Team Leader, AIESEC Beijing Foreign Studies University, Sept. 2015 – Sept. 2016;

Beijing Foreign Studies University

Software Engineer

• Enhanced our real-time data warehouse Unified Data Warehouse (UDW) core framework, including:
      Adding new features for ingesting raw data in different encoding formats, and filtering data paths
      Improving pre-aggregation functionality and metadata collection
      Defining view management interface, standardizing and automating view’s definition
• Built the UDW data quality assurance framework, which help collect quality metrics and trigger alerts
• Owned the Review, Rating and Download Revenue datasets UDW ETL migration, also including table schema restructure, and improving query performance by optimizing index, cache and pre-aggregation.
• Participated building the Snowflake local testing environment, reaching a 95% coverage of codes.

Big Data Engineer Intern

• Collected operation data and calculated the geographical distance and cycling delivery time between the delivery points and receiving points according to the road traffic conditions with Amap API
• Optimized the logistics distribution locations to decrease distribution cost with the knowledge of the Uncapacitated Fixed-charge Location Problem (UFLP) in the location planning, and relevant modeling methods with Python integer programming; Selected 8 distribution points out of 79 candidate points

Algorithm Intern

• Administrated the preliminary book selection, price negotiations, price adjustment, and the sales monitoring process of 4 important promotion modules of the Kindle store
• Analyzed and improved book selection and pricing strategies using historical sales data and wrote the corresponding code according to policy standards
• Participated in the testing and improvement of the newly-launched management information system Web Tool, adjusting the database updating cycle and writing embedded formulae to optimize the process

Content Demand-Pricing Intern

• Developed “The Magnet of China for Talents Overseas Report”, including Analyzing survey data and sorting out the storyline; responsible for 70% of writing and revision in the report
• Arranged the “Global Talent Strategy Forum” and invited guest speakers and HR managers from different industries
• Co-planned the “China’s CHRO Workplace Insight Report”; discussed with the organizer about the structure and proposed the required data dimensions