WORK PROJECTS

WORK PROJECTS
Programming Language is Java if no mention in each project

2008 Year

August

Take Training Class: Understand MARC Better

Make Changes of Course Reserve List Service Based on Feedback

Take Training Class: Project Management

July

Take Training Class: UML and Java Web Services

Continue Developing Course Reserve List Service

June

Update Bursar Transfer Program

Trouble Shooting Invoice Transfer Problem

Develop Course Reserve List Service

May

Design Course Reserve List Service

Research Course Reserve List Service

Review Jira Use

Study Technique from Ajax Course

Trouble Shooting Invoice Transfer Problem

Update CERL OAI Orbis Harvesting Tool

April

Update LSF Refile Program

Take Training Class: Developing Ajax Web 2.0 Applications

Write Self-evaluation and Work Journals

March

Develop Generic OAI Orbis Extract Tool

Update SFX AZ List

February

Update LSF Refile Program

Develop Auto Discharge Kirtas Items Program

Investigate Directory Listing Issue

Write JIRA User Tip Guides

Test Voyager DISCHARGE API

January

Provide Tomcat Realm, Special User Role Training

Attend Conference Oracle Day - Oracle Database 11g & Oracle Fusion Middleware

Trouble Shooting Invoice Transfer Problems

Upgrade Tomcat 5.5, NetBeans 5.0 on Deleon

Investigate OAI Kirtas One Item Barcode Mapping Multiple Bibliographic Records

Research Database Auto Reconnection and 0 downtime Issue

Organize Kirtas Offline Charge File Deployment

2007 Year

December

Trouble Shooting JIRA

Lead to prepare Tomcat 5.5 Upgrade

Develop Journal Flip Report Program

Prepare and participate OAI Forum

Develop Kirtas Items Offline Charge File Program

November

Develop OAI Harvesting Orbis Records by Item Barcode for Kirtas Materials Program

Develop Place Kirtas LSF Items Program

Learn existing LSF Set Callslip program and GFA system

Develop Course Reserve List Search

October

Research Tomcat 5.5, NetBeans 5.0, Subversion Upgrade

Investigate JIRA

Update SFX AZ List Search Feed

Update OAI MARC format

September

SUN TECH DAYS 2007 - 2008

Update Tomcat Special User Role Application

Develop Automating Course Reserve List Pre-Deactivation Data Save

Trouble Shoot Invoice Transfer Application

August

Help Promote JIRA to Production Environment

Develop CERL OAI Dublin Core and MARCXML

Learn XMetaL

July

Research JIRA

Install NetBeans 5.5.1, Subversion, Maven

O'Reilly Open Source Conference

Update OAI Orbis Extract Proposal

June

Research JIRA

Update SFX A-Z List Data Search

Update Circ Reports

Update Invoice Transfer Programs

May

SFX A-Z List Data Search - XML output

SQL Developer Test

Trouble Shooting Invoice Transfer Program

April

Lewis Walpole Orbis OAI Extract

Create BRBL Query

Investigate Voyager Oracle tables UTF-8 issue

Create Circ Annual Report Queries in Oracle

Circ Reports Enhancement

March

Investigate Three Issues

Create Beinecke Library Extract Orbis Data SQL

Continue Developing and finish Collection Analysis Version 2 Revision 1

February

Continue Developing Collection Analysis Output Function

Draft OAI Orbis Tool Proposal

Develop Web Download Files Function in Tomcat Environment

January

Research and Test SQL Developer 1.1

Promote Cataloging Statistics

Promote IDWorks

Analyze, Investigate, Research Collection Analysis Big Set Problem

2006 Year

December

Draft OAI Orbis Tool Proposal

Finish Cataloging Statistics

Update LC Match 13 ISBN

Learn Fedora Open Source

Finish IDWorks Views

November

Test and Document Invoice Transfer Java Version

Document IDWorks- Voyager Views Criteria

Voyager Release 6.0 Local Critical Programs Testing

October

Oracle Open World Annual Conference - San Francisco, CA

Create Queries for IDWorks - Voyager Views

Add E-Resource to Cataloging Statistics

Continue Develop Invoice Transfer Java Version

September

Develop Invoice Transfer Java Version

Review IDWorks Process

Add Summary Function to Cataloging Statistic

July/August

Develop Cataloging Statistic Project

Develop Collection Analysis Tool Version 2, Revision 1

Develop Non-filling Characters Project

June

ALA Annual Conference - New Orleans, LA

Start Cataloging Statistic Project

Interface Design - Collection Analysis Tool Version 2, Revision 1

Update OAI Finding Aids

May

Review Non-filling Characters Project

Call Number Select - Collection Analysis Tool Version 2, Revision 1

