Kian Linn

Business Analyst

Nike•  January 2019 - Present

Digital Preseason - Business Analyst Rotation Program Aug 2021 - Current • Develop SQL queries for Alteryx workflows to streamline and automate analysis and reporting for validation exercises, orderbook audits and coverage reporting • Design Tableau dashboards on orderbook supply coverage (15M+ units/season) to provide insights on supply status and air freight decisions • Increase the reach of dynamic coverage reporting data creating space to provide more granular data since we are reporting on multiple seasons • Minimize NA shipping risk by ensuring multi-sourced product aligns with outbound capacity forecasts via order writing audit • Reduce the unit count requiring rewrites from 12M+ units in SU22 to 0 units in FA22 by conducting knowledge transfers with the planning teams • Support our planning partners with ad-hoc requests related to supply ETAs for launch product, orderbook audits, and other strategic initiatives Authenticators - Business Analyst Rotation Program Feb 2021 – Aug 2021 • Led 5-month operational ship goal forecasting for the Authenticator business with collaboration from the Specialist Leads and other BAs • Increased at-once shipping performance 8% by influencing at-once orderbook policies and tightening the supply visibility window • Automated ship goal reporting in Alteryx by condensing multiple streams of work from cross-functional teams into a single process • Supported demand/inventory planning teams regarding Vietnam factory closures with ad-hoc supply analysis requests • Trained Authenticator Org. to interpret and analyze ship goal data for forecasting In-Season Execution Jan 2019 - Feb 2021 • Influenced senior leadership decisions for entire North America geo through detailed storytelling using complex data and key insights from marketplace • Managed decisions and tradeoffs regarding supply expedites, reporting processes, forecast processes and DC inbound and outbound prioritization to ensure that we are in line with our overarching supply chain strategy • Drove and facilitated end to end submission of 5-month Ship Goal forecast for North America geo (over $1B in revenue per quarter) • Collaborated with our development teams to build out web tools and create logic for Tableau dashboards to support forecasting processes and reporting to improve user experience and forecast accuracy