Software Engineer Senior

Timothy Fay Senior Software Engineer

Professional summary

Timothy Fay is a senior software engineer and database administrator who has supported applications for a number of industries including utilities, pharmaceuticals, banking, semiconductor, telecom, and insurance, using various architectures such as web (Java/Spring Boot), client/server (Powerbuilder), and mainframe platforms (Cobol/Focus/JCL), on a variety of operating systems. Technology summary

Programming Languages: SQL (30+ years), Powerbuilder (25+ years, version 3.0a - 2022R3), Java (15+ years), Spring Boot (also Spring MVC and Spring Security), JPA/Hibernate, Python, Bash scripting. Databases: Advanced database programming (functions, procedures, triggers, views), database design, and query optimization, Oracle (PL/SQL, Java), Sybase/MS SQL Server (TSQL), Postgresql (PL/pgSQL). Database Management: Oracle (version 7 - 21c, 25+ years), Sybase/MS SQL Server (7+ years), Postgresql

(3+ years). As Development DBA, I managed and deployed database scripting in Production, QA, and Test environments, and released the scripts for implementation at client locations. CI/CD/Quality Assurance: Jenkins build machine configuration and scripting implemented on local servers and in AWS. Compilation and test results published through Jenkins dashboards. Unit testing: Created automated unit tests for SQL and Java using JUNIT, UTPLSQL, and database scripts as part of the daily CI/CD build process. Created automated Powerbuilder test applications using open source libraries.

Powerbuilder Deployment/Code Analysis Tools: Configured Powergen and PBAutoBuild scripts to create Powerbuilder executable files for deployment. Configured Powerbuilder Code Analysis server using VisualExpert.

Powerbuilder PFC: Advanced use of the Powerbuilder PFC library. Migrated older version of the PFC to version 19/22 in support of Powerbuilder upgrades to recent versions. Web Services: Implemented REST and SOAP web service calls from Powerbuilder using HttpClient and RestClient to Java endpoints created with Spring Boot/Spring Security (annotations). Source Control: Git, Subversion, CVS.

Documentation: MS Word, ASCIIDOC, DOCBOOK, and Markdown. Project Management: JIRA/Confluence, using Agile and conventional waterfall approaches. Education

Bachelors Degree In Computer Science - w/minor in Mathematics and French, La Salle University, Philadelphia, Pennsylvania.

Work Experience

Senior Programmer / Analyst, United States Census Bureau, March, 2025 – June, 2025. 1

Timothy Fay Senior Software Engineer

• Development and maintenance of a Powerbuilder 2022 R3 application, in github repositories, running on a Oracle 19 and 21c databases. Provided support for PL/SQL programming, data modeling, and database scripts. Converted Powergen build scripts to PBAutoBuild scripts for deployment of Powerbuilder executables.

Senior Developer, IDEXX Corporation, July, 2021 – March, 2025.

• Migration of Sybase to PostgreSQL database (version 16/17). Converted stored procedures, functions, triggers, and views from T-SQL to pl/pgsql. Created all DBA scripting and data conversion using psql.

• Development and support of a Powerbuilder 2022 R3 / Java (Spring) / application. Responsible for Sybase database design and programming (stored procedures, functions, triggers, views). Created and enhanced powerbuilder and java applications, bash scripts, github repositories, and Jenkins build machine. Implemented web service calls for both SOAP and REST endpoints.

• Environment: PostgreSQL 16, Sybase, Java (1.8), Powerbuilder-Appeon 2022 R3, JIRA/Confluence, Git, Jenkins CI/CD.

Software Engineer, Cygna Energy Services, Oct, 1998 – May, 2021.

• Lead developer for an Electrical Engineering and Configuration application using both a Spring Boot (Java) web application and a Powerbuilder client/server application (from version 3.0a through 2017 R3). Primary database was Oracle (through 19c), making extensive use of PL/SQL. The application was designed to automated complex public safety-related Electrical Engineering calculations and manage change control and construction, in nuclear and fossil/hydro power plants, for utility companies including Southern Company, Entergy, Dominion Resources, Florida Power and Light, Arizona Public Service, South Texas Project, and the Department of Energy.

• Designed and created a data conversion system for importing plant data from a variety of database and file sources with integrated Hibernate validation and reporting.

• Built and optimized Oracle PL/SQL and Sybase/MS SQL Server scripts, stored procedures, functions, triggers, views, and designed related JPA data model repository, services, and controllers. Implemented application security using Spring Security, including LDAP, Active Directory, and JDBC security integration.

• Implemented CI/CD server, and thousands of JUNIT unit and integration tests, to ensure compliance with public safety requirements for complex Electrical Engineering calculations.

• Produced, developed and maintained project SDLC documentation using MS Word, ASCIIDOC, DOCBOOK XML, and Markdown.

• Developed web service interface for Powerbuilder application data and content retrieval from Documentum content management system using DFC library.

• Led requirements gathering, analysis, and provided recommendations for enhancements.

• Environment: Spring Boot/MVC/Security, JPA/Hibernate, Oracle 12c/19c, PL/SQL, MS SQL Server, Powerbuilder-Appeon 2017 R3, CI/CD.

Consultant, Allianz Insurance, 1996 – 1997.

• Lead developer for a Powerbuilder application which processed Co-Insurance claims. 2

Timothy Fay Senior Software Engineer

• Managed Sybase SQL Server, SQL Anywhere, and MS SQL Server databases. Performed database dumps, loads, and recovery. Migrated data using bulk copy program (bcp) with scripts. Developed data pipeline objects to migrate data through Powerbuilder directly between data sources.

• Built and optimized Transact-SQL scripts, stored procedures, triggers, views, and implemented RPC calls directly from the Powerbuilder application.

• Environment: Powerbuilder, Sybase, MS SQL Server, SQL Anywhere, Transact-SQL. Software Engineer, National Semiconductor Corporation, 1991 – 1996.

• Responsible for the design and deployment of Quality and Reliability Systems for the manufacture of semiconductor materials.

• Migrated mainframe system (VM/MVS DB2/Focus) to Sybase/Powerbuilder.

• Environment: Powerbuilder, Sybase, VM/MVS/JCL, DB2/Focus. Rhone-Poulenc Rorer Pharmaceuticals, Inc., 1989 – 1991.

• Development and support of sales and marketing systems.

• Environment: VM/MVS/JCL/Rexx, DB2/Focus/Nomad.

Consultant, 1988 – 1989.

• Development of telecom systems (Pacific Bell) and banking applications (Wells Fargo).

• Environment: VM/MVS/JCL/Rexx, DB2/Cobol/Focus/Nomad. Systems Engineer, Bank of America, 1987 – 1988.

• Responsible for the problem resolution of hardware, software, and network issues in the production environment for point of sales and money transfer systems.

• Completed the Bank of America Management Training program for Information Systems professionals.

• Environment: VM/MVS/JCL, Cobol.

For more information: Timothy Fay 925-***-****), **********@*****.*** 3

Contact this candidate