Database Engineering and Data Analysis
Database Engineering and Data Analysis
Jeff Yahua Yuan
Phone: (480) 491-5578 Email: yuanjeff@yahoo.com Location: Phoenix, Arizona, USA |
Strength and Skills
Database Administration ERP & DSS Applications support Sophisticated Data Analysis
|
Databases
Oracle:
Oracle certified DBA: Database administration on UNIX and Windows platforms in enterprise environment.
Development: PL/SQL (trigger, package, function), Oracle Workflow, Oracle Forms 6i.
DB Architecture: database design, data modeling, DB capacity planning.
Ingres:
Database maintenance tools: VERIFYDB, OPTIMIZEDB, MODIFY.
Ingres Utilities such as IPM, QBF, ISQL, SYSMOD and Ingres/NET.
Database development by using CREATEDB, COPYDB, SQL.
Access:
Access database creation, form and report writing.
C, Embedded SQL and PL/SQL
Embedded SQL: Database Loader
C code: Data manipulation
Data visualization by using SAS
(Output samples in semiconductor manufacturing)
Wafer Mapping
Bin Map for One Wafer;
Bin Map for One Lot;
Out-of-Control: Defectivity
Weekly Chart;
Out-of-Control: By Area
Pareto Rports
Capability Analysis
Trend Chart & Summary Statistics
Control Chart
Trend Analysis
Split Analysis
F-test and Boxplot
Pipeline Chart
Paper presented in 98' WUSS Conference
UNIX script & Perl script
C shell: Manipulate data file
Korn shell: Call DB loader to load data files
HTML & Perl scripts: Access database by Perl from HTML form
Quantitative Analysis
MATH Database by European Mathematical Society
MathSciNet Database by American Mathematical Society
Support and Training
Links for Quick Access
Last modified on 06/15/00