Monday, 30 January 2017

Quick Guide to getting your Excel Spreadsheet Online



If you have some useful Microsoft Excel spreadsheets that are loaded with functionality, but are not fully available through Office 365 and Excel online then this short guide is for you.

 

Why is it not fully functional through Excel online?

Office 365 provides you with the most recent version of Office programs, there is however a desktop version of Excel and an online version. The desktop version is backward compatible, meaning it fully supports VBA macros, which is the technology that is used to implement application-like functionality within Excel. VBA is powerful and very easy to get started with and is widely spread within most industries.  Here is the catch, Excel online doesn’t support VBA. The spreadsheet will still open, but all VBA macros will be disabled. Simple as that really.

What has Microsoft replaced VBA with?

Microsoft provide 2 different methods in which functionality within Excel can be implemented, Apps for Office and Visual Studio Tools for Office (VSTO). Without getting into the tech too much, these are more current technologies. They do however present a bigger barrier to entry because whilst almost anyone could quite quickly learn to put together a VBA macro, these 2 new technologies require some form of understanding of software development and the respective languages.

What are your options?

VBA is not going away overnight, it’s too widely used for that, however it does make sense to at some point make the transition to the newer tech and take advantage of the features that they have to offer. These new technologies can improve the stability, performance and usability of your spreadsheet and also reduce the time it takes to make amendments or implement new features. If you prefer to put the change off for a while, another solution can be too run the spreadsheet somewhere on a permanent basis and only share the relevant data via Excel Online, which is achievable via 3rd party tools. If you would like assistance with migrating your Excel applications to Excel online or making use of tools to share your data securely online, then get in touch and we would be happy to help.



George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

Wednesday, 25 January 2017

Synetec Looking for Full-Stack Application Developer



Synetec is a growing software development firm that builds bespoke, business-critical systems for some of the UK's most interesting organisations. The company is expanding and we’re in need of talented software engineers at all experience levels to work across the development stack.

You’ll be surrounded by smart, highly-capable people in a collaborative environment that encourages the sharing of knowledge and experience. You’ll be as passionate as the rest of us are about doing software engineering right, and ultimately delivering great solutions to our clients. We follow an Agile approach with solid development practices, and encourage picking up new skills and expanding your experience.

We’re more interested in finding great people to join our motivated team than in hiring experts in any specific technology. We are looking for creative and self-motivated problem solvers with a demonstrable passion for technology.

You should have:
  • C# 
  • MVC
  • REST API Development
  • SQL (MSSQL, PostgreSQL or Oracle)
  • ORM (Entity Framework or Nhibernate)
  • A JavaScript Web Framework (Angular, React, Node)

It would also be great if you have:
  • Experience of a cloud platform such as AWS or Azure
  • NoSQL Databases 
  • WebAPI 
  • Mobile App Dev (ReactNative or Xamarin) 


All candidates should have UK work experience and the necessary passport or visas to work indefinitely within the UK.

NO AGENTS PLEASE
Applicants must register their interest and email through their CV's to careers@synetec.co.uk

Tuesday, 10 January 2017

Job Role for New Business Development Manager



Company Profile

Synetec is a growing software development firm previously targeting primarily the Financial Services sector and now expanding into other industries. We are a Microsoft Certified Solution Provider and cover most areas of software development. In addition we also provide support for new and legacy systems to a number of clients.
Due to a new service offering we are looking for a Business Development Manager who wants to join an exciting and talented team working in a personal and growing environment where they can help grow Synetec to the next level.

Candidate Profile

The successful candidate is skilled and experienced in finding and winning new business within the software development services space. They will have a proven track record in closing and be completely confident in generating or assessing the marketplace to identify sales leads. They would be excited by the prospect of building on their existing network within the software development services or financial services industry sector.

They will be someone who doesn’t want to be just a number in a team within a larger company, but will thrive in the personal environment of a smaller company where a big part can be played in the continued growth and they can share in that growth.


Essential Job Functions:

  • ·         Develop and execute a new business strategy
  • ·         Create and maintain a sales pipeline that supports your sales targets
  • ·         Grow the network of referral partners
  • ·         Meet defined lead generation targets
  • ·         Meet defined revenue targets
  • ·         Autonomously source and develop your own prospects and opportunities
  • ·         Consistent attendance of relevant events for networking
  • ·         Compose compelling proposals
  • ·         Identify prospects requirements and align with relevant products/services
  • ·         Build relationships with senior level prospects by gaining insight into their businesses to enable you to provide solutions for their requirements
  • ·         Maintain a strong understanding of relevant service offering and technology landscape
  • ·         Create and maintain our personal weekly sales plan
  • ·         Keep CRM system updated with all your activity
  • ·         Reporting on sales, customer and market intelligence updates
  • ·         Work with marketing to create assets to support the new business function


