Shiqi Cheng

Shiqi Cheng

Followers of Shiqi Cheng220 followers
location of Shiqi ChengMannheim, Baden-Württemberg, Germany

Connect with Shiqi Cheng to Send Message

Connect

Connect with Shiqi Cheng to Send Message

Connect
  • Timeline

  • About me

    Business Intelligence Manager @Auto1 Group

  • Education

    • Taiwan Foguang University

      2016 - 2016
      Exchange student Economics
    • Beijing Jiaotong University

      2014 - 2018
      Bachelor's degree Economics 89/100
    • Mannheim Business School

      2019 - 2021
      Master's degree Economics
  • Experience

    • ZEW - Leibniz Centre for European Economic Research

      Oct 2020 - Apr 2021

      • Supported in preparing and analyzing• Assisted the economic models analysis and mathematical calculations• Support with database management and download facilities. - Data preparation and visualisation for research projects with python and R code.- Contribution to the creation of new databases, for instance via webscraping.- Support with database management and download facilities.

      • Student Research Assistant

        Feb 2021 - Apr 2021
      • Intern

        Oct 2020 - Jan 2021
    • Emma – The Sleep Company

      May 2021 - Sept 2021
      Intern Business Development Greater China

      Data integration and analysis• Collaborate data between on-site and off-set to simulate consumer journey, in order to optimizepurchasing and usage behaviour as well as the conversion funnel.• analyse all marketing relevant KPI and derive recommendations for action and present theresults to all relevant stakeholders.Marketing activities• Responsible of design and control of marketing Implementation, especially for social mediainfluencers promotion cooperation.• Follow up promotion executions, including product delivery, advertisement content review,promotion data analysis, etc.SEO&SEM• SEO: Responsible for SEO optimization of the website, to achieve optional keywords ranking.• SEM: Develop website paid ads strategy to increase site traffic and generate more traffic toonline store. Show less

    • AUTO1 Group

      Jan 2022 - Jun 2022
      Business Intelligence Intern - Finance
    • AUTO1 Group

      Sept 2022 - now

      - Established and maintained an inventory audit system, training teams andsupporting annual audits.- Build ETL pipelines to integrate financial data from various sources, automating monthly report distribution via GitHub and dbt.- Produce highly-optimized SQL queries about Inventory payment for B2Conline retail plat-form, performing data quality checks to detect abnormalities and outliers in production tables.- Migrate legacy ETL jobs to Python, developing advanced Python codingskills in the process. Show less

      • Business Intelligence Manager

        Jul 2023 - now
      • Junior Business Intelligence Manager

        Sept 2022 - Jun 2023
  • Licenses & Certifications

    • Chartered Financial Analyst LEVEL II

      CFA Institute
      Oct 2022
      View certificate certificate
    • Chartered Financial Analyst (CFA) Level I

      CFA Institute
      Aug 2021