John B. Profile

4.9

(5 reviews)

You're now following

Error following user.

This user does not allow users to follow them.

You are already following this user.

Your membership plan only allows 0 follows. Upgrade here.

Successfully unfollowed

Error unfollowing user.

You have successfully recommended

Error recommending user.

Something went wrong. Please refresh the page and try again.

Email successfully verified.

$40 USD / hour

eastbourne,

united kingdom

$40 USD / hour

It's currently 1:21 AM here

Joined May 20, 2015

0 Recommendations

John B.

@JohnBoothby

4.9

(5 reviews)

3.0

100%

$40 USD / hour

eastbourne,

united kingdom

$40 USD / hour

100%

Jobs Completed

44%

On Budget

44%

On Time

N/A

Repeat Hire Rate

Expert in Excel, VBA, Data Analysis and Automation

A analytical professional with outstanding academic pedigree and more than five years of experience working in business analysis and improvement. Author of hundreds of VBA Tools, many working in tandem with complex SQL queries, performing functions as varied as sales forecasting, order calculation and placement, web scraping and automation, complex data analysis and KPI dashboard production. I have worked extensively on a variety of projects and contracts outside of this platform: references and examples of previous work are available on request. All Projects will be quoted on an individual basis.

See all Excel Experts in United Kingdom

Contact John B. about your job

Portfolio

The focus of this project was to produce a professional and pleasing UI, but seamlessly weave in lookup and activex functionality.

Excel Freelancer-Invoice Template

Snips from a presentation to a CEO and CFO on the projected impact of a no-deal Brexit in terms of inbound tarriffs, outbound tariffs, and the risk of delay to production based on significant customs delays.

Analysis involved significant data crunching on key spend categories, sales classifications, and designing a tool to project the impact of delivery failures on a component-by-component basis.

(Sensitive Information has been blacked out)

Brexit Impact Analysis

A simple excel workbook to present raw order information in a specified dashboard format.

Users select what data they wish to see using a simple interface and drop-down boxes.

Running the macro updates the source data from an external database, analyses it against known shipment addresses, and summarises it in a easy-to-use format, that allows quick analysis of direct vs drop-shipments.

Live Sales Dashboard from Raw Data

4786692

Recursive Order Availability Checker for Multi-BOM items

Excel Freelancer-Invoice Template

Brexit Impact Analysis

Live Sales Dashboard from Raw Data

4786692

Recursive Order Availability Checker for Multi-BOM items

Reviews

Changes saved

Showing 1 - 5 out of 5 reviews

Filter reviews by:

5.0

$30.00 USD

Create a unique Excel Invoice Template for freelancers

John is the quite professional freelancer, especially on Excel and VBA. I highly recommend him to hire to be sure your work will finish on time with strong communication. I hired him again cause you can access him easly and can explain what you need.

Tulay V.

@someka2

•

5 years ago

5.0

$30.00 USD

Need an Excel wizard to create automated macro helping me with data update -- 3

Amazing freelancer, no doubts my best experience on Freelancer ever. Excellent communication, fantastic understanding project requirements and delivery within budget and within few hours from starting the project. Would highly recommend, true Excel wizard!!! :)

Visual Basic

Excel

Visual Basic for Apps

Daniel G.

@dangorka

•

5 years ago

4.8

$180.00 USD

War Dragons Breeding Guide

John has been a great delight to work with. I have spent a couple of years trying to complete this project with a little bit of help, here and there, but John truly went above and beyond to complete it. He is a very thorough and dedicated professional that never gave up and spent more time than was necessary to satisfy my needs. I highly recommend him and would be more than pleased to have his help for any future projects.

Data Processing

Excel

Donovan C.

@donovancullum316

•

5 years ago

5.0

$30.00 USD

Help import data into Excel spreadsheet from other spreadsheets

John was a pleasure to work with and had helpful additional suggestions for our Excel needs that we hired him for.

Derek H.

@shshshshs

•

5 years ago

5.0

$50.00 USD

Looking for VBA coder to update an excel sheet and duplicate one

Excellent work . Awesome Personality. Will hire again for sure. Thank you John.

Techweb S.

@techwebsam

•

5 years ago

Experience

Market Leading Manufacturer

Sep 2015 - Present

Working with a broad remit to improve business processes and provide improved analytical support across the business - in the course of my time at Paxton I have authored in excess of 100 VBA macros; designed processes used on daily basis for activities as varied as forecasting, materials purchasing and control, dashboard production and customer experience tracking. I take responsibility for a wide range of analytical reporting functions including quality, OTD and supplier KPIs.

Multi-national Telecommunications Company

Sep 2014 - Aug 2015 (11 months, 1 day)

Continuous Improvement Team-lead. Simplifying reporting and summarising data using excel macros to drive savings, efficiencies and direct team efforts towards high-value accounts.