Daniel Ng
Email Me Contact Me

You're welcome to email me at dng11@sympatico.ca.

While I do like hearing from you, I am not interested in SEO services nor offshoring my business, so please don't offer me any.

Follow me on Twitter Subscribe to my RSS feed

My Portfolio

Here is a sample collection of my past works:

Click to view screenshot(s) ASP.NET Application

Custom Captive Portal/Splash Page

This is a custom-built externally-hosted captive portal (a.k.a. splash page) that works with the Cisco Meraki cloud. Before a member of the public can connect to the free public WiFi, the user will be redirected to this custom authentication page and the user must accept the terms of use. The user can either connect as a member (i.e., sign on using their library card number) or as a non-member. The difference being that authenticated members can enjoy faster Internet speed. I was the chief designer and developer.

Keywords: ASP.NET 4.5; jQuery; SQL Server; SSID; Captive Portal; WiFi; IguanaXgateway Web Service
Click to view screenshot(s) Windows Application

Building Permits & Inspections Application

This application is developed for building inspectors to issue building permits, orders and inspection reports while out in the field. This is an Occasionally Connected Application (OCA) that can work even when there is no Internet/network connection. The application UI is designed with Windows Surface tablets in mind, and data entry is streamlined to improve user experience. A custom sync will perform a bi-directional synchronization between locally stored data and a centralized SQL Server database. Furthermore, new permit data will integrate seamlessly into the Vadim's iCity system. I was the chief designer and developer.

Keywords: VB.NET 4.5; SQL Server; ClickOnce
Click to view screenshot(s) HTML5 Website

2015 Great Lakes and St. Lawrence Cities Initiative Annual Conference Website

This is a modern one-page responsive HTML5 website based on the Bootstrap Framework. I was the sole designer.

Keywords: HTML5; jQuery; Bootstrap Framework
Click to view screenshot(s) ASP.NET Application

Email Subscription System

This is an ASP.NET public facing application developed in part to meet the Canada Anti-Spam Legislation (CASL) requirements. Any member of the public can freely subscribe (or unsubscribe) to our email list via this application, and all contacts will automatically be added to the appropriate Universal Distribution Groups in our Exchange server. In this particular system, I leveraged PowerShell scripts to manage all mail contacts and members in Universal Distribution Groups. I was the chief designer and developer.

Keywords: ASP.NET 4.0; SQL Server Enterprise; T-SQL; Microsoft Exchange; PowerShell; Universal Distribution Group
Click to view screenshot(s) Windows Application

OSIM Bridge & Culvert Inspection Program

This is a stand-alone Windows application with SQL Server back-end. It supports both SQL Server Enterprise and Compact Editions. The latter is meant to be used in a disconnected environment. This application provides a single access point to all bridge & culvert data and also to all photos and any other supporting documents. It is also designed for engineering staff to enter new OSIM bridge inspection data. Both the Bridge Condition Index (BCI) and the Bridge Sufficiency Index (BSI) will be auto-computed by the program. Overall, this is a rather typical CRUD application. One of the interesting parts, however, is that most of the form controls are added dynamically at runtime based on database values. I was the sole designer and developer.

Keywords: VB.NET 3.5; ADO.NET; Dynamic Control; SQL Server Enterprise & Compact Editions; T-SQL
Click to view screenshot(s) Windows Application

Sudoku Solver

I'm an avid fan of Sudoku. I got bored one day and this was the result - a Sudoku Solver! This is a stand-alone Windows application. The program is capable of solving the puzzle at any level of difficulty. Yes, I do realize that this would take the fun out of playing the game. Like I said, I was bored.

Keywords: VB.NET 3.5; Custom User Control
Click to view screenshot(s) ASP.NET Application

Employee Information Portal (EIP)

This is an ASP.NET intranet application designed for employees at Lambton County. This application intergrates with the County's HR and financial system, and also the Active Directory. It has many features, including (a) online employee performance appraisal system; (b) employee photo directory that also displays reporting structure; (c) real-time employee statistics; (d) a peer-to-peer online recognition program called "Kudos", and many more. I was the sole designer and developer.

Keywords: ASP.NET 3.5; ASP.NET ListView Control; ASP.NET Charting Control; SQL Server 2008; AJAX; HTML; CSS; T-SQL; LINQ to SQL
Click to view screenshot(s) Windows Application

Timesheet

This is a stand-alone Windows application initially designed for Public Works staff to enter both labour and equipment time. This program was later integrated with a fuel management system. Staffs are now able to track fuel consumption at various depots and also to view fleet meter readings. Furthermore, fleet meter readings are also automatically being fed into a separate asset management and preventative maintenance system. The preventative maintenance system will auto-generate maintenance work order based on meter readings. I was the sole designer and developer.

Keywords: VB.NET 3.5; Microsoft Chart Controls; ClickOnce Deployment; SQL Server 2008; T-SQL
Click to view screenshot(s) Windows Application

Inventory Issuing

This stand-alone Windows application simplifies the inventory issuing (and returning) process for staff. It is designed for batch issuing items and the program has a support for barcode scanner. This application integrates with Maximo Asset Management system, which also served as an inventory system in this case. I was the sole designer and developer. For more information, please visit this link.

