Monday, August 21, 2017

DrDesign Inc.

professional IT support

Portfolio of Select Projects

Organization: Canadian Institutes of Health Research (CIHR)
Project: Custom-developed Online Course

Overview

Canada's three federal research agencies, CIHR, NSERC and SSHRC, jointly created the Interagency Advisory Panel on Research Ethics (PRE or the Panel) as part of a collaborative effort to promote the ethical conduct of research involving human participants. To achieve its mission, PRE commissioned DrDesign to develop an online tutorial consisting of eight modules, in both English and French. The tutorial, called CORE, would be made available to multiple institutions across Canada and would be a requirement for any researcher receiving federal funding. Several universities across Canada also have CORE as a requirement for graduation. The application needed to be bilingual and have tools for PRE staff to create new course content.

The site has over 300,000 users, with more joining daily.

Solution

DrDesign incorporated the latest in application design methodologies and dynamic translation to allow for a bilingual website.

  • Allow PRE staff to create their own tutorial content including video and podcasts. This made them self-sufficient in creating content and managing the website.
  • QCubed, a framework for providing Object Relational Mapping (ORM) functionality and stateful object-oriented HTML forms.
  • Zend Framework, a collection of high quality components for building scalable web applications.
  • Zend Translate module using translation files to allow for seamless translation from English to French and vice-versa.
  • Content Management tools to allow editing of content and the creation of new modules.
  • CSS-based layout and visual elements.

DrDesign's Role

DrDesign developed an easy to use Administrative interface for PRE administrators to manage course content, web site content, users, and institutions.

Based on client requirements, DrDesign managed the whole development and deployment process including creating the functionality document, wireframing the application, data modeling, and coding.

Organization: Innovation Park at Queen's University
Project: Drupal CMS-based website

Overview

Innovation Park wanted to launch their web presence with an exciting site that showcased the full breadth of services and facilities they offered. In addition, they wanted to highlight the researchers and companies that were either affiliated with Innovation Park or used their state-of-the-art facilities.

Solution

DrDesign delivered a solution that utilized the Drupal Content Management Framework as well as the latest XHTML and CSS standards

  • CSS-based layout and visual elements.
  • Search engine optimized pages and URLs
  • Drupal module and theme customization

DrDesign's Role

DrDesign created a CSS-based layout thereby making the look-and-feel highly configurable and easily maintainable.

On the development side DrDesign deployed a customized Drupal installation:

  • Custom content types such as News Artices, Events, Researchers, Companies, and Success Stories.
  • A customized version of the TinyMCE WYSIWIG editor for creating and editing content.
  • Photo Gallery module

Based on client requirements, DrDesign managed the whole development and deployment process including creating the functionality document, wireframing the application, data modeling, and coding.

Organization: Public Health Agency of Canada
Project: CLF 2.0 Conversion

Overview

Public Health Agency of Canada marks the birth of a new approach toward public health systems for provinces and territories. DrDesign engages in the management, design and development of the new Common Look and Feel CLF 2.0 design templates and conversion to the new standards set by the Treasury Board of Canada Secretariat including the implementation of the media player. Given the tight deadline for the conversion of all web pages to CLF 2.0 and the over 20,000 pages to convert, a manual solution was not feasible. Software to do mass conversion of web pages needed to be developed.

Solution

DrDesign developed a sophisticated page conversion software engine that converted the myriad of designs and incongruently coded pages into CLF 2.0 compliant and W3C-validated pages. In addition, a trouble ticket system was developed during the QA process to solicit feedback for fine tuning the conversion software.

Based on client requirements, DrDesign managed the whole development and deployment process including creating the functionality document, wireframing the application, data modeling, and coding.

Organization: Gallagher Animal Management Systems
Project: Internal Order placement and fulfillment system

Overview

Australia has an advanced livestock tracking system known as the National Livestock Tracking System (NLIS). NLIS tracks the location and ownership of all cattle and sheep from birth. This requires all animals under the purview of the system to be outfitted with a variety of RFID tags that enable precise tracking. Gallagher is a government-authorized manufacturer and distributor of these tags with a network of over 2000 resellers across Australia. The company wanted to deploy an advanced web-based order placement and fulfillment system to replace their entirely paper based system. The new system would provide access to Resellers, Verifiers, Territory Managers, and Gallagher Administrators.

Solution

