William Yan work email
- Valid
William Yan personal email
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.
-
Demand Planning - Sr. AnalystSamsung Electronics America Apr 2022 - Jun 2023Ridgefield 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 -
Supply Chain Specialist IiSamsung Sds America Dec 2021 - Apr 2022Ridgefield 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. -
Supply Chain AssociateKnoas 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
-
Warehouse AssociateAmazon Sep 2020 - Oct 2020Seattle, 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. -
Marketing DepartmentAscend Ut Dallas Student Chapter Aug 2018 - Aug 2020Richardson, 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 -
Accounting InternshipMainstage 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
-
Operations Department InternshipBank Of China May 2018 - Jun 2018Beijing, 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 UniversityInformation Technology And Management -
The University Of Texas At DallasAnd 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
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial