Database development

I've been working with databases for about 15 years. I've been involved in more or less everything, but here are a few of my specialties:

Data management

I provide access to data for those who need it. The data is secured away from everyone else. Where access is provided, I ensure the format is appropriate and the interface intuitive. I have created tools for rapid searching and ad-hoc updates. I am experienced creating roadmaps to align organisational data to GDPR legislation and implementing the process. In addition, I support the organisation, teams and individuals to make the best use of their data.

SQL Server Integration Services (SSIS)

SQL Server Integration Services is a tool for exchanging data with other machines. I have over 15 years experience in designing and maintaining such systems from version 2005 onwards. Hit me up.

SQL Server Reporting Services (SSRS)

SQL Server Reporting Serices is a tool is for delivering data to users in the form of reports. I'm good at this. I've set up and configured the service on a server FROM SCRATCH. I've had the system prepare packs for clients that are pixel-perfect, presented in PDF format. Table of contents, visualisations, tablix are split sensibly across worksheets etc. Control your jelously and get in touch.

Data insight & analysis

You got some numbers? You want them crunched? I can't work miracles, but I should be able to answer most of your data questions. Did you know... data I prepared appeared in the *FINANCIAL TIMES* Life & Arts travel section. My contribution was uncredited :( Those guys don't mess around when it comes to numbers. They insist on the best and so should you! Hire me.

Microsoft PowerBI

Microsoft PowerBI is an interactive data visualisation tool. It's not quite as good as the marketing would have you believe. However it does integrate well with the other Microsoft products and can do some neat tricks. A good dashboard begins with an understanding of the issues at hand, if you've got a grip on that; then let's go. Hit me up. It is really good for maps IMO.

Documentation

I feel strongly that any solution should be well documented. A good way to identify if those leading a project are interested in the long term sustainability of it is, if the subject of doucmentation is discussed early on. It often isn't and only really makes itself known when when a key person leaves. If this has happened to you, hit me up.