Keywords: VB.NET 3.5; Microsoft Chart Controls; Barcode Reader
Click to view screenshot(s) ASP.NET Web Application

Newcomer Employment Options (NEO)

A professional mentorship web application built with ASP.NET. This is a Government of Ontario's pilot program to help communities outside of the Greater Toronto Area to recruit qualified internationally trained individuals. This application allows a mentor to adopt a mentee and to track his/her progress through a one year internship program. I was the sole designer and developer.

Keywords: ASP.NET 3.5; ASP.NET ListView Control; ASP.NET Charting Control; ASP.NET Membership; SQL Server 2008; AJAX; HTML; CSS; T-SQL; LINQ to SQL
Click to view screenshot(s) InfoPath + SharePoint

Work Related Employee Incident/Accident Report

This is a full-trust browser compatible InfoPath form published to the SharePoint Server. It receives and submits data via a custom ASP.NET Web Service. Form submitted is parsed and stored in a database. I was the sole designer and developer.

Keywords: Microsoft InfoPath 2007; ASP.NET Web Service; Microsoft Office SharePoint Server; SQL Server 2008; XML
Click to view screenshot(s) MS Access Application

Budget Minutes Program

This is an MS Access application designed to record live budget motions at council meetings. The program will calculate and display real-time budget numbers. Also, it will record council votes, which are weighted, and will calculate and display instant voting results. This program has an Access front-end and a SQL Server back-end. I was the sole designer and developer.

Keywords: Microsoft Access 2007; SQL; SQL Server 2005; VBA
Click to view screenshot(s) Standard Website

Learning Disabilities Association of Lambton County

A clean and simple HTML+CSS website for the Learning Disabilities Association of Lambton County. I was the sole designer and webmaster.

Keywords: HTML; CSS
Click to view screenshot(s) MS Access Application

Zi Wei - Ancient Chinese Astrology Interactive Charting System

This is an MS Access application for plotting ancient Chinese astrology Zi Wei Dou Shu chart (which is also known as the Purple Star Astrology). It generates dynamic birth chart and also the 1 year and 10 year luck chart. The program can generate chart in both Chinese and English. I was the sole designer and developer.

Keywords: Microsoft Access 2007; SQL; VBA
Maximo Customization

IBM Maximo Asset Management

I have been a Maximo Asset Management System Administrator/Developer since 2009. I have (a) helped implement Maximo 7.1; (b) developed custom BIRT reports, MBO classes, workflows and applications; (c) set up integrations to other external information systems; (d) applied fixes and upgrades; and etc.

Keywords: Java; Eclipse BIRT; SQL Server; T-SQL; MBO Customization
Click to view screenshot(s) Standard Website

Lambton County GIS Web Portal

A clean and simple HTML+CSS website for showcasing Lambton County's GIS services and data. I was the sole designer and developer.

Keywords: HTML; CSS
Click to view screenshot(s) GIS Mapping

Thematic Maps

A series of thematic Maps in PDF format showing census information of Lambton County. I was the sole designer and analyst.

Keywords: GIS; ArcMap; Statistics Canada census data
Click to view screenshot(s) ASP.NET Web Application + GIS

Lambton County Local Services & Facilities Finder

This is an ASP.NET web application for searching services and facilities within Lambton County. Public can search services by keywords, location or both. I was the sole designer and developer.

Keywords: ASP.NET; ArcObjects; ArcGIS Server 9.2 with cached map service; ArcGIS Web ADF; AJAX; SQL Server 2005 and Full-Text Search
Click to view screenshot(s) ArcGIS Extension + Simulation

MapNow - An ArcGIS Extension

This is a land-use visualization tool designed to work in conjunction with A Landscape Cumulative Effects Simulator (ALCES) computer model. It produces realistic maps of future landscape according to ALCES outputs and it allows users to visualize the various impacts of land-use management policies. I was the lead developer.

Keywords: GIS; ArcMap; ArcObjects; VB.NET; ALCES
Click to view screenshot(s) ASP.NET Web Application

Health & Safety Environmental Plans (HaSEP)

This is an ASP.NET intranet application developed for an environmental consulting firm to administer electronic Health and Safety Environmental Plans. I was the lead developer.

Keywords: ASP.NET; SQL Server 2000; SQL Server Reporting Services
Click to view screenshot(s) InfoPath + SharePoint

Borehole Data Entry Form

This electronic form is designed for field staff to collect borehole data while out in the field. Completed form is then submitted into a SharePoint document library for supervisors to review. Upon approval, a custom SharePoint library event will submit the entire form to a custom Web Service to have the entire form content parsed and stored in a database. I was the lead developer.

Keywords: Microsoft InfoPath 2003; Microsoft Office SharePoint Server; ASP.NET Web Service; SQL Server 2000; SQL Server Reporting Services; Custom SharePoint Library Event Handler; XML
ASP.NET Application + GIS

Commitments, Sensitivity & Complaints Tracking System (CSCT)

This is an ASP.NET intranet web application developed for a large oil and gas exploration and production company to track and manage obligations to land owners. This application has GIS capabilities integrated into it. I was the lead developer.

Keywords: ASP.NET; Oracle; Crystal Reports; ArcObjects; ArcGIS Web Application Developer Framework (ADF)

Copyright © 2013 www.xcentricway.ca. All rights reserved.