Neal Barnett, Developer in Los Gatos, United States
Neal is available for hire
Hire Neal

Neal Barnett

Verified Expert  in Engineering

Software Developer

Location
Los Gatos, United States
Toptal Member Since
May 15, 2019

Neal is a senior consultant, database expert, and technical project manager (PMP-certified) who brings a wealth of knowledge and over two decades of experience to the table. He is well-versed in agile, website, and SaaS application development, Cloud, DBA, and other technical aspects. Neal has acted as a CIO at startup companies and touched every IT infrastructure aspect.

Portfolio

GlobalScape
SQL Server 2016, Query Plan, Amazon S3 (AWS S3), Microsoft SQL Server, Looker...
Fort Systems
IT Management, IT Project Management, Google Cloud Platform (GCP)...
Sign-On Systems
SQL, WordPress, PHP, CSS, JavaScript, HTML, Agile, Agile Project Management...

Experience

Availability

Part-time

Preferred Environment

Amazon Web Services (AWS), Azure, Linux, Windows, Google Cloud Platform (GCP), CIO, Web Development, WordPress, SQL, Integration Testing, Looker, SQL Server Reporting Services (SSRS), APIs, API Integration, REST APIs, Artificial Intelligence (AI), Data Architecture, BPM, Migration, Beautiful Soup, UI Design, Software Development, Vue, Security, cPanel, Git, OAuth 2, Full-stack Development, Architecture, Data Engineering, Query Optimization, English, ETL, Data Migration

The most amazing...

...database project I've worked on was the one that enabled legal wine shipping throughout the US.

Work Experience

Database Architect and Developer

2019 - PRESENT
GlobalScape
  • Updated and optimized an intelligent file transfer application with a SQL database back end.
  • Used various tools and techniques to make routines run more quickly and efficiently.
  • Created reporting tables to increase reports by up to 80%.
  • Scripted nightly tasks to summarize the daily information for a quicker output.
Technologies: SQL Server 2016, Query Plan, Amazon S3 (AWS S3), Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL DML, Data Queries, SQL Performance, Performance Tuning, Data Modeling, Data-driven Design, Data Architecture, Database Modeling, NoSQL, Security, Architecture, Data Engineering, Query Optimization, ETL, Data Migration

CIO

2016 - PRESENT
Fort Systems
  • Oversaw company security, including firewalls, WAFs, and external firms.
  • Handled IT infrastructure, both internal and cloud.
  • Interfaced with vendors, resources, developers, and internal staff.
  • Managed IT and infrastructure projects for the entire company.
Technologies: IT Management, IT Project Management, Google Cloud Platform (GCP), Amazon Web Services (AWS), Heroku, BPM, Security

Consultant

2015 - PRESENT
Sign-On Systems
  • Worked on a number of website projects, mainly using WordPress, PHP, and MySQL. Managed several PMP-certified developers using Agile methods.
  • Handled database consulting projects using my DBA and SQL development skills.
  • Oversaw eCommerce and SaaS application launches with various companies.
  • Used web scraping to scrape websites for data from both static and dynamic web pages. Ported the scraped data to SQL Server for analysis and reporting.
Technologies: SQL, WordPress, PHP, CSS, JavaScript, HTML, Agile, Agile Project Management, Flutter, Mobile Back-end, Data Modeling, Data Architecture, Database Modeling, Amazon DynamoDB, BPM, Selenium, Migration, Software Development, Security, cPanel, OAuth 2, Full-stack Development, Architecture, Web Scraping

Database Administrator, Application Developer, Project Manager

2015 - PRESENT
SSI Investment Management
  • Managed and administered multiple SQL Server instances.
  • Managed and updated the company website, including the database back end.
  • Oversaw the development of portfolio management and trading applications.
