Through my limited company, I have provided contracting and consulting services to a range of reputable organisations. My extensive experience includes working with companies such as PM Dragonfly, Napster, Hilti, SoundCloud, IKEA, River Island, Mortgage Gym, Haven Holidays, Kingfisher, Secret Escapes, Cancer Research UK, and ACCO Brands.At these organisations, I’ve offered and implemented the following services and solutions:• Programming Languages: SQL / Python / Shell / Bash / Regex / JavaScript / HTML / CSS• CI/CD data pipelines to Extract, Transform, Load (ETL) from various data sources into BigQuery using various services such as Google Cloud Functions (Python Scripting), Airflow, Terraform, APIs, VMs• BigQuery development to create tables from various datasets such as Google Analytics, Google Search Console, Google AdWords, Firebase, Facebook, backend/company data sources and more• Developed many AI and data related Python apps and tools for increasing efficiency, automation and management of data• Heavily involved in automation, event driven job scheduling, data/web architecture administration and governance for future proofing, security, cost keeping and efficiency• Creating and configuring Google Looker Studio and other reports/dashboards based on tables created in BigQuery and other data sources• End-to-end Implementation and configuration of Google Analytics, Google Tag Manager, Google Firebase, Google Optimize and Optimizely• End-to-end Implementation of 3rd party tracking tags/pixels, web analytics and conversion optimisation services; AdWords, Facebook, DoubleClick, other marketing and affiliate pixels, Optimizely, Hotjar and many more• Training staff members on the various tools and technologies

Hired as a key contributor to accelerate the development of the Ocado Smart Platform (OSP), focusing on the data warehouse segment of this long-term project. Collaborated closely with a team of senior data engineers to expedite the migration and data warehouse initiatives:● Discovery and Analysis: Conducted extensive analysis of existing data sources to guide the migration and data warehousing strategy in Google BigQuery.● DBT Model Development: Developed and refined multiple DBT models for areas like refunds, recurring orders, and delivery logistics, integrating tools such as GitLab for effective version control and CI/CD pipeline management.● Data Pipeline Enhancement: Enhanced data pipeline efficiency, ensuring optimal functionality and alignment with the company's analytical needs.● Business Intelligence Expansion: Played a key role in expanding business intelligence, creating new insights through advanced reporting and dashboard development, thereby facilitating improved decision-making and business growth strategies.

• Engaged with a portfolio of ten clients, specialising in Google Analytics migrations, BigQuery operations, and automation initiatives.• Developed a suite of Python tools, including BigQuery remote functions, enhancing the company's data pipeline and analytics capabilities. These tools included:- Audit tools for Google Analytics and Google Tag Manager, streamlining data quality checks and optimisation.- AI related Python scripts to automate tasks- Custom utilities to extract data from Google Analytics and Google Tag Manager APIs, enhancing data access and management.- A robust Twitter data pipeline, enabling efficient social media data analysis and insights extraction.- A token authentication utility, ensuring secure and efficient access to data tools.• Crafted numerous BigQuery SQL stored procedures, enabling advanced data manipulation and extraction.• Utilised GCP's BigQuery to create comprehensive data tables from various datasets.• Configured Google Looker Studio dashboards, providing clients with impactful data visualisation and reporting tools.• Provided team members with various tools and services, boosting operational efficiency and technical acumen.

• Led a substantial data migration project to Google Cloud Platform (GCP).• Converted ETLs to DBT models for data transformation, utilising Apache Airflow for orchestration.• Employed Python and SQL extensively in managing data pipeline tasks.• Set up data testing, anomaly detection, and data reliability framework• CI/CD using tools like GitHub, CloudRun, Docker, and Terraform to streamline code development and maintain version control.• Constructed comprehensive data tables from various datasets using GCP's BigQuery.• Google Cloud Functions and Pub/Sub for efficient data pipeline operations.• Set up and configured Google Looker Studio dashboards to effectively visualise data.• Provided training to team members on diverse tools and technologies, enhancing their technical skills.

• Managed client data projects, providing bespoke data solutions for multiple clients.• Implemented ETL transformations using Dataform, optimising data pipeline efficiency.• Developed a suite of Python scripts for data pipeline and adtech tasks, with many deployed as Google Cloud Functions.• Created custom tools and services using BigQuery for processing YouTube, Google Ads, and DoubleClick data.- Created AI tools using Python to automate day to day agency tasks.• Generated comprehensive data tables from various datasets using Google Cloud Platform's (GCP) BigQuery.• Set up and configured Google Looker Studio dashboards for effective data visualisation and reporting.

• Worked extensively with Google Analytics and BigQuery SQL to enhance data operations and analytics.• Crafted multiple data tables and orchestrated ETL processes for seamless data extraction, transformation, and loading.• Developed PowerBI reports, transforming raw data into actionable insights for stakeholders.• Leverage GCP's BigQuery to generate comprehensive data tables from various data sources.• Provided training and guidance to team members on the usage of various tools and technologies.

• Led significant data migration projects to Google Cloud Platform (GCP), boosting data accessibility and efficiency.• Orchestrated ETL transformations using a combination of Apache Airflow DAGs and Terraform, resulting in streamlined data pipeline processes.• Heavily utilised Python for the creation of robust unit testing and data anomaly detection frameworks, leading to improved data quality and integrity.• Managed CI/CD with tools like GitHub for improved code development and effective version control.• Introduced the use of BigQuery sketches, optimising data operations and transforming how data was used within the organisation. This implementation significantly enhanced data functionality and was publicly recognised in a company blog post.• Generated comprehensive data tables from various datasets using GCP's BigQuery.• Configured Google Data Studio dashboards, enabling effective data visualisation and reporting.• Conducted training sessions for team members on diverse tools and technologies, enhancing their technical skills.

