System Project

To:

Subject: Please review my resume. I look forward to hearing from you.

Date: Wed, 25 Jul 2001 08:53:10 +0100

Contact Information: ********@*******.**************.***

FENG SHEN

SUMMARY: I have over 13 years of IT experience in Information System

Development. I have specialized in client/server systems in finance and

accounting fields. His primary role has been that of a Visual Basic

developer. Additionally, I am certified in both Oracle 8/8i Database

Administration and Java Programming. I have extensive knowledge and

experience in RDBMS technologies and object-oriented methodologies.

SOFTWARE: Visual Basic 6.0/5.0/4.0, Visual C++ 6.0/4.2, Oracle 8i/8/7.3,

PL/SQL, SQL*PLUS, Java 2.0, FoxPro 3.0/2.5/2.0, Crystal Reports 7.0, MS

Access 2000/97/2.0, Dbase 3.0/2.0/1.5, Forms 4.5, Designer/2000, UML

(Rational Rose), PICK/Basic, IBM PCOMM Toolkit, TCL, FORTRAN, Pascal,

Cobol, TeamWare Workflow, CARDPAC, SQL Server 7.0/6.5, Microsoft

Transaction Server 2.0, ActiveX, ODBC 3.x/2.x, RDO and ADO.

OPERATING

SYSTEMS: UNIX, IBM AIX 4.1, Novell NetWare 3.x/4.x, Windows

2000/NT/98/95/3.x, MS DOS, PICK.

HARDWARE: PC 386/486/586, IBM RS 6000, IBM 93xx, Compaq Server (P5500),

DEC VAX 11, PDP-11,

EXPERIENCE:

DBS Bank, Singapore Jun 97 to Present

Card Center MIS

Dec 99

to PresentDatabase / Applications Administrator

Description:

Since March 1998, the Bank Card Center has been building their MIS system

that used an Oracle database along with the existing application system.

The new database structure included the on-line transaction database,

settlement record database, workflow database, chargeback (customer

dispute transactions) case database and the Visa/MasterCard input

transaction database. These databases were running on NT server and IBM

AIX. There were two major application systems in Visual Basic 5.0/6.0

using these Oracle databases.

Responsibilities:

Built and maintained five Oracle databases, which existed on the IBM AIX

and Windows NT server during the development, testing, and production

stage of the application.

Built the OEM for monitoring the system performance, which included the

space usage, SQL statements, memo usage, and storage structure.

Developed the backup and restore database procedures.

Ensured database backups and recovery.

Developed stored procedures to implement back-end jobs such as data

transfer, archive, reporting, etc.

Upgraded the system from Oracle 8.0.3/8.0.4 to Oracle 8i.

Handled the database administration for two platforms (NT and AIX) and

six databases.

Debugged and updated the Visual Basic source code of the chargeback

automation system and the transaction processing system.

Performed enhancements on the Visual Basic code (added functions or

public modules) based on user requirements and changes in linkage

applications.

Environment: Visual Basic 6.0, ADO, Oracle 8.03/8i for Window NT, Oracle

8.04/8.1.5 for AIX, PL/SQL, SQL* PLUS, Compaq Server 5500, Compaq server

2500, IBM RS/6000 F50, IBM AIX4.2, Oracle Enterprise Management tool and

PL/SQL

General Security - DBS Cards

Aug 00 to Oct 00

Description:

This application was built on Microsoft MTS technology and was used for

the security login, user profile maintenance, application access rights

and connect string management. The end products were server components and

client components. Visual Basic 6.0/5.0 was the main developing tool and

one module was in MS Visual C++ 6.0.

Responsibilities:

Designed the application.

Setup the MTS structure.

Coded the client and server components.

Performed performance tuning and trained the developer to integrate with

other applications.

Conducted training for the application administrator and user

administrator.

Environment: Windows 2000/98/95, Visual Basic 6.0, ActiveX, ADO, Visual

C++, Access 2.0, UML (Rational Rose), MTS V2.0.

BSP Air Tickets Transaction processing System

Jun 99 to Oct 99Project Leader

Description:

This System was developed for processing Credit Card purchases of Air

Ticket transactions through the ITIA BSP system. These transactions were

an on-line processing part of the ITIA system, but an off-line processing

on the Visa and MasterCard network. As a major bank in Singapore, we

developed this system for billing cardholder accounts and made payments to

travel agents and airline companies.

Responsibilities:

Developed the project design for the whole life cycle.

Coded the interface for other systems and mainframes.

Automated the GRIO job in the application.

