Lee-chin Liu
**** ******* **** **. ****** Hill, CA 95037
Phone: C: 763-***-****
Email: ***********@*****.***
OBJECTIVE
Software Engineer in database or database application
SUMMARY
Developer of Relational Database Engine for two platforms, IBM DB2 for z/OS
and Unisys and developer of DRDA data communication and Compiler.
Solid working experiences on z/OS and MVS development environment.
Experienced in all phases of a large scale software life cycle from design,
development, testing, and support. Excellent team player and problem
solver. Passionate about technology.
* 12 years of experiences in IBM DB2 for z/OS internal development with in-
depth knowledge in query optimization and query transformation
techniques, XML, DRDA, Star Join and Materialized Query Table data
warehouse techniques.
* 12 years of experiences in Unisys Relational Database internal
development with in-depth knowledge in B-tree, view, join, group by.
* 4 years of experience in development IBM DB2 for z/OS application,
Content Manager.
* 4 years of experience in development of Compiler.
EMPLOYMENT
1/2009-8/12/2013 IBM, Silicon Valley Lab San Jose, CA
Content Manager for z/OS developer
* I am responsible designing and developing DB2 for z/OS application to
store, scan, and search documents, images, pictures. CM also supports
folder, multi-values column of a table and is written in C.
4/1998-12/2008 IBM, Silicon Valley Lab San Jose, CA
DB2 for z/OS Relational Data Service(RDS) developer
* My responsibility is in XML component and includes development of XPAth
parser, XML Key Generation, XML Date and Time data type and functions.
* My responsibility is in SQL semantic & transformation component. Its
function is to perform semantic analysis of complex SQL statements and
query transformation to optimize query such as subquery to join
transformation, table expression merging, join reduction, union
distribution, view, Materialized Query Table for data warehouse, index
on expression for performance, etc.
* My responsibility is in Access Path Selection component and includes
development of Star Join for data warehouse. APS uses Cost model to
find the best Access Path for a query.
* I also mentor new college hires in our team and also provide technical
consultation to peers and cross product teams in my area of DB2
processing.
* Apart from new development tasks, I work closely with IBM Level 2
technical support team to diagnose and deliver technical solutions to
customer reported problems. This role has given me the opportunity to
develop a very strong analytical skill in solving technical problems.
* My responsibility includes project management. I plan rally schedule,
maintain code library, and coordinate activities among team members.
* Received several US patents as one of the inventors.
* DB2 for z/OS is written in PL/X which is PLI like programming language.
6/1997-4/1998 IBM, Plymonth, MN, Global Service for Prudential
Insurance
DBA of Insurance Application Development using DB2 z/OS
* My responsibility is DBA for DB2 s/OS application and includes data
modeling, performance, Problem solving and development CICS COBOL
application.
10/1991-6/1997 Unisys, Roseville, MN
Relational Database developer
* I was responsible for designing and developing RDA which connects
heterogeneous relational databases, Sort Merge Join and Hybrid Hash
Join. Both joins are patented.
9/1989-10/1991 IBM, Rochester, MN
Developed DRDA which connects AS/400 and z/OS DB2
* I was responsible for designing and developing DRDA which is at an
application layer of data communication to connect AS/400 and z/OS DB2
so a SQL query can access remote tables as well as local tables.
10/1983-9/1989 Unisys, Roseville, MN
Relational Database developer
* I joined the team right after first release and was responsible for
Relational Storage Management for B-tree, view, Group By, etc.
* I was responsible to Maintain CODASYL database model.
1979-10/1983 Unisys, Roseville, MN
Unisys' PL/X like compiler developer
* I was responsible for designing and developing Unisys's system
programming language.
1978-1979 Honeywell, Plymonth, MN
Computer Aid Design developer
* I designed and implemented Computer Aid Design tool for engineer.
QUALIFICATIONS
* Experienced in relational database management systems such as IBM DB2,
Unisys RDMS
* SQL query writing and optimization techniques
* Understanding in the development cycle of a complex, large scale
enterprise software system and able to maintain and enhance such systems
from years of experiences as an IBM DB2 developer
* Consistently meet the project requirements under tight schedule
* Able to learn a new programming environment in a short period of time
* Highly motivated and able to work independently.
* Solid working experiences on z/OS and MVS development environment(JCL,
IPCS, ISPF, SPUI, PL/X, PL/1)
* Programming languages: PL/X, Java, C, COBOL, CICS, SQL
EDUCATION
University of Minnesota at Twin City, PhD in Computer Science, 06/1989
while working for Unisys as full time employee, part time student and
Mother of three kids.
GPA : 3.7
SECURITY CLEARANCE
Security Clearance is granted to allow accessing classified information.
REFERENCE
Available upon request