Ian Gilmour

Ian Gilmour - IT Consultant

With more than 17 years experience working in dynamic and fast-paced IT roles, I've taken some time to reflect and highlight just a few of the many projects and experiences I've been part of other the years.

What I can help with

Whether it's sorting out everyday IT issues or helping you move to Microsoft 365, I can provide practical, reliable IT support that fit for purpose.

IT Consultancy
Tech Support (Remote / On-site)
Microsoft 365 Setup & Migration
Email & Domain Configuration
Networking, Wi-Fi & Firewalls
Backups & Disaster Recovery
Security Reviews & Hardening
Power BI Reporting
Power Automate & Workflow Automation
Device Setup (Laptops, PCs, Phones)
Diagnostics & Performance Fixes
Data Recovery & Repair Guidance

Selected Projects & Experience

Below is a selection of IT projects and business improvements I've delivered across infrastructure, cloud, data, and digital transformation.

Showing 6 projects. Use search to filter, or click "Show all".

Windows Desktop Upgrades (XP/7/8/10/11)

Delivered multiple desktop refresh and upgrade cycles, from small office upgrades through to multi-country rollouts.

  • International deployments across 6 countries (350+ users)
  • Standardised builds, imaging and rollout process
  • Group Policy baselines and endpoint configuration
  • Intune setup, RMM deployment and device onboarding

Windows Server Support & Modernisation

Managed the full lifecycle of Windows Server estates (2003-2025), including migrations, domain upgrades and infrastructure modernisation.

  • Legacy AD and GPO improvements, including hybrid readiness
  • Hyper-V implementation and later Azure integrations
  • Security hardening, patch management and resilience
  • Core roles: DNS, DHCP, file/print, remote access

On-Premise to Azure Migration

Led the end-to-end migration of 50 on-premise servers to Microsoft Azure, covering application, file and database workloads.

  • Discovery, assessment and right-sizing for cloud efficiency
  • Phased migration plan using Azure Migrate and ASR
  • Testing-led approach with minimal downtime cutovers
  • Post-migration optimisation for performance and cost control

Result: improved scalability, resilience and predictable infrastructure costs.

Phone Systems: Avaya to Teams Phone

Migrated a multinational Avaya phone system (UK, USA, Spain, Germany) to Microsoft Teams Phone, consolidating legacy infrastructure into a modern cloud platform.

  • Planning, rollout and user adoption support
  • Number porting and Direct Routing configuration
  • Regional stakeholder coordination and compliance checks
  • Quality of Service focus to minimise disruption

Result: unified communications, simpler management and reduced telephony costs.

Citrix XenApp / XenDesktop Modernisation

Modernised Citrix environments from XenApp 6 to Citrix Virtual Apps and Desktops, improving stability, security and user experience.

  • Infrastructure upgrades and image management
  • Profile optimisation (including FSLogix)
  • Multi-site load balancing and capacity planning
  • Secure access with AD integration and MFA

Global CRM Deployment: Dynamics to Salesforce

Delivered a global migration from Microsoft Dynamics to Salesforce across six regions (UK, Italy, USA, Spain, Germany, France).

  • Stakeholder alignment and change management
  • Data mapping, cleansing and migration governance
  • Custom objects, workflows and API integrations
  • GDPR compliance, multi-language support and training

Result: improved sales processes, adoption and reporting across regions.

HR & Payroll System Migration

Migrated legacy HR and payroll systems to a modern HRIS platform, streamlining operations across the UK and USA.

  • Requirements capture, data cleansing and secure migration
  • Employee records, pay history and compliance data validation
  • Core HR, payroll, benefits and self-service configuration
  • Region-specific workflows aligned to local regulations

Result: improved accuracy, reporting and employee experience with less admin overhead.

IT Helpdesk Management (Multi-Company)

Ran end-to-end IT support for a group of six companies across multiple countries, delivering consistent service in a complex global structure.

  • Helpdesk operations, triage and escalation processes
  • User provisioning, onboarding/offboarding and access control
  • Application and infrastructure support across time zones
  • Service delivery improvements and stakeholder comms

Analytics Modernisation: Crystal Reports to Power BI

Replaced legacy Crystal Reports with Power BI, turning static reporting into interactive dashboards and self-service insights.

  • Redesigned KPIs with stakeholders and leadership teams
  • Streamlined data sources and built secure data models
  • Automated refresh schedules and improved reliability
  • Performance optimisation across large datasets

Result: faster insights and reduced dependency on static report generation.

Enterprise Data Warehouse

