PT. Feng Tay Group EnterprisesSoftware Engineer
Apr. 2018 - Nov. 2023Bandung Area, West Java, IndonesiaDesign, develop, maintain and enhance ERP system with oracle environment, integrating internal system with export/import reporting to customs office. Responsibility to modules:
- Purchasing.
- Customs.
- Assets Management (Accounting Sub-module).
- Bank Book.
- Credit/Debit Note.
- Work Shipment.
- Production Scheduling.
- Production Waste Management that integrated to its Customs data. During my work period, I learns a lot about stock warehousing flow start from raw material to finish goods. And also makes me strong in query SQL in a large scale and proficient to designing relational database. In this company too, I'm learns until I'm proficient to develop a PL/SQL using Package, Procedure or Trigger in Oracle based. I contribute the most to Customs, I develop and enhance the system to follow Customs regulation where all purchased materials traceable to its incoming document and match with Customs database. Besides, I also develop Production Waste Management which is didn't exists before, and integrated to usages data, inventory data, incoming data, customs data and purchase order data. I also develop so the system should able to convert incoming unit (in kg) to Recyclable Material Consolidation Centre (RMCC) department into its original unit such as; square feet, square meter, yard, meter, etc.