Client – Vee24

Vee24

Database and software developer, BI developer

On-site

Vee24 is the world leader in live video chat solutions. They use JavaScript plugins to allow website users to interact with sales agents via web services, offering video, text messaging and co-browsing.

In 2013, Vee24 asked me to assist with management of the huge amount of time-critical data going through their Sql Servers and also build a new reporting system as the company’s permanent development team were focussed on core product delivery.

My initial contract was to help with these two areas but was extended multiple times to assist with continued expansion in these areas and also to enhance the core system’s web handlers, create a new content management system, improve logging systems, create a new dashboard and assist with the web farm redesign as the company increased its use of Microsoft Azure as its delivery platform.

Key achievements

  • Huge improvements in reliability and performance of database operations, maintenance and replication.
  • Created Content Management System using C# MVC and Bootstrap to replace ageing SharePoint system.
  • Created a secure web application reporting system presenting time-zone sensitive data using SSrs templates.
  • Created Analysis Services data cube for management reporting of client success.
  • Created secure web-socket based dashboard showing real-time agent availability and user information using SignalR.
  • Created management overview dashboard showing fast response high level KPI versus actual summaries (JavaScript / JQuery / HTML5 Canvas).
  • Created API (with Azure Management API front end) to allow users secure and monitored access to raw JSON data.
  • Rewrite of REST API for back-end operation support using Couchbase NoSQL database.
  • Eliminated storage of PCI data from text chat messages by using regular expressions within SQL Server using a CLR object.
  • Created prototype production system for back-end SQL Server 2014 Enterprise with Always On High Availability Groups on Microsoft Azure to migrate current system.
  • Implemented SQL CLR object to add Regular expressions, base64 encoding and decoding and Time zone awareness to SQL Server.
  • Designed and implemented a tagging system for operator skills, allowing web applications to quickly search for available operators with specialist skills (these tags also provide useful real-time information to the afore mentioned dashboard).