Environment: Visual Basic 6.0, Crystal Reports 7.0, ActiveX, ADO, IBM

PCOMM 2.0 Tool Kit 2.0, PC Trans Software, MS Access 97 and CARDLINK

Check Payment System

Jan 98 to May 98Programmer

Description:

This system was used for processing merchant payments. It was developed 4

years ago using VB3.0 and Access 2.0. The system function included the

settlement data input, check issue, check cancel, finance report

processing and merchant information maintenance. This Project was for

redeveloping the system to make it Y2K compliant.

Responsibilities:

Analyzed the old system, which was developed by another team.

Designed the new system and made the plan for redeveloping and

conversion.

Developed the system using 32 bit-programming concepts.

Changed the 16-bits API calls to 32-bit ActiveX controls.

Rewrote the security model using C++ and upgraded the Access database to

version 2.0.

Environment: NetWare 4.0, Windows 95, MS Access, Visual Basic 5.0 and VC++

4.2

Customer Dispute Processing Automation System

Sep 97

to Dec 99Team Leader

Description:

This system was used to process transaction related customer disputes,

internally referred to as chargeback. The automated system would help the

officer capture the transaction detail information from the mainframe or

from the in-house settlement database, retrieve the sale draft from the

acquired bank and complete the chargeback. The system was also used to

monitor the entire case processing and capture the case data from the

mainframe to support the case settlement. The system added about 40 cases

daily. The case processing was monitored for approximately six months to

complete the cycle of processing. The workflow engine controlled the

entire processing. This system s market value is about 1 million

Singapore Dollars.

Responsibilities:

Developed the logical and physical design of the system.

Developed the Oracle storage procedure in PL/SQL, the batch end job in

Visual C++ and also the interface between the Oracle storage procedure and

the TeamWare Workflow server.

Coded the ActiveX Controls to connect the clients of this application

with CARDLINK.

Implemented the application.

Upgraded Oracle 8.0.3/8.0.4 to 8.1.5/8.1.6.

Environment: IBM RS/6000 F50, IBM AIX4.2, Oracle 8.1.5/8.04,PL/SQL, SQL*

PLUS, AIX, Compaq Server 5500, Compaq server 2500, Oracle 8.03/8.1.6 for

Window NT, Oracle Enterprise Management tool and PL/SQL, IBM PCOMM 2.0

Toolkit 2.0, Crystal report 7.0, Visual Basic 5.0/6.0, ActiveX, RDO, ADO,

Visual C++ 4.2/6.0, TCL.

Credit Card Application System (Enhancement)

Jun 97

to Dec 97

System Analyst

Description:

This project involved the conversion of the old system to a Y2K compliant

system in addition to its constant maintenance. The system used an IBM

RS6000, AIX 4.3 and Informix 4.2. It was based on workflow using Inconcert

4.0 and image processing technology, coding server models with C++ and

client models with Powerbuild 4.0 running on Windows 3.1.

Responsibilities:

Analyzed the old system and reviewed the Informix structure.

Defined the scheduled job to run the daily batch job using shell script.

Coded the APPC programming to connect and retrieve data from the IBM

mainframe (CICS).

Handled daily maintenance and technical troubleshooting.

Environment: IBM RS/6000, IBM AIX4.2, Informix 4.2 for AIX, IBM C++,

Powerbuild 4.0 and Windows 95.

CSA Private Limited / IT&C Private Limited

Oct 94 to Jun 97

Tender Management System and Automatic File Process

Jun 96 to Jun 97Project Leader

Description:

This application assisted the officers in handling tender processing,

collecting the tendered data and completing the tendered result between

the different vendors. The system was a fully automated system that

generated the tender book and stored it in the database. The system also

allowed distribution of the tender data on electrical format and

distribution of the client interface to the vendor thereby allowing them

to fill the items in a defined format.

Responsibilities:

Designed the entire system.

Coded the auto-fax, mail and auto letter generator model using Visual

Basic 4.0 and MS Office toolkit.

Developed the PICK ODBC driver using C++.

Developed the electronic tender system using Oracle7.3, and MS-Access.

Environment: Visual Basic 4.0, Oracle 7.3, PL/SQL, SQL* PLUS, MS-Access,

C++ and MS Office 95.

Account Automation System for Silkway, Singapore Mar 96 to Oct 96Project Manager

Description:

The application was a classic accounting system and its functions

included general ledger, account receivable and account payroll. It was

used to help the users perform normal accounting processes. It was

developed as a product for sale to small companies. The application

allowed technical support to configure it so as to match the

customer s requirements. This system supported multiple accounting

