Larry L. McClain
Senior Developer Consultant
Albany, Georgia, 31721, USA
******@*****.***
https://www.linkedin.com/in/larry-l-mcclain-93840252/
SUMMARY
Dynamic Senior Developer Consultant with over 30 years of experience in application design, development, and supervision. Proficient in various programming languages and database development, with a strong background in creating maintainable and efficient code while adhering to best practices. Successfully led enhancements for legacy systems, improving performance and user interfaces, while driving collaboration among teams. Committed to delivering innovative solutions that address complex technical challenges, poised to bring valuable expertise to your company.
WORK EXPERIENCE
10/2022 – Present Pinao Consulting, LLC; Albany, USA Senior Mainframe Programmer
Provided comprehensive support and enhancements for TMS (Transportation Management System), a USMC legacy mainframe application using: Natural, Adabas, COBOL, Assembler, JCL, Endevor, ROSCOE, and TSO utilities.
Roles and Responsibilities:
Participates as senior team member to provide support and enhancements for TMS (Transportation Management System), a legacy USMC mainframe application coded primarily in Natural N20
Participates as a team member to redesign, recode, and streamline old TMS mainframe functionality in preparation to transition to cloud functionality
Maintained and enhanced programs written in both Natural, COBOL, and Assembler which were stored using various TSO utilities as Endevor
Maintained and developed JCL batch processing using for report printing, FTP, and zip archiving
Used various IBM z/OS utilities (e.g. IEBGENER, IEBCOPY, IEFBR14, IEBCOMPR, IDCAMS, SORT, SuperCE, File-Aid, Xpediter, etc.) to create, debug. and manipulate VSAM and PDS files
10/2022 – 07/2025 SAIC, Inc.; Reston, USA Senior PowerBuilder Consultant
Delivered expert support and enhancements for JFRG (Joint Force Requirements Generator), a USMC legacy standalone application using: PowerBuilder, SQL Anywhere, Git, SourceTree, and Windows utilities.
Roles and Responsibilities:
Analyzed, debugged, and resolved complex issues within the PowerBuilder-based application to ensure seamless operation and data accuracy for mission-critical functions.
Designed and implemented enhancements to the existing PowerBuilder codebase to improve performance, usability, and compliance with evolving military requirements.
Collaborated with functional stakeholders to gather and refine software requirements and translated them into robust application features.
Developed and optimized SQL queries and stored procedures in SQL Anywhere to support data-driven functionalities and reporting modules.
10/2016 – 09/2022 CGI Federal, Inc.; Albany, USA Senior Consultant
Led a team and served as adjunct Lead Developer to thoroughly research, analyze, and document baseline functionalities of the Transportation Management System (TMS) using: Natural, Adabas, JCL, TSO, Roscoe, Endevor, COBOL, Java, Maven, AJAX, ASP, Access, Agile, Bootstrap, CSS, Confluence, DTS, Docker, Git, Hibernate, JIRA, JPA, Kubernetes, Lombok, PHP, PostgreSQL, RESTful services, SASS, Spring, Vuex Router, VueJS, Vuex, Wireframes, PowerBuilder, SQL Anywhere, GitHub, SourceTree, and TSO utilities. Revised PII user screens and reports within the TMS application by redesigning and obfuscating components.
Roles and Responsibilities:
Directed a cross-functional team to perform reverse engineering of legacy mainframe and distributed components, ensuring accurate capture of system behavior and data flows across multiple platforms.
Conducted deep-dive assessments of existing functionalities written in Natural, COBOL, and PowerBuilder, mapping them to modern Java-based microservices and web technologies.
Performed analysis and enhancements on PowerBuilder modules, including user interface redesign, data validation logic, and backend interaction with SQL Anywhere databases.
Refactored legacy PowerBuilder code to align with updated business rules, improving maintainability and performance of critical components within the TMS application.
Developed and tested PowerBuilder screen modifications and reports to accommodate PII obfuscation requirements while preserving user functionality.
Integrated PowerBuilder enhancements into a unified development workflow, using GitHub and SourceTree for version control and collaboration.
Authored detailed system documentation, architecture diagrams, and wireframes to support knowledge transfer and modernization planning.
Contributed to DevSecOps pipelines, container orchestration, and deployment strategies involving Docker and Kubernetes.
Coordinated with business analysts and security teams to ensure system updates were audit-ready and in alignment with federal and DoD regulations.
06/2014 – 09/2016 IPNS, Inc.; Albany, USA Senior Program Analyst
Collaborated with functional analysts to define and refine specifications and requirements for USMC legacy application changes using: Natural, Ababas, JCL, TSO, Roscoe, Endevor, COBOL, Java, JavaScript, JSP, Oracle, PL/SQL, and TSO utilities. Authored thorough documentation and artifacts to support adherence to best business practices.
Roles and Responsibilities:
Executed all phases of the software life cycle development and testing
Consulted with functional analysts to define/refine specs and requirements for USMC legacy application changes and fixes
Analyzed log/error files for problem resolution
Generated business cases, level-of-efforts, point papers, recommendations and other technical advice to ensure an integrated solutions were successfully concluded
Generated documentation and artifacts to support and sustain best business practices to develop and maintain legacy software in accordance to DoD and C4 policies
Developed PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 11g/12c
Maintained and supported legacy applications which comprise of Java, JavaScript, and JSP objects
Assisted in the CSP/DPAS data conversion at all major USMC base installations by providing data analysis, software coding, and backend data import/export support
07/2013 – 06/2014 SAWTST, Inc.; Albany, USA Senior Program Analyst
Collaborated with functional analysts to define and refine specifications and requirements for USMC legacy application changes using: Java, JavaScript, JSP, Oracle, and PL/SQL.
Roles and Responsibilities:
Executed all phases of the software life cycle development and testing
Consulted with functional analysts to define/refine specs and requirements for USMC legacy application changes and fixes
Analyzed log/error files for problem resolution
Generated business cases, level-of-efforts, point papers, recommendations and other technical advice to ensure an integrated solutions were successfully concluded
Generated documentation and artifacts to support and sustain best business practices to develop and maintain legacy software in accordance to DoD and C4 policies
Developed PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 11g/12c
01/2010 – 05/2013 CGI Federal, Inc.; Albany, USA Deputy Program Manager
Championed project management responsibilities, focusing on budget oversight and forecasting to support USMC legacy applications.
Roles and Responsibilities:
Executed Project Management responsibilities for budget and forecasting for Stanley's GCSS-MC LS PDSS Team
Coordinated daily activities of Stanley (Prime Contractor) and its subcontractors (CSC, IR Tech, and Smartronix)
Assisted in supervising some 35+ staffers including Analysts, Programmers, Developers, and DBA’s
Generated Monthly Status Reports as mandated in the contract agreement
Created PowerPoint presentations for Interim Program Reviews with metrics describing quarterly support efforts
02/2008 – 01/2010 Stanley Associates, Inc.; Quantico, VA; Software Developer
Engineered, developed, and maintained internal applications using: PowerBuilder, Java, Oracle, PL/SQL, Maven, Eclipse, and XML.
Roles and Responsibilities:
Designed and developed user interfaces and business logic using PowerBuilder to support internal workflows and enterprise processes.
Built and maintained client-server applications with complex data entry, validation, and reporting capabilities, ensuring high usability and performance.
Integrated PowerBuilder front-end components with Oracle databases through PL/SQL procedures and dynamic SQL queries to support transactional and reporting needs.
Analyzed and refactored legacy PowerBuilder modules to improve performance, maintainability, and compliance with coding standards.
Developed backend services in Java and coordinated integration with existing PowerBuilder components for seamless user interaction across application layers.
01/2008 - 02/2008 TEK Systems, Inc.; Oklahoma City, OK Contractor
Roles and Responsibilities:
Designed, developed, and maintained internal applications built using PowerBuilder and Java
Designed, developed, and maintained Oracle stored procedures, triggers, tables, views, etc.
Achieved an understanding and used XML, XML parsing, and XML over HTTP, etc.
Provided support to internal business units for all POS (point-of-sales) applications and devices
Worked with team members to help provide problem resolutions
Participated in peer reviews on specifications, design, documentation, and development
Other duties included supporting various applications written in .Net and C++
10/2007 - 12/2007 TEK Systems, Inc.; Columbus, OH Contractor
Roles and Responsibilities:
Achieved an understanding of existing PB and .Net applications to document functional decomposition
Created and tested Unit Test Scripts for FDA compliance for nutritional devices
Created and tested Validation Test Scripts for FDA compliance for nutritional devices
Reviewed and approved electronic signature requirements
Developed and/or reviewed company software and quality policy and procedures
Developed PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 9i
03/2007 - 10/2007 Contractor; S & P Solutions, Inc.; Cleveland, OH
Roles and Responsibilities:
Achieved an understanding of the existing MicroFocus COBOL and C++ legacy applications
Created PB GUI windows to replace legacy text screens
Debugged and tested MicroFocus COBOL code using the tool Animator
Designed and coded user enhancements to existing PB applications
Developed PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 9i
Other duties included supporting various applications written in .Net
03/2006 - 09/2006 Database Developer; TechResults, Inc.; Las Vegas, NV
Roles and Responsibilities:
Achieved an understanding of the existing client data tables for conversion to in-house usage
Created and modified ETL (extract-transfer-load) stored procedures for client data
Created and modified DTS (data transformation services) packages to import client data
Created and modified cube views used to report client data for casino analytics
Created documentation for QA testing and client installations for client system modifications
Designed and coded an ad hoc PB application used to assist in report development and training
Develop PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 9i
10/2005 - 03/2006 Contractor; IIC / Apollo Consulting, Inc.; Tulsa, OK
Roles and Responsibilities:
Met with users to discuss proposed changes and enhancements to legacy PB applications
Created MS Word documents to detail proposed code changes
Coded and tested revised PB enhancements
Followed up with users to ensure code functionality is working as designed
Provided 24/7 support via pager
09/2000 – 04/2003 Software Developer; GERS, Inc.; San Diego, CA
Provided ongoing support to maintain and enhance applications tailored for retail business solutions.
Roles and Responsibilities:
Met with users to discuss proposed changes and enhancements to legacy PB applications
Provided support to maintain, enhance, and extend applications for retail business solutions designed for inventory control and management, and data warehousing
Used the following tools in the development environment: PB v6 and v7, Oracle Forms, Oracle 8i, SQL Plus, PL/SQL, C++, and PL/1 using MS WinNT 4.0, UNIX, IBM AIX, and Sun Solaris
Coded scripts for testing database tables creation, alters, etc.
Assisted in the full-life development cycle from design, coding, and testing.
Develop PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle 8i
02/1998 – 09/2000 Systems Analyst; EHS, Inc.; Tempe, AZ
Roles and Responsibilities:
Assisted in the support of a PC-based property management system
Enhanced and maintained a PB v6.5 application used by hotel and resort clients
Worked to make applications coded in C++, MS Pascal, and Assembler to be Y2K compliant
Develop PL/SQL packages, tables, triggers, indexes, constraints, etc. using Oracle, MS SQL Server, and Sybase Anywhere
EDUCATION
09/1969 – 05/1972 North Natchez High School Diploma, General Studies Natchez, USA
09/1972 – 08/1975 Jackson State University B.S., Computer Science Jackson, USA
09/1975 – Present Arizona State University M.A., Mathematics Tempe, USA
01/2009 – 05/2010 Andersonville Theological Seminary Th.M., Theology Camilla, USA
01/2009 – 01/2011 Andersonville Theological Seminary Th.D., Theology Camilla, USA
SKILLS
• Access
• Adabas
• Agile
• AIX
• AJAX
• APEX
• ASP
• Assembler
• Bootstrap
• C/C++
• Citrix
• COBOL
• Confluence
• CouchDB
• Crystal Reports
• CSS
• CURL
• DB2
• Docker
• DOS
• DTS
• EDI
• EDX
• Endevor
• FORTRAN
• GCOS
• GetHub
• Git
• Go
• Hibernate
• Informix
• InstallShield
• ISPF
• Java
• JCL
• jDeveloper
• JIRA
• JPA
• jQuery
• JSON
• Kubernetes
• Linux
• Lombok
• Lotus Notes
• Maven
• MongoDB
• Natural
• Oracle
• Oracle Forms
• OS/2
• OS/390
• Pascal
• PHP
• PL/1
• PL/SQL
• PostgreSQL
• PowerBuilder
• PuTTY
• RESTful
• Rogue Wave
• Roscoe
• SASS
• SourceTree
• Spring
• SQL Anywhere
• SQL Server
• TOAD
• TSO
• Unix
• Visual Basic
• VueJS
• Vuex
• Vuex Router
• WinCVS
• Windows
• Wireframes
• XML
• z/OS
ACHIEVEMENTS
• Team Leadership
• Agile Methodologies
• Project Management
• Technical Documentation
• Certification: OCA PL/SQL Developer (1Z0-044), 2015
Certification: ITIL Foundation (v3), 2015
Certification: Security+ (SY0-401), 2017 (thru October, 2026)
Active Secret Clearance