Technologies: Delphi, .NET, T-SQL (Transact-SQL), SQL Server 2012, Query Plan, SQL Server Integration Services (SSIS), SolarWinds, Unit Testing, Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), Dashboards, SQL DML, Data Queries, SQL Performance, Performance Tuning, JavaScript, BPM, Migration, cPanel, OAuth 2, Full-stack Development, Data Engineering, Query Optimization, ETL, Data Migration

Database Administrator, Website Developer, App Developer

2015 - PRESENT
Preferred Convention Services, Inc.
  • Designed and created the database schema.
  • Oversaw database administration.
  • Developed a web application using .NET.
  • Designed and developed the website.
Technologies: Visual Studio, .NET, SQL Server 2017, Query Plan, SQL Server Integration Services (SSIS), Microsoft SQL Server, Looker, SQL Server Reporting Services (SSRS), T-SQL (Transact-SQL), SQL DML, Data Queries, SQL Performance, Performance Tuning, Migration, Data Engineering, Query Optimization

Senior Database Administrator, Architect, Developer

2008 - PRESENT
FORT Systems
  • Designed and created the database schema.
  • Oversaw the monitoring, upgrades, security, backups, and archiving for the database.
  • Developed the database with a focus on queries, stored procedures, views, and performance optimization.
Technologies: T-SQL (Transact-SQL), SQL, SQL Server 2016, SolarWinds, Architecture, Data Engineering, Query Optimization

Senior SQL Server Developer

2023 - 2024
RanchWorx Global Inc
  • Updated a PHP/Vue application with a number of requested changes. Required database modifications, front-end/UI updates, and internal code changes.
  • Tracked and fixed bugs using online spreadsheets and documents.
  • Oversaw the launch process, moving the site to a separate location and domain.
Technologies: Database Architecture, Microsoft SQL Server, SQL, WordPress, HTML, CSS, JavaScript, GoDaddy, Full-stack Development, Data Engineering, Query Optimization, Data Migration

PostgreSQL Architect and Developer

2019 - 2019
MyFitment
  • Optimized a very large database.
  • Added missing indexes, optimized queries, and suggested schema changes.
  • Improved the platform configuration to allow the database to run more optimally.
Technologies: Heroku, pgAdmin, PostgreSQL, Data Engineering, Query Optimization

Shop Hotel Beds Direct

http://www.shophbd.com
I designed and managed the website's development and handled back-end database modifications, queries, and updates. I worked on the interface with mattress manufacturers and performed maintenance on the site post-launch.

No-code Developers Freelance Platform

https://www.no-codedevelopers.com/
The project consisted of the design and custom development of a website marketplace matching employers with no-code developers. A freelance-specific WordPress theme was used and highly customized to manage all required platform features.

Tableau Reports for TV Audience Analysis

The information was collected from Smart TV users and brought into a SQL database, then matched again with public entertainment databases to analyze viewer behaviors and patterns. Data was modeled and interactive charts were created to display analyses and drill down into specific groupings and characteristics.

Counselors of Real Estate Portal

http://www.cre.org
This website portal is a large organization of property professionals. The client wished to redesign their site and add a number of features. Members must be able to add or edit their profiles, and users must be able to search and filter members. The site needed to be user-friendly and easy to use while keeping the aesthetics and modern look in the forefront.

Python Web Scrape into SQL Server

Scraped both file download links (ZIP files containing CSV files) and standard web pages using Python. Then the script inserts into database tables, formatting data as they are added. Used setup tables to run scripts with parameters.

SQL: Use Report Summary Table if Available

This script tests for the existence of a report summary table and records within the summary table. If they exist, then the summary table is used for all dates it contains within the supplied parameters—which is generally much quicker than querying the data directly from the base tables. Then, any data not contained in the summary table is retrieved from the base tables and UNION'd with the summary data to supply to the report.

Techniques used include testing for table existence, testing for available data, creating minimum and maximum functions inline to test for minimum and maximum dates between two supplied, joining with a view, and UNION multiple queries.

Housing Credit Score Proof of Concept