Requirements:

The requirements listed below are representative of the knowledge, skills and/or abilities required to satisfactorily perform the essential functions of this job:
  • ·         IT Services Sales experience
  • ·         Track record of achievement against revenue and performance targets
  • ·         Strong understanding of IT Industry and software development
  • ·         Experience in presenting to all levels
  • ·         Experience of creating, delivering and winning pitches
  • ·         Sales related certification
  • ·         Degree level education or equivalent



NO AGENTS PLEASE! 

Applicants must register their interest and email through their CV's to careers@synetec.co.uk 

Staying motivated on the move. The top tech podcasts



If like me you have little spare time, but spend a fair bit of it commuting or driving and you can absorb information quite easily from audio, then this list of podcasts could quite literally change your year. Subscribing to the right podcasts allow you to easily stay abreast of what’s going on with your areas of interest while you are on the move. So without further delay these are my personal tech podcasts that I subscribe to, hope you enjoy some of them.

·         Agile for Humans

·         Western Devs

·         The Vergecast

·         Harvard Business Review (not specifically tech, but features it quite often)


There are some others that I listen to which are more general business interest, but a tip of advice is to not subscribe to 50 podcasts and then never listen to any of them. Which is what I sometimes do.



George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

Thursday, 1 December 2016

Synetec supporting #Movember

A couple of us at Synetec wanted to raise some money for #Movember this year, the money that was raised was matched by Synetec to support a worthy cause. 

1 month worth of growth below! 



Friday, 18 November 2016

#noestimates




Prior to the popular Agile era which started roughly in the late 90's, The waterfall model was widely recognized as the most popular, and involved a  sequential software design process, in which progress is seen as flowing steadily downwards (like a waterfall) through the phases of Conception, Initiation, Analysis, Design, Construction, Testing, Production/Implementation and Maintenance.
The down-sides included time-lines and budgets.  A typical software build could take 6 to 9 months, during which time the stakeholder had little or no interaction with the product and what seemed to be business critical at the start of the build would often be deemed unnecessary or secondary months later. The client also realized no benefit from the project until the very end when the entire system was presented in one wave- not always the all-singing, all-dancing system it might have been sold as.

The four core values of agile software development as stated by the Agile Manifesto emphasize: Individuals and interactions over processes and tools. Working software over comprehensive documentation. Customer collaboration over contract negotiation.

The Agile Manifesto, above,  evolved processes somewhat and gives the stakeholder a greater level of control at a much earlier phase of the build time-line. As functionality is released, it can delivered incrementally, enabling some benefits to be realized early as the product continues to develop. This Speed-to-market can be beneficial for cost control and monitoring quality before it's too late to do anything about it. Should requirements alter, subsequent functionality and system design can be changed before being developed, saving large amounts of wasted development costs. The end result is optimum business Engagement and Customer Satisfaction.

Agile is not without its own challenges though... with daily stand up meetings not always being possible and regular involvement from stakeholders can be limited due to time and distance. Business Analysis, Requirements Planning and Estimates might not always be totally accurate and can change along the way, proving to slow down development and be seen by developers as a distraction.
Ask any developer using Agile, they would still rather not have estimates and planning around every corner and the #noestimates movement is gaining momentum, adding the need for even better tools to unsure that quality is not compromised by frequent delivery dates.The #NoEstimates hash tag on twitter has caused a whirlwind of discussion about the role of estimates in software development, with several books already writtenon the subject.

The basic idea, is that it is possible to do small chunks of work incrementally, leading as rapidly as possible to a desired usable product, and that when you do that there is no need to do much of anything in the way of estimating stories or the project. Estimates present another challenge all together. When requirements are vague — and it seems that they always are — then the best conceivable estimates could also be guestimates rather than estimates. Accurate estimation of complex functionality often requires a fair amount of work and quite frequently some initial coding to validate. It is still almost impossible to know how long something will take, without research and validation.

