• Wordpress website.
• Videos and audio samples.
• Preview of the author's new novel in built-in PDF reader.

Visit online: robertsultan.com
Tools: Wordpress 6
Developed: 2022

• One page static website.
• Bootstrap framework.

Visit online: windywaters.ca
Tools: HTML5, CSS3, jQuery, JavaScript, Bootstrap
Developed: 2021

• Web site optimized for mobile devices.
• List with all data collection points and links to the individual data entry screens.
• On the phones, data is only accessible and editable for the current day.
• Desktop program for viewing and further processing.

Tools: ASP.NET, VB.NET, SQL Server 2016, T-SQL, HTML5, CSS3, jQuery, Javascript, Bootstrap, MS Access
Developed: 2020

• Custom animations in homepage slider.
• Portfolio with filter function and overlays for project summary
• Bootstrap framework.

Tools: HTML5, CSS3, jQuery, JavaScript, Bootstrap framework, ASP.NET, VB.Net
Developed: Since 1999

• Online since 2002; major redesigns in 2013 and 2019.
• Custom content management for all sections including timeline.
• German language.

Visit online: www.greenvalue.de
Tools: ASP.NET, VB.NET, SQL Server 2016, T-SQL, HTML5, CSS3, jQuery, JavaScript, Bootstrap
Developed: Since 2002

• Travel stories and photos
• Resource section for Culture, Language, and Travel

Visit online: www.AdventureChina.ca
Tools: HTML5, CSS3, jQuery, JavaScript, Bootstrap
Developed: 2017/2019

• One page static website.
• "Accordions" that can be collapsed or expanded to keep the site compact.
• Bootstrap framework.

Visit online: CRRotaryWineFest.ca
Tools: HTML5, CSS3, jQuery, JavaScript, Bootstrap
Developed: 2019-2020

• Funded deals with filter function and overlays for project summary.
• Custom content management for projects and news.
• Bootstrap framework.

Visit online: NorthlandMortgage.ca
Tools: HTML5, CSS3, jQuery, JavaScript, Bootstrap, MS Access
Developed: 2018-2019

• Originally a stand-alone website.
• Now part of the myRealPage framework which hugely reduced cost and simplified maintenance.

Visit online: BobDavidsen.bc.ca
Tools: myRealPage framework
Developed: 2018

• Integrates seamlessly with the existing Board & Committee Meeting software.
• Web interface for staff where they can comment on action items.
• Existing desktop application allows administration to modify, accept, reject, and close action items.

Tools: ASP.NET, MS Access, SQL Server, Zurb Foundation
Developed: 2018

• Upgrade from an Access solution designed by another developer in 2005.
• Moved back-end to SQL Server.
• Access to program and confidential resolutions is now controlled through AD groups.

Tools: Access 2016, SQL Server
Developed: 2018

• Grouped by focus or sector.
• Extensive filter functions with the option to save and re-use searches.
• Event tracking.
• Email recipient list creation.
• Subscriber lists.

Tools: Access 2016, SQL Server
Developed: 2017/2018

• Case screen with simple and advanced filter options.
• Color highlighting as follow-up reminders.
• Statistics
• Data conversion and attachment extract from previous database.

Tools: Access 2016, SQL Server
Developed: 2017

• Loss-less data conversion from three almost identical Works databases.
• Kept simplicity and familiarity of the previous program.
• Custom ribbon for all essential functions such as search and print.

Tools: Access 2013/2016
Developed: 2017

• Daily blueberry harvest recording including pickers and time spent picking.
• Blueberry harvest summary for any given time period.
• Daily sales recording including receivables tracking.
• Sales summaries for any given time period.
• Blueberry U-Pick.
• Produce and value-added product sales.
• Extensive and flexible customer reports by customer, products, and sales value.

Tools: Access 2016
Developed: 2016

• Unlimited plant locations.
• Three different permission groups per plant: admin, technical, and read-only.
• Convenient user, permission, and project administration.
• Extensive filtering and Excel output.
• Mobile friendly ASP.NET web pages.

Tools: SQL Server, ASP.NET, Zurb Foundation
Developed: 2016

• Searches for text in all minutes; can be narrowed to a date range and select committees.
• Utilizes client certificates to determine if results from confidential meetings are included or not.
• Left bar contains search criteria; collapsed when search results are shown.
• Displays meeting dates, board or committee names, paragraphs that contain the search phrase, and links to the related meeting minutes.
• Mobile friendly ASP.NET web page.
• Fast – even if a very large number of records meets the criteria.

Tools: SQL Server, ASP.NET, Zurb Foundation
Developed: 2015-2016

• Searches by Roll # or PID or (partial) property address or (partial) owner name.
• Data is selected from a variety of VADIM SQL Server tables and other sources.
• Considers properties that have multiple PIDs and multiple owners.
• Owners and Residential Inventory are only retrieved after clicking the corresponding buttons. This ensures that the pages are always loading fast.
• Mobile friendly ASP.NET web page.
• Now a stand-alone intranet page, the underlying functions will later be used for GIS integration.

Tools: SQL Server, ASP.NET, Bootstrap
Developed: 2015-2016

• Stores and looks up data in a new SQL Server and a legacy MS Access database.
• Imports all new orders into the in-house system.
• Integrity checks before importing, for example, a customer or species must exist in the in-house system.
• Compares records that exist in the in-house system for differences which might or might not be intentional. Mismatching fields are highlighted.
• The analyzed datasheet, complete with highlights, can be exported to Excel.
• "Mapping" tables to match identifiers that are different in SPAR, such as customer IDs and species.
• A "field map" ensures that future column renaming or additions in SPAR are easily accommodated.

