Campbell Software has a strong understanding of custom accounting software development from accounting, audit, integration and design perspectives.

Scratch build of a full custom designed accounting system:  We created an accounting system which included a General Ledger module, an Accounts Receivable module, an Accounts Payable module, a Canadian Payroll module and a Point of Sale interface module (sales were electronically imported).  The usual reports such as Income statement, Balance Sheet, Trial Balance, Audit Detail, Aged Receivables and Payments, plus Employee T4’s and Corporate T1 were also provided.

Electronic Polling / Billing system for legal firm:  This project integrated data from a serial based (RS-232) telephone station message detail recorder (inbound and outbound telephone and fax call SMDR), a photo copier, an electronic  postage metering system and a network printer.  A module “polled” the electronic RS-232 devices, and some of the data was collected from network device logs.  The electronic data was costed, transposed to a proprietary format, then converted to EBCDIC via a 5251 emulator, and pushed out to a custom IBM System 36 accounting system.  The one click process eliminated all manual data entry which previously required 3 full time staff.  The system also forced client account coding of all inbound and outbound calls & hard copies.  For example, if a secretary or a lawyer received or made a telephone call, sent or received a fax, printed a hard-copy or photocopied a page, the system required a billing code.  This project resulted in a monthly gain of $30k of additional billing per month for the legal firm.  References available.

Campbell Software developed a custom Web Analytics tool to capture and study website behavior.  Client side mouse movements and mouse clicks, ENTER key, navigation keys (home, end, page up, page down) and key combinations were captured for each website element.  Activity flow (from to paths) and data was totaled per user, per page, per element, with low, high, means and averages, group by screen sizes.  Custom Analytics software development reporting exposed the variances of how usage expectations differed from real world usage.  In many cases, the Analytics tool identified where people had difficulties performing certain tasks, where people had challenges finding certain options and functionalities that were hardly ever used.  Personal user information was not collected, adhering to common use privacy policies.  The technology was designed to be a plug-in, meaning that with just a few web page includes, client side Analytics could easily be implemented on any website.  We also developed the server side reporting system which could be (or not) accessible via a site portal (logon authentication required).

We also created a custom mobility application metrics capture and logging product, similar to the concept above, but for mobility (iOS and Android devices).  The project was developed for a commercial 3rd party analytics tool company.  The custom analytics software solution included a web services API, providing a deep analysis of user metrics to measure interactivity, features used, features NOT used, user flow, application usage time totals and more.

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 as the project was deployed across 17 different states.  The roll-out of the custom banking software solution was intense as laws and compliance rules differ between states.  Campbell Software was 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.

A primary aspect of development was migrating code and data from mainframe systems.  Since mainframe numeric data representation differs (as does textual content), all of the data needed to be transposed to a PC format.  To reduce translation requirements, we implemented specialized hardware to convert the data.  Additionally, due to the legacy aspect of the data, date formats (of all historical transactions) had to be expanded (similar to the Y2K issue).  Security compliance was a concern due to the legacy of the original system, this was a sub-project on its own due to the age of the original treasury management system.  As well, we also provided a robust set of new reporting features, capable of grouping report data by sub-regions, regions, states and across all branches.  We cannot disclose additional details due to an NDA other than stating the technology effort was primarily a migration from COBOL to a .NET / Microsoft stack.

We developed a “generic” custom big data software solution which provided a plethora of custom big data collection configuration options.  The configuration options provided legal web scraping via website approval keys, similar to how Google Webmaster Tools ensures ownership.  Configuration options also included REST interfaces for posting named pairs with pass-through authentication.  Data could also be collected via form posts, flat files such as .CSV or XLS, SQL data transfers (via SQL SSMS User access) and various types of API’s.  The SQL database structure was proprietary utilizing SQLCLR to ensure tables, queries, design and working secrets were not exposed.

We created various windows services to perform unattended automated data collection.  Automated services ground the high velocity, complex and variable data, drilling it down into a 3 levels of analytical phases (unstructured data analytics).  Once prepared, custom software services performed calculations with means, averages, with hi and low value thresh-holds optionally flagged as ignores.  Upon completion of this step, custom views were populated, aided by solution specific modules.  Views supported various forms of filtering (date range, regional, types, etc.).  In summary, this “generic” big data custom solution provided in-depth automated analysis of disparate yet related data, with advanced blending algorithms and rules to identify trends, medians, probabilities and predictive analysis.  Note Campbell Software was chosen to develop this solution to to our extensive SQL experience, our Analytics experience  and our business reporting design experience.  This was a mid-size project (6 figures).

We created a Child Care Services Custom Software Development 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).  The project is now in maintenance mode.

Charles Flowers, CEO of CCSG stated:

“In February 2014, we started working with Campbell Software, replacing our existing contracted development team due to vast shortcomings.  Gary’s team immediately addressed the previous group’s short comings, over-promises and failures.

Campbell Software improved progress visibility, provided detailed work logs per developer, provided staging and beta sites, code repository and an online project portal.  

In comparison to the previous company, Campbell Software has completed tasks faster for a lower overall cost.  But most importantly, their code is resilient, secure and performance driven.  

To summarize the 8000+ hours of development Campbell Software has provided to date, they have addressed performance issues and eliminated bugs inherited from the previous team.  They have completed 86 sprints and 2 production releases.

We are now working on our 3rd production release.  They are also hosting our production servers at a cost lower than Amazon.  What impresses me is that they seek to find lower cost approaches to accomplish the same task (one task in particular eliminated a $5000 expense per year).  Yet another involved a database trigger approach that eliminated hundreds of hours of complex development and a huge amount of QA.”

