SUMMARY:

Work in a team to create applications that help many people without exploiting them. Leverage my current skills while continually acquiring new skills. Work in an environment that utilizes open source projects and encourages contributions back to these projects. Mentor less experienced developers. Participate in peer reviews of work products.

WORK EXPERIENCE:

Confidential, Washington, DC

Contract Architect/Developer

Responsibilities:

• Convert existing Enrollment system from Rails 3.0 to Rails 4, Ruby 1.8.7 to Ruby 2.0; update gems and tests; upgrade database from PostgreSQL 9.0 to 9.3 to get to a supported environment with security fixes (in process).
• Architect Common Measures outcome tracking system using existing 4 server farm.
• This replaced over 400,000 non - standardized spreadsheet tabs administered by 64,000 volunteers.
• Design/implement Common Measures in a remote team of 2 developers using stack of Ubuntu 12.04, Postgresql 9, memcached, rvm, Capistrano, Rspec, Ruby 1.9.3, Rails 3.2.
• Architect Event Management system using existing 4 server farm, 2 server geographically diverse backup and Amazon ECS/EBS/S3 tertiary backup. This system generated over $100,000 in revenue in the first 4 months of operation.
• Design/implement Event system in a remote Agile team of 4 developers. System stack Ubuntu 12.04, Postgresql 9, memcached, rvm, Capistrano, Circled, Rspec, Capybara, Selenium, Ruby 1.8.7 (ree), Rails 3.0.
• Performance tune an existing reporting subsystem by modifying a Postgresql adapter to use PostgreSQL views and functions. Add 3-level Russian-doll caching using Dalli/Memcached and a backport of the Rails 3.2 ActionController::Cache and ActiveSupport::Cache. Common report runtimes reduced from 15 minutes to sub-minute performance.
• Move outbound email from local postfix servers to Sendgrid API to manage and secure 4 million outbound email messages/month. Postfix servers became unstable, losing email messages, and were not secure.
• Provide all Ubuntu 12.04 server operations support
• Use Skype, Adobe Connect, Assembla, GitHub, phone and email to communicate with remote developers, project manager, QA testers, business analysts, steering committee and other stakeholders.

Confidential, Rhode Island

Contract Ruby on Rails Developer

Responsibilities:

• Upgrade netra.org site from Debian 6 to Debian 7, Ruby 1.8.7 to ree, Ruby on Rails 1.0 to 2.3, database from MySQL 4 to MySQL 5 to provide event logistics information, event placement, scoring and championship calculations for 10-15 races/season with scaling to 2,000 active members from inital site used only by 10 board members and 1 administrator.
• Migrate hosting from internal to Slicehost to Linode and provide all server operations support in a Debian 6/7 environment.
• Add forum (rboard) and store site (Spree/ActiveMerchant) on Debian 7, Ruby 1.8.7 (ree), Rails 3.0, MySQL 5, rvm. The store replaced a fax-in form with a limited array of club merchandise with a store with 3x more SKUs, real-time inventory and credit-card payment capability which more than tripled the product revenue.
• Modify Spree to provide event management functions such as selling tickets with multiple configurable options and event reporting. This replaced approximately a thousand emails and a giant Excel spreadsheet. The new system provided the exact outputs needed to run events and reduced administrators effort by 90%. This allowed NETRA to eliminate a full-time administrator and replace him with a volunteer for a net savings of 75% of their annual budget.
• Implement REST APIs with queuing between Spree site, forum site and the main site to manage membership purchases/renewals and single sign on to eliminate user irritation about needing to create 3 different accounts.
• Implement S3 CDN for most commonly accessed PDF, photo and video content to eliminate congestion on the NETRA server.
• Implemented Sendgrid outbound email API to replace paper newsletters with a link to S3-based PDF file which reduced the NETRA budget by 25%.

Confidential, Chicago

Contract Architect

Responsibilities:

• Architect and design centralized NetOps data warehouse storing network transactions from phones to radios to cell towers to switches to network support room to NetOps Intranet site using snowflake schema running on a cluster of Solaris database servers running Oracle 10g/11g.
• This system provided near-real-time alerting of network problems and aggregated reports at 9 levels on over 250 metrics with 2 year data retention for 1,200 users running both web-based and client-server BI tools.

Technical Lead / Acting Project Manager

Confidential

Responsibilities:

