These are just some of the projects TCS staff has worked on in North America. Projects listed from most recent to oldest, note we do hourly rates as well as fixed term projects. Budgets are all listed in CAD. Size of team refers to number of people who worked on the project.

IceCorp - 2017

Billing Automation, WMS Development & Integration

Budget: ~$66,105 Duration of Project: 6 Months Size of Team: 3

*Implementing new warehouse management system (RAMP) and developing integration services packages for EDI exchanges.

Integrating UPS & Purolator web services into RAMP proprietary warehouse management system (WMS)

Automated billing process from within the WMS.

Technologies Used: SQL Server 2012, C# 4.5, RAMP WMS, Interchange Integration, Jasper Reports

Rogers - 2016

Business Intelligence Solutions

Budget: ~$138,000 Duration of Project: 9 Months Size of Team: 3

*Provided all the development and some of the design for the business managed side of one of Rogers' largest projects of 2016, the Family Data Manager (FDM).

*Provided architecture, development, training & documentation for BI, reporting and integration services projects.

Technologies Used: Oracle 12c (Exadata), Teradata, Microsoft Data Tools (SSIS), Visual Studio 2013, C# 4.0, SQL Server 2012.

Girl Scouts - 2016

MVC Web Application Managing Sales and Incentives

Budget: ~$167,800 Duration of Project: 6 Months Size of Team: 5

*Designed MVC 4.0 web application for Girl Scouts (www.abcsnap.com).

*This was a rewards, incentives and sales tracking and management platform.

Technologies Used: C# 4.0, MVC 4.0, Team Foundation Server, SQL Server 2012, Javascript, HTML, Jira

Procura - 2015

Web Based Mobile Scheduling Software

Budget: ~$58,800 Duration of Project: 3.5 Months Size of Team: 3

*Designed and developed a web basd mobile scheduling application for in home care givers (nurses).   

*This application was developed on BlackBerry 10.  It included client and appointment modules. 

Technologies Used: QML, C++, SQLite, Momentics, Git

Longos - 2015

Website and response E-Flyers

Budget: ~$11,000 Duration of Project: 1.5 Months Size of Team: 3

*Implementation of responsive UI, successfully responsive on 20 mobile and none mobile platforms.  Implemented custom website control.   

*CMS (Worldpress) maintenance.

Technologies Used: Visual Studio 2010,C#, .NET 4.0, ASP.NET 4.0, HTML 5, Javascript, Bootstrap, CSS3

Telus - 2014

Web Based Shipping Application & RMA

Budget: ~$180,000 Duration of Project: 3 Months Size of Team: 3

*Designed and implemented a web based shipping application which processed Telus' return to merchant authorization transactions for some of their hardware.  This application currently manages their RMA warehouse, and interacts with Purolator's web service. 

*This software also includes a custom enterprice content management system.  

Technologies Used: Visual Studio 2010, Oracle 11g, C#, .NET 4.0.

Mother Parker's - 2014

Reporting & ERP

Budget: ~$56,000 Duration of Project: 2 Months Size of Team: 6

*Delivered a thorough audit of company wide enterprise resource planning (ERP) reports for inventory, purchasing and customer relations.

*Designed and developed a microsoft Dyamix AX filtered search.

Technologies Used: Dynamix AX 2012 R2, Visual Studio 2010, SQL Server 2008 R2, C#, Sharepoint, .NET 4.0, ASP.NET

Whirlpool - 2013

MVC Web Application, Reporting & Website

Budget: ~$99,000 Duration of Project: 5 Months Size of Team: 5

*Designed and developed the Whirlpool Hub, a sales incentive portal managing sales incentive programs for Whirlpool appliances.

*Implemented the front end, including a data driven menu system.  Implemented back end for reporting.

*Sales Reports development

Technologies Used: Visual Studio 2010, SQL Server 2008 R2, C#, .NET 4.0, Telerik, SVN, ASP.NET

Mitten Vinyl - 2012

Reporting & Data Migration

Budget: ~$27,000 Duration of Project: 3 Months Size of Team: 2

*Cubed company wide sales data. 

