Neal Barnett, Software Developer in Los Gatos, CA, United States
Neal Barnett

Software Developer in Los Gatos, CA, United States

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.
Neal is now available for hire

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)...
  • SSI Investment Management
    Delphi, .NET, T-SQL (Transact-SQL), SQL Server 2012, Query Plan...

Experience

Location

Los Gatos, CA, United States

Availability

Full-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)

The most amazing...

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

Employment

  • Database Architect and Developer

    2019 - PRESENT
    Globalscape
    • Updated, and optimized an intelligent file transfer application with a SQL database back end.
    • Used a variety of 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
  • 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
  • Database Administrator, Application Developer, and 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
  • Database Administrator, Website Developer, and App Developer

    2015 - PRESENT
    Preferred Convention Services, Inc.
    • Designed, and created the database schema.
    • Oversaw the 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
  • Senior Database Administrator, Architect, and 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
  • 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

Experience

  • Python Web Scrape into SQL Server

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

  • 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.

  • Modern Web Scraping With Python and Selenium (Publication)
    Web scraping has been around since the early days of the World Wide Web, but scraping modern sites that heavily rely on new technologies is anything but straightforward. In this article, Toptal Software Developer Neal Barnett demonstrates how you can use Python and Selenium to scrape sites that employ a lot of JavaScript, iframes, and certificates.
  • An Intro to SQL Window Functions (Publication)
    SQL window functions are calculation functions similar to aggregate functions but, unlike normal aggregate functions like "group by," have access to individual rows and can even add some of their attributes into the result set. In this article, Toptal Freelance SQL Developer Neal Barnett explains the benefits of SQL functions, describes when you’d use them, and gives you real examples to help with the concepts.

Skills

  • Languages

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

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

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

    Microsoft SQL Server, Azure SQL, PostgreSQL, MySQL, Database Administration (DBA), SQL Server Reporting Services (SSRS), SQL Performance, SQL Server Integration Services (SSIS), Amazon S3 (AWS S3), SQL Server 2016, SQL Server 2017, SQL Server 2012, Databases, SQL CLR
  • Industry Expertise

    Project Management, Security, Healthcare
  • Other

    Performance Optimization, CIO, Machine Learning, Data Queries, Performance Tuning, APIs, Reporting, International Affairs, Web Scraping, Data Analysis, Data Analytics, Integration Testing, Dashboards, BI Reporting, Import/Export, Business Administration, Web Development, IT Management, IT Project Management, Web Project Management, Certified Project Manager, Public Speaking, Computer Science, Statistical Methods, IT Projects
  • Frameworks

    Genesis Framework, .NET, Ruby on Rails 5
  • Libraries/APIs

    WooCommerce API, Stripe API, jQuery
  • Paradigms

    Agile, DevOps, Continuous Delivery (CD), Continuous Integration (CI), Unit Testing, Agile Project Management

Education

  • Masters's Degree in Business Administration
    2000 - 2001
    University of San Francisco - San Francisco, CA
  • Bachelor's Degree in Statistics and Computer Science
    1980 - 1984
    UC Berkeley - Berkeley, CA, USA

Certifications

  • Project Management Professional (PMP)
    SEPTEMBER 2022 - PRESENT
    Project Management Institute (PMI)
  • Microsoft MCSA
    FEBRUARY 2019 - PRESENT
    Microsoft
  • Public Speaking Certification
    NOVEMBER 1991 - PRESENT
    Dale Carnegie

To view more profiles

Join Toptal
Share it with others