Designed and implemented a centralised data warehouse integrating three ERP systems, multiple CRMs, production systems and SharePoint.

  • Data modelling, schema unification and governance
  • ETL pipelines for reliable ingestion and transformation
  • Cross-functional reporting foundation for analytics
  • Tools used: SQL Server, ADF, Synapse, Fabric and Power BI

SharePoint & OneDrive: File Server Replacement

Delivered a full rollout of SharePoint and OneDrive to replace legacy on-prem file servers and modernise document management.

  • Migrated structured and unstructured data safely
  • Governance, access controls and retention policies
  • Team sites and communication hubs for collaboration
  • SharePoint Lists to digitise manual tracking processes

PowerApps & Frontline Tablet Deployment

Rolled out Intune-managed Android devices and PowerApps to digitise paper-based workflows in manufacturing.

  • Intune compliance policies and secure device management
  • Over-the-air deployment of apps and configurations
  • PowerApps for maintenance logs, incidents and stock tracking
  • Improved data accuracy and real-time visibility on the shop floor

IT Leadership: Digital Transformation

Directed a two-year transformation programme focused on reducing paper usage and modernising business processes.

  • Implemented digital workflows, e-signatures and collaboration tools
  • Drove adoption across departments and improved process consistency
  • Aligned IT delivery to wider business goals and sustainability

Result: reduced printing from 43,000 to 10,000 sheets and delivered measurable cost savings.

Spend Management System (Multi-Entity)

Implemented a unified spend management platform across five legal entities to streamline procurement and expenses.

  • Configured each entity's structure while keeping central oversight
  • Approval workflows, policy controls and compliance improvements
  • ERP integrations for reporting and reconciliation
  • Reduced manual receipt processing and improved audit readiness

Smart Manufacturing Solutions (Industry 4.0)

Delivered practical digital tools to reduce errors, improve traceability and increase real-time production visibility.

  • Box label printing integrated with production data
  • Machine monitoring and planning (status, downtime, capacity)
  • Zero-cost pallet tracking system
  • Automated delayed order tracking and escalation

Result: improved oversight, reduced manual effort and strengthened traceability.

ERP Upgrades & Migrations (SYSPRO / Sage)

Supported and delivered ERP upgrades and migrations, working closely with finance and operations to minimise disruption.

  • Major version upgrades, database migrations and environment redesign
  • Vendor coordination and release planning
  • UAT planning, support and data integrity checks
  • Performance and usability improvements for day-to-day operations

Result: smoother financial processing, better reporting and improved reliability.

IT Budgeting & Cost Reduction

Owned annual budgeting and lifecycle planning, aligning spend to business priorities while improving value-for-money.

  • Forecasting across infrastructure, software and support
  • Hardware lifecycle: procurement, deployment, refresh and disposal
  • Supplier management to control cost and improve outcomes
  • Security and compliance maintained throughout change

E-Marketing Platforms & Salesforce Integration

Managed Spotler and Mailchimp, integrating both with Salesforce to improve segmentation, tracking and automation.

  • Automated email workflows and lead nurturing journeys
  • Campaign tracking, reporting and engagement monitoring
  • Contact segmentation and data quality improvements
  • GDPR-compliant list management and governance

Result: improved campaign visibility, ROI and sales/marketing alignment.

Cyber Essentials / Cyber Essentials Plus

Implemented and maintained Cyber Essentials controls to strengthen security posture and improve compliance.

  • Secure configuration baselines and patching discipline
  • Access control improvements and least-privilege review
  • Malware protection, endpoint standards and monitoring
  • Evidence gathering and audit readiness support

Firewall Upgrade & Standardisation

Delivered firewall upgrades and configuration standardisation to improve security, visibility and manageability across sites.

  • Standard rule sets, segmentation and documentation
  • Remote access improvements and secure connectivity
  • Logging/monitoring improvements and change control
  • Reduced configuration drift across locations

Result: stronger perimeter security and simpler ongoing management.

IT Management (Capabilities)

As an IT manager supporting multiple businesses, I've led and contributed across the full range of core IT functions.

  • IAM: Active Directory, MFA, role-based access across platforms
  • ITSM: service workflows and improvements using tools such as Zendesk
  • BC/DR: planning, implementation and testing for operational resilience
  • Networking: Wi-Fi and network redesign for security and performance
  • Automation: PowerShell, Logic Apps and workflows to reduce manual effort
  • Asset & licensing: software compliance, audits, renewals and optimisation
  • Vendors: contract management and supplier performance