JAY YU
2664 MEADOW HALL DRIVE, HERNDON, VA 20171
 [Send email to request phone number] 63-8264
[Send email using form at bottom]


Education:	M.S. Electrical Engineering, University of Maryland, College Park,
1993

	B.S. Computer Science, University of Maryland, College Park, 1990

Employment History:

Have over 15 years of experience in the area of Information Technology
specializing in Oracle & SQL Server Database Management Systems. Have been
involved in all phases of life cycle system development including user
requirement analysis, system analysis and design, database design and
administration, application development and implementation.



3/05-Present	Northrop Grumman Corporation
Senior DBA Consultant

Provided primary Oracle database administrative support for Northrop Grumman
Health Solution division, in charge of all enterprise production and test
environment applications.  These included 9 production databases and 9
development/test databases. Users were located in America, Europe and Asia
Pacific.  Responsibilities included,

•	Installation and configuration of Oracle 9i/10g servers and creation of
databases in UNIX and Windows environments.
•	Installing and configuring 10g Real Application Clusters (RAC).  Troubleshoot
performance problems.
•	Implementing and configuring Oracle Database Replication.
•	Database monitoring and maintenance activities which include checking alert
logs, space management, undo management, gathering database statistics, database
locking issues, scheduling of cron jobs, creation of users, schemas, Tablespaces
and other database objects.
•	Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating
the changes in the database design. 
•	Establishing and monitoring database backup and export schemes (hot/cold).
•	Installing Oracle applications on server and client machines, and developing
scripts for common Oracle tasks.
•	Database performance tuning.
•	Developing PL/SQL procedures for various applications.
•	Database architecture Design.
•	Logical Data modeling using ERWIN
•	Creating and maintaining database links between different Oracle databases.
•	Data conversion and migration from a legacy system that contains over 100
Tables.


 Also provided DBA support for a MySQL database on a Linux environment.  It was
a high volume, high availability production database.  Installed and configured
the database server.  Managed user securities and database schemas.  Setup
database replication for Backup and Recovery purpose.


9/98-3/05	Integic Corporation
Oracle DBA/Senior Developer

Provided Oracle DBA support for multiple large databases in production,
development and test environments for various types of databases. Planned and
executed multiple server upgrades and migrations. Coordinated capacity planning
through in-depth trend analysis. Calculated space utilization and application
growth, and projected database sizing. Initiated and executed disaster recovery
and backup initiatives. Collaborated with business analysts and development teams
in design and deployment of relational databases from legacy data. Facilitated
database performance tuning. The Oracle systems were 10g, 9i, and 8.1.6 in Unix
and NT environments.


Led the development efforts on the Remote Data Capture product for Integic
Corporation. This system is a WEB enabled remote Data Entry application that
allows the Pharmaceutical companies or CROs to enter the clinical data remotely
over the Web or Intranet. It also allows the users to generate, transmit, and
resolve the Discrepancy records.  The system is an XML based application, and
utilizes the standard CDISK clinical data element definitions. The clinical data
is stored in either Oracle Clinical or Clintrial.  The system is integrated with
Oracle Clinical’s Data Capture API and Clintrial’s Batch Data Upload API to
transfer data to the backend database.  

Led the development efforts on the CRF Workflow product. This product provides
Workflow and Imaging capabilities for Clinical Report Form(CRF) tracking process
for Pharmaceutical industry.  It greatly improves the efficiency of the clinical
research process and has been accepted as a standard system by many
Pharmaceutical companies. The application is also integrated with different
clinical database systems including Oracle Clinical and Clinitrial to provide
Automatic Data Upload, Split Screen Data Entry, and Discrepancy processing
functions. Other features include audit trial, image conversion to PDF, study
archive, and generating submission data to FDA.  The product is written in C++,
and Visual Basic.  The clinical database APIs integrated within the system
includes Oracle Clinical Imaging API, Oracle Clinical Data Upload API, and
Clintrial Data Upload API. The various technologies implemented into the product
include Barcode printing/reading, OCR/ICR recognition, Crystal Report engineer,
MAPI Email engineer, Automatic fax import, Optical storage, and remote access.  


11/95-9/98	Universal Systems Inc
Technical Lead

As the technical lead, successfully led the development and delivery of the
following projects:

Developed and implemented a large scale, multi-site Document Management/Workflow
system for Johnson & Johnson Pharmaceuticals, which features document scanning,
indexing, Barcode reading, OCR/Automatic data entry, automated incoming and
outgoing fax, optical storage management, and Workflow processing. The system was
based upon the Documentum system environment, running on Sun Solaris as the Unix
server.  The development tools included C++, Visual Basic, ASP, HTML, and Oracle
PL/SQL.  


Developed a multi-platform imaging/workflow system for Sony Music Corporation.
The system utilized workflow technology to manage Sony Music’s account payable
process, which handled large amount of invoices, receipts, checks and claims
daily.  The system featured many automated processes within the workflow, which
greatly reduced the turn-around time of the invoice processing.  The system was
implemented on the MS SQL Server database. 

Led the CRF Workflow system development effort for OTSUKA Pharmaceuticals. This
is a client/server application featuring document scanning, indexing, barcoding,
automatic lab page processing, Optical storage management, batch printing,
document retrieval and Workflow Processing. The system includes Novell Netware as
the file server, DEC Alpha machines as the Database server running ORACLE
Relational DBMS(ver 7.0), TCP/IP as network protocol and MS Windows client
workstations. 

Was the lead developer on the Boehringer Mannheim Pharmaceuticals Imaging
project. This is a client/server application featuring image scanning, indexing,
ad hoc retrieval, OCR recognition and full text search. The application was
written in C and Visual Basic. 


4/94-11/95	BTG Inc
Software Developer
				
Worked as a Software Developer on BTG's Impresario product, a large scale
document/image storage and retrieving system. Provided detailed design of the
database and user interface, and some application tools including OCR, scanning,
faxing, editing, and full-text searching. The system runs on the platform of MS
SQL Server and MS Windows client, with Novell Netware or LAN Manager as network
system. 


Technical Skills:

Databases : Oracle 9i, 10g, 11g RAC, MySQL, MS SQL Server 2000 & 2005, MS
Access. 

Middleware : Oracle Application Server 10g, WebLogic, SSO, OID, LDAP. 

Programming : C/C++, Java, SQL, PL/SQL, Visual Basic, PHP, Unix Shell scripting,
ASP, VB Scripts.

Tools & Utilities : SQL Navigator, ERWin, Visio, Oracle Developer, Oracle
Enterprise Manager, Oracle Maestro, Oracle SQL*Plus, Oracle SQL*Loader, TOAD,
Microsoft Visual Studio .NET. 

Operating System : UNIX, Solaris, HP-UX, Windows 2000/2003, Linux.

Network : TCP/IP, DNS, COM+/DCOM Security, Active Directory, Virtual IP.