For more information or enquries, please contact us: Phone: (604) 642 6139   | Fax: (604) 677 7753 Email: info@decisionstreams.com
|Business Intelligence Analytics Projects
Following is the partial list of the Business Intelligence and Analytics Projects developed by Decision Streams for various public and private sectors

Bus Service Scheduling Analytics
Analyze bus service schedule data for lost time, revenue time, recovery time, re-scheduling, on-boarding, service hours by analyzing the demanding bus schedule for CMBC in greater Vancouver. The bus scheduling is $250 million dollars operations and the project has a expected minimum save rate of 1% per annum, which dollar terms is approx 2.5 Million dollars per year.

Incident Management Analytics
Analyze incidents,accidents and assault data for CMBC fleets of bus and trains to help transit security understand the patterns and route cause of those incidents to plan preventive steps for public safety. The information is also shared to other securities agencies in lower main land including RCMP.

Asset Forecasting
Developed Assets forecasting model to help CMBC in their fleet management and planning, including vendor analysis, asset analysis , part analysis, engine overhaul schedules, break down patterns, vehicle model performance, reliability , vehicle maintenance schedules, labour cost and maintenance cost. This project gave TransLink insight into their Fleet Operation, to better forecast, plan and manage their $200 Million dollar annual budget by increasing efficiencies and cutting down the cost.

Traffic Data Analytics
Analyze real-time social mobile networking data and creating real-time customer patterns based upon their social tagging, preferences, relationship, behaviors and choices etc, to help create a dynamic product advertisement. The project use advance analytics data mining artificial Decision Tree, Clustering, Linear regression, Time series algorithms to create a real time predictive models.

Financial Data Analytics
Analyze various financial product portfolios for wide range of financial clients in bond, securities, commodities market in North America and identifying patterns for targeting and retaining most valuable customers.

AMC Concession and Ticket Data Analytics
Analyzing Movie ticket and connection data, consumer buying patterns, profitabletheaters, concessions and users preference. Data was sourced from AMC point of sales terminal in canonical forms. The key subject areas were – Theatre, Tickets/Products sales, Loyalty Management, Rentrack, Feature etc. The information is used by the AMC marketing team to generate customer loyalty programs, Operation department to arrange concessions and finance/HR for revenue cashflow forecasting.

Security Data Analytics
Analyze real time security data collected from internal gateways, IDS, firewalls, databases, web servers and server logs for external threats, venerability, breach and fraud detection. Each detection scheme or pattern is save to diagnosis a repeat of same behavior or security breach. A compliance report engine process all threats, venerability, breach and fraud report to take preventive actions.

Resource (Oil, gas, pipeline) application analytics
Analyze Oil, gas, pipeline application data to ensure application processing, compliance, and public safety. The information is used to analyze processing delays, non-compliance, incidents, royalties and public safety.

Table Player Rating Analytics
Analyzing table player data i.e player play patterns, average win/loss, bets. Players preferences, favorite table game, time of the day
| .NET Software Projects
Following is the partial list of the Product developed and Project undertaking, by Decision Streams, specifically using Microsoft .Net Technologies and SQL Server Database.


DS Extreme CRM v1.1
In a dynamic and ever-changing market place, the need for managing customer relationships is no longer a choice - it’s an absolute necessity. Critical information on existing customers is stored, analyzed and later used to effectively manage relationships with customers. The Extreme CRM, developed by us will help the Clients - Promote a customer-oriented philosophy, adopt customer-based measures, develop end-to-end processes to serve customers, provide successful customer support, handle customer complaints and track all aspects of sales
Technologies – -NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, JavaScript, Windows Mobile CE

WDS Extreme Seat Management v1.2
Our Extreme Seat- Managmente Product is a reserve seating management software for theaters, sport arenas and auditoriums that needs advance seat planning and reservations. The Extreme Seat-U is a web based powerful admin and management tool that allows seating designs, image processing, functional layouts, labeling, pricing and special preferences with GUI based sketch pad.
Technologies – - NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, JavaScript, Windows Mobile CE.

Web enabled B2B CRM, CSM and Information management system for Quadro's engineering products for Pharmaceutical, Food, Cosmetic/Personal Care, Fine Chemical and Biotechnology Industries.
Technologies – NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, JavaScript, Windows Mobile CE

Seat U
Blacktie is a US company headquartered in Denver, Colorado, that provides event management services and solutions. BlacktieSeat U Online Ticketing Solution had been awarded to another company for development, which had failed to deliver the solution. Our team was entrusted the task of analyzing and delivering the solution where the other vendor had failed. The successful delivery of the project saw the growth in BlacktieSeat U ticket sales by 50%.
Technologies - .NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, Javascript

CSTK is part of Velociti, Inc. Group, Kansas USA specializing in wireless local area networking and transportation technology systems. CSTK had a CRM requirement that was not addressed by the CRMs available in the market. Our team gathered the CSTK requirements, analyzed it, designed and developed the system and successfully implemented the CRM to address CSTK's complex and custom requirements.
Technologies – - NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, JavaScript, Windows Mobile CE Project Management Portal Project Management Portal developed to streamline and optimize project management processors and to provide their customers www.decisionstreams.com better visibility and an enhanced service. Our team of engineers designed developed and implemented the ESS requirement and thereby optimizing the process 80% and improving ESS client project visibility 100%.
Technologies - .NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, Javascript

My Cardiologist
The My Cardiologist Chat Application was designed developed and delivered to Rainbow Cardiovascular LLC which provides cardiologists around the world, to communicate with each other in a secure and easy manner, using their mobile phone or any web enabled computer or device. Our team of highly skilled architects scoped designed, developed and implemented the solution for Rainbow Cardiovascular. The solution comprised of the scalable chat server and administration consol, web 2.0 site with web chat capabilities and mobile device clients for Windows Mobile, Palm, BlackBerry, iPhone, Android and Nokia Symbian devices
Technologies - .NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, Javascript.

Efficient Ticketing System
On the back of the success of Seat U Blacktie Denver, Colorado entrusted the task of building their next generation online ticketing solution to our engineers. The new system was build from ground up with advanced functionality with customizable and configurable venue layout, show and events, ticket packages, payment options, multi payment gateway options, delivery options, and many more features to give Blacktie a competitive edge.
Technologies - .NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, Javascript

Meridian Products
Meridian Products, L.L.C. is a reputable, independent, Women-Owned business serving the appliance, bathroom fixture, and furniture and restaurant display industry. To aid in the sales, planning and engineering staff management Meridian required a BI and Data Mining solution implemented to reduce custom manual reporting requirements due to the lack of proper information visibility. Our BI-Data Warehousing team delivered the requirement to Meridian Products, L.L.C thereby reducing manual reporting by 90% and improving visibility by 100%.
Technologies - .NET Framework 2.0, ASP.NET, C#, SQL Server 2005, AJAX, Javascript.

With our global reach and offshore presence, our consultants work 24 hours per day, 7 days per week: we never sleep.
Copyright (c) 2005. Decision Streams. All rights reserved.