Senior Software Architect & Developer for Enterprise Applications

JOHN E. RAMSPOTT

Senior Software Architect & Developer

Marietta, GA 30064 404-***-**** *********@*****.*** https://www.linkedin.com/in/john-ramspott-5367299/

PROFESSIONAL SUMMARY

Senior Software Architect with 35+ years of enterprise application development experience, specializing in Java-based web applications, cloud migration, and large-scale database architecture. Proven expertise in modernizing legacy systems, designing scalable solutions, and leading end-to-end application lifecycles for government and enterprise clients. Strong track record of successful AWS cloud migrations and multi-year application maintenance supporting thousands of users.

Core Competencies: Enterprise Architecture Java/J2EE Development Cloud Migration (AWS) Database Design & Optimization Web Services Integration Technical Leadership

TECHNICAL SKILLS

Languages: Java, SQL, JavaScript, Python, XML, HTML/CSS, Perl, C/C++

Frameworks & Tools: Spring, Hibernate, Struts, Apache Tomcat, Eclipse, Ant, Git

Databases: Oracle (10g-19c), MySQL, DB2 UDB, SQL Server

Cloud & DevOps: AWS (EC2, RDS, S3, CloudWatch), Linux (Red Hat/Amazon Linux), CI/CD pipelines, Azure

Integration: SOAP Web Services, Apache Axis, IBM WebSphere, REST API

Platforms: Linux (Red Hat/AWS), macOS, Windows Server, AIX, Solaris

AI: Claude Code, Codex, PyCharm, XCode

PROFESSIONAL EXPERIENCE

Architect/Developer State of Georgia – Georgia Building Authority

December 2026 – Present

Part-time, temporary contractor to migrate applications from Linux in Docker containers to Windows Server and .exe files.

Key Achievements

Relearned Python: Successfully moved code to Windows, stepped through that code and debugged/fixed issues, and performed requested updates with both the database access and REST API usage.

Developer a GUI interface: Developed a GUI application with Python to allow selective downloads of LDAP data from a third-party system via REST.

Moved from Cron to Windows Scheduler. Rewrote a BASH script as a PowerShell script. Wrote PowerShell scripts to schedule and monitor the jobs.

Senior Architect & Developer Object Resource Group (Contract)

July 2008 – November 2025

Georgia CPRS Application – Administrative Office of the Courts

Lead architect and developer for the Court Process Reporting System (CPRS), a mission-critical web application serving Georgia's child welfare system with 2,000+ active users.

Key Achievements:

Modernized Legacy Infrastructure: Successfully migrated CPRS from Solaris to Linux on AWS, improving scalability and reducing infrastructure costs.

Java Modernization: Led migration from Java 6 11 17, upgrading Spring, Hibernate, and Struts frameworks while maintaining zero downtime for production users

Cloud Architecture: Designed and implemented AWS deployment architecture using EC2, RDS, S3, and CloudWatch for a highly available production environment

