Michael C. Yu - Data, Music and Life

Sales Data Analyst

Aug 2022 - Current

Manage and improve sales and operational reporting across HANA, SAC, Sales Cloud, and related data sources.
Monitor data quality and resolve reporting issues, especially for shipment, backlog, POS, opportunity, and NPI reporting.
Support cross-functional analytics needs by working closely with Sales, IT, and Operations teams.
Define and refine business logic, metrics, and reporting structures to improve consistency and decision-making.
Contribute to data governance efforts, including standard model design, change management, documentation, and single-source-of-truth discussions.
Provide ad-hoc analysis and communication support for business users, management, and project stakeholders.

Data Analyst

May 2022 - Jun 2022

Acted as mar-tech implementation analyst and data analytics consultant focused on customer behavior analytics for Cabital Earn product and corporate website.
Implemented advanced Google Analytics and Google Tag Manager event tracking and documentation.
Built product performance, user engagement and transactional data monitoring dashboards with Tableau and Google Data Studio.
Improved mar-tech technology integration and standardization to reduce development resources.
Successfully set up Snowflake table quality management process, refined business reporting metric definition and established dashboard SQL version control via Gitlab.

Senior Digital Analyst

Jan 2021 - Apr 2022

Digital product optimization and analytics focused on client’s classifieds business in South Africa with over 5 million active monthly users across web and app platforms.
Launched the first identity verification feature and redesigned seller information page, resulting in seller profile trust and interest increasing by 14%.
Launched new homepage and product landing page design with content management system(CMS) tool to reduce development time from content marketing team to our users.
Built automated reporting dashboards and metric alter notifications with SQL and Tableau for business stakeholders to have quick access to key product metrics.
Led the tracking requirement documentation and design for new flutter app product with Google Analytics and Google Tag Manager.
Led the project for upgrading Firebase Analytics and Universal Analytics to Google Analytics 4 and integrated the web and app products in the same product view.

Digital Analyst

Mar 2018 - Jan 2021

Driven client success as an analytics consultant by providing data-driven analysis and transformational insights to shape client’s online classifieds business with over 8 million monthly users across Mexico and South Africa.
Defined experiment workflow and coordinated the communication process between design, product and engineering teams which built the foundation for successfully executing more than 60 AB tests on both web and app platforms.
Improved primary business metric (reply through rate) by 6.8% and improved overall product funnel click-thru rate by 27% through experimentation.
Delivered tasks from tracking specifications, data visualization, and user journey analysis. Performed funnel analysis to identify areas for improvement to enhance user experience and conversion.
Involved in developing a culture by sharing analytics concepts and building analytics comprehension for the extended team.

Material Planner Lead

Dec 2017 - Mar 2018

Led a team of 5 planners managing laptop and desktop service parts planning, inventory management, demand forecasting, and data analysis for HP and ASUS repair centers in North America.
Product scope covered over 1,500 SKUs and service lifecycle management from 3 to 6 years.
Resolved material parts shortages and reduced product backlog from 500 to fewer than 100 units.
Increased daily service parts fulfillment rate from 85% to 98% within one quarter.
Identified root causes for inventory discrepancies and reduced system transaction errors by 44%.

Material Planner

Dec 2016 - Dec 2017

Conducted factory onsite projects to improve the return-to-vendor (RTV) process.
Assisted in designing warehouse material tracking workflows and investigated root causes for inventory discrepancies.
Improved defective part recall accuracy rate from 85% to 99% for motherboard and memory repair lines.
Reduced motherboard unit testing and sorting turnaround time by 21%.
Saved $250,000 in monthly material cost by improving operational efficiency and inventory accuracy.

Sourcing Specialist

Dec 2015 - Dec 2016

Operated strategic sourcing for laptop camera, display, and speaker modules, as well as Greater China local sourcing for passive components.

Michael.