Solutions
Customer: A Private School (1996) Business Problem:
A local private school wanted a better way to maintain multiyear information related to admissions (Families, Students/Alumni, Inquiries). They needed to track names, addresses, grades, teachers, etc.
Technology Solution:
Cyberwolf Software, Inc built the private school a client server application using Visual Basic 5 as the interface to a Microsoft Access database. The solution included the ability to perform quick-key (Quicken style) lookups and provided the ability to automatically generated the student directory in Microsoft Word. Additional utilities were created to ease the routine jobs of re-enrollment and student promotion. Hunter was provided to the customer as a software tool add-on to provide ad-hoc query capabilities against the Admissions database.
Customer: A Labor Management Company (1997 - present)
Business Problem:
The labor management company manages the installation and dismantle of booths at trade shows (Comdex, etc.). This business is an information intensive business. At the time, the labor management company was using a dBASE application to manage some of the information required by the business. The dBASE application was only usable by the central office. Most of the information was also needed by the remote sales force and city managers on the show floor. The dBASE solution required the central office to relay the information via telephone and fax. The labor management company wanted a solution which allowed the central office to oversee & confirm the information and would also allow the remote employees access for review and creating new orders.
Technology Solution:
Cyberwolf Software, Inc. broke this project down into a variety of phases. First a dedicated NT server was purchased to handle the new database (SQL Server) and provide internet services (IIS) and e-mail services (MS Exchange Server). Next a client/server application using Visual Basic 6 with RDO was built for users in the central office. This application was deployed to 20 desktops in the central office. The next step was to build a web application that allowed read-only access to the real-time information in the SQL Server database. This was accomplished using Visual Interdev (ASP, JavaScript, DHTML). The web application has been further modified to allow employees to create and modify orders and customers to create orders. The project is on-going and Cyberwolf Software has added approval features and XML technology to view customer invoices. Hunter is used as the customers’ ad-hoc query tool to retrieve information from the SQL Server database.
Customer: A Fortune 500 Chemical Company (1998)
Business Problem:
The Chemical company is a large user of Hewlett-Packard’s Chemstations and Chemservers to perform GC analysis on lab samples. The customer was looking for a solution which would allow the transfer of results (after a review by a technician) to their proprietary QMS (Quality Management System).
Technology Solution:
Cyberwolf Software built a stand alone Visual Basic 6 application using Crescent’s Internet Toolpak that filled the customer’s needs. The resulting solution parsed a report provided by the instrument; repackaged the information into a file suitable for the QMS; ftp transferred the file to a DEC VAX; logged in as an interactive user via Telnet; had the QMS process the file; and, ftp retrieved the QMS results back to the Chemstation. Cyberwolf Software built an additional piece of software to help configure and maintain the mapping information between what the instrument provides and what the QMS requires. A Hunter dictionary was provided to the customer to allow ad-hoc queries against the mapping database.
Customer: A Biology Company (1997)
Business Problem:
The biology company needed to complex post process of Pertussis and Tetanus ELISA plates from an instrument. The instrument generated a text file containing the results that needed statistical and linear regression post processing. Also, the resulting solution needed to pass FDA Validation requirements.
Technology Solution:
Cyberwolf Software took advantage of the inherent features of Microsoft Excel to build the customer a large Excel VBA application. The Excel VBA application read the text file; asked the user for the pertinent information and performed linear regressions and statistical analysis of the results. Results validation proved that Cyberwolf Software’s calculations were correct and their previous solution contained errors that the customer was unaware of. The Excel VBA application was then completely re-documented to comply with FDA documentation requirements.
Customer: A Fortune 500 Chemical Company
Business Problem:
The customer needed a way to control their chemical formulation instrument and communicate between it and their chemical formulation ordering database (Oracle). Basically, they needed a way to streamline and automate these tasks since people resources were getting extremely difficult and costly to secure.
Technology Solution:
Cyberwolf Software used Visual Basic 6 with ADO to build a client/server application that controlled the TECAN instrument (using C++ libraries) and communicated with the Oracle chemical formulation database. This solution is used daily by the customer.
Customer: A vendor of a Fortune 500 Chemical Company (1998)
Business Problem:
The vendor had to supply a file (to the Fortune 500 Chemical Company) which provided all of the barcodes for the products in a palette. Some palettes can have over 12,000 bar codes. The vendor needed a highly reliable application that was easy to use (the vendor uses labor that is physically challenged) to track the barcodes and prepare the file the Chemical Company required.
Technology Solution:
Cyberwolf Software built a standalone application using Visual Basic 6 and Microsoft Access to meet the customers needs. The software could be stopped at any time while building a palette and would maintain a complete list of barcodes. In addition, the software provided the user with a visual cue as to what part of the palette the user was working with. The solution allowed the users to just swipe the products in front of an Intermec scanner. The software also determined the count, insured that no duplication of barcodes occurred and indicated to the user when a layer or palette was completed.