PROJECT/PORTFOLIO
DURATION :
From Dec 2002 to Jan 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
MODULE INVOLVED : Pressure Transducer,
Transmitter, Recoder, Meter, Ton.
DESCRIPTION
Pressure Gauge System was designed for both Wireless Pocket PC and
Web-based application using SQL, Crystal Report and ASP. The system can
be used for Pressure Transmitter, Pressure Transducer, Pressure Gauge, Pressure
Ton, Pressure Recorder and Pressure Meter testing. With the new PG system,
it has improved workflow and reduced job redundancy of the testing
process. The new system has cut down the operation flow from 4
steps to only 1 step by introducing one Step Dynamic Report Generation and
backend calculation without manual entry by technician to separate excel
worksheet for calculation and report printing.
Tachometer & Stroboscope Testing System
DURATION :
From Mar 2002 to June 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP.NET, C#, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Tachometer &
Stroboscope Testing was designed for both Wireless Pocket PC and Web-based
application using SQL2000, Crystal Report and ASP.NET, VB.NET and C#. The
system is designed to improve the efficiency of the Tachometer &
Stroboscope operation testing.
Gauge Block Testing System
DURATION :
From June 2002 to July 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP.NET, C#, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Gauge Block System is a
standalone application which developed using SQL2000, Crystal Report and ASP.NET,
VB.NET and C#. The system is designed to improve the efficiency of the
Gauge Block operation testing.
Aircraft Inspection Testing System
DURATION :
From Jan to Feb 2003.
CLIENT :
Inspection Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Aircraft Inspection Testing System was designed for standalone PC
application using SQL, Crystal Report and ASP. Inspection System has
improved the current job efficiency. It allows engineer to retrieve
and store all the Inspection Information to SQL database for reporting
purpose. The new system has reduced the duplicate paper work and
prevents loss of hardcopy document.
Mass Calibration Testing System
DURATION :
From Feb to Mar 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Mass Calibration Testing System was designed for both Wireless Pocket PC
and Web-based application using SQL, Crystal Report and ASP. Unlike the past,
engineer has to manually calculate the Uncertainty by picking and combining the
different set of mass value. Mass Calibration System can be used for Black
box and Wooden Box Mass set testing with the auto-calculation and combination
of different Mass weight and Balance Uncertainty based on the Mass set
combination standard (
Weighing Balance Testing System
DURATION :
From Feb to Mar 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Weighing Balance Testing System was designed for both Wireless Pocket PC
and Web-based application using SQL, Crystal Report and ASP. Weighing Balance
Testing System can be used for complicated calculation test such as
Repeatability, Departure from Nominal Value, Effect of Off-Center Loading and
Hysteresis of Weighing Balance Reading.
Pressure Digital (HECS) Testing System
DURATION :
From Mar to April 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
MODULE INVOLVED : Pressure Transducer,
Transmitter, Recoder, Meter, Ton.
DESCRIPTION
Pressure Digital Testing System was designed to integrate the DWT
equipment by using RS232 technology. It allows the tester to send the
signal/Results directly from the equipment to our SQL Database Pressure Digital
Testing System. It can be integrated to our new Pressure Gauge Testing System
in the later stage.
Force Testing System
DURATION :
From Apr to May 2003.
CLIENT :
Calibration Department.
ORGANIZATION :
Mechanical Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
Force Testing System was designed for both Wireless Pocket PC and
Web-based application using SQL, ASP and Crystal Report. Force Testing System
can be used for complicated calculation test such as Mean, Error,
Repeatability, Machine Zero error of the Force equipment. It also provides
dynamic reporting for different Force Testing Criteria.
Enhanced Automated Cube Testing System
DURATION :
From Jan to May 2003.
CLIENT :
Cube Lab.
ORGANIZATION :
Contruction Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
1
DESCRIPTION
The enhanced ACTS system will help to improve our existing work flow and
reduce the job redundancy of the cube Testing. When cube arrives, our present
ACTS system requires data entry and barcode pasted to the cube form by our
internal clerk. The enhanced system will allow barcode to be pasted on the cube
and the cube details will be entered by using our Online ACTS system via www.setsco.com
at the Customer/Supplier side. When the cubes arrive, it can be tested on the
spot in our Cube Laboratory.
TestXpert
Software
DURATION :
From Feb to Apr 2003.
CLIENT :
Concrete Lab.
ORGANIZATION :
Contruction Technology Division
SOFTWARE :
ASP, VB Script, Stored Procedure, SQL 2000, Crystal Report 8.5
O/S :
Window 2000
TEAM SIZE :
2
To installed and link the TestXpert software to Tonitrol Controller in
Concrete Lab. The software has the ability to link and automate the three
controller machine (3000KN, 600KN and 100KN) using the software interface.
Tester can just choose the type of test and provide the correct parameter to
the program to perform the test. Engineer can pre-set the parameter and save as
a template for different type of testing. Hence, it will increase the
productivity without having manual setting to the controller machine. Example
of test available are Compressive test, E-modulus, flexural strength test,
cylinder, 50x50mm cube and 100x100mm cube.
www.dreamotor.com.
DURATION :
From 7th Jan to April 2000.
CLIENT :
Vehicle Company and internet Users.
ORGANIZATION :
www.dreamforte.com.
SOFTWARE :
Cold Fusion, DB2, Perl, ASP, CGI, Java Script
O/S :
Window NT
TEAM SIZE :
3
MODULE INVOLVED : Payment Gateway, E-mail,
Account login, Database.
DESCRIPTION
The application is
developed by using Cold Fusion and Java Script for opening a new account for
Vehicle Company as well as Internet Users. It maintains daily transactions like
participating for the online sales as well as online purchase by using DB2
database. It also options for paying through the payment gateway by Using
Credit Card. The payment gateway is developed by using Perl Script. Others
subprojects include www.amazon.com and www.hp.com.my and converting the existing
multimedia project to Web-base application for Glove & Safety Company.
Das Web Application (Billing Support System Department)
DURATION :
From
CLIENT :
Global & Regional Billing, SingTel Credit Management, Billing SingTel,
Computer Operation, Billing Management.
ORGANIZATION :
SOFTWARE : HTML,
ASP, Java Script, VB Script, Java Applet, Seagate Crystal
Report, Adobe Acrobat, PowerPoint and
Macromedia Flash.
O/S :
Window NT, SQL, Oracle, and Sybase.
TEAM SIZE :
3
MODULE INVOLVED : User Access Control, Multitier
database,Crystal Report, Database and
System Administration.
DESCRIPTION
The online Web Reports
allows user to view, save and print all the reports for the projects of Billing
Support System. Analysis, Design, Develop and Implement DAS Web Report for the
projects of Billing Support System Department. Successfully introduce User
Access Control, multitier databse, Seagate Crystal Report, Acrobat Reader,
PowerPoint, Flash and Java Applet for different kind of project reports.
Converting the existing Delphi Application to Web using Corba, Active X, OCX,
multi-tier and middleware solution.
Maritime Billing System
DURATION :
From April 2000 to December 2000.
CLIENT :
Global & Regional Billing, SingTel Credit Management, Billing SingTel,
Computer Operation, Billing
Management.
ORGANIZATION :
SOFTWARE : C, Unix, Sybase, SQL, Power Bulider7.0,
Centura, Gupta.
O/S :
Digital Unix TEAM
SIZE : 4
Module Involded :
Shipmaster Update, USD Billing,
Electronic Billing, Visa Card, mail Subscription, budget call, Program for
Validation,Pricing,Billing and Invoice module of various Inmarsat Services such
as Inmarsat A/B/MB/MM/C/Mini.. Account and Rate Conversion Script. Report,
Invoice and Billing written in C and print on MS-Dos format.
DESCRIPTION
This is an integrated
system comprising of Traffic, Billing, Bill Production, Accounting and Credit
Control, Masterfile maintenance functions for International Maritime Accounting
(IMA) & International Mobile Services (IMS) to bill customers of maritime
services. Among the new IS Request is USD/SGD Traffic Billing Implementation,
Visa Card and Shipmaster Updation and Electronic Billing module.
DEBT ALLOCATION SYSTEM
DURATION :
From April 2001 to October 2001.
CLENT :
SingTel Credit Management
ORGANIZATION :
SOFTWARE : C,
Unix, Sybase,
Machine :
SUN Enterprise Server - Ultra 4500
Module Involved : Wap,
Flexi Report, Financial Year, Pre Allocation, Debt/Credit Allocation,
Auto-Email, Reconcilation
Script and batch processing.
Debt Allocation System
(DAS) generates the monthly Aging and Allocation Reports for the four major
Subsidiaries Units of SingTel Group, includes SingTel, SingTel-Mobil,
SingTel-Paging, and SingNet. Allocation
of Debts is designed to meet statistics and inquiry requirements of debts for
Corporate Finance and Credit Management to produce the Aging and Allocation
Reports based on the Allocation Rule given. In addition to providing the Aging
and Allocation Reports, DAS also generates the Penalty Charges Report, 1900 Age
Analysis Report, and Flexible Reports. First DAS Live Reports were delivered
from January 1999.
DAS also enhanced meet
the auditor's request on delivering the monthly debt status reports for the
Financial Year earned revenues. Among the new inclusion for the systems are
FY0102, WAP, Port ID and Auto Flexi Reports.
Supporting Debt Allocation
System production and implementing WAP, Financial Year 2001-2002, Flexi Report
and Port ID changes for Debt Allocation System. Solving the outstanding
problems on DAS Back-end (Unix, C) and Front-end Application (Delphi5.0).
Database and system backup.
WORLD SOURCE BILLING SYSTEM
DURATION :
From June 2000 to October 2001
CLENT :
SingTel Billing Operation
ORGANIZATION :
SOFTWARE : C, Unix
Shell Scripts and Sybase, Gupta SQL
Machine :
SUN Enterprise Server - Ultra 3500
DESCRIPTION
A group of
Telecommunication Companies (AT&T, KDD, and SINGTEL) that individually
enter into the World Partners Association Membership Agreement with World
Partners Company (WPC) and thereafter provide the Association offers as specified
in the Association Membership Agreement. World Source Offers the three basic
telecommunication services as a global offer for the Multi National Customers
to manage their global business under one umbrella.
- World Source Virtual Network Service (WS VNS)
- World Source Global Private Line (WS GPL)
- World Source Global Frame Relay (WS GFR)
Supporting World Source
Billing System production. Debugging the problem for the LM (Lead Member) and
SM (Support Member) process of the Invoice and Conversion program to make sure Bill deliver to customer
on time.
GSM/PCN/Auto-Email SYSTEM
DURATION :
From June 2000 to October 2001
CLENT :
SingTel Billing
ORGANIZATION :
SOFTWARE :
Machine :
SUN Enterprise Server - Ultra 3500
DESCRIPTION
Client Server based GSM/PCN
Invoicing System down loads the oversea operators charge details from CSI
Mainframe system, and generates the monthly invoices. The system also provides
the facility for sending the softcopy monthly Invoices and Accounting Statement
to oversea operators through Auto E-Mailing. The system is also enhanced to
support CROSS ROAMING and DUALSIM Networks in addition to the GSM/PCN Networks.
To introduce auto-email to user for the request of some important reports.
Database and System Administration.
A. Maritime Billing System- Shipmaster
Updation.
DURATION :
From April 2000 to June 2000.
CLIENT :
Global & Reg'l Billing
ORGANIZATION :
SOFTWARE : Power
Bulider7.0. Unix shell script, Sybase C, SQL.
O/S :
Digital-UNIX.
DESCRIPTION
Ship Master Input Files are received on daily basis from all over the world via
ESAs for various inmarsat services (A, B/M, C and MINI-M) to update Account and
Ship Details in the MBS system. PC based existing Gupta program is very slow in
processing the daily files from ESAs. By using the power of C and Shell Script,
it accepts input files from PC and process them at UNIX; this gives higher
speed and more flexibility. Front-end screen is developed by PowerBuilder7.0
and it allows user to print the necessary control reports from the same PC
interface. The new approach is transparent to user, which means they will be
given similar existing interface to process the daily ship master files with
the better response and speed.
B.
Maritime Billing System- New Visa Card payment.
DURATION : From
April 2000 to April 2000.
CLIENT :
Global & Regional Billing
ORGANIZATION :
SOFTWARE : Power
Bulider7.0. Unix shell script, Sybase C, SQL
O/S :
Digital-UNIX.
DESCRIPTION
Write a store procedure in Sybase for the use of C program to populate data in
the Visa Card customer for billing purpose. Front-end is developed by using
PowerBuilder7.0 to print the receipt. Among the table affected are Accounts,
Invoice Details, Invoice Header and etc. Verify and test the results by running
the Billing and Invoice module in C program.
C. DEBT ALLOCATION SYSTEM
(WAP/PORTID/FY0001/0102/Credit Allocation)
DURATION :
From December 2000 to April 2001.
CLENT :
SingTel Credit Management
ORGANIZATION :
SOFTWARE : C and
Sybase, Delphi, Unix Shell Script
Machine :
SUN Enterprise Server - Ultra 4500
DESCRIPTION
New Inclusion for DAS is WAP Billing, SMS Port ID and Financial Year
0001/0102 processing and reports. Impacted program for Wap Billing (Back-end)
are Pre Allocation, Debt Allocation, Report Generation, and Credit Allocation. Impacted program for
Financial Year (Back-end) are Financial Year (FY) Allocation, FY 00/01 Report
Generation and DAS operational script. Impacted front-end application is DAS
application developed by using
D. Auto-Flexi DAS Aging Reports/Debt Allocation System
DURATION :
From November 2000 to January 2001.
CLENT :
SingTel Billing Operation
ORGANIZATION :
SOFTWARE :
Machine :
SUN Enterprise Server - Ultra 3500
DESCRIPTION
To view what are the RCs
& PICs tied to each CFU groups, user had to manually create the correct
PICs and RCs code tied to each CFU group from the Flexible Report Id table and
view the PIC+RC Aging Reports details. System was enhanced to automate the RC
& PIC sorting by CFU & Company Groups from the DAS Flexible Reports ID
table for viewing and printing which involved logical and database programming.