Gary, Charles, Rachit and other primaries worked closely together for years on this project.  One person (Sandy) requires special mention as she provided rock solid requirements and follow through, she was a key person (employed by CCSG) to make this project a success.

Gary Campbell was the founder and director of a custom, scratch build web conferencing platform.

The Web Conferencing software platform was nominated by the British Columbia Technology Industry Association as best start-up in 2006 by 900 members.  The web conferencing platform was used to host over 500,000 business meetings.  Over 4 million people used the custom designed built from scratch product.  PC Magazine provided an expose of the product (earned media, not paid).  The company and product was profiled in a publication by the Honorable Colin Hansen (June 15, 2006) “British Columbia Technology Sector Profile” as a success story.  The product and company also appeared in Frost and Sullivan, IDC Research and Wainhouse Research publications (web conferencing research papers and comparisons).

This web conferencing software platform was unique in many ways.  The product could be “skinned”, meaning that all colors, buttons, icons and graphics for the user interface could be branded (custom themed).  Another unique feature was that the web conferencing platform provided private 1:1 and separate group audio conversations to occur while listening to the podium speaker.  This allowed people to discuss / comment / question the podium presenter privately while the speaker was talking.  Another unique feature was voting, when a podium speaker was talking, they could ask a question and get immediate feedback with a vote tally.  The doodle board was also popular, screens could be marked up participants (if enabled) to provide a truly interactive meeting.

A Verizon branded version was used internally (internal and external users could join meetings).  It was rolled out to tens of thousands of internal Verizon desktops.  The web conferencing system was also used by Health Canada, Engineers without Borders, Purple Hearts, some 50+ colleges & universities.  The Canadian military used the product for group based tank battlefield simulations, it was used for real time auctions to sell heavy equipment (live auction bidding component) and also sell homes auctioned off during the real estate crash.

Servers were .NET C# based, client was OCX based, first on the scene with a Windows 7 one 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.

We created a scratch built Education Based 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.  For each role, tasks, processes and verification processes could be assigned.  This enabled a LMS provider to define customized daily, weekly and monthly task lists.

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).

The custom LMS Education 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).  We have a whitepaper available which details all features, topology, hardware and more.

Campbell Software was subcontracted to create 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#.  Gary Campbell wrote the user guide while directing developers to deliver the requirements.  We cannot provide further details due to an NDA.

We developed a role based secure work force management Custom ERP solution, where data was collected from many different types of sources (proprietary and standard data formats) from contact centers across the globe.   Data collection processes supported including field office to head office data transfers, file based transfers, API service based data transfers and unattended automated service based ERP data transfers.

Our custom ERP software development experience includes developing flexible / configuration control panel applets which were then consumed to provide a custom user defined dashboard.  Data snapshots were supported, where live data was frozen in time allowing deeper analysis.  We also provided in-depth reporting and charting via SSRS.  Analytical reports provided deep analysis of service levels, quality of service and other key performance indicators (KPI’s).

State Wide Energy Utility Grid Project – One of our key people at Campbell Software has a PHD and a Masters degree in two energy systems related fields.  As such, we are a suitable match for city, state and country based hydro projects.  One of our state based Hydro projects required custom ERP software to provide real time data collection, reporting and analysis of SCADA data feeders, generating live alerts of theft, bypasses, outages, load triggers other parameters.  Custom ERP software management modules were also required.  These modules included performance analysis of field teams, feeder scheduling, tiered level shutdown process due to electrical shortage and demand forecasting.  This was a very large project (8 figures).

For 300 Wendy’s franchises, Campbell software, contracted to 2020 ITS provided modules to collect data from separate franchises in Canada, pre-process the data to a common format, and push the structured data to the Canadian head office.  This was a a challenging hospitality software development project in that franchises used many completely different POS systems.  As such, PLU menu item numbers, names, even pricing varied, as did regional specials and promotions.  Gary wrote a module to translate the hospitality Point of Sale data to a common format, based upon his past experience integrating 40 different POS systems to a common back office.

Gary also developed a complex EDI ordering system, integrating to a major Ontario based food supplier with distribution branches located across Canada.  By leveraging his past experience with perpetual inventory and recipe costing, the system could generate orders to the supplier leveraging “just in time” ordering.  This functionality saved management many hours of effort per week, as manually determining what and how much to order, and telephoning in the orders is time consuming.  A Labor scheduling module was also developed, automating and labor costing shifts based upon projected sales.

Also for a Wendy’s Franchise, Gary and his team performed an in-depth cost analysis (onsite weighing and measuring ingredients) with recipe confirmation of Wendy’s entire line of food and beverage products resulting in nation price change corrections across the chain.  While this effort was not as much hospitality software development related, the extremely detail oriented data collected provided an accurate costing analysis.

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:

Campbell Software developed over 40 different POS systems interfaces which integrated most major cash register brands.  30 revenue centers per store were supported, each supporting up to 30 different inventory stock.  Batch processing was provided (for commissaries with tracking/distribution to franchise locations).

Perpetual Inventory, Just in time reordering with EDI electronic ordering to major vendors, Receiving with various handheld electronic devices were supported.  Also provided was 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 was provided.  Daily server cash-outs, blind cash-outs and cashier cash-out systems automated and simplified shit based and end of day processes.

Projected labor cost scheduling was a key feature, enabling management to schedule staff, costed as per projected sales.  Staff management also included magnetic card sign-ins with early / late approvals and custom rounding rules.

Daily and to-date labor costing, end of day financials and many other features were provided.  The product was distributed in 7 countries, in 4 languages (English, French, Spanish and German).  This Custom Hospitality Back Office Software product was probably the most extensive restaurant management system created.