• Lead database team of 3 developers in creating Oracle data warehouse on a cluster of 4 geographically diverse servers with key/value store fact table with over 1 trillion rows growing by over 2 billion rows/day. All access to the database is by views and procedures that pull selective subsets of the fact table and perform row to column transforms to facilitate BI tool access.
• Lead database development team of 3 in creating an Oracle Operational Data Store (ODS) on a cluster of 6 servers to buffer and normalize incoming NetOps data traffic of 1-2 billion rows/hour with real-time feed into the data warehouse. All ETL performed using Oracle PL/SQL stored procedures.
• Perform performance tuning on upstream Oracle data source systems to move from batch processing to real-time data flow-through to the ODS and data warehouse.
• Create Ruby on Rails 3.2, Ruby 1.9.3, Solaris, memcached, Ext JS web interface to the data warehouse providing both standard reports as well as a highly interactive web dashboard utilizing Ext JS for the UI and Rails metadata coding using field-level Ruby snippets stored in a separate reporting database. The resulting reports are assembled on the fly to produce sub-minute dashboard page renders of 46 graphs totaling more than 1 million JSON data points as well as other graphic and tabular reports. The largest of these reports replaced a 300 tab Excel spreadsheet generated by a full-time consultant doing cut & paste and manual entry.
• Design and create SOAP, REST and custom APIs to feed various downstream systems. Some of these systems had never received the data available in the data warehouse and entered with cut & paste the other data.
• Migrate entire infrastructure for ODS and DW to Oracle Exabyte server farm and perform significant performance tuning to support addition of LTE infrastructure which expands incoming data flow to 10 billion rows/hour.
• Tuning was so successful that server farm size was cut in half from the original design and still had headroom to support growth beyond the initial LTE implementation despite growth of the database to petabyte scale for a total cost savings of $50 million upfront and $5 million/year in maintenance.

Confidential, Arkansas

Development Subcontractor

Responsibilities:

• Architect complete WAPR and LAPR stack-based application to completely automated the summer camp administration process from public signups. e-commerce. cabin assignments. activity management. health services management (HIPAA compliant), maintenance management, time entry and API to Quickbooks for payroll and accounting transfers of e-commerce revenue and activity costs.
• Design system using graphic design provided by Confidential ’s vendors along with workflow analysis generated by a Confidential team of 2.
• Hire 3 developers and a graphic designer to implement the designed system using Apache, PostgreSQL, Ruby 1.8.7 and Rails 2.3.
• Generate iPhone HTML-based interface for bus pickup attendance checks and activity attendance monitoring.
• Create master dashboard page in Rails that allowed the camp owners to quickly ascertain the number of cabins needing to be used for each session, the number of counselors and other staff needed for each session, the number of buses needed to pick up campers from near-by major cities, the schedule of arrivals at the Little Rock airport of unaccompanied minors, the state of each camper’s required paperwork and the cash-flow of the camp operations.

Confidential, Lakeland, FL

Development Contractor

Responsibilities:

• Architect complete stack, application, automated dataflow and manual processes for a service called Lien Assistant that would allow construction subcontractors who had worked on a construction site but had not been paid by the general contractor to file a lien on the building under construction in the hope that they could recoup their lost revenue.
• Design database and application with a 2-person business analysis team. Research each county court system in Florida and identify courts that accept electronic filings.
• Hire a graphic designer and a developer to implement the designed system using PostgreSQL, Apache, CentOS, Ruby 1.8.7, Rails 2.1 - 2.3.
• Create Windows-based high-volume scanning station with Adobe Acrobat scanning controlled by a Ruby/WRX windows application using OLE automation to capture subcontractor receipts and other documentation required to generate the court filings for liens.
• Create API consumer of USPS mailing service to print and mail postcards to subcontractors and legal filings to the courts unable to accept electronic filings.
• Create API consumer for each Florida county court capable of accepting electronic filings. We discovered 2 commercial solutions with custom APIs and 3 homemade systems each with their own API.
• Create administrative workflow management and reporting Rails application to insure that all filings are sent to the appropriate court within 30 days of the non-payment.

Confidential, Lombard, IL

Contract Developer

Responsibilities:

• Created initial HTML pages for Golden Prairie site from graphical mockups
• Created API server process in Ruby for a specialized financial spreadsheet product running in Windows that parsed multiple CSV files and served that data to a web-server based Ruby on Rails API consumer.
• Create reporting site in Ruby on Rails to report on the data pulled into a MySQL database from the Windows-based API.

Confidential

Chief Technology Officer

Responsibilities:

• Design and implement with a team of 3 developers, an analyst and a graphic designer touchscreen-based consumer kiosk hardware design and programming using .NET-controlled captive IE objects, ASP, internal IIS server, HTML, Flash, Delphi database.
• Design and implement with a team of 3 developers and a graphic designer centrally controlled digital signage in retail environments using .NET-controlled captive IE objects, ASP, internal IIS server, HTML, Flash, SQL Server database
• Design and implement in a team of 2 the hardware and software required to run a consumer behavior-driven retail marketing system using WAMP, HTML, Flash. I am a named co-inventor on relevant patent filings.

Confidential

Partner, Chief Technology Officer

Responsibilities:

• Led prototype development of a branched logic scripting tool with a team of 8 developers and one analyst. I am a co-inventor of patent US7310784 granted for the branched logic scripting tool. This tool is now used to generate automated attendant phone systems.
• Created a low-cost secure wireless communications network for a national network of automated teller machines that allowed ATMs to be placed anywhere, including in mobile banking centers.