Adam Taylor

Adam Taylor

Mentor
5.0
(12 reviews)
US$20.00
For every 15 mins
22
Sessions/Jobs
free badge
First 15 mins free for your first session
ABOUT ME
Data & Systems Architect (SQL, SSRS, Access, Excel, VBA, PowerBI, Azure ADF)
Data & Systems Architect (SQL, SSRS, Access, Excel, VBA, PowerBI, Azure ADF)

A UK-based Data Professional, I have over 20 years experience in Excel, Access, SQL and VBA, and have learnt a ton about data, reporting, automation, and how to make the systems I design work smarter to add real business value.

The majority of my career to date has been in:
-Microsoft Office products (Access, Excel, VBA programming)
-Microsoft SQL (databases, stored procedures, SSRS, SSIS, PowerBI, Optimization)
-PowerShell (script creation)
-Data imports/exports
-Azure DevOps, including Azure Data Factory Pipelines, Powershell, Chocolatey and more
-Data Warehouse creation, systems integration
-Creating useful and timely information systems (reports, dashboards) with data from one or multiple sources

I have worked in a number of industries including Automotive Manufacturing, Oil/Gas/Nuclear, Engineering, Food Manufacturing, amongst others, and have extensive experience with MES, ERP and PLM system integration.

I am passionate about what I do, and want to pass on some of the knowledge and expertise that I've acquired over the years. I've only just got started on CodeMentor, but really enjoy working with Clients from around the world to help them make sense of the issue they are trying to troubleshoot.

If you're struggling with an issue in any of the areas I specialise in, you are very welcome to contact me to discuss your issue. Our initial discussion will be completely free of charge, to ascertain whether I can provide the support you need - and if you're happy to proceed, then we'll get started!

If you need something more longer-term or a piece of work completing, we can discuss that, too. I've successfully completed a number of freelancing projects, both large and small, and am willing to negotiate my fee for these projects.

I look forward to working with you! :-)

London (+01:00)
Joined February 2021
EXPERTISE
20 years experience | 2 endorsements
Built my first application within Access in 2003, and continued to grow and develop from there. Over 100 applications written, I general...
Built my first application within Access in 2003, and continued to grow and develop from there. Over 100 applications written, I generally use Access because it's a quick and easy front end for a robust Database application connecting to SQL Server
Relational DatabaseAutomationReport Design
View more
15 years experience | 6 endorsements
From helping with query design in the Access Query Editor, creating Stored Procedures in SQL Server or DBA activities such as Index Optim...
From helping with query design in the Access Query Editor, creating Stored Procedures in SQL Server or DBA activities such as Index Optimization, I've used most sorts of SQL at one time or another over the years and am comfortable with most activities within it.
View more
View more
20 years experience | 3 endorsements
Self-taught in VBA, I started my journey by recording macros in Excel - and learnt to automate. Moved into Access after a couple of year...
Self-taught in VBA, I started my journey by recording macros in Excel - and learnt to automate. Moved into Access after a couple of years, and now regularly create complete systems in it.
ExcelAccess
View more
ExcelAccess
View more
10 years experience
10 years experience
5 years experience
Configuration and modification of Azure Database, set up of new pipelines in ADF
Configuration and modification of Azure Database, set up of new pipelines in ADF
2 years experience
Creation and optimization of multiple ADF Pipelines along with associated datasets and triggers, to handle large, complex automated data...
Creation and optimization of multiple ADF Pipelines along with associated datasets and triggers, to handle large, complex automated data transformation including import and creation of multiple files.

REVIEWS FROM CLIENTS

5.0
(12 reviews)
Keith Thompson
Keith Thompson
November 2021
What a great mentor. My company asked me to start a database for the testing we are doing. Within just a few days, I knew that I was way over my head. Adam in just a few hours had me up and running. His knowledge of access and database work is second to done. I will contnue to us Adam for all my database needs.
James Godesky
James Godesky
July 2021
Did a Zoom with Mr. Taylor and an end of the week response was acceptable. He stayed up late and plowed through my problem and in a short time a result was given. Problem Solved!. Very gratefull!
Nykky Yates
Nykky Yates
April 2021
Adam has been my go to person and has been very helpful solving things I have broken. Highly recommend and I will use him again. Thanks.
Paul Coonrod
Paul Coonrod
April 2021
I highly recommend Adam for future work! He went above and beyond my expectations. He quickly completed the SQL database freelance job, formed creative solutions in Azure Data Factory, while ensuring all of his processes were well-documented. He’s extremely professional, and I’d hide him again in a heartbeat!
Nykky Yates
Nykky Yates
April 2021
Adam has been very helpful in walking me through MS Access database I am creating. In the process I am learning things I did not know were there. He is very knowledgeable and shared other helpful information. Highly Recommend.
Sharon Esdaille
Sharon Esdaille
March 2021
Adam was responsive. He worked quickly. He fully understood what I needed as was able to provide a solution. He also explained what we were doing and why so I would understand. It was a pleasure working with him.
Lauren Kopec
Lauren Kopec
March 2021
Adam was a great help with a complicated VBA issue. He tackled it, worked through it with me, and got it working in the end. Will absolutely work with him again.
Florian Bujupai
Florian Bujupai
March 2021
It was a pleasure to have Adam helping with setting up a VBA code for sorting complex matrices.
Rye Kennedy
Rye Kennedy
March 2021
Adam was great to work with. He got right into my code and helped me work out a few bugs and add some functionality to make the application more robust.
Rye Kennedy
Rye Kennedy
March 2021
Adam was easy to work with and quick to get up to speed on the problems I was having. He helped me work through them and explained why I was having the problems.
SOCIAL PRESENCE
Stack Overflow
258 Reputation
0
3
10
EMPLOYMENTS
Systems Architect
An EV Battery Manufacturing Company
2017-02-01-Present
Designed and implemented business systems including creating a Manufacturing Execution System and Dispatch system (Access front end, SQL ...
Designed and implemented business systems including creating a Manufacturing Execution System and Dispatch system (Access front end, SQL Server back end), with integration into ERP systems, to enable the business to manufacture EV battery modules and full EV Battery packs for motorsport and consumer vehicles.
Microsoft Access
Access vba
T-SQL
View more
Microsoft Access
Access vba
T-SQL
Stored Procedure
SSRS (SQL Server Reporting Services)
Microsoft SQL Server
Office 365
Node-RED
Microsoft Power BI
Microsoft Power Apps
View more