Project Experience

Client	Project	Brief Description
Prudential Hong Kong Limited	Web-based Quotation System	A web-based system was developed for Prudential Assurance in 2008. Today more than 20,000 agents in Hong Kong are currently using this system to present the proposals to their clients. ¡P The system could be run as off-line mode and on-line mode. Regardless of which versions, the underlying business-logic objects are common. ¡P The UI is revamped so that user could easily learn to use as a simple web application. ¡P After the system validation and calculation, the illustration will be shown as a PDF file. ¡P This system utilized the latest technologies such as J2EE, AJAX, WebSphere, DB2, .NET, Jasper Report, Web Services ¡K etc. ¡P Up to the present moment, we are proud to provide more than 50 enhancement versions to this system. ¡P The system is upgraded to support the browser on the mobile platform such as iOS, Android and Windows
Fubon Life Insurance (HK) Co Ltd.	Illustration System	A web-based Illustration system was developed for Fubon Life Insurance in 2016. It provides an online platform for brokers to generate illustrations to their clients. ¡P The responsive UI layout design is flexible to support various form factor device, from desktop browser to mobile phone browser. ¡P After the system validation and calculation, the illustration will be shown as a PDF file. ¡P This system is developed by using J2EE, Jasper Report and SQL Server. ¡P Up to the present moment, we provide more than 10 enhancement versions to this system.
Prudential Hong Kong Limited	Windows-based Quotation System	A professional and portable quotation system was developed for Prudential Assurance in 1999. ¡P Complex calculation logics are built into the separated components, which simplify the frequent update problems. ¡P Present the proposal to the client with specific layout for particular products. ¡P The system was developed by Visual Basic 6 and Crystal Report.
Prudential Hong Kong Limited	Sales Reporting System	This system is targeted to provide the daily operational and management reports upon the user requests. ¡P Over 30 reports were developed in this system. The reports output are in Excel file format and could be sent to the requesters by email. ¡P Provides UI to allow the batch data upload to the backend database ¡P The system was developed by .NET 2008, Excel objects and Crystal Report. The major data source is come from Informix database.
Deloitte	Business Contact Database	This system is cover business contact information currently maintained by regional C & M team. ¡P Bilingual capability. ¡P Administration of user security profile and data access right. ¡P Data input and extraction based on desire selection criteria. ¡P System can be access at event site via internet. ¡P The solution is developed by using ASP.NET 2.0 and SQL Server 2005.
Deloitte	Tax Tracking System	Tax Tracking System is a web-based system which allows partners or supervisors to keep track the tax return process of their clients ¡P Users could enter their client and tax data to the system via the web UI in an interactive or batch mode. ¡P Since the same record could be updated by a number of users at the same time, in order to prevent whole record overwriting, system will compare the changes and allow the update of the modified fields only. ¡P Mail will be automatically sent to remind the responsible persons about the critical milestone for their corresponding jobs. ¡P A year cut-off function is provided for copying the current data to the next financial year as a quick startup. ¡P The solution is developed by using ASP.NET 2.0 and SQL Server 2005.
ING Asia/Pacific Ltd.	SharePoint Portal Customization and data Migration	We work with the Microsoft Consultant Team to provide the following services to ING on their existing Microsoft SharePoint Portal: ¡P Build a custom search page to allow Portal Site Searching by Country and Site with customized sorting. ¡P Apply a migration tool to migrate the data (document library, custom list, events, discussion board and survey) from the existing site to a new site structure.
Joy Group Ltd.	POS System	The POS system is run in on-line mode, so the transaction done in any branch can be reflected in the Head Office. The inventory information of a location can be retrieved from any locations. ¡P Currently it is run on 4 remote sites and allows concurrently about ¡P By applying the Client-Server via Web Services architecture, it can support large data volume and secure transaction processing without the physical location limitation. ¡P Other features include: batch price changing system, special security handling in sales, print preview system, real-time credit control, multiple payment on the same transaction, supports standard bar-code scanner and cord-less bar code scanner, ¡K etc. ¡P The solution is developed by using C# and SQL Server 2012.
Invest Hong Kong	Knowledge Management System	We work with the Microsoft Consultant Team and HP project team to develop a web-based Knowledge Management System for Invest Hong Kong In this 12-month project, we provide the following services: ¡P Develop and implement a SharePoint Portal Server 2003 solution integrated with customized features of Document Rating, Rollup Calendar, Personal To-Do-List, Searching with Customized fields, Active Directory Synchronization ¡K etc. ¡P Various reports are developed by using SQL Server Reporting Services to produce the site usage analysis, staff contribution, document rating list, ¡K etc. ¡P Implement the data migration by using the customized migration tools. It automates the large volume data upload within a limited time frame. ¡P The involved technologies and platform are: ASP.NET, XML Web Services, SharePoint Object Model, SQL Server Reporting Services and Active Directory Services.
China Light & Power Co., Limited	Electronic Billing System	This system provides an alternative to traditional billing for CLP, it supports e-mail, Fax and Traditional Billing. The system has been built with some unique features: ¡P N-Tier design, easy to add server to support the future growth ¡P Customized bill template design tool with text overlay, barcode, OCR fonts, chart, ¡K support ¡P Generate Excel, PDF, JPG files as email attachment ¡P Real time bill data merging function ¡P Support Multi-Channel Fax Server ¡P Mainframe data coding (EBCDIC) conversion
Vocational Training Council	MIS Financial Reporting System	This system was developed by using ASP.NET, Crystal Report.NET and SQL Server to provide Financial Data Analysis to their finance department. ¡P Integration with the existing Enrollment System to minimize the redundant data entry effort ¡P Provides a easy-to-use data entry system for the input of the course, class, cost-center, trainer, product, ¡K etc. ¡P Provides various kinds of financial data analysis reports for ad-hoc review such as comparison report, staff performance, operation reports ¡K etc.