.................................................................................................................................................

A Major Wine and Spirits Producer

Client Profile
Our client is one of the largest producer and marketer of wine and related products in Canada. The Company's products are produced at a family of estate wineries located in the provinces of British Columbia, Ontario, Quebec and New Brunswick. These wineries are supported by a national distribution network and dedicated sales and marketing team.

Challenge
Combining third-party, industry data to effectively cross- and up-sell. The Wine and Spirits industry has a rich dataset available for business intelligence. In addition to traditional internal systems such as ERP and retail Point of Sales (POS), the liquor boards across the country sell sales data back to producers/distributors. This data provides distributors with information about sales to every single licensed dealer – restaurants, bars, and stores – for every single SKU at a weekly level. This represents millions of rows of data per week.

Solution Summary
DSI implemented an integrated Finance and Inventory data warehouse solution in SQL Server 2005 (Enterprise Edition) on a Windows Server 2003 platform. The environment was deployed on eight servers using Hewlett-Packard blades and an HP Storage Area Network

back to top

.................................................................................................................................................

Major Regional Hospital

Client Profile
A 299-bed acute care community hospital based outside of the GTA. This regional hospital is the only facility in the area that provides specialized services to patients across a large geographical area. The hospital’s dynamic and progressive medical team of over 280 skilled physicians, almost 2,300 caring staff members and 1,100 dedicated volunteers provideS outstanding health care specializing in Cancer Care, Surgical Services, Critical Care, Mental Health Rehabilitation Services, as well as Women and Children's programs.

Challenge
Our client required greater visibility into their financials so they could consistently and easily understand and manage operating costs. Due to the rapidly increasing volume in patient caseloads, management also identified the pressing need to monitor, manage and analyze key performance indicators of the business such as wait times and service levels.

Solution Summary
DSI delivered:

A solid, secure, extensible infrastructure built using our own Data Warehousing methodology
A central source for reporting and analysis information delivered through a proven web based portal
A General Ledger repository (a data cube) which allows for simple to complex analysis and reporting
A General Ledger Reporting solution with drill down and drill-through access to additional detailed data not captured in the data cube
An automated nightly processing cycle pulling and updating data for both the reporting solution and cube
A role-based security model leveraging access rights and credentials seamlessly with the hospital’s central medical information system
A web based application that provides the hospital the ability to maintain metadata and business definitions in a secure and reliable way

.................................................................................................................................................

North American Logistics Company

Client Profile
Our customer is one of North America’s leading customs brokerage, consulting, freight and integrated logistics service provider.

Challenge
The existing production development and launch process required users to spend a great deal of time manually routing, approving, tracking, filing, and archiving product development–related documents. In addition, finding a document involved asking another employee who knew where to look, even if that meant going to another floor, building or office location. Finding the most basic documents was a challenge, resulting in wasted time and lost productivity.

Solution Summary
DSI implemented Microsoft® SharePoint Server 2007 system which includes collaboration, workflows and enterprise content management technology with search capabilities to automate manual processes and reduce time-to-market. The solution was built on Windows Server 2008 using Hyper V, SQL Server 2008, Internet Information Server 7.0 and SharePoint Designer. Microsoft Project 2007 was used for resources and time management. Latest virtualization methodologies were utilized for future expansion and custom document workflow were deployed to fulfill the needs for change management.