• Managed and optimised, tracking, data pipelines, reports, and dashboards using BigQuery, Google Analytics, Google Tag Manager, and Google Data Studio.• Collaborated with stakeholders to identify key metrics and data requirements.• Ensured data accuracy and consistency across platforms by implementing quality checks and data validation.• Developed custom data pipelines and reports to provide stakeholders with relevant data and insights.• Optimised data visualisations for user engagement and accessibility.• Provided recommendations for data optimisation and automation.• Maintained and improved the performance of the analytics infrastructure.• Kept up to date with industry trends and best practices for data analytics and reporting.

• Managed and optimised Google Tag Manager, Google Analytics, and Optimizely for various websites and digital campaigns.• Collaborated with stakeholders to understand their digital goals and KPIs.• Provided customised reports and dashboards to offer relevant data and insights.• Enabled stakeholders to track and analyse key metrics accurately.• Optimised digital campaigns for conversions and user engagement.• Configured and resolved any technical issues with tag implementation, tracking, and data consistency across platforms.• Analysed data to provide insights for optimising campaigns for conversions and user engagement.• Developed tracking and reporting strategies to monitor and measure the effectiveness of digital marketing campaigns.• Provided recommendations for website and campaign optimisation based on data analysis and insights.• Continuously evaluated and improved website and campaign performance by identifying and implementing best practices and industry trends.• Collaborated with cross-functional teams to execute and measure the success of digital marketing initiatives.

Challenges:• Understanding the performance of CRUK's ad campaigns and tracking user engagement and conversions.• Reconfiguring the tagging platform to efficiently track relevant information and prioritise tagging requests.• Enhancing and implementing tags across CRUK's websites to measure user interactions and campaign performance.• Resolving inconsistencies and mistakes in the tags that were already implemented.• Correcting the data skewing issues in CRUK's analytics account.Key Responsibilities:• Prioritising and reconfiguring the tagging platform to efficiently track relevant information using JIRA, a ticketing system.• Collaborating with stakeholders to understand their KPIs and digital goals and carrying out an audit to highlight the issues with their current process.• Enhancing and implementing nearly 250 tags across CRUK's websites to track user interactions and campaign performance.• Evaluating and removing over 150 obsolete tags that were no longer needed.• Analysing CRUK's data to provide insights into user behaviour and optimize campaigns.Results:• Implemented a simple tracking system to deal with tagging requests efficiently.• Enabled colleagues to work on different tag deployment projects simultaneously due to the reconfiguration of the tagging platform and the ticketing system that we implemented.• Provided CRUK with funnel reports to track the performance of each individual campaign.• Enabled CRUK to view which campaigns were underperforming and optimise their campaigns with relevant data and insights.• Ensured that all data was accurately tracked and sent to CRUK's analytics account and relevant ad platforms.

Challenges:• Handling over 150 incomplete tasks within the ticketing system.• Carrying out technical and on-site SEO work across multiple websites.• Revamping the company's Google Analytics setup and implementing Google Tag Manager across 20 websites.Key Responsibilities:• Collaborating with various stakeholders to prioritise the backlog of tickets and resolving the issues efficiently.• Auditing and enhancing the SEO of four ACCO Brands websites (Kensington, GBC, Nobo, and Rexel).• Advising and collaborating with in-house writers to produce SEO-friendly content.• Implementing Google Tag Manager across 20 websites to track website activity and eCommerce transactions.• Revamping the company's Google Analytics account by establishing filters, goals, and dashboards to provide valuable insights to stakeholders.Results:• Reduced the backlog of unworked tickets from over 150 to 20 within two weeks, resolving many of the IT and website issues that were making the company's day-to-day operations inefficient.• Completed over 500 tickets and ensured that the ticketing system remained up to date.• Achieved an average organic rank growth of 87% across the four ACCO Brands websites.• Provided stakeholders with customised reports and dashboards, enabling them to track how customers were interacting with the company's websites and products.

• Successfully managed and maintained 30+ key accounts as the recognised Google Analytics & Tag Manager (Certified).• Reviewed clients’ strategies implement events, goals, advanced filters, content groupings, reports and dashboards, tracking scripts, data layers, enhanced e-commerce, AdWords dynamic Remarketing, Facebook dynamic ads, regular expression (regex) / custom JavaScript triggers and variables.• Web development centred on WordPress, HTML, CSS, JavaScript, PHP and MySQL, including APIs and custom scripts.• Installation, configuration and management of websites, client and internal web servers, and internal IT network.• Training sessions for staff education and improvement. Producing client friendly documentation and step-by-step guides.

Developed HTML, CSS, JavaScript, PHP and MySQL web campaigns and advised clients on Technical SEO strategies for CMS’s, architecture, web development and usability, whilst consulting and advising on updates and new technologies.

Developed websites using HTML, CSS, JavaScript, C#, Java for Together Mutual Insurance, including configuration and content management within Ektron CMS, as well as Windows Server Configuration and implementing website SSL certificate.

Installed hardware and software, maintained/configured servers and workstations and developed websites using HTML 4 & 5, Joomla, WordPress, Drupal, PHP, MySQL, JavaScript, including Search Engine Optimization.

• Provided 1st line support to over 10,000 staff and students, including password resets, active directory, editing, adding and deleting entries.• Diagnosed, resolved and supported issues with different hardware and software.• Deployed new hardware, automated software rollouts/upgrades, backups and retirement of obsolete hardware.

• Installed, repaired and upgraded customers systems and ICT devices including workstations, printers/scanners and wireless devices.• Provided telephone, email and remote assistance support to customers and businesses.