SAP (Star Schema, InfoCube, BWA, BEx, BO Explorer, RSPC, ABAP, BAPI, ALV, BDC)● Pioneered development for SAP based engineering data exploring. Built 7 Infocubes and BO Explorer for product line and test.● Migrated legacy material management system from DOS to SAP.WEB J2EE/CGI Applications (Oracle, Sybase, AJAX, JavaScript, Struts, Tomcat, JBoss, Perl, Tcl/tk, C, Apache, iPlanet, Netscape):● Engineering Skill Search (Ajax type ahead suggestion).● System-At-Glance system to collect process information of both Fab and Assembly sites for creating Cycle Time Reporting and Lot Tracker.● Test Management Systems for wafer sort and final test.● Test Hardware Development system with document management.● Defense Product Ordering – demand and supply query for backlog, inventory and WIP ● Metrics for three systems to show cycle time, workload and performance at real time.● Assembly Management System that supports ten package types of processes and travelers.● Gross Die per Wafer Improvement Workbench for managing enhanced control map.● ET Specification system for parsing and extracting ET parameters from TPL files and loaded to Oracle to query on the WEB.● Failure Analysis System for managing process cost, cycle time and equipment usage.● Foundry Web Site for external customers to query engineering, Inventory and shipping information.● Silicon Die ID System - An innovation project to retrieve, store and search embedded 256 bits of Silicon Die ID circuits.● Domino Applications run on Web for Work Accident Reporting and Carpool Registration.

SAS Applications (SCL, STAT, GRAPH, ANOVA, Perl, Tcl/Tk,C, HTML, JavaScript, Sybase, JMP).● Variance Component Analysis for detecting the variance among lot, wafer and die.● Profile Analysis for grouping the variance.● Commonality Analysis for finding the process commonalities.● Metrology Data Analysis for KLA Overlay and ASM tracking.Data Collection and analysis(Sybase, SAS, C, Tcl/tk, STDF, Unix, VAX).● Defect Mapping system for mapping the wafer map and defect map from KLA, Tencor and Lomac.● ETL process for defect data collection from Tencor and Reedholm.● EzET system for Sybase ETL and engineering data on test log and Keithly. Interface to SAS, RS/1 and Excel.

● Soil Builder Retail Ordering System (SCO Unix, Ingres/ABF, C, OpenSQL).● Information Warehouse System (Sybase, C/DBLibrary, Transac-SQL, ObjectView),● Repair System for chemical equipment maintenance (Nexpert, OIT).

Managed the development of Imaging scan and plot on SUN and VAX/Ultrex The Image system is a subsystem of corporate product, Engineering Change Notification System (Unix/C, device driver).

Applications for Insertion Machines (Vax/VMS Fortran, C, Pascal, QIO, Mailbox, PROMIS)● Pattern Program Download System for loading pattern programs from VAX to Universal’s insertion machines.● Equipment Maintenance System for insertion machines.● Driver programs to communicate between VAX mailbox and PROMIS.System Management● Managed the SUN system, NFS and networking administration.● Developed FTP/DNI scripts for file transferring from IBM VM/CMS to VAX/VMS via SUN server.● Developed a fully automated backup script to backup SUN and Ultrex files to a 8mm tape.

CAD/CAM Applications (VAX Fortran, ISAM, QIO, SUN C, Lisp, CGI).● A team member of developing Silicon Compiler on Symbolics and SUN/3 for rule checking and plotting the physical layout of IC circuit.● Team leader of SPC System development for 2 FAB production sites.● .Map Data Analysis System for reducing the test sample size of wafer sort.System Management● Communication programs for data transfer among VAX, Burroughs, PDP11 and HP3000.● VAX Cluster and Decnet on two VAX 785s by using CI lines to share common OS (VMS 4.1) for two clustering hosts.

Maintained Student Database System on HoneyWell. (Honeywell Cobol, JCL)

● Managed Property Tax System (CDC Cyber 172, CDC3300, COBOL Wang’s 2000).● Worked with CDC engineer to modify the COBOL compiler on Cyber 174 to become a Muti-User–Job system. (CDC Cyber 174 COBOL, Compass).