Sample Projects
 |
In keeping with the goal of developing small custom applications that
leverage much larger enterprise applications, Commonwealth Software developed one that integrates a
CRM system (GoldMine) with the company’s ERP systems (Macola, DBA),
maintaining an ongoing link between these systems for each sale made (Visual
Basic, ODBC, Windows shell programming and DDE application
interoperability, fig. 1).
|
fig. 1, Two screens from GoldBridge application
 |
For the State of Maine, supported the
migration of the mental retardation application (see below), along with 6 smaller
applications connected to it, to an enterprise-scale web-based information
system, providing extensive documentation (Oracle Designer, Oracle Reports, COGNOS,
TOAD, fig 2).
|
fig.
2, “Mapping MR-MIS Applications to SIDI/EIS,” parts I-IV (Part II shown open)
 |
For a medical device manufacturer,
developed an application that handles
CAPA (Corrective And Preventive Action) events in manufacturing,
contributing to client’s success with ISO 9001/2000, FDA and CE medical device
certifications. (Visual Basic, linked to ERP system using Pervasive SQL over
ODBC, fig. 3). Click for more details...
fig. 3, Screen from CAPA
application showing multiple documents
|
 |
For the State of Maine, developed a
statewide information system, operating on seven regional networks (fig. 4,
5), that models the delivery of community-based services for approximately
5000 persons with mental retardation (Dbase, Lotus Approach, LotusScript).
fig. 4, 5, Screen and statewide network diagram from MR-MIS application
|
 |
Developed an industrial machine vision system for
measuring and inspecting microelectrodes in production (Visual BASIC), and
helped develop the accompanying data analysis tools (Access, Excel, fig. 6,
7).
|
fig. 6, 7 Screen and Excel printout from Machine Vision application
 |
Developed an application that manages
verification and transmission across the Internet of fabrication details for surgical
fixtures used in deep brain surgery (Visual Basic, Windows OLE drag-and-drop,
SMTP, 2D/3D graphics, fig 8, 9).
|
fig 8, 9, Screen and vector printout from StarFix Receiver application
|
|