I'm a Process Automation Engineer working fully remotely. I have ~15 years of experience turning repetitive, manual, error‑prone work into reliable automated systems.

I specialise in SQL, Python, ETL pipelines, and Power BI, helping businesses move from "we do this manually every week" to "this updates itself."

Based in the UK (Belfast), working fully remotely.

An end-to-end ETL pipeline that extracts customer & sales data, validates it, applies data quality checks, and loads it into SQL Server.

• Full ETL flow (extract → transform → load)
• Realistic validation rules and auditing
• Built with SSIS + SQL Server in a clean, portfolio-friendly format
• Demonstrates maintainable, production-style pipelines

My focus is simple: eliminate repetitive work and make data trustworthy.

In practice, that means I:

• Build automated scripts that clean, process, and move data
• Design ETL pipelines so data flows without human intervention
• Create dashboards and reports that refresh themselves
• Integrate AI tools into workflows when they add real value
• Reduce processes that take hours… down to minutes

Most of my work sits at the intersection of SQL, Python, ETL, and Business Intelligence.

A local, Ollama-powered chatbot that speeds up reporting work by explaining metrics, drafting report structures, and answering BI questions. Saves me hours every week.

Tech: Python, Flask, Ollama

A complete SSIS + SQL Server ETL pipeline with quality checks, error handling, and auditing — built to reflect real workflow scenarios.

Tech: SSIS, SQL Server

A collection of dashboards focused on clarity, practical decision‑making, and operational insight.

Tech: Power BI, DAX, SQL

A lightweight Python tool to turn PDF tables into clean CSVs.

Tech: Python

Languages: SQL, Python, C#
Tools: VS Code, Power BI, SSIS, Ollama, Git
Databases: SQL Server (primary)

I'm pragmatic — I use whatever solves the problem efficiently.

• Integrating practical AI/ML into everyday business workflows
• Making ETL processes more resilient to messy real-world data
• Building reusable automation frameworks and templates

I’m open to freelance, contract, and remote opportunities — especially where SQL, automation, or reporting is involved.

• Website: http://www.mrvivian.com
• LinkedIn: https://www.linkedin.com/in/vivianferguson
• GitHub: https://github.com/mrvivian