Estimation is challenging and we would be well off if we could avoid it, that’s why the #NoEstimates idea is so compelling, however there are many real business questions that will always need to be answered before they become obsolete. “When will it be ready?” “How much will it cost?”
“Accurate estimation is impossible for complex technical projects, but keeping to agreed budgets and deadlines is achievable by using feedback and change.” Seb Rose from Clay Snow

George Toursoulopoulos, CEO at Synetec Ltd, who delivers bespoke software to small and medium size hedge funds is aware of his development team shouting No Estimates, yet insists that his clients require commitment in terms of deliverables and costs and estimates are currently still essential.



George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

Thursday, 11 August 2016

Tech trends in financial services

The UK’s financial services have entered a period of unprecedented turbulence, further enhanced by the Brexit vote. This has brought a sharper focus on to the wider challenges facing the more established players, namely driving down cost, increasing security and improving the client experience. All have technology as the key enabler.The tech sector , being dynamic and rapidly evolving, leaves a strong temptation to adopt the latest ‘breakthrough’ or ‘gamechanging’ application, but a key aspect of exploring digital business models and processes is understanding how technology can facilitate and streamline all aspects of the business, while supporting a longer-term strategy. Brexit makes this more imperative with the pressure on the financial services industry to diversify their USPs if they are to retain global pre-eminence. This diversification is key in before the potential regulatory impacts and talent outflow start to bite.

This risk of talent outflow is a focus of the Mayor of London. His office launched London’s Digital Future - Mayoral Tech Manifesto 2016 alongside the #LondonIsOpen campaign, to show international entrepreneurs and investors that London retains its entrepreneurial spirit and status as the top tech city in Europe.

Back to financial services - how should they monetise knowledge capital and innovation to ensure they stay profitable, technologically competitive and continue to pull in diverse international talent? Technology is the key enabler, particularly around providing a continually improving and seamless service no matter where the platform, staff and knowledge are based. As financial services companies are under cost pressure to run a more dispersed business, both through geographic footprint and 4-D teams (dispersed, diverse, digital and dynamic), clients’ requirements to feel safe are emphatic. Technology needs to ethically facilitate this. Recent incidents such as the hack of SWIFT and the loss of funds from a blockchain segment have an exponential impact on clients’ security fears.

Consumer driven demand for financial services to be innovative and shareholder demand for cost reductions have to be balanced against regulatory requirements. One can't afford to be left behind; there is absolute expectation that financial services are on top of the new technological themes, such as block chain, yet capital requirements have a direct link to operational risk, which includes IT and IT processes. If systems or processes are flawed, the capital requirement could increase. Hence technological innovation needs to be carefully balanced.

According to McKinsey (5 questions boards should ask about IT in a digital world, July ’16), executives should be routinely asking these five critical questions relating to the organisation’s performance: • How well does technology enable the core business? • What value is the business getting from its most important IT projects? • How long does it take the IT organisation to develop and deploy new features and functionality? • How efficient is IT at rolling out technologies and achieving desired outcomes? • How strong is our supply of next-generation IT talent?

