Employment History:

7/2004 - 07/2009 
Confidential, Milwaukee, WI, USA
Technical Architect

Designed and programmed in various projects which Load, extract and transfer data through the AT & T Enterprise Data Warehouse in various databases ( DB2, Teradata Oracle ) in IBM Mainframe & Unix environments.

Duties included creating High Level Application Design (HLAD) documents and/or Detail Design documents; Programming and testing using COBOL, DB2 utilities, Teradata utilities, JCL, SQL various file sysyems and transmission tools; Insuring data integrity and accuracy for the supported databases; Providing performance tuning recommendations; Problem shooting and solving in Production and test environments; Also involved some DB2 data model designs and Data transitions from Teradata to DB2 databases.

7/2002 -7/2004
Confidential, Milwaukee, WI, USA 
Senior Program Analyst

Acted as one of the High Level Application Development Leads (HLADLs) in the Billing Data Repository (BDR) team. BDR collects billing data from all of the SBC regions and stores them in SBC Teradata databases. COBOL, JCL, SQL,VSAM, IBM utilities and Teradata utilities were used to transfer, reformat and load data into the Teradata database on an IBM MVS and/or OS environment. BDR also maintained data and ensure the data integrity and accuracy - Performed audit data functions everyday; Created and updated data, tables, views, and columns whenever necessary.
My duties included estimating the impact of new projects on BDR, consulting with Detail Business Requirement (DBR) and High Level System Design (HLSD), creating High Level Application Development (HLAD) and Detail Designs documents; helping on coding , testing and problem solving.

03/1998 - 06/2002 
Confidential, Milwaukee, WI, USA 
Program Analyst / Senior Program Analyst

I was the subject matter expert of IB (Installment Billing). Duties included new release work and system maintenance, trouble shooting and problem solving, defects analysis and control, maintaining the IB database and AS-Rendered database, data integrity. 
These systems are written in IMS/DB2, COBOL, JCL, VSAM, etc. on an MVS and/or OS environments.

01/1990 - 02/1998 
Confidential, Milwaukee, WI USA 
Program Analyst / Database manager 

Developed and maintained the on-line and batch Information System on an IBM VM/ESA environment. Duties included designing and developing new systems, maintaining existing systems using COBOL, CICS, VSAM, JCL etc. Designed and developed a quality management system which included more than 40 on-line and batch programs, which eliminated paper work and confusing searches. Also designed and developed Sales management systems, which helped the company's forecast and management. 

Database manager. Duties included the transition from the existing IBM Mainframe database to a QAD Client-Server database, testing and maintaining the new database. Successfully created the Client Sever databases, transferred data from the mainframe database to the Client-Server database, created database security, and helped/consulted with users on testing and problems with the new database. 

Confidential. Duties included design and development of a new Lotus Notes system and consulting/helping users with problems. Designed and wrote about 10 Lotus Notes Programs in just about 1 year, and earned a LOTUS NOTES Development Specialist Certificate from the LOTUS NOTES company by passing the required examinations. I also learned JAVA and HTML and Lotus Notes Scripts in the period.

06/1988 - 01/1990 
Confidential, Milwaukee, WI USA 
Research Assistant

Created an electrocardiogram signal system with two professors and one another student using C in chips. The system let the patients to carry the programmed chips for 24 hours to measure and record their cardiogram data, then reconvert the data to cardiograms in PC for further analysis. The system was tested on Unix, PC, and VAX/VMS. My duties included research, analyzing, and comparing of different electrocardiogram signals processing methods by designing, coding and testing them as well as partial final coding and testing for the selected specific electrocardiogram signals system. The system was completed and began to use in the Medical Research Center in Milwaukee from January of 1990. 

Besides, there were several projects were finished during my studying period, such as projects on TCP/IP, database systems, and operating systems. I was a leader of several projects.

05/1982 - 07/1987 
Confidential, Beijing, China 
System Supporter/Analyst, Database Administrator 

System Installation, maintenance and user supports. The duties included installing IBM mainframe system software on 4331/4361, designing and developing system interfaces, testing, and initiating and maintaining databases. Successfully installed DOS, CICS, STAIRS and other software, tested CICS and STAIRS, and found the problems in STAIRS when a huge volume of data was run through it. Successfully created the first STAIRS database in China and an on-line retrieval system for the database by using CICS. Designed and developed several interface programs and applications in COBOL, VSAM, JCL, and DB2 on the IBM mainframe. 

Project leader for creating an automatic retrieval system for the Scientific Library of Academy of China. Duties included analysis, design and development of the computer searching and retrieval system. Created the first scientific magazine library database and its retrieval system in China.

Education:

Confidential, Milwaukee, WI USA
Master, Math & Computer Science

Confidential, Beijing, China
Master, Software Engineering

Confidential, Beijing, China
BS, Mathematics,

Confidential, Milwaukee, WI USA
Certificate, C++, 135 Hours Completed, Certificate

Confidential, New York, NY USA
Certificate, IBM softwares, 500 Hours Completed

Confidential, Milwaukee, WI USA
Specialist in Lotus Notes Development, Lotus Notes, 48 Hours Completed