Learn Data Skills
Beta
Andai Li

Andai Li

Commercial Operation Specialist

Sennheiser

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Track

Associate Data Analyst in SQL (previously Data Analyst in SQL)

My New Course

Introduction to Python

Insights conductor, orchestrating a symphony of knowledge from data melodies.

My Work

Take a look at my latest work.

DataLab

Project - Analyzing Unicorn Companies

DataLab

Analyzing Motorcycle Sales

DataLab

Intermediate SQL

DataLab

Project - Analyzing Unicorn Companies

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Sennheiser electronic Beijing Co. | Sep 2021 - Oct 2022

Commercial Operations Specialist

• Processed retail orders worth over CNY 8M on monthly bases in JDE system by coordinating with warehouse team to complete full shipment cycle on time. • Generated weekly inventory report by using SQL to support sales team’s purchasing and marketing decisions • Identified product failure rates from monthly return reports using Excel pivot table to improve the efficiency of services center • Initiated return process for key business accounts by working with sales and finance teams for keeping healthy cash flow and improving customer satisfaction • Maintained records of customer information and inquiries in CRM system, including interactions, transactions, recorded details of inquiries, complaints, comments and actions.
Show More

Huatai Usa LLC | Jul 2017 - Oct 2020

Export Logistics Specialist

• Executed ACH and wire payment of over $200,000 weekly to vendors in accuracy and timely manner while adhering to business policies and procedures • Resolved booking related issues by negotiating with shipping line company to ensure export shipment delivered to customer on time • Prepare export documents on timely manner by working with shipping line documentation and insurance company to keep healthy cash flow • Created monthly shipping line rate matrix and monthly rate GRI report using Excel pivot table to assist manager team on budget planning • Verified and entered business transaction to accounting system accurately to help improve work efficiency on doing bank reconciliation at the end of the month • Reviewed and entered invoice information into accounting system, including payment terms, invoice amount and invoice dates. negotiated with vendor and related department when invoice discrepancy occurred

My Education

Take a look at my formal education

Master's degree in Investment ManagementTemple University | 2017
Bachelor's degree in FinanceTemple University | 2016

About Me

Andai Li

After working in supply chain and logistics for 4 years, I'm activly learning SQL and Python to change career path to Data Analyst.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free