Jan Theodore Galkowski

jtgalkowski@alum.mit.edu Smalltalk, SQL, PERL, Object-Oriented Design and Programming, Databases, Data Warehouses, ETL, Data Marts, and the Web 607-754-1115





CERTIFICATIONS

NYS Civil Service Qualification 20219 Senior Computer Programmer-Analyst
Master Brainbench Certification ANSI SQL
Brainbench Certification Data Warehousing Concepts




EDUCATION

Masters
of Science
1976 Massachusetts Institute of Technology Electrical Engineering and Computer Science Thesis and research at MIT Artificial Intelligence Laboratory
Bachelors
of Science
1974 Providence College Physics  
--- 1979, 1983, 1984, 1985, 1993 Syracuse University, MIT, Binghamton University, Cornell Univeristy Computer Science, Mathematics, Electrical Engineering, Geology  




WORK HISTORY

KEYED BY DATES OF PROJECTS IN REVERSE CHRONOLOGICAL ORDER ORGANIZATION ROLE SKILLS USED DESCRIPTION

May 1998-present

Cornell University

Database and ETL Developer SQL, Informix, Oracle, AIX shell scripts, PERL, AWK, 4GL, Ardent/Informix Datastage, ErWin ETL development and physical design for Cornell Graduate School
Marts Analyst and Developer SQL, Informix, Oracle, AIX shell scripts, PERL, ErWin Logical, structural, and physical design, ETL development, and operation in production of Kimball-style star schema marts for pay check distribution and pay detail distribution
Software Analyst and Developer AIX shell scripts, Informix, SQL, PERL, Datastage, PeopleSoft Freeing data marts ETL from legally encumbered scheduling software; migrated ETL schemas and procedures from Ardent/Informix Datastage to AIX shell scripts
PeopleTools and Java Programmer PeopleTools, Java Trained and supported functional employees using PeopleTools and Java
Database and ETL Developer Wiki technology, SQL, shell scripts, HTML Documented data warehouse staging area and marts using WikiWeb technology
Database and ETL Developer Datastage, shell scripts, some SysAdmin, PERL, DBA skills Devised and maintained Ardent/Informix staging area build and load procedures; supported Production Control during operations
Web Developer HTML, CSS, Javascript, CGI, ANSI C, Actuate Paired with two others to design, draw, and develop the Web site which serves as the interface to control and provide deployment of administrative Actuate reports to campus. This site at Cornell accesses various business-related reports and uses Kerberos for authentication. It's not very interesting since it will block visitors missing the proper interrogation.
Web Developer CGI, HTML, ANSI C, Actuate, PERL, Javascript Adapted the Actuate security mechanism and the CUREPORTS Web site CGI and Javascript to use Kerberos as its authentication mechanism
Database Reports Developer Actuate, PeopleSoft, OOD, OOP Developed administrative, HR, and benefits reports drawing on PeopleSoft production data and using Actuate. Shepherded reports into production with signoffs by functional end-users
Object-Oriented Programmer Actuate, OOD, OOP, shell scripts Studied the Actuate objects factory mechanism and device for instantiating reports and report sub-objects, evaluating it and providing recommendations for training

Spring 1999

freelance work, Aero Gymnastics Academy, Vestal, NY

Web Developer HTML, CSS, media, graphics Developed promotional Web site for Aero Gymnastics Academy with very little budget. Turned over to them for maintenance.

1998-present

freelance work, developing utilities for publication on the Web for The Smalltalk Idiom

Software Developer Smalltalk, SQL, Windows, quantitative programming Ongoing publication of Smalltalk goodies, including sample code, SQL script data flow analysis, support for combinatorial calculations using Smalltalk's bignum facility

November 1997 to April 1998

Consulting Software Developer for Aerotek/The Maxim Group at Aetna USHealthCare, Middletown, CT

Web and Database Developer ANSI C, ESQL/C, DB/2, JScript, PERL, HTML, CGI Productivity-measuring decision support tool deployed on corporate intranet
ANSI C, Net.Data, SQL, ESQL/C, DB/2, CGI, PERL, requirements gathering and analysis Redesign of database models and tables, Web interface, Javascript, and reporting C code for productivity decision support tool
Specification writing, data analysis, logical modeling Rewriting requirements specification for productivity decision support tool, including consulting with manangement end-users and negotiating schedule
Crystal Reports, SQL Evaluated Crystal Reports for use in productivity decision support tool on corporate intranet, including trial reporting programs
Net.Data, Web design, HTML Evaluating IBM's Net.Data for use in productivity decision support tool on corporate intranet, including trial reporting programs

May to July of 2000

(freelance consultation, client requested privilege)

Web and Application Developer Smalltalk, Pervasive.SQL 2000, Windows Drop-in application which retrieved scientific data and presented it for display via the Web

September 1999

(freelance consultation, client requested privilege)

Application Developer Smalltalk, Prolog, quantitative programming, Windows Application which sampled data from a real-time stream and presented it in summary statistical and histogram forms on a display

August to October of 1997

Hanukkah House, Temple Concord, Binghamton, NY

Application Developer Delphi Computer-based kiosk which narrates and displays stories and artifacts regarding Hanukkah using a touch-screen-only display on an inexpensive Windows 3.1 system

January to July of 1997

Digicomp Research, Ithaca, NY

Application Developer Quantitative analysis, HTML Reliability calculation for progress report and add-on work proposal to client regarding computing hardware
Quantitative analysis, quantitative programming, Ada95 Assessed accuracy of existing program code in comparison to WGS-84 ellipsoidal Earth model
Quantitative analysis, quantitative programming, Ada95 Built Model and computer codes in Ada95 for making collision anticipation tests and collision avoidance calculations for air traffic control application
Tcl/Tk, X-Windows, OOD, OOP, Ada95 Tool for managing releases of versions of software and documenting their release

