Home Resume Boeing Details Bellevue College Details Programming Projects

Position: Senior Programmer Analyst
Dates: April 1989 to June 2020

Summary

Senior Systems Analyst & Developer with 30+ years of experience in business applications and data warehousing. Expertise in SQL, PL/SQL, C, Java, and Perl, with a strong background in system architecture, data migration, and automation. Passionate about improving operational efficiency through strategic insights and problem-solving.

Technical Skills

Skill Categories

DATABASES

During my 31 years at Boeing, my IT experience has been heavily into databases. I worked mostly on IBM DB2 on the mainframe (OS/390 or zOS) and later on IBM AIX. The database work was to support the configuration information about Dassault Systemes’ CATIA CAD/CAM models first used for the 777.

Second to DB2 was my work with Oracle on Red Hat Enterprise Linux (RHEL). I worked on applications where the database stored information about supplier quality as well as the configuration management of Boeing applications and engineering workstations. I’ve become rather proficient at writing stored procedures in Oracle that use the PL/SQL database programming language. I worked with setting up scripts and makefiles to have Fortran use imbedded SQL instead of calling to another language. I worked with porting Fortran SQL routines to AIX.

SQL

Advanced proficiency in using SQL for DB2 in SPUFI, QMF on MVS, AIX db2 command line and Perl. Progressive thinking of relational database concepts gained from years of working with IBM's DB2. Add SQL processing capability to development environment builds for FORTRAN, Java (SQLJ), and C.

DATA MIGRATION

I wrote scripts to automate the migration of many thousands to CATIA CAD/CAM models into the ENOVIA product management system before the retirement of the legacy application and shift from CATIA V4 on AIX to CATIA V5 on Microsoft Windows. Metadata from the legacy database was used in the migration and entered into ENOVIA. Detailed maintenance and monitoring of Autosys scheduled jobs that pull data from other systems for input into a supplier quality data warehouse application.

PORTING

Ported DB2 data from MVS (aka, OS/390 and zOS) to AIX. Ported application from MVS to AIX with conversion of PL/I to C, FORTRAN. Created Perl build utilities to handle imbedded SQL in C and Fortran for DB2.

SCRIPTING LANGUAGES

Another significant area of my IT experience has been with scripting languages used to automate builds for developers. I worked on automation in mainframe JCL procedures, CLISTs and Rexx. Automation work continued on UNIX (AIX) with Korn Shell, Perl and makefiles. I also assisted with the conversion of legacy PL/I code into C.

SYSTEM ADMIN/CONFIG

I also assisted a work group that I used to be in with configuring RHEL servers (VMs actually). I worked with the root account to install Perl, Oracle client software and so on and then copied over the application software from AIX where I worked on re-configuring it to work on RHEL. Years before Boeing paid for me to go out of state for training on AIX system administration but I haven’t really used that skill.

WEB PROGRAMMING

I spent several years working on IBM WebSphere under the J2EE framework which uses Java in servlets and Java Server Pages (JSP). I worked under popular Model-View-Controller (MVC) paradigm. This application presented information from the system that contains CATIA V4 metadata. I continued my developer support/automation by compiling SQL imbedded in Java or SQLJ.

Position Details

HIRED: 4/17/1989

Computer Appl. Tech. Scientific (J535-4,2,B): 4/1989 - 3/1993
(Mainframe) IMS Testing, CATIA V3 Fortran GII user interface, MVS, JCL, CLIST
Skills: ISPF · Database Development · IBM SPUFI · IBM Query Management Facility (QMF) · CLIST · CATIA GII · Job Control Language (JCL) · REXX · MVS · Fortran · DB2

Systems Analyst Computing (JED4P1): 4/1993 - 11/1993
(Mainframe) FORTRAN, GII, JCL
Skills: z/OS · ISPF · Database Development · IBM SPUFI · IBM Query Management Facility (QMF) · CLIST · CATIA GII · Job Control Language (JCL) · REXX · MVS · C (Programming Language) · Fortran · DB2

Programmer Analyst (JBDG52-49,52): 12/1993 - 1/1999
Porting application from MVS to AIX with conversion of PL/I to C, FORTRAN, created Perl build utilities to handle imbedded SQL for DB2.
Skills: z/OS · ISPF · Ksh · Database Development · IBM SPUFI · IBM Query Management Facility (QMF) · CLIST · CATIA GII · Job Control Language (JCL) · REXX · MVS · C (Programming Language) · Fortran · DB2 · Perl · IBM AIX

Programmer/Analyst-Engineering/Scientific (BDATP3): 2/1999 – 2/2004
Y2K development/testing, creating J2EE user interface on IBM WebSphere, porting DB2 from MVS (aka, OS/390 and zOS) to AIX
Skills: z/OS · ISPF · Ksh · Database Development · CATIA GII · Job Control Language (JCL) · REXX · MVS · J2EE Application Development · ClearCase · C (Programming Language) · DB2 · IBM AIX

System Design Integration Specialist (BCBDP3): 3/2004 – 2/2005
Design, development, integration and test of WebSphere server images
Skills: TCL · Database Development · DB2

Programmer Analyst (BDATP3, BAUE3): 3/2005 - 5/2008
Y2K development/testing, creating J2EE user interface on IBM WebSphere, porting DB2 from MVS (aka, OS/390 and zOS) to AIX
Skills: Ksh · Database Development · J2EE Application Development · ClearCase · DB2 · IBM AIX · SQLJ

Programmer Analyst (BAMBP3): 6/2008 – 2/2013
Data migration and sync of legacy data to ENOVIA. Worked with Autosys and scripts for scheduled jobs. WebSphere app integration into Boeing environment from subcontractors; SQL, DB2Work on data warehouse ETL scripts on Oracle Database with PL/SQL
Skills: HTTP · Ksh · Database Development · Autosys · ClearCase · Data Migration · Oracle Database · PL/SQL · DB2 · Perl

Programmer Analyst (BAMBP3): 3/2013 – 3/2017
Working with Perl and PL/SQL on data warehousing Oracle database application for data auditing and data fixes. Worked with Autosys and scripts for scheduled jobs. Using T-SQL and SQL Server Management Studio for data warehousing on SQL Server database application for data auditing and data fixes in Business Intelligence & Reporting organization. Duties included Production support, supporting SQL Server job queues. Working with data warehouses and data marts in Supplier Quality.
Skills: Database Development · Stored Procedures · Java · Toad · Data Warehousing · Autosys · ClearCase · Oracle SQL Developer · Oracle Database · PL/SQL · Perl · Red Hat Linux · Extract, Transform, Load (ETL) · Microsoft SQL Server · SQL Server Management Studio

Configuration Management Analyst (BAMBP3): 3/2017 – 5/2020
Support applications in migrating to Microsoft TFS-GIT, support Windows ClearCase for developers, help support internal CM database app. ClearCase support follows my experience of many years with ClearCase on UNIX (AIX) and Windows.
Skills: HTTP) · Database Development · Stored Procedures · Toad · Data Warehousing · Autosys · ClearCase · Oracle SQL Developer · Perl · Red Hat Linux · Extract, Transform, Load (ETL) · Git

LAID OFF: 6/5/2020