|
Up
| |
THEODORE LOUIS PALMER
314-994-1621
EDUCATION:
Texas Christian University; Fort Worth, Texas.
B.S. in Computer Science 1982
DeVry Institute of Technology; Chicago, Illinois.
A.A.S., Electronics Engineering Technology 1967
VENDOR CERTIFICATION:
Sun Certified Programmer for the Java 2
Platform
PROFESSIONAL EXPERIENCE:
2005-April to 2005-December
Monsanto (As a consultant for
Technisource, Inc.)
Designed and created tables
and queries in Microsoft Access and PL/SQL functions in Oracle to perform
preprocessing of billing data from 3 different cellular telephone vendors, a
remote access server (RAS), and voice conferencing bridge equipment. Provided
production support by using these software components to load the data from these
sources into a 3rd party vendor product (Pinnacle) written in Oracle
PL/SQL. Designed and used tracking procedures to guarantee that all data gets
loaded and loaded only once. Coordinated and directed the work of others in the
research and revision of application data needed for reconcilation to
application business rules.
2004-February to 2005-March
SBC (As a consultant for
Cymbal Corporation)
Performed software maintenance changes for: client side application software written in
Visual Basic .NET, and PowerBuilder. Server side software written in UNIX Korn
Shell script, Windows NT Shell script, VB.NET, and Microsoft SQL Server 2000
script. The applications were a billing system for operator assisted long
distance telephone calls (VB.NET & MS SQL Server); an Operator Services
statistical package backend DB (MS SQL Server); an Operator Services
performance review and positive discipline recording DB (PowerBuilder &
Oracle); and an ad hoc and scheduled distribution of E911 data (VB.NET with MS
Access DB and a FTP interface to IBM mainframe).
In Microsoft SQL Serve 2000, I performed: ad hoc queries and updates to
fix flawed data; replicated databases for backup and testing purposes;
identified, extracted, and setup test cases; created from scratch a script that
moved old data from the main database to an archive database to resolve
performance issues; made maintenance changes to stored procedures. The technical
environment for: client side software was Windows 2000 Professional and Windows
NT Workstation; server side software was Oracle Server version 9.2 and
Microsoft SQL Server 2000 database servers; HP-UX Unix version 11; Windows 2000
Server; and Windows Server 2003 Network Operating Systems. Performed
administration for databases and network as needed in support of 5
applications.
2003-May to Present
Subcontractor to Omnitec Corporation
Performed maintenance changes and custom reports on various Microsoft
Access applications for small and medium sized businesses. Performed
maintenance changes and trouble shooting service for small office networks and
end user PCs.
2000-November to 2002-August
Monsanto (As a consultant for Sykes
Enterprises, Inc.)
Environment: UNIX – Compaq True64, Oracle 8.1.6,
T.O.A.D., Autosys, Acta, Microsoft Visual Studio and Microsoft NT Server
 | Created and maintained Oracle PL/SQL as Stored