February to May of 1997

Broome Community College, Binghamton, NY

Instructor Visual Basic, OOP Course on Visual Basic 4 taught with lab sessions

September to November of 1996

Spider Graphics Corporation, Trumansburg, NY, on behalf of countrydata.com

Web Developer CGI, HTML, PERL, business analysis Developed CGI scheme and supporting HTML for countrydata.com which is a market of information "nibbles". Researched credit card payment terms and software.

August to October of 1996

Spider Graphics Corporation, Trumansburg, NY

Web Developer HTML, CGI, PERL Maintaining customers's Web sites, including making changes per request, investigating and fixing problems, for example

December 1995 to November of 1996

Matrix Munchers, Vestal, NY

Statistician, Software Developer, Web Developer Adobe Acrobat, HTML, CGI, ANSI C, MacOS, PERL, Windows, Statistica/W, quantitative analysis, quantitative programming, PERL Determined feasibility and built prototype for automobile traffic density collection and presentation system for Binghamton, NY
Adobe Acrobat, HTML, Prolog, ANSI C, PERL Electronic shopping map in Adobe Acrobat PDF of greater Binghamton, NY area, with linkages to sites on the Web

March 1994 to December 1995

Loral Federal Systems, Owego, NY



(Loral purchased the Federal Systems Division from IBM in 1994. In early 1997, Lockheed-Martin purchased Federal Systems from Loral.)

Integration and Test Engineering Systems integration, test case design, test case analysis and implementation, R:base, APL, MATLAB, MIL-STD-1750A assembler, debugging, problem isolation, formal problem documentation, regression testing, quantitative analysis, statistics Devised, analyzed, and evaluated statistical tests of performance and capability which were required to demonstrate that a system for delivery complied with requirements demanded of it by its specification
Systems integration, test case design, test case analysis and implementation, R:base, APL, MATLAB, MIL-STD-1750A assembler, debugging, problem isolation, formal problem documentation, regression testing, quantitative analysis, statistics Devised, analyzed, and evaluated tests assessing performance and capability in location-finding and position-finding which were required to demonstrate that a system for delivery complied with requirements demanded of it by its specification

1989 to 1994

IBM Federal Systems Division, Owego, NY

Integration and Test Engineering Systems integration, test case design, test case analysis and implementation, R:base, APL, MATLAB, MIL-STD-1750A assembler, debugging, problem isolation, formal problem documentation, regression testing, quantitative analysis, statistics, geodetic models Integration and testing of hardware and numerical software in a large airborne multicomputer system including supervising programmer-engineer teams, many presentations to customers, reports on progress of development
Systems integration, test case design, test case analysis and implementation, R:base, debugging, problem isolation, formal problem documentation, regression testing Test design, scripting, control to support subsystem integration of portions of a large airborne multicomputer system, including developing unique software to circumvent limitations of GUI-based testing system. Received compensation awards at highest possible levels.

1987 to 1989

Cornell University, Ithaca, NY

Resident Study Program Resident study of digital signal processing and numerical analysis at Cornell Resident study of digital signal processing and numerical analysis at Cornell University in Ithaca, NY, with full salary and tuition paid by IBM
Quantitative analysis, applied mathematics Consulted with IBM FSD engineers regarding a guidance law for a special operations helicopter and suggested a direct equation
Quantitative analysis, statistics, APL Target detection was impeded by temperature and silting characteristics of Persian Gulf. Consulted on means of overcoming sensor limitations

1984

IBM, Boca Raton, FL

PC Applications Programmer PC assembler, PC BASIC (a.k.a. "QuickBASIC") Wrote and published The Forms Designer, an IBM PC desktop application for designing and using business forms, sold to an internal IBM division which developed software idea from IBM employees on an internal basis, written in PC Basic and Intel MASM

1976 to 1989

IBM Federal Systems Division, Owego, NY

Software Engineer PL/1, APL, MATLAB Developed and awarded U.S. Patent 4,803,651, issued 2/7/89, assigned, of course, to IBM
Quantitative analysis, APL Devised alternative methods for testing software consisting primarily of numerical calculations and adapting these to software specifications
Quantitative analysis, APL, PL/1, Fortran Evaluation and development of target detection algorithms and supporting hardware for airborne optical sensors
Ada95 Major participant in the Department of Defense test and evaluation team for the Ada programming language
Functional programming, LISP, ISWIM, SIMD computing Applied research on scalable parallel processing using functional programming
LISP, MIL-STD-1984 (a.k.a. "MCF") assembler, Pascal Rapid Application Development of working (software) models of novel computer architectures for the U.S.Army using LISP as the implementation language
Applied research on provably correct software Applied research on constraining software designs so they are more easily proved compliant with a specification
Fortran, assembly for special USAF computer, APL, support software development Programmer and message database designer for real-time digital communications system, now deployed, and using a semiautomatic means of updating its message definitions from pictorial specifications

Summer 1972

Ciba-Geigy Chemical Corporation, Cranston, RI

Data Processing Programmer (summer intern) Fortran, COBOL Used COBOL and FORTRAN on IBM 360/25, demonstrated ability to link pieces of different IBM-compiled codes using IBM Link Editor





Member number:1707
Go to The Software Contractors' Guild
Home Page.
Go to Jan Theodore Galkowski's Home Page.
Go back to Jan Theodore Galkowski's detailed resume.
Copyright(c) 1995 1996 1997 1998 1999 2000 2001 Jan Theodore Galkowski and
The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257