Lee-chin Liu

**** ******* **** **. ****** Hill, CA 95037

Phone: C: 763-***-****

Email: ab9np9@r.postjobfree.com

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

Contact this candidate