These are specific projects I accomplished
1. Product Yield Monitoring Tool- software written in Visual Basic that fetch yield files from each testers and save to a server. Two parts of the project are Grabber and Analyzer. Grabber resides on server and responsible for grabbing and storing yield information to database. Analyzer reads data from database and display to each client PC hooks. Analyzer contains graphs, tables and form components.
2. Hardware Build-Time Calculator Tool- software that calculates time in building a requested hardware. Main input is bill of material(BOM). The tool will evaluate BOM and categorize each component listed on BOM. Quantities and Mounting Type is also determined. Data from BOM is compared and matched to the time-definition table. From this table build-time of each component is determined and the total build time is calculated. Each calculated build time is stored to database and tagged with the appropriate hardware name. Hardware builders will use the calculated build time as reference for the actual time to build.
3. Pads Schematic Checker- a tool that will read schematic from PADS Logic software. Attributes of each component from schematics is compared to the component listed in master library. A spreadsheet report is generated showing components that matched, mismatched, and not found on master library. This tool is useful to standardize each component to use and forced engineers to build 100% master library compliant schematics.
4. BOM Formatter- a simple Excel Macro program that format text BOM to standardized spreadsheet BOM. This tool helps the hardware builder to read BOM easily and apply appropriate kits and accessories to the hardware.
5. GBD (guaranteed by design) Online- This is a web based tool written in PHP that computes %R&R of two to four set of data. Data inputs are in spd format. This data is read and stored to database. Logical functions execute gage calculations and display it in a color coded table format. This is helpful for engineers who are evaluating test program, testers, hardware while they are on IC test floors.
6. Cost-Saving Calculator - an excel macro tool that asks for two several set of vendors quotes and compares each price. The tool will determine the cheapest price offered and price difference between each vendor.