The end result incorporated the latest in application design methodologies to deliver a highly effective site:

  • Qcubed, www.qcu.be, framework for providing Object Relational Mapping (ORM) functionality and stateful object-oriented HTML forms.
  • Zend Framework, a collection of high quality components for building scalable web applications.
  • CSS-based layout and visual elements.

DrDesign's Role

On the application development side DrDesign developed a robust web application:

  • AJAX driven order forms and shopping cart.
  • Complete set of management tools that allow Gallagher to fully manage their products, prices, and users with an easy-to-use interface.
  • Separation of presentation, business, and application logic was achieved through a hybrid of the Zend and Qcubed frameworks.

Based on client requirements, DrDesign managed the whole development and deployment process including creating the functionality document, wireframing the application, data modeling, and coding.

Organization: Canadian Air Transport Security Authority (CATSA)
Project: Mobile Website

Overview

CATSA is a Canadian Crown Corporation responsible for security screening of people and baggage and the administration of identity cards at the 89 designated airports in Canada. They were looking for a mobile friendly website to disseminate information about air transportation to the general public.

Solution

In order to make content management straighforward for CATSA staff, the end result utlized XML based files to feed information to the website. The XML files were edited through a custom-built CMS:

  • Qcubed, www.qcu.be, framework for providing Object Relational Mapping (ORM) functionality and stateful object-oriented HTML forms.
  • Zend Framework, a collection of high quality components for building scalable web applications.
  • CSS-based layout and visual elements.

DrDesign's Role

Based on client requirements, DrDesign managed the whole development and deployment process including creating the functionality document, wireframing the application, data modeling, and coding.

Organization: Queen's University, Office of Advancement, Kingston, Ontario
Project: Integrity Centre

Overview

The Office of Advancement is a 130-strong unit within Queen's University, responsible for fund-raising, external relations, and marketing. The Office of Advancement has a 10 gigabyte Oracle database with almost 300,000 entities. It needed a web-based application to manage data integrity errors in the database. Examples of errors include incorrectly formatted addresses, gift pledges that have expired but are still classed as active, etc.

Solution

The Integrity Centre aimed to provide a single point of reference for all data integrity errors in the Advancement database. To this end, the final solution combined a hybrid of frameworks and technologies:

  • PHP with a MySQL backend
  • Flash UI
  • PL/SQL stored procedures
  • Shell scripts
  • Fusebox framework
  • Model-View-Controller (MVC) architecture

DrDesign's Role

Underpinning the Integrity Centre was an application built with the Fusebox framework and using a MVC architecture. This enabled DrDesign to delegate a portion of the work to other developers. Some key elements of the solution were:

  • Oracle PL/SQL stored procedures that run nightly, weekly, or monthly on the main Advancement server. Each procedure created an "Integrity Table."
  • A PHP web-based administrator module that allowed designated individuals to add and remove users, manage Integrity Tables, as well as control access to individual Integrity Tables.
  • Shell scripts that managed under a CRON.
  • Flash and HTML forms.
  • AJAX functionality built in.
  • All scripts were documented with the robust Fusedoc standard.

By employing the latest in application development methodologies and user interface design, the final result exceeded expectations in terms of functionality and usability. Key to the project’s successful completion was DrDesign's ability to liaise effectively with staff across the Office of Advancement, listen to feedback, and provide excellent customer service.

Organization: Portman Studios
Project: Database driven product website and internal tools

Overview

Portman Studios, a leading distributor of gift ware and apparel, needed a website to showcaes products to its customer and develop internal tools to generate catalogs, custom photo quotes, and labels on the fly.

Solution

DrDesign utilized the Zend Framework to develop a highly effect solution:

  • Qcubed, www.qcu.be, framework for providing Object Relational Mapping (ORM) functionality and stateful object-oriented HTML forms.
  • Zend Framework, a collection of high quality components for building scalable web applications.
  • Zend Framework PDF module to generate photo quotes and catalogs on the fly.
  • Generate barcode labels on the fly across all product lines.
  • Easy to use online interface to manage products and content.

Project: Amazon & Ebay Integrations and E-Commerce websites.

Overview

DrDesign has developed custom e-commerce websites for many private companies. We have integrated their websites with their ERP systems to eliminate data duplication.

We have also done extensive Amazon & Ebay store integrations for a variety of vendors to automate their product uploads, syncing inventory, and managing store orders.