Coland Chan - IT System Developer, Financial Planner

Coland Chan is an IT System Developer and IT Support Engineer in Hong Kong, he familar in:
  • Programming Language
    • PHP, ASP.NET
    • HTML5, CSS3
    • jQuery
  • Database
    • MySQL, MSSQL, Access
Coland Chan is a Financial Planner, he graduated in:
  • Insurance
  • Investments
  • Taxation & Tax Planning
  • Employee Benefits & Estate Planning
  • Advanced Financial Planning

By


Certification

Licensing Examination for Securities and Futures Intermediaries

The Licensing, Examination for Securities and Futures Intermediaries (LE). Practical and market-oriented exam is developed from the entire financial services industry, regulators, academics and practitioners to assist.

 

Associate member of
IFPHK - Institute of Financial Planners of Hong Kong

The financial planning process is straight forward step to provide you with Plan of action aimed at achieving financial objectives and financial position.

  • Establishing client-planner relationships
  • Gathering client data and determining goals and expectations
  • Determining the client's financial status by analyzing and evaluating client's information
  • Developing and presenting the financial plan
  • Implementing the financial plan
  • Monitoring the financial plan
 

First Aid Certificate, St John Ambulance

Hong Kong St. John Ambulance, 1884, since it served as some social and charity, can be traced back a century or more have a long history.

Hong Kong St. John Ambulance Association has been founded in 1884 by emergency services of the Board of Directors in 1916 and 1949. , The emergency ambulance services and first aid instructions in the program for first aid and public organization dedicated to people with disabilities, the "personal services" stick to its motto, teeth, of home care.

 

MPF Schemes Examination

Mandatory Provident Fund ("MPF"), which plays an important role in helping local residents access to basic retirement protection. Retirement age, people of Hong Kong, as expected, combined with the life of the people of Hong Kong will increase more and more, (which should have reached the age of 65, 2039 28% of the population).

MPF system is one of the three pillars of protection of the other two pillars of retirement savings and insurance and voluntary safety net of social security. Employer and employee to participate in the MPF contributions on time, in fact, the future is useful to be able to take advantage of people's lives of the existing work is stable and comfortable.

 

Insurance Intermediaries Quality Assurance Scheme Examination

By the Vocational Training Council by the Insurance Intermediaries Qualifying Examination registration / authorization conditions, unless exempted, otherwise all insurance intermediaries, their chief executives / responsible officers and technical representatives. They must also comply with the requirements of continuing professional development program.

Skype Bot

Skype Bot, an online dictionary robot for Skype
  • Instruction:
    • Search col.bot and request for a contact authorization
    • You will be authorized in a second
    • Send him a vocabulary, e.g. computer or whatever you want
    • He will explain the vocab to you in a second, like a dictionary

Instant Messenger

Instant Messenger WebApp for iPhone http://im.colandchan.com
  • User Functions:
    • Advanced user search
    • Online/Offline messages
    • Private message, multiple users group chat
    • Photo sharing
    • Users can send private messages (PM), or how the system can provide a private chat room facilities
    • All other users of the user's login and chat
  • Management Features:
    • Backend user profile modification
    • Offline user registration
    • General usage chart analysis
    • List the form of reports, the most active users

By

Homework Checking System WebApp

Homework Checking System WebApp
http://www.tpsy.edu.hk/homework-checking-system
  • Admin Functions:
    • Add/Modify homework and test
    • Assignments analysis
    • Report generation
  • Frontend Functions:
    • Homework projections

By

CMS - Content Management System

Multifunctional content management system
  • Frontend Functions:
    • Slider module
    • Dynamic SEF - Search Engine Friendly URL
    • Online credit card payment gateway
    • Membership restricted area
    • Paperless e-Invoice/e-Receipt
    • Online blog
  • Administrative Functions:
    • Articles update/post
    • Menu module
    • Widget function
    • Frontend membership system
    • Invoice system
    • Photo gallery management
    • Events announcement
    • Publications
    • Newsletter EDM
    • File management tools
  • Developers Functions:
    • System variables configuration
    • Server healthy check
    • Database backup/restore

