RESUME

 

Thomas A. Costanza, III

 

 

 

  1989 - Present

   Costanza & Associates, Inc.

 

   President

   Skill summary and history

   Design, programming, maintenance, of software projects, specializing in IBM style PC hardware;

               Programming:

                        Microsoft Visual Basic including .NET (Microsoft Certified)

                        Microsoft Access (Microsoft Certified)

                        VBA

                        VBScript

                        Active Server Pages (ASP)

                        JavaScript

                        ActiveX

                        COM

                        Oracle

                        SQL Server

                        Paradox / Paradox for Windows

                        C

                        Clipper

                        FoxPro

                        dBase

                        80x86 Assembler

                        Delphi

                        Crystal Reports

            Trainer for:

                        VB

                        Access (all levels beginner through programming)

                        MS Office products

            Author:

                        articles for Paradox Informant and Delphi Informant

                        articles for Wrox VBToday (works in progress)

                        speaker at Borland Database Conference

 

Certifications:  Microsoft Certified Professional

Member of:  American Mensa, Ltd.

 

Testimonials and references available upon request.

 


 

Recent Experience

Eric Hening Promotions

August 2002-October 2002

Language VB.net/Access/Crystal Reports

 

Converted an application I had previously written for this client from VB6 to VB.net.  This is a multi-user scheduling system to assist client with various steps required to produce concerts and comedy shows.  The back-end was MS Access to allow interfacing with an existing system.  The front-end was in VB6 and was converted to VB.net.  The system allows user to enter templates consisting of steps for a generic show.  When an actual show is booked, and the playdate is known, an actual show is created from a template.  This lists several dozen steps to be completed and a due date is shown along with the person responsible for that step.  When the step is completed, the date it was completed is entered.  A manager can now see what needs to be done for any given time period for any given show.

The Visual Studio wizard was used for some of the conversion, but much of the code was re-written in VB.net.

_______________________________________________________________________

 

AT&T

June 2002-July 2002

Language/Products:  VBA/Access; MapInfo

 

Ongoing maintenance of software I developed several years ago.

________________________________________________________________________

 

Catholic Charities

March 2002

Language/Products:  VBA/Access

Develop Access database for tracking client visits and reporting on same.

________________________________________________________________________

 

Schering-Plough

August 1999 – February 2002

Language/Products: VB, VBA, ASP, VBScript, JavaScript, Oracle

 

Health Care Management

Develop Access database and VBA program for asthma intervention project.  Data is imported from a text file (received from a health management organization) into the Access database.  Many calculations are performed and stored, the result of which predict a patient’s probability of a medical catastrophe, and to that degree, medical expenses.  Users can perform ad-hoc queries, through a user friendly form, for the top N% of a predictive score and various other criteria.  A report is then produced which indicates which patients are targeted for intervention.  Continuing maintenance of this project.

 

 

Develop Access database and VBA program to produce a myriad of reports from financial data provided by health care insurance companies responsible for above patients.  Reports are created based upon the results of ad-hoc queries made through a user-friendly form.    Continuing maintenance of this project.

 

 

Develop Access database and VBA program to track inventory (the intervention items discussed above) and allow forecasting of quantities required by the client’s sales force.

 

Convert above inventory project for an intranet, using Internet Explorer as a front end.  Converted Access’s VBA to ASP, VB/COM, and JavaScript for the front end, and converted the Access database to ORACLE 8 for the back end.  Continuing maintenance of this project.

 

I developed a second front-end for the above ORACLE database which allowed users to extract data using ad-hoc queries through a user-friendly form, and produce a text file for distribution to a fulfillment vendor.  An MSWord document was created under program control, which was used as a transmittal document.

 

 

Reporting application gets statistical data on web usage from HTML web pages, parses them into MS Access tables and allows users to query and report on this data.  Uses Access and VBA.

 

 

I developed VB front end and Access database for data entry of consultant time sheets and reconciliation of consultant hours to consulting company invoices.  This product tracked and compared hours billed for a project to the projects budget. 

 

 

I maintained an Access/VBA project that tracked the status of proposals and contracts.  Fixed existing bugs and added requested new features.

________________________________________________________________________

 

 

RecordTrak, Inc.

June 1999 – July 1999

Language/Products:  FoxPro (DOS)

Y2K conversion of record tracking system.  Comprehensive search and edit of source code, I/O screens, and reports.  Converted date fields stored as text to real FoxPro date fields.  Modified screens to accept four-digit year.  Tested for Y2K compliance.

__________________________________________________________________

Vanguard Cellular Systems

Jan 1999 – Apr 1999

