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.

<p>Led complex data analysis projects, focusing on inventory health status and warehouse capacity utilization, shop order performance, enhancing operational efficiency.<br>
Developed and delivered comprehensive reports and dashboards for management, utilizing Power BI and SQL to visualize key performance indicators (KPIs).<br>
Conducted data quality audits and reconciliations, identifying trends and areas for improvement, statistics and analysis practices.<br>
Collaborated with cross functional teams to support supply chain reporting and strategic decision making.<br>
Monthly/ Weekly reporting for KPI metrics for cross-function teams and stakeholders.<br>
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.</p>

--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.

<p>Review & analyze customer's product portfolio to ensure adequate levels of inventory were maintained as outlined by customers.<br>
Placed orders based on sales forecast & depletion analysis etc. in order to maintain healthy weekly supply.<br>
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.<br>
Order tracking and liaised with overseas suppliers and appropriate freight forwarder on status orders and readiness of cargo.<br>
Cross team support including products info auditing & complex reports automation/analysis.<br>
System support, troubleshooting tickets.<br>
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.</p>

<p>Inventory control/management & analysis for 4500+ SKUs.<br>
Customer sales representative & support; I was in charge of multiple large-scale customers.<br>
Order processing/tracking/logistics (shipping/receiving/dispatching) including LTL, FTL.<br>
Generate order tracking and inventory (movement) reports, low stock replenishment alert etc.<br>
Cost/Revenue analysis/reporting.<br>
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.<br>
System operation & IT support.</p>

--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.

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

<p>Inventory control/management & analysis for 4500+ SKUs.<br>
Customer sales representative & support; I was in charge of multiple large-scale customers.<br>
Order processing/tracking/logistics (shipping/receiving/dispatching) including LTL, FTL.<br>
Generate order tracking and inventory (movement) reports, low stock replenishment alert etc.<br>
Cost/Revenue analysis/reporting.<br>
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.<br>
System operation & IT support.</p>

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