Client Projects

Examples of work we've done.

investmentSecurities.png

Securities Management

Implemented a web-based application for the custodial management of investment securities.

Qualicom undertook an extensive requirements gathering activity as a stand-alone project. Over four months, we interviewed operations and business users and other stakeholders and reviewed the existing system.

We produced a comprehensive set of use cases and functional and non-functional requirements.These were reviewed extensively and approved by the operations and business users. They were then used as input to the bidding process for development. As the successful bidder, Qualicom used the high-level requirements specification as input to the detailed requirements and system design specifications.

We then built the web application, which has now been in production successfully for several years.


eCommerce.png

eCommerce Website

Created an eCommerce website for the client, a small health and beauty retailer.

Qualicom developed a flexible content framework using the dotCMS web content management platform, as well as a presentation layer using HTML5, CSS3, jQuery, and Twitter Bootstrap. The client enters information about each product using a back-end form, including a description, a category, and an image, and changes are instantly reflected on the site.

Taxes and shipping costs are calculated based on the customer's location and the type of product, and the rates used for the calculations can be easily changed from a back-end form.

For checkout, we leveraged the widely used PayPal system, reducing the risk for the client, maintaining the development timeline, and making the site easier to update.


retailManagementSystem.png

Franchise Management System

Deployed our Retailarc Enterprise POS and retail management system across the organization

Qualicom worked with retail store to provide a powerful, intuitive touch screen POS interface at their retail locations. They required a flexible product display menu that presented the most popular items at each location on the main screen for fast transaction turn-around.

We were able to deliver most requirements out of the box, requiring only minor customizations to our Retailarc Enterprise system.


BASEL.png

Basel Database Enhancements

Helped the client improve the performance of the Basel data mart, containing over 3 terabytes of data, and develop enhancements to support it in the future.

Qualicom assigned a project team consisting of a business intelligence specialist, a data architect, and a data conversion specialist. The team: 

  • Analyzed the source systems to identify any data cleanliness issues.
  • Designed and developed ETL processes to source input data to the Basel data mart.
  • Designed an invalid data dependency report based on business rules.
  • Tuned various complex database queries to improve performance.
  • Designed and developed the database partition strategy.
  • Designed the common data model and database naming conventions.
  • Documented the common data dictionary in conjunction with the client.
  • Generated scripts to create the physical database.
  • Developed an automatic data archiving process.
  • Designed and developed tools to validate source and target data.
  • Designed and developed a web-based file upload process as part of the input options.
  • Enhanced the GUI for managing the data in the data mart.
  • Enhanced the Java logic to improve performance.

online-Banking.png

Online Business Banking Portal

Allowed client to deliver a unified online banking experience to customers of its Canadian and US banks.

The issue of duplicate login credentials was addressed relatively easily through single sign-on (SSO). We evaluated various solutions, settling on IBM Tivoli Federated Identity Manager (TFIM).

While this solution addressed the login issue, the user experience was still inconsistent. Qualicom designed a common platform to provide a consistent client experience, to aggregate heterogeneous services, and to implement a more flexible development methodology for the future.

We prepared a proof of concept based on IBM WebSphere Portal Server, an important feature of which was its ability to aggregate multiple applications into a single page by creating a dashboard with multiple information windows. Each window was implemented as a portlet, with each portlet being a deployable module. This was significant in that each application could be maintained separately while being combined into a single page for rendering. Using traditional web application technology, information would have been rendered as separate monolithic applications with limited flexibility.

The next challenge was to unify the legacy services. The client's Canadian portal had been using IBM's Tivoli Access Manager (TAM) to perform SSO for its Canadian services, so half the legacy services were already covered. For the US side, we leveraged the TIFM integration delivered early in the project. Because both legacy portals were using framesets to separate navigation and services, it was relatively simple to identify the frame URL for each service and integrate them into the new portal under separate menus. In the end, only a minor development effort was needed to seamlessly integrate all the legacy services.

Other aspects of the project included a dashboard for Central User Administration (CUA) and the Vignette content management system (CMS).


EDI.png

EDI Replacement Project

Migrated Electronic Data Interchange (EDI) system, which provides payment origination, collection, and information delivery services for the client's own clients and internal systems across various lines of business in Canada and the US, from a legacy platform to current technology.

Qualicom assigned a project team consisting of a project manager, an application architect, a data architect, and several business analysts, systems analysts, application developers, and QA specialists.

We analyzed the process flows of the legacy system and produced a high-level Requirements Specification containing functional and non-functional requirements. We also reviewed and developed a solid understanding of the new technology platform, as well as the client's overall enterprise architecture and infrastructure standards and direction.

We then proposed a suitable application architecture based on a service-oriented architecture (SOA) platform using webMethods Flow Service, business process management (BPM), portal, and Java technology.

