Netlogistix Logo Netlogistix global connect img
  Applications

 

Database design & Implementation - MS Access & MS SQL Server
Application design, customization & implementation - MS Access, MS Excel, C, MS Word
Data conversion, manipulation, extraction
Data querying & report generation
Modifications & enhancements to existing databases & applications
Installation, customization & configuration of financial software packages - MS Access & SQL Server

PARTIAL LIST
Benefits receipts database
Securities trades tracking system
Credit card manufacture quotation system
Insurance policy processing application
Time logging & tracking system
Inventory control system
UA Accounting Software Customization
Contact management system
Work order database system
Database synchronization system
Encryption programs
Data manipulation system for data export

 
APPLICATION DESCRIPTION

Click on the screen icon to view a screen shot, then click the Back button on your browser to return to this screen

Demutualization Benefits Database - Bank HO (MS Access & VBA)

Manipulation and conversion of spreadsheet data, and import into a database to hold demutualization benefits data for subscribing bank employees.  Simple interface for call center employees, balancing of payments to be made, reporting and output of various payment categories for ADP and SAP import and manipulation.

Top       

Securities Trades Tracking System  - Bank HO (MS Access and VBA)
Multi-user database to maintain trade orders on various securities, print securities in various formats, inventory of notes stock, keep track of maturing securities and outstanding holdings, allow cancellation, exchanges and corrections on notes issued, reporting to meet CDS and other client requirements.
Top           

Quotation system -  Credit card manufacturer (Excel and VBA)
To automate and facilitate quotation production where the manual system meant that each quote would take a minimum of a half hour per set of conditions, and for each quantity. The program also provided several more choices and much greater flexibility than the customer had asked for.  They were given the ability to control some of the facets themselves, such as the entry of various components for their manufacturing, a point which they appreciated. The result:  The customer is able to provide their client with quotes for different quantities with a given set of conditions in less than a minute.  Any change in conditions is easily fed into the system, producing corresponding quotes.  Quotes could be provided over the phone and/or faxed within minutes from the computer.  The saving of several man-hours were put to use in other areas.  Great improvement in customer service. TopInsurance Database for application and policy processing - Brokerage (MS Access and VBA)Database keeps track of various parties and amounts involved in insurance policy processing.  Provides a simple user interface, permits data entry and processing at various user levels, as well as full creation of queries and reports for the management user level.  Policy processing capabilities restricted according to users.  Compulsory and automatic recalculation of policy calculations whenever figures were changed, results in error reduction and recalculation time saved.  Policies have flexibility to have multiple insurers and syndicates/contracts.  Easy reporting provided, quick and simple policy production, as well as simple data maintenance.  Customized navigation.
Top     


Time Log System to track times worked - Furniture manufacturer (MS Access and VBA)
Database imports times swiped in and out, figures out which are times swiped in or out, as well filters them out from multiple swipes, then calculates the times worked based on a list of work orders imported from the personnel agency.  System allows for shifts variation, absentees and unscheduled workers.  Easy interface (one button to import time data and one button to import the daily orders), all calculations and processing are not visible to the user.  Reporting simple for user.  System permitted time adjustments on a per record basis, while allowing for supervisor approval on a group of records basis.  Simple data maintenance and customized navigation.
Top     

Inventory Control system - Plastic card manufacturer (MS Access and VBA)
Database maintains inventory for customer’s clients.  Inventory is adjusted by inventory issues and addition transactions made.  The system maintains the minimum quantities permitted per item, and warns when inventory is low.  Simple interface designed to allow step by step data entry for more efficient and accurate data processing.  Customized navigation, simple data maintenance and multiple choice reporting.

Top       

Accounting Software Modifications & Customization - UA (Unlimited Access) Accounting Software - Various clients (MS Access, SQL Server and VBA)
Various modules including: General Ledger, Accounts Payable, Accounts Receivable, Order Entry, Inventory Control, Purchase Orders etc.
TopContact Management System modifications - Non-profit organization (MS Access and VBA)Integrated Microsoft Application populating various Word documents.  Automation of web database update with selected local database data.  Top    Work Order Database (MS Access and VBA) - ManufacturerMulti user system handled work order entry for different label sizes & types, ink types and quantities.  Selection of order dates, proof dates, due dates and completion dates.
Top     


Database Synchronization System (MS Access and VBA) -
Utility
System to synchronize two databases (the databases need not be MS Access).  Permits selection of tables to be synchronized, as well as selection of fields that should not be synchronized.  Synchronization may be set on a timer basis to update at particular time(s).
Top       


C programs
Encryption and number production programs for plastic card manufacturer:  Programs had to meet with customer’s clients specifications.  Customer’s clients included MasterCard, Bell Canada, Sprint Canada etc.Designed application for customer to handle the majority of encryption and number production, instead of requesting individual programs for different jobs.Designed program for Sprint Canada to enable daily card data to be input automatically into their database.

Top