Ross Smith II 310 985 9642 resume@smithii.com Professional Summary Over 12 years as a Senior LAMP/PHP developer, creating full-stack, scalable solutions, primarily using Zend Framework/Zend Server on Linux-based systems. Highly proficient in all aspects of development including system architecture and design, schema design, coding and code profiling, query optimization, unit and functional testing, technical/end-user documentation, etc. Strong leadership and communication skills. Published author. Open Source advocate. Serial optimist. Experience Guthy-Renker, Santa Monica, CA 8/2009 – Present Senior Developer Developed many of the components of the Order Gateway System, a Zend Framework based RESTful web service. Primarily responsible for the most critical component, the Order Validator. Authored full unit tests using PHPUnit and Mockery. Developed numerous QA regression tests using PHP and Ruby. Improved daily performance of internal Zend Framework based application by over 90% (24+ hours to under 2 hours), via query optimization, and code profiling. Developed multi-site shopping cart validation RESTful web service to significantly improve checkout conversion rates. Authored AJAX interface using Dojo. Migrated Club Catalog site from proactiv.com to canada.proactiv.com, adding lightbox pages using Dojo/AJAX. Authored detailed developer/user documentation using DocBook, producing ePub, PDF, and HTML5 formats. Created fully automated deployment scripts (to VM, or cloud) using bash. Technologies include AJAX, Apache, bash, DocBook, Doctrine, Dojo, git, jQuery, Mockery, MySQL, Perl, PHP, PHPUnit, Redis, Redmine, REST, Ruby, Subversion, Symfony, VMware, Watir, Zend Framework, Zend Server, Zend Studio, in a RedHat GNU/Linux environment. Switch Games, New York, NY 7/2009 – 8/2009 Senior Developer (Contract) Replaced existing database layer with ADOdb. Improved performance by up to 90% by rewriting over 30 of the slowest queries. Provided complete unit tests for all reworked queries. Technologies include AJAX, Apache, ExtJS, JavaScript, MySQL, PHP, Subversion in a RedHat GNU/Linux environment. Fotochatter, Venice, CA 5/2007 – 7/2009 Chief Software Architect (Equity) Responsible for all aspects of development of fotochatter.com and mobile site wap.fotochatter.com. Managed team of 5 on-site developers, and one off-site system administrator. Responsible for migrating legacy code to Zend platform. Migrated over 200 SQL queries to stored procedures, to produce 90% speed improvement in many cases. Added RESTful interface to stored procedures, tables, and select PHP classes. Added session and query caching using Memcache. Added support for MySQL master/slave servers. Technologies included AJAX, Apache, JavaScript, jQuery, MySQL, Perforce, Perl, PHP, REST, Ruby, SOAP, Watir, Zend Framework in a Debian GNU/Linux environment. Sony Connect, Los Angeles, CA 3/2004 – 5/2007 Developer Assisted in launching connect.com. Maintained and enhanced several Java/Tomcat based applications. Developed internal website for ad hoc reporting requirements in PHP. Created numerous Ruby/bash scripts to QA and automate vital processes. Authored internal documentation using DocBook. Enhanced MySQL performance by over 90% by optimizing SQL queries. Migrated data from MySQL to Oracle 9i. Various system administration duties. Tools included Apache, CVS, Cygwin, Java, JavaScript, MySQL, Oracle, Perforce, Perl, PHP, Python, Ruby, Tomcat, XHTML in RedHat/Windows XP/2000 environments. modifi.com, Santa Monica, CA 10/2003 – 3/2004 Lead Developer (Contract)  Lead Developer for modifi.com to enhance their AccountManager product. Optimized several Perl and PL-SQL scripts to decrease runtimes by up to 90%. Enhanced application to support single-signon across Java and PHP sub-systems. Tools included Apache, CVS, Java, JavaScript, Oracle, Perl, PHP, Tomcat, WebSphere, XHTML in Debian/RedHat/Windows XP environments. Bold New World, Hollywood, CA 7/2002 – 9/2003 Senior Developer (Contract) Developed the Mercury Content Management System in PHP using MySQL. Rolled out ifp.org and colgincellars.com. Tools included Apache, CVS, JavaScript, PHP, MySQL, XHTML in Debian/Solaris/Windows XP/2000 environments. Independent Consultant, Santa Monica, CA 11/2001 – 6/2002 Senior Developer (Contract) Created and enhanced several websites for clients, including seedcuisine.com, and walford.com. Enhanced online order form PHP/Perl script to provide real-time credit card authorization via authorize.net. Tools included Apache, Perl, PHP, MySQL, XHTML in Debian/Windows XP/2000 environments. Intellitech Web Solutions, Playa Del Rey, CA 9/2001 – 11/2001 Senior Developer Developed Perl/MySQL application to optimize search engine placement for clients’ websites. Created parallelizing web crawler achieving 1MB/sec throughout. Architected 30+ table database schema. Some system administration duties. 15k lines of Perl, 2k lines of SQL. Tools included Apache, CVS, HTML, Perl, PHP, MySQL, MS SQL Server in Red Hat/Windows 2000 environments. Uprizer, Inc., Venice, CA 10/2000 – 6/2001 Senior Developer (Equity) Created custom, cross-platform (Windows/Linux), peer-to-peer content replication application in C++/Java. Solely responsible for embedded multi-threaded HTTP web server. Created Java BeanBox application using JINI to provide GUI front end to C++ code. Developed Java/SAX application to parse XML to generate gnuplot graphs. Responsible for Windows 2000/Linux system administration and the creation and maintenance of development related web site. 50k+ lines of C++. 5k lines of Java. Tools included Java, Visual C++ 6, Apache, autoconf/automake, CVS, gcc, gnuplot, HTML, JINI, Perl, PHP, Python, SAX, SQL, wxWindows, XML, XSL in Debian/Red Hat/Windows 2000 environments. iXL, Inc., Los Angeles, CA 3/2000 – 9/2000 Senior Developer (Contract) Led JSP/PHP/Oracle development for an undisclosed client. Led PHP/Oracle development for mountaindew.com. Assisted in completing development of esalon.com. Tools included Apache, BroadVision, CVS, Java, JSP (JavaServer Pages), Server & Client Side JavaScript, Oracle 8i EE, Perl, PHP in Solaris/Windows NT/2000 environments. eToys, Inc., Santa Monica, CA 11/1999 – 3/2000 Senior Developer (Contract) Responsible for programming and system support for internal order fulfillment website. Improved performance of several of the most commonly used functions by over 90%. Migrated entire code base (40,000+ lines) from CGI to Apache/mod_perl for a ten-fold speed improvement. Developed automated testing procedures to speed code migration. Streamlined code by modularizing commonly used functions to prepare for mod perl/Oracle 8 migrations. Created several analysis tools to diagnose and correct performance bottlenecks. Optimized SQL statements to improve performance by up to 90%. Implemented standard HTML layout, to provide visual consistency, and to ease training and support costs. Developed Perl scripts to automate migration of data from MySQL to Oracle 8i. Reviewed code to achieve Y2K compliance. Maintained CVS repository for a four-person development team. Tools included Apache, CVS, JavaScript, mod_perl, MySQL, Oracle 8i EE, and Perl. Perl packages included CGI, DBD::MySQL, DBD::Oracle, DBI, LWP, Net::FTP, & others. Lakeshore Learning Company, Carson, CA 7/1999 – 11/1999 Senior Developer (Contract) Rewrote and enhanced major portions of Lakeshore’s e-commerce site, toystogrowon.com, to improve performance, eliminate bugs, and streamline user interface. Coding in Perl/CGI using DBI and DBD::Solid, as well as some SQL and HTML. Installed and maintained SourceSafe repository. YogaShala, Santa Monica, CA 6/1999 – 7/2000 Senior Developer (Contract) Developed Delphi/Access/MS SQL Server 7 application (yogamala.com) to manage class attendance and accounting. Used Microsoft ADO 2.6 to allow client to transparently migrate from Access to MS SQL 7 when needed. System contains over 70 tables and 35,000+ lines of Object Pascal. The Longbrook Company, Venice, CA 1/1999 – 6/1999 Senior Developer (Contract) Created secure online order form (walford.com/ordering.htm) using Perl/CGI. Migrated script from Unix to NT due to client switching content provider. Developed interactive content using Perl and DreamWeaver EGK Systems, Pasadena, CA 11/1997 – 7/1999 Senior Developer (Contract) Developed the Delphi/SQL/C++ application, BICAOffice, to provide contractors an automated way to create and track California Preliminary Notices. Developed interface to remote Sybase SQL Server 11.5 database via HTTP/ISAPI interface to increase performance fivefold. Developed custom email client using SMTP/POP3 protocols. Over 80k lines of Delphi, 2k lines of SQL, 5k lines of C++. Yoga Works, Inc., Santa Monica, CA 1/1997 – 10/1997 Senior Developer (Contract) Created the Studio Management System, a Delphi program to track student enrollments, store orders and payments. Transparently scaled up from using local Paradox tables to a Sybase SQL database without significant coding changes. Developed conversion utility to migrate data from existing Paradox program. 30k lines of Delphi, 5k lines of SQL, 5k lines of PAL. Charles Schwab & Co., Inc., San Francisco, CA 7/1995 – 11/1996 Senior Developer (Contract) Project: Mutual Fund Billing System (2/1996 – 11/1996). Rewrote Paradox for Windows system to track billing of over 300 mutual fund companies. Reduced processing time from over two hours per day to less than 30 minutes per month. 20k lines of PAL Created system documentation as a 1MB+ Windows help file. Project: CallPoll System (2/1996 – 3/1996). Rewrote Paradox for Windows/Procomm for Windows application to download data from fifty Rolm phone switches and produce numerous detail and summary reports. Project: Employee Stock Purchase Accounting (7/1995 – 2/1996). Enhanced Paradox for Windows application to handle stock splits and add multi-user functionality. Reduced storage requirements and improved daily performance by over eightfold. North American Mortgage Company, Santa Rosa, CA 2/1995 – 6/1995 Senior Developer (Contract) Created GLAUS, a Paradox for Windows application to download accounting data from the AS/400 daily and distribute throughout company. Created and enhanced numerous other in-house Paradox for Windows and Paradox for DOS programs. 5k lines of PAL. Morgan Stanley, San Francisco, CA/New York, NY 11/1992 – 2/1995 Senior Developer (Contract) Created the investment related Partnership Accounting System. Reduced processing time from 2 to 3 days to 10 minutes per accounting period. 20k lines of PAL. 2k lines of SQL. Bank of America, San Francisco, CA 9/1992 – 10/1993 Senior Developer (Contract) Developed the Bankwide Credit Training System, to track training information for credit officers worldwide. Produced over 100 different reports using custom designed report generator. 40k lines of PAL. Lillick & Charles, San Francisco, CA 8/1988 – 11/1995 Senior Developer (Contract) Wrote the Previous Case Search System to identify potential conflicts of interest for upcoming matters. Used complex search algorithm to allow wildcard and inexact searches. 30k lines of PAL. Attest Systems, Novato, CA 11/1992 – 8/1995 Senior Developer (Contract) Created the Companywide Software Audit System (GASP)., to track software and hardware statistics for auditing purposes. C/Assembler module gathers data, Paradox system handles consolidation and reporting. 25k lines of PAL, 10k lines of C/Assembler. Marketel International, Inc., San Francisco, CA 11/1992 – 6/1993 Senior Developer (Equity) Developed a multi-user Paradox application, Airline Seat Auction System, to provide real-time auctioning system for airline seats. System automatically generated and sent confirmations via network fax server using PostScript software interpreter. This system was the inspiration for priceline.com. Books Published LaserJet 4 Typography – Random House/Hewlett Packard Press 1993 Learning PostScript: A Visual Approach – Addison Wesley/Peachpit Press 1990 Open Source Projects aria2 – Command line download utility, supports metalink files, written in C++. Responsible for Win32 port (via MinGW). attr – Win32 utility to set/get file attributes, written in C. Authored. cherokee – Windows service integration, written in C. Authored. cppunit – Cygwin maintainer, written in C. email – Cygwin maintainer, written in C. eolfix – Cross-platform, command line end-of-line correction utility, written in C. Authored. freebeer – PHP class library with full PHPUnit tests. Authored. regdelta – Win32 command line registry differential tool, written in C++. Authored. res_set – Win32 command line screen resolution utility, written in C. Authored. tikiwiki – Improved third-party code integration, improved page load times, by reducing query count, written in PHP. Technical Skills Languages: C, C++, Delphi (Object Pascal), Java, JavaScript, MySQL Stored Procedures, Perl, PHP, PL/SQL (Oracle), PostScript, Python, Ruby, Transact SQL (MS SQL Server), Visual Basic, VBA, Visual C++, x86 Assembler Libraries and Tools: autoconf, automake, COM, CVS, DCOM, gcc, gdb, InstallShield, Java Servlets, JINI, JSP, make, MFC, Multithreading, NSIS, Perforce, Prototype, SAX, SourceSafe, Standard Template Library (STL), Subversion Web Development: AJAX, Apache, CGI, CSS, DHTML, DreamWeaver, HTML, HTTP, IIS, ISAPI, Java, JavaScript, mod_perl, mod_ssl, Photoshop, POP3, REST, SMTP, SOAP, SSL, TCP, UDP, WAP, Watir, XHTML, XML, XSL JavaScript Frameworks: Dojo, jQuery, script.aculo.us PHP Frameworks: Doctrine, Horde, PEAR,. Symfony, Zend Framework Databases and Tools: Microsoft SQL Server, MySQL, MySQL Workbench, Oracle, Solid, Sybase, Interbase, Paradox, ADO, RDO, ERwin System Administration: Apache, bash/csh/tsch/DOS shell scripting, Cygwin, cron, DNS, DHCP, FTP, IIS, iptables, Kerberos, NFS, NIS, NTP, OpenVPN, Postfix, PPP, PPTP, Samba, SSH, tHTTPd, VNC, X Operating Systems: Debian/Mandrake/RedHat GNU/Linux, Windows, Novell Netware, Solaris References Available on request.