Andy is a highly effective, versatile and motivated IT professional with 20 years' experience as a database and web developer and administrator. Andy also has 10+ years' experience of running small businesses and consultancy to small and medium enterprises. Microsoft stack specialist - SQL Server design, development and tuning, .NET, C#, MVC. Andy is an inveterate problem solver with a no-nonsense pragmatic manner, delivering bespoke solutions to the highest standard whilst minimising impact on the client.

- Andy McAuley, Freelance Technical Consultant.

Full CV available here

CORE SKILLS

• data_usage SQL Server

  v6.5-2017: Design, tuning, administration: security, replication, backup, ETL/ELT , HA, T-SQL, Triggers, Stored Procedures, Indexed Views, SSIS, SSAS

• code Microsoft Stack

  C#, EF6, MVC4, ASP/.NET, VS2017, IIS, Windows Server NT3.51-2016, PowerShell, MSMQ, VB.Net, VBA , Access (v2.0-2013)

• web Web Tech

  JavaScript (Knockout, jQuery, VueJS, ExtJS, Dojo, JSON), HTML5, CSS3 (Bootstrap, Materialize), Bash, VB.Net, VBA, Magento, PHP7.0, XML/XSLT

• cloud Devops

  AWS: EC2, S3, EBS, Cloud Formation, Cloudberry RDS, Octopus deploy, Splunk, Wireshark

• control_point Source Control

  SVN, GIT, TFS, Jira, Trello

• data_usage MI/BI

  Prism, Tableau, PowerBI, Google Datastudio

• computer Linux Stack

  Debian, Ubuntu, Apache2, NginX, MySQL (v5.5-8.0), MariaDB, PhpMyAdmin, Percona, Bash, MongoDB

• money ERP/Finance

  Navision (v4,2009, Dynamics NAV), Sage (500/X3/50), Samtouch/ Samstock

• folder Methodologies

  Scrum, DSDM, SSADM.

• person_outline Soft Skills

  Mentoring, remote working, self-starter, time management