Technical Consultant – RemoteNovember 2022 – Present

Writing articles, assisting with open-source projects.

• Updated Robert Rodes’s Blogfolio, this blog and portfolio website. (WordPress, JavaScript, HTML/CSS)
• Co-created Neighborhoods, an open-source application that allows users to come together and provide related services.
• Contributed to Mozilla’s MDN documentation.
• Consulted with the creators of Alexandria, an open-source text translator, on database architecture.
• Published numerous technical articles.

Student, Launch School – RemoteJanuary 2019 – November 2022

Launch School is a comprehensive, mastery-based online software engineering school.

• Enhanced JavaScript, HTML and CSS skills.
• Learned Ruby, PostgreSQL and TCP/IP.
• Mentored other students in OOAD, SQL and JavaScript.

Software Developer, PPLS – Manchester, TNFebruary 2016 – January 2019

PPLS is a startup military order fulfillment company.

• Wrote an internal, browser-based software application to facilitate the process of bidding on Department of Defense (DoD) solicitations.
• Gathered requirements, designed and coded front and back end. (MySQL, PHP, jQuery, JavaScript)

Contract Consultant, NLETS – RemoteJanuary 2015 – January 2016

NLETS is the National Law Enforcement Telecom System. Coded and deployed changes to an NLETS software application that transmits License Plate Recognition (LPR) data feeds from capture sites, and forwards them to law enforcement databases. (Java, Netbeans)

• Analyzed and executed a set of change requirements to the LPR (License Plate Recognition) data feed.
• Identified issues with, and proposed revisions to, existing specifications, moving the process forward to successful completion.

Consulting Analyst, Bridgestone Warren Plant – Morrison, TNSeptember – December 2014

• Gathered requirements for, and designed revisions to, an application that checks credentials of operators using plant equipment. (C#)
• As part of a SQL Server version upgrade, migrated approximately 50 reports to the new version. (SQL Server, SSIS)
• Generated multiple new reports in SSRS.
• Designed changes to a controller application for a device that assembles components for mixing machines. (C#)

Contract Analyst, CIGNA – Chattanooga, TNJanuary – June 2014

Contributed to the migration of 4 million legacy VB6/DB2 Patient Records to a McKesson/Oracle application.

• Performed gap analyses on database schemas, identified issues and suggested solutions.
• Audited Quality Assurance test plans and requirements traceability matrix (RTM) documents.
• Created evidence of testing (EOT) documents.

Software Developer/Product Manager, J2 Software Systems – Tullahoma, TNAugust 2011 – September 2013

Led Business Analysis, UI and UX Design and quality assurance efforts for PD Manager v.3.10, a police department management application. (SQL Server, C#, LLBLGen, jQuery, Balsamiq)

• Created gap analysis between FBI’s NIBRS and N-Dex database schema, each with over 2000 individual elements.
• Revised test plans and supervised Quality Assurance staff.
• Built mockups, wireframes, and prototypes.
• Coded modules, repaired bugs and implemented changes.

Consultant, Clear Vision Information Systems – Westlake Village, CAOctober 2010 – March 2011

• Merged 7000 duplicate records in a hospital database. (SQL Server, VB6)
• Created a tool to help other users merge duplicate records. (VB6)

Technical Analyst, The Word and Brown Companies – Orange, CAMay 2009 – July 2010

Contributed to the development and launching of www.healthcompare.com, a website that assists users in finding health insurance carriers.

• Analyzed business requirements, devised and documented functional and technical specifications.

Change Control Coordinator, CSAA/AAA – Irvine, CASeptember 2005 – October 2008

• Devised and implemented a new change management proces. Administered the process for 3 years.
• Cut emergency changes as a percent of total changes by 70 percent, and lowered defects per change by 40 percent.

Independent Contractor – Home-Office Based1998 – 2005

• Developed software application for Jack Demmer Ford to track rebates. Reduced chargebacks by 80 percent. Reduced unit holding costs by 5 percent. (VB6)
• Architected and developed a customized Customer Relationship Management application for ExpanderAmericas to track inventory and sales leads. Application in production for over 7 years. (Lotus Notes, NotesScript)
• Conducted over 1000 hours of classroom seminars in VB6, requirements analysis, SQL Server, and UML.