Xiaojing(Ramona) Bao
Birmingham,United Kingdom
Summary
A detail-oriented planning coordinator who supports production scheduling, prepares materials, and plans capacity across over 40 product lines. Master the Orbit MRP system, leverage advanced Excel functions, and communicate cross-departmentally to ensure precise schedules, resolve material shortages, and boost on-time delivery rates. Maintain composure and focus on solving problems in fast-paced environments. Consistently manage workflows with precision and efficiency.
Overview
1
1
year of professional experience
4
4
years of post-secondary education
Work history
Junior Planning Coordinator
Ultron Technologies
Birmingham
10.2025 - 11.2025
- Develop and maintain daily, weekly, and monthly production schedules across 40+ product lines, ensuring alignment between OPO demand, material readiness, BOM accuracy, and SMT/THP line capacity.
- Utilize the Orbit MRP system for order release, BOM verification, WIP tracking, kit status checks, and capacity validation to ensure feasible production plans.
- Coordinate with procurement, engineering, production, and sales to resolve shortages and material mismatches. Address schedule conflicts in time-sensitive environments.
- Monitor line output, backlog, and delivery risks to ensure optimal performance. Prepare real-time planning and shipment reports to support decision-making.
- Support NPI planning by coordinating engineering updates and material availability. Schedule trial builds and manage cross-team communication.
- Achievements and Impact
- Planned and coordinated production for 40 product lines. Supported USD 407k in on-time shipments in one month, improving OTD performance.
- Rebuilt a monthly shipment tracker covering 30+ shipment lines. Increased data accuracy and enabled double-digit improvement in release-to-dispatch speed.
- Enhanced material readiness by analysing supply plans and material flow. Reduced delays and improved alignment between demand, kit availability, and capacity.
- Improved visibility of production performance through structured reporting and daily reviews. Helped managers identify bottlenecks and reduce last-minute rescheduling.
Summer Internship
Ultron Technologies
Birmingham
07.2024 - 09.2024
- Executed eBay marketing campaigns with integrated visuals and copy, generating 48 product sales and £500+ revenue in 2 months.
- Built Excel-based tracking tools for 13 SKUs package usage, reducing packaging waste and improving procurement decisions.
- Processed courier documentation and initiated compliance checks during recovery of a £42,000 shipment, preventing production delays and insurance claims.
- Reorganised warehouse workflow for 100+ raw materials, maintaining updated stock records and improving reporting accuracy.
Education
MSc - Urban Development Planning
University College London
09.2024 - 09.2025
BA - Urban Planning
University of Liverpool
09.2021 - 07.2024
Skills
- Technical Skills: MRP/ERP: Daily use of Orbit for order release, BOM checks, WIP tracking, and material readiness Production Planning: Daily/weekly scheduling, capacity checks, demand–supply alignment Excel: PivotTables, VLOOKUP/XLOOKUP, SUMIFS, tracking, and reporting Inventory & Materials: Kit readiness, shortage analysis, stock accuracy
- Soft Skills: Cross-functional communication (production, engineering, procurement, sales) Problem-solving and prioritisation Attention to detail and accuracy Process improvement mindset
SKILLS and LANGUAGES
English
Native
Chinese (Cantonese)
Upper intermediate
Chinese (Mandarin)
Native
Timeline
Junior Planning Coordinator
Ultron Technologies
10.2025 - 11.2025
MSc - Urban Development Planning
University College London
09.2024 - 09.2025
Summer Internship
Ultron Technologies
07.2024 - 09.2024
BA - Urban Planning
University of Liverpool
09.2021 - 07.2024