Johnrey Ygot

Results-oriented Logistics and Operations Manager with over 14 years of experience in supply chain planning, inventory management, and data analysis for e-commerce and manufacturing industries. Proven track record in managing multi-warehouse inventory, forecasting demand, optimizing reorder points, and coordinating with 3PL providers to ensure timely, cost-effective fulfillment. Expertise in leveraging Power BI, Advanced Excel, and SQL to drive data-backed decisions, reduce operational costs, and maintain 60+ days of safety stock across 20+ SKUs.

Operations Data Analyst / Planner - Skinlycious - Remote

(2021-03)

• Oversee inventory levels for 20+ SKUs across USA and China warehouses, ensuring consistent stock availability. Calculate reorder points based on sales velocity and lead times to prevent stockouts and overstocking.
• Coordinate with China-based suppliers and USA 3PL providers to manage inbound/outbound shipments, ensuring timely replenishment and accurate order fulfillment.
• Compile and integrate sales data from Shopify, WooCommerce, and Amazon FBA into a unified reporting system. Develop interactive Power BI dashboards tracking inventory turnover, fulfillment accuracy, and shipping costs.
• Analyze historical sales data and market trends to accurately forecast demand, supporting strategic purchasing decisions and minimizing carrying costs.
• Generate financial reports to support accounting and pricing strategies, ensuring alignment with overall business goals.

Loyalty Perks Administrator - Lexmark Research and Development - Remote

(2019-08 - 2024-12)

• Validated reseller claims by verifying serial and part numbers, resolving disputes, and maintaining accurate data records for key accounts (CDW, DMR, Insight).
• Spearheaded the transition to a new Loyalty Perks platform and created a Power BI dashboard for real-time data visualization and performance tracking.
• Delivered monthly reports to stakeholders, ensuring transparency and data-driven decision-making.

Sales & Marketing Support - Lexmark Research and Development

(2015-12 - 2019-08)

• Supported the North America Enterprise Sales team with Salesforce reporting, deal desk quote management, and Anaplan forecasting.
• Managed inbound calls for warranty renewals and created sales opportunities, building strong relationships with stakeholders.
• Sourced and qualified leads, uploading accurate contact information into Salesforce and Eloqua to support marketing campaigns.

Business Planning & Financial Analyst - Author Solutions Inc.

(2013-07 - 2015-12)

• Generated and distributed daily sales reports across multiple imprints, reconciling monthly sales and calculating commissions.
• Analyzed e-book sales from diverse online sources, identifying key sales contributors and performance trends.

Material Planner - Taiyo Yuden Philippines Inc.

(2012-02 - 2013-07)

• Generated material plans based on production schedules to ensure continuous supply chain operations.
• Monitored material shelf-life and stock levels to prevent expiration and depletion, optimizing inventory by reviewing usage forecasts.

Continuous Improvement / Process Engineer - Metro Wear Inc.

(2011-06 - 2012-02)

• Led Lean Six Sigma projects to enhance manufacturing efficiency, including an embroidery efficiency initiative.
• Conducted root-cause analysis on production issues and balanced production lines to meet output targets.

Master - Industrial Technology - Cebu Technological University – Main Campus (2024-03)

Bachelor of Science - Industrial Engineering - Cebu Technological University – Main Campus (2011-03)