Client-Server
Client-Server ProjectsClient-Server Projects
Below are some client-server projects that I've worked on.
![]() |
Designed database and wrote Visual Basic programs to post many types of incoming EDI transactions to an Oracle database: invoices (810), advance ship notices (856), ocean container status (315), customs entry status (857), customs transport status (350), consolidated freight station status (861). | |
![]() |
Wrote Visual Basic programs to create EDI transactions to be fed to a custom mainframe application, to SAP, and to our 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
|