Uploaded File
add photo
Thomas
goetzt@juno.com
760-815-7236
1770 vallley
Carlsbad, CA 92008
Senior Programmer Analyst
16 years experience W2
3
Recommendations
Average rating
138
Profile views
Summary

  • More than Twenty (20) years of IT experience in application development and maintenance, with more than Ten (10) years in PowerBuilder.
  • Expert at planning, analysis, design, testing and programming, in PowerBuilder client server and n-tier environments.
  • Wrote complex queries, triggers and stored procedures for Oracle, MS SQL Server, and Sybase databases.
  • Specialization in performance issues, migration, debugging, enhancement, installation, release management, testing, documentation and support.
  • Very effective at communicating with expert systems staff, and non-expert systems end-users.

Technical Skills:

  • Languages: PowerBuilder 6.5/7/8/9/10.5/11/12.5 (.NET Web Apps), SQL, XML, Java, COBOL, VB 6
  • Databases: Oracle 7/8/9i /10g (PLSQL), MS SQL Server (2000, 2005, T-SQL, DTS), Sybase 12.5, DB2
  • Operating Systems: Windows 98/NT/XP, UNIX, CICS
  • Tools: Crystal Reports 8.0 and 8.5, Erwin, Business Objects, Jaguar/Easerver, and Visio

Experience
Senior Programmer
Information Technology
May 2014 - present
  • PowerBuilder development and support for small software vendor. Currently converting the existing software package for new applications.
  • Developed applications for tracking gas purchases from vendors to retailers, and enhancements to order entry system.
  • Developed non-visual objects for complex business processes.
  • Performed upgrade from PowerBuilder 9.0 to 12.
  • Recently developed PowerBuilder .net/web forms application.

Environment: PowerBuilder 9/12, Sybase 16, Windows 7.0

PowerBuilder Sybase .NET Web Forms Windows
Remove Skill
References
Average Rating

1 recommendation
Senior Programmer
Government
May 2013 - Mar 2014
  • Led development for Permit applications.
  • Developed complex systems for extracting data from spreadsheets.
  • Developed Windows, Data windows, user objects, and tables, stored procedures and triggers.
  • Worked closely with data modelers, DBA's, programmer and business experts.
  • Migrated PowerBuilder applications from version 8 to 11.5 Production support.

Environment: PowerBuilder 8/11.5 (PFC), MS SQL Server 8

SQL Server PowerBuilder PFC Triggers Stored Procedure Production Support SQL Windows
Remove Skill
References
Average Rating

1 recommendation
Senior Programmer
Information Technology
Sep 2012 - Apr 2013
  • Led development for Maritime applications.
  • Developed systems for estimating contracts and reimbursement of contract costs. Developed windows, data windows, user objects, and tables and stored procedures in SQL.
  • Participated in upgrade from PowerBuilder 11.5 to 12.5.

Environment: PowerBuilder 11.5/12.5, MS SQL Server 8, VB 6

Visual Basic SQL Server PowerBuilder Stored Procedure SQL Windows
Remove Skill
References
Average Rating

1 recommendation
Senior Programmer Analyst
Information Technology
Jan 2012 - Jul 2012
  • Led development for vintage car parts retailer.
  • Troubleshoot defects in design and implementation of legacy pricing system. Replaced large blocks of PB code with stored procedures.
  • Performed upgrade from PowerBuilder 8.0 to 12.5.

Environment: PowerBuilder 8/12, MS SQL Server 11

SQL Server PowerBuilder SQL
Remove Skill
Senior Programmer Analyst
Information Technology
Jun 2011 - Dec 2011

Responsibilities:

  • Successfully bid on and won a contract to deliver design for the implementation of document scanning solutions for the State of Maryland.
  • Developed proposals and implementation and technical design documents.

Environment: Document scanning and storage hardware and software

No skills were added
Remove Skill
Senior Programmer Analyst
Information Technology
Apr 2011 - Jun 2011
  • Develop enhancements to PowerBuilder applications for Department of Corrections.
  • Working from detailed specifications, I cleared a backlog of requirements ahead of schedule.

Environment: PowerBuilder 10 (PFC), SQL Server 2005 T-SQL