systems on one server.

Responsibilities:

Designed and developed the system.

Completed GL subsystem using Visual-FoxBASE 3.0.

Migrated it to SQL server environment under Windows/NT.

Environment: Visual FoxPro 3.0, SQL Server 6.0

PWD of Singapore

Oct 94 to Jun 97Technical Support

Description:

This project was developed for the QSS office of the Public Works

Department of Singapore. The application was a management construction

project. It included the project estimated processing, pre-project

processing, tender manager and post-project processing modules. The system

assisted the government officers to manage the government projects for big

investments.

Responsibilities:

Handled the development, maintenance and extension from IBM 9309 to

PC-workstation running Windows 95.

Developed parallel running models of folio processing and re-developed

the post-contract sub-system under IBM9309, Ultimate OS/R10, PICK.

Developed a cost analysis model using Visual-Basic 3.0 that was based on

the PICK database.

Developed a multi-platform client/server system to replace the old

system and analyzed system flow and existing programs. Integrated the old

system with the new system.

Performed daily maintenance of the system.

Included enhancement features based on feedback requirements from end

users.

Environment: IBM9309 under Ultimate OS/R10, PICK, WIZARD, PICK-BASIC,

UNIX, UNIVISION, Visual-Basic4.0,Oracle 7.0 and PL/SQL.

Nanjing University of Aeronautics and Astronautics

Jul 87 to Oct 94

Production Management Information

Dec 91

to Sep 94Project Leader

Description:

The Application system was an integration of the Material Requirement

Planning and the Quality control system. The Quality data and information

subsystem was the center of the entire system. The subsystem included the

production planning, labor resource management, product cost control

system, quality control system, productivity analyst model and MRP

modules.

Responsibilities:

Performed analysis, design and implementation.

Setup the Oracle database and installed NetWare 3.11.

Performed end user and technical user training.

Developed the quality control model.

Handled the Oracle database administration during the User Acceptance

Testing period.

Environment: Oracle 6.0 (Forms 2.3, ReportWriter 2.0, PRO*C 1.5), PL/SQL,

NetWare 3.11, Windows 95, FoxPro 2.5 and C/C++.

PERT Planning and Project Information System

Mar 90 to Dec 93System Analyst

Description:

This application system was based on the system engineering theory. PERT

was the key theory used for application developing. It was used to control

and manage new aircraft model research and manufacture. This project was a

typical research project and was awarded by Government of P.R China.

Responsibilities:

Created the standard of development code and document format.

Handled general designing and integrated the subsystems.

Developed the document management system to aid the SA/SD method.

Developed the pert chart and the reports generator model.

Environment: Microsoft C7.0, FoxPro 2.5, Quick Basic 1.1 and NetWare 3.11.

Rudong Chemical plant Financial and Accounting Information System

System Analyst

Apr 88 to May 90

Description:

This system was a standard accounting system that used real time

production. The application included a GL subsystem, finance balance sub

system and a finance report generator subsystem.

Responsibilities:

Designed and developed the entire system.

Managed a five-person team.

Developed the report generator model and make it into a reuse component.

Environment: IBM/PS2/50, DOS 3.0, FoxBASE 2.0, Quick C 2.0.

Financial Budget Decision Support System

Jul 87 to Mar 88Project Leader

Description:

This system was a decision support system that was used for the

company s annual planning. The whole system was based on a model

base management including a to do budget and the evaluation of annual

planning. The basic model was built on the history operation data.

Responsibilities:

Handled system design and implementation.

Built the model base system and the data drive interfaces.

Developed the entire system.

Managed the entire project from the initiation phase to the testing

stage.

Environment: FoxPro 2.5, Windows3.11 and Quick Basic

EDUCATION:

B.S

., Computer Department

FUDAN University,

ShangHai, P.R.China, 1985

M.S

., Management Information System,

FUDAN University,

ShangHai, P.R.China, 1987

Certifications:

ORACLE Certified Professional For ORACLE8 DBA

February 2000

ORACLE Certified Professional For ORACLE8i DBA

April 2000

Sun Certified JAVA 2 Programmer

October 2000

Professional Trainings:

VISA International Workshop Training for VAP system (Authorization

processing)

April 1998

7 Habits Of Highly Effective Leaders Program

January 1999

Ascendent Transaction Software (Atp) Technical Training

February 1999

Oracle DBA Training, Oracle Global Education Center (S.E.A),

October 1999

IBM AIX OS Administrator Training

Feb 2000

IDeveloper 2000 of Oracle

October 2000

Contact this candidate