Learn Data Skills
Beta
Yu Hsiang Wang

Yu Hsiang Wang

Shipping Monitor & AR Collector

National Taipei University

Technologies

My Portfolio Highlights

My New Track

SQL Server Developer

My New Course

Introduction to Python

My New Track

SQL Server Developer

Quantitative guru, enlightening the world with data-driven wisdom.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Understanding ChatGPT

course

Introduction to Python

course

Introduction to Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Understanding ChatGPT
Introduction to Power BI

My Work Experience

Where I've interned and worked during my career.

Sports City International Inc.飛雁有限公司 | Jan 2021 - Present

Shipping Monitor & AR Collector

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: Provide systematic solutions and full score pass customers' compliance. -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 More

Sports City International Inc.飛雁有限公司 | Sep 2018 - Dec 2020

Shipping Monitor

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

パーク二四（株） | Oct 2015 - Apr 2018

Operation & Procurement Specialist

・ 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

My Education

Take a look at my formal education

Bachelor of Arts (B.A.), Foreign languages and applied linguisticsNational Taipei University | 2015
Exchange student, Culture and Education佐賀大学 | 2015

About Me

Yu Hsiang Wang

5Y+ shipping internal audit and analysis, 3Y+ RPA implementation and 2Y+ AR collection in apparel manufacturing; 2Y+ prosecution in Japan parking industry.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free