*Implemented Margin Analysis report.

*Migrated sales data from relational database to multidimensional database (OLAP).

Technologies Used: SSIS, SSAS, SSRS, C#, SQL Server 2008 R2, .NET 3.5, Visual Studio 2010, ASP.NET

Millennium Research Group - 2011

Web Based Survey Management Solution

Budget: ~$200,000 Duration of Project: 4 Months Size of Team: 3

*Implemented a web based survey management solution for the medical industry.

*Implemented a web based average price calculator.

Technologies Used: C# 3.5, .NET 3.5, Visual Studio 2010, SVN, SQL Server 2008 R2, Javascript, ASP.NET

TailTowns - 2010-2011

Video Game (MMORPG)

Budget: ~$143000 Duration of Project: 6 Months Size of Team: 7

*Implemented artificial intelligence, navigation system and user interface for 3D massively multiplayer online role playing game.

Technologies Used: Unity, Mono C#

Mother Parker's - 2009-2010

Reporting

Budget: ~$87,000 Duration of Project: 8 Months Size of Team: 2

*Developed District Profile Reporting Tool, a drill downable, multi-threaded reporting dashboard, which directed compay hiring policy throughout canada. 

Technologies Used: SQL Server 2005, C# 3.0, .NET 3.0, Visual Studio 2010, Excel Interoperability Library

LG canada - 2008-2009

Data Cubing & Cleansing

Budget: ~$8000 Duration of Project: 6 Months Size of Team: 1

*Cubed, Sanitized, Cleansed and Migrated nationwide POS & retail data.

*Designed and developed an artificially intelligent data cleansing & alignment application.

Technologies Used: SSIS, SSAS, Data Analyzer, C# 2.0, .NET 2.0, Visual Studio 2008, SQL Server 2005, SQL Server 2000

Belkin - 2008-2009

Data Cubing & Cleansing

Budget: ~$8000 Duration of Project: 6 Months Size of Team: 1

*Cubed, Sanitized, Cleansed and Migrated nationwide POS & retail data.

*Designed and developed an artificially intelligent data cleansing & alignment application.

Technologies Used: SSIS, SSAS, Data Analyzer, C# 2.0, .NET 2.0, Visual Studio 2008, SQL Server 2005, SQL Server 2000

Targus - 2008-2009

Data Cubing & Cleansing

Budget: ~$8000 Duration of Project: 6 Months Size of Team: 1

*Cubed, Sanitized, Cleansed and Migrated nationwide POS & retail data.

*Designed and developed an artificially intelligent data cleansing & alignment application.

Technologies Used: SSIS, SSAS, Data Analyzer, C# 2.0, .NET 2.0, Visual Studio 2008, SQL Server 2005, SQL Server 2000

Cogeco Cable, GIS Work - 2006-2008

Geographic Information Systems

Budget: ~$100,000 Duration of Projects: 2 years Size of Team: 3

*Implemented navigation, spatial indexing and graphical representation for geographic information based asset management software for physical assets such as fiber optic and coax cables.

*Implemented custom querying system. 

*Debugging web version of GIS based asset management application.

Technologies Used: C# 2.0, .NET 2.0, Team Foundation Server, Visual Studio 2005, SQL Server 2005, ASP.NET, ESRI GIS SDK, Autodesk Map 3D, Direct 3D

Farmers Telco - 2007

Geographic Information System

Budget: ~$5000 Duration of Project: 2 Months Size of Team: 2

*Implemented a coordinate linking utility for telecommunications infrastructure.

Technologies Used: C# 2.0, .NET 2.0, Visual Studio 2005

DHL canada 2005-2006

Analysis Software, Data mining & Data Correction

Budget: ~$16800 Duration of Project: ~2 Months Size of Team: 2

*Designed and implemented AAP 1.0 (Accuracy, Attendance & Productivity 1.0), analyst software used for DHL canada's billing head quarters.

*Developed a data mine used to identify erroneous way bill numbers.

Technologies Used: Visual Basic for Applications, Access, AS400, Unix Solaris Shell Scripting



The Consulting Store 2017