Yu Hsiang Wang
Shipping Monitor & AR Collector at Sports City International Inc.飛雁有限公司- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
-
Mandarin Native or bilingual proficiency
-
English Full professional proficiency
-
Japanese Full professional proficiency
Topline Score
Bio
Credentials
-
Data Analyst in Power BI
DataCampAug, 2023- Sep, 2024 -
Power BI Fundamentals
DataCampJul, 2023- Sep, 2024 -
SQL Server Developer
DataCampJun, 2023- Sep, 2024 -
Supply Chain Fundamentals: Understanding the Basics
UdemyJun, 2023- Sep, 2024 -
Python Fundamentals
DataCampJul, 2021- Sep, 2024 -
SQL Fundamentals
DataCampJul, 2021- Sep, 2024 -
基礎數位行銷資格認證/ Google Digital Garage Certification
GoogleAug, 2018- Sep, 2024
Experience
-
Sports City International Inc.飛雁有限公司
-
Taiwan
-
Textile Manufacturing
-
1 - 100 Employee
-
Shipping Monitor & AR Collector
-
Jan 2021 - Present
Internal Audit for Outbound Shipments:1.Shipping Process Manage: Monitor shipping teams in 4 countries with 10+ factories by weekly to yearly reports, including booking, shipping, loading, invoicing, and payment collection status. 2.Shipping Process Improve:-Provide flow chart and FAQ for troubleshooting. ->Decrease 30%+ duplicated questions.-Streamline workflow by rectifying inconsistent processes.->Increase 50%+ data immediacy and accuracy.-Reinforce ERP system and design report for daily transaction.->Fty: save 50%+ time.; My team: save 40%+ time.-Provide PBI dashboards for outbound shipments and payment collection status. ->Influence report readers from managers to associates, totally over 100+.3.Transport Cost Analysis:-Reinforce report by re-defining workflow and importing reliable external data.-Analysis irregular and variance cost.-Provide Power BI YTD and YoY analysis for top managers.4.Trading: In-depth knowledge and hands-on experience with import, export, logistics and incoterms.5.Customer compliance:-Logistics: adidas Logistics KPI woner and full score pass twice.-Sustainability: Independent lead RCS 100 audit three times.Account Receivable Manager:1.Maintain monthly reconciliations to ensure accuracy and timely report, identify and escalate issues.2.Process Improve:-Streamline workflow by rectifying inconsistent processes. -> Increase 70%+ data productivity and accuracy.-Provide PBI dashboard for AR invoice and debit memo aging report for top manager.RPA Project:1.Shipping Process:-Cross check price to ensure correct invoice amount. ->Save 98%+ time, 370hr+ per year.-Implement compliance data for KPI management. ->Save 95%+ time, 240hr+ per year.2.AR:-Implement payment notification records and forecast AR. ->Save 95%+ time, 570hr+ per year.-Implement invoicing date and forecast AR. ->Save 95%+ time, 240hr+ per year.-Implement inward remittance records and close AR voucher. ->Save 80%+ time, 286hr+ per year. Show less
-
-
Shipping Monitor
-
Sep 2018 - Dec 2020
・Monitor shipping teams in Vietnam and Cambodia with 5+ factories by weekly to yearly reports, including booking, shipping, loading, invoicing, and payment collection status. ・Monitor the performance of factory shipping team to maintain the accurate delivery record, and provide training for system upgrade.・Effectively manage delivery report to ensure the integrity of accuracy and productivity.・Understand business requirements to provide solutions to meet buyers' new policies. ・Interface with planning, shipping, and finance teams to facilitate process improvement.・Analyze forwarder KPI reports to support compliance need, and process buyer payment notification in the system. Show less
-
-
-
パーク二四（株）
-
Real Estate
-
1 - 100 Employee
-
Operation & Procurement Specialist
-
Oct 2015 - Apr 2018
・ Develop data base to track inquiries about construction management status, reducing 25% construction delay ・ Design Excel spreadsheets for purchasing department to obtain purchase and stock for managing warehouse effectively ・ Coordinate with Accounting Department to ensure payments 100% proceeded punctually ・ Cooperate with construction managers to schedule follow-ups for each construction; coordinate with suppliers and vendors to arrange the materials for construction department to use; implement utilizing of used CCTV camera in good condition, reducing costs by 54% ・ Advance key management policy to resolve disordered key cabinet in low cost but high efficiency and result in 120% achievement of goal ・ Communicate with site superintendent about delays and any other issues that must be informed to relevant departments ・ Compose SOP manuals with specific explanations and abundant examples Show less
-
-
Education
-
2010 - 2014
National Taipei University
Bachelor of Arts (B.A.), Foreign languages and applied linguistics -
2014 - 2015
佐賀大学
Exchange student, Culture and Education
Community
