Pang How Tan Email & Phone Number

Singapore

• Collaborated with internal stakeholders to gather business requirements through requirement analysis.• Developed, maintained and enhanced Siltronic’s in-house .NET applications (including WinForms, web, and console).• Created test data and conducted extensive User Acceptance Testing (UAT) with users and documented outcomes meticulously to ensure robust software quality.• Managed the Oracle database schema, created efficient stored procedures, and scheduled data loading jobs based on application requirements.• Ensured up-to-date system documentation by providing technical documentation for both newly developed and pre-existing applications.• Offered next level support for production application issues in a timely manner when needed.• Translated company’s English articles into Mandarin articles.

Singapore

Singapore, Singapore

- Collaborated with 3 other team members and liaised with PIL Chief Engineers to understand the pain points of predicting purchase order trends that had caused overstocking and increased inventory cost.- Communicated and analyzed as a team, defined project scope, categorized spare parts, proactively liaised with managers to intuitively enquired on demands alongside specific requirements, and to understand all the fields in raw data.- Successfully cleaned data which have many discrepancies and identified the main components that had contributed to the largest cost based on historical data, using Excel and Tableau.- Developed comprehensive and interactive data visualization on Tableau Dashboard, providing insightful analysis and improving process of material procurements. Presented results to senior management, received positive feedback and requests for additional enhancements.

Singapore

- Performed daily server backups at various sites, assisted technicians in analyzing faulty parts through monitoring and maintaining data of ventilation system of commercial and industrial buildings.- Developed a prototype backend server using MySQL and Node JS as a side project and handed over to supervisor at end of internship.

Bachelor Of Engineering - Be, Industrial Engineering

Bachelor Of Engineering - Be, Industrial And Systems Engineering