|
|
|
Al served as a
senior software developer in charge of converting several existing databases at
Sallie Mae
and making them Y2K-compatible. These databases pertained to time
card reporting, and production and report management areas. Some of the
databases were developed using Access 2.0 and were converted to Access 97. Most
of them contained in excess of 100 forms and 20 modules that needed to be
converted to 32-bit versions. The conversion of these databases was completed
by November of 1998.
|
|
Al designed and
developed a Student database for the
Maryland College of Arts and Design
(MCAD). This database, which was developed using MS Access 97, contained
detailed information pertaining to each student, faculty member and class, as
well as the registration, admissions, financial aid, and billing processes.
This database was completed in late 1998.
|
|
Al designed and developed a full
life-cycle MS Access database for
Opera America, a small
trade association in Washington, DC. This database contained detailed
information about the Association's member companies and individuals worldwide
and pertained to issues such as publications, finances, conferences, auditions
and meetings.
|
|
Al served as a member of a
team of developers in charge of designing and developing a full life-cycle
MS Access database for the Centers for Disease Control (CDC) in Atlanta,
Georgia. This database contained information collected by field technicians
resulting from voluntary interviews of various laboratories and their practices
nationwide. After being fully developed, the database was linked with an
existing CDC database to address other issues.
|
|
With the assistance of DataSpex, Al designed and developed a full life-cycle survey
database of all national and international Fullbright-Hays scholars for the
Council of American Overseas Research Center (CAORC), a large
trade association in Washington, DC. This project was done in Access 95.
|
|
Al managed one
of the tasks pertaining to a large project for the United States Air Force
Scientific Advisory Board (SAB) located at the Pentagon. Al assisted in the
development of this very large database enabling the SAB staff to track data
relating to SAB’s meetings and activities. This database, which is comprised of
approximately 100 screens, was developed using MS Access 2.0. It was designed
to allow the SAB staff to fully manage the logistics of these meetings. The
database contained information on the attendees, as well as the nature of the
meetings, the location, travel, registration, security, documentation, and
follow up reports based on standardized queries. This database was fully
implemented in 1996 and Al provides a portion of the maintenance support.
|
|
A smaller database that Al designed and developed for the same SAB client was used to
track information pertaining to the nomination of new SAB members. The database
contained personal information, such as scientific specialty, education,
employer and geographical location for all current members and those
individuals proposed for nomination. Information such as SAB committee
affiliation and length of service with the SAB was also tracked. This database,
which was developed using MS Access 2.0, was comprised of approximately 50
screens and allowed the user to create reports based on standardized queries.
Al provides a portion of the maintenance support for this database.
|
|
The third database that Al designed for SAB, also in MS Access 2.0, was developed to
track data on publications and report ordering activities. This database
tracked data on publications and reports generated by SAB and available for
order. It also tracked current inventory, shipping data, and customer profiles.
This database contained approximately 10 screens and was fully implementated in
1996.
|
|
Al designed a database for another U.S. Air Force client to track personnel data pertaining
to the entire directorate. This database was developed in MS Access 2.0 and
contained information such as name, address, phone number, rank, office symbol
and location, previous posts, DOB, POB, security clearance, area of expertise,
and supervisor's name and information.
|
|
Al converted an exisiting database developed in SuperBase 2.01 to MS Access 2.0. This database
contained security information on personnel assigned to a particular United
States
Air Force office at the Pentagon. As part of this conversion, Al used
the ERwin data modeling tool to redesign the database data model structure.
This data model was then used as the basic foundation for the new database. Al
designed and developed screens similar to screens in the old database, wrote
extensive code to perform required functions, designed standardized queries and
reports, and built new screens to better accomodate the client. This database
consisted of approximately 40 screens and was fully implemented in 1996.
|
|
As a consultant on a contract with
MCI in McLean, VA, Al assisted in the
development and maintenance of a database designed and developed in Microsoft
Access 97. This database, called the Transition Database, was used by
approximately 20 MCI employees on a daily basis from two locations. The
database was used by MCI to track the events related to a project in which all
telecommunications systems for all United States military services were
transitioned from AT&T to MCI. The database included over 150 tables, 150
queries, 45 forms, and 45 reports. The Defense Information Systems Agency
(DISA), MCI’s client, receives a copy of the updated database on a regular
basis. Al assisted in securing the database by assigning various user and
group level permissions for those employees using the database. In addition,
she developed technical documentation and provided training to database users.
She also provided ad hoc management reports on an as-needed basis.
|
|