|
|
|
For SAIC, Al is currently serving as a Technical Lead
on the Automated Frequency Manager (AFM) project for the Federal Aviation Administration (
FAA). This system, which manages all frequencies granted by FAA nationwide, is developed using Visual Basic 6.0,
COM+ and the ESRI MapObject and communicates with an Oracle 10g database via stored procedures.
For Booz Allen, Al served a Senior Developer on several projects with
FDIC. These projects were developed using a series of tools such as
Visual Basic 6.0, ASP and SQL Server 2000.
For OST, Al served as a Technical Lead
on the Automated Frequency Manager (AFM) project for the Federal Aviation Administration (
FAA). This system, which manages all frequencies granted by FAA nationwide, was developed using Visual Basic 6.0,
COM+ and the ESRI MapObject and communicates with an Oracle 10g database via stored procedures.
For Northrop Grumman Mission Systems,
Al served as a Sr. Software Developer on the Defense Travel System (DTS) for DoD. This system provided DoD travelers
with completely automated travel planning and reimbursement capabilities. The technologies and tools used in this
system were Visual Basic 6.0, Oracle 9i and Access 2000, as well as several others such as Java and PL-SQL. All
reporting on this project was done via Crystal Reports 8.5.
For Principal Visions,
Al developed a series of tracking systems to track items such as vineyards worldwide, infants and passwords. The
technologies and tools used in these systems were VB.NET and Access 2000.
For Freddie Mac’s
Multifamily group, Al is currently serving as a Sr. Software Developer on a
property assessment project. This system uses Visual Basic, COM and DCOM and is
tied to a Sybase 11 database via stored procedures and on a Windows 2000
platform. All reporting on this project is done using Crystal Reports 8.
For Theracom, Al served as
a Sr. Software Developer in a team of developers developing a Case Management
System to help manage cases for the company’s healthcare products. This system
was developed using Visual Basic 6.0 and COM and was tied to a SQL Server 2000
database and on a Windows NT 2000 platform. All database transactions were
performed via stored procedures and all reporting done using Crystal Reports
8.5.
For Viatech, Al served as a
Sr. Web Developer on several projects for the USDA. The majority of these
projects used Visual Basic 6.0, COM, ASP, XML, VBScript and JavaScript and were
tied to a Sybase 12 database and on a Windows NT 4.0 platform. Al also
developed a Visual Basic project that retrieved e-mails from an Exchange 2000
server on a Windows 2000 Advanced Server platform using the Collaborative Data
Object (CDO) and Active Directory, then detached the attachments and stored
them in a SQL Server 2000 database.
For Axiom, Al served as a
Sr. Visual Basic Developer on a project for the Clinical Information Technology
Program Office (CITPO) of DOD, under Section 508 of ADA. This project, which
was developed using Visual Basic 6.0 and SQL Server 2000 on a Windows 2000
platform, tracked the lessons learned pertaining to each separate program run
by CITPO. All database transactions were performed via stored procedures and
all reporting done using Crystal Reports 8.0 and various API function
calls.
For Logicon, Al served as a
developer on a project for the U.S. Patent & Trademark Office (PTO). This
project pertained to developing a Visual Basic 6.0 system to import and export
data from/to a wireless Psion handheld system containing the PTO assets. This
system communicated with an Oracle 8i database. All reporting on this project
was done using Crystal Reports 6.0 and 8.0
Al served as a
Sr. Web Developer on the Olympic Visa Information Database (OVID) system for
the Department of State. This system was built on an MS Windows 2000 platform,
using Visual InterDev to develop the ASP, VBScript and JavaScript code,
Microsoft Transaction Server (MTS) and Internet Information Server (IIS) 5.0 as
the middle tier to store the COM+ business objects and Oracle 8i as the backend
database. All COM+ objects for this system were developed using Visual Basic
6.0. The system, which also interfaced with the FBI, INS and CIA systems,
supported the activities of the 2002 Salt Lake City Olympics by storing,
processing and tracking detailed information on all applicants, providing
management reports and issuing identity cards.
Al served as a
Senior Web Developer for KeepMore, Inc. working on a financial system that
would enable people to apply for credit cards over the internet using certain
banks' or financial institutions' websites. This product was developed using
Visual InterDev 6.0 and ASP and was linked to a SQL Server 7.0 database
containing numerous stored procedures.
Al served as a senior software
developer working on a web-based survey application and a client-server Food
Production System for
Sodexho Marriott Services (SMS). The web-based
application pertained to a Unit Site Survey that the unit managers would access
to update their site information. This application was developed using Visual
InterDev 6.0 and ASP linked to an Access 97 database. The client-server system
was developed using Visual Basic 6.0 with an Oracle 8.0 backend. This system
tied together menu planning, production, standard recipes, procurement and
nutrition and was scheduled to be used at over 4000 facilities (i.e., schools,
hospitals and cafeterias) nationwide. Some of the development and testing of
this system was performed in SMS's Manchester, England office.
Al served as a member of
team of software engineers developing a multi-tier system for
Fannie Mae This
system, which is developed using Visual Basic 6.0 as its frontend and Sybase as
a backend, also has several middle tiers that carry the information back and
forth in the form of flat files. This application tracks all necessary
information pertaining to home mortgage loan applications.
Al served as a member of team of software engineers developing a system for the Disaster
Relief Operations Center of the
American Red Cross This system, which was
developed using Visual Basic 6.0 as its frontend and Oracle 7.3 as a backend,
tracked every aspect of every disaster (e.g., budget, logistics, etc.) from the
second it occurs to when it is no longer considered a disaster. This project
also employed the use of several third party tools by Sheridan, Apex, FarPoint
and Zip Code Pro.
Al was a member of a team
of software engineers and developers involved with a Y2K project for the U.S.
Agency for International Development (USAID). The original system was developed
using Visual Basic 3.0 as a frontend and Oracle 7.3 as a backend. The first
phase of this project consisted of making the existing system fully
Y2K-compatible. When the modified system was tested and certified as being
Y2K-compatible, its frontend was then converted to Visual Basic 6.0. This
system addressed the following areas of USAID: Acquisitions and Assistance,
Accounting, Operations and Budget. (CSC)
Al served as a member of a
team of software engineers developing a client-server healthcare system for the
Department of Defense (DOD). This system, which was developed using MS Visual
Basic 6.0 as its frontend and Informix as its backend, operated in a Microsoft
NT environment and tracked healthcare related information, specifically in the
area of dental care. The system was comprised of several .DLLs, also written in
Visual Basic, and used the COM technology. When fully completed, the system
would be integrated with several COTS products, as well as an existing DOD
healthcare system and used DOD-wide.
Al served as a senior
software developer in charge of converting an existing database for the
U.S. Forest Service and making it Y2K-compatible. This database pertained to
historical tracking of forest fires in the United States and was developed
using Visual Basic 3.0 with an Access 2.0 backend. I converted the system to
Visual Basic 5.0 with an Access 97 backend. The system contained in excess of
80 forms and 10 modules. The first phase of the conversion of this database was
completed in December of 1998. This project is ongoing.
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. All databases were
developed using Visual Basic 3.0 with Access 2.0 backends and were converted to
Visual Basic 5.0 with Access 97 backends. Most of them contained in excess of
100 API function calls that needed to be converted to 32-bit versions. The
conversion of these databases was completed in November of 1998.
Al served as a Team Leader
on a "full life-cycle" project for the Department of State (DoS). This
project pertained to the design and development of a database to track all
computer security examination and evaluations at approximately 500 DoS posts
(e.g., embassies, bureaus, branches, etc.) worldwide. The database was
developed using MS Visual Basic 5.0 with an MS Access 97 database. When
completed, this database was to be installed on laptop computers for the DoS
evaluators to use onsite to evaluate the computer security issues at various
posts. After each site evaluation is completed, a report would be generated by
the system describing in detail the observations and recommendations made by
the evaluation team. This project was completed in June 1998.
Al designed and developed a
database for
ComTech Services to track all software and hardware repair
projects nationwide. This database, which was developed using MS Visual Basic
5.0 with an MS Access 97 database, enabled the ComTech staff to not only track
these projects, but also to maintain an inventory of all of their customers, as
well as all of their 3,000+ technicians. Once a repair call is received by the
ComTech dispatchers, they would be able to locate the technician nearest to the
client site, find out the technician's rate, expertise and availability and
dispatch him/her to the project location. The ComTech staff would use this
system to track each project by location, client and by technician. Several
reports and invoices are generated by this system, including field reports and
invoices. The first phase of this project was completed in late 1998.
Al was a member of a team
of developers developing a database for a joint venture between the Board of
Governors of the Federal Reserve Board (FRB) and the Federal Deposit Insurance
Corporation (FDIC). This database, which would enable the FRB examiners to
scrutinize all bank records more accurately, had an n-tier architecture, and
was developed in Visual Basic 5.0 with an MS Access 97 backend. It contained
OLE servers and OLE automation technology. It also contained more than 100
forms, several custom controls (OCX), as well as several DLLs and ActiveX
controls both created in VB 5.0. Reporting in this database was performed using
Crystal Reports 5.0 and VSReports. After completion, the database was installed
on laptop computers for the examiners to use onsite during bank examinations.
This project was completed during the first quarter of 1998.
Al was a member of a team
of developers developing a membership database for the American Dental
Association (ADA). This client/server database, whose first four applications
were originally developed in Visual Basic 4.0 with an MS Access 7.0 backend,
contained detailed information pertaining to the ADA members on local, state
and national levels. After being fully developed and tested, these first four
applications were ported to Visual Basic 5.0 with an MS SQL Server 6.5 backend,
and delivered to ADA, along with the remaining eight applications. This
database contained in excess of 80 screens and used various third-party (OCX)
tools including several by Microsoft, Sheridan and Videosoft.
Al developed an "Applicant
Tracking System" for a client for its internal use, enabling the client
management to track potential candidates for employment. This database, which
was developed using MS Visual Basic 4.0 with an MS Access 2.0 backend,
comprised of queries to allow for the extraction of various types of
information, such as the potential candidates’ programming expertise and
education. This system was also designed to allow the client management to rate
candidates and make further hiring decisions.
Al developed a "System Change Request" database, allowing for the documentation
of modifications requested by the organization clients pertaining to any
software developed by that particular organization. This database, which was
developed in MS Visual Basic 4.0, cataloged the system or software name, the
client name, the company and client points of contact, the nature of
modification, the request and receipt dates, the company team leader and
project manager, the individual making the modification, the date assigned to
the individual, the individual’s comments, suggestions made by either the
client or company staff, the completion date, quality assurance performed, and
finally the approval date by the team leader, along with a change request
number.
|
|