Language/Products: Visual Basic/Access

I wrote a program several years ago in Access 2.0 for this client.  This program kept a database of all the equipment and phone connections at their many cell sites.  Several modifications have been made since the original product was delivered.  In January 1999 I converted this application to Access 97 and tested for Y2K compliance.  I also added some new functionality and reporting capability.

__________________________________________________________________

Schering – Plough

Sept 1998 – Dec 1998

Language/Products:  VBA/Access

Convert 4 Access 2.0 applications to Access 97 and test for Y2K compliance.  Problems were obsolete controls (Data Outline Control which was converted to Tree View Control), obsolete syntax (recordset.[field name] instead of recordset![field name]), etc.

 

One application ran on an NT Server in the background.  It received files from a mainframe; the mainframe launched a batch file, which launched the Access application.  The Access application imported these text files, massaged the data, and exported text files, which were processed by Oracle Express.  Problems getting Access 97 to run as a background process were finally solved.

 

Another application collected financial data from subsidiary offices through an AS400 interface or directly through keyboard input.  It then reported this data to the company’s main office.  The main problem here was that the Access 2.0 application used a Data Outline Control.  While there was a replacement control for Access 97, it was not supported by Microsoft, and the decision was made to convert it to the Tree View Control.  This was done with the required extensive code changes.

 

Conversion of this and the other two programs required fixing bugs in the original versions left by the previous programmer.

 

Y2K Testing was routine and of little consequence since there was virtually no date information in the databases.

__________________________________________________________________

RecordTrak, Inc.

1997 – 1998

Language/Products: Visual Basic, FoxPro, Crystal Reports

Main project was an accounts receivable and billing program to calculate the invoice, post and track the receivable, post cash received, and print a plethora of reports (aged receivables, cash received, bank reconciliation, etc.).

 

I wrote a VB program to track the documents in various stages through a document imaging system.  This also alerted the users of the software that a problem occurred that required their intervention.

 

I wrote a VB program to convert RecordTrak’s document imaging database into a format requested by one of RecordTrak’s customers.


 

Other Miscellaneous

AT+T

Language/Products: Visual Basic  – Access

Description:

I wrote a Microsoft Access program to model AT+T’s cellular network.  It allowed management to track equipment inventory and unused network capability, and allowed technicians to track circuit interconnection.  Many queries and reports were also necessary.  In addition, they had network diagrams of the system, which were created using AutoCad.  This took hours each month to update, and, because the network was always changing, were always months out of date.  Since the database held the longitude and latitude of the cell sites, I interfaced a mapping program (MapInfo) to the database program using MapBasic (a VB-like product).  This allowed the client to get an accurate network map on demand.

__________________________________________________________________

Language/Products: Paradox for Windows - ObjectPAL

Description:

A synagogue was starting a campaign to raise money from the congregation.  I provided a program to allow tracking of member contributions and reporting for a third party managing the campaign.

__________________________________________________________________

Language/Products: Paradox for Windows - ObjectPAL

Description:

I wrote a programmer’s tool called QBF++, a query-by-form expert for Paradox for Windows.  It allows a developer to present the user with a Paradox form (instead of the query by example grid) and allow the user to enter criteria for the query.  QBF++ creates the form and generates the ObjectPAL code necessary to call the form.

__________________________________________________________________

Prudential Fixed Income Advisors

Language/Products: Paradox for Windows - ObjectPAL

Description

I provided a multi-user turnkey system in Paradox for Windows, which allowed the company to project portfolio performance, based on parameters they entered at reporting time.  Since fees are based on portfolio performance, the program also projected revenues and printed client bills.


__________________________________________________________________

Language/Products: Paradox for Windows - ObjectPAL

Description

I wrote a Paradox for Windows program that would allow data entry of applicants for, and awards of, scholarships.  The program also tracked cash disbursements, and printed  various reports required by the scholarship’s board of directors and auditors.

__________________________________________________________________

K. Hovnanian

Language/Products: Visual Basic - Access

Description:

