John B. Profile

4,9

(5 anmeldelser)

Du følger nu

Fejl under følg af bruger.

Denne bruger har ikke tilladt andre bruger at følge dem.

Du følger allerede denne bruger.

Din medlemsskabsplan tillader kun at følge 0. Opgrader her.

Du følger nu ikke længere

Kunne ikke stoppe med at følge bruger.

Du har nu anbefalet

Kunne ikke anbefale bruger.

Noget gik galt. Forny venligst siden og prøv igen.

Email verificeret.

$40 USD / time

eastbourne,

united kingdom

$40 USD / time

Det er i øjeblikket 1:16 AM her

Tilmeldt maj 20, 2015

0 Anbefalinger

John B.

@JohnBoothby

4,9

(5 anmeldelser)

3,0

100%

$40 USD / time

eastbourne,

united kingdom

$40 USD / time

100 %

Jobs færdiggjort

44 %

Indenfor budgettet

44 %

Til tiden

N/A

Genansættelsesrate

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.

Se alle Excel Experts i United Kingdom

Kontakt John B. omkring dit job

Log ind for at diskutere detaljerne via chat.

Portfolio-mappe

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

Anmeldelser

Ændringer gemt

Viser 1 - 5 ud af 5 anmeldelser

Filtrer anbefalinger ud fra:

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 år siden

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 år siden

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 år siden

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 år siden

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 år siden

Erfaring

Market Leading Manufacturer

sep. 2015 - Nuværende

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 måneder, 1 dag)

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