Senior Editor (Publications Team)2017 - PRESENTToptal
- Wrote, formatted, edited, and published blog articles, anonymous guides, and other site content.
- Prepared and sent newsletters.
- Recruited and coordinated with authors.
- Brainstormed and coordinated with the design team for illustrations.
- Applied SEO research to articles.
- Helped execute social media outreach plans.
- Streamlined procedures and checklists.
- Added integration automation to the pipeline.
Senior Back-end Developer - Node.js2017 - 2018Mllnnl
- Maintained, extended, and scaled the back end and database.
- Managed DevOps processes.
- Did code reviews.
- Coordinated with front-end developers on back-end API changes.
- Implemented the back-end test suite.
Indie Developer2015 - 2016In the Beginning was the Word Game
Technologies: Back-end, Shotcut, Godot, Inkscape, Audacity, Blender, Linux, OS X, Windows, FlashDevelop, HaxeFlixel, HaXe
- Created two very basic Android apps.
- Built two games for Ludum Dare game jams (i.e., very rapid development).
- Designed, developed, blogged and tweeted about, directed, tested, published, and promoted a commercial video game while contributing bug and feature patches back to the open source technologies being used.
- Open-sourced my own library, FlxScrollableArea.
Linux Server Administrator/Automation Developer2015 - 2015Stepping Stone GmbH
Technologies: Back-end, LibreOffice, SSH, Templates, MediaWiki, PHP, Windows Server, Remote Desktop, OwnCloud, Iptables, Bash, Vi, Terminal, GitHub, Subversion (SVN), Spiceworks, SugarCRM, Alfresco, DNS, LDAP, GlusterFS, NFS, Ubuntu, Gentoo, CentOS, Quick EMUlator (QEMU), KVM
- Provisioned KVM server (Linux and Windows) for various client projects, each involving setting up servers from cloned VMs, updating the internal wiki, configuring Zabbix host monitoring, and customizing Iptables-based firewall scripts. Some projects also involved database and application back-end setup, creating simplified/prettified documentation for clients, and VM template maintenance.
- Provisioned web hosting, mail accounts, backup accounts, and ownCloud servers—set up and administered when requested by various clients.
- Helped install new RAID drives in rack servers and remove old ones.
- Automated DNS settings and firewall change for 200+ servers by writing bash scripts to extract server data from MediaWiki pages and to automate execution of DNS and firewall update scripts on every running Linux-based physical server, vServer, and KVM server.
- Optimized maintenance window notifiers and developed features—optimized and extended a Perl script using data from LDAP for exporting and for sending scheduled reminder emails.
- Helped prepare for colocation migration by taking physical inventory of rack servers and switches and updating firmware on newly purchased switches as well as provisioning a web server from ancient hardware to display a message during migration.
- Helped with physical colocation migration by uninstalling rack hardware, moving it, organizing it for most efficient reinstall, reinstalling it, and reconnecting cables.
Project Manager and Full-stack Software Engineer1996 - 2015Brant Aero
- Added a number of features, including a drag-n-drop image uploader, a "pending" feature for group request submissions, a history search feature with full text indexing and fuzzy text search for stock items, Facebook-style homepage notifications, and more, to a purchase request system.
- Created a government extranet for inspectors to approve policy manual revisions.
- Enabled cache support for hangar floor parts, requiring fewer trips to the stockroom while maintaining government traceability requirements and supply-level monitoring.
- Fixed, cleaned up, and provided data recovery and performance tuning for ad-hoc databases. Generated a network attack tracker graph that automatically imports data from the router.
- Implemented several features, including a document hierarchy editor with drag-n-drop added to the CMS, a third-party issue tracker solution hosted with Docker, and cronjobs to help catch vendor errors and notify the relevant manager using an integrated permissions hierarchy.
- Made the core functionality of an intranet app robust against outages of the main third-party system.
- Ported PartTake from VB to mod_perl, including barcode and address printing (with provisions for just-in-time auto-switching printers on Windows via URL scheme and rundll32 workaround).
- Staged a build system with unit testing, minification, performance testing, and integration testing with integrated QA.
- Upgraded a backup system to cross-platform multi-server usage.
- Added a website section powered by third-party bulletin board software and created an automatic image renaming and uploading tool for personal project management.
- Built a power outage tracker graph that automatically imports data from UPS. Added authenticated inspection tracking to the alternative UI for shop order updates.
- Created a couple of backup systems, including a solution for HyperV environment and a backup, verification, and restore solution to replace the old tapes-based system.
- Designed, wrote, and maintained the PartTake software system to streamline stockroom processes while meeting strict government traceability requirements and working with the exisitng inventory system and its timeclock, tool tracking, and purchase ordering integrations. Shipped with barcode and address label printers drawing relevant data from the existing system and configured the GUI tool.
- Enabled vendor purchase email templating for the purchase request system.
- Implemented honors-system workstation sharing, allowing different logins on separate tabs without confusing credentials (see https://stackoverflow.com/a/1133999/16777 – sometimes the rather unique business environment involved required unorthodox solutions).
- Oversaw and helped with the data migration of an accounting, inventory, and shop order system from DOS to SQL/Windows.
- Redesigned a number of websites, including a website and corresponding script to automatically update local pilot weather information, and vectorized its company logo; a website and wrote/edited material for the Save the Airport local political campaign; a website to be fast-loading and able to fit on a floppy disk; a website to feature a new aircraft sales section; a website with dynamic content and search functionality; and a website with featured past projects and auto-updated weather map overlayed onto the company's precise location.
- Wrote and implemented IT policy and analyzed and made improvements to the year-end processes as well as researched, revised, and helped implement, organize, and conduct the company process audit.
- Built an NS- and IE-compatible website and corresponding Windows GUI page-text updater utility.
- Created marketing materials to sell PartTake to other users of our third-party niche industry integrated accounting system.
- Developed a custom CMS—from scratch—automatically following government regulation updates, notifying only the relevant internal parties of the relevant internal documents (and their internal dependencies) that would need review. All regulatory links were kept in consistent auto-updated format, and review and audit policies were enforced by database triggers.
- Evaluated Andromeda as a potential platform to base the rest of the intranet app on.
- Implemented the UI for a SQL backup manager. Rewrote an intranet app with commonly used SQL reports from scratch to speed it up and cover functionality gaps.
- Migrated a domain from Windows 2003 AD to Samba 4.
- Oversaw the migration of a server and workstation system from Novell Netware to Windows 2000 AD.
- Refactored shop order workflow to streamline usage, testing, and maintenance; integrated a fast menu UI library (both keyboard and touchscreen friendly).
- Built database development tools: a PostgreSQL function body searcher for global renames, a GraphViz-based foreign key map generator, and more.
- Created server health metrics via statistical process control graphs and output comparison, with email notification.
- Developed a smart-sorting table view UI so that part numbers end up being sorted as they traditionally were physically, even in more complicated number-letter-number-etc. scenarios.
- Expanded the shop order UI to cover more features than offered by the third-party system, and added project wrap-up verification tools to avoid peak activity errors.
- Integrated government-supplied aircraft registration databases for easy client info updates.
- Migrated a purchase request system from paper to email, and then later from email to database, integrated with the existing intranet app. Wrote a VB5 utility to speed up the process of scanning old documents into the new paperless system.
- Built the Dogfooded task/project management feature integrated with an intranet app.
- Created Widgetissimo, an initially jQuery-based plugin side project for UX improvement with form autosave and keyboardability focus.
- Developed an alternative UI for shop order updates for user convenience/workflow speed, including time tracker UI replacement, with RTF to HTML (and back) conversion, and HTML editor UI (cross-database).
- Integrated a timed training bulletin system with a CMS to force a re-read of updated sections at a manager-specified interval.
- Migrated a major accounting system version, including all required changes, to homegrown add-ons.
- Developed disaster recovery for SQL and filesystem data from a HyperV environment.
- Integrated a website with Blogger.com to allow a stockroom manager to update the special offers page herself.
- Researched, built, set up, and administered a new Linux server and dial-up connection sharing. Migrated the intranet app and scheduled scripts from Windows to Linux.
- Developed draggable sort-preserved multiselect for quick composition of complex selections for a purchasing request system (close emulation of Windows Explorer's behavior for easiest user learning curve).
- Integrated an avionics storage bin tracking and replacing paper system with the project management UI and vendor database.
- Mitigated potential disaster using commit hooks integrated with paper procedures to keep a plan for dealing effectively with IT service outages up to date. Wrote an intro paper telling how to access multiple automatic backups of electronic documentation.
- Researched, designed, and implemented autogenerated database views from a smart normalized database design with integrated benchmarking. The database features manager, employee, and personalized database views (where applicable) with auto-generated UI and tables that automatically link to the editing page for each row and the editing page for any referenced foreign key in the row. The editing pages saves partially filled-out forms to pre-emptively protect against data loss in the case of client, server, or connection problems.
- Developed full text search indexing for a third-party app via smart synchronization for vast speed improvements on zero budget.
- Integrated company role hierarchy with the CMS for training so that document updates trigger a notification to exactly the right employee to read changes; an automatic org chart generator is based on this data to fulfill a requirement for maintaining the policy manual.
- Integrated Selenium IDE into the QA process for most common tasks to prevent regressions.
National Operations and Accounts Administrator2011 - 2012Global Youth Volunteer Network
Technologies: SQL, Back-end, Front-end, Full-stack, Windows, WordPress, CiviCRM, MacOS, Python, PHP, MySQL
- Migrated a website to a new provider and content to WordPress.
- Maintained and extended a web-based accounting system—home-grown and undocumented (PHP, MySQL).
- Migrated Core Data to CiviCRM.
Intern2002 - 2002Storeimage
Technologies: PHP, HTML, MacOS, Linux, Windows
- Rebuilt Windows workstations, wrote technical documentation and procedures, organized documents and spare hardware, troubleshot Windows desktop and server issues, and managed desktop virus scanner updates.
- Reorganized 200 network cables' worth of spaghetti after hours to avoid service disruption.
- Wrote a simple info service generator in PHP on my last day.