Software Development Projects

Recent Projects:

British Columbia Lottery Corporation:  The BCLC contracted Campbell Software to integrate their “Encore” Loyalty Rewards program to 40 different Casinos in British Columbia.  To accomplish this, each proprietary Point of Sale system needed to support BCLC Food and Beverage categories, member card point balance look-ups, member card prize claims, member card earnings and member card point redemption with PIN verification.

Posera POS:  Assisted Posera to update and change various client side back office reports.  Campbell Software also provided custom middle-ware to integrate the POS with Greek Fiscal printers (this was a country compliant sales tax reporting requirement).

Animal Dental Care: We recently delivered Phase II development efforts (after completing Phase I) related to an animal dental surgery application, including an anesthetic monitoring module.

Interface Media Group:  We altered an existing version of a video kiosk application for COMCAST, providing the ability to add, change, update, tag, search and sync media across disparate kiosks.  We also provided usage metrics tracking.


Custom Software Development

Below is are sample of the projects we have been involved with.  Project budget sizes vary, from $2500 to $2 million.  Volumes of users vary, from a few hundred users a month to millions of users per hour.  Software project complexity varies from “I need a report changed to consolidate totals” to “We need our SCADA based State Hydro utility system to identify electrical theft, compare projected consumption to actual use and provide trigger based variance warnings”.


Accounting

Scratch build of a full custom designed accounting system:  General Ledger, Accounts Receivable, Accounts Payable and Canadian Payroll modules, with usual reports such as Income statement, Balance Sheet, Trial Balance, Audit Detail, Aged Receivables and Payments, plus Employee T4’s and Corporate T1.

Electronic Polling / Billing system for legal firm:  Serial based communication to capture data from a station message detail recorder (inbound and outbound telephone and fax call SMDR), photo copier and postage system, with network based hard copy print logging, transposing the data to a proprietary accounting format, converting to EBCDIC via a 5251 emulator, and integration to an IBM System 36 accounting system, eliminating all manual data entry which previously required 3 full time staff.  The system also enforced client account coding of all inbound and outbound calls & hard copies, resulting in a monthly gain of $30k in additional billing per month for the firm.  References available.

Analytics

We developed a popular Web Analytics tool to capture and study website behavior.  Capturing client side mouse movements, UI clicks and key presses (that Google analytics does not) to help the client to make better UI decisions for their E/C website.

Mobility app metrics capture and logging, similar in concept to above, but for mobility (iOS Android), consumed by a 3rd party analytics tool via an API reporting module, providing a deep analysis of user metrics to measure interactivity, features used, features NOT used, etc.

Banking

Campbell Software has developed custom banking software for a major banking client to improve their Treasury Management system. Ninety (90) people worked on the project for 14 months. We were just one part of the software development team (18 developers). This project required a tremendous amount of complex domain knowledge and banking software (stack) related skill sets. We cannot disclose the details due to an NDA other than stating the technology effort was primarily a migration from COBOL to a .NET / Microsoft stack. As well, we also provided a robust set of new features.

Big Data

We developed a “generic” big data solution providing in-depth automated analysis of disparate yet related data, with advanced blending algorithms and rules to identify trends, medians and probabilities.  We implemented MSSQL with SQLCLR modules for security and privacy reasons, RSS feed subscriptions and data scraping utilizing a legal approval permission process.  This was a mid-size project (6 figures).

Child Care Services

We created a Child care services system for tracking meals, attendance, nutrition and billing, with automated government reporting for 300 Texas counties.  The project was HIPAA compliant, with electronic digital signature signing (custom approach) for monthly government filings.  This was a mid-size project (6 figures).  Project is now in maintenance mode.  Campbell Software’s VP of Networks and Systems hosts the sites and portals.  References available.

Web Conferencing

Gary Campbell – Start-up founder, director.

Nominated by the BCTIA as best start-up in 2006 by 900 BC technology companies.  Earned media in PC Magazine, profiled in a publication by the Honorable Colin Hansen (June 15, 2006) “British Columbia Technology Sector Profile” as a success story, appeared in Frost and Sullivan, IDC Research and Wainhouse Research publications.

Over 500,000 meetings hosted with 4 million participants.

Used by Verizon internally, rolled out to tens of thousands of internal Verizon desktops, used by Health Canada, Engineers without Borders, Purple Hearts, colleges, universities, Canadian military for group based tank simulations, real time auctions to sell heavy equipment (live auction bidding component).

Servers were .NET C# based, client was OCX based, first on the scene with Win 7 1 click web install, with openSSL (since at that time, Windows did not provide SSL layer services), VoIP audio mixing, webcam, PPT presentations, screen-casting, recordings, voting, web tours and a multitude of other features ahead of its time were provided.

LMS Education Software

