|
|
Recent Projects
|
| • |
ShowLeads
is a suite of applications used to track sales leads or session attendance
at Trade Shows. There are two main "user applications" one "server
application" and a "Sql database" used to store the data.
The user applications are designed to run on either a PC (typically a laptop)
or a hand held Pocket PC, based on user preference. Both applications share
the same architecture and make use of Bar Code scanners, and/or Magnetic
Stripe card readers as input devices, to reduce the time it takes to acquire
an attendees sales or attendance demographics. Both applications are designed
to be used in either a stand-alone or fully networked environment. In a
fully networked environment sales leads and session attendance is transmitted
to the server in near real time. The system can send emails to customers
with targeted text or attachments (brochures, price lists, etc.) based on
their answers to questions they were asked in the booth. The email can be
sent within minutes after requesting the information while they are still
attending the show. Session tracking information is available to show management
within minutes of its acquisition on the show floor. |
| • |
Directions
is used by School Districts to manage their Special Education "Individualized Education Plan"
(IEP) program. It provides school districts with a district wide enterprise level
resource to create and maintain individualized, state compliant, and professional-looking
IEPs and GIEPs. It tracks regulatory deadlines, and provides district-wide
Pa and federal reports. Directions integrates seamlessly with the school districts
existing Student Information System to maintain teacher and student demographics
via automatic nightly updates. The sysyem is self deployed to the desktop with MS Access
and uses MS SQL 2000 as the backend database. |
| • |
Dimensions
is a district-wide solution for creating a K-12 Assessment Portfolio for
each student in the district. It uses a variety of assessment instruments
(e.g. rubrics, grades, tests, Report Cards, PSSA, checklists) created by
the district. Dimensions is a hybrid app that uses both Browser based (ASP/HTML)
and MS Access programs to allow teachers and administrators to create and
assign assessments to teachers or groups of teachers, enter scores, and
analyze results for all students in the district. Allows tracking student
progress for the entire career of the student. Integrates seamlessly with
the districts existing Student Information System importing teacher, student,
and roster data via automatic overnight updates. Uses MS SQL 2000 as its
data store. |
| • |
Foundations,
is a computer aided instruction program that enables teachers to integrate
technology with best practices teaching methodologies like ABA (Applied
Behavior Analysis), and DTT (Discrete Trial Testing) to help Autistic and
other learning disabled children. Foundations uses dual (touch screen) monitors to present multiple
full motion videos, audio and still digital images. It collects real time student
performance data, and provides multiple reporting and charting options allowing
teachers to measure student progress. Developed using Visual Basic with
an MS Access database. |
| • |
P2 an MS Access application using a MS SQL 2000 database backend to manages the installation of
network wiring in thousands of sites for multiple customers. P2 automatically
integrates with the company’s legacy Computer Rental Reservation database
system allowing all of the accounts payable, receivables and GL to be in
the same place, while allowing the new group to have their own tool to manage
their unique business rules, forecasts, and schedules. |
| • |
AMEX
Expense Reporting System (AERS) using MS Access. This aplication saved the
company thousands of dollars a month in wasted man-hours by centralizing
and automating expense reporting for corporate AMEX cardholders located
across the country. Before AERS the accounting department would have to
duplicate and mail printed AMEX statements to all cardholders so they could
fill out their expense reports. When the expense reports came back the accounting
clerks had to audit the expenses and manually post each one to an appropriate
GL category. After the program was deployed the accounting department would
download one file from an AMEX website, and push a button to import it into
the system. They would then send an Email to all the cardholders who would electronically
complete their expense reports. Once the expense reports were completed
the accounting group pushed one button to export all the GL data to their accounting system. |
