William Yan

William Yan Email and Phone Number

Data Analyst | SQL | Tableau | Power BI | Python
William Yan's Location
Allen, Texas, United States, United States
William Yan's Contact Details

William Yan work email

William Yan personal email

n/a
About William Yan

Data-driven professional with a Master’s in IT and Management and a Bachelor's in Supply Chain Management. Experienced in optimizing supply chain processes, launching products, and using advanced analytics and BI tools. Skilled in SQL, Python, SAP, Tableau, and Power BI. Fluent in Mandarin, with a proven ability to streamline operations and drive efficiency. Passionate about leveraging data to make strategic business decisions and continuously improve performance.

William Yan's Current Company Details

Data Analyst | SQL | Tableau | Power BI | Python
William Yan Work Experience Details
  • Samsung Electronics America
    Demand Planning - Sr. Analyst
    Samsung Electronics America Apr 2022 - Jun 2023
    Ridgefield Park, Nj, Us
    • Mitigated risks related to inventory management by conducting weekly analysis of multiple data sources, such as sales targets and inventory aging schedules, within the ERP system• Analyzed weekly Supply Chain Management Production, Sales, Inventory (PSI) data, monitoring sales performance across 10+ product lines, tracked inventory levels, and assessed production schedules, ensuring alignment with monthly revenue targets and timely delivery fulfillment using data-driven tools and ERP system• Created Tableau and MS Power BI visualizations (10+ sections) of statistical and economic models to enhance the understanding of future production and sales plans, enabling a comprehensive view of the data• Engaged in collaborative efforts with multinational teams, including HQ and key distributors, to ensure compliance with localrules and regulations while fulfilling commitments, on a weekly basis• Collaborated with the finance team over issues concerning credit risks of suppliers, distributors, and other relevant parties
  • Samsung Sds America
    Supply Chain Specialist Ii
    Samsung Sds America Dec 2021 - Apr 2022
    Ridgefield Park, New Jersey, Us
    • Facilitated coordination among multiple teams in various countries to manage the arrival and departure of over 600 containers transporting Samsung products to and from the United States on a weekly basis.• Minimized risks associated with shipping and delivery by consistently tracking the movement of all containers in transit with involved carriers throughout the duration.• Ensured daily compliance with port regulations and delivery terms, utilizing data-driven insights to streamline processes, resulting in enhanced operational efficiency and increased customer satisfaction.
  • Knoas Flooring Inc.
    Supply Chain Associate
    Knoas Flooring Inc. Dec 2020 - Dec 2021
    • Maintained a 100% on-time delivery rate for 100+ customer orders by analyzing and optimizing order fulfillment processes, utilizing data-driven inventory allocation strategies within the order management system.• Designed and implemented a weekly shipment reporting process to facilitate communication between the corporate office andtransportation team, resulting in a 30% improvement in on-time delivery rates.• Analyzed customer data for 5 key accounts and over 100 customers, leveraging insights to increase non-peak revenue by 50% through targeted strategies and improved decision-making.• Prevented delays for 90 orders by utilizing the internal inventory borrowing model to resolve supply shortages.• Optimized warehouse space utilization by conducting a thorough data analysis and applying Spaghetti diagram tools, leading to a 3000 sq. ft. reduction in space waste
  • Amazon
    Warehouse Associate
    Amazon Sep 2020 - Oct 2020
    Seattle, Wa, Us
    • Developed skills in all aspects of warehouse operations for the assigned department to ensure efficient and accurate customer delivery process.• Adhered to the warehouse compliance standards for safety, quality, and productivity goals in support of team objectives.
  • Ascend Ut Dallas Student Chapter
    Marketing Department
    Ascend Ut Dallas Student Chapter Aug 2018 - Aug 2020
    Richardson, Texas, Us
    • Managed marketing department of 6 officers and successfully organized 8 professional development and networking workshops; awarded Best Organization at School of Management for outstanding performance and leadership• Maintained and expanded relationship with local firms such as American Arline and Big 4 accounting firms, and invited professionals to provide career consultation and mentorship to benefit students• Increased membership by 20% to 40 students by hosting marketing campaigns and spreading impact on campus
  • Mainstage Inc.
    Accounting Internship
    Mainstage Inc. Aug 2019 - Dec 2019
    • Allocated pay for 10 employees based on hourly rates, hours worked, or salary rates and days worked• Recorded journal entries of the payroll account into the general ledger weekly• Processed bi-weekly payroll, quarterly941, and TWC reports, Annual W-2’s, and form 940 by using Excel• Arranged work schedule for internship group of 5 people through the worksheet to ensure the efficiency of work• Reconciled client’s daily revenue transactions with cash accounts to ensure total amounts balanced
  • Bank Of China
    Operations Department Internship
    Bank Of China May 2018 - Jun 2018
    Beijing, Cn
    • Collaborated with the project manager to explore student membership opportunities by holding seminars on student loan security to promote bank brand in 13 universities• Acted as the liaison between the project department and the Beijing headquarter in framework related matters for the first student loan project in the Changsha area• Gave a presentation about loan security to 300 students at Hunan University of Finance and Economics

William Yan Education Details

  • Dallas Baptist University
    Dallas Baptist University
    Information Technology And Management
  • The University Of Texas At Dallas
    The University Of Texas At Dallas
    And Supply Chain Management

Frequently Asked Questions about William Yan

What is William Yan's role at the current company?

William Yan's current role is Data Analyst | SQL | Tableau | Power BI | Python.

What is William Yan's email address?

William Yan's email address is zi****@****ung.com

What schools did William Yan attend?

William Yan attended Dallas Baptist University, The University Of Texas At Dallas.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.