Scratch build of an Education Software Learning Management System (LMS) supporting many roles (System Admin, EDU admin, Academic Officers, Course Instructors, Students, Graduates, Marketing Manager, Marketing Staff, Technical Support, Admissions Manager, Admissions Staff, Student Services Manager, Student Services staff, Authoring Role, HR Manager, HR Staff, Finance Manager, Finance Staff and custom roles.  The project included a Silverlight transcription component with advanced audio transcription features such as play speed and content formatting rules.  Also complex quizzes, lesson tests, chapter tests, with weighted grading, supporting many unique types of questions (usual types plus crosswords, find a word, non-exact match, etc).  Solution eliminated $2000 of royalties per student, enabling the college to offer a better course for less.  This was a mid-size project (6 figures).  Whitepaper available.

Subcontracted to work on Amazon’s AWS gold certification programming verification course for developers.  The project included course content, documentation and course programming examples in both Java and C#.  We cannot provide further details due to NDA.

ERP

We developed a role based secure work force management ERP solution, where data was collected from many different types of sources (proprietary and standard data formats) from contact centers across the globe.  Developed flexible / configuration control panel applets (dashboard) providing snapshots.  In-depth reporting and charting (SSRS) provided analysis on service levels, quality of service and other key performance indicators (KPI’s).

State Wide Energy Utility Grid Project – collection, reporting and analysis of SCADA data of feeders, generating alerts at run time for theft, bypasses, outages, load and other parameters, performance of field teams, scheduling of feeders, shutdown in case of shortage of electricity and demand forecasting.  This was a very large project (8 figures).

Hospitality Franchise

Data processing for 300 Wendy’s franchises, head office franchise reporting, EDI ordering, perpetual inventory, labor scheduling, head office reporting, daily electronic data uploads and other processes.

Also for a Wendy’s Franchise, performed an in-depth cost analysis (onsite weighing and measuring ingredients) with recipe confirmation of their entire line of food and beverage products resulting in nation price change corrections across the chain.

Hospitality Back Office

Onsite POS installations – NCR, Aloha, RMS and others.  Campbell Software’s VP of POS has over 1000 POS installs while Gary has been involved with about 20.  There was a time when we pulled wire, setup and configured networks, now with wireless, installation is much so much easier.

Custom built hospitality back office system:

Integration to 40 different POS systems and cash register brands, Multi-revenue departments and inventory stock centers (30), Batch processing (for commissaries with tracking/distribution to franchise locations), Perpetual Inventory, Just in time reordering with EDI electronic ordering to major vendors, Receiving with various handhelds, Food and beverage recipe costing with yields, trim, waste factoring, Unlimited conversion definitions (Case 24 100oz, 16-20 count per pound, etc.), Theoretical sales mix costing and reporting, Server cash-outs, blind cash-outs, cashier cash-outs, Projected labor cost scheduling, Magnetic card sign-ins with early / late approvals and custom rounding rules, Daily and to-date labor costing, End of day financials, Distributed in 7 countries, in 4 languages (English, French, Spanish and German).  Whew! That was a mouthful.  Integrated with 40 hospitality back office brands of POS systems.

Insurance

We augmented a National (USA) insurance system project providing public employees (teachers), supporting all major insurance carriers, regulatory rules, renewals and coverage changes.  The requirements document was comprised of 130 pages, highly detailed and professional detailed. When the project commenced, the client was behind 2 drop dates (4 months), we assisted with the catch-up mode, saving the project from a drastic fail.  This was a mid-size project (6 figures), we worked long days and weekends to save this project.

Medical

Design and development of a complete HIPAA compliant medical portal doctors & patients and associated medical records system.  This project had a $300,000 project, we had 12 people working on this from concept, requirements definition collection, formalization of requirements, accept, development, project deliverable approval, production release and post production verification.

Medical Portal POC (proof of concept) for a Fertility clinic.  This project required protection against bot logins, bot logon attempt notification to users, automatic routing to never-never land when a bot attacked, user management, profile management, services content management and more.

Medical Image data processing system (POC) for a hand held medical device used by a general practitioner that scans heart chambers and vales to identify heart disease.  This was a small POC project focusing on advanced image recognition technology. Unfortunately, due to legal patent challenges from a patent toll legal firm related to the client, the project was placed on hold and we were contracted to argue the supposed patent infringement.

Mobility

POC iOS application intended for the US Chamber of Commerce, to automate visitor data collection with data consolidation across cities, regions and states.  This app eliminated the manual conversion of collecting hand written data and manually merging spreadsheets across regions, states and the country, with data being instantly consolidated across the nation.  This was a small project (5 figures).

A “No logon required” free social media mobile app to take pictures of public event posters (or marketing content) which were assigned categories, tagged with event name, location, dates, etc.  GEO lookups via US postal codes or GPS meta data within the image provided regional radius searching.  This allowed region visitors or tourists to instantly find activities of interest in their area via with keyword and category filtering (Night Life, Over 21, Family, Dining, etc.)  Monetization aspects included Ticket Master and poster advertisers).  A web portal provided back-end administration for event submission approvals.  This was a small project (5 figures).