By

ERP System

ERP System.
This is a commercial ERP - Enterprise Resource Planning System, include the following functions:
  • Core functions
    • Account, Logistics, Human Resources System
    • B/S Intranet/Internet based system environment
    • EDI industry standard
  • Invoice/Admin System
    • Real time PDF convertion
    • Cargo tracing system
    • Parcel package status tracking

By

iPad Simulator

It is to emulate Flash object on iOS device. You may know how is your website on an iPad by http://ipad.colandchan.com.
Simulator Functions:
  • Remove Flash objects in the target site
  • HTML5 contact form validator demonostration

By

Career Times, Visual Basic ASP.NET

It is a platform provide to employer and job seeker to match the partnerships.
It is a Web Application made by VB - Visual Basic .NET 3.5 Framework, with Microsoft SQL server instance. The system used to matching employers and job seekers, job posting site design and development of Web applications. http://careertimesvb.colandchan.com
  • Employer
    • Employers use the Web application, and publish their vacancies to attract job seekers. Former employers can post job vacancies, the employer must be registered with the site. The employer can once vacancies in various positions of the site.
    • Job posting, description
    • Inverted search to job seekers
    • View/modify/delete job applications
  • Job seekers
    • Vacancies to find their own preferences and ability to match job-seekers using the Web application.
    • Job search, apply and appointment
  • Search Function in one or more of the following vacancies:
    • Job category (selected from a pre-defined list)
    • Years of experience the job seeker has
    • The highest level of academic qualification acquired by the job seeker
    • Name of the job title of the desired job openings
    • Employment term
  • Administrator
    • Add or delete the types of work on the site
    • Whenever he / she found that the vacancies are inappropriate Web sites, delete the job opening

By

Friend's Food Cooperative

It is a project that to develop a system in local office of Friend's Food Cooperative in Hong Kong. http://food.colandchan.com

Rapid commodity price increases in recent years, especially in many popular foods, has accumulated a lot of complaints. Even many low-income families need to save money, in order to reduce the intake of food. Some non-governmental organization (NGO, for example, the YMCA and Oxfam) on this issue great concern, and an informal gathering, they want to form a "Friends of the food co-operatives" to help its members to The relax sharing the bulk of their funding pressures in the procurement of wholesale prices and / or get some food from food banks in Hong Kong. So they formed a "friend of the working group in Hong Kong, food cooperatives, from the Boys and Girls Club Association (BGCA) Mr. Peter Chan, chairman of the nomination.

The Working Group thought the Colca Friends of the cabin process model case studies, in his structured analysis and design "(instructions attached) offered a similar run operation. A local NGO, each center is the center of the specialized center of a regional office (LO) and the NGO or a group of NGO's in the case of the head office.

The Working Group believes that the operation of the cooperatives through a Web-based information system to support the administrative work will be minimized between the LO and the LOS and Members. In addition, a few years ago, a student of the NGO and government projects a computer (or computer) Recently, the Government has funded in need of home Internet connection. Therefore, their family members in the majority of members of the computer connected to the Internet services, which can be orders through the network, rather than by dragging and dropping to fill in the form of collection boxes at the local center. However, they still can be arranged without a computer or Web site for whatever reason, do not want to order the box. Payment convenient and simple, the Working Group recommends that the two bank accounts at HSBC and BOC (two of the most popular bank in Hong Kong). One member will be credited to his / her payment, charge into the computer, the total amount due to intend to mail-order form. He / she can deposit the amount of accounts or directly through the ATM money transfer. Members can enter the system to confirm the date and time on the order of payment receipt number or ATM transfer slip. Members should continue to pay for their proof of payment / remittance receipt / slip.

By

Smarty Car Park Management System, Arduino car park project

with Arduino ultrasonic sensor supported

The server communicate with Ardunio board with parking sensor to retrieve parking bay availability and sync with database


