Mickey Chen

Experience

• 

  Chase

  Aug 2017 - Jun 2018

  Part time teller

  • Collaborated with branch teams, ensuring customers’ financial transaction are completed accurately• Understood customers’ historical financial performance and needs, created connection with customers todesign investment recommendation strategy• Promoted advanced technology and multiple self-service channels such as mobile app to customers for bettercustomer experience• Identified Anti-Money Laundry and fraud activities based on daily transaction data

• 

  Bain & Company

  Mar 2019 - May 2019

  Research Assistant

  • Performed detailed research on and analyzed toothpaste products functions and selling strategies on major e-commerce platforms in China to support team members on a consumer project• Understood Alibaba’s New Retail Revolution, conducted research about how e-commerce companies and physical retail stores cooperate to run the revolution both online and offline for reporting to seniors

• 

  Ping An Technology

  Jun 2019 - Aug 2019

  Strategy Analyst

  • Proactively researched, analyzed and processed information from internal database using Excel pivot table and industry reports to generate business insights on company products under current promoting strategies and more accurate customers portrait• Independently drafted multiple presentations by analyzing the product selling strategies and development trends in promising industries such as Fast-Moving Customer Goods, Tourism and Automotive Aftermarket for future investments• Conducted in-depth research on recommendation system to facilitate customized product promotion and current product penetration plan by summarizing the system theory in practical application Show less

• 

  Comscore, Inc.

  Feb 2020 - Aug 2022

  • Built complex dynamic SQL queries and automation to streamlined data extraction process by 50% and conducted QA checks for anomalies, outliers and data validation for client facing team• Helped shape key business strategies by designing and developing visualized dashboard to show trends and outliers in customer demographics, market share, and other KPIs• Performed custom clickstream analyses with the multi-panel data of 2 million worldwide internet users by using SQL server, Snowflake, Greenplum and Bash• Managed data mining requests for top telecom companies including creation of regularly occurring deliveries and data driven solutions to provide insights in holiday sales performance and enabled clients identify potential customers across market and conversion funnel deep dive analyses, etc. Show less

  • Data Analyst

    Dec 2021 - Aug 2022

  • Associate Data Solutions Analyst

    Feb 2020 - Dec 2021
• 

  Amazon Global Robotics

  Aug 2022 - Mar 2023

  Sustainability Data Analyst

  • Maintained and automated the carbon emission pipeline and converted to scalable and user-friendly carbon footprint metrics• Developed SQL queries to retrieve product component and operational information for sustainability related life cycle assessment• Designed yearly carbon emission metrics and operational product information dashboard for consistent goal tracking• Worked closely with multifunctional teams to improve data collection process and shape carbon emission reduction plan Show less

• 

  ISpot.tv

  Mar 2023 - now

  Senior Data QA Analyst