-
Student Information Systems (Harvard T.H. Chan School of Public Health, Boston, Massachusetts,
June-October, 2014 and October, 2015-April, 2016): Coded and modified PL/SQL scripts, procedures,
functions and packages, largely for import and export of data, using the Banner Student and A/R
modules in the Student Information Systems team.
(Oracle 11g R2, Banner 8.6, Oracle SQL Developer, PL/SQL Developer, TOAD).
-
Chip design support database (Contractor at Broadcom, Andover, MA, July-December, 2013):
Provided T-SQL programming and miscellaneous database support in a project supporting Broadcom's
semiconductor design activities (MS SQL Server 2012, SQL Server Management Studio, TOAD for SQL Server
- Energy efficiency program systems:
(Contractor and Application Developer, Conservation Services Group,
Westborough, MA, 2005-2012; using Delphi 7 Enterprise, Oracle 9.2, 10g, 11g, TOAD,
PL/SQL Developer, and various Oracle utilities.)
Responsibilities included programming,
documentation, build and deployment control, ETL
operations such as loading public utility account and
usage data, schema copies, schema maintenance., and a
variety of infrastructure tasks, as part of teams
building and operating complex, mostly two-tier
systems used by an industry-supported nonprofit to
administer a variety of energy-efficiency programs for
both new construction and building retrofits.
-
Remote tank monitoring system: (Software Engineer,
Scully Signal Company, Wilmington, MA, 2002-2003; using Delphi
4 Client/Server, AsyncPro) Made wide-ranging
upgrades to a complex application which handles serial
data from remote fuel tank monitors, and notifies fuel
dealers of low-tank conditions and other problems. Upgrades
included (among many others) additions to message handling
code, repairs to notification messaging (automatic paging,
faxing, e-mail) and report changes. Revised the
helpfile, wrote user's guide, and built a new
installation package for the system.
- International travel industry reservation and
property management system: (as Senior Application Developer,
Acadia Software, Andover, MA, 1999-2001 and as independent contractor
2002-2003; using Delphi 5 Enterprise, Paradox for Windows, MS SQL Server 7)
This is a distributed application involving SQL Server
7 database, MIDAS server, and several MIDAS client and
auxiliary applications, remote and local. Took over
principal responsibility for database analysis,
design, and documentation, and T-SQL scripts and
procedure development; did detailed functional
requirements, wrote Delphi MIDAS application for live
database synchronization and auxiliary applications
such as a data archiver.
- Market and financial information system for the
plastics industry: (as Senior Application Developer,
Acadia Software, Andover, MA, 1999-2000; using Delphi 3
Client/Server, ReportPrinter 3, MS SQL Server 6.5)
Made enhancements to a complex client/server system
for delivering detailed market information and
financial reports on the polymer conversion
industries. Analyzed the large body of undocumented
legacy code, improved the user interface, modified
custom components and developed custom classes for
specialized presentation features. (1999-2000).
- Budget submission and analysis system:
(as Associate, D. Lawton Associates,
Natick and Beverly, MA, 1998-1999, using Java 1.1 servlets,
JRun 2.3, JBuilder 2, Oracle 7, Delphi 4 Client/Server)
Technical analysis, design, and development in Java,
SQL, and Delphi 4 Client/Server on a budget-submission
and analysis project for a major university, in two
phases: A servlet for departmental budget
proposal submission, and a client/server Windows
application used by the financial planning office for
manipulating budget data. For this system, which
was built by a team of 3-5 analysts and developers,
analyzed database needs, developed the new database
scripts, wrote the servlet framework (using JBuilder 2
and JRun 2) wrote the client/server application
architecture and the major budget transaction module.
- Windows Telephone billing report controller
(as contractor at Spectrum Telecorp, Merrimack, NH;
using Delphi 3 Client/Server, Crystal Reports, Oracle 7,
Paradox) Extensive enhancements to a controller for producing
telephone bills and a variety of other telephone usage reports,
with versions for both high-volume production and
customer support. (October, 1997 - June, 1998)
- Manufacturer's proposal configurator:
(as contractor at Apogee Information Systems, Marlboro, MA;
usingDelphi 2 Client/Server, Sybase 11) Programmed security
administration and data entry modules, developed
objects for security uses and error handling, in a
team of 5-7 developers. (June-August, 1997)
- National Accident Sampling System
(as contractor at Volpe National Transportation
Systems Center, Cambridge, MA; using Delphi 2 Client/Server, Oracle 7)
on the team which developed the data collection portion of this
extensive, multilevel, replicated database system for
the US Department of Transportation. Tasks included
interface programming, creating Oracle views,
reporting using QuickReport, and documentation.
(November, 1996-May, 1997)
- Double data-entry master system for clinical
trials (as contractor at MDCI, North Attleboro, MA;
usingParadox for Windows 5 LAN system) Designed and coded a master application
providing a reusable framework for setting up and
administering data entry in clinical trials, including
an auto-generated data entry menu, various security
levels, tracking of paper forms, logging of all user
access to data entry screens, templates for data-entry
screens, and an ObjectPAL code library.
(September-October, 1996)
- Windows document distribution system:
(as independent developer for ITW Devcon, Danvers, MA;
using Delphi 1, Apollo, QuickReport) A two-part
database application for distributing material safety
data sheets, written for an industrial chemical
manufacturer. The production portion extracts data for
a user-specified product group from a master database,
converts its table format with special processing for
specific fields, and prepares scripts for a setup
program. The end-user portion, distributed with the
converted data, produces MSDSs on demand for viewing
or printing, and includes a context-sensitive help
file. (1996-1997)
- Windows Right-to-Know data system
(as independent developer for ITW Devcon, Danvers, MA;
using Paradox for Windows 5 LAN system) This system manages health and
safety data for several companies and produces
material safety data sheets in the sixteen-section,
ANSI-standard format as well as several others.
Designed system architecture and data model, created
and coded forms and ObjectPAL library. Wrote
conversion programs for migration of data from
client's previous flatfile system, a Windows help
file, user's guide, and adminstrator's manual.
Installed system and trained users. (1995-1996)
- Windows Formula Maintenance system
(as Chemist at ITW Devcon, Danvers, MA; using Paradox for Windows 1-5):
A multi-user system spanning the product development lab,
QC department, and health and safety group.
The system maintains information about raw materials,
formulations, hazard characteristics, process instructions,
quality control specifications and QC test results; it produces
automatically-scaled batch recipes with process
instructions in a choice of formats. This system
consists of Paradox forms, reports, scripts, and an
ObjectPAL code library. For this system, did the
entire system design and implementation, including
interface and database design, forms, coding,
helpfile, and administrator's manual. Coding included
specialized, record-level security to restrict
unauthorized changes in formulas and process
instructions. (1993-1995)
- DOS document delivery system:
(as Chemist at ITW Devcon, Danvers, MA;
using Paradox for DOS 3.5): Designed and
consulted on implementation of this DOS Paradox
runtime application which extracted data from the
flatfile MSDS system and allowed its delivery on
diskette to industrial distributors. (1990)
- DOS Right-to-Know data system
(as Chemist at ITW Devcon, Danvers, MA;
using Symantec Q&A 3) Designed and implemented this
flatfile system allowing production of MSDS reports in
multiple formats (1987-88)
|