PROJECT WORK EXPERIENCE: 

Drug and Alcohol Testing Network Enterprise System

This system was developed for an organization that is a drug and alcohol testing network.  The organization locates drug testing labs and urine collection clinics around the world and provides that network of information to companies worldwide.  They function as the middleman between the subscriber of the service and the collection clinic by handling all association billing that occurs.  Omni developed the integrated business system that captures information about their customers and the located collection clinics.  It contains complex matching logic to provide a customer with the collection clinics that are nearest to the customer’s location.  The system handles the invoicing of customers and all accounts receivable functions.  Accounts Payable is handled through a system interface to the SBT accounting package.  The system is object-oriented in design and componentized using COM objects.

 Environment:  Visual Basic 6, SQL Server 7.0, Crystal Reports 8.0, COM, Microsoft Transaction Server, Rational Rose.  

Corrective Action Tracking System

This system was developed for a leading manufacturer of air movement and control equipment; e.g., industrial fans and blowers.  The manufacturer had developed an in-house single-user Paradox application to track problems (Corrective Action Requests) discovered in the manufacturing process.  Omni Resources developed a new multi-user CAR tracking system accessed via the company’s intranet.  The project was designed using Rational Rose as the modeling tool.  The system was developed using Borland Delphi 4.0, using COM data objects and ActiveX controls on the client side.  The database for the system was Microsoft SQL Server 7.0.  The WEB browser was Microsoft Internet Explorer 4.0.  The application also interfaced to corporate data on a DEC/Progress database and to Microsoft Exchange to provide email services.  

Environment:  Rational Rose, Borland Delphi, COM data objects, ActiveX controls, Internet Explorer, SQL Server, Microsoft Exchange.  

Online Web Tax Forms

This system was developed for a provider of electronic tax forms and tax form processing.  This project involved taking encrypted tax return information collected at a web site, securely transferring it over the internet to a staging computer, decrypting and verifying the returns and transferring them to another system that further processed the returns to the IRS.  Then the system had to take the acknowledgement data from the IRS and return it to the online system where individuals could view their refund status information.  This system included an online, web based administration interface, error and system logs, email notification to individuals of their return status if they provided and email address, automatic filtering of valid email addresses, 128 bit SSL transfer encryption and management of thousands of files.  The system was written using Perl, Java, Korn shell scripting and the Netscape Enterprise Server for Solaris.

 Environment:  Rational Rose, Perl, Java, Korn K Shell, Netscape Enterprise Server for Solaris.  

 Logistics and Warehouse Management System

This system was developed for a freight consolidater that ships millions of pounds of freight each year to the US and Canada.  Omni developed an integrated business system that combined shipment data entry, logistics, warehouse document management and invoicing with a dynamic web site that allows the client’s carriers to update shipment status information and members to tender shipment information and view status via the Internet.  This application included parts of three different systems written in combinations of Visual Basic 3, Visual Basic 4, Access 2.0 and Crystal Reports.  The final solution uses Visual Basic 6.0, Access 97, Crystal Reports, Visual InterDev and MS SQL Server to organize the loading, planning, shipping, invoicing and reporting functions of the system.  All major functionality of the system is componentized using COM objects so that key functions like rate calculation can be done with the same code from a thin VB client, a spreadsheet, the web server or the full invoicing system.  This not only ensures that a change in an important business rule for invoicing will propagate to other systems but that separate code does not have to be maintained for the other parts of the system, reducing development time and increasing reliability.

 Environment:  Visual Basic 3,4,6, Access 2.0, Crystal Reports, Access 97, Visual InterDev, SQL Server 6.5, COM, Active Server Pages