Zebranet client case studiesFrom construction to stock control
Below are just a few case studies from recent projects to highlight the diversity of what we do here at Zebranet.
This is not a comprehensive list but it just gives a flavour of some of the projects we’ve undertaken recently. Who knows, your project could be next on the list!
Electrical safety services organisation, Sheffield
We were approached by the company with a view to design and build a solution allowing them to undertake electrical surveys on-site and allow them to submit the results back to a database for their clients to view.
After consulting with the company, we specified a solution whereby the engineers would take tablet pc’s on-site with them and fill in the forms electronically using a bespoke Microsoft Access database written by me. The information gathered would then be transmitted automatically over the web to a dedicated client SharePoint site hosted on the company’s servers. Their client would be given logins to their own site so that they would be able to view and download their reports.
we designed several custom pages in SharePoint so that the format of the reports resembled the BS standard paper forms.
We then set up a training programme for the internal office staff an engineers, so that they would be fully skilled in using all aspects of the system. We also performed ‘administrator’ training for key members of the internal office staff to enable them to manage several aspects of the system themselves.
Testing, inspection and compliance services organisation, Burton-On-Trent
This company required a SharePoint-based intranet solution building. Within this, there were several departmental applications that needed to be included in the build:
The company had recently merged with another organisation and had a requirement to be able to internally invoice between the two businesses. We designed and developed an invoicing facility within SharePoint using a combination of SharePoint’s built-in workflow functionality and custom programming to create an efficient solution which is used daily.
There was also a requirement to build a disaster recovery solution, where all solutions and scenarios are logged within the site and actions taken accordingly. This used standard SharePoint functionality and some custom development.
The company is split over more than 20 sites and laboratories, so we had to make sure the system was accessible across all sites.
We also designed several different training workshops for the company to cover all the levels of technical ability and user focus.
Cutting technology and plastic solutions organisation, Blackburn.
This company wanted to build a CRM solution, but found that the majority of off the shelf solutions didn’t quite do what they wanted. We designed a bespoke CRM solution within SharePoint which allows them to integrate with email clients (Outlook in this case) and their Opera II accounts solution.
The system was designed to retrieve live sales data from the accounts platform for analysing sales trends and invoiced information so that the sales team can build up a clearer picture when identifying leads. There is a full sales pipeline and opportunity management function using a combination of SharePoint built-in technology and custom development. There are many workflows running in the background for notifications, reminders and escalation of tasks within the opportunity area.
Once an opportunity becomes a sale, the system automatically sends the relevant data into the Opera accounts system to produce the relevant paperwork and create the invoice.
Staff training for this solution was ad-hoc during the development of the solution. Demonstrating the system to the sales team when available and working with internal staff to design and develop the solution as we progressed.
Aerospace and defence organisation, Derby
We are working with this company to build a company Intranet incorporating: Document Management, HR solutions, Quality tracking, and building a full reporting solution linked to their ERP system.
This involves integrating SharePoint with several third-party solutions in order to retrieve and post data to various areas within the organisation. One of the other requirements is to build a customer portal in SharePoint whereby their clients can log in and see the status of projects, create and monitor concessions and also provide feedback. The key of this solution is to provide a central area bringing together several systems and remove the need for manual reporting, and reduce the amount of paper the company produces. The business is across several sites in the UK and the USA, so connectivity, stability and security are paramount.
We worked with the internal IT team and trained them with basic administration skills so that they can take the solution over in the long term. We’ve also worked with the management team in workshops so that we can build the right solution and define the project goals from the outset.
Relationship support charity, Doncaster
This charity needed a way of keeping the information about their practitioners in an easily navigable system. Keeping track of training records, qualifications, documentation, roles and registration for over 1,800 people all over the country required a bespoke system.
We were initially given a full specification from the client, but on closer inspection we realised that there were going to be problems with functionality if we stuck to it. So we went through the whole thing with the project stakeholders and changed the direction the system would take. This made it far more user-friendly and cut down on a great deal of duplication of data.
We built it from the ground up to be a web application so that it could be accessed from any number of devices. It has saved time, money and manpower since it went live back in 2013.