YU-HSIANG, HSU (Shawn) 中文履歷

B2B/CRM | ERP | CIM | Programming | Data Analysis | Project Management

  • 7~8 years of experience in software development and project management for the semiconductor and electronic components industries.
  • Integrate B2B transaction data (ERP and MES) into the ERP system of the global supply chain.
  • Data analytics and visualization, software development, distributed architecture design.
  • SQL performance tuning, heterogeneous distributed database to integrate data from different databases.
  • Using deep learning to detect objects

   Tainan, Taiwan     

Skills

  • Languages: Mandarin (native), English (Intermediate)
  • Programming:  C#, Java, SQL, Python, PL/SQL, webMethods&RosettaNet, VB6, VB.NET, VBA, WinForms, Windows Mobile, Dapper, DevExpress, NUnit, NLog, distributed systems.
  • Web: HTML、CSS、JavaScript、ASP.NET MVC、Web API、Web Service 

  • Version control: Azure DevOps Server, Git, SVN, VSS.

  • Databases: Oracle DB, Oracle DB Gateways, SQL Server, SQLite.

  • Server&Virtualization: IIS、Nginx、Windows Server、Windows CE、Solaris、VirtualBox.

  • Management and analytics: Project management, ITIL, 8D Report, statistics, Excel, Tableau.

  • ML&DL: YOLO、Darknet、Pandas、Seaborn 

  • Others: SoftwareAG webMethods, SAP, emergency medical technician, financial accounting. 

Work Experience

ERP Software Engineer

ChipMOS TECHNOLOGIES • 2022/12 - Now • Tainan, Taiwan 

Skills: C# / Oracle SQL / WinForms / ASP.NET MVC / SVN / OracleDB / NUnit / Tableau / ChatGPT / Prompt Engineering / SAP 

Target: Development, maintenance, project planning, and BI data analysis for the ERP 2.0 and SAP.

Job Description:

  • The ERP PP module integrates 7 manufacturing processes, from production to warehousing of finished goods, and links to the SD module for shipping to approximately 50 customers or end-users. This integration is done within SAP.
  • The original 4GL programs were converted to C#, with partial translation using ChatGPT, resulting in over 200 converted programs, optimized and integrated.
  • Program performance and SQL performance reduce the average execution time by about 25%~75%.
  • Using Tableau for data analysis and visualization.

Project: (Benefits: About 5,000 users, include modules PP, MM, SD, FI, CO, OA, etc., with annual orders reaching up to billions.)

  1. ERP: Finished goods completion and warehousing, label printing and check, material budget analysis.
  2. B2B: Material forecasting from Micron, estimated yield calculation.
  3. BI Data Analytics: ESG transportation carbon emissions calculation, historical employee turnover rate analysis.

For UMC On-site service - CIM Software Engineer

IS-Land Systems INC • 2018/12 - 2021/3 • Tainan, Taiwan 

Skills: C# / Oracle SQL / WinForms / Python / YOLO 3&4 / Darknet / DevExpress / MSMQ /GIT / TFS / Oracle DB / RPA Sikuli

Target: Based on Applied Materials E3 system and integrated with the FDC UI, and product development for the AI CCTV system.

Job Description:

  • Developed AI image recognition for CCTV Phase 1 to 2, implementing a distributed architecture designed for GPU scalability,  achieving a false positive rate of less than 10% and saving approximately $20 million in costs for UMC.
  • The FDC UI system ensuring error detection within 3 standard deviations. Additionally, functionalities related to wafer manufacturing processes, UI development, data analysis, and visualization.
  • Program performance and SQL performance reduce the average execution time by about 25%~75%.
  • The code coverage depends on different systems, with an average of about 40~70%.

Project: (Benefits: The AI system impacts all chemical-related work areas, resulting in a cost reduction of $20 million.)

  1. AI Application: The AI image recognition system for chemical tanker violation detection.
  2. FDC: The FDC UI retrieves statistical data from Hadoop for conducting univariate analysis simulations and control charts.
  3. Others: Cross-FAB Compare (comparing recipe parameters across different data sources).

B2B Project Engineer

WPG Holdings Limited • 2018/5 - 2018/11 • Taipei, Taiwan 

Skills: C# / Java / webMethods&RosettaNet / Oracle SQL / ASP.NET MVC / GIT / Oracle DB

Target: Integrate B2B transaction data (ERP) into the global supply chain's ERP system for transaction automation.

Job Description:

  • B2B relationship management, receive the demand, coordination, and reporting cases.
  • Drawing the company's business process diagram, including procurement, orders, requisitions, quoting, warehousing, shipping, etc., primarily comprising about 20 transaction types.
  • Migration of webMethods from version 9.6 to 10.1 involves approximately 30 programs and Java crawler development.
  • Inventory checks for approximately 10 outsourced warehouse agents.

