Supply Chain Planning Analyst optimizing operational efficiency with data-driven solutions

PROFESSIONAL SUMMARY

Results-driven Supply Chain Planning Analyst with 7+ years of experience optimizing inventory, streamlining processes, and developing powerful forecasting tools. Skilled in Power BI, Alteryx, SQL, and Excel automation to drive efficiency and enable data-driven decision-making. Proven track record in reducing operational costs, supporting ERP migrations, and leading cross-functional planning initiatives. Collaborative, accountable, and focused on continuous improvement.

WORK EXPERIENCE

WireCo – A Global Steel Rope Manufacturing Company

Supply Chain Planning Analyst  May 2021 – Present

  • Designed and manage global forecasting tools using Alteryx, SQL, and Power Query to drive SIOP planning, inventory modeling, production scheduling, and capacity alignment, enhancing decision-making accuracy.

  • Collaborates cross-functionally with finance and operations teams to optimize inventory levels and improve on-time delivery performance, resulting in better operational efficiency.

  • Created and implemented a container tracking system, significantly improving product flow visibility from international suppliers to the U.S., reducing lead times and improving logistics coordination.

  • Supported a successful ERP migration from Domo to QLIK BI by modeling data, validating tools, and restructuring reporting processes, ensuring a smooth transition and enhanced reporting capabilities.

  • Enhanced department onboarding processes by developing comprehensive SOP documentation and quick-reference guides, improving training efficiency and team productivity.

  • Led a $4.7M reduction in U.S. crane rope inventory as part of a $13M national inventory optimization initiative, boosting cash flow and freeing up working capital for reinvestment.

  • Manages interactive dashboards used by U.S. Planning Operations to ensure optimal inventory ordering, improving accuracy and efficiency in supply chain operations.

  • Oversee customer forecasting for US operations, facilitating streamlined integration of customer demand data into overall planning processes to ensure accurate demand forecasting and alignment with production schedules.

  • Developed comprehensive global KPI dashboards with 12-month visibility into inventory, production, and demand, enabling data-driven strategic decisions and standardizing reporting across the Steel Division.


Panasonic Connected Solutions – Panasonic North America Subsidiary

Inventory Control Manager              Nov 2020 - May 2021

  • Analyzed high-volume data sets to direct logistics for mobile asset repairs in factory settings.

  • Led a team of inventory and production specialists to enforce process consistency and efficiency.

  • Rebuilt and streamlined the inventory reporting processes across the company to achieve optimal efficiency using data queries and pivot tables.

  • Ensured just-in-time inventory by working with Panasonic's SCM team so high-demand parts remained in stock.

  • Assisted with statement-of-work negotiations with Panasonic/PIVS by pulling a large amount of historical data through Power Query in Excel and developing dashboards to display the results to the executive team.

  • Implemented Macro/VBA solutions to automate daily company reports on backorder and high-usage parts

    Inventory Specialist              April 2016 - Nov 2020

  • Led receiving operations and supported the transition to a 33K sq. ft. facility, improving workflow efficiency.

  • Analyzed inventory trends and collaborated with leadership to adjust stocking strategies.

  • Organized storage systems to improve material movement and minimize labor.

    Shipping and Receiving Associate             June 2011 - April 2016

  • Prepared and processed shipping documents, including work and shipping orders, route materials, and bills of lading.

  • Compared shipment contents with paperwork to support inventory accuracy and record management.

EDUCATION

  • Bachelor of Business Administration, with a Minor in Healthcare Information Management - The University of Kansas - Class of 2019

  • IBM Data Science Certificate, Coursera - Issued – 2020

    • In this Professional Certificate learners developed and honed hands-on skills in Data Science and Machine Learning.

    • Learners started with an orientation of Data Science and its Methodology, became familiar and used a variety of data science tools, learned Python and SQL, performed Data Visualization and Analysis, and created Machine Learning models.

    • In the process they completed several labs and assignments on the cloud including a Capstone Project at the end to apply and demonstrate their knowledge and skills.

  • Alteryx Designer Core Certification   - Issued - 2022