My resume: Sina Dorostkar | Hamadan Glass Company

---

📄 Foreign Procurement Specialist

Hamadan Glass Company (Public Joint Stock)
Tehran, Iran
Oct 2022 – Present

🎓 Educations

• Master's in Industrial Management (Production & Operations)
  University of Tehran, 2022 – Present (GPA: 18.60) – Ranked 14 in national entrance exam
• Bachelor's in Industrial Management
  Allameh Tabatabaei University, Tehran, 2017 – Present (GPA: 18.97)

---

📌 Responsibilities:

• Managed foreign order registration, customs clearance, and document processing.
• Coordinated with suppliers, freight forwarders, and inspection agencies.
• Reviewed documents including PI, PL, BL, CO, and Inspection Certificates.
• Handled contract reviews and Incoterms compliance.
• Oversaw transportation and documentation workflows end-to-end.

🏆 Key Achievements (the projects were led by Sina Dorostkar):

• Mapped the full procurement process using Visual Paradigm Software.
• Built data pipelines using Excel, SQL, SSIS, and Power BI.
• Developed a T-SQL vendor recommender system using historical data.
• Created a Python-based desktop tool to extract invoice data into Excel.
• Designed a GPT-powered "Commercial Documents Analysis" model to detect discrepancies, compare contracts, and extract structured data for database use.

📦 Highlight Project:

Project: Design and development of a comprehensive foreign procurement software system

Client: Hamadan Glass Company (Public Joint Stock)

Date: May 2025

This project involved building a complete software tool to manage the full cycle of foreign orders including:

• Event and milestone tracking with full historical logs
• Data stored in SQLite with export to CSV and PDF
• Price comparison for items, transporters, and suppliers with analytics
• Import timeline prediction using historical data
• User-friendly UI with checklists and guidance
• Operational for daily use & strategic reporting