John Lim Email & Phone Number

Kirkland, Wa, Us

Kirkland, Wa, Us

Seattle, Wa, Us

Seattle, Wa, Us

Bellevue, Wa, Us

Aftermarket Purchasing • Conducted root cause analysis of aftermarket parts’ P/O discrepancy using PowerPivot, Python/R for 300+ suppliers and leveraging data analysis to generate supplier scoreboards to support stakeholders’ understanding of business needs• Developed robust data visualizations using Tableau to support supplier performance evaluations for internal stakeholders, implementing improved aftermarket processes to increase PACCAR Part’s various teams’ efficiency and goal attainment• Generated monthly & quarterly supplier seasonal promotional discounts and marketing funds/rebates using Snowflake relational database warehouse and SQL scripting/querying, saving aftermarket purchasing cost of ~$4-6M quarterly • Examined quarterly and yearly cost change data analysis to assist development of negotiation strategy with suppliers

Seattle, Wa, Us

• Targeted 100% non-delaying continuing student internal application process with the Registrar Office• Consulted prospective students regarding graduate programs’ admissions and its system process • Managed a portfolio of materials for graduate open house, orientations, and information sessions• Evaluated query report performance on Albers digital channels through SEO to team manager• Analyzed and reported weekly prospective students’ marketing portfolios to the Albers School's Director of Marketing & Communication

Seoul, Seoul, Kr

Coupang Eats Department (part of Inaugural/New Market offering team member) • Produced daily & weekly KPI reporting for senior leadership using PowerPivot and shaped KPI findings into actionable recommendations to drive business performance within account management and analytics team • Drove User Acceptance Testing (UAT) using internal software/solution to validate all platform integrations and usability from a user perspective, resulting expansion of customer delivery religions by 500% in 3 months• Conducted competitor and key market analysis to optimize pricing and promotions in collaboration with business partners (sales, sales operation, and client services team), achieving 30-100% WoW & 10-20% MoM increase in total revenue

Seoul, Seoul, Kr

Private Label/Brand Department• Orchestrated the end-to-end supply chain and vendor management process using MS Excel functions (VLOOKUP, SUMIFS, COUNTIFS, etc.) and PivotTable for private brand product categories, ensuring 90%+ on-time fulfillment and product launch• Oversaw the manufacturing lifecycle of and data management for 30-45 distinct private label products• Drove the contract management process for pre-launch product sampling with 10+ manufacturers per day • Served as the liaison for the brand managers and manufacturers, achieving targeted goal of launching 5-10 private label products

Lynnwood, Wa, Us

• Conducted key information gathering and analysis using MS Excel Pivot Table/Power Pivot for clients’ payment card industry (PCI) data security standard (DSS) for credit card fraud prevention, resulting in 97% compliance validation• Oversaw the PCI data management process to configure POS/terminal system with Field Operations Department• Ensured proper integrations between POS and automated clearing house systems and resolution of technical inquiries related to retail batch settlement process – improving client contentment rate from 85% to 92% over 3 consecutive quarters

Master Of Science - Ms, Business Analytics

Bachelor Of Arts - Ba, Economics, International Studies