Implement Java Excel API

Fix the Check Number Problem

Take Training Class: Java and XML Application Development

April

Finish LC Match 13-digit ISBN Documentations

EndUser Annual Conference - Chicago, IL

Learn Cognos and Analyzer

Research LC Call Number Search and Sort

Redesign Collection Analysis Application

March

Update Programms For LC Match 13-digit ISBN

Build LC Subclass Range Tables

Research Oracle Query Performance

Implement OAI New Query

Finish Check Number Documentations

February

Resarch and Test AJAX, Mutiple Threads Combined Example

Learn Mutiple Threads

Learn AJAX

Taking Training Class: Web Design and Usability Techniques

Finish Check Number Project

January

Start Collection Analysis Update Project

Taking Training Class: XSLT

Investigate Unicode Display Problem in Orbis Tools

Learn Invoice Transfer Program

OAI Finding Aids Set Solution

2005 Year

December

Taking Training Class: Perl Programming and CGI Scripting

Develop Finding Aids OAI Data Provider Tool Pattern

Develop Adding Check Number and Expenditure in Acquisition

November

Propose Voyager APIs for Adding Check Number and Expenditure in Acquisition

Voyager Release 5.0 / Unicode Local Non-critical Programs Testing

Write Fiscal Year Prep and Rollover Documentations

Realm Production Implementation and Test

October

Learn OCLC's Collection Analysis

Learn the Concept and Process of Invoice Transfer

Prepare for upgrading LC Matching Program to accommodate 13-digit ISBN

Implement OAI Open Source Tool

September

Research and Test OAI Open Source Tool

Implement Tomcat Realm on Web Applications

Voyager Release 5.0 / Unicode Local Critical Programs Testing

August

Update programs for UPI Flips

Guide Implentmenting Tomcat JDBC Realm

Develop Accessing Tomcat JDBC Realm Roles Table

July

Taking Training Class: Web Development with Cascading Style Sheets

Develop Display Stand-lone Batch Job Properties Sheet Data

Organize, Prepare, and Run Tomcat Realm Bootcamp

June

ALA Annual Conference - Chicago, IL

Add Function of displaying Split Funds of One Line Item in Line Item Report of Fund Management Tool

May

Develop Fund Allocation

Research and Investigate Tomcat Realm

Taking Training Class: Photoshop CS - Level 1 Basic Image Enhancement

April

Prepare to Develop Fund Allocation

Move up Applications for Production Run

Solve Problem of Authentication Filter

March

Taking Training Class: Administering Apache Tomcat

Develop Fund Management Administration

Update Fund Management Tool

Update Circ Reports

Support Replacing Patron SSN Based Barcode Production Run

February

Participate Tomcat 5 problem solving

Develop Replacing Patron SSN Based Barcode to non-SSN Based Barcode

Work More About Tomcat 5

January

Design and Develop Bar Graph to Show Fund Status

Update Circ Reports Web

Design and Develop Fund Management Tool

2004 Year

December

Circulation Reports Test

Implement Netbeans 4

Set up Configuration Between Tomcat 5 and Application

Investigate Bursar Transfer Problem

November

Design Fund Management Tool Prototype

Learn Existing MDB Selector Application for Funds

Create Circ Reports Policy Groups Mapping Locations Excel File

Create Circ Reorts Authentication Hierarchy System

October

Design and Develop Circ Reports Authentication

Design and Develop Circ Reports Configuration

Convert Circ Reports Queries from MDB to Oracle

Design and Develop Circ Reports Export

Design and Develop Circ Reports Preview

Design and Develop Circ Reports Menu

Patron Load Test for Data Warehouse

September

Learn and Investigate Excelling in Excel with Java

Learn Fund Allocation Operation

Design and Develop Structure of Converting Circ Reports to Web Application

August

Develop Programming Function to Process XML Document Using DOM in JSP

Learn Circulation Reports MDB Process

Take Training Class: XML A Comprehensive Hands-On Introduction

Develop ISP Web Report Authentication

July

Learn invoice transfer programms

Technical support to change the layout of the Webvoyage login page

Add new ability into Voyager Java Filter to authenticate groups through custom queries

Update MultiPod to CoolTools

June

ALA Annual Conference - Orlando FL

Add PIDM in Bursar Transfer File

Figure out how to pass session attribut in sql resultset and core var

Use Oracle Date Format in JSTL

Validate Date Format

May

Date JavaBeans

Foreign Currency Conversion Table

Package MultiPod with Filter

April

Take Training Class: Advanced JavaScript Web Development

Currency Exchange Rates

Self-Study Test Driven Development

March

Design and Develop MultiPod

February

Design and Develop YULTOOKIT Front Page