Mobile Program Writer:  Subscription based automated mobile app generator for iOS, Android and Windows phones, eliminating the need to custom develop apps for major types of software products across all special interest categories.  Using a web portal, the subscriber selects App type, selects a theme style, custom branding, then defines or uploads content.  Then the three types of apps (iOS, Android and WinPhone) are generated (no programming required).  Think of this as an application that creates applications to be distributed on Google Play, the iStore and Windows store.  This was a small project.

Organize the unorganized local commerce market by providing the existing supply chain with mobile technology with auto-discovery of retailers, products and services, enabling direct interaction between the consumer & retailer, and facilitating the e-commerce process.  This was a small project (5 figures).

See Oil & Gas regarding a VERY large Field Data Collection project using an iPad).

Oil & Gas

Oil & Gas field data collection iOS tablet app, supporting dynamically generated no-custom-programming required data collection interfaces for routes, route stops, collection points for tank inventory, well status, casing and tubing pressure, seals, downtime, water meters with automated sync to head office.  This is probably the worlds most advanced product of its type and it drastically reduces field data collection costs for oil companies.  This was a large project (7 figures).  References available.

For numerous oil & gas companies, we provided custom programming to improve business process and reporting.

POS Back Office

Over 1000 hospitality and retail POS (point of sale) integrations, configurations, customizations and installations throughout the US and Canada.

Back of the house integration with over 40 different POS products (all major brands such as Squirrel, Remanco, NCR, Tec, Panasonic, Casio, RMS, Aloha, etc).

Entire custom back of the house system for Comtrex, for all end of day reports, cashouts & deposits, integrated with optional perpetual inventory, theoretical sales mix cost analysis, etc.  This was a mid-size project (6 figures).

Project Management

We provide an online portal to clients, stakeholders, analysts and developers.  The system tracks requirements, tasks, % complete, meetings, milestones, time, billing, invoicing, risk management, discussions, etc.  Everything related to the project is located in one convenient online location.

We provide staging systems for clients, to experience, visualize and experience day to day progress.  We also provide clients with access to their private TFS (Team Foundation Server) source code repository, to compare check-ins against requirement tasks, assess effort, etc.  Also note we utilize the advanced security capabilities of TFS, ensuring ONLY the people assigned to the project have the access they need (readers, contributors, builders).

All of our servers have 6 layers of security:  AD security, Symantec Cloud AV, MS Forefront security, heavyweight commercial Cisco firewall, Port and IP lockouts (intrusion detection) and TFS security round out these layers.  Our network is comprised of Cisco routers, IBM hardware, commercial tape backups using Microsoft DPM, offsite backups, UPS and diesel backup protection, BGP routing with 4 GB’s of connectivity, SSD storage and 99.9% uptime guaranteed.  This enterprise class infrastructure ensures we have the tools and performance required to develop and protect a client’s IP.

Our developers adhere to our proven methodologies and business process, from architecture to coding, ensuring the codes are unit testable and loosely coupled.  All deliverables are verified via a recorded session, when a task is about to be closed and confirmed by our QA team, stakeholders can view the video recording of the deliverable confirmation.

We utilize a silo approach to development for the UI, business logic and Data layers.

Reservation Systems

Numerous custom proprietary motel and hotel reservation system integrations.

We have also developed web based service extensions providing web discovery interfaces and enumerable services related to online reservation bookings, pricing, inventory, features and amenities.

Retail Management

Developed a web portal for tracking and managing inventory, logistics, resource management, with A/R and A/P.

Component for managing private label products within a supply chain management system, based upon documents exchanged between the various entities.

Multilingual application for managing in store promotions, supply and management of private label products for retailers across diverse vendors and global locations (countries).

Customization of POS relational databases to support bar code scanners.

Custom Software

Animal dental care dentistry solution for veterinarians, supporting all industry standard diagnosis and procedures, dental charting, occlusal charting, anesthetic monitoring, compliant medical record locking, multi-user networking with client and referring vet facing web portal.  Also integration with non-competing market leaders allowing for a quick start-up (clients and patients being electronically imported).  This was a small project (5 figures).  References available plus a BBB review.

Complex sports portal / web application for managing sports, venues, teams, referees, inventory, placement, penalties, scheduling and other features required by a city or league to manage the sport.  This was a mid-size project (6 figures).  References available.

Online Trading (bid/sell) management portal for the coal and energy sector, cannot disclose details, other than it being a mid-size project (6 figures).

Websites & Web Based Applications

We have been involved with many custom website projects and web based applications (at least 100). There was a time when much of our work involved creating general websites. However, due to the advancements in website template offerings such as WordPress (our website is a theme based WordPress template), it no longer makes sense to spend thousands on a general website (when you can purchase a fantastic template for $50).

Campbell Software also has experience with at least 50 complex web applications.