Tools: SQL Server, Access 2013, Excel 2007+
Developed: 2015

• Creates extensive Excel workbooks with sheets for comparison by geographical location, weight, grade, customer overview, and individual customers.
• Can be called for any date range.
• Graphs on customer detail pages show overall sales and trends.

Tools: MS Access 2010
Developed: 2014

• Imported almost 2000 objects and fixed incompatibilities.
• Replaced obsolete menus with newer Office ribbon technology.
• Prepared for use with Access 2013 Runtime version.

Tools: MS Access 2010 / 2013 Runtime
Upgraded/maintained: 2014-2016

• After entering the details of a financial agreement, the system schedules payroll and one-time amounts.
• The payment schedule always starts with the last unconfirmed regular pay date.
• As soon as payment for a past pay period is confirmed, the column disappears and a new one column is added at the end of the schedule.
• Staff can adjust the schedule at any time.
• Payment schedule includes totals and can be filtered and sorted.

Tools: MS Access 2010
Developed: 2013-2014

• Online since 2004; redesigned as responsive website in 2013.
• Custom content management system for News & Events section.
• Full website in English with summary pages in Italian and German.

Visit online: www.zeballosexpeditions.com
Tools: HTML5, CSS3, jQuery, JavaScript, ASP.NET, VB.NET, SQL Server 2012, Skeleton (boilerplate)
Developed: 2004-2015

• Users can be members of one or more projects.
• Documents are listed with optional description, contributing team member, submission date, file size and file type information.
• As soon as a new document or message is submitted, an email notification is sent to all team members.
• Administrators can delete any document; users can only delete their own documents on the submission day.
• Can be installed in a hosted environment.
• Available in English and German.

Tools: ASP.NET, VB.NET, SQL Server 2005/2008, TSQL, HTML, JavaScript, CSS
Developed: 2009

• Database and programs on a virtual cloud server (in Hong Kong).
• Application is accessed from offices in Europe and Asia.
• Automated inquiry and order creation.
• Product and price list maintenance.
• Creation of all customer facing documents: quotes, order confirmation, changes, and invoices.
• Customers can submit inquiries and orders online.
• Customers can access all orders with the complete document history online.

Tools: Windows Server 2008, MS Access RT, Excel, SQL Server 2012, TSQL, ASP.NET, VB.NET, HTML, JavaScript, CSS
Developed: 2008-2015

• Easy access to comprehensive information for thousands of contacts.
• Extensive search and filter function.
• Various levels of user permissions.
• Export to Excel function.

Tools: ASP.NET, VB.NET, SQL Server 2005/2012, TSQL, HTML, JavaScript, CSS
Developed: 2008-2012

• Detailed information on all impounded and released vehicles including their location in the lot.
• Always up-to-date information on accumulated costs (towing, storage, surcharges).
• Slot allocation
• Extensive search and filter function.
• Tow card and report printing.
• Easy to use by anyone.
• Large font and large buttons for easy readability.

Tools: MS Access (RT)
Developed: 2004-2017

• Used by the City of Campbell River for all council and some committee meetings between 2001 and 2006. The adaptation for the Regional District Comox-Strathcona that manages all Board, Committee, and Hospital meetings went live in January 2005. In 2008, Regional District Comox-Strathcona was replaced by two successor regional districts, Comox Valley and Strathcona. Since then the edition for the Strathcona Regional District has undergone many adjustments and changes to accommodate the changing business requirements.
• Streamlines the entire process to save time, labor, and paper, and is a first step toward a paperless system.
• Replaced Word-based systems with a database where all the itemized information is stored.
• One button-click to convert an agenda to minutes.
• Extensive search and filter functions.
• Sophisticated permission settings and data filtering gives authorized users access to open, closed, and restricted meetings.
• Internal and external web pages create and display agendas and minutes from the database and provide further functionality.

Tools: Access, SQL Server, Classic ASP
Developed: 2001-2015

• Customized editions for the Land Use Services departments at the City of Campbell River and the City of White Rock.
• Organizes essential information of all applications, relations between applications, and related documents.
• User-defined Word and Excel templates integrate the information from the database, for example applicant and property data. This approach makes creating complex forms, such as fee summaries, very flexible and efficient.
• Extensive search and filter function.
• Link to property information stored in external applications or databases.

Tools: Access, SQL Server, Word, Excel
Developed: 2000-2012

• Every harvest is recorded and anticipated sales proceeds are calculated based on previous actual sales prices.
• Detailed harvest summary: species, grade, weights, prices, fees, production and processing/packaging costs, commission, etc. for any given time period or trip range. Optional graph for sales and market price trends.
• Claims and downgrade handling.
• Harvest lists and price comparison.
• Customer reporting module.

Tools: Access, SQL Server, Excel
Developed: 2005-2012

• Imports actual monthly costs, such as feed and labour, for each site and year class from Sage (Accpac).
• Imports inventory data, such as weights and transfers, from Fishtalk using Fishtalk Connect.
• Creates extensive Excel workbooks relating the imported data with complete information for each site and year class.

Tools: Access, SQL Server, Excel, Fishtalk, Sage (Accpac)
Developed: 2011-2012

• An Access-based content management system allows administrators to add, change, and remove policies and procedures and manage related attachments and external links.
• Documents are saved as PDFs in a managed folder structure. Related information is stored in SQL Server.
• An intranet site gives authorized users access to all stored documents for viewing and downloading.
• Documents can be retrieved using various search options or by browsing the hierarchical index.
• Automated review reminders ensure that all online documents are always up-to-date.

Tools: Access, SQL Server, TSQL, ASP.NET, CSS, HTML, VB.NET
Developed: 2008/2017