Jay G.

I have over 25 years of experience writing software and administering databases. I am a PHP web developer with experience in Laravel, CodeIgniter, CakePHP, core PHP, and some Vue.js. I prefer to use an MVC pattern as provided by a good framework such as Laravel or CakePHP, but can also work with older PHP applications. I design and maintain databases in MySQL, PostgreSQL, and SQL Lite. I started as a PHP developer using the CakePHP 2 framework; this is where I first learned the MVC pattern, where manipulating, presenting, and controlling data is abstracted out. I then added SASS, to make CSS easier to write and maintain. For the user interface, I use bootstrap or the tailwind responsive framework along with jQuery or Vue. For non-Vue applications, I can use Smarty for view templates, but am also well-versed in using Blade, CakePHP, and CodeIgniter templates. I prefer to use Laravel for most projects; it provides better overall functionality than other frameworks and a superb ORM. I have recently started using Vue in projects via an open-source project called Inertia.js. Inertia bridges the gap between Vue and Laravel. This gives the best of both worlds where you get the power of Laravel on the back-end and the modern, sleek feeling of Vue on the front-end where your customers interact with the system. I started life after college (1998) as a Microsoft Visual C++ developer with some Visual Basic. In that role, I developed applications for law enforcement, 911 centers, jails, retail businesses, nursing homes, and trucking companies. I then moved into the .NET Framework in 2001. I set out to learn C# and have since developed many object-oriented and tiered client/server applications. These include applications for GIS mapping systems and some data mining and sharing initiatives. I have created custom TCP/UDP servers and clients for low-bandwidth mobile applications. I have worked with O/R mappers such as LLBLGen Pro and became accustomed to using entities in data layers rather than reading/writing data directly. My first database was Access 95 (yes, I know). From there, I moved into SQL Server 7.0, where I designed and maintained many databases. Database concepts such as normalization/denormalization, primary/foreign keys, and check/default constraints are not new to me. Whether it be T-SQL, PL/SQL, or MySQL, I am proficient with database programmability, such as triggers, procedures, functions, and views. File organization and usage, backup and maintenance, and database efficiency are also strengths. I currently primarily use MySQL, where available and PostgreSQL where it is not. Other databases include SQLite and Oracle. I have used a number of servers for hosting my web applications. I prefer either Ubuntu or CentOS running nginx and php-fpm with MySQL for the database. With the right configuration, this simply offers the best performance. I am proficient in the use of source control systems such as Git, Mercurial, SVN, Vault, and SourceSafe. Git really is the best choice here but Mercurial comes in at a close second. During the past two decades, I have created and maintained custom line-of-business applications, with a focus during the past ten years on web applications. I feel that I can be an added asset to your organization, even if it is only for the short-term. I've done a mix of short projects, several-month projects, and long-term engagements lasting a year or more. Preferences/Specialize In Web Applications/Services Records Management/Business Applications/CRMs Database Design/Administration Back-end Work API Programming Integration of Systems Data Mining/Conversion Programming Languages PHP C# VB.NET C++ Databases MySQL PostgreSQL SQLite SQL Server Oracle Database Access Web CakePHP CodeIgniter Laravel node/npm HTML5 CSS3 Bootstrap Tailwind Smarty Blade SASS JavaScript jQuery Vue.js Inertia.js REST JSON XML Regular Expressions Concepts Model-View-Controller Object-Oriented Programming n-Tier Architecture Service-Oriented Architecture Normalization/De-normalization Primary/Foreign/Unique Keys Check/Default Constraints Database Programmability Tools Visual Studio SQL Management Studio PhpStorm DataGrip LLBLGen Pro VMWare Microsoft Office Libre Office TextMate DbVisualizer Active Reports Crystal Reports Iron Speed CodeOnTime Source Control Git Mercurial SVN SourceSafe SourceGear Vault Web Browsers FireFox Chrome Safari Internet Explorer/Edge Operating Systems/Servers macOS Windows Ubuntu CentOS nginx apache php-fpm Payment Processors WePay PaySimple authorize.net Forte Stripe