Consultants Exchange Product Capabilities
 Consultants
Exchange is the central hub of a virtual
organization providing information
technology consulting services across
a wide spectrum of systems, platforms and technologies.
The Exchange represents an ever-expanding group
of consulting partner companies, each of which
specializes in a particular niche within the
information technology arena. The company currently
operates regionally, nationally and internationally
depending upon the outlook of its individual
partners.
Following is a representative overview of Consultant
Exchange's experience and capabilities,
classified in broad technological categories:
I. CLIENT-SERVER SYSTEMS
|
Technology: Windows; Unix; SQL
Server; Oracle; Sybase; Informix;
DB2; Access; Visual Basic; Delphi;
C/C++ and related tools
|
|
Applications:
- Fleet Policy Management
System for AIG Small Fleet
Division
- Order processing, bar coding
and shipping system for
Innotrac
- Credit Score Model Development
System for Credit Strategy
Management
- Long Range Business Planning
System for Siemens Energy
& Automation
- Credentials & Roster Management
System for Office of School
Readiness - State of Georgia
- Credit Card Registry System
for Metris (Fingerhut)
- Property Management System
for Norfolk Southern Railroad
- Data Warehouse assessment
project for Grady Health
System
|
II. INTERNET & COMMUNICATIONS
SYSTEMS
|
Technology: NT; UNIX; IIS; ASP;
Java; Perl; HTML; VPN; Active-X;
FTP; TELNET; HTTP; RDB Interface
|
|
Applications:
- Web portal for V2B Solutions
- Web Browser-Based Time Tracking
for Nth Degree
- Call Center & Web-Based
Reporting System for FleetSafe
- Collection of transaction
data from designated Internet
sites and conversion to
Excel files for Bell Capital
Management
- File transfer of Pacific
Bell shipping orders to
Innotrac via FTP
- Implementation of server
software in DSL router
equipment for Copper Mountain
Networks
- Large-scale e-commerce site
with on-line catalog for
Buckshot Racing
- Website and backend database
application for conference
registration for Church's
Fried Chicken
- Critical e-commerce site
for selling computer parts
for Computer Exchange
- Website for RealEstate.com
|
III. NETWORK DESIGN, INSTALLATION
& SUPPORT
|
Technology: Windows; Novell Netware;
Unix; Citrix; ISDN; Internet
|
|
Applications:
- Installed LAN and WAN for
Smith & Sons Foods to connect
user departments and the
food distribution warehouse
to the company's new financial
management system
- Installed WAN for private
probation company with
offices in several Georgia
counties, and connected
remote sites to user's
host site via Internet
using Citrix software
- Installed WAN using frame
relay to connect The Winston
Group with its Golden Corral
restaurants, including
on-line camera monitoring
- Upgraded LAN and added Internet
access for Rebco Racing
- Provide "on call" LAN support
for Optimum Radiology and
numerous other clients
|
IV. DATABASE SYSTEMS
|
Technology: Windows; Access; Visual
Basic; FoxPro; Delphi; Paradox;
Pick; MUMPS; Excel
|
|
Applications:
- Inventory management system
with interface to SQL Server
based manufacturing system
for BioLabs
- Used FoxPro to develop business
management software used
for licensing administration,
royalty accounting, contract
compliance, etc for Collegiate
Licensing Company
- Used Access to create Order
Tracking System that extracts
selected data from Excel
spreadsheets for Motorola
- Used Access to develop
Order Processing System
that identifies products
based on multiple optional
parameters for Electrical
Lighting Systems
- Invoicing and billing application
for Allied Materials
- Developed client database
for Emory Healthcare
- Developed medical billing,
inventory control, order
entry and invoicing systems
for wide range of clients
|
V. ACCOUNTING AND FINANCIAL
MANAGEMENT SYSTEMS
|
Technology: MAS 90; Great Plains;
Open Systems; Peachtree; Essbase;
Excel; Access; Word; Crystal
Reports; FRx; Citrix
|
|
Applications:
- Aided in search and selection
of LAN-based financial
management software to
replace old system that
ran on obsolete hardware
for Smith & Sons Foods
- Designed and developed Excel
application to accumulate
and monitor marketing expenditures
for Orkin Pest Control
- Assisted SunTrust Bank in
converting hundreds of
non-Microsoft spreadsheets,
word processing documents
and database applications
to their Microsoft equivalents
(Excel, Word or Access)
- Developed financial projection
model for Agnes Scott College
- Extracted financial reports
from corporate database
for BellSouth Cellular
- Application to disperse
$18 million/month in lottery
funds for pre-school programs
for Office of School Readiness,
State of Georgia
- Supported Turner Enterprises
using Open Systems
- Set up systems for regional
accounting firm to enable
firm's clients to access
their accounting records
remotely using Citrix
|
VI. ELECTRONIC DATA INTERCHANGE
(EDI) SYSTEMS
|
Technology: Sterling/Gentran;
GEI Desktop; Harbinger
|
|
Applications:
- Created ANSI X12 interfaces
for Mudd, LLC to interface
with retailers such as
Federated Stores, J.C.
Penney, Dayton-Hudson Group,
etc.
- Created ANSI X12 interfaces
for Clean-Rite Products
to interface with retailers
such as Wal-mart, Sears,
K-Mart, Pep Boys, etc.
- Created NSF and ANSI X12
interfaces for Management
Services Network, Medical
Billing Management and
several other medical billing
companies to interface
with Medicaid, Medicare
and Blue Cross Blue Shield
- Assisted All Magazine Subscription
Agency in mapping their
invoice format to EDI standards
for interface with JCPenney
|
VII. DOCUMENTATION, GRAPHICS
& DESKTOP PUBLISHING
|
Technology: FrameMaker; Adobe
Photoshop; MS Publisher; PowerPoint;
Word; WordPerfect; Macromedia
Flash
|
|
Applications:
- User manuals and disaster
recovery plan for Scientific
Games
- Policies & procedures and
user manuals for BellSouth
- Test plan for BellSouth
Advanced Networks
- System documentation for
Center for Disease Control
(CDC)
- Hardware manual for Lanier
Worldwide
|
VIII. AS-400 SYSTEMS
|
Technology: RPG 400; COBOL 400;
OCL; SEU; DFU; DMAS; MAPICS
|
|
Applications:
- Converted legacy system
to AS400 technology for
Southern Engineering Co.
- Barcode label application
for Clinton County, MO
- 2K readiness assessment
for Embraer, a Brazilian
aircraft manufacturer
- Y2K project for Johnson
& Johnson, Montreal
- Ported MS C++ application
to Visual Age C++ to run
on AS400 for Witness Systems
|
IX. LITIGATION
SUPPORT
|
Applications:
- Provided technical consultant
and expert witness for
Kirkland & Ellis in major
IT-related case
- Provided mediator to resolve
IT software litigation
- Assist client's defense
against software piracy
complaint
|
|
