Yi-Kai, Chen (Steven)

Experience

• 

  State of Idaho

  Dec 2021 - Jun 2022

  Asia Trade Office Marketing Intern

  - Connected 2 Idaho food producers with 15 Taiwanese manufacturers by crafting 7 customer feedback reports for the office director- Facilitated Idaho companies to provide 25% more product samples to Taiwan by developing Taiwanese Customer Research Report, which provides market entry strategies and consumer preferences of Taiwan market - Created comprehensive export trend dashboards for the director to identify potential Idaho products for import by using Excel pivot tables and analyzing a substantial 2 GB dataset of trading data- Provided visibility of trade show by monitoring key marketing metrics such as conversion rate, acquisition cost per customer and return on marketing campaign Show less

• 

  Deloitte

  Sept 2022 - Apr 2023

  Risk Advisory Consultant

  - Achieved a 87.5% of customer satisfaction rate by delivering inventive data quality solutions that solved data log management issues for Financial, Data Engineering as well as CIOs across 8 technology firms- Accomplished 100% data accuracy for 8 TB of data source by designing 200+ ad-hoc SQL queries to validate data integrity, and optimizing ERP data processes such as SAP and Oracle- Prevented $4M+ data breach loss by defining cross-functional executive teams’ goals, outlining 3 KPIs of data management, crafting 200+ pages of documentation with Excel VLOOKUP, and exercising high judgment- Obtained 100% customer retention rate by translating ambiguous SQL data extraction results, client anecdotes and business context into actionable operation improvement for the VP of Deloitte and CIO of HTC Show less

• 

  Alaska Airlines

  Mar 2024 - Jun 2024

  Customer Analytics Consultant (Business Analytics Capstone Project)

  - Led a team of 6 to build a groundbreaking Customer Lifetime Value Prediction model by using Python for designing a XGBoost machine learning model, thus achieving a low root mean square error rate of 11.3%- Designed 6 customer retention and acquisition campaigns by cleaning 7 GB of transaction data with SQL, modeling with Python and crafting with Tableau dashboard

• 

  SHEIN

  Jul 2024 - now

  Product Specialist（U.S Fulfillment & Logistics)