https://www.exposure.com/
The project aimed to provide a credit score for one's profession/career by analyzing a LinkedIn profile. The output was a score between 0 and 100 and reported back to the user. The system used LinkedIn's API and some web crawling to obtain the necessary data.

ShopVOX Database Project

http://www.shopvox.com
The client needed a database expert for their growing PostgreSQL DB. The goal was to review the current configuration, check for optimization possibilities, and fine-tune for the best performance, including generating a report of findings and performing recommended tasks.

American Cancer Society - ACS Heroes

http://www.acsheroes.org
Helped with the design, setup, and implementation. I handled all technical aspects, as well as project management of other team members, including development and quality assurance. I also oversaw the product launch and post-launch maintenance.

RanchWorx Global - Update PHP-based Application with Various Modifications

http://stw.ranchworx.com
RanchWorx Global had an aging application written in PHP, and multiple modifications were required to bring it up to date. This involves learning and working with the existing PHP application and MySQL database. I also worked with the client to clarify a number of the requests.
2000 - 2001

Master's Degree in Business Administration

University of San Francisco - San Francisco, CA

1980 - 1984

Bachelor's Degree in Statistics and Computer Science

UC Berkeley - Berkeley, CA, USA

SEPTEMBER 2022 - PRESENT

Project Management Professional (PMP)

Project Management Institute (PMI)

FEBRUARY 2019 - PRESENT

Microsoft MCSA

Microsoft

NOVEMBER 1991 - PRESENT

Public Speaking Certification

Dale Carnegie

Libraries/APIs

Beautiful Soup, WooCommerce API, Stripe API, REST APIs, Vue, jQuery

Tools

pgAdmin, Adobe CQ, Tableau, Microsoft Power BI, Jira, Query Plan, Adobe ColdFusion, GitHub, Visual Studio, Looker, Asana, Git, SolarWinds, Microsoft Project

Frameworks

Selenium, Genesis Framework, .NET, Flutter, Laravel, OAuth 2, Ruby on Rails 5, Bootstrap

Languages

Delphi 7, SQL, JavaScript, T-SQL (Transact-SQL), PHP, SQL DML, Python, HTML, CSS, Delphi, HTML5, C#

Paradigms

ETL, Agile, DevOps, Continuous Delivery (CD), Continuous Integration (CI), Agile Project Management, Unit Testing, B2B, Data-driven Design, UI Design

Platforms

Windows, Windows Server, WordPress, Heroku, cPanel, Amazon Web Services (AWS), Google Cloud Platform (GCP), Linux, Azure, WooCommerce

Storage

Microsoft SQL Server, SQL Server 2016, SQL Server 2017, SQL Server 2012, Azure SQL, Databases, PostgreSQL, MySQL, Database Administration (DBA), SQL Server Reporting Services (SSRS), SQL Performance, Database Modeling, SQL Server Integration Services (SSIS), Amazon S3 (AWS S3), NoSQL, Amazon DynamoDB, SQL CLR, Database Architecture

Industry Expertise

Project Management, Healthcare

Other

Performance Optimization, Import/Export, CIO, Machine Learning, Web Scraping, Data Queries, Web Development, Performance Tuning, Data Modeling, Data Architecture, Software Development, Full-stack Development, Architecture, Data Engineering, Query Optimization, English, Data Migration, APIs, Reporting, BI Reporting, Security, Business Administration, International Affairs, Data Analysis, Data Analytics, Statistical Methods, Integration Testing, Dashboards, API Integration, Payment APIs, Plugins, Web Crawlers, Search, SEO Tools, Elementor, Gravity Forms, Shipping Management, Monday.com, Artificial Intelligence (AI), Mobile Back-end, BPM, Migration, IT Management, IT Project Management, Web Project Management, Certified Project Manager, Public Speaking, Computer Science, IT Projects, GoDaddy, Excel to PDF

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring