Welcome to VDI, LLC

Services Provided

Micosoft Visual Studio.NET

For Center for Oral Surgery, Al developed an interactive website keeping track of its operations. This website was developed using Visual Studio.NET 2005, ASP.NET, VB.NET and linked to an Access 2007 database.
Al created an interactive website for an academic institution located overseas. This website, which allowed the users to add information, conduct searches, edit their own information and view and sort the entire listing, was developed using Visual Studio.NET 2005, ASP.NET, VB.NET and Flash and was linked to a SQL Server 2012 database. This site can be visited at www.RaziHighschool.com.
For L3 Communications, Al developed a system for the Army Counter Intelligence using Visual Studio 2005 (ASP.NET and VB.NET) and SQL Server 2000.
For Northrop Grumman, Al served as a Senior Developer on several projects with the US Postal Service. These projects were all developed using Visual Studio.NET 2005 and SQL Server 2000 on a Windows 2003 platform.
For the Department of State , Al served as a Sr. Web Developer on a project for the IRM branch. This web-based portal, which also complied with Section 508 of ADA, consisted of a system that contained a digital dashboard and several types of graphs and charts describing the data collected from various systems located at DoS posts worldwide. The data also interacted with the Windows Active Directory (AD) and was displayed in both graphical and tabular formats. The system was built on a Windows 2003 Server platform and stored the data in a SQL Server 2000 database. The communication between the forms and the database was done via stored procedures. The technologies and tools used in this system consisted of Visual Studio.NET, ASP.NET, XML, XSL, XSLT, CSS (Cascading Stylesheets), SQL Server 2000 and DotNetCharting graphs.
For OneMortgageLender, a mortgage lender organization, Al developed an interactive website to keep track of their clients, as well as their settlement, real estate and home improvement companies. This site was developed using ASP.NET, VBScript and JavaScript and was tied to an Access 2000 database and on a Windows 2000 platform.
For American Telephone & Communications, Inc., Al developed an interactive website to keep track of their inventory, a list of current and completed projects, as well as a list of clients. This site was developed using ASP.NET, VBScript and JavaScript and was tied to an Access 2000 database and on a Windows 2000 platform.
For Financial Solutions, Inc., Al developed an interactive website to keep track of their operations, clients, accounts and companies they represent. This site was developed using ASP.NET, VBScript and JavaScript and was tied to an Access 2000 database and on a Windows XP platform.
For Nazarian Brothers, Inc., Al developed an interactive website to keep track of their operations, clients, accounts and inventory. This site was developed using ASP.NET, VBScript and JavaScript and was tied to an Access 2000 database and on a Windows XP platform.
For Viatech, Inc., Al served as a Sr. Web Developer on several projects for the USDA. 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.
For ElleK Associates, a hotel booking organization, Al developed an interactive website to keep track of their clients and their requests. This site was developed using ASP, VBScript and JavaScript and was tied to an Access 2000 database and on a Windows 2000 platform.
For 3TI, Al developed several interactive websites on a contract for the General Services Administration (GSA). As part of this project, Al developed systems to collect training-related surveys from the GSA staff. These websites were developed using Visual InterDev 6.0, ASP, HTML, VBScript and JavaScript and are linked to an Access 2000 database.
For SI International, 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 HomeSite 4.51 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 are 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.
For KeepMore, Inc., Al served as a Team Leader working on a financial system that enabled users to apply for credit cards online using certain banks' or financial institutions' websites. This product was developed on a Windows 2000 platform, using IIS 5.0 and COM+ and was developed using Visual InterDev 6.0, ASP, VBScript and JavaScript, linked to a SQL Server 7.0 database containing numerous stored procedures.

Micosoft Visual Basic

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, Inc., 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 served as a Sr. Software Developer on a property assessment project. This system used Visual Basic, COM and DCOM and was tied to a Sybase 11 database via stored procedures and on a Windows 2000 platform. All reporting on this project was 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 & TrademarkOffice (PTO) . This project pertained to developing a Visual Basic 6.0 system to import and exportdata 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 . 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 was developed using Visual Basic 6.0 as its frontend and Sybase as a backend, also had several middle tiers that carried 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. This database was completed in December of 1998.
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.

Micosoft Access

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 The National Opera Center 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 and Prevention (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 developed and mainted 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.