M.S. candidate in Computer Science and Mathematics, University of Louisville, Louisville, KY 40292  
B.S. in Mathematics, Jinan University, Guangzhou, P.R. China, 07/1991 

SYSTEM ANALYST  
Princeton Information, Inc., JP MORGAN, 60 Wall Street, New York, New York Foreign Exchange Option Trading Operation support team.  
· Maintain, support and enhance the FX option trading front/back office application.  
· Support Devon, a vendor supplied FX derivative back office system, monitor the data transfer between the front office Sybase data server and Devon, and make sure they are consistent.  
· Use UNIX shell and DQL (Devon specify query language) to generate reports that keep track of the profit, loss balance and trading position for the customers.  
· Upgrade the existing Sybase 10 based application to Sybase 11, which includes installing the system software, modifying the existing stored procedures, converting the DB-Lib codes to CT-Lib codes, reconfiguring the data server so that it can take full advantage of the Sybasell new features. 

APPLICATION SYSTEM DESIGNER & ANALYST/SYSTEM PROGRAMMER AMA System, Inc., Picatinny Arsenal, NJ Designed, implemented and maintained AMAS (Army Material Automated system), the standard army automate procurement and material management form flow system with UNIX, C, SYBASE. AMAS is an open system that has the interfaces with the Army Financial System, Army Equipment System and UPS shipment tracking system.  

Implemented and optimized the AMAS application by reviewing the logical, physical database design, identifying and analyzing critical transaction as well as improving the database memory management and locking mechanism. Developed and evaluated the SQL queries, stored procedures and triggers and index selections and come up with he most efficient solutions based on the performance tuning principles.  

Implemented an interface that downloads the data from Army standard equipment management system to AMAS database on a daily basis by using C, DB-Library. UNIX SHELL and Transact SQL utilities.  

Developed an On Line Transaction Process procedure that interfaces the Army financial system. It reconciles the AMAS database with the real time financial data and it is the most critical interface with other system in AMAS, it uses the UNIX reliable signal notification mechanism, IPC, BSD Socket communications technics as well as Sybase DB-Library, Sybase Open Server-Library. Perform the day to day UNIX application server and Database server administration that consists of writing the watch dog shell scripts that monitor the server, writing the SQL-Batch scripts that backup the databases, monitor the databases performance the maintain the databases operation by writing the stored procedures.  

Migrate the existing database server and application from Sybase system 10 to Sybase system 11 which includes reconfiguring the SQL server options and database objects so that it can take advantage of the improved system 11 cache, data storage, transaction log management features, replacing the DB-Library routines with the new CT-Library routines.  

Rewrite the old AMAS UNIX application and move the front end out of UNIX to PC platform with Borland Delphi. This is a full cycle project that includes: · Collect, analysis the application requirements and come out with the new application architecture.  

Review, modify and rewrite the database structure, table layout, indexes, stored procedures, triggers so that they can fit into the new application and fully take advantage of the system 11 new features.  

Develop a server daemon that sits as the middle tie between the PC client and the UNIX database back end with C, C++, and use TCP/IP protocol, BSD Socket API and Window Socket API to do the communication.  

Develop a web based interface that allows the users to use the browser to run the application by using Java and keep the existing back end server and middle tier unchanged.  

TEACHING ASSISTANT  
University of Louisville, Louisville, KY 40292  
Taught College Algebra, a required course for under graduate students. Taught Intermediate Math, a secondary math course about probability, matrix algebra, operating research. Duties in both courses included lecture, making up quizzes, grading. 

C, C++, Delphi, JAVA, UNIX shell, Windows Programming, Sybase Open Client/Server Library, UNIX and PC Communication Programming with TCP/IP and BSD Socket, UNIX IPC, UNIX System Programming, Transact SQL, PowerBuilder, Pascal, Fortran. UNIX (Sun OS< DEC UNIX), Sybase System 4.9,10,11, Window NT, Windows95