Summary
Overview
Work History
Education
Skills
Websites
Certification
LANGUAGES
Timeline
Generic

Sofia Gonzalez

Delft

Summary

Detail-oriented and analytical professional with 5+ years of experience in production planning, order management, and inventory control within supply chain and manufacturing environments. Skilled in extracting and analyzing data from SAP, automating reports using Excel (Power Query, VBA), and creating KPIs to drive process improvements. Proven ability to coordinate cross-functional teams, resolve operational bottlenecks, and support timely decision-making through data. Currently seeking to leverage strong analytical skills and operational insight in a Data Analyst Role.

Overview

11
11
years of professional experience
1
1
Certification

Work History

SALES ORDER OPERATION

KYOCERA DOCUMENT SOLUTIONS
11.2021 - Current
  • Managed the end-to-end order pipeline between Sales Companies and 3PL suppliers, ensuring compliance with SLAs and minimizing delays.
  • Extracted and prepared large datasets from SAP to optimize order allocation and reduce open/back orders through equitable distribution strategies.
  • Analyzed critical metrics including back orders, stock availability, incoming shipments, and high-priority items to support data-driven decisions.
  • Created and maintained dashboards (e.g., JIRA) to monitor tickets and coordinate timely support for Sales Companies and external partners.
  • Automated complex Excel reports using VBA macros, Power Query, and Data Model to increase reporting efficiency and reduce manual workload.
  • Supported sales order creation and resolution of order-related issues, contributing to process optimization and customer satisfaction.

PRODUCTION PLANNER I

YAZAKI
01.2016 - 07.2020
  • Designed and maintained KPI dashboards to report daily performance metrics, including finished goods output, inventory levels, and critical parts, for upper management.
  • Led weekly planning meetings to review and escalate issues related to critical part availability and production risks.
  • Collaborated cross-functionally with planning and logistics teams to resolve material shortages and realign production schedules in response to shifting priorities or line downtimes.
  • Reviewed and adjusted weekly production plans to ensure alignment with capacity, inventory targets, and customer demand.
  • Monitored excess and obsolete inventory, coordinating disposition plans to optimize stock levels and reduce waste.

PRODUCTION PLANNING/BUYER

BASCULAS TORREY
06.2015 - 11.2015
  • Developed and maintained KPIs to track performance of finished goods and part numbers, providing actionable insights to improve planning accuracy.
  • Prepared and managed purchase requisitions for over 500 part numbers based on MRP outputs, ensuring timely material availability.
  • Scheduled and monitored shipments of inbound materials, tracking transit status to prevent delays in production.
  • Collaborated closely with warehouse staff to maintain accurate inventory records and avoid stock discrepancies.
  • Planned and adjusted production schedules in alignment with sales orders and material availability, ensuring optimal workflow and resource utilization.

PRODUCTION SCHEDULING

NACIONAL DE ACERO
03.2014 - 05.2015
  • Developed and tracked KPIs to monitor finished goods performance, supporting continuous improvement initiatives in production efficiency.
  • Oversaw daily execution of the production plan, ensuring adherence to schedules and on-time order fulfillment.
  • Supervised and optimized production line balancing to minimize downtime and support Just-in-Time (JIT) manufacturing goals.
  • Analyzed bills of materials (BOM) versus actual material usage to identify discrepancies, improve stock accuracy, and support inventory optimization.

Education

Degree in Mechanical Engineering - Facultad de Ingeniería Mecánica y Eléctrica

UNIVERSIDAD AUTONOMA DE NUEVO LEON
12.2015

Skills

    Technical & Analytical:

  • Data Analysis & Reporting
    (Excel, Power Query, Data Model, VBA/Macros, KPI creation)
  • ERP Systems
  • Dashboard Monitoring & Support Tools
    (JIRA, ticket resolution, SLA coordination)
  • Microsoft Office Suite
  • Inventory & Supply Chain Management
    (Stock control, excess/obsolete inventory, inbound/outbound coordination)

    • Automation & Efficiency:

  • Process Automation in Excel
    (Macros, scripting, automated reports)
  • KPI Design & Dashboard Creation

    • Soft Skills & Professional Strengths:

  • Cross-functional Collaboration
  • Problem Solving & Root Cause Analysis
  • Attention to Detail & Accuracy
  • Adaptability in Dynamic Environments
  • Stakeholder Communication & Support

Certification

  • Advanced Excel 2010
  • Computer-aided industrial engineering and design (Solidworks)
  • Seven Basic Tools of Quality
  • Lean Manufacturing

LANGUAGES

Spanish
Bilingual or Proficient (C2)
English
Advanced (C1)

Timeline

SALES ORDER OPERATION

KYOCERA DOCUMENT SOLUTIONS
11.2021 - Current

PRODUCTION PLANNER I

YAZAKI
01.2016 - 07.2020

PRODUCTION PLANNING/BUYER

BASCULAS TORREY
06.2015 - 11.2015

PRODUCTION SCHEDULING

NACIONAL DE ACERO
03.2014 - 05.2015

Degree in Mechanical Engineering - Facultad de Ingeniería Mecánica y Eléctrica

UNIVERSIDAD AUTONOMA DE NUEVO LEON

Similar Profiles

CREATE PROFILE
Sofia Gonzalez