Janet Li
Supply Chain Planner @ Legrand, North America | Inventory Optimization | Cost Reduction | Data Visualization | Advanced Excel Professional | Supply Chain Solver
- Role
- Supply Chain Planner at Legrand, North America
- Location
- San Francisco, CA, US
- LinkedIn followers
- 500 followers
About Janet Li
Data-driven and highly motivated supply chain planner with a proven track record of…
Experience
Supply Chain Planner
Aug 2022 — Present · Union City, CA, US
ERP System and Inventory Optimization: Designed and implemented ERP system logics and parameters tailored for business needs, employing ABCXYZ analysis to establish optimal safety stock levels of products, enhancing inventory turnover rate from 3 to 5. This initiative finetuned inventory management for over configure-to-order lighting fixtures- SIOP Data Analysis and Forecasting: Led demand and supply planning efforts for SIOP meetings by utilizing Power BI for data visualization and applying time series and regression analysis to improve forecasting accuracy by 15%. Supported the Sales team in predicting future orders and ensured material availability by analyzing trends and addressing supply-demand mismatches in monthly and quarterly overview. Collaborated with Operations, Marketing and Sales teams to enhance on-time delivery rates by 8%, reduce excess inventory by $8 million and minimize supply disruptions by 20%- Collaborative Demand Visualization: Create forecast trend data and implement on Power BI to visualize product trend insights. Collaborated with Finance and Operations teams to identify EOL fixture families, incorporating feedback from Sales and Marketing to adjust EOL parameters, effectively reducing excess inventory by $3 million- Quantified Collaboration in R&D Optimization: Partnered with the Engineering team to streamline the Engineering Change Order (ECO) process, resulting in a 30% reduction in product update lead times and a 25% improvement in overall supply chain responsiveness. Ensured that NPL and EOL products were accurately classified and communicated to cross-functional teams for timely product launches- Strategic Sourcing and Cost Analysis: Led nationwide sourcing for acrylic extruded lenses, analyzing material composition, manufacturing processes, and supplier overheads based on production location and material usage. Built data-driven should-cost models to guide negotiations, achieving a 15% cost reduction.
Education
W. P. Carey School of Business – Arizona State University
Master of Science - MS, Logistics, Materials, and Supply Chain Management
Zhengzhou University of Light Industry
Bachelor's degree, E-commerce
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.