“ ”
Examples: making a difference in businesses and organisations
amina - call handling
Amina - The Muslim Women's Resource Centre's confidential telephone helpline service needed a system to log calls, clients and issues and to provide regular summary data to management and funders. We built the system on their existing platforms (Microsoft Access, SharePoint and Azure).
HomeForce - integrated business process
Edinburgh HomeForce wanted to grow business by streamlining the process of taking customer calls, offering jobs to local tradespeople, allowing them to accept the jobs online, tracking those jobs and automatically billing HomeForce's percentage. And to keep everyone informed by email. We built from scratch desktop apps and an online 'Job Board' that allowed tradespeople to accept jobs and synchronise with the ServiceM8 off-the-shelf job management system.
causeway education - gdpr
Causeway Education's Director of Research needed external technical advice on their preparations for new data protection legislation. We reviewed the organisation's data audit procedures, data plan and privacy notices and provided written and over-the-phone advice.
the Sutton trust - needs analysis
The Sutton Trust had grown rapidly in recent years and needed to take stock of its I.T. systems, software and security. We spoke to multiple stakeholders in the organisation, wrote a report with recommendations and helped to implement them in conjunction with their existing I.T. suppliers.
cws - maintenance & development
Commercial Water Solutions’ software website, database and system software was built and maintained abroad on a retained-contractor bases. The system takes customer queries, downloads and processes daily water market data, and generates quotes and invoices. We took over and have maintained the code, have progressively increased security, and have developed the system, on a job by job basis with fixed price quotes for each piece of work.
Taylor partners - data cleaning
On behalf of one of their clients, Taylor Partners Marketing Consultancy needed to combine thousands of customer data records from the client's employees' email accounts and from the client's invoicing database. We wrote a utility that intelligently matched customers using the different types of data available in the invoice and email accounts, and removed duplicates across all the email accounts, and generated a single list that Taylor Partners could use to create the client’s new marketing database.
queen rania foundation (jordan) GDPR
The Queen Rania Foundation wanted to review their data protection policies in light of GDPR, with a view to developing high standards and meeting European funding organisations’ needs. We provided text and graphical resources and met in order to help them analyse and develop their on-going review process.
learning for sustainability scotland
LfSS needed to collect the same project data from a range of organisations who were executing the project. Some of those organisations wanted to draw the data directly from their existing databases into the format required by LfSS. We built queries on top of the existing system to provided the required information.
Ideas - data mining
The International Development Education Association of Scotland needed to rapidly and regularly collect deep data from their members' databases in order to meet Government reporting requirements for a funded project. We developed the software to dig out that data and write it to an internally-designed spreadsheet. Some members ran the software themselves. Some members asked us to deliver their reports.
Scotdec - data import
Scotdec moved to online SurveyMonkey questionnaires to evaluate their professional learning events. But they needed to get that data into their desktop Microsoft Access evaluation database system. We built a utility that allowed them to equate online questions with database system questions and automatically import responses into the database.
GOVAN HELP
Govan Help’s service user registration and case note database needed to be replaced because the existing system was not meeting staff needs. We worked through what was required and built a new system using the technologies in which they were already invested.