Clients
A sample listing of just a few clients from over the last 16 years...
Air Products Inc
Utilize
VBA skills to convert product usage from plants in Asia into specific
invoice line items individualized per contract mathematics (price
tiering).
Lehigh Valley Hospital
Design
and build MS Access applications for the IS Security department.
Applications range from a user programmable automated data transfer
program to a corporate wide systems audit application. Monitor
automated systems and handle errors. Handle 2nd level security
authentication support calls for network and over 150 applications.
"Production Management Control System" for FSI Products Inc.
Design
and implement MS ACCESS database/application to handle all phases of
product manufacturing including quotes, ad hoc queries, and reporting.
Recommend and administer a client/server solution to upgrade from a
peer to peer network by setting up and implementing an MS NT 4.0
network, utilizing MS Small Business Server.
Rodale Inc.
The
Accounting department needed a way to get more done in less time.
Since much time was spent formatting, merging, and adjusting Excel
spreadsheets, a solution was needed to increase productivity. Several
VBA macros were created to do the work of “many hours” that take now
literally 20 seconds to run!
“BMC Quoter” for Bracalente Manufacturing Inc.
Redesign
legacy quoting system for ease of use using MS ACCESS that can
interface with ERP system. Import/convert old legacy data, improve
performance, redesign new front end utilizing MS ACCESS, SQL Server,
and VBA.
“Auto Web” for Pennmark Autogroup Inc.
Mercedes/Porsche
Dealer needed to automatically convert dissimilar E-mail based lead
information to an MS Access sales database. Using MS ACCESS and VBA, a
solution was created to automatically parse and import the sales lead
information from MS Outlook and save the data into an MS ACCESS sales
database.
"T-Time" Reservation System for 'Olde Homestead Golf Club'
MS
ACCESS application manages reservations and times for golf club. From
reservation taking, golfer data and tracking reservation history, to
special reports, this application organizes the critical schedule of
this busy club.
Hoffmann La-Roche Pharmaceuticals NJ
Design
and roll out new MS ACCESS/VBA applications for the Quality
Management/Assurance department. Upgrade, enhance, and address
performance and Y2k issues with earlier versions of MS ACCESS
databases. Design and implement Y2k protocols for FDA
approval. Implement strict security protocols utilizing MS ACCESS
security features.
Reed Technology and Information Systems (Legal/publishing industry)
Design
applications to format text for magazine directory layouts using MS
ACCESS/VBA/SQL, adding HTML tags, and interacting as a client liaison.