I designed a program that would track a land developer’s competitors’ housing developments.  This allows the client, through queries and reports, to make comparisons based on various criteria (price, # of bedrooms, etc.).  Several graphs are also available.

__________________________________________________________________

Hewlett-Packard

Language/Products: Paradox (PAL)

Description:

I provided an integrated, multi-user system to process reservations and waiting lists for used inventory.  Interfaces with the corporate mainframe computer included corporate price lists and e-mail.  The inventory lists are obtained from divisions world wide through Lotus spreadsheets, and imported into the system.  Numerous reports were provided and statistics kept to determine the performance of each division.  This project included approximately 10,000 lines of PAL code.

__________________________________________________________________

Lenox China

Language/Products: Clipper

Description:

A program was written to allow the gilders to weigh each piece before applying the gold (tare), apply the gold, and weigh the piece again.  The difference between these two weights is the weight of the gold.  The program read the scale through a serial interface and recorded various information, such as the gilder, type of item, weight of gold, date and time, temperature and humidity, etc.  At any time, the gilder could request the display of a process control graph which showed the gilder his performance as it compared to the department targets and also how it compared to the average of all gilders.  This provides instant feedback to the gilder to let him know if he is applying too much or too little gold.

__________________________________________________________________

Lenox China

Language/Products: Paradox (PAL), "C", Paradox Engine

Description:

This project consisted of connecting a PC to a serial interface on a large industrial scale.  A database program was written allowing the supervisor to enter formulas into the database using codes (to keep formulas secret) for the different chemicals used in glazes.  The operator would now be prompted for 50 pounds of a coded item.  The program would then read the scale and tell the operator to add or subtract whatever difference there was.  It also allowed printing of usage reports allowing the maintenance of inventory.  A side benefit was that the individuals weighing the product were fascinated by the "high tech" nature of the product and productivity increased as a result.


__________________________________________________________________

Carter Wallace

Language/Products: Paradox (PAL)

Description:

I wrote a program to automate printing letters, envelopes, labels, and refund checks for the consumer relations department.  The data was downloaded daily from the corporate mainframe computer to a remote local area network.  The database allows querying for different material to be printed and prints it on either a dot matrix printer or a laser printer as required.  The database is then updated to show the dates each item was printed.  Operators can print reports for any desired criteria, eg. show all product X consumers who received refund checks for the second quarter of 1999.

__________________________________________________________________

Global Financial Press

Language/Products: Paradox (PAL)

Description:

This client wanted to automate their billing procedure.  I wrote a program to maintain a customer list, record work-in-progress, print invoices, calculate profit, calculate salesman commissions, etc.  Typical reports were also designed.

__________________________________________________________________

DaTech

Language/Products: "C", embedded software

Description:

My responsibility for this project was to implement a communications interface between a laser controller and a CIM (Computer Integrated Manufacturing) program which the client used for other controllers.  I inherited some code from a previous programmer for other functions of the controller, which I debugged.

__________________________________________________________________

MedPhone

Language/Products: Clipper

Description:

My involvement with this project was to write a PC program to communicate with a portable defibrillator via a dial-up phone line.  The defibrillator (remotely located) would dial the PC base unit (located at a hospital), and transmit an ID which my program would use as a key to a patient record.  The PC would display patient information to a physician who could set parameters for the defibrillator and instruct it to shock the patient.  The PC also takes care of housekeeping functions such as programming phone numbers into the patient unit, and reading various parameters from the patient unit such as battery capacity, etc.  (This device was reviewed in Popular Science magazine August 22, 1992)

__________________________________________________________________
MedPhone

Language/Products: "C"

Description:

The portable defibrillator described above contained a rechargeable ni-cad battery.  An engineering company designed and I programmed a microprocessor based unit which would charge this battery.  The battery contained a 32 byte non-volatile RAM which held various parameters such as date of last charge, number of times charged, remaining battery capacity, etc.  The software was also intelligent enough to know when the battery was starting to fail.

__________________________________________________________________

Symbol Technologies

Language/Products: "C"

Description:

I assisted in the design of an interface attach a bar code reader’s hardware to several boards installed in the PC.  I then wrote a PC program that would exercise the bar code reader, measure various parameters, and display those parameters to the operator.  There were various tests the operator could perform both for initial testing and later for repair of the pc board.

__________________________________________________________________

Language/Products: Paradox (PAL)

Description:

A client wanted to automate the printing of purchase requisitions for their manufacturing operation.  This program allowed the operator to enter the appropriate information, and print the PRs for their various vendors.  The system would also allow them to copy a batch of previously entered requisitions for a new manufacturing run.

 

 

  1981 - 1989

   Prophet 21, Inc.

 

   1986 - 1989    Manager of Engineering

   Design, debug, interface computer hardware and peripherals for proprietary mini-computer; write and maintain technical manuals; responsible for UL listing, & FCC verification;  software development for: communications, bar-code applications, inventory control,  failure analysis

 

   1981 - 1986    Manager of Technical Services

   Supervise teams of Field Service Engineers, Installation Technicians, and Depot Service Engineers; train above personnel; interface with end user

 

   6/81 - 9/81    Field Service Manager

   Supervise team of Field Service Engineers