DAVID S. LI
Fremont, CA94555 ablcn6@r.postjobfree.com Cell:
Objective:
A PL/SQL Developer position in a challenging environment where my
strengths and experience can add value.
Qualification:
. 10+ years of experience in software and application development.
. Well experienced in development of Client/Server/Web service
application and programming using Stored procedure, PL/SQL, Java/J2EE
and C#/.Net Framework
. 5+ years of experience in schema design, data analysis, modeling,
mapping, stored procedure, SQL, PL/SQL and shell scripts.
. 5+ years of experience in developing backend data store using OR-
Mapping, Optimized Query, Stored procedure and RDBMS. Strong
knowledge in TopLink mapping.
. 3+ years of experience in developing applications in SOA architecture
based on J2EE.
. 2+ years of experience in developing .Net and Java web-based front-end
application.
. 2+ years of experience in QA and applications integration testing.
. Extensive work experience in system testing, performance
optimizations, application implementation, data migration and multi-
platform enterprise applications support.
. Strong analytical, troubleshooting, problem solving and debugging
skills.
. Knowledge of UNIX, Oracle9i RAC, Sybase, SQL Server and Oracle
Application Server 10g.
. Knowledge and experience of OOAD, SDLC and Agile development
methodology.
. Experienced collaborating with other offshore teams.
. Excellent communication, interpersonal skills and good team player.
. Industrial knowledge in Logistics/Supply Chain, Transportation and e-
commerce.
Technical Skills:
. Java, SQL, PL/SQL, Stored procedure, Shell script, C#, MS Visual
Studio, .NET Framework, C, FoxPro, Visual Basic, Smalltalk,
PowerBuilder, COBOL, RPG, JCL.
. Oracle9i, Sybase, MS SQL Server, Gemstone, JDBC, ODBC, RDBMS, OODBMS,
TopLink, PL/SQL Developer, SQL Developer, SQL*Loader, SQL*Plus, TOAD.
. XML, XSD, WSDL, HTML, JSP, XMLSpy, Web service (SOAP).
. J2EE, SOA 3.0, Oracle 10.1.3.1 Application Server, Agile development
methodology, UML.
. Eclipse 3.2, ClearCase, ClearQuest, MS VSS, MS Office, HP-UX, Solaris,
VMS.
Professional Experience:
Orient Oversea Container Line (www.oocl.com), San Jose, CA (Oct96 - Aug09)
Software Engineer
CDRIVE Project (May05 - Aug09)
CDRIVE is a web-based and customer-centric system to support the customer
service, convenience and retention.
. Designed, developed and implemented web-services server side
applications using Java/J2EE, SOA, XSD, WSDL, TopLink, PL/SQL for
transactional data update and lookup.
. Developed and maintained a web-services client side application using
C#/.NET framework.
. Responsible for application performance tuning, QA and integration
testing. Review PL/SQL, stored procedures, Java code and identify
areas of improvement and measure performance gain.
. Responsible for application debugging and troubleshooting. Provided
solution and work around solution to resolve problem and responsible
for program code enhancements. Provided 24/12 on call production
support.
www.operationsmart.com Project (May02 - Apr05)
OperationSmart is an Internet application system that enables carriers to
collaborate with their vendors in the e-Commerce environment. It is a
web-based equipment inventory related system.
. Developed Java backend process to support EDI data file upload batch
processing. Wrote programs in Java, PLSQL and UNIX shell script.
. Designed, developed and implemented the data migration process using
Sybase stored procedure, UNIX script and SQL Loader. Data were
migrated from Sybase database to Oracle database by different phase.
. Responsible for application enhancements, debugging, data migration
and release cutover.
. Conducted training to offshore teams on how to enhance and debug the
application.
IRIS-2 System IEIS Module Project (Jan99 - Apr02)
Integrated Regional Information Systems 2 (IRIS-2) is a large scale
deployment mainly building on GemStone/Smalltalk and Sybase/Java to
replace the mainframe application systems into one international
enterprise system. IEIS is the Equipment system in IRIS-2 handling
equipment inventory and real-time tracking. It is java front end
function based with Sybase stored procedures in back end. The module was
implemented and sold to other companies.
. Designed, developed and implemented a backend process using Sybase
stored procedures to build the validation and update logic.
. Designed, developed and implemented data migration from legacy system
to Sybase.
. Conducted training to external customer on how to enhance and maintain
the module.
. Developed and implemented a sub module in GemStone/Smalltalk
environment using object oriented design approach.
Representative Projects (Oct96 - Dec98)
. Implemented and supported the Sales module (SMM) developed by a software
company.
. Developed a backend process for Internet applications using C.
Orient Oversea Container Line, San Ramon, CA (Apr91 - Sep96)
Programmer Analyst
. Designed and developed pc application using FoxPro.
. Developed Client/Server application using PowerBuilder and Sybase stored
procedure.
. Implemented enterprise applications and analyzed EDI data used in IBM
Mainframe.
Education:
University of California, Santa Cruz Extension
The University of Hong Kong Extension (HKU SPACE) - Computer System and
Programming
Chu Hai College, Hong Kong - BA in Journalism
Certifications and Training:
Oracle : Oracle PL/SQL Programming and Performance 2008
UNITEK : Visual C# Programming and Developing
2008
TIBCO : Developing with the TIBCO Enterprise Message Service
2006
SUN : JavaServer Pages Technology 2001
SUN : Java Programming Language (UNIX)
2000
SUN : Enterprise JavaBeans Programming
2000
GEMSTONE : Fundamentals of GS/S 1999
UCSC : Java Servlets
1999
UCSC : Object-Oriented Design / Analysis
1998
ObjectWorks : SmallTalk with VisualWorks
1998
UCSC : C Language Programming 1996
LRH : Visual Basic Programming 1996
Sybase : Introduction to PowerBuilder
1995