Integration Development: Built robust web services integration with GA SHINES (Georgia's SACWIS system) for case data synchronization and document sharing.

Feature Development: Developed comprehensive modules for Panel Reviewers, State Appointed Attorneys General (SAAGs), DFCS employees, and CASA volunteers

Document Management: Implemented electronic filing system enabling signed court orders to be transmitted directly to SHINES

Business Logic: Designed complex timeline tracking and automated alert systems to ensure compliance with court-mandated deadlines

Database Architecture: Designed and optimized 200+ Oracle tables, stored procedures, and triggers supporting application functionality

Technologies: Java 17, Spring 5.x, Hibernate, Struts, Oracle 19c, AWS (EC2, RDS, S3), Linux, Apache Tomcat, SOAP Web Services

Data Architect & Java Developer Accenture via Object Resource Group

March 2006 – June 2008

Georgia SHINES – Statewide SACWIS Implementation (GA DFCS)

Served as Data Architect and Interface Architect for Georgia's $100M+ SACWIS implementation, one of the largest child welfare systems in the United States.

Key Achievements:

Enterprise Data Modeling: Architected Oracle 10g database containing 500+ tables across 5 schemas using Embarcadero ER/Studio, identified as critical project success factor

Systems Integration: Designed and implemented integration architecture connecting SHINES with 5 major state systems using WebMethods, web services, and custom ETL processes

Governance & Compliance: Established Database Change Request (DBCR) process and Data Fix procedures for controlled production modifications, ensuring audit compliance

Application Development: Built application screens using Java, Spring, Hibernate, and Accenture's GRNDS framework within Eclipse/MyEclipse IDE

Data Migration: Led conversion efforts migrating legacy system data to SHINES database, ensuring data integrity and business continuity

Reporting Infrastructure: Developed complex queries and reports for case management and compliance tracking

Technologies: Oracle 10g, Java/J2EE, Spring, Hibernate, WebMethods, ER/Studio, Eclipse, Linux

Lead Application Architect Object Resource Group

July 2004 – March 2006

CPRS Version 1 – Georgia Administrative Office of the Courts

Architected and developed the initial Case Plan Reporting System for Georgia's foster care system from ground up.

Key Achievements:

Full-Stack Development: Led complete SDLC from requirements gathering through production deployment using Java, Struts, Apache Tomcat on Sun SPARC servers

Database Design: Created comprehensive Oracle data models and database scripts using TOAD and Oracle SQL Developer

Web Services Integration: Implemented web services client using Apache Axis and WSIF for external system connectivity

Development Infrastructure: Established Eclipse 3.0 IDE with MyEclipse after thorough tool evaluation, improving team productivity

Reporting System: Designed and deployed analytics infrastructure with instrumentation for production system monitoring

Innovative UI: Developed Court Scheduling System using Laszlo Presentation Server (early RIA technology)

Team Leadership: Managed DBA, QA, and documentation resources across project lifecycle

Technologies: Java, Struts, Apache Tomcat, Oracle, Sun Solaris, Eclipse, Apache Axis, Laszlo

IT Architect Allied Holdings / IBM

December 1998 – June 2004

Founded and led the internet development team, delivering mission-critical web applications for nationwide automotive transportation operations.

Key Achievements:

Vehicle Tracking System: Architected real-time tracking application supporting both web browsers and wireless WML interface for nationwide fleet visibility

Yard Management System: Built comprehensive inventory management platform for terminal operations across multiple locations

Enterprise Applications: Developed Project Accounting, Issue Tracking, and HR database applications serving 1,000+ employees

Technology Leadership: Established technology standards, evaluated emerging tools, and mentored development team of 8+ developers

J2EE Architecture: Designed and implemented applications using IBM WebSphere, EJBs (CMP/BMP entity beans, session beans), servlets, and JSP

Multi-Platform Integration: Built interfaces between Oracle, DB2 UDB, and mainframe DB2 systems using custom ETL processes

SOAP/XML Integration: Developed "Electronic Hub" for B2B integration with major automotive manufacturer using early web services standards

Mobile Innovation: Designed prototype wireless application for truck drivers using Motorola phones and WML

Handheld Integration: Built interfaces for Windows CE devices with 802.11B wireless and barcode scanning capabilities

Database Administration: Managed DB2 UDB instances across Windows and Solaris platforms

Technologies: Java/J2EE, IBM WebSphere, EJB, JSP/Servlets, Oracle, DB2, XML/SOAP, ERwin, Windows NT/IIS, Solaris

EDUCATION

Bachelor of Science in Computer Science Clemson University 1987

Summa Cum Laude

PROFESSIONAL DEVELOPMENT

Speaker: WebSphere 2000 Conference, Miami, FL

Technical Author: Published articles on Java EJB, C++ programming, X-Windows, and product reviews in industry periodicals

Community Engagement: Regular presenter at AIX Atlanta User Group

ADDITIONAL INFORMATION

Security Clearance: Eligible for government clearance (extensive government contract experience)

Availability: Open to full-time, contract, or consulting opportunities

Willing to travel: Up to 25%

Contact this candidate