ROBERT RODES
Software Engineer
Technical Proficiencies
Work History
Software Developer – National Aerospace Solutions (NAS)October 2023 – Present
I provide development support for the Arnold Test Mission Support System (ATMSS) business system, primarily supporting the ongoing effort to migrate WAM v. 1.9 to WAM v. 2.3.
- Developed Inbound Web Service APIs and SQL code to perform batch additions of and updates to WAM invoices. Reduced the time required to enter a typical dataset from two to three hours to several minutes. (WAM, PL/SQL)
- Created enhancements to various reports. (BI Publisher, PL/SQL)
- Created Material Issue and Purchase Order test data in support of a warehouse barcode reading project. (WAM)
Technical Consultant – RemoteNovember 2022 – September 2023
Writing articles, assisting with open-source projects.
- Created content for this blog and portfolio website. (WordPress, JavaScript, HTML/CSS)
- 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, implemented and administered a change management process for a team of 60 developers.
- 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.
Education
INDIANA UNIVERSITY, South Bend, Indiana
Bachelor of Science (Music, Electronic and Computer Music)
Certifications
Microsoft Certified Solution Developer (MCSD), 2000-2010
Microsoft Certified Trainer (MCT), 1996-2005
Microsoft Certified Professional (MCP)
Sun Certified Instructor (SCI)
Publications
Pender, Tom. (2003). UML Bible. Edited by Robert Rodes, et al. Indianapolis, IN: Wiley.