Database Architect, Developer
2019 - PRESENTGlobalscape- 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 2016CIO
2016 - PRESENTFORT 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), AWS, HerokuDatabase DBA, Application Developer, Project Manager
2015 - PRESENTSSI Investment Management- Managed and administered multiple SQL Server instances.
- Managed and updated the company website, including the database back end.
- Oversaw the development of the portfolio management, and trading applications.
Technologies: Delphi, .NET, T-SQL, SQL Server 2012Database DBA, Website Developer, App Developer
2015 - PRESENTPreferred 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 2017Senior Database Administrator, Architect, Developer
2008 - PRESENTFORT 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, SQL, SQL Server 2016PostgreSQL Architect, and Developer
2019 - 2019MyFitment- 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
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 start-up companies and has touched every aspect of the IT Infrastructure.
Neal is now available for hire
Portfolio
- GlobalscapeSQL Server 2016
- FORT SystemsIT Management, IT Project Management, Google Cloud Platform (GCP), AWS, Heroku
- SSI Investment ManagementDelphi, .NET, T-SQL, SQL Server 2012
Availability
Part-time
Preferred Environment
Amazon Web Services (AWS), AWS, Azure, Linux, Windows, Google Cloud Platform (GCP), CIO, Web Development, WordPress, SQL
The most amazing...
...database project I've worked on was the one that enabled legal wine shipping throughout the US.
Employment
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, Python, HTML, CSS, Delphi, PHP, C#, JavaScriptTools
Adobe CQ, Tableau, Microsoft Power BI, Jira, SSRS, Adobe ColdFusion, GitHub, Visual Studio, pgAdminPlatforms
Windows Server, WordPress, Joomla, Heroku, Google Cloud Platform (GCP), Linux, Azure, WooCommerce, Windows, Amazon Web Services (AWS)Storage
Azure SQL, PostgreSQL, MySQL, Database Administration (DBA), Microsoft SQL Server, SQL Server 2016, SQL Server 2017, SQL Server 2012, Databases, SQL CLRIndustry Expertise
Project Management, SecurityOther
Performance Optimization, CIO, Machine Learning, Data Queries, APIs, International Affairs, Web Scraping, Data Analysis, Data Analytics, AWS, Reporting, BI Reporting, Import/Export, Business Administration, Web Development, IT Management, IT Project ManagementFrameworks
Genesis Framework, .NET, Ruby on Rails 5Libraries/APIs
WooCommerce API, Stripe API, jQueryParadigms
Agile, DevOps, Continuous Delivery (CD), Continuous Integration (CI)
Education
- Masters's Degree in Business Administration2000 - 2001University of San Francisco - San Francisco, CA
- Bachelor's Degree in Statistics and Computer Science1980 - 1984UC Berkeley - Berkeley, CA
Certifications
- Microsoft MCSAFEBRUARY 2019 - PRESENTMicrosoft
- Public Speaking CertificationNOVEMBER 1991 - PRESENTDale Carnegie