January

Organized the documentation of each project

Move saved projects'codes from Torbis2 CVS to Magellan CVS

2003 Year

December

Add three things to the Collection Analysis

Design and Create limitation search function of Collection Analysis

November

Design and Create Yale University Library Tool Kit Front Page

Design and Create JSP Error Page

October

Use JavaBeans in list item part of Collection Analysis

Add and re-construct building call number range part of Collection Analysis

September

Function connection pool with DataSource used in JSTL sql taglib on Tomcat 4.0.6 of NetBeans IDE 3.5.1

August

Fix Bursar Transfer problems caused by APIs

Add Collection Analysis Report Save/Load session

Function Tomcat 4.1.24 Connection Pool

July

Research How Tomcat 4.1.24 Configs Connection Pool

Install Tomcat 4.1.24 on Window NT

June

Add Include and Exclude Function for Collection Analysis Report Summary List

Format Collection Analysis Report Session Display Interface

Get Collection Analysis Report DataSource Value from web.xml

May

Parse and handle results of different queries for Show Collection Summary.

Collection Analysis Report Session Function

April

Update Bursar Programms to Accept Small Amount Fine/Fee for Transfer

Add Multiple tag 866 in MFHD

March

Collection Analysis Report Display Interface Design

February

LSF Report Display Interface Design

Take Training Class: Web Component Development With Java Technology

January

NOTIS ARCHIVE Circulation Module Footer Design

Delete Patron Numeric Pop-up Note

Add Indicators to Mfhd 852 and 866

2002 Year

November & December

Notis Archive Acquisition Search

Notis Archive Circulation Patron Parse

October

Bursar Transfer Production Job Run

Post Old Fine/Fees

Currency Web Display(Java JSP version)

Currency Web Display(Java Applet version)

Foreign Language Diacritics Problem Solving

September

Update web currency bib record

Analyse, report and test problems of Voyager bursar transfer for handling credit records

Test Voyager API tester against patch server

August

Add new functions to bursar bill transfer programms

Remove patron from one patron group according patron barcode list

Updated Programming group web page: reformat and add content for "report" and "tools" sections

July

Voyager API Tester (Java version)

Adding |2 localyale to 852 Tag in MFHD Records

June

Java James API (Java MARC Events) use in BIB MARC records

Batch matching LC data overlay Orbis data

May

Create unix shell script for bursar and vendor running

Create Java jar file and CVS use for bursar and vendor projects

Process Pbursar file

Add function of limiting the minimum amount to be transferred

Programming update vendor institution id

April

Update TSO program which creates the keylist to solve LC Authority file duplicates

Programming Charging Privileges Transfer CREDIT File

Programming Deleting Patron Barcode from the Patron Group

Programming Adding Patron Barcode to the Charging Privilege Patron Group

CVS Server Use

March

Programming Charging Privileges Transfer DEBIT File

New "first" Voyager API Test

February

Take Training Class: Visual Basic 6.0

Creating Programming Group Web Site

Researching Charging Privileges Transfer File

January

Fix 1xx tags after 2xx tags problem

Continue Voyager API tester

2001 Year

December

Java programming processing monitor

Voyager API tester

November

Java input arguments interface

October

Build up combined JCL to run multiple jobs together

Convert file format from Tag file to Transaction file (TOTRANS.C)

SQL query against NT item database

September

Programming for Non-Filing Indicators Cleanup(C version)

Java programming for Non-Filing Indicators Cleanup(JDBC version)

Take Training Class: Introduction to Oracle-SQL & SQL *Plus

August

Java programming for Non-Filing Indicators Cleanup(Normal Java version)

Construct One Data Mining SQL Table

June & July

ShelfList Database Rebuilding

May

Write back Item data from flat file to VSAM file

Download item data to SQL server

April

Item data mining

March

Alphbet-number filter

Add the 927 field to the LSF selector's Tool output (LSF9271, LSF9273)

Take Training Class: Java Programming Language

February

LSF series selector's tool part 3 changes

Select LC keys with multiple header

January

PERL test environment for PE

LSF report rewrite, testing, and documentation

2000 Year

December

LSF series selector's tool extract

OCLC MARS Authority control project

November

Call number clear-up version-2(Find record keys)

LSF selector output template

October

Call number clear-up version-1(Find record keys)

Find "for" "geo" "ksl"

Call number clear-up(Correct the problems)

September

Delete assigned subfield or tag

Extract the Yale Bibliographic database keys to OCLC

Find problem call number

August

Update geo

Empty A22 subfield c

Construct personal homepage

Send comments to: yue.ji@yale.edu

Return to the top

Last Updated: Wednesday, 03-Sep-2008 16:30:50 EDT