Rohm and Haas

Bridge-Soft client;VB, VB.NET and SQL Server consulting contract in from June, 1999 – September, 2005

The original development of QMS occurred through a contract with specialty chemical manufacturer Shipley Company of Marlborough, MA (later acquired by Rohm and Haas).  It was an enterprise quality management system that maintained QC specifications for over ten thousand part numbers and managed the data entry of test results and created certificates of analyses for product shipments.  Technical details of the project included:

  • Developed using Visual Basic 5.0 and 6.0 with a SQL Server back end.
  • A central unattended application automatically rendered and delivered certificates of analysis for every product shipment.
    • The company could not ship product without this system functioning correctly.
    • In the original implementation, warehouse pick lists were pulled from querying the MRP system (PRISM). 
    • This was later replaced with an interface to SAP using the Developer’s Toolkit.  It retrieved the pick list from SAP in XML format, parsed the contents, and then rendered the certificate.
    • The certificate was automatically routed to the appropriate location based upon dynamic customer profiles.  They were printed to one of thirteen warehouses in North America and Europe, exported to PDF and emailed directly to the client, and/or exported to customer-specific XML formats and then uploaded via FTP.
    • Certificate results were wrapped into XML format and uploaded to SAP quality module via SAP Developer’s Toolkit via SOAP protocol.
    • I also wrote a web service to respond to data warehouse requests for data.  This service would retrieve results from the database in XML format and perform a bulk upload to the SQL Server data warehouse using XSLFO.
  • An external web portal was written for Shipley customers to log in and download certificates online.  Security authentication was retrieved from a Lotus Domino server via SOAP protocol.

New England Water Works Association

ASP.NET development contract in September, 2005 – present.

Developed interactive web site for the New England Water Works Association with content management, membership-based services, job posting board, event sign-up, and shopping cart features using ASP.NET with a SQL Server 2005 back end. Recently migrated to VB.NET 2008 and integrated DevExpress control suite.

New England Water Works Association member-only journal download
New England Water Works Association member-only journal download