|
|
|
| |
|
|
|
| |
Silverlight Web Portal |
| |
|
Tools/Language |
| |
|
|
Silverlight, Web Services, SQL Server 2008 |
| |
|
Description |
| |
|
|
The client portal was created to help clients analyze, visualize and report on their data. |
| |
17 Server Data Synchronization |
| |
|
Tools/Language |
| |
|
|
C#, XML, Web Services, SQL Server 2000 |
| |
|
Description |
| |
|
|
This system synchronizes data between our system and 17 of our partner servers. The services synchronize over 200 MB of XML data daily. |
| |
PDA Data Collection |
| |
|
Tools/Language |
| |
|
|
.Net Compact Framework, C#, Web Services, SQL Server 2000 |
| |
|
Description |
| |
|
|
This system was completed and was to be rolled out to 4000 technicians nationwide. The program collects pest management data and synchronizes it with our servers. The system is capable of managing over 10 MB of pest control data on a technician's PDA. |
| |
Copesan Desktop |
| |
|
Tools/Language |
| |
|
|
C#, ClickOnce, Webservices, SQL Server |
| |
|
Description |
| |
|
|
This application was created to allow non-PDA partners to enter and edit pest management data. Functionality was expanded to allow customers to create reports and view pest activity overlaid on physical maps of their facilities. The mapping system allows users to draw their own facilities or import facility layouts from Autocad DXF files. |
| |
Email Notification Server |
| |
|
Tools/Language |
| |
|
|
C#, XSLT, SQL Server 2000 |
| |
|
Description |
| |
|
|
The system allows customer to set pest and deficiency thresholds that will trigger emails when thresholds are hit. |
| |
|
|
|
| |
|
|
|
|
| |
|
|
|
| |
Integration Framework |
| |
|
Tools/Language |
| |
|
|
JAVA, XML, JDBC/MS SQL Server 2000 |
| |
|
Description |
| |
|
|
The project was supposed to supply data access to clients via SOAP. I supplied an interface to the JAVA services in order to persist their data. Data was passed to me as blobs of XML which were parsed and stored in relational SQL Server tables. The product was scrapped for an alterative system (see Automation Desktop). |
| |
Automation Desktop |
| |
|
Tools/Language |
| |
|
|
C#, XML, Web Services, ADO.Net and SQL Server 2000 |
| |
|
Description |
| |
|
|
My piece of this project was to provide a generic data store in SQL Server for our developers and 3rd party plugins. The data store needed to version, checkin/out, secure by user/role and provide a temporary work area to persist data. In a nutshell, the my piece reflects .Net assemblies and looks for exported types. Based on the exported types and their hierarchy, it builds the relational sql tables needed to store the instances of the types. To update/checkin an object, the developer just passes me an instance of the object and I walk the object and it's hierarchy, storing the data in the correct tables, versioning and unlocking the objects as requested. To retrieve data, I have methods allowing developers to query and return objects and any piece of their hierarchy (I return instances of the classes). There is a movement to make this piece of the project a company wide standard for data storage. |
| |
XML Repository |
| |
|
Tools/Language |
| |
|
|
C#, XML, ADO.Net and SQL Server 2000 |
| |
|
Description |
| |
|
|
This project used the Automation Desktop repository as the base of an XML repository. The repository uses XML Schema to configure the SQL tables. |
| |
|
|
|
| |
|
|
|
|
| |
|
|
|
| |
PDM Utility Version 1 |
| |
|
Tools/Language |
| |
|
|
VC++, ODBC, Access |
| |
|
Description |
| |
|
|
The goal of the project was to create a utility that would help manage parts, specifically part attributes and drawings. Future goals included using the part attributes in a Motor Configurator. The first step of the project was to converting a 100+ existing Excel spreadsheets into and Access database. With the data converted, a C++ front end was created allowing users to search and view data. Privileged users where also able to edit and add new parts to the system. Autocad drawings were then linked to the parts allowing instant access for the engineers and shop associates. Additional features were added to allow engineers to check in/out drawings. |
| |
PDM Utility Version 2 |
| |
|
Tools/Language |
| |
|
|
JDeveloper, JAVA Servlets, JDBC, JAVA Applet, HTML, Javascript, Oracle, Toad |
| |
|
Description |
| |
|
|
With demand for the PDM Utility growing at other facilities, it was decided to move this version to the intranet. This version was developed using JAVA Servlets on an Apache Web Server. Using JAVA Servlets, a web API was created, allowing HTML templates to be read and processed by the servlets. The templates contain the basic layout and field names where the database data will go. The use of processed templates allowed a single template to be used for searching, viewing and editing. All future web development will use this custom API. |
| |
Electrical Attribute Database |
| |
|
Tools/Language |
| |
|
|
JDeveloper, JAVA Servlets, JDBC, JAVA Applet, HTML, Javascript, Oracle, Toad |
| |
|
Description |
| |
|
|
The goal of the project was to allow engineers and sales easy access to electrical motor data. Online editing is restricted to engineers to ensure data integrity. Using the API created for the PDM project, 200+ HTML/JavaScript pages were created. Custom Servlets were created to add some functionality lacking in the custom API. |
| |
Autocad 2000 Customizations |
| |
|
Tools/Language |
| |
|
|
C++, VBA, JAVA Servlets, Oracle, Toad |
| |
|
Description |
| |
|
|
In order to tie the custom PDM package into Autocad, a way to checkout drawings was needed. To do this, a custom C++ interface to Oracle was created. This interface replaced AutoCad's default file open dialog. Also, to allow the custom PDM package to automatically update and read attributes from drawings, attributes were added to all drawings with custom VBA dialogs providing the UI. |
| |
Motor Configurator |
| |
|
Tools/Language |
| |
|
|
VC++, ODBC, Oracle |
| |
|
Description |
| |
|
|
Upon completion, this utility was to simplify the designing of new motors. The program will take a customer order request form and determine the best components for the application. The utility will also determine if parts specified by the designers meet all tolerances. The program draws information from the PDM, Electrical Attribute and Business Systems. |
| |
Multiple Where Used |
| |
|
Tools/Language |
| |
|
|
VC++, ODBC, Oracle, multithreaded |
| |
|
Description |
| |
|
|
Our system lacked a way of looking up where 2 or more parts are used on a Bill of Material. I created a utility allowing users to search for multiple parts and/or alternates. The utility is capable of viewing and exporting the bill of materials. |
| |
|
|
|
| |
|
|
|
|
| |
|
|
|
| |
Online Web Catalog |
| |
|
Tools/Language |
| |
|
|
ISAPI/C++, ODBC, ASP, ADO, HTML, Interdev, Informix, Access |
| |
|
Description |
| |
|
|
Designed for a customer and hosted on our site, this system allows authorized users to log in and search for products matching their criteria. The front end of the system was initially designed using ASP. More power was need to dynamically create up to 900+ pages of the catalog so ISAPI was used. Products specifications and pricing is refreshed twice a week by an automatic data dump. Administration pages were created to allow our customer to manage users. |
| |
Online Configurator |
| |
|
Tools/Language |
| |
|
|
ASP, HTML, Javascipt, ADO, Informix |
| |
|
Description |
| |
|
|
This tool, which was hosted on our site, was designed to help customers configure and order products. The rule-based configurator allows for the configuration and purchase of products. Administration pages were created to allow our customer to perform user administration, post product lag times and company news. |
| |
CDROM Product Catalogs |
| |
|
Tools/Language |
| |
|
|
VC++, Adobe Acrobat Plug-In API, Install Shield |
| |
|
Description |
| |
|
|
Created a generic yet customizable search and order form. The plug-in that interfaces with Adobe Acrobat allows users to search the PDF files and click on products in the PDF to add them to a shopping cart. The shopping cart could then be printed or faxed to the company. |
| |
Customer Service Tools |
| |
|
Tools/Language |
| |
|
|
J++, JDBC, HTML, JavaScript, Informix |
| |
|
Description |
| |
|
|
Started to replace existing Unix C tools with web bases JAVA Applets. This project was eventually taken over by a co-worker. |
| |
Automation of Pre-Press/Printing Process |
| |
|
Tools/Language |
| |
|
|
ASP, VC++, ODBC, sockets |
| |
|
Description |
| |
|
|
The goal of the project was to design a system that simplified the job of the printers. The web based utility would take a Customer Order Number, query the database for the applicable documents, telnet to the 3 Terabytes of online storage and move the documents to the printing queue. The custom built telnet client was created based on RFC 854. |
| |
|
|
|
| |
|
|
|
|
| |
|
|
|
| |
Engineering Application |
| |
|
Tools/Language |
| |
|
|
Fortran, C++ |
| |
|
Description |
| |
|
|
This ongoing project consisted of maintaining 16 engineering applications as well as new development. These programs, which were first started in 1972, are used by engineers to design and analyze custom products. (Over 2000 pages of programming.) |
| |
Division PDM System |
| |
|
Tools/Language |
| |
|
|
MS Access, VBA, Paradox, C++ |
| |
|
Description |
| |
|
|
The first step in this project was to convert an old legacy system (Paradox) into an Access Database. With the data in Access, new data and new search screens were added. A C++ utility was created to synchronize part attributes with the mainframe. (Access reliably managed the 200+ Megs of data) |
| |
Transmittal Database |
| |
|
Tools/Language |
| |
|
|
MS Access, VBA |
| |
|
Description |
| |
|
|
This utility was designed to track and create transmittals to and from our customers. |
| |
Fax Redirector |
| |
|
Tools/Language |
| |
|
|
VC++ |
| |
|
Description |
| |
|
|
Our LAN based fax system lacked the ability to redirect faxes from people on vacation to the people covering their positions. The fax redirector allowed users to redirect faxes from the incoming system queue into their own queue. |
| |
Price Book |
| |
|
Tools/Language |
| |
|
|
VC++, MS Access Database |
| |
|
Description |
| |
|
|
This utility aids the service department by allowing customers to easily search and order replacement parts. Data updates are easily emailed to customers for installation. |
| |
|
|
|
| |
|
|
|
Copyright © 2011 PCProg.com. All rights reserved.
|
|