[Product IRB 2.0] Vanderbilt hired me to work on the new version of their “Interdepartmental Review Board” (IRB) application, written in Java and Lotus. The new version was written in PHP, and MySql. I sat with the members of the IRB, who are non­technical, and discussed their functional needs. From these conversations I was able to gather technical requirements, and draft a Fundamental Requirements Document (FRD).Architecture of and code migration of "Discover-E" doc archve program; integreate with "REDCap" Data capture application.

Rockbridge initially hired me as a full­time employee. The owner continues to engage me for consulting projects. ● [Product: Customer Upload Web Site]Wrote a Google App Script form to allow clients to upload graphics files to the Rockbridge Google Drive, rather than having to FTP to a dedicated server. This allowed Rockbridge to eliminate a redundant server, and cut cost. This allowed in clients being able more easily submit their artwork, shorter delivery time, and increased revenue.● [Product: Order Tracking System] Rockbridge used to track customer orders on paper order sheets. When a sales rep needed to know the status of a client order, they had to walk through production, and find the physical order form. I visited the production facility, walked through the production line, and spoke to the workers. Understanding this process allowed me to gather technical requirements to automate their production tracking. I wrote an automated system that allowed tracking orders in real time, greatly improving order efficiency.● [Product: e­commerce sites]Rockbridge has many online stores, mostly running Magento ecommerce platform. We discovered these servers were under constant hacker attack. I wrote a program called Remedi8 that monitored bad traffic and blocked it. The result was an immediate reduction in malicious traffic, and no more hacking intrusions.

Product: Site PortalC­Squared had initially interviewed me to work on an asset management program. During the interview, they decided that given my broad skill set, they would rather hire me for their “troubleshooter” role. I was able to finally resolve a large number of longtime technical issues.● [Product, Site Portal 2.0] The Site Portal web application displays alarms across a cell carriers entire network. Some of the queries required for the dashboard took a long time to run, and this had been causing increasingly sluggish GUI performance, resulting in complaints from clients. This issue had been getting worse for two years. I analyzed the structure and implemented several optimizations that greatly improved performance, and noticed that the one table had over 21,000 records in it, but only 120 were required for the join; the rest were historical records. I partitioned the table so that the join only used the relevant 120 records, instead of the full 21,000. This measure alone cut the query time by 75%, and dramatically increased GUI performance, resulting in a better user experience, and continued successful end­user adoption● C­Squared had an image for a development VM that ran on their rack­system infrastructure. I modified the VM so that it would run on developers laptops. This eliminated the need for developers to connect to the VPN for development. This allowed developers being more efficient, resulting in an improved time to market.● I wrote a shell script to automate the deployment of sandbox servers on the corporate infrastructure, including pulling the latest code from SVN. A process that would take a developer much of the day was now completed in 10 minutes. This allowed developers being more efficient, resulting in an improved time to market.

● [Product: Virtuo 2.0] Virtuo Group was migrating their Virtuo program from MS­ASP/MS­SQL to PHP/MySQL. In addition to changing the database structure, I designed a simple change­management system based upon BASH scripts that would ensure database changes were properly pushed from development to test to production.● [Product: Virtuo 2.0] The Virtuo application consists of a mysql database, as well as an Apache web site. The site requires some rather complex permissions configuration. I wrote a installation script that would automatically create the database instance, create the web site, configure directory permissions, and

Athlon Sports was using Mailchimp to manage their e­mail campaigns. Whenever they made a change to their local database, they had to push several thousand changes to the Mail Chimp server. This resulted in very long update times, and timeouts. I rewrote their code that interacted with the Mail Chimp API, and got updates down to under three minutes.Developed E-Commerce and Process Automation solutions using Magento PHP

[Product: PDL 2.0] Terenine was upgrading their “Payday Loan” (PDL) program to a new version. The old version was written in PHP 4, and directly accessed the database table. I was put in charge of analyzing the current database, and drafting requirements to implement Doctrine 2.0. The PDL database consisted of over 600 tables, including many without indexes. I wrote a PHP program to configure the database so that Doctrine2 could create data objects from the tables. Doing this process manually would have taken many weeks. The final run time for the script was 15 minutes.

● [Product: Summary Report System] Managers in our department wanted to produce regular reports off of the network performance data stored in the corporate­level Oracle server but their current reporting solution was not working. I met with managers, heard their problems, the shortfalls with the current system, and the reports that they needed to be able to create. I drafted a requirements document, and wrote a program to extract only the data that we needed (ie, Southern Division data that was missing) from the Corporate servers, scrub it, transform it, and store it in local tables on our MySql server. Reports that took 40 minutes to run now ran in under three minutes.● [Product: Database API] After learning that the OSS department had local data from the national databases, other departments had a requirement to generate reports based upon data from our database. However, our manager did not want to give said departments direct access to our data. I met with managers of our department, and other departments, and gathered requirements fordesigning a solution. I wrote an XML­based API that allowed us to give specific access to specific departments that needed it. This eliminated the need for our department to run requested queries, and provide data in spreadsheet format.● [Product: IMP] Once we started importing data from the corporate Oracle server, we needed a way to monitor the imports. I met with members of our NOC, and worked out requirements for a program to monitor and control data import jobs. I wrote a program called Import Monitor Program (IMP) to control, monitor and restart import jobs.

