Project Portfolio for Michael Mullins
Web Graphics Rendering
Internet Banking Signup
Order Tracking web site
EDI and Point-of-Sale integration
Quotes, Sales Order, and Assembly Ticket system
Chemical Inventory, Receipts, Batch Consumption, Efficiency, Costing system
Union Payroll Integration
Order Entry / Shipping / Accounts Receivable integration
Shop Floor Production Order Release system
Parts Inventory and Work Order system
Membership Management and Lock Box Dues Accounting system
Automated Data Collection, Storage, and Distribution system
Sample Applications & Work-in-Process
Business Card Imprint Layout
Client Side Manipulation of Graphical Elements using Dynamic HTML
Quotations: Client-side XML/XSL
Client-side Rendering of HMTL Using XML/XSL (Requires Internet Explorer 5)
Quotations: Server-side XML/XSL
Server-side Rendering of HMTL Using XML/XSL (cross-browser compatible)
Visual Interdev, FrontPage, Access, Active Server Pages, ActiveX Data Objects
Web site for enrolling customers for electronic banking services
Developed an online banking enrollment application to sign up internet customers on a secure site. Cross-browser support and both client-side and server-side data validation routines were developed to maximize integrity of input data. Validated data is committed in real-time to an Access database and forwarded via email to the applicant and to Customer Service Representatives.
A separate back office system was developed to transfer new enrollments through several firewalls via XML into a master database for mail merge acknowledgements and subsequent transfer into the electronic banking system.
Visual Interdev and Internet Information Server, MS Access 95, ODBC
Web site for order tracking by customer; companion secured extranet for
performing database maintenance
Developed a web user interface to a customer order tracking database which provided order status and delivery information to a major contract customer over the internet. A companion secured web site provided access to the database for additions and changes.
Channel Retailer Visual Basic, MS Access 95 EDI (electronic data interchange) and Point-of-Sale integration
Programming to transfer sales and inventory data from a commercial point-of-sale program into an EDI transaction set for transmission through the ADVANTIS network. An abstract layer was established between the code and the FoxPro inventory database in the form of an Access query to select and transform the data. This provided a very simple method for handling a planned change to a btrieve based Point of Sale system. The Access query was re-attached to the btrieve data source, and no change at all was needed for the Visual Basic EDI data translator code.
Channel Retailer MS Access 95 in Access BASIC Custom Quote, Sales Order, and Assembly Ticket system
Automated the import of distributor's inventory database in dbase format with 60,000 SKUs. Access BASIC routines used DDE to generate email message to the distributor auto-response system to trigger weekly transmission of the inventory. When an updated file was received, handler programs notified the administrator to schedule data import. Upon entry to the system, sales person was notified that inventory updates had occurred and they could print a report of quotes with item cost changes that may require re-pricing for the customer.
The main sales person routines provided real-time quote generation using a shopping basket methodology. While speaking with a prospect over the phone, the sales rep could search for items, quote prices from a table of pre-calculated margins, check stock status for multiple warehouses, advise customer of special circumstances such as constraints and non-returnable items, and add the item to the shopping basket.
After adding all items, the quote could be printed and optionally a FAX cover or envelope could be selected. Quotes could be converted to sales orders upon proposal acceptance, and open orders were tracked through receipt of goods, assembly, and delivery.
MS Access 2.0 in Access BASIC
Chemical Inventory, Receipts, Batch Consumption, Efficiency, Cost system
Developed a database application to track chemical inventory and usage from receipt through delivery. An interesting aspect of the project was a self-modifying design of the storage vessel calculation routines. Process and storage vessels used geometric formulas supplied by an engineer to calculate the weight of the tank contents. The system was designed to store the formula as data in the database and then automatically define a program function to implement the formula. The design made it easy for engineers to add and change vessel equations, and obtain the weight of tank contents for inventory calculations without calling in a programmer for every change. This feature of the system was used successfully to bring up an entirely new vessel in only 3 hours rather than several days that would otherwise have been required to code new logic for input routines, reports, and testing.
Other unique elements of the system involved programming for handling materials that were received in pipelines, tank trucks, and rail cars. Chemicals had to be accounted for in the cost system not only in terms of weight, but by concentration of solutions, and percentage of water for solids.
Automotive Parts Manufacturer MS Access 2.0 in Access macros Union Payroll Integration
Developed a union payroll front-end to Great Plains Accounting payroll. The payroll module did not resolve multiple pay rates per period, shift differentials, or temporary re-assignments in departments or job codes. The integrated logic attached an Access database to the Great Plains btrieve tables for lookup of the assigned employee/department/shift/job/rate values. The payroll clerk could generate a default batch based on the standard employee assignements and then override specific transactions in the case of temporary re-assignments on the shop floor. The resulting transaction set was imported into Great Plains through the Import Manager module for batch processing, check printing, and accumulation for W2 forms..
Automotive Parts Manufacturer MS Access 2.0 in Access BASIC Order Entry / Shipping / Accounts Receivable integration
Developed an Order Entry System with unit pricing resolved for standard catalog price, customer discount, volume discount, and customer quoted price methods. The system produced production scheduling and shipping documents and reports automatically upon entry by sales clersk. For out-of-stock conditions backorders were produced based on shipping/production clerk directions. Shipped orders were transferred daily into Great Plains A/R for posting to customer accounts.
Automotive Parts Manufacturer MS Access 2.0 in Access BASIC Shop Floor Production Order Release system
Developed a custom system to schedule production and track standard order releases for die cut parts purchased by Ford, GM, and Chrysler.
Welding and Truck Body Repair Shop MS Access 2.0 in Access BASIC Parts Inventory and Work Order system
Developed a system to keep parts inventory, receipts, and cost data. The work order system printed shop orders and relieved inventory for items used in the repairs. A repair and maintenance log was kept for company owned vehicles. A direct pay sales tax report calculated state tax remittances on taxable purchases.
Fraternal Organization Q&A and Turbo C++ (DOS based) Membership Management and Lock Box Dues Accounting system
Developed a system to manage member information and track dues history. Printed dues notices and payment receipts.
Medical Laboratory Service IBM BASIC compiler (DOS based) Automated Data Collection, Storage, and Distribution system
The client's former method of receiving test results from the testing laboratory was via ascii terminal login to a unix system and requesting reports be printed to a local attached printer. Reports were received in order of test completion by the lab rather than by doctor or hospital. This resulted in hardcopies having to be bursted, hand sorted and manually distributed by courier resulting in delayed delivery to outlying facilities. Many requests from doctors for results reporting over the phone consumed tremendous customer service resources.
No storage and retrieval was possible, only printed copies were received, and were very weakly formatted resulting in protracted time required for doctors to interpret the reports. Additionally, no indicator showed which test results of a panel were out of range, so the doctors had to visually compare each test result to the normals range and assess the result. Daily preliminary reports for cultures that required several days to complete were not culled out from hardcopies, so doctors spent an inordinate amount of time reviewing reports that were not final.
A system was developed for automated login and download of the report data to disk using a pre-determined dialog much like a human operator. A program then parsed the transmitted data and stored patient information and test results in discreet fields and records within a database.
Report programs then provided a strongly formatted columnar report for final completed panels with the addition of interpretation aids that denoted out-of-range results. Additional programs sorted the tests by doctor/hospital destination and either printed test reports for timely manual distribution or transmitted reports in batches to modem attached printers at outlying hospital locations.