The project Smarty Car Park Management System is a full car park management solution in order to strengthen the existing car park management system, so it can provide what parking, staff can more easily find free parking, this is the ID number of the data in the parking lot. The car park management system uses Arduino ultrasonic sensor to detects the availability of parking lots. Staff or security personnel can access the system through mobile devices, when they walk to the car park around the security check. For the use of state of each car park management and mobile device browser, you can streamline the human resources, including but not limited to the duty officer and security personnel actually operating costs down.

The availability of car parks can also be displayed at the entrance of the driver. Facility information will be displayed in each layer the number of parking, so they do not waste too much time to browse around the parking lot, which may attract drivers to use the parking lot, and the lack of information displayed. May also include at the entrance can be scanned by the driver's hand, so they will have real-time updates of their hands, the availability of QR Code.

Using the data collected can be used as drawing graphics to analysis using the flow, so to find out the terms of hours, one day, or average parking time during weekdays. This will help the transfer price of the strategy most likely to increase in the peak time hourly rental. This will also help determine how to collect, such as rental step up to half an hour, drivers like. High utilization rate of the parking lot, drivers of all ages, for whatever reason, the most recently used at the mall, so the company may consider switching to a fixed monthly rental of parking, the parking lot a higher rent. rate by the owner.

The project will include a common billing system, the calculation of the hourly rental fee. Then, it will establish and concentrated on determining the sensor installed in each car park provides free parking. So when vehicles entering or leaving the parking lot, the sensor will send the movement of the server machine and parking lot ID of.

The system also can provide a lot number of the supply of parking in the parking lot, parking lot is full, the entrance will be blocked until another one to exit the parking lot to the release of a parking lot. The sensors are installed in each car park, the location of the parking lot will be displayed at the entrance, so the driver did not visit the security around the most time. In addition, managers can easily find parking may still be able to direct access to the system.

By

Windows 8 / Server 2012 Stuck with VMWare ESX/ESXi

Solution of getting Windows 8 / Server 2012 boot up in VMWare ESX/ESXi

Windows 8 and Windows Server 2012 RTM have just been released a days ago. As you may have same issue with me: Windows Server 2012 getting stuck with boot up screen in VMWare ESX/ESXi. The issue has been reported in WMWare official Knowledge Base (ID: 2006859) saying ESX/ESXi 4.0 is no more supported on 4.0 or 4.1. For ESX/ESXi 5.0 it has to be updated by Patch Release ESXi500-201112001. Here is the instruction to do so:

Here is the screen stuck with ESX/ESXi:

Now go to VMWare product download page, locate ESXi500-201112001 and download

Open vSphere Client, under the tab "Configuration" select "Security Profile" and "Properties"

If the SSH Daemon is stopped, click "Options" then "Start" to enable SSH connection

At the summary screen, locate the datastore and select "Browse Datastore". Please record the name of this datastore that we have to use later, in this case the name of datastore named datastore500

Select "Upload File" and the patch ZIP file you just downloaded from VMWare website

The upload process will only takes a minute to complete

Now confirm the file has been uploaded to datastore

On this stage, all VM instance have to be turned off before continue. Now change the host to Maintenance Mode by "Enter maintenance Mode" under "Inventory" and "Host" at main screen

To connect the host, a SSH client is required. Here I suggest PuTTY that is free to download

At PuTTY Configuration, input the host IP address, leave all settings default and click "Open"

The host will ask for login name and password. Please provide the same with the one you are using. Here will be an option to get the current running version as a reference by the following command:

esxcli software profile get

The host will ask for login name and password. Please provide the same with the one you are using. Here will be an option to get the current running version as a reference by the following command:

To patch the host, the following command is required:

esxcli software vib install -d /vmfs/volumes/datastore500/ESXi500-201112001.zip

The path "/datastore500" depends of the datastore name that you may have to modify

At the vSphere Client main screen, click "Reboot" and input the patch number as a reference.

Bingo! You may now continue to your previous Windows 8 / Windows Server 2012 installation.

No database selected