Procedures, Functions, Triggers, and SQL*Plus scripts in support of a Data Repository
application that extracted data from an SAP ERP System implemented in Oracle and made the
data available for extraction by domestic and international Data Warehouses via Oracle
DB-Link and Oracle Export. |
| Performed maintenance changes on Acta objects which is
a 3rd party software product designed for the extraction of data from SAP
pooled, clustered, or transparent tables. |
| Used Visual Basic for miscellaneous support programs
such as archiving job logs and mass changes to Oracle SQL*Plus scripts. Created
miscellaneous reporting functionality in MS-Access for reports on application metric data
and error logs collected in Oracle tables. Created Automated Pager functionality using
Oracle Jserver Option and e-mail. |
| Created and maintained UNIX Korn Shell scripts for
batch execution of Oracle Stored Procedures, Oracle SQL*Plus scripts, and Autosys function
calls. |
| Created and maintained Autosys JIL (Job Information
Language) scripts for the automated execution of batch SQL*Plus scripts and Acta jobs. |
| Created SQL*Loader scripts for loading data from a
variety of flat file formats into Oracle tables. |
| Exported data from many different tables using PAR
files that I created, with Oracle Export utility. |
| Created and maintained Oracle snapshots on remote
tables. |
| Used T.O.A.D. to do almost everything in Oracle and
MS-Excel for project planning and control. |
2000-January to 2000-May
Premcor -- formerly Clark Refining and
Marketing (As a consultant for Kendall Placement Group)
Lead Programmer Analyst
Created a new Electronic Data Interchange (EDI)
application using PowerBuilder 7, Oracle 8.0.5, Microsoft SQL Server 6.5, and MS-Access
for Office 97. This application automated the process of reconciliation of Exchange
Reports of petroleum product transactions between industry trading partners.
1999 July to 1999 December -- Subcontractor
Created validated data entry screens and reports for
an application that is used in the financing of insurance premiums. The application was
written in Visual Basic version 6. It calculated quotes applying the usury laws of
different states; it collected policy detail information and detail information about the
insured, insurance agencies, and insurance companies. It stored all this information in a
Microsoft Access database using DAO & ADO record set objects.
1994 to 1999 Express Scripts, Inc Senior Programmer/Analyst
Responsible for new development and maintenance of application software and
hardware on various client and server PCs and Midrange computers Stratus and HP-9000 using
PowerBuilder, Pro*C, SQL, WordBASIC, and COBOL.
| Maintained an application that encourages
Pharmacy Benefit Management card holders to switch from brand name drugs to generic drug
equivalents. This application was written in PowerBuilder; Oracle Pro*C, SQL*Plus, PL/SQL
Stored Procedures; and Korn Shell UNIX Scripts. Its data is stored in Oracle SQL Server
version 7.3. |
| Administered a FAX Server product (MCI) capable
of sending 5,000 FAX messages per day. Wrote a WordBASIC macro that merged flat file data
from any source into letters to be faxed via the MCI FAX Server. |
| Created a new application named Telephone Call
Logging and Reporting System using PowerBuilder to construct the client executable and
Oracle 7 as the database SQL server engine. Performed all user requirements gathering and
wrote the User Specification for this project. |
| Performed maintenance programming in Stratus
COBOL for two other telephone call contact management on-line applications. |
| Performed maintenance programming and production
support for an Interactive Voice Response (IVR) system that interfaced a telephone Private
Branch Exchange (PBX) to a Stratus host mainframe. The IVR was a part of one of the
telephone call contact management on-line applications. |
1991 to 1994 Electronic Data Systems (formerly McDonnell Douglas Systems
Integration)
Software Engineer
Responsible for maintenance of mainframe applications software and applying new
information technology to business information problems as they are needed by clients.
| Created from scratch a Graphical User Interface (GUI)
client/server front end that integrated CICS applications executing on separate isolated
mainframes. This software was written in Microsoft Visual Basic for Windows and executes
on a LAN PC workstation. Connectivity to the mainframes was via LAN file and communication
servers running under Novel Netware NOS and Novell Netware for SAA. 3270 terminal
emulation was performed using Rumba and Rumba Tools for Visual Basic. Demonstration of
front end upon initial customer delivery was performed using pcANYWHERE for windows remote
access software and dial access telephone line. Customer testing mainframe connectivity
was also provided using a Rumba Protocol Converter, a dedicated private line synchronous
modem and eight telephone line dial access asynchronous modems. Designed and specified all
the hardware, all the data communications connectivity, and all the software for this GUI
client/server front-end. Also directed the work of others as Technical Leader of this
project. Customer was EDS client account Bankers & Shippers Insurance of Burlington
North Carolina. |
| Converted IMS-DL/I calls to DB2/SQL calls in mainframe
CICS and batch COBOL programs using microfocus COBOL workbench running under OS/2 and IBM
LAN Manager NOS. This is one of the mainframe applications accessed by the front-end
described above. Added form letter functionality to front-end described above by creating
additional Visual Basic program code to retrieve mainframe data and pass it to Microsoft
Word for Windows word processing program and update mainframe application with form letter
specific variable data by passing user entered dialog box data back to the mainframe. |
| Performed PL/I software maintenance on a sequential
file processing system for an application that performs DP function of product fulfillment
for magazine subscriptions and book clubs. Processes maintained were customer billing and
market research special offer form letters to select target customer groups. Customer was
EDS client account Neodata/Meredith Publishing. |
| Established configuration management processes for two
EDS Insurance applications which included resolving conflicts in JCL, CICS Maps, COBOL
source code, and COBOL executable load modules. |
| Performed presales research in response to customer
questions for the proposed sale of an EDS Insurance product. The solution proposed
involved a PC front end that integrates by means of 3270 terminal emulation, two
applications executing on different isolated mainframes via a Local Area Network (LAN). |
| Performed maintenance programming in OS/VS COBOL on an
IMS/DB application for EDS Communications customer, Bell of Canada. |
| Performed testing of IMS/DB programs and job streams
for an integrated welfare management and eligibility system (Kentucky Automated Management
and Eligibility System) for the state of Kentucky using JCL, File-Aid, Data-XPERT,
IMS-XPERT, XPEDITER, and Telon. |
| Provided system support including several major
enhancements to an EDS-RSC in-house accounting application that performed all customer
invoicing, tracked third party consultant hours for vendor billing, and provided human
resource management information. This application was written in Clipper database
programming language for the PC. |
| Performed initial program creation from client
specifications of software for a new financial application at the national offices of
Edward D. Jones & Company. The technical environment was IBM OS/MVS/ESA, IDMS, COBOL
II, and XPEDITER. |
| Performed software maintenance on a savings plan
application for McDonnell Douglas World Headquarters. Made changes to a conversational
on-line program. Wrote a batch program for a one-time execution to update savings plan
data. The technical environment was IBM OS/MVS/XA, IMS DB/DC, COBOL, DB2, and XPEDITER. |
1990 to 1991 Independent Software Development
Self-Employed Software Developer
| As an independent software developer, consulted with
the owner of an aviation Fixed Base Operation (FBO) that performed fueling operations for
a major airline and fueling and general ground service operations for corporate jet
operators on the design and development of a preventative maintenance software package for
aviation ground support equipment. |
| Performed maintenance software changes to an
accounting application written in Clipper for Environmental Protection Agency prime
contractor for emergency response. The technical environment was IBM/AT/386, Clipper, and
R&R Report Writer. |
1988 to 1990 Southwestern Bell Telephone Company
Programmer/Analyst
As a programmer/analyst for a Regional Bell Operating
Company, (RBOC) performed software maintenance on both on-line and batch programs for a
human resource management application. Responsibilities for this application included
source code changes to:
| COBOL programs, DBDs, PSBs, MFSs, execution JCL, and
cataloged procedures. Also provided 24 hour a day, 7 day a week, data center support. The
technical environment for this application was IBM OS/MVS/XA, COBOL, IMS DB/DC, XPEDITER,
and Recoder. |
| In support of a payroll application, developed a three
dimensional electronic spread sheet for cross verification of control reports. The
technical environment for this application was IBM VM/CMS, PROFS, and ESS. |
1984 to 1988 Southwestern Bell Telephone
Company
Lead Programmer
As a lead programmer, participated in hardware vendor
selection then designed and coded software for an on-line Operational Support System for a
Special Services Center of a Regional Bell Operating Company. This system collected the
data and tracked the status of customer reports on private line voice and data telephone
service.
This system included:
| an interface to an IMS mainframe application that
emulated IBM 3270 Binary Synchronous Control (BSC/BiSynch) protocol; |
| a fail safe document distribution feature that used
Hayes modem control language and asynchronous data communication techniques; |
| and a remote access feature to users of DEC VT-100
compatible terminals. |
| The technical environment for this application was
Wang, COBOL, IBM 3270 BSC, IBM/PC/XT, and DEC VT-100. |
1966 to 1984 Southwestern Bell Telephone Co.
General Dynamics Corporation
Honeywell, Incorporated, EDP Division
Electronic Technician
Tested and repaired hardware failures in various
kinds of electronic and electromechanical equipment.
ADDENDUM
SUMMARY TECHNICAL EXPERIENCE
Hardware
Hewlett Packard; Stratus; IBM mainframes:
30XX/4381/ES9200; CDC Cyber-170; Wang; IBM and Compatible PCs Pentium/486/386/286/8086;
Microcomputers based on CPU chips: Intel 8080, 8086/8088, Zilog Z-80, Motorola M6800;
Honeywell-200
Languages
IBM COBOL/COBOL II, JCL, PL/I, CLIST; PowerBuilder;
Oracle SQL and Oracle Pro*C; Korn Shell UNIX Scripts; Visual Basic; Wang COBOL and
Procedure Language; Stratus COBOL and Command Macro Language; dBASE and Clipper
DBMS
IMS/DL1 DB/DC, DB2, IDMS, Oracle 7, Sybase SQL
Anywhere, dBASE
Operating Systems
Hewlett Packard: HP-UX
Stratus: VOS
IBM: OS/MVS/XA/ESA, VM/CMS
Wang: VS (Virtual System)
Novell: Netware 3.11 LAN Network Operating System
IBM: LAN Manager Network Operating System
IBM & Compatible PCs: MS-DOS, MS-Windows 3.1,
Windows 95, OS/2
CP/M (Control Program for Microcomputers) predecessor
to MS-DOS
Control Data Corporation: Cyber Network Operating
System
Honeywell-200: Vendor Proprietary
Data Communications Protocols and Hardware
Asynchronous, SDLC, SNA/SAA, BSC/BiSynch, ISO/OSI,
TCP/IP, DEC VT-100 Terminal Emulation, IBM-3174 Station Cluster Controller, Rumba Protocol
Converter, Halcyon Datalink Monitor (DataScope), Ethernet and Token Ring LAN Topologies
Software Development Tools
TSO/ISPF/PDF, VSAM/IDCAMS, MFS & BTS, CICS,
Xpediter, IMS-Xpert, DATA-Xpert, Abend-AID, File-AID, Recoder, Panvalet, CA-Librarian,
Microfocus COBOL Workbench, DataScope (for PCs)
Other Software
PROFS, dBASEII/III+/IV, Clipper, R&R Report
Writer, Rumba 3270 Emulation and Rumba Tools for Visual Basic, C, Pascal, Lotus 123/ESS,
pcANYWHERE, Wygant (IVR) ArchiTalk, FTP (File Transfer Program on TCP/IP Telnet),
Microsoft Word for Windows Macro Command Language, CoSession
|
