Below are some client-server projects that I've worked on.
|Created a program for a utility company to automatically create a cross-reference list between documents and equipment tags. Involved using VB.NET to programmatically read 2,500 Word, WordPerfect, and NotePad documents and search each document to find every matching occurrence from a list of 30,000 possible equipment tags. The program produced a list of all matches showing the document name, the found equipment tag, and the context (50 characters before and after the match) in which the tag the was found. This data was then uploaded into the company's enterprise system so that for any equipment tag, the related documents are readily accessible.|
Implemented a process to extract data from an Access database and ultimately load compressed, segmented Word documents into an Oracle database to be utilized by the PassPort utility-industry software.
Involved creating a VB.NET program to gather information from the Access database, compress indicated Word documents (after doing a wildcard search to ensure exactly one document exists where the beginning part of the file name matches part of an Access field), and do binary reads and writes in order to write the compressed Word document out in 4,000-byte chunks which is the expected format for the Oracle database.
The VB.NET program creates three sets of control and data files that are then ported to a Unix machine and loaded into an Oracle database using the SQL*Loader utility which loads both the textual data as well as the binary data.
|Designed database and wrote Visual Basic programs to post many types of incoming EDI transactions to an Oracle database: purchase orders (850), invoices (810), advance ship notices (856), ocean container status (315), customs entry status (857), customs transport status (350), consolidated freight station status (861). The following outgoing transactions were also generated: discrepancy reports (214) and advance ship notices (856).|
|Wrote Visual Basic programs to create EDI transactions to be fed to a custom mainframe application, to SAP, and to trading partners.|
Designed and coded a shipment tracking system so that shipments can be tracked in detail
from the time they leave a factory overseas, through various events and destinations, until
they arrive at a distribution center in the U.S.
The shipment tracking system is web-based and uses Oracle for its database. Visual Basic programs handle the posting and updating of EDI transactions; and active server pages and DLLs present the information to the users.
|Used VBA (Visual Basic Access) to create a spreadsheet with built-in edit checking.|
|Created reports based on data extracted from an Oracle database via Visual Basic. Reports are created programmatically as spreadsheets via ExcelWriter interface. Spreadsheets are emailed to users based on configuration data stored in the database and configured via ASP pages.|
Designed database and created program that automatically posts lab results to a medical practice's patient database (Access database).
Involved writing Visual Basic program to read EDI HL7 data, interpret it correctly, match it up to the proper patient records, and post it. If matching patient data cannot be found, data is posted to an error database along with the reason for its rejection so that any issues are flagged to be manually addressed by the user.
Integrated and enhanced two existing systems to create a fully functional resource scheduling
application running against a SQL Server database.
Enhancements were done in PowerBuilder 5.0 and involved heavy use of custom user objects and classes that facilitated display and entry of dates and times in a calendar-like format.
Developed a new system to be marketed as an engineering tool to facilitate factory automation.
Allows engineers to visually build and debug programs that control robotic components.
The system is written with Visual Basic and uses Access for the database.
OCXs used include: Crescent, Sheridan Software's DataWidgets, Protoview's Interact, Delta Tau's Ptalk, and Pinnacle's Graphics Server.
Developed a new system to simplify the process that screen printers must go through in order
to run their business.
The system automatically determines raw materials needed to fulfill customer orders and then produces a list of these items, taking into consideration items that are currently in stock, so that only necessary materials are ordered.
All code was done in PowerBuilder, using SQL Anywhere for a database.
|Coded enhancements to a dispatching system in a PowerBuilder environment. This involved creating new screens/windows, updating a Watcom database, and reading and creating sequential files.|
|Designed and created a time entry/reporting system, in PowerBuilder/SQL Server, for use by the application development team. This system enables tracking of projects to determine if they are on budget and allows for comparison of different types of projects (e.g. maintenance vs. new development; client-server vs. mainframe).|
|Assisted in coding Artificial Intelligence program to automatically classify garments and generate commercial invoice descriptions, which are required by customs for importing.|
Performed analysis, design, spec writing, design reviews with client, and programming for a
new customer service system.
Designed the database for the new system in a PC/LAN environment; coded programs using RM-COBOL and RM-PANELS; used Btrieve as an interface between the COBOL programs and the LAN.
|Designed and coded programs in dBASE III Plus; wrote user and administrator manuals for the custom software; trained users on newly installed systems.|
Home Client-Server Client-Server Projects
||Top of Page|