I received 3 performance achievement awards in under 12 months both recognition and cash awards, and a $15,000 bonus for my superior performance and determination in repeatably solving mission critical/time sensitive technical challenges - which included 3 shifts that were over 24 hours in length. In one case, by solving the technical challenges, significant revenue recognition goals were met.In another, a major media company required resolution of some unique technical issues, before the planned upgrade would be successful. By working all week-end and many nights until 1AM, I had identified and reolved all issues - much to the satisfaction of this very high profile customer. In yet another, a vendor's technical issue threatened a critical deadline the evening before. I was able to find solutions to overcome each roadblock the vendor encountered, and keep the vendor working through the night. Mission accomplished - deadline was met!(for more success cases, contact me directly)• Played key roll in development of critical VMRE and FAME systems for government contracts• Designed and integrated domain architecture for Invenio Digital Asset Management (DAM)solns• Designed automated stress-test scheme for Digital Asset Management Systems• Designed production process for VMRE and FAME systems to automate deployment• Performed system security to DISA and DSS standards to allow certification for classified data• Created first ever client software installation program• Performed on-site installation and upgrade of Harris Invenio software• Received 3 awards for outstanding performance within first 12 months

Driveitaway was a web company that started in my friends basement. I helped to take the company from a tiny startup to a 4­Million dollar company.● [Product: Driveitaway web application] Meeting with the stakeholders, I was able to understand the concept of the function of the proposed Driveitaway application. I was able to gather requirements, use cases, and user stories to write a Fundamental Requirements Document (FRD) From this, I designed the entire schema for the driveaway application. The design was stable and scalable.• Designed MySQL database for online auction company• Designed and developed auction front-end and back end• Configured and deployed Linux and Windows servers and workstations• Managed office and NOC networks• Deployed Standardized workstation image solution using Ghost• Supported MS-Windows and Linux computers and network• Implemented backup scheme for Linux and Windows servers and workstations, including mail and database servers• Managed Netscreen firewalls to secure office and NOC, and provide load balancing and high-availability• Maintained website and corporate application on Apache servers• Managed corporate Sendmail and Exchange mail servers• Performed Network Security Scanning

● [Product: Business Control System] Pundits was using a paper timecard system for consultants to submit their billable hours. This system was data­entry heavy, and cumbersome. In addition, Pundits new that they were failing to bill for many hours due to missing timecards, but they had no way of tracking it. I wrote a web­based time entry system to track employee data, clients, consulting contracts, resumes and references. Querying this system, I was able to find over $200,000 in un­billed consulting hours.• Designed, Implemented and administrated integrated Unix/ Windows-NT/2K network.• Implemented internal and client remote network management• Installed, configured and administered Windows and Linux servers• Trained 30 person Networking team• Standardized rollout of new workstation configurations using Symantec Ghost Enterprise• Centrally managed network security and virus detection using industry standard applications• Implemented corporate-wide scheme to backup workstations and servers including Exchange, MS-SQL and Oracle servers• Wrote program in MS-Access to track, employee data, time cards, clients, consulting contracts, resumes and references.• Supported 150 end users in 12 national offices• Implemented corporate-wide MS Exchange solution for e-mail and collaboration• Managed corporate Intranet and website using IIS 5• Deployed Terminal Services remote access solution• Performed Network Security Scanning

• Designed SQL 7.0 Database Back end for custom web application• Configured NT development and production servers• Provided tech support to 30 user office• Managed Sonic Wall firewall• Wrote IT Asset tracking database in Microsoft Access• Managed web application on Microsoft IIS server• Oversaw development of web based Human Resource Management system using Cold Fusion and MS-SQL 7.0• Automated workstation deployment with Ghost• Wrote executive technical training manuals• Managed LAN/WAN operations.• Provided tech support to clients• Managed integration of IT departments after corporate merger, including training, standardization, and VPN deployment

• Standardized server, workstation and network configurations• Automated workstation deployment• Managed project to de-upgrade servers and workstations in 6 offices• Automated deployment of IT infrastructure to 6 new corporate offices• Trained 6 person networking team• Secured company network and IT assets• Deployed new servers for Computer Based Training (CBT) programs• Implemented corporate intranet• Provided technical suppor

• Managed deployment project to migrate 20 offices and 250 users from Unix application on MUX 56K lines to Windows based PC’s and high-speed Internet lines• Installed and CSU/DSUs , Ethernet Switches and routers for our WAN• Developed and documented all network LAN, WAN, Server and workstation configurations, standards and procedures• Trained and managed 8 person deployment team.• Developed Quality Assurance and installation documentation procedures.• Wrote extensive network and software training manuals• Organized, managed and trained training and support team• Worked with ISP's to provide WAN connectivity for 20 corporate offices and resolve installation issues• Provide full hardware and software support to end users and technical staff.

Network Engineer, Application architect/developer