Robert Jay Spector

Beverly, Massachusetts
Request contact information at
http://www.scguild.com/Resume/4424I.html


See my LinkedIn profile at www.linkedin.com/in/robertjspector

  • Full-cycle development of relational database applications: analysis, specification, table and user interface design, coding, testing, builds, deployments, documentation, ETL, and user training

  • Unique mix of experience in business software development, chemical product development, and regulatory affairs

  • Graduate training in chemistry, polymer science, computer science, statistics, and design of experiments; prior career as an industrial chemist

TOOLSETS
  • Extensive experience: PL/SQL, T-SQL, Delphi, ObjectPAL (Paradox for Windows)
  • Other experience: Java, Perl, HTML, CGI, BASIC, PHP
  • Platforms: Windows, Unix/Linux, DOS
  • Development environments: Delphi, TOAD, PL/SQL Developer, Oracle SQL Developer, MSSMS, Paradox
  • Databases: Oracle, MS SQL Server, Paradox, InterBase/Firebird, Access, Sybase
  • Ancillary tools: SQL*Plus, SQL*Loader, QuickReport, Crystal Reports, RoboHelp, InstallShield Express, SetupBuilder, Visio, MS Office

PROJECTS AND ACCOMPLISHMENTS

Database and other application development...
  • 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)
Hardware and Systems Support...
  • Provided PC and network repair, installation, and technical support to a local nonprofit organization which supplies refurbished computers to low-income families.((as volunteer, Beverly Bootstraps Food Pantry, Beverly, MA, 2003-2006)
Chemical Product Development...
as AChemist, ITW Devcon, Danvers, MA, 1987-1995 and BChemist, 3M Corporation (and predecessors Materials Research and ECC Divisions of High Voltage Engineering Corporation), Burlington, MA, 1979-1986...
Over fifteen years' experience developing and testing a variety of products, mostly polymer-based, using thermal analysis (DSC, TGA), infrared spectroscopy, mechanical and electrical testing equipment mixing, milling molding, and extrusion equipment among others to create and improve...
  • Epoxy compounds  for coating and machining applications, including acid-resistant coatings and high-temperature epoxy formulations A
  • Waterborne and solvent-borne inks A
  • Spill sorbent productsA
  • Solvent and detergent cleanersA
  • Radiation-crosslinkable and thermoplastic materials  including heat-shrinkable polyolefin and fluoropolymer products, elastomers for cable jacket repair, and thermoplastic sealantsB
  • Led team of professionals and technicians for developing materials, design, and testing of heat-shrinkable electrical connection devices. B
  • Conducted and directed qualification testing of materials and devices to UL, CSA, MIL, and customer specifications. B
  • Maintained competitive-patent awareness program, and acted as reference librarian for printed and online technical resources. B
  • Received US patent 4965410, for an improved connector design. B

Regulatory Affairs...
  • Wrote and revised material safety data sheets to Massachusetts, federal, and specific customer requirements. A
  • Programmed and maintained SARA hazardous materials inventory reporting system and produced SARA section 501 reports. A
  • Designed and implemented microcomputer systems to minimize the costs of process engineering and regulatory compliance. A

EDUCATION
Reed College, Portland, Oregon:   B.A., Anthropology, 1971
Oregon State University, Corvallis: B.S., Chemistry, 1979
University of Lowell, Massachusetts: Graduate work, Polymer Chemistry: Courses in organic chemistry, polymer science, plastics engineering, electronics; thesis work on compatibilized blends of polystyrene and poly(ethylene-co-vinyl alcohol).
Harvard University Extension: Courses in statistics, mathematics, electronics, C++
Northeastern University:   Graduate courses in design of experiments, FORTRAN, thermodynamics, materials science