When the requirements were completed and the application architecture established, we deployed the development and testing team to assist the client in migrating the existing EDI functionality from the legacy system to the new platform over a series of four releases.

In addition, we developed and delivered training to the client's operations and production support staff. This included an overview of the new architecture and functionality, setting up and maintaining the configuration through the new UI, and troubleshooting the system.


Future-Friendly-Repair.png

Future Friendly Repair Direct

Increased speed with which telecommunications could repair their customers' equipment.

The redesigned application led to an improved turn-around time for repairs of around 30%. This also resulted in a 30% improvement in customer satisfaction around the repair experience.


Message-switching-migration-project.png

Message-switching migration project

Migrated a series of payment, collection and information delivery services for clients and internal systems across various lines of business in Canada and the US from a legacy platform to modern technology.

Qualicom assigned a project team consisting of a project manager and several business analysts, systems analysts, application developers, and QA specialists. Among other activities, the team:

  • Reviewed and developed a solid understanding of the new technology platform, as well as the client's overall enterprise architecture and infrastructure standards and direction.
  • Reviewed the legacy processes, data flows, COBOL programs, and one-off processing in order to thoroughly understand the legacy system.
  • Produced a series of high-level requirements specifications containing functional and non-functional requirements.
  • Produced documentation describing the legacy processes that could be consumed by a wider audience.
  • Created a facility for the business users to view and maintain the legacy data so that it could be properly mapped to the new system.
  • Identified the external parties that needed to change connections and contacted them to secure the necessary resources to participate in end-to-end testing.
  • Translated the requirements into design specifications.
  • Developed test cases and provided a traceability matrix to ensure full coverage.
  • Assisted the client in migrating the existing functionality from the legacy system to the new platform over a series of releases.
  • Developed and delivered training to the client's operations and production support staff. This included an overview of the new architecture and functionality, setting up and maintaining the configuration through the new UI, and troubleshooting the system.

Client-Facing-Support-Portal.png

Client-Facing Support Portal

Performed usability testing and card sorting to improve the client's online help web site.

Qualicom worked with Koodo to perform usability testing on the existing wireframes in order to identify their strengths and weaknesses. As we discovered weaknesses we revised the designs, using an iterative approach to quickly make important improvements. Simultaneously, we performed card sorting to determine the most natural information architecture for the site, in order to make sure that the information on the site could be found.

On completion of the analysis phase, we produced a revised wireframe diagram incorporating the best practices and learnings that had been identified.


Property-Management-System.png

Property Management System

Replaced a legacy condominium sales tracking system based on MS Access with a series of integrated web applications and an Oracle back end.

The new system comprised:

  • Admin Web—Enables internal Baker users to manage all aspects of the system, including properties, sales, registrants, and system users.
  • Sales Web—Enables internal Baker real estate agents to view properties, run reports, register potential buyers, track contacts made with those
  • potential buyers, manage sales, and perform customer relationship management.
  • Builder Web—Enables builders to view registration and sales reports.
  • A new public website to present general information about Baker and Baker-brokered projects to the public.
  • These sites were built on a common Oracle database. They all had a browser-based front-end and a Java back-end.

An especially important component of the new system was its reporting capability. As well as a series of preformatted reports, we provided the client with the ability to produce flexible, ad-hoc reports.

In addition, Qualicom developed an API for the Baker Realty Partner micro-sites that Baker produces on behalf of developers in order to insert registration information from these sites into the database.


Retail-Management-System.png

Retail Management System (Startup)

Set up a retail management system to support wireless carrier aggressive retail growth.

Qualicom worked with Helio to quickly deploy Retailarc Enterprise to meet the complex challenges associated with wireless carrier's aggressive timeline. As an experienced systems integrator, we were also able to integrate our Retailarc Enterprise Server seamlessly with SAP and wireless carrier's other back-end systems.


Retail-Management-System-(Major-Upgrade).png

Retail Management System (Major Upgrade)

Created a custom retail management solution to serve as a stable base for Mobility's planned rapid expansion.

Qualicom's design integrated Web and Java technologies to deliver state-of-the-art functionality to the stores.

The POS application was based on a single-transaction workflow combining sales and returns. Input came from scanning product codes, serial numbers or receipts; transactions could be suspended, resumed, voided or paid by a mix of different tender types.

Part of the project involved re-engineering and automating all store processes to ensure ease of use and deliver productivity through a single access point for store staff. It also involved centralizing inventory, product and promotion management, incorporating other business applications in the corporate store environment, and including a POS framework capable of plugging in Web applications to integrate various payment options.

We also enabled offline transactions so that customers could be serviced without having to connect to the central server. And unlike many RMS's, which required extensive modifications to support new requirements, Qualicom's solution enabled other applications to interface with the RMS.