Project: (Benefits: About 10 suppliers engaged in global transactions have been automated. Annual orders amount to billions.)

  1. B2B: development for suppliers such as TI, STM, Micron, Marvell, etc., including 3A1, 3A4, 5D1, 4B3, 3C3, 3B2, 3A8, and 3A7.
  2. Others: webMethods Migration from version 9.6 to 10.1.

Navy Software Engineer

U&U ENGINEERING INC  •  2017/4 - 2017/12 • Kaohsiung, Taiwan 

Skills: C# / Java / Oracle SQL / WinForms / ASP.NET / Windows Mobile / Oracle DB Gateways / Acunetix / Solaris / Oracle DB

Target: development and design of the Navy Logistics System (ERP System), and enhance cybersecurity risk management.

Job Description:

  • .NET development (WinForm, ASP.NET), UI design, PDA program maintenance, and development.
  • A heterogeneous distributed database to integrate data from 5 naval base branches.
  • System vulnerability scanning improvement (medium and high risk is 0, low risk is within 50).

Project: (Benefits: Include all Navy bases in Taiwan, reduce manual 6 hours per day, saving approximately $9 million.)

  1. Logistics: Weapon System Files, Naval Shipyard Maintenance Management, Warehouse Management, Anti-Submarine Aircraft Data Conversion.
  2. Others: Oracle heterogeneous database connectivity, website vulnerability scanning report risk handling and analysis.

Group IT-B2B Software Engineer

Advanced Semiconductor Engineering, INC.  •  2013/12 - 2016/9 • Shanghai, China; Kaohsiung, Taiwan.

Skills: C# / Java / webMethods&RosettaNet / Oracle SQL / PL SQL / VB6 / WinForms / ASP.NET / VSS / Solaris / Oracle DB

Target: Integrate B2B transaction data (ERP and MES) into the global supply chain's ERP system for transaction automation.

Job Description:

  • The correctness of transaction data (close to 98%), and customer satisfaction (not less than 70%).
  • B2B assessment, dealing with customer issues and new requirements and writing internal specs.
  • CIS (Customer Information Service) and webMethods transmission development.
  • SQL performance improvement reduced by about 25%~50%, customer test report and 8D Report.

Project: (Benefits: About 25 customers engaged in global transactions have been automated. Annual orders amount to billions.) 

  1. B2B: development and monitoring for customers such as Qualcomm, Micron, Onsemi, STM, Dialog, Broadcom, AVAGO, etc., covering requirements for 7B1, 7B5, 3C3, 3B2, 4B2.
  2. ERP and Others: GMO Cost Calculation System, GMO Quotation System, Statistical Analysis for IT Satisfaction Survey at Kaohsiung Plant, WaferMap Verification Feedback System for Hisilicon Semiconductor, VB6 to C# conversion.
  3. BPR: Assisted in process integration, technical evaluation, and improvement for Intel's integration with Lantiq.

Education

2019/9 - 2023/1

National Cheng Kung University

Executive Master’s Degree, Industrial and Information Management

Master of Management Science (M.M.S.)

2008/9 - 2012/6

National Kaohsiung University of Science and Technology

Information Management(First Campus)

Bachelor of Business Administration (B.B.A.)

Certifications

ITIL® 4 Foundation In IT Service Management

AXELOS Global Best Practice

GR671136027YH
Issued 2020/3

Project Management Professional (PMP)

Project Management Institute (PMI)

2594313
Issued 2019/6 · Expired 2025/12

Network Security of Packet Analysis (NSPA)

Network Traffic Packets Analysis Association(NTPA)

NSPAC2017085
Issued 2017/6

Advanced Cardiac Life Support (ACLS）

Taiwan Society of Emergency Medicine

10200524
Issued 2013/3 · Expired 2016/3

MCTS-SQL Server 2005

Microsoft

D200-6234
Issued 2010/12

CIW - Security Analyst

Certification Partners (CIW)

5627993
Issued 2010/12

Emergency Medical Technician (EMT1)

National Fire Agency (Taiwan)


Issued 2012/11· Expired 2015/11

Level C technician for accounting

Ministry of Labor(Taiwan)

149--379579
Issued 2007/5

Internship experience

Software Engineer Intern

HAMASTAR TECHNOLOGY CO., LTD • 2011/6 - 2011/9  • Kaohsiung, Taiwan

Skills: C# / SQL / ASP.NET / VSS / MS SQL Server

Target: To assist in the software product development.

Job Description:

  • Program development, SQL, OWC chart, development of modules for Word, Excel, and PDF form printing and formatting (including programming and algorithms)

Project: National Kaohsiung Normal University - National Junior High and Elementary School Teacher Professional Development Evaluation System.