Danny Ko

Supply Chain Planning Analyst, S&OP @ Niagara Bottling

About

Hi, I’m Danny! I’m a data analytics professional currently pursuing a Master of Science in Business Analytics (STEM) at USC Marshall. My diverse experience in data analytics, risk consulting, and corporate banking has shaped me into a data-driven analyst with strong financial business acumen. I’m passionate about leveraging data techniques and domain expertise to uncover patterns in data and extract impactful insights that drive informed business decisions. In addition to my career, I’m also a self-driven musical artist on YouTube and Spotify. As a side hustle, I manage partnerships with music distributors and media streaming platforms like YouTube and Spotify, amassing over 700K views across channels. I love sharing my passion for music to inspire and motivate listeners! If you’re interested in my background, feel free to connect—let’s explore opportunities for collaboration and mutual success!

Country

United States

City

Los Angeles

Industry

Banking

Skill

K-Nearest Neighbors (KNN), Decision Trees, Logistic Regression, Support Vector Machine (SVM), k-means clustering, Python (Programming Language), Exploratory Data Analysis, Regression Models, Ridge Regression, Predictive Modeling, Model Selection, Data Analytics Coaching, Project Planning, Case Studies, Data Visualization, MySQL, Extract, Transform, Load (ETL), Product Development, Consulting, MS SQL

Experience

Supply Chain Planning Analyst, S&OP

Niagara Bottling

2025-5 - Present · 1 yr 5 mos

Diamond Bar, California, United States

Assistant Relationship Manager, Corporate Banking

E.sun Financial Holding Co., Ltd

2023-2 - 2023-7 · 6 mos

Xinyi District, Taipei City, Taiwan

• Conducted pre-deal due diligence for 5 offshore lending cases on USD 10M+ to examine clients’ supply chain transactions, financial liquidity, and compliance, generating 4+ credit analysis reports presented to senior managers and general managers. • Maintained clients’ relationships by completing offshore transactions and consulting with the CEO, CFO, and finance teams to assess offshore business expansion plans and serve potential financing demands.

Data Analyst Intern

Henkel

2022-3 - 2022-5 · 3 mos

Shanghai, China

• Managed APAC CMD data cleansing projects to cleanse and streamline channel pricing data from 4 DBs by cross-functionally collaborating with 9 Channel teams and the Data team, improving data quality to 80%+ consistency rate in the APAC SAP. • Manifested cleansing improvement and revenue impact across each channel by developing metrics and 3 pricing dashboards using Power BI, facilitating new pricing strategies for the entire APAC channels. • Designed swim lane charts and mind maps using Microsoft Visio and XMind to prioritize data cleansing procedures, division of responsibility, and alternatives for flawed refreshing, expediting project communication in 10+ stakeholders’ meetings.

Risk Advisory Intern, Process System Improvement

Deloitte

2021-9 - 2022-1 · 5 mos

Taipei City, Taiwan

• Initiated an innovative project to integrate a new data ETL pipeline into the original product using Tableau Prep, automating the data synchronization and decreasing 70% of the average refresh time in the one-time data streaming process. • Utilized the MECE framework to construct analytical scenarios and metrics in 5 Tableau dashboards for analyzing clients’ declining profits in Asian markets, pinpointing the major factors, and optimizing the client’s 2021 improvement planning. • Built ER diagrams to define the relationship among 40K+ data entities across ERP system and other 5+ DBs, facilitating the data consolidation and relational database design in MS SQL.

Power BI Instructor

National Central University

2021-7 - 2022-1 · 7 mos

• Coordinated with 2 MBA students to organize 2 Power BI training modules, creating COVID-19 Trend and Superstore Performance cases to instruct 30+ students in data manipulation and dashboard reporting.