Spectra Data Solutions Ltd - Custom Software Development, Business Automation Solutions, Database Development, Systems Integration.

Our Software Solutions

While Spectra Data specializes in custom-built software development, we also have a number of existing software solutions used every day by our clients.  Please forward any enquiries about these using the Contact Us page.

Duplicate Record Remover

The Duplicate Record Remover is for finding duplicate contact and customer records in a database and providing a software tool to merge those duplicate records back into a single record again.

This tool examines large customer/contact/client/marketing database lists and uses a fuzzy-logic algorithm to identify any duplicate records.

The fuzzy-logic technique is clever enough to identify duplicate records even when names and addresses are misspelt, incorrectly entered or abbreviated. After examining the records, it automatically merges any clear duplicate records it finds, while also providing the user a simple tool to examine and confirm any less-than-certain matches.

You can download the tool from the Duplicate Record Remover download page, or read more about why you should delete duplicate database records, the process of finding duplicate records, and deleting duplicate records and where duplicate database records come from here.



Other tools available include:

Skill Tracker

Skill Tracker is an employee skills and competencies tracking system.  It allows you to track employee role requirements in a hierarchical (tree-like) manner.  Skills and competencies are arranged into common groups and applied to each role as required.  These are then tracked against each employee to identify any gaps in their skills and training.

Skill Tracker can…

Manage Organizational Role Requirements

  • Manage complex job descriptions and requirements in a natural hierarchical manner (eg: parent-child-grandchild skill requirements).
  • Track which employees have a given set of role requirements.

Warn of any Skills Gaps

  • Allow quick and easy reporting of current staff training requirements.
  • Give pre-set warnings of soon-to-expire licenses and skills.
  • Manage crews and shifts (collections of staff) that have given requirements, and whether those requirements are being met.

Track Individual Employee Skills & Training

  • Track skills, courses, licenses, endorsements, ratings, tasks and requirements that each employee has undertaken.
  • Produce individual training plans customized to each employee.
  • Allow for succession planning and future role training plans.
  • Track skills and training outside an employee’s current role.

Be Easy and Intuitive to use

  • Skill Tracker has a highly intuitive Windows design with quick double-click navigation, drag-and-drop, context-sensitive menus, and multiple window editing.

Spectra Marketing Toolkit

The Marketing Toolkit tracks direct database marketing activity.  It tracks the effectiveness of each campaign and the value of each individual customer to the business.  This solution has been custom-built for Comzone (Telecom Business Directions) and Loadrite and can be modified and adapted to almost any business that stores customer details.

Stock Tracker

Stock Tracker is a stock management system built for mail order companies to allow phone, mail and web orders to be placed.  It manages inventory, pricing, orders, invoicing and debtors.  The result is a reduction in warehousing and order fulfilment costs.
Spectra Data Solutions Ltd
“We have found you to be honest and committed. Most importantly you carefully consider the implications of each change request...”
Ted Ebbing - Project Manager - ABN AMRO Craigs
Copyright © 2000-2008 Spectra Data Solutions.