Sr. Web Developer and DBA
I have over 18 years of experience writing software & administering databases. I generally use PHP for web development & C# / VB.NET for Windows development. For the web, I prefer to use an MVC pattern as provided by a good framework such as CakePHP or Yii, but can also work with older PHP applications. I design & maintain databases in MySQL, PostgreSQL, & SQL Server. I'm especially good at writing functions & views for databases.
I started as a PHP developer using the CakePHP 2 framework; this is where I first learned the MVC pattern, where manipulating, presenting, & controlling data is abstracted out. I then added SASS, to make CSS easier to write & maintain. Thinking of mobile devices, I adopted the skelJS responsive framework. I can use bootstrap but prefer the lighter skelJS. Next up was Yii 2; a framework that supports the use of Smarty for view templates. This is attractive because writing PHP within HTML stinks. I have since been using Smarty in CakePHP as well. I am now using CakePHP 3, which provides better overall functionality & a better ORM. I have also worked on straight PHP projects that do not utilize any framework.
As a Microsoft Developer, I have written some Silverlight applications for use in the web browser. I have also written a few web services using WCF. These were written in C# / VB.NET. Some were RESTful, using JSON for communication; others utilized SOAP, using XML.
I started life after college (1998) as a Microsoft Visual C++ developer with some VB 6.0. In that role, I developed applications for law enforcement, 911 centers, jails, retail businesses, nursing homes, & trucking companies. I then moved into the .NET Framework in 2001. I set out to learn C# & have since developed many object-oriented & tiered client/server applications. These include applications for GIS mapping systems & some data mining & sharing initiatives. I have created custom TCP/UDP servers & clients for low-bandwidth mobile applications. I have worked with O/R mappers such as LLBLGen Pro & am accustomed to using entities in data layers rather than reading/writing data directly. I prefer to work with applications that follow an n-Tier architecture along with object-oriented concepts such as inheritance & abstraction. I have vast experience using C++ & the Microsoft Foundation Classes along with the Win32 API. Other languages/frameworks include LINQ, Regular Expressions, & VB 6.0.
My first database was Microsoft Access 95 (yes, I know). From there, I moved into SQL Server 7.0, where I designed & maintained many databases. Database concepts such as normalization/denormalization, primary/foreign keys, & check/default contraints 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, & views. File organization & usage, backup & maintenance, & database efficiency are also strengths. I currently primarily use MySQL 5+, where available & PostgreSQL 9+ where it is not. Other databases include SQLite & Oracle.
I have used a number of servers for hosting my web applications. I prefer either Ubuntu or CentOS running nginx & 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, & SourceSafe. Git really is the best choice here but mercurial comes in at a close second.
During the past 18 years, I have created & maintained custom line-of-business Windows applications, with a focus now more 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, & long-term engagements lasting a year or more.
Records Management/Business Applications
Back-end Work (business, data layer, facade)
Windows Forms Applications
Integration of Systems
CakePHP 2 & 3
SQL Management Studio
Open Office/Libre Office
Mac OS X