PT. Wahana Interfood Nusantara TBK.

About This Experience

Admin – Research & Development / Admin All Roles

Sep 2022 – May 2024 · 1 yr 9 mos · Bandung, West Java, Indonesia

Initially served as Admin Research & Development and later assigned to a newly established subsidiary as Admin All Roles, handling multi-departmental administrative and operational tasks. Demonstrated strong adaptability across Production, Warehouse, R&D, General Affairs, PPIC, and Purchasing functions.

Production Department

Created production result forms and Excel-based recipe usage history records.
Compiled and calculated production capacity comparisons between actual and estimated daily/monthly outputs.
Coordinated production flow with operators and monitored recipe utilization accuracy.

Warehouse Department

Prepared delivery and receipt documents while verifying product quantities.
Created Excel forms for goods arrival, COA storage, and supplier data management.
Implemented the First In, First Out (FIFO) inventory principle.
Designed stock in/out tracking forms using Excel and applied Pivot Tables for summary analysis.
Automated production-issued materials tracking using ArrayFormula and Query in Google Sheets linked with Google Forms.
Conducted monthly stock opname with minimal acceptable discrepancies.

Research & Development Department

Documented product development and research processes.
Created formula calculation sheets and managed material quantity analysis.
Performed organoleptic testing of raw materials (taste, color, appearance) and documented results using interactive Excel hyperlinks.
Coordinated the formula handover process for production use.
Developed Google Sheets for trial progress tracking until product acceptance.
Summarized accepted product reports on a monthly basis.

General Affairs Department

Managed raw material purchasing and expense tracking.
Created Excel forms for procurement and financial expenditure documentation.

PPIC Department

Reviewed and verified R&D formulas used in production.
Calculated material requirements for production based on Order To Fulfill (OTF) data using automated Excel forms.
Planned production schedules and coordinated shift assignments according to warehouse material availability.
Developed progress tracking forms for Pre-Orders and OTF monitoring.