Neal Barnett

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.

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.

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.

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.

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.

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.

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.

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.

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.