JENG-PING SZU

--Led complex data analysis projects, focusing on inventory health status and warehouse capacity utilization, shop order performance, enhancing operational efficiency.
--Developed and delivered comprehensive reports and dashboards for management, utilizing Power BI and SQL to visualize key performance indicators (KPIs).
--Conducted data quality audits and reconciliations, identifying trends and areas for improvement, statistics and analysis practices.
--Collaborated with cross functional teams to support supply chain reporting and strategic decision making.
--Created various analysis tools and dashboards by multiple analysis models with proficient ETL process via SQL/ Excel/ Power Query/Python/ VBA over Power BI & SharePoint platforms.

Led complex data analysis projects, focusing on inventory health status and warehouse capacity utilization, shop order performance, enhancing operational efficiency.
Developed and delivered comprehensive reports and dashboards for management, utilizing Power BI and SQL to visualize key performance indicators (KPIs).
Conducted data quality audits and reconciliations, identifying trends and areas for improvement, statistics and analysis practices.
Collaborated with cross functional teams to support supply chain reporting and strategic decision making.
Monthly/ Weekly reporting for KPI metrics for cross-function teams and stakeholders.
Created various analysis tools and dashboards by multiple analysis models with proficient ETL process via SQL/Excel/Power Query/Python/VBA over Power BI & SharePoint platforms.

--Review & analyze customer 's product portfolio to ensure adequate levels of inventory were maintained as outlined by customers
--Placed orders based on sales forecast & depletion analysis etc. in order to maintain healthy weekly supply.
--Collected data from multiple sources and generated weekly/monthly reports including sales projections, inventory/forecast analyst, watch list, promotions, orders status, OOS (out of stock) etc.
--Order tracking and liaised with overseas suppliers and appropriate freight forwarder on status orders and readiness of cargo.
--Cross team support including products info auditing & complex reports automation/ analysis.
--System support, troubleshooting tickets.
--Operation & performance analysis; developed various KPI/performance analysis tools & dashboard, including products velocity, replenishment, operator productivity reports etc. in order to analyze large scale dataset efficiently on daily, weekly & monthly basis.

Review & analyze customer's product portfolio to ensure adequate levels of inventory were maintained as outlined by customers.
Placed orders based on sales forecast & depletion analysis etc. in order to maintain healthy weekly supply.
Collected data from multiple sources and generated weekly/monthly reports including sales projections, inventory/forecast analyst, watch list, promotions, orders status, OOS (out of stock) etc.
Order tracking and liaised with overseas suppliers and appropriate freight forwarder on status orders and readiness of cargo.
Cross team support including products info auditing & complex reports automation/analysis.
System support, troubleshooting tickets.
Operation & performance analysis; developed various KPI/performance analysis tools & dashboard, including products velocity, replenishment, operator productivity reports etc. in order to analyze large scale dataset efficiently on daily, weekly & monthly basis.

Inventory control/management & analysis for 4500+ SKUs.
Customer sales representative & support; I was in charge of multiple large-scale customers.
Order processing/tracking/logistics (shipping/receiving/dispatching) including LTL, FTL.
Generate order tracking and inventory (movement) reports, low stock replenishment alert etc.
Cost/Revenue analysis/reporting.
Successfully improved inventory accuracy from 70% to 98~99%, and saved tens of thousands of dollars of inventory loss, from which I achieved high customer satisfaction ratings.
System operation & IT support.

--Customer sales representative & support; I was in charge of multiple large-scale customers.
--Order processing/tracking/logistics (shipping/receiving/dispatching) including LTL, FTL.
--Generated detailed reports on inventory movement and cost analysis, contributing to enhanced operational efficiency.
--Cost/Revenue analysis/reporting.
--Successfully improved inventory accuracy from 70% to 98~99%, and saved tens of thousands of dollars of inventory loss, from which I achieved high customer satisfaction ratings.
--System operation & IT support.

--Supervised inventory management processes, ensuring timely support for production lines through effective stock oversight.
--Developed new reporting processes to track inventory health and performance KPIs.
--Discrepancy investigation and reconciliation/adjustment.
--Weekly and monthly KPI / performance reports.
--Liaised with other functional areas including Receiving, Shipping and Procurement.

Supervised a team to maintain inventory health, and to support production lines by preparing stock/parts in time per specific work orders.
Developed and implemented new processes/projects as needed.
Stock/inventory oversight & replenishment by implementing Kanban and Lean process.
Monitored and generated low level parts reports, maintained close communication with parts buyers in order to support production plan.
Discrepancy investigation and reconciliation/adjustment.
Weekly and monthly KPI / performance reports.
Liaised with other functional areas including Receiving, Shipping and Procurement.

Inventory control/management & analysis for 4500+ SKUs.
Customer sales representative & support; I was in charge of multiple large-scale customers.
Order processing/tracking/logistics (shipping/receiving/dispatching) including LTL, FTL.
Generate order tracking and inventory (movement) reports, low stock replenishment alert etc.
Cost/Revenue analysis/reporting.
Successfully improved inventory accuracy from 70% to 98~99%, and saved tens of thousands of dollars of inventory loss, from which I achieved high customer satisfaction ratings.
System operation & IT support.

In charged of top 10 IT projects of Chung-Hwa Telecom. (the largest telecom vendor in Taiwan)
Support for customer IT system configuration, installation and training.
HP Special Contribution employee award among 600 employees.