William Yeh
IT Assistant Manager
Wenshan District, Taipei
Summary
Dynamic IT and Digital transformation professional with a proven track record by my past project experiences, specializing in RPA/AI tools ,BI/ETL/data analytics tools and Digital transformation strategy. Excelled in implementing digital transformation projects and optimizing supply chain systems, achieving a 20% cost reduction. Demonstrates strong data-driven visualization analytical skills and a commitment to efficiency.
Overview
21
21
years of professional experience
6
6
years of post-secondary education
2
2
Certifications
3
3
Languages
Work History
IT Assistant Manager
Taiwan Semiconductor IT Department
07.2023 - Current
- Develop and implement operation intelligent and analytics platform (Financial/Sales/Supply Chain/Manufacture) to integrate multiple data sources and pipeline into Power BI in Cloud/Web/App/Teams to improve 10% operation efficiency with BI/RPA/ETL tools.
- Develop and implement digital transformation projects with Microsoft consultants.
- Develop automated report and RPA automated operation flow(Oracle EBS/Web AP/Excel/Mail/Window/OCR) in operation automated center to save a lot of time for human resources and provide 7X24 AI robot service with AI/RPA and VBA/Macro.
- Implement Oracle MRP with Oracle supply chain consultant.
Senior Specialist
Pegatron Supply Chain Development Department
01.2009 - 06.2023
- Implement and lead a service team to coordinate with global users for serving and real time problem-solving in supply chain platform(SCM/e-Procurement/e-Logistic/e-Green/eBid/ESG).
- Develop automated operation report with RPA and Power BI to reduce cost by 20%.
- Validate and test each program for software reliablity before a new system launches.
- Develop supply chain system with ASP.NET MVC and teach global users how to do with supply chain and RPA.
- Optimized Pegatron best pratice flows in supply chain /eLogistic/eGreen system.
- Develop RPA automated flow in SAP/Excel/Pdf OCR/Mail/Web App/Window App to save a lot of time for user's routine jobs.
Software Engineer
ASUS Computer Center
03.2006 - 12.2008
- Introduce and implement IBM SSO in ASUS IT systems with IBM consultants with automated verification to save time.
- Develop ASUS automated intelligence visualization reports and dashboard with Oracle BI tool for business analytics.
- Develop ASUS supply chain system with ASP.NET to improve 20% supply chain management efficiency.
Senior Automation Engineer
AUO Facility Automation Department
10.2003 - 02.2006
- Built AUO’s two 6th generation TFT-LCD FAB plants
- Plan and implement for automation equipment management(specification/capacity scheduling/implementation/coordination/validating /move-in) and continuous improvement for automated manufacturing.
- Efficiency improvement and trouble shooting for AMHS equipments(AGV/RGV/OHV/Robot/Conveyor) and MCS software/SEMI standard.
- Develop automated management report and dashboard for AMHS equipment management.
Education
MBA - Information Management
Tamkang University
New Taipei City 09.1999 - 06.2001
BBA - Information Management
Tamkang University
New Taipei City 09.1995 - 06.1999
Skills
RPA tools(Power Automate/Uipath)
BI Tools(Power BI/IBM Cognos/DAX/Oracle Hyperion)
ETL Tool(SSIS/AZURE Data Factory/AZURE Synapse Analytics)
VBScript/VBA
Oracle EBS MRP/PL-SQL
Power Platform/Microsoft(EXCEL/Word/Power Point/Visio/Access/Project)
ASPNET MVC/C#/AZURE Open AI/AI Builder
Java/Javascript/SAP PP/SAP MM/K8
IBM SSO Production(webseal, DB2,ITDI, LDAP, MQ, Websphere))
SQL Server/OLTP/T-SQL
Certification
SCJP
Timeline
IT Assistant Manager
Taiwan Semiconductor IT Department
07.2023 - Current
Senior Specialist
Pegatron Supply Chain Development Department
01.2009 - 06.2023
Software Engineer
ASUS Computer Center
03.2006 - 12.2008
Senior Automation Engineer
AUO Facility Automation Department
10.2003 - 02.2006
MBA - Information Management
Tamkang University
09.1999 - 06.2001
BBA - Information Management
Tamkang University
09.1995 - 06.1999
Similar Profiles
YI KAI CHANYI KAI CHAN
R&D Lithography Metrology Engineer at TSMC Taiwan Semiconductor Manufacturing CompanyR&D Lithography Metrology Engineer at TSMC Taiwan Semiconductor Manufacturing Company
YA-HSIEN WANGYA-HSIEN WANG
Intelligent Manufacturing Engineer at Taiwan Semiconductor Manufacturing Company LimitedIntelligent Manufacturing Engineer at Taiwan Semiconductor Manufacturing Company Limited
Cheng-Hung Lin (Wilson)Cheng-Hung Lin (Wilson)
R&D Process Integration Engineer at Taiwan Semiconductor Manufacturing Co., Ltd.R&D Process Integration Engineer at Taiwan Semiconductor Manufacturing Co., Ltd.
Yu-Tung LinYu-Tung Lin
Business Development Assistant at LLAC Group Inc.Business Development Assistant at LLAC Group Inc.
Kelvin ChangKelvin Chang
Translator at FreelanceTranslator at Freelance