System Project
Resume:
To:
Subject: Please review my resume. I look forward to hearing from you.
Date: Wed, 25 Jul 2001 08:53:10 +0100
Contact Information: abp2lg@r.postjobfree.com
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