[1991-1996] Tianjin Light Industry Institute, majoring in Automatic Control

Member of Tianjin Computer Community

Then I was involved in the AS/400 Y2K upgrade project, assisted the suppliers to modify program, because I have the experience of AS/400 when I worked in SSA. Two weeks later, the system got successful upgrade.

In February 1999, I developed Web application system for Headcount control and management. Managers can easily make smart plan for future headcount volume and proportion through Intranet. They also can query headcount history and information for any period, shown by chart and Excel metrix. The back platform consists of one Microsoft SQL 7.0 and one Web server, and the front platform can be any kind of browser. I use ASP and HTML for programming, connecting to ODBC and then to SQL database. This Web system also includes one MAPI application, which can send query result to you safely, because, to some extent, this system is secured. Users who encounter any problem can register in this system and the system will automatically send an email to right IT people. You can enjoy conference chat here, too.

After successful Headcount development, production department asked me to develop another two applications. One is Training Certification System (MSO), another is Cost of Quality Management (COQ). MSO is a multi-positioned manufacturing resource administrating system. It automatically generates certificate report from the course database, listing detailed operation licenses of the operators, sorting by production line and/or by department. At the same time, it administrates the violation information. Everyday, it will send warning message to the supervisors if their subordinates’ operation licenses will expire soon, or the subordinate has violation for 3 times. This web application has distinguished security features, which meets the security requirement of the company. This system receives high appraisal from QA manager, HR manager, IT manager and users.

MSO keeps every operator’s skill and training records, it can automatically send pre-alert mail to production leader & manager of who should get a new test or who has a violation. It can tell manager which key process lacks how many qualified operators as well.

I’m not only DNS administrator of our department, but also became Notes administrator later because of re-organization. I’m the Y2K contingency plan champion as well.

I set up the CTS (Tianjin) Website in year 1999. On this site, there are Headcount and MSO systems, desktop support request forms, PRMS project introduction, computer training center, etc. This site supports PGP certificate security protocol, using RSA encrypt calculation methodology. This kind of work attracts me very much.

At spare time, I installed a Linux system, and set up an Apache Web server and a database named ‘MySQL’ on it. I like Linux.

Generally speaking, I work for the Iridium Plan for about 5 months per year. Perfect cooperation and good friendship with all of the team members made me always been chosen every time and enjoy the time I spent in TSLC.

At that time, I mainly engaged in Wide Area Network including TEDA & MOS-17. I set up several circuits and then connect them to the network of Human Resources Department, Finance Department and other Sector/Groups. We applied for a DDN from the post office, encrypted by Cylink, through Modem, connected to our CISCO router.

I got CISCO ICRC certificate, and had Cabletron Switch training. On October 1 & 2 1997, we upgraded AGS to CISCO 7507 router, thus improved our performance. We modified parameter of circuit and router according to the demand of our users, ensuring 24hr*365day high quality telecommunications. After that, I organized laying fiber, added NewBridge site machine. The NewBridge was used to provide VoiceLink service. Setting up & maintaining TJ Secure Dial-In server were also my responsibility. I was in charge of analyzing user data. I learned HTML and JavaScript on the time, I setup web server on our Sun host. I experimented using Sun Solaris to manage that data (network and terminal server) and to place it on the intraweb. I succeeded. So we can know which circuit has a high traffic, when has a high traffic, then analyze data (ping time, IP accounting…). We successfully found that one department broadcast intemperately with InocuLan incorrect configuration. After correcting, this department circuit traffic was decreased extremely.

So I maintained our web server for networking management.

Working in SSA, I got familiar with BPCS software and the basic theory of MRP. I negotiated with Tianjin No.1 Machine Tool Factory on a MRP project, and helped the company apply and implement a MRP system.

Training:

Giving lectures of Microsoft Office Product to British Verity Perkiness Ltd.
Giving lectures of Microsoft Office Product to Japanese Mitsubishi Co., Ltd.
Giving lectures of Microsoft Database Product to Australian CSR Co., Ltd.

Software Conversion:

BPCS System Training Book for SSA,

HELP file for DB Company,

Organizing the conversion of all HELP files for Windows NT software for Novell part, and some other small projects such as HP, Microsoft, etc.

Development:

Commercial information system project of Hua Xu Department Store. I organized and participated in developing and programming the Selling Section and Management Section. The hardware system was composed of 1 IBM 320 Server, 14 IBM SureOne POSs, and 18 IBM PC 100 workstations. The software system consisted of POS Sales program over the counter and multiple data analysis program. The system has been running smoothly and successfully.