Alan Yi

Experience

• 

  Camino Apparel, Inc

  Apr 2014 - Aug 2014

  Floor Manager

  -Involved with the distribution, handling, and packaging of materials

• 

  Descanso Garden Spa

  Nov 2015 - Jun 2016

  Front Desk Coordinator/Assistant Manager

  -Management of scheduling and liaison between upper management and base employees-Responsible for system set up and training of employees (POS[UpSolutions], TimeTrax)-Customer Service Representative-Supported upper management by observing, assessing, and analyzing elements of the business for improvement

• 

  KW Industrial Management, Inc.

  Dec 2016 - Sept 2017

  Data Analyst/Quality Assurance Analyst/Project Management

  -Tracking service information using SAP and in-house proprietary systems and external enterprise databases-Focusing on trend analysis and agent performance using Key Performance Indicators-Data management using Microsoft Excel with advanced functions (vlookup, pivot tables, etc.)-Collect, process, compile, and analyze data to produce daily, weekly, monthly ad hoc reports for clients and internal teams-Work with a cross-functional team to launch and manage multiple projects within specifications and budget restrictions-Establish and maintain liaisons with internal departments, employees, and third party groups to provide accurate, clear, and concise recommendations to upper management and propose business project solutions based on analyzed project data-Review, research, and evaluate contracts, legal documents, and agreements Show less

• 

  Amazon

  Sept 2017 - now

  • Created and developed CDL Training Schedule Plan to forecast projections for the network (300+ sites) for CDL training impacting OTR (over the road) expenses and support network-wide transportation initiativeso Streamlined and developed model identifying a failure to CDL train additional associates would generate a 309% increase in 3P shuttling hours reliance translating to a potential increase of $40MM in expenses in 2023. Additional CDL training in 2023 would enable cost savings of $61MM and $131MM in 2023 and 2024 respectively Show less - Simplified and reduced manual work by automating analysis/reports of indirect Supply Chain verticals and providing data visualization through Quicksight for external/internal stakeholders- Coordinated with cross-functional teams from Procurement Operations (NA & EU), Operations Support teams, Finance/FinTech, Business Intelligence and tech teams to develop strategic/tactical planning as well as defining parameters of KPIs/metrics to drive process improvements including: supplier inventory, count accuracy, planner efficiency, AP invoice holds, etc.- Designed, implemented, and support platforms (Quicksight data visualization, Excel) to provide ad-hoc access to large datasets- Identified process gap for bulk requisition creation capturing 8000+ requisitions/PO’s with significant discrepancies regarding payment period and provided process improvements to bridge gaps- Created labor plan that allowed for automation of manual manipulation, forward-looking calculations of headcount, accounted for training weeks, and simplified template to allow for sustainability and scalability for additional data points (additional teams, site types, etc.) as well as identifying and correcting multiple discrepancies that accounted for inaccurate headcount calculations. Show less - SME on COVID-19 PPE Allocations process and trained, supported, and managed workflow of 3 specialists- Developed deep dive analysis of allocations of PPE supplies to identify opportunities of growth to close gaps for GCF and ATS networks. Provided weekly reports for deep dive by POAs/POMS/iSChOC for increased visibility on gaps.- Supported launch of 3PL allocation process and maintained communication with 3PL sites and provided analysis to streamline allocations process driving down lead times from 15+ days to 10-12 daysCOVID-19 Allocations Project:- Created and developed automated reports tracking critical items (PPE supplies, testing kits), KPI, usage, and DOH analysis of 1500 sites in response to COVID-19 using databases (Quicksight, Siphon, internal Quips/Excel) to provide clear and concise visualization of response to senior leadership- Provided analysis for distribution and allocation of 100MM+ of units of PPE supplies to 1500 sites across continental US while maintaining storage limitations, ensuring safety compliance, and mitigating risks from supply chain disruptions.- Implemented process improvements based on analysis of current SOP to increase accuracy of analysis while optimizing process to reduce churn, allowing for headcount to be reduced by more than 50% Show less - Provide support for Fulfillment Centers, Sort Centers, 3PL, etc., including: forecasting of non-inventory products, inventory management, non-inventory flow and space models, cycle counts, procurement transaction and expediting support- Coordinate the demand identification, procurement, and inventory management of all non-inventory items required for building operation- Work in partnership both internally and with external suppliers/vendors to develop innovative solutions to provide Indirect Supply Chain support to the Operations network- Implemented multiple process improvements: standardization and optimization of workflow processes, created a tool allowing for increased accuracy of KPI tracking and reducing churn by 300%, and introduced multiple methods/tools for data management- Certified Floor Trainer and subject matter expert tasked with training newly hired associates/specialistsCOVID-19 Allocations Project: - Created and developed automated reports tracking critical items (PPE supplies, testing kits), KPI, usage, and DOH analysis of 1500 sites in response to COVID-19 using databases (Quicksight, Siphon, internal Quips/Excel) to provide clear and concise visualization of response to senior leadership- Provided analysis for distribution and allocation of 100MM+ of units of PPE supplies to 1500 sites across continental US while maintaining storage limitations, ensuring safety compliance, and mitigating risks from supply chain disruptions.- Implemented process improvements based on analysis of current SOP to increase accuracy of analysis while optimizing process to reduce churn, allowing for headcount to be reduced by more than 50% Show less -Investigation and root cause analysis/resolution for Fulfilled by Amazon (FBA) Merchant and Customer Issues-Assist with the definition and design of improvements to software (tools), creation of standard operating procedures and processes for Amazon's Fulfillment Center Operations, Technical Account Management for Merchants (TAM) and Customer Service (CS) associates.-Participated on project to retroactively provide proper reimbursements to customers due to software glitch totaling $500,000-Audit of agent performance for quality analysis Show less

  • Business Analyst II/Program Manager II

    Apr 2023 - now

  • Labor Planning Analyst I (Business Analyst I)

    May 2022 - now

  • Program Analyst

    Mar 2021 - May 2022

  • Team Lead

    Aug 2020 - Mar 2021

  • Supply Chain Specialist

    Oct 2019 - Aug 2020

  • Investigation Specialist

    Sept 2017 - Oct 2019