T-SQL SQL Server PowerBuilder PFC SQL
Remove Skill
Senior Programmer Analyst
Information Technology
Aug 2010 - Mar 2011
  • Migration of DB2 to SQL Server.
  • Troubleshoot and fix errors in data windows and PowerBuilder and SQL code resulting from the conversion. PowerBuilder 8 (PFC), SQL Server 2005.
  • Work with offshore team to deliver complete customer solution.

Environment: PowerBuilder 8, SQL Server 2005 T-SQL

T-SQL PowerBuilder SQL Server PFC SQL DB2 Windows
Remove Skill
Senior Programmer Analyst
Government
Mar 2010 - Jul 2010
  • Maintenance and enhancement to MACWIS Child Welfare system.
  • Added data entry windows, Data Windows, and non-visual objects to existing system.
  • Work with team to improve performance.

Environment: PowerBuilder 10.5 (PFC), Oracle 10g, CVS

PowerBuilder PFC Oracle Windows
Remove Skill
Senior Programmer Analyst
Information Technology
Oct 2008 - Dec 2009
  • Developed programs for interface between SAP and legacy system.
  • Programmed windows and scripts in the Risk Management application for new functionality.

Environment: PowerBuilder 10, Oracle 10 g, PFC, PB Native version control

PowerBuilder Oracle PFC Windows
Remove Skill
Senior Programmer Analyst
Government
Jan 2008 - Sep 2008
  • Provide application and information systems expertise in support of Child Welfare applications.
  • Within this n-tiered environment, made modifications to PB scripts, data windows and library structures to enhance performance.
  • Participate in the performance management team. Gained an understanding of and participated in troubleshooting Easerver 5. Found performance gains by rewriting areas of PB Application.

Environment: PowerBuilder 10, DB2, Jaguar/Easerver, Java, Windows NT

PowerBuilder Java DB2 Windows
Remove Skill
Senior Programmer Analyst
Information Technology
May 2006 - Dec 2007
  • Maintenance, support and development of child welfare systems developed in PB and SQL.
  • Primary responsibility for full life cycle development of enhancements to 13 applications.
  • Migrated PB systems from version 7 to version 10.5, SQL Server from 2000 to 2005.

Environment: PowerBuilder 7/10.5, MS Sequel Server 2005 (T-SQL)

PowerBuilder SQL T-SQL SQL Server
Remove Skill
Senior Programmer Analyst
Information Technology
Jul 2005 - May 2006
  • Developing complex reports utilizing PowerBuilder Data windows and PL/SQL.
  • Participated in the development and implementation of version control methodology.

Environment: PowerBuilder 7/9, Oracle 9i, DBArtisan, Citrix, Visual Source Safe

SQL PowerBuilder PL/SQL Oracle Citrix Microsoft SourceSafe Windows
Remove Skill
Senior Programmer Analyst
Information Technology
Oct 2003 - Jun 2005
  • Support and maintenance of legal systems developed in PowerBuilder and Microsoft Sequel Server 6.5 in a Windows 2000/XP environment.
  • Performed upgrade of system written in PB 5 to PB 9.
  • Developed background processing using stored procedures, triggers and DTS. Developed reports using Infomaker and Business Objects/Crystal Reports.
  • Used Business Objects/Crystal Reports to access a data warehouse for management reporting.

Environment: PowerBuilder 5/9, VB 6, SQL Server 2000 (T-SQL), LAWPACK, Infomaker, COBOL, Business Objects/Crystal Reports, Oracle 9i, Jaguar/EASERVER, Java

Visual Basic T-SQL SQL Server PowerBuilder Oracle Cobol Triggers Stored Procedure Crystal Reports SQL Java Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
study of Applied Symbolic Logic
Loyola University of Chicago
History of Science and Mathematics
St. Johns College
Wrote
The Evergreen State College
The Evergreen State College
Skills
Windows
2021
13
PowerBuilder
2021
11
SQL
2014
7
SQL Server
2014
5
.NET
2021
4
Oracle
2010
4
T-SQL
2011
4
Web Forms
2021
4
PFC
2014
3
Stored Procedure
2014
3
Crystal Reports
2005
2
Java
2008
2
Sybase
2021
2
Triggers
2014
2
Visual Basic
2013
2
Cobol
2005
1
DB2
2011
1
CICS
0
1
Citrix
2006
1
Microsoft SourceSafe
2006
1
PL/SQL
2006
1
Production Support
2014
1
UNIX
0
1
XML
0
1