To the last point, I would add ‘and ideas’. How are financial services firms staying on top of all the new ideas being developed? How are they building both interaction with external technology firms and investment, into their business strategy? There has been an explosion in the number of new technology entrants, each typically offering aniche, nimble and flexible solution to a particular area of inefficiency, rather than a full service offering. One useful piece of reading material is the newWorld Economic Forum report (http://reports.weforum.org/future-of-financial-services-2015/executive-summary/), which reviews what the future holds for the finance industry, drawing on interviews and workshops with industry experts, global financial institution strategy officers and high-flying fintech innovators. Their findings suggest that the upcoming innovations will encourage a fundamental review of business models in financial services.

There is disruption to come and it is going to shake the industry to its core

Rachel Barnes is a financial services industry adviser to Synetec, one of the UK’s leading providers of bespoke software solutions.

References: World Economic Forum report (http://reports.weforum.org/future-of-financial-services-2015/executive-summary/) McKinsey (5 questions boards should ask about IT in a digital world, July ’16) London’s Digital Future - Mayoral Tech Manifesto 2016

Tuesday, 7 June 2016

Permanent Role for a Software Developer




Synetec is a growing software development firm aimed primarily at the Financial Services sector. We cover most areas of .net software development. In addition we also provide support for new and legacy systems to a number of clients.

Synetec is expanding and we are looking for a mid-level developer to join us and as a valued member of the team, we will encourage, train and support you in keeping you up to date with the latest technologies.

Job Description 
  • Minimum of 3 years experience
  • Experience in the following is essential: MVC, Microsoft C# .Net, Microsoft SQL Server
  • Experience in the following is beneficial: ASP.net Web Forms, Agile Development Methodologies
  • Familiarity with the following software is essential: Visual Studio, Microsoft SQL Server Studio Manager
  • Permanent position
  • 6 Month probation period
  • Based in London near London Bridge, Southwark and Waterloo stations
  • Starting ASAP





    Additional Points:

    We are looking for an enthusiastic, energetic, ‘can do’ type of person that gets along well with others

    All candidates must have UK work experience and the necessary passport or visas to work indefinitely within the UK.

    NO AGENTS PLEASE
    Applicants must register their interest and email through their CV's to careers@synetec.co.uk

    Should you Buy or Build your Intranet



    Every organisation that has more than a handful of employees can benefit from having an intranet. It offers a casual, multi user, easy to access, up-to-date means of communication. Communication is key in any business, therefore so is an intranet.

    The big question for business decision makers is whether to buy ready-to-go intranet software or build your own bespoke software. The correct answer depends on your business needs, your combined technical ability and of course, budget. Because there are so many great intranet 'Ready to use' products available, it does seem wise to buy unless you have very specific requirements. Products such as SharePoint or Confluence offer intranet, document management and workflow systems with out-of-the-box functionality that you can quickly deploy and set up. Other reputable systems include Huddle and Slack.
    Key considerations when making your decision include hosting and usability. Will you be hosting the intranet internally or on the cloud? Are you geared up for remote access over a VPN type connection or is the cloud better.

    The standard functionality of any intranet includes integration with email and calendars, the ability to collaborate on documents and pages, company communications, How-To articles, People search or 'Who-is directory'. It should offer remote access, be secure and provide a user-friendly environment, even for non-technical users.

    Less frequently required features include blogs, company workflow and integration with other in-house systems or programs. Some users might also require remote access from mobile devices.
    Before deciding which way forward, you should also establish who is going to be maintaining the intranet. It should have a dedicated editor or curator that can ensure accuracy and keep pages up-to-date and relevant with easy-to-use page creation, widgets, notifications and comments. If users become swamped with old, out-of-date information that cannot be relied on for accuracy, your team will very quickly abandon the intranet and it will become useless. Before looking at any of the products available, the team should be considered. Who will be editing, who will be contributing. How much technical expertise do they have? Start with the team, not the technology.

    If building a bespoke product is the only way you will get the full control offunctionality and the integration that you require or meet any other specific needs, you should still consider the team first, and then other key factors like time scales and budget. Should you require bespoke intranet software, Synetec can advise, build and integrate your intranet to ensure you end up meeting all your business needs. Alternatively, you might simply require advice on software selection and set-up which they will be happy to offer.

    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

    Tuesday, 10 May 2016

    Offshore Outsourcing



    Choosing your IT partner is the business equivalent of choosing a spouse- you're hoping for a happy, long-standing relationship or perhaps like choosing a builder for an extension or renovation- an offering that can work with your style, needs and budget and most importantly, a contact that you have a rapport with. These kinds of relations assist in communications which are key to any IT project- be it enterprise scale or start-up. Considering that communication will be the single most important factor in success, it goes to show that choosing an off-shore provider, sourced through a trade directory, with project managers that you will never meet face-to-face, can be likened to choosing a mail-order bride. Risky at best.

    There are key aspects that should be explored and considered when it comes to choosing the right company to supply you with IT services. It should be a 'partnership', not a 'contract', and you should aim for a long-standing relationship that will provide your company with what you need, when you need it, within the time and budget constraints of your organisation. You might not always know exactly what those needs will be at the outset... often this becomes apparent and is demonstrated only further down the road.

    If you are considering offshore IT resources, consider why people are uncomfortable with the idea that their personal information is stored in another country where there are different cultural attitudes to personal information and different laws.  A lot of countries do not provide secure property laws which make it easy for economic espionage to occur and those with the most sought labour costs are the ones that are still busy developing their political systems and labour laws.

    Offshore outsourcing also relies heavily on documentation needed to comply with certain policies and procedures and to increase the chance of IT projects meeting objectives. This could lead to a lengthy waiting period before you can actually start working and producing what you need to, not to mention the expertise and resource required to complete technical software requirements and specifications. Local software experts tend to specialise in specific industries reducing the need for such extensive specifications and usually offering added value in many areas due to specific, localised industry knowledge.

    Another aspect to consider is time zones. Even though the offshore company you are busy forging a relationship with might not be a whole day ahead of you, even a few hours can make a difference. Say you request a task for completion at 8am in the morning and the country of your outsourcing is 2 hours behind, it will be 10am before they receive the request. They might only complete the task by the end of their day, which is already 2 hours after you might have left, making it a whole day of waiting on a simple task. Had you asked a local company, they could have received and completed the task within the day. Doesn't sound so bad waiting 1 extra night on 1 task, but multiply this by the number of tasks and queries on a complex IT project that runs for 6-8 months and what you end up with is basically just a waiting game.

    It is true that cost reduction plays an important part in the decision to choose offshore outsourcing as an option. Most offshore companies usually offer competitive labour rates that can be very appealing, but most businesses that choose this option rarely ever look at the fine print or the hidden costs behind it. These costs are usually not calculated into the overall budget and should be analysed carefully. There are things like costs for long distance communication, training, and travelling. Any long distance relationship requires a large amount of effort, money, and time and it can become taxing on your everyday work situation.

    More often than not these relationships are not always maintained. It's breakdown is so fast and severe that it can cause major damage to your business. Common causes for these breakdowns include an insufficient number of individuals involved, poorly designed policies, gaps or uncertainties in the contracts, and poor execution of roles between the two parties.

    So the vital question that still remains is the following: is offshore outsourcing something to consider when delivering an IT solution? Evidence shows that it is not something that you should delve into blindly due to the factors that can hinder it. Onshore business will save you costs, time, and money, and the lines of communication will be open and easily accessible for all.


    In short, it is acceptable to outsource certain elements of your IT function, and in certain situations can make sense, but it is better to use local companies in order to save in the long run and ensure seamless integration. Even if your local IT service provider does manage to successfully outsource some of the development to offshore resources, let them do the project managing and technical integration. The cost savings will still be passed on to you as the client. 

    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

    Monday, 11 April 2016

    Permanent Role for a Software Developer



    Synetec is a growing software development firm aimed primarily at the Financial Services sector. We cover most areas of .net software development. In addition we also provide support for new and legacy systems to a number of clients.

    Synetec is expanding and we are looking for a mid-level developer to join us and as a valued member of the team, we will encourage, train and support you in keeping you up to date with the latest technologies.

    Mid-Level Developer
    •         Minimum of 4 years of experience
    •         Experience in the following is essential: Microsoft C# .Net, MVC, Microsoft SQLServer, ASP.net
    •         Experience in the following is beneficial: Microsoft VB .Net, WPF, Windows Services, Test Drive Development
    •         Familiarity with the following software is essential: Visual Studio, Microsoft SQL Server Studio Manager
    •         Permanent position
    •         6 Month probation period
    •         Based in London near London Bridge, Southwark and Waterloo stations
    •         Starting ASAP



    Additional Points:

    We are looking for an enthusiastic, energetic, ‘can do’ type of person that gets along well with others

    All candidates must have UK work experience and the necessary passport or visas to work indefinitely within the UK.

    NO AGENTS PLEASE
    Applicants must register their interest and email through their CV's to careers@synetec.co.uk


    Monday, 1 February 2016

    Permanent Role for a Senior Developer



    Synetec is expanding and we are looking for a senior developer to join and as a valued member of the team, they will encourage, train and support you in keeping you up to date with the latest technologies.

    •         Senior Microsoft Software Developer
    •         Minimum of 8 years of experience
    •         Experience in the following is essential: Microsoft C# .Net, MVC, Microsoft SQL Server, ASP.net, Test Driven Development, Agile, Database Design, Use Case Creation
    •         Experience in the following is beneficial: Microsoft VB .Net, WPF, Windows Services, VBA/Excel Development, Unit Testing
    •         Experience in the Financial Services Industry would be an advantage, but not essential
    •         Familiarity with the following software is essential: Visual Studio, SQL Studio Manager, JIRA
    •         Familiarity with the following software is beneficial: Tortoise, XUnit, TeamCity
    •         Permanent position
    •         6 Month probation period
    •         Based in London, Charing Cross
    •         Starting ASAP

    Additional Points:
    •         The salary for this role is between 50K to 60K depending on experience.
    •         This person should have the ability to lead a team of developers from a technical perspective, and be able to present and communicate clearly and concisely while providing  guidance to other developers in the team
    •         They should demonstrate great problem solving ability
    •         We are looking for an enthusiastic, energetic, ‘can do’ type of person that gets along well with others

    Useful Info:
    Our offices are based in Central London, near Waterloo although will be relocating to larger premises in the area shortly. All candidates must have UK work experience and the necessary passport or visas to work indefinitely within the UK.

    NO AGENTS PLEASE

    Applicants must register their interest and email through their CV's to careers@synetec.co.uk



    Permanent role for a Project Manager




    Synetec is expanding and we are looking for a Project Manager to join and as a valued member of the team, they will encourage, train and support you in keeping you up to date with the latest technologies.


    • Project Manager/Scrum Master/Business Analyst

    • Minimum of 8 years of experience

    • Experience in the following is essential: Agile, Scrum Management, Stakeholder Engagement, Coordinating development teams , Interpreting research to create requirements, Use Case Creation, Business Process analysis and re-engineering, strong reporting skills, organisation of project meetings (retrospectives, daily stand ups and planning meetings), Business case & delivery proposal production, excellent organisational and communication skills, works well under pressure, strong documentation and process skills

    • Experience in the following is beneficial: Waterfall Methodologies, Development Background, Test Function Management, Kanban

    • Experience in the Financial Services Industry would be an advantage, but not essential

    • Familiarity with the following software is essential: JIRA

    • Familiarity with the following software is beneficial: Confluence

    • The following qualifications are beneficial, but not essential: SCRUMMASTER, Prince2 Practitioner

    • Permanent position

    • Based in London, Charing Cross

    • Starting ASAP

    Additional Points:

    • The salary for this role is in line with market rates and dependent on experience

    • We are looking for an extremely well organised person, enthusiastic, energetic, ‘can do’ type of person that gets along well with others

    • A professional manner and presentation is key

    Useful Info:

    Our offices are based in Central London, near Waterloo although will be relocating to larger premises in the area shortly. All candidates must have UK work experience and the necessary passport or visas to work indefinitely within the UK.


    NO AGENTS PLEASE
    Applicants must register their interest and email through their CV's to careers@synetec.co.uk



    Tuesday, 12 January 2016

    Are you making use of your data?

     

    Is your company one of many sitting on Mega size excel spreadsheets, creaking with data, but no time or expertise to sort, report and analyse the mass to make it usable and worthwhile? Data is like gold, while it is in the ground it is worthless. It is when it has been extracted and polished that it becomes very valuable.

    With a surge in rapid software development frameworks and improved data manipulation methodologies, comes the ability for companies to unlock the potential within their data and information about markets, trends, customers, potential customers, productivity and competitors far and wide. However, in order to use this data to tell a meaningful story and for it to affect actions and decisions in line with strategic planning, it needs to be moulded into nuggets of information relevant to the business goals and objectives.

    Synetec had a client that ran most of their operations on a combination of a Back Office System, CRM system and very functional Excel spreadsheets. Across these three technologies they had terabytes of data that they were not realizing any value out of. Through consolidation and interpretation of these data sources,  the resulting data set, very accurately pinpointed ‘sweetspots’ and indicated where there processes and teams were achieving the greatest results. Just as valuable was the ability to identify where things could be improved on and what was the differentiator. This in turn brought about some minor adjustments to their processes, some training in very specific areas for individual team members and over a very modest time period an increase in performance across the board. It was all in the data.

    As well as key business drivers, it appears that employees are better motivated when individual efforts and actions can be traced, rewarded and acknowledged, even when functioning as part of a team. Employees can also benefit from USEFUL data. If a certain team member is outperforming his peers, a dynamic report that highlights to management and leads to recognition and reward, would be beneficial to business goals. Or in greater detail, data may show that certain salespeople are stronger or weaker at selling a particular product or in a certain stage of the pipeline. You know software is really unlocking the value of your data when you are being informed on how to enhance processes for improvements and when its based upon YOUR data, then it’s worth listening.
    What good would any of this data be if it's all stuck in a swamp of excel or dispersed amongst various database non-coherently? 

    With a surge in technology that supports the financial industry and decline in the cost of gathering and storing data, the likelihood and reality of sitting on heaps of raw data is growing. The need for high level, almost instant reporting requires new and updated technologies that are not only bullet proof, secure and resilient, but also accessible to the non-technical user.


    Synetec offers bespoke solutions with expertise in designing and managing the transition from legacy systems to updated technologies which can assist you in unlocking the value of your data.  While this process can often be problematic and expensive, Synetec can ensure that your business mines the gold instead of just spending it. 

    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

    Tuesday, 1 December 2015

    Quick Guide to Internet of Things



    The “Internet of things” (IoT) has been a big topic of conversation in the workplace for some time, but considering how it can change how we both live and work, it’s no surprise that it continues to make headlines. Broadband Internet has become more widely available, the cost of connecting is decreasing, more devices are being created with Wi-Fi capabilities and sensors built into them, technology costs are going down, and smart phone penetration is sky-rocketing.  All of these things are creating a “perfect storm” for the IoT. This short article addresses what exactly it is, what impact it will have on you, what development trends are we seeing in this field and what can other areas of software development learn from it.

    What exactly is the IoT?

    The concept in its simplest form is that basically involves connecting any device with an on and off switch to the Internet (and/or to each other). This includes everything from cell phones, coffee makers, washing machines, headphones, lamps, wearable devices and almost anything else you can think of.  This also applies to components of machines, for example a jet engine of an airplane or the drill of an oil rig.  As I mentioned, if it has an on and off switch then chances are it can be a part of the IoT.  The analyst firm Gartner says that by 2020 there will be over 26 billion connected devices…that’s a lot of connections (some even estimate this number to be much higher, over 100 billion).  The IoT is a giant network of connected “things” (which also includes people).  The relationship will be between people-people, people-things, and things-things.

    How does this impact you?

    The new rule for the future is going to be, “anything that can be connected, will be connected.”  But why on earth would you want so many connected devices talking to each other?  There are many examples for what this might look like or what the potential value might be.  Say for example you are on your way to a meeting, your car could have access to your calendar and already know the best route to take, if the traffic is heavy your car might send a text to the other party notifying them that you will be late.  What if your alarm clock wakes up you at 6 am and then notifies your coffee maker to start brewing coffee for you? What if your office equipment knew when it was running low on supplies and automatically re-ordered more?  What if the wearable device you used in the workplace could tell you when and where you were most active and productive and shared that information with other devices that you used while working?

    On a broader scale the IoT can be applied to things like transportation networks “smart cities” which can help us reduce waste and improve efficiency for things such as energy use; this helping us understand and improve how we work and live.  It does sound great, well parts of it do, the main concern is the security threat implication. Will someone be able to hack into your toaster and thereby get access to your entire network?  The IoT also opens up companies all over the world to more security threats.  Then we have the issue of privacy and data sharing.  That is and always will be a hot topic, so one can only imagine how the conversation and concerns will escalate when we are talking about many billions of devices being connected.  Another issue that many companies specifically are going to be faced with is around the massive amounts data that all of these devices are going to produce.  Companies need to figure out a way to store, track, analyse, and make sense of the vast amounts of data that will be generated.

     

    Development Trends

    Let’s start off with a few facts and insights from the Evans Data Corporation Internet of Things Development Study 2015. A third of all IoT developers are primarily focusing on Big Data and analytics projects, with 20.6% primarily focusing on firmware or preloaded software for the client device. Middleware (20%), which is essential for enterprise-wide adoption of IoT strategies, along with backend/server development (17.2%) taken together comprise the majority of development efforts.
    21.7% of all IoT developers surveyed are working on ecommerce-related projects today. Business-to-Consumer (B2C) has a slight edge regarding the number of developers at 11.7% versus those developers working on Business-to-Business (B2B) projects (10%). Developers are also concentrating on supply chain-related projects including logistics (7.4%) and transportation (7%). The following graphic provides a ranking of connected device projects by percent of developers currently working in these areas.
    42% of IoT developers are currently writing software that uses sensors. IoT developers are most often supporting acceleration and vibration sensors while creating new apps, followed by electric/magnetic and flow-based sensor devices. The study makes the point that acceleration or vibration sensors can refer to the sensors that change the orientation of a touch screen based on the way in which the device is held, and can measure the stability of stationary objects or objects with moving parts.
    23% of IoT developers are currently working with or incorporating in-memory databases into their development work, and 44% plan to in the next six months.

    Parting Thoughts

    As everything we do is increasingly connected, so will the levels of available data increase proportionately. That is the key at the end of the day, the data. Keeping it secure, managing it efficiently, all while using it to fulfil an undoubtedly massive potential.




    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

    Monday, 30 November 2015

    Synetec playing golf in support of DEBRA

    Synetec were proud to get involved with one of the DEBRA Charity Golf Days this year. The event was held at the immaculate and prestigious Swinley Forest Golf Club.  

    Most importantly the day raised awareness and funds for the tremendous work and effort that DEBRA puts into helping and supporting the individuals and families affected by Epidermolysis Bullosa (EB). This is a great and worthy cause, so if you can support them in any way then we encourage you to. Click here to learn more about the great work being undertaken by DEBRA.







    The imposing Swinley Forest Club House

    Tuesday, 27 October 2015

    Cyber Security & Learning from TalkTalk


    When we last discussed cyber security the point regarding high profile companies being hacked was a relevant one and now with the latest incident regarding TalkTalk, it has just been hammered home once more. This short article discusses what happened and how we can all learn from it

     

    Short version of what actually happened

    TalkTalk do not know how many of its 4 million customers have been affected by the data breach, but what we do know is that the cyber-attack which took place on Wednesday, 21st of October, affected people’s names, addresses, bank account numbers and sort codes. As TalkTalk put it on their website, these details ‘may have been accessed’. TalkTalk were hacked, the hackers attempted to blackmail them, they refused to pay and reported the breach.

    What can we learn from it?

    If there is only 1 thing to learn from it, it’s that system data must be encrypted. Most systems have debit/credit card details encrypted, but the possibilities to take advantage of other customer data these days is enormous. There is a thriving black market for stolen data, and you don’t even have to go to the Darknet to get it, it’s readily available online.

    The other thing to take way from the TalkTalk incident is to have a proper post-breach response plan, this should include quick distribution of accurate information to the relevant parties (customers and authorities), allowing the proper assistance if required, but also to lessen the impact on your customers and begin the process of rebuilding their trust in your organisation.



    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.

    Wednesday, 30 September 2015

    Software, Data Hacking and Fitness Bands



    So everybody, well almost everybody, is wearing a fitness tracker of some variety. Almost everybody, because I haven’t jumped on that bandwagon yet, but that’s another story. With the ability to develop applications specifically for these devices and for these apps to be available across devices, there is an increasing amount of interest in this topic. This short article outlines some basic capabilities, what you should consider and some posed safety risks which you should know about to prevent your data from being ‘hacked’.

    Part 1: Software Development

    Back in May 2015 Microsoft released a SDK (software development kit) for those who want to create apps for the Microsoft Band fitness tracker. With this SDK developers are able to create applications that can access information from the fitness bands sensors and also allow applications to send notifications from a paired smartphone to the fitness band. This allows developers to create applications that support Windows, access all calorie data recorded and stored in the fitness band and connect to the band from tasks running in the background. The functionality exposed by this SDK includes access to all the fitness bands sensors such as a heart rate monitor, accelerometer and gyroscope. Versions of the SDK are available for each mobile operating system. This in tandem with Microsoft Health (a cloud-based fitness service that offers personalised health related information using data gathered from fitness bands) allows the potential for competition against Apple and Google and there offering.
    Ignoring the individual software vendors and fitness bands themselves the scope is simply immense! Not only are existing fitness apps so much more useful, because let’s face it who wants to input all their calories intake or exercise details into an app when it can be done automatically, but the opportunity to provide focused and extremely relevant informed services to the consumer has never been better. As more and more devices become connected and can share your health related information, the more useful they can become. I will admit I was pretty envious when hearing about the WIFI weight scale that shared information with the fitness band and all that information was shared with an app on the users phone to provide amazing data and reporting. With the ability to develop and deliver apps that can access some of these devices, the potential is exciting.

     

    Part 2: Your health data

    All the data that is recorded by the sensors on your fitness band is available when pairing to the device through the Bluetooth LE protocol, which doesn’t require a password to pair two devices. By using the standard Android SDK you can easily scan for any Bluetooth LE fitness band in the vicinity and attempt to connect to it. In fact the only thing that stops anyone from just connecting to these bands and accessing all the data is if there’s already a phone connected to the device! However, it is also possible to disrupt the connection between a paired phone and a band, giving the software the opportunity to connect instead. So what is the downside of having your band hacked? Not much at this stage, they are still in their relative infancy and only record calorie and exercise related information, but this is also changing and you wouldn’t want your GPS recorded location history available? That could quite easily allow someone to know where you worked, lived, etc.
    No doubt the band manufacturers will address this, but until then it’s possible.



    George Toursoulopoulos is a technology specialist and CEO of Synetec, one of the UK’s leading providers of bespoke software solutions.