Browse categories
Explore
Fiverr Pro
English
$
USD
Looks Like This Service Is On Hold
I will build advanced factory scheduling and optimization systems
Piamsak MSK
About this gig
Are you struggling with complex production schedules and inefficient resource allocation?
With over 20 years of experience in Production Planning, IT, and Management within the manufacturing industry, I dont just write codeI build practical solutions that work on the actual shop floor. I understand the "Genba" (actual place) and the real challenges of factory operations.
I specialize in creating Custom Optimization Engines using Python and Google OR-Tools (CP-SAT Solver) to transform your manual, time-consuming planning into a high-precision automated system.
What I can do for you:
- Smart Scheduling: Multi-machine, multi-skill, and complex constraint handling.
- Resource Optimization: Minimize idle time and maximize machine utilization (OEE).
- Real-time Dashboards: Implement "Mieruka" (Visual Control) using Firebase and Node.js.
- Lean Integratio
Get to know Piamsak MSK
Piamsak MSK
Production Planning and Scheduling Expert, Python, Excel VBA, Firebase, Digital
- FromThailand
- Member sinceJun 2022
- Avg. response time1 hour
Languages
Thai, Japanese, English
With 20+ years in production planning, procurement, and IT systems, I bring real factory expertise to every project.
I specialize in Excel, VBA, Power Query, Power Pivot, SQL, and AS/400 to build practical solutions for scheduling, data automation, and optimization using OR and heuristic models.
I do not just write code. I understand manufacturing from the inside.
Services:
Production planning and scheduling
Excel and VBA automation
Power Query and Power Pivot analysis
SQL reporting and queries
OR and heuristic optimization
AS/400 support
Let us turn your challenges into smart solutions.
My Portfolio
FAQ
1. What information do I need to provide to get started?
Answer: To design the best logic, I need a clear description of your production process, your current scheduling method (e.g., Excel sample), and a list of constraints (machine capacity, labor shifts, material availability).
2. Can your system handle complex constraints like machine maintenance or priority orders?
Answer: Yes, absolutely. My engine built with Google OR-Tools is designed to handle multi-level constraints, including preventive maintenance windows, varying machine speeds, and dynamic order priorities.
3. Do I need to pay for any expensive software licenses?
Answer: No. I use open-source technologies like Python and Google OR-Tools, which are free for commercial use. If you choose the Cloud Dashboard option, we will use Firebase's free tier, which is usually sufficient for most factory operations.
4. Can you integrate this system with my existing Excel sheets or ERP?
Answer: Yes. The system can read and write data directly from Excel, CSV, or SQL databases. I can also build integrations for legacy systems like AS/400 or modern ERPs via API.
5. Do you offer support after the system is delivered?
Answer: Yes, I provide a support period (depending on your package) to ensure the system runs smoothly and to help your team adjust to the new automated workflow.
