Institute of Database Developers
 

 

John Adelsten  Broad background in mainframe, client/server and web-based technologies. Strong methodology experience in Information Engineering from James Martin. Currently focused on Oracle datawarehouse development and production support. Experienced in Oracle version 7 and 8. Significant experience with large Oracle databases (50-100Gb).  
14929 Cub Run Park Drive
Centreville, VA 20120
703-309-0690
Email Address

 

 
Project: USPS Automation
Owner: US Postal Service
Owner Web: http://www.usps.gov
Dates: 1994-2001
Location: Washington, DC
Role: Project Manager
Duration: 7 years
Type: Financial Transaction Accumulation
Systems received awards for saving over $1,000,000 per month. Focus is on cost saving through automation. Significant achievements include 90 million tranactions in a 10 minute window each day. Currently deploying an electronic travel voucher system to 81,000 customers.
 

 

David Bryant  David founded Oak Tree Systems, Inc in 1994 It began as a firm that provided technical training instructors to training centers around the U.S. Early software development and consulting services focused on the Mid-Atlantic region. Today we claim customers from Virginia to California. Oak Tree Systems has its roots planted and continues to grow, tripling in size since 1994. 
61 Callohill Drive
Lovingston, VA 22949
804-263-6000
Email Address

 

 
Project: TrainingForce.com
Project Web: http://www.trainingforce.com
Owner: OakTree Systems
Owner Web: http://www.oaktree-systems.com
Dates: 2000,2001
Location: Lovingston, VA
Role: Lead Developer
Duration: 18 months
Type: ASP Rental
TrainingForce.com is an on-line system designed to automate the daily tasks of any training or educational business. It schedules courses and instructors, registers students, creates invoices and more
 

 

Kennett Fussell  Doctorate in Education. Worked with microcomputers and software development since 1980. Since 1984 wrote over fifty courses and taught over 10,000 people how to use database, spreadsheet, wordprocessing, project management, and graphics software. Since 1993 have managed networks and software automation projects for the federal government. Currently developing interactive web databases. 
5694 Kirkham Court
Springfield, VA 22151
202-273-3567
Email Address

 

 
Project: Finanacial Improvement Progress System
Project Web: Http://fido.gov/fips
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Federal agencies are audited each year. The FIPS system tracks audit information and findings. Agency initatives are associated with findings to track progress of the improvements discovered in the findings.
 
Project: Federal Interagency Databases Online
Project Web: Http://fido.gov
Owner: Office of Government-wide Policy GSA
Owner Web: http://www.gsa.gov
Dates: 2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
FIDO provides access to database that are used by many agencies. A score300 chart is available to compare agencies across numerous data collection processes.
 
Project: Financial Management Systems Inventory
Project Web: Http://fido.gov/fmsi
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2002,2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 24 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Federal agencies use FMSI to report information about the Financial Managemnet tools that they use. The information is used to assist in budget preparation and monitoring.
 
Project: FACA DATABASE
Project Web: http://204.254.112.5/cms
Owner: General Services Administration
Owner Web: http://www.gsa.gov
Dates: 2001,2000,1999
Location: Washington, DC
Role: Enhancement and Production
Duration: 48 months
Type: NT4, IIS4, SQL7, XML, Internet database
The 2 year old FACA Database received a face lift and additional reporting capabilities. A new Public area was created that allows anyone to log one and view or download data from the system.
 

 

Ladislav Goc  I have been designing and building database solutions since 1987. I am an expert in digital and audio processing and preparing content for streaming over the Internet. I am also experienced in th preparation and delivery of training programs. I love Bond girls. I am currently investigating the use of XML in for my future solutions. 
Na Parcelach 75
011-420-603-514716
Email Address

 

 
Project: International Marketing and Product Development
Project Web: http://www.icewarp.com/merakmail/index.html
Owner: IceWarp, Ltd.
Owner Web: http://www.icewarp.com
Dates: 2001,2000
Location: Prague, CZ
Role: Analysis and Design
Duration: 6 moths
Type: NT 2000 Linux W9X Email
I am guiding the developers of an existing, cool and successful email server called Merak. I am using my experience with the marketing of my software solutions and professional audio visual equipment to develop an international sales effort. We are delivering our product digitally world-wide. The only printed material that we have is our business cards.
 
Project: XML Do It Now!
Project Web: http://xml4all.com/ASP/OtherLocations.asp
Owner: XML4All
Owner Web: http://xml4all.com
Dates: 2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 3 Months
Type: XML,NT4, IIS4, SQL7 database
Course was created to explain the XML tools available for doing XML now.
 

 

Joseph Gotthelf  Joseph has been developing database applications since 1981. He runs August Technologies, Inc., a consulting firm out of the Philadelphia area, which specializes in the development of data intensive web applications. He has experience in a number of industries, such as Telecommunications, Oil, Banking, Managed Care, Medical, Government, etc. Joseph has spoken at technical conferences in the US and Canada, and is a contributing author for several FoxPro books. He has also written numerous magazine articles. 
7 Arbordale Lane
Broomall, PA 19008-1650
610-325-9550
Email Address

 

 
Project: FINANCIAL MANAGEMENT SYSTEM INVENTORY
Project Web: http://www.fmsinventory.gov
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2001
Location: Washington, DC
Role: Developer
Duration: 4 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Developed database based e-mail system to track communications between participants in the FSMI Inventory system. More details on this e-mail system can bee seen at www.dmail3000.com
 
Project: Tenant Screening
Owner: American Tenant Screen
Owner Web: http://www.atshome.com
Dates: 2001
Location: Havertown, PA
Role: Design and Implement
Duration: 3 months
Type: NT4 IIS4 SQL7 VB ASP
Repair and Enhance system which performs credit, check, criminal background, eviction, and other reports on prospective tenants for the firm's customers
 
Project: STANDARDS COMMITTEE MEMBERS
Project Web: http://standards.gov/membersearch/
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 2000
Location: Alabama, Maryland, Virginia, Pennsylvania
Role: System Analysis, Design, Production
Duration: 3 months
Type: NT4, IIS4, SQL7 database, XML, Access
The process involves a new calling web server and existing remote servers at NIST, DOD and NASA. The user browses to the calling server. The calling server uses standard CGI scripting to contact the remote servers. The remote servers retrieve the desired information from their databases, format it and return it to the calling server. The calling server combines and formats the results using state of the art XML and XSL, returning HTML to the user’s browser.
 
Project: PROVIDER CONNECT ELITE
Owner: InfoMC, Inc.
Owner Web: http://www.infomc.com/
Dates: 2000
Location: Philadelphia Metro Area
Role: Application Architect
Duration:
Type:
Enhancement to the Provider Connect system, providing access to open-ended back-end database systems via XML interface.
 
Project: PROVIDER CONNECT
Owner: InfoMC, Inc.
Owner Web: http://www.infomc.com/
Dates: 2000.1999
Location: Philadelphia Metro Area
Role: ApplicationArchitect, Design, Lead Developer
Duration:
Type:
The Provider Connect System gives health care providers the ability to view patients benefits, insurance eligibility, treatment history, address information, etc. via the Internet. It also allows them to send claim information, and request & receive authorizations in an automated fashion via the Web.
 
Project: ECURA INFORMATION SYSTEM
Owner: InfoMC, Inc.
Owner Web: http://www.infomc.com/
Dates: 1999
Location: Philadelphia Metro Area
Role: Application Architect, Lead Developer
Duration:
Type:
The eCura Information System is a complete system for Managed Behavioral Health Care Providers. The system incorporates intake, eligibility, referrals, care management, reporting, claims-processing and accounts payable into an integrated, web-enabled information system
 
Project: ON LINE ACCESS TO AGENT INFORMATION
Owner: Capsule Communications (US Wats)
Owner Web: http://www.capsulecom.com/
Dates: 1999,1998
Location: Philadelphia Metro Area
Role: Database Development, Create of Data Access Module
Duration:
Type:
Web based tools were created to allow Agents to access and update their Customer Data, to receive commission reports, and near real-time billing information on line.
 
Project: INTERNET ACIS
Owner: Capsule Communications (US Wats)
Owner Web: http://www.capsulecom.com/
Dates: 1999.1998
Location: Philadelphia Metro Area
Role: Application Architect & Development
Duration:
Type:
The existing DOS application was migrated to a Windows platform, and provides Internet access. This allows employees and agents to securely access all customer information via the web.
 
Project: REAL-TIME DATA & BILLING
Owner: Advanced Telecommunication Network
Owner Web: http://www.atn.com/
Dates: 1998
Location: Philadelphia Metro Area
Role: Database Development, Create of Data Access Module
Duration:
Type:
Customer Application, Customer Care, Bill Payment, and Agent Services were made available via ATN's Internet Presence.
 
Project: TAMS & TRAMS
Owner: Triton International
Owner Web: http://www.trition-net.com/
Dates: 1998
Location: Philadelphia Metro Area
Role: Application & Database Design
Duration:
Type:
TRAMS is an end user application used by agents all over the world to enter new customer orders and transmit them electronically to the TAMS application which enters the orders into the telecommunications switches. This process allows agents anywhere in the world to instantly add new customers, and to modify existing customer accounts.
 

 

Frank Grimberg  Frank has been directly involved with over 100 successful custom software implementations for small business and Fortune 500 companies. He currently runs WaterCastle, LLC. His development expertise includes SQL Server, ASP, ASP.NET, C# but has worked with almost everything. 
8150 Leesburg Pike 820
Vienna, VA 22182
703-391-7272
Email Address

 

 
Project: Help Desk
Owner: Office Cleaning Company
Dates: 2002
Location:
Role: Design and Production
Duration:
Type: ASP.NET, C#, SQL Server, Exchange
 
Project: Client and Order Processing Website
Project Web: http://www.broadcastvideogear.com
Owner: Bexel
Dates: 2002
Location:
Role: CTO, Design and Production
Duration:
Type: ASP, SQL Server, Oracle
 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 

 

John Hagan  John Hagan has been in IT support since ‘93 and currently runs Commonwealth Technology Consulting, Inc. He has a background in networking, desktop/server implementation, call center management, and end user support. Areas of expertise include Windows environments, MS Exchange, IIS, VPN, Wireless, Switching and Routing, Dell and HP servers. 
PO Box 479
Norfolk, VA 23501
757-575-8000
Email Address

 

 
Project: Server/Network Installation
Owner: K & M Contracting, Inc.
Dates: 2007
Location: Fredricksburg, VA
Role: System Implementation, Production, Maintenance
Duration: Ongoing
Type: Windows SBS, Virtual, Vista
Replace aging office Windows 2000 server with Windows 2003 Small Business Server. Migrate data shares, user logins, network printers, etc. Implement MS Exchange and SPAM mitigation tools. Configure VPN for employees and remote access support. Setup Shadow Copy services and backups.
 
Project: Server/Network Installation
Owner: Step by Step Consulting
Dates: 2008
Location: Suffolk, VA
Role: System Implementation, Production, Maintenance
Duration: Ongoing
Type: Windows SBS, Virtual, Vista
Install a Windows 2003 Small Business Server, router, and data switch. Implement Shadow Copy services, file and print shares, MS Virtual Server 2005, PPTP VPN, backups, remote printing, and QuickBooks. Upgrade clients from Vista Home to Vista Business, preserver user profiles and add to domain.
 
Project: MS Exchange 2003 Implementation
Owner: Nancy Chandler Associates
Owner Web: http://www.nancychandler.com
Dates: 2008
Location: Norfolk, VA
Role: System Implementation, Production, Maintenance
Duration: Ongoing
Type: Win2003, Excahnge
Install Exchange server, backup system, and Domain Controller in a secure hosting site. Connect to main offices via VPN. Implement MS Exchange 2003 for 30 employees and 100 contractors. Provide access via Outlook Web Access, MS Outlook, POP, and IMAP. Activate Exchange SPAM mitigation tools
 

 

Emad Hammoud  In a nutshell I have been developing user systems since the 70's, client/server since the 80's, dynamic data-driven web applications since the early 90's, survived the Y2K crisis at DARPA, and presently integrating more Active Directory & all types of scripting for 21st century modules. Most of these systems are SQL-based. With the advent and popularity of the Windows 2000 server operating system, have also integrated SQL 7.0 and Active Directory as resource for validation, control, and security on web sites. Researching XML & WSH scripting for true cost/time savings without uprooting existing systems. Applied efficient modularity for usage of new tools. In problem-solving or decision-making situations, always sought solutions with calculated risk and common-sense reality 
14354 Maple Rock Court
Centreville, VA 20121
703-222-9889
Email Address

 

 
Project: DIRECT MARKETING
Owner: AB & C Group - Vienna, VA
Dates: 1994
Location: Charlestown, WV
Role: Design and Production
Duration: 4 Months
Type: Novell LAN 3.11 - FoxPro 2.6
AB & C provides direct marketing support for Compaq, the National Rifle Association and On-Line America. The project was designed to provide support for client requests under a unified FoxPro interface. The use of multiple Novell file servers and HP minis required close coordination between MIS staff and the FoxPro team. A systems required data transfers between the various servers. There are presently three sub-systems in place: Compaq Customer Surveys, Healthy Directions Selects and Credit Card Processing for NRA.
 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 

 

Nelson Johnson  20 years programming and consulting experience, with the first 4 years working with main-frame systems and the rest on the PC. Founded own company 1994 and renamed it to Eccountable in 2001 to reflect business focus on Accounting and e-commerce. Earned a BS degree on Decision Sciences and MIS from the George Mason University school of Business in 1990. Database design expert. 
9687 B Main Street
Fairfax, VA 22031
703-426-1905
Email Address

 

 
Project: ESP
Project Web: http://www.espgroup.net
Owner: ESP Group
Dates: 1996-2000
Location:
Role: Senior database designer and developer
Duration:
Type: NT, NS, ColdFusion, VFP, 6000 users
The Extranet for Security Professionals (ESP) project began at DARPA as a “Lotus-Notes like” productivity web portal for the security community that includes collaborative document development, forums, calendar, secure mail (with positive read-receipt), document library, classified advertising, and more. Administration of the site was designed to allow authenticated users to create their own “communities” and authenticate more people into the system so that very little administration was needed. After initial success, several members of the team “took it commercial” and now have a profitable ASP offering this product as their flagship.
 
Project: HCIN
Owner: Pracon
Dates: 1992-Pres
Location:
Role: Project Manager, Developer, Designer
Duration:
Type: NT, VFP, SQL Svr, ColdFusion, Word, Excel, 50 user
Multi-location call center system for tracking patient applications for health insurance reimbursement and managing distribution of drug shipments. Also helps manage indigent patients applications to qualify for free drug programs. Integrated with word processing to manage a complete correspondence with doctors, insurance company, and patients. Data is never lost from the system; uncommitted data is cached in local disk and can be recovered in case the client is interrupted, and a complete image of every record is managed on the server to insure that data even relational table updates will not impact reporting. Uses VFP on the front end, and SQL Server.
 
Project: SEALINK
Owner: US Navy
Dates: 1994-2001
Location:
Role: Senior Architect and lead developer
Duration:
Type: NT, IIS, VFP, ColdFusion, 500 users
This system supports NAVSEA in the initial design phase of shipbuilding, and several Navy maintenance activities. SEALINk is a web based design tool that is used to identify equipment that can fill a specific requirement in a ship design. It uses an inverted index to allow searching by the functionality (size, color, weight, volts, etc.) of all known Navy equipment to locate everything that will fit a given need. The system goes further in collecting data from Navy maintenance records to identify which parts are good or poor maintenance choices and the relative logistical costs in order to identify a best-value product.
 

 

Robin Mattern  Robin is currently working on Procurement eCommerce 
1610 Apricot Court
Reston, VA 22090
703 456-0110
Email Address

 

 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 

 

Alan McConnell  McConnell Data Management, Inc. Database applications, client/server applications, and web applications. Contributing Writer for Access/Office/Visual Basic Advisor magazine. Works with MS Access, Borland Delphi, and Visual Basic.  
4124 Lake Harbor Road
Norton Shores, MI 49441
231-638-2391
Email Address

 

 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 

 

Tom Meeks  Predominantly developing in Visual FoxPro 6.0 and designing web interfaces. Focusing on user oriented web page design. Currently working on creating a web portal site as a platform for experimenting with techniques for selling on the web. 
5208 Flanders Avenue
Kensington, MD 20895
301-933-4309
Email Address

 

 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 

 

Bruce Parker  Bruce has been developing complex computer systems for over 30 years. He is currently developing both Web-based applications (using HTML and Active Server Pages with Microsoft's SQL Server) and PC-based applications (with Microsoft Access). For his Web applications, he has developed a series of "code generators" and software libraries that enable him to easily develop sophisticated Web applications, based on electronic specifications, for surveys, reporting, and data entry/edit. He also has extensive experience with VB and Fox Pro. 
827 Fontaine St
Alexandria, VA 22302
202-361-3894
Email Address

 

 
Project: EZ Data Surveys
Project Web: http://ezdatasurveys.com
Owner: EZ Data
Dates: 2002,2001
Location: Arlington, VA
Role: System Analysis, Design, Production
Duration: 10 months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
EZ Data Surveys allows customers to create surveys using a simple text editor. The survey is uploaded to the web and produce a web survey.
 
Project: EZ Data on the Web
Project Web: http://ezdataontheweb.com
Owner: EZ Data
Dates: 2002,2001,2000
Location: Arlington, VA
Role: System Analysis, Design, Production
Duration: 6 Months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
EZ Data on the Web allows customers to upload their data from spreadsheets or Access into a SQL Server with automatic web forms and reports.
 

 

Richard Schinner  Richard has more than 22 years experience with computers. He is a recent Computer Science graduate from the University of Maryland and is the founder and owner of eVantage, LLC since 1996. He is a software/database developer with more than 30 years of broad operations experience that gives him the ability to understand a project in ways many other developers cannot. This understanding allows him to create exactly what the customer needs in a very short time. He has developed several outstanding applications in the manufacturing industry. The most comprehensive is PFEP (Plan For Every Part. This copyrighted program is available for small to large manufacturers.

For more information: Resume; Email 
15622 Blackberry Drive
Gaithersburg, MD 20878
301-977-5196
Email Address

 

 
Project: 123 Easy Card
Project Web: Http://123easycard.com
Owner: 123 Easy
Dates: 2002
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 4 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
123 Easy Card allows customers to create electonic business cards and greeting cards.
 
Project: Federal Interagency Databases Online
Project Web: Http://fido.gov
Owner: Office of Government-wide Policy GSA
Owner Web: http://www.gsa.gov
Dates: 2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
FIDO provides access to database that are used by many agencies. A score300 chart is available to compare agencies across numerous data collection processes.
 
Project: Project Management Office
Owner: Marriott Corporation
Owner Web: http://www.marriott.com
Dates: 2002
Location: Bethesda, MD
Role: System Analysis, Design, Production
Duration: 5 months
Type: NT4, Access
The PMO system tracks activity across Disciplines and Projects. The information is centrally controlled at the PMO office.
 
Project: Financial Management Systems Inventory
Project Web: Http://fido.gov/fmsi
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2002,2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 24 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Federal agencies use FMSI to report information about the Financial Managemnet tools that they use. The information is used to assist in budget preparation and monitoring.
 
Project: Standards Gov
Project Web: http://standards.gov/
Owner: National Institute of Standards and Technology
Owner Web: http://nist.gov
Dates: 2002,2001
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 6 months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
Standards.Gov is a one-stop location for finding information related to the use of voluntary consensus standards in government. Each federal agency web site (as well as state and local governments sites) has important, standards-related information. Locating that information can be a time-consuming and difficult task. At Standards.Gov, you can find links that take you directly to the information you want, thus reducing time and effort spent in needlessly locating and then searching numerous agency web sites.
 
Project: FINANCIAL MANAGEMENT SYSTEM INVENTORY
Project Web: http://www.fmsinventory.gov
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 4 months
Type: NT4, IIS4, SQL7 database, XML, Access
The Internet was used to allow Federal Agencies to report the status of their financial management systems to the Office of Management and Budget. In 2001 over 280 federal employees reported on 1426 systems. The system included security and a link to the dMail service to allow tracking of email related to this project.
 
Project: OFFICE OF WEIGHTS AND MEASURES
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 2000
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 3 months
Type: Access97, Multi-user NT4.0
This project allows the OWM office to collect information about NIST members and merge it with the National Committees database. It also tracks the training for members. It produces a directory, labels, class roles and certicates.
 
Project: AUTOMATED MENU SYSTEM
Project Web: http://evantageone.com/ams
Owner: eVantage, LLC and Dessez, Inc
Owner Web: http://evantageone.com
Dates: 2000
Location: Gaithersburg, MD
Role: Back Office Design and Production
Duration: 1 year
Type: NT4, IIS4, SQL7 Internet database
This project converts Richard Schinner's fabulous Airline Catering menu system to the Intenet. Now kitchens and corporate from all over the world can get updated airline, food and equipment information in real time.
 
Project: WEB TIME CARDS
Owner: KPMG
Owner Web: http://www.kpmg.com/
Dates: 1999,1998
Location: Arlington, VA
Role: Design and Production
Duration: 3 years
Type: Internet Data Processing - Windows 95/NT - Access
The TIMEX system manages cards from KPMG employees and contractors. Individuals input their time sheet data over the Internet through a secure SSL connection. The data is analyzed and reported via an Access 97 application that is also connected via the Internet.
 

 

David Schmucker  David is currently CEO of DataOverTheWeb.com a database development company specializing in Microsoft db products used over the web. He started working with databases back in the Dbase II days in 1980 with a large real estate firm. Extensive experience with all versions of MS Access and has a broad business background. 
4424 Windom Pl. NW Suite 100
Washington, DC 20016
202-276-5100
Email Address

 

 
Project: Tabulate
Project Web: http://tabulate.com
Owner: Tabulate.com
Owner Web: http://tabulate.com
Dates: 2000,1999
Location: Washington, DC
Role: System Architect, Design and Production
Duration: 1 year
Type: Web Scrubbing and Analysis
Our business is managing and protecting domain names. Since 1998, Tabulate.com has been developing systems and satisfying clients with it innovative search and protection capabilities. Tabulate.com principals are seasoned software and business professionals. The world wide web is producing remarkable challenges. Many firms can tell you your business profile on the web, Tabulate.com is the first to focus on domain names, their impact, activation and deactivation on a real-time basis.
 
Project: TRANSPLANT SYSTEM
Owner: University of Maryland Medical System.
Owner Web: http://www.umm.edu/
Dates: 1997,1996
Location: Baltimore, MD
Role: Design and Production
Duration: 12 months
Type: Multi-user LAN - Windows 3.x/95/NT - Access 2.0 -
The Transplant (TX) project was designed to replace the client's existing FoxPro computer system and manual patients records system . The project scope included Patient Tracking, electronic links to UNOS and internal UMMS patient systems.
 

 

Bruce Troutman  Bruce is an expert in managing the development of web database and client-server applications using HTML, XML, Active Server Pages with SQL Server and Oracle. Since 1986, his successful projects include for the Federal Interagency Database (fido.gov), NATO Summit Management System, Federal Advisory Committee Act System, Standards.gov and the Exxon Valdez Oil Spill Transportation Management System.

He is president of the Institute of Database Developers, past-president of the Washington Area Visual Interdev User Group, Mid-Atlantic Access User Group and Potomac Area Foxpro User Group. 
PO Box 3261
Falls Church, VA 22043
202-460-8020
Email Address

 

 
Project: OFFM Help System
Owner: Department of Homeland Security
Owner Web: http://www.dhs.gov
Dates: 2003,2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 3 months
Type: Win2000, IIS5, ASP, VB, SQL2000, XML, Access
 
Project: Solicitor's Contingent Liability Network System
Owner: Department of Interior
Owner Web: http://www.doi.gov
Dates: 2003
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 4 months
Type: Win2000, IIS5, ASP, VB, SQL2000, XML, Access
Attornies update case status for agency potential liabilities exceeding $300,000. This is an Intranet solution.
 
Project: Security Clearance Tracking System
Owner: Department of Homeland Security
Owner Web: http://www.dhs.gov
Dates: 2003
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 3 months
Type: Win2000, MSAccess
This system allows for the tracking of progress of security clearance for employess and contractors within the Immigration and Naturalization Service (INS).
 
Project: CFO Measurement Tracking System
Project Web: Http://fido.gov/mts/cfo/
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2011-2003
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 4 months
Type: Win2000, IIS5, ASP, VB, SQL2000, XML, Access
Federal agencies report values of 8 indicators on a monthly basis. The MTS system tracks and provides graphic analysis over time. Results are provided to senior management in support of the President's Management Agenda.
 
Project: Travel Management System
Project Web: http://www.iptravel.com
Owner: In Loco Parentis Travel
Owner Web: http://www.iptravel.com
Dates: 2003
Location: Bethesda MD
Role: System Analysis, Design, Production
Duration: Ongoing
Type: Win2000, IIS5, ASP, VB, SQL2000, XML, Access
Exchange students travel across the world through out the year. The system tracks the travel arrangements and actual travel, so that a student's location is avaliable in real-time on the Internet.
 
Project: Financial Improvement Progress System
Project Web: Http://fido.gov/fips
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2011-2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Federal agencies are audited each year. The FIPS system tracks audit information and findings. Agency initatives are associated with findings to track progress of the improvements discovered in the findings.
 
Project: Project Management Office
Owner: Marriott Corporation
Owner Web: http://www.marriott.com
Dates: 2003,2002
Location: Bethesda, MD
Role: System Analysis, Design, Production
Duration: 5 months
Type: NT4, Access
The PMO system tracks activity across Disciplines and Projects. The information is centrally controlled at the PMO office.
 
Project: Federal Interagency Databases Online
Project Web: Http://fido.gov
Owner: Office of Government-wide Policy GSA
Owner Web: http://www.gsa.gov
Dates: 2011-2002
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
FIDO provides access to database that are used by many agencies. A score300 chart is available to compare agencies across numerous data collection processes.
 
Project: Financial Management Systems Inventory
Project Web: Http://fido.gov/fmsi
Owner: Office of Management and Budget
Owner Web: http://www.whitehouse.gov/omb/
Dates: 2011-2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 12 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
Federal agencies use FMSI to report information about the Financial Managemnet tools that they use. The information is used to assist in budget preparation and monitoring.In 2001 over 280 federal employees reported on 1426 systems. The system included security and a link to the dMail service to allow tracking of email related to this project.
 
Project: Standards Gov
Project Web: http://standards.gov/
Owner: National Institute of Standards and Technology
Owner Web: http://nist.gov
Dates: 2003,2002,2001
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 6 months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
Standards.Gov is a one-stop location for finding information related to the use of voluntary consensus standards in government. Each federal agency web site (as well as state and local governments sites) has important, standards-related information. Locating that information can be a time-consuming and difficult task. At Standards.Gov, you can find links that take you directly to the information you want, thus reducing time and effort spent in needlessly locating and then searching numerous agency web sites.
 
Project: 123 Easy Card
Project Web: Http://123easycard.com
Owner: 123 Easy
Dates: 2003,2002
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 4 months
Type: NT4, IIS4, ASP, VB, SQL7 database, XML, Access
123 Easy Card allows customers to create electonic business cards and greeting cards.
 
Project: EZ Data Surveys
Project Web: http://ezdatasurveys.com
Owner: EZ Data
Owner Web: http://ezdataontheweb.com
Dates: 2003,2002,2001
Location: Arlington, VA
Role: System Analysis, Design, Production
Duration: 10 months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
EZ Data Surveys allows customers to create surveys using a simple text editor. The survey is uploaded to the web and produce a web survey.
 
Project: EZ Data on the Web
Project Web: http://ezdataontheweb.com
Owner: EZ Data
Owner Web: http://ezdataontheweb.com
Dates: 2003,2002,2001,2000
Location: Arlington, VA
Role: System Analysis, Design, Production
Duration: 6 Months
Type: XML,NT4, IIS4, SQL7 database, XML, Access
EZ Data on the Web allows customers to upload their data from spreadsheets or Access into a SQL Server with automatic web forms and reports.
 
Project: XML Do It Now!
Project Web: http://xml4all.com/ASP/OtherLocations.asp
Owner: XML4All
Owner Web: http://xml4all.com
Dates: 2001
Location: Washington, DC
Role: System Analysis, Design, Production
Duration: 3 Months
Type: XML,NT4, IIS4, SQL7 database
Course was created to explain the XML tools available for doing XML now.
 
Project: Standards Annual Report
Project Web: http://standards.gov/annualreport
Owner: National Institute of Standards and Technology
Owner Web: http://nist.gov
Dates: 2003,2002,2001,2000
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 3 months
Type: NT4, IIS4, SQL7 database, XML, Access
The process uses the Internet to collect annual report information about the Standards activity of Federal Agencies. Information about the use of world-wide standards is particularly important.
 
Project: Standards Committee Members
Project Web: http://standards.gov/MemberSearch
Owner: National Institute of Standards and Technology
Owner Web: http://nist.gov
Dates: 2003,2002,2001,2000
Location: Alabama, Maryland, Virginia, Pennsylvania
Role: System Analysis, Design, Production
Duration: 3 months
Type: NT4, IIS4, SQL7 database, XML, Access
The process involves a new calling web server and existing remote servers at NIST, DOD and NASA. The user browses to the calling server. The calling server uses standard CGI scripting to contact the remote servers. The remote servers retrieve the desired information from their databases, format it and return it to the calling server. The calling server combines and formats the results using state of the art XML and XSL, returning HTML to the user’s browser.
 
Project: Office of Weights and Measures
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 2000
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 3 months
Type: Access97, Multi-user NT4.0
This project allows the OWM office to collect information about NIST members and merge it with the National Committees database. It also tracks the training for members. It produces a directory, labels, class roles and certicates.
 
Project: Case Management System
Owner: Department of Interior
Owner Web: http://www.doi.gov
Dates: 2000
Location: Washington, DC
Role: Enhancement
Duration: 2 months
Type: Multi-user LAN Access 97
Provided enhancement support for the tracking of legal cases as they flow through the Department of Interior.
 
Project: Automated Menu Ssytem
Project Web: http://evantageone.com/ams
Owner: eVantage, LLC and Dessez, Inc
Owner Web: http://evantageone.com
Dates: 2003,2002,2001,2000
Location: Gaithersburg, MD
Role: Back Office Design and Production
Duration: 3 months
Type: NT4, IIS4, SQL7 Internet database
This project converts Rick Shinner's fabulous Airline Catering menu system to the Intenet. Now kitchens and corporate from all over the world can get updated airline, food and equipment information in real time.
 
Project: Patient Tracking System
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 2000
Location: Gaithersburg, MD
Role: Enhancement and Production
Duration: 2 months
Type: Multi-User LAN - Access 97
NIST was provided with enhancements to their existing system that performs work flow management of the Patent Application Process.
 
Project: SecureAddress
Project Web: http://secureaddress.com
Owner: DataCall Systems.com
Owner Web: http://secureaddress.com/dessez
Dates: 2011-1999
Location: Fairfax, VA
Role: System Analysis, Design, Production
Duration: 5 months
Type: NT4, IIS4, SQL7 database, Internet Certificate
SecureAddress.com is a secure web server that serves as an Application Service Provider platform. It uses a Thawte certificate to implement SSL security. It uses BlackIce as an early warning system. It also uses Microsoft's Security Configuration Editor to tighten up NT4. The hardware has multiple redundancy levels at the disk drive and controller levels. Server is hosted at CAIS Internet Services.
 
Project: Time Cards System
Project Web: http://secureaddress.com/tcmp
Owner: eVantage, LLC and Dessez, Inc
Owner Web: http://evantageone.com
Dates: 2000,1999
Location: Gaithersburg, MD
Role: System Analysis, Design, Production
Duration: 3 months
Type: NT4, IIS4, SQL7 Internet database
The project converts old style time card processing to the Internet. Data is collected from employees, approved by the client and forwarded on to billing and payroll.
 
Project: GEO Locator System
Project Web: http://www.ehp.com/locator
Owner: Employee Health Programs
Owner Web: http://www.ehp.com
Dates: 2000,1999
Location: Bethesda, MD
Role: System Analysis, Design, Production
Duration: 6 months
Type: NT4, IIS4, SQL7 Internet database
Created a locator system that allows EHP clients and staff to find the closest EHP facility based on Address. The system connects in real time to the Centrus Tiger database for current latitude and longitude information.
 
Project: Education Data Mart
Project Web: http://secureaddress.com/eddm
Owner: PriceWaterhouseCoopers
Owner Web: http://www.pricewaterhousecoopers.com
Dates: 2000,1999
Location: Fairfax, VA
Role: Enhancement
Duration: 3 Months
Type: Solaris, Oracle
I provided for PwC and the North Carolina Department of Public Education a prototype of a web application that produced mailing labels and other standard reports.
 
Project: FACA Database
Project Web: http://fido.gov/facadatabase
Owner: General Services Administration
Owner Web: http://www.gsa.gov
Dates: 2011-1987
Location: Washington, DC
Role: Enhancement and Production
Duration: 48 months
Type: NT4, IIS4, SQL7, XML, Internet database
The 2 year old FACA Database received a face lift and additional reporting capabilities. A new Public area was created that allows anyone to log one and view or download data from the system.
 
Project: Server Up
Owner: Server Up, LLC
Dates: 1999
Location: Arlington, VA
Role: System Analysis, Design, Production
Duration: 8 months
Type: NT4, IIS4, SQL6.5 Internet database
Server Up periodically checks servers around the world to determine that they are running. Emails are sent, if the server is down. It logs results in a Sql Server database.
 
Project: NATO Summit
Owner: Departments of State and Defense
Owner Web: http://www.state.gov
Dates: 1999
Location: Washington, DC
Role: Design and Production
Duration: 3 months
Type: Internet - Multi-user LAN - Windows NT - Access 97
The project supported the NATO Summit's 50th Anniversary meeting. The system provided credentials for 2,000 foreign dignitaries and 10,000 US citizens. The Summit staff was able to monitor Airport arrivals and departures , Hotel and Event information. The Operations Center was managed using a real-time Incident System from their browser. The technology used was NT 4.0 and Active Server Pages.
 
Project: Web Time Cards
Owner: KPMG
Owner Web: http://www.kpmg.com/
Dates: 1999,1998
Location: Arlington, VA
Role: Design and Production
Duration: 3 months
Type: Internet Data Processing - Windows 95/NT - Access
The TIMEX system manages cards from KPMG employees and contractors. Individuals input their time sheet data over the Internet through a secure SSL connection. The data is analyzed and reported via an Access 97 application that is also connected via the Internet.
 
Project: Committee Web System
Owner: General Service Administration
Owner Web: http://www.gsa.gov
Dates: 1999,1998,1997
Location: Washington, DC
Role: Design and Production
Duration: 12 months
Type: 1,000+ Users - Internet - Multi-user LAN - Windows
The Committee Management Secretariat is responsible for tracking almost 1,000 committees and 13,000 members from 60 agencies of the Federal Government. The new web based system replaces the formerly manual paper system. Representatives from each agency log in to the system via a Netscape or Internet Explorer browser and updates their appropriate data. The data is used by an Access application to produce a written report that is sent to the President and then forwarded to Congress.
 
Project: Web Directory
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 1998
Location: Gaithersburg, MD
Role: Design and Production
Duration: 3 months
Type: Internet - Multi-user LAN - Windows 95/NT - Access
This project updates the original SAMI database from Access 2.0 to Access 97. Also provided is a searchable web database feature that allows users to analyze the directory on-line. Finally committee members can update changes in their status through a browser from any point on the internet.
 
Project: Employee Assitance Program
Owner: Employee Health Programs
Owner Web: http://www.ehp.com
Dates: 1998 ,1997
Location: Rockville, MD
Role: Design and Production
Duration: 3 months
Type: Multi-user LAN - Windows 95/NT - Access 97
The EAP system manages employees of subscribing organizations who need assistance with various emotional problems related to family and/or the workplace. The system processes the initial contact, evaluation, assignment of a counselor and periodic notes about the case.
 
Project: Publications System
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 1997
Location: Gaithersburg, MD
Role: Design and Mentoring
Duration: 3 months
Type: Multi-user LAN - Windows 95/NT - Access 97
The Publications project was designed to replace the client's existing legacy database R:Base for DOS computer system. It manages the process of technical publications throughout NIST at both of the Gaithersburg and Boulder locations. The process includes editorial review, production, accounting, and inventory/distribution control.
 
Project: GATT Web System
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 1997
Location: Gaithersburg, MD
Role: Design and Production
Duration: 3 months
Type: Internet - Multi-user LAN - Windows 3.x/95/NT - Ac
The GATT project involves the collection and management of proposed standards from the World Trade Organization in Switzerland. This data is collected via the Internet and then imported into an Access database. As events take place regarding each item, additional information can be added by NIST personnel. Full featured filtering and reporting was included.
 
Project: Day Care System
Owner: District of Columbia
Owner Web: http://www.washingtondc.gov/
Dates: 1997
Location: Washington, DC
Role: Design and Production
Duration: 3 months
Type: Multi-user LAN - Windows 95/NT - Access 97 - SQL S
The Day Care project manages the assignment of eligible children to authorized day care providers. It replaces a legacy Paradox system. The eligible children are provided from a main frame system. Providers are captured by the system. The link is made by a case worker. Histories are provided. A future enhancement will link the assignment to the billing system.
 
Project: Automated Transcription System
Owner: University of Maryland Medical System
Owner Web: http://www.umm.edu/
Dates: 1997,1996
Location: Baltimore, MD
Role: Design and Production
Duration: 8 months
Type: Multi-User internal LAN - Access 2.0 - Oracle
The Transcription project was designed to allow the automation of doctor review of transcribed dictation for patient charts. The doctor dictation is transcribed by an off-site service who downloads the text to UMMS. The text is imported into the Transcription system and routed back to the doctor for review. Integration with the existing hospital systems and the downloaded text files provided the most significant challenges on this project.
 
Project: Telecommunications Order Processing
Owner: Cable & Wireless, Inc.
Owner Web: http://www.cableandwireless.com
Dates: 1997,1996
Location: Vienna , VA
Role: Design and Production
Duration: 14 months
Type: 100+ User Windows 3.x/95/NT, SQL Server 6.5, Acces
The Proposal, Order Entry and Provisioning System (POPS) project was designed to replace the client's manual order entry computer system. The design consisted of 200+ tables and data imported from multiple existing systems. A key component was the master customer table, which allows multiple systems to utilize a single customer list. The system will run on the desktop of each sales representative around the country and at headquarters. POPS Mail is a device which keeps all responsible parties informed of significant changes in the status of an order.
 
Project: Transplant System
Owner: University of Maryland Medical System.
Owner Web: http://www.umm.edu/
Dates: 1997,1996
Location: Baltimore, MD
Role: Design and Production
Duration: 12 months
Type: Multi-user LAN - Windows 3.x/95/NT - Access 2.0 -
The Transplant (TX) project was designed to replace the client's existing FoxPro computer system and manual patients records system . The project scope included Patient Tracking, electronic links to UNOS and internal UMMS patient systems.
 
Project: Oracle to Paradox Billing System
Owner: Cable & Wireless, Inc.
Owner Web: http://www.cableandwireless.com
Dates: 1997,1996,1995
Location: Vienna, VA
Role: Design and Production
Duration: 6 months
Type: Multi-user LAN - Access 2.0 - Oracle
The ATB project was designed to replace the client's manual efforts of extracting provisioning information from a mini-computer and keying it again into a PC based system. It is estimated that 6 man-years of manual efforts was saved. The challenge with this project was connectivity with an very large Oracle database and the formatting of Paradox files with this data.
 
Project: Super Work In Progress System
Owner: Cable & Wireless, Inc
Owner Web: http://www.cableandwireless.com
Dates: 1997,1996,1995
Location: Vienna, VA
Role: Design and Production
Duration: 6 months
Type: 200+ User Windows 3.x/95/NT, SQL Server 6.5, Acces
The Super Work in Process (SWIP) system was developed to replace the client's existing spreadsheet system. Information from existing order processing data stored in MS SQL Server and provisioning data in stored Oracle was merged into a management system that allowed for improved tracking of an order's progress through the provisioning system. The system is highlighted by its unique "pull" distribution system and automatic ODBC connectivity.
 
Project: Patient Log for Baseball Games
Owner: Camden Yards Emergency Medicine, UMMS
Owner Web: http://www.umm.edu/
Dates: 1996
Location: Baltimore, MD
Role: Design and Production
Duration: 3 months
Type: Single User, Access 2.0
The ORIOUMMS project was designed to allow for the tracking of injuries sustained by fans, players and employees at the baseball games at Camden Yards in Baltimore. The significant challenges here were related to the format of the roll-up reports.
 
Project: NIST Directory
Owner: National Institute of Standards and Technology
Owner Web: http://www.nist.gov
Dates: 1996,1995
Location: Gaithersburg, MD
Role: Design and Production
Duration: 4 months
Type: Multi-user Novell LAN - Access 2.0
The NIST Directory project was designed to replace the client's existing computer system. The system was designed, tested and implemented in 4 months. The existing system required several difficult processes including "sneaker net" to function properly. The new system provides a single point of data entry and will print out the source documents for printing.
 
Project: Drug Test Processing
Owner: Employee Health Programs
Owner Web: http://www.ehp.com
Dates: 1996,1995,1994
Location: Bethesda, MD
Role: Enhancement and Production
Duration: 15 months
Type: Multi-user Novell LAN - Windows 3.11 - FoxPro 2.6
The MRO project was designed by another company. 80/20 was asked to assist in the maintenance and enhancement of several aspects of the system. Prospective employees for many of the nation's leading businesses take drug screening tests. These results are delivered electronically into the MRO system. Negative results are formatted into e-mail, fax or telephony formats and made available to the employer. Positive tests require a doctor's screening before results are confirmed. Technologies used were: Microsoft Mail, Windows NT, Visual Basic for the telephony pieces.
 
Project: Direct Mailing
Owner: AB & C Group - Vienna, VA
Dates: 1994
Location: Charlestown, WV
Role: Design and Production
Duration: 4 Months
Type: Novell LAN 3.11 - FoxPro 2.6
AB & C provides direct marketing support for Compaq, the National Rifle Association and On-Line America. The project was designed to provide support for client requests under a unified FoxPro interface. The use of multiple Novell file servers and HP minis required close coordination between MIS staff and the FoxPro team. A systems required data transfers between the various servers. There are presently three sub-systems in place: Compaq Customer Surveys, Healthy Directions Selects and Credit Card Processing for NRA.
 
Project: Telephone Operations and Provisioning
Owner: Capsule Communications (US Wats)
Owner Web: http://www.capsulecom.com/
Dates: 1994,1993
Location: Philadelphia, PA
Role: Design and Production
Duration: 18 months
Type: 100+ User Novell LAN 3.11 - FoxPro 2.6
The ACIS project was designed to replace the client's existing computer system. The system was designed, tested and implemented in 4 months. Over 100 megabytes of data was imported from the older system. The project scope included Customer Service, Marketing Support and Provisioning. Computer driven interfaces to Bell Atlantic, WILTEL, NYNEX and ALLNET was provided. Remote dialup capability was provided to resellers for adding customers. Billing data was merged for the benefit of Customer Service and Collections.
 
Project: Main to LAN Accounting System
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.
 
Project: Govenment Services System - SERVICENET
Owner: Department of Family and Children Services - GA
Owner Web: http://www.fultondfacs.org/
Dates: 1991
Location: Atlanta, GA
Role: Design and Production
Duration: 7 Months
Type: 149 Single user and 10 Novell LANs - FoxPro 2.0
ServiceNet is a downsizing project designed to replace a main frame system. It collects information on such areas as child abuse, adoption, adult protection and service providers for the 159 counties in Georgia with a central system in the state office in Atlanta. There are 40 data files covering over 1000 items of information with more than 30 reports.
 
Project: Engineering Resource Managment
Owner: Parsons, Brinkerhoff / Tudor
Owner Web: http://www.parsons.com
Dates: 1991,1990
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 6 Months
Type: Single user - FoxPro 2.0
The Engineering Resource Management System provides for the collection of the budget, forecast and actual man-hours required to design projects for the Metropolitan Atlanta Rapid Transit Authority (MARTA). There 30 data files and 37 reports covering 550 items of information. The system is installed at the two PB/T offices as single user workstations. The system is designed for a future multi-user setup on a local area network.
 
Project: Pulp and Paper Manufacturing System
Owner: Boise Cascade
Owner Web: http://www.boisecascade.com/
Dates: 1991,1990,1989,1988,1987
Location: Kenora, On
Role: System Analysis, Design and Production
Duration: 18 Months
Type: Multi-user Novell LAN - 7 user - FoxBase +
This system provides for the capturing of more than 1600 items of information involving the production and quality control of newsprint. The networked procedures include data entry into the Paper, Pulp, Lost Time, Energy, Environmental and Quality sub-systems. Periodic reporting is available for daily, monthly and ad hoc reports. There are 69 predefined reports currently available on the Pulp and Paper System. Customers can query the data in any order based on any selection criteria and can export the selected data to other programs.
 
Project: Oil Spill Management System
Owner: Exxon USA, Valdez Oil Spill Project
Owner Web: http://www.mobil.com
Dates: 1990,1989
Location: Anchorage, AK
Role: System Analyst, Design and Production
Duration: 18 Months
Type: Multi-user Novell LAN - 65 user - Clipper
The Tracking System is designed to record the activities required to effectively manage the clean up of spilled oil as a result of the grounding of the Exxon Valdez tanker. The system tracks contracts, bids, invoices, vessels, aircraft, personnel, scheduling and fuel. The system consists of 146 data and index files covering more than 900 data elements. There are 50 standard reports. It runs on a network with more than 65 authorized users accessing the more than 100,000 records from various cities in Alaska and Texas.
 
Project: Job Search System
Owner: Claremont-Brannan
Dates: 1990,1989,1988,1997
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 6 Months
Type: Multi-user Alloy LAN - 4 user - FoxBase +
This project provides the opportunity to match job candidates with prospective employers. Information about both the candidates and employers are collected in two data files encompassing more than 200 items of information. The candidate database is scanned for matching criteria and selected candidates are recommended to the employers.
 
Project: Retail Sales System
Owner: Jackson Music Store
Dates: 1990,1989,1988,1997
Location: College Park, GA
Role: System Analysis, Design and Production
Duration: 4 Months
Type: Single user - FoxBase +
This system was designed to automate a manual bookkeeping system for a retail music store. The transaction volume is in the low thousands per month and includes more than 200 items of information about sales and banking transactions.
 
Project: Insurance Claims System
Owner: Henning and Associates
Dates: 1988,1987,1986
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 6 Months
Type: Multi-user Alloy LAN - 3 users - FoxBase +
This system collects information for multiple insurance carriers including the names, carriers, and policy data. Over 240 storage locations are used. There are 22 options providing management reports on various subjects including Daily Case Status, Claims vs. Collections Analysis, and monthly reports.
 
Project: Movie Catalog System
Owner: RBT Enterprises
Dates: 1988,1987,1986,1985
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 16 Months
Type: Single user - FoxBase +
Over 5,000 movie titles are maintained with this system. The are related files about the actors, directors, set designers, etc. These files can be joined to provide multiple views of this database. Movies can be selected based on type, box office receipts, academy awards or actor name. Over 450 items of information are collected and 62 reports are available.
 
Project: Time and Billing System
Owner: Hagan Communications
Owner Web: http://www.hagancommunications.com
Dates: 1988,1987,1986,1985,1984
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 9 Months
Type: Single user - FoxPro
This generic system allows for the collection of times and expenses covering multiple employees, jobs and customers. Invoices and job status reports are produced. Over 150 fields of information are collected.
 
Project: Medical Records System
Owner: Scottish Rite Children's Hospital
Owner Web: http://www.scottishritechildrens.org/
Dates: 1986
Location: Atlanta, GA
Role: System Analysis, Design and Production
Duration: 3 Months
Type: Single user - FoxBase +
This project encompasses the processing of patient records at a children's research hospital. The clinic provides assistance in the areas of plastic surgery, speech therapy, dentistry and orthodontics. There are 386 items of information collect on each patient during twice a year visits. The doctors can select from 9 reports for patient analysis prior to the semi-annual visit.
 
Project: Advertising Sales System
Owner: Mikronis Consulting - Omni Publications
Dates: 1986
Location: Sarasota, FL
Role: System Analysis, Design and Production
Duration: 2 Months
Type: Multi-user Novell LAN: 5 users - FoxBase +
Magazine ad sales activity is collected for up to 10 sales people and 5 publications. The sales representatives entered the sale information into 1 of 5 screens and receipt a calculated invoice amount based on the size, color and position of the ad. Management can choose from 12 reports to analyze the results.
 
Project: Commercial Real Estate System
Owner: Gulf Bay Properties
Dates: 1986,1985,1984,1983
Location: Fort Myers, FL
Role: System Analysis, Design, Production
Duration: 12 Months
Type: Single user - dBase
A major land bank in Florida required the ability to project sales and development over a 25 year period. Data entry is accomplished through 11 screens covering over 320 items. The 15 reports cover cash flow, lender pay back and profit and loss statements by multiple divisions of the project.
 
Project: Real Estage Management System
Owner: Royal Gulf Properties
Dates: 1983,1982,1981,1980
Location: Fort Myers, FL
Role: System Analysis, Design, Production
Duration: 48 Months
Type: Single user - dBase
The Real Estate Management System was used to track sales and listings for over 100 sales agents and over $10 million in sales.
 

 

Karl Zercoe  Karl is a database application developer with Titanium Software, Inc. in Houston Texas. He has been consulting full time since 1992. He is an expert in Visual FoxPro and is currently also developing applications in VB.net/IIS/ASP.net and SQL Server. B.S. in Computer Science Texas A&M University, 1986, Microsoft Certified Solution Developer (MCSD) and MCP in Visual FoxPro and Access. 
P.O. Box 980788
Houston, TX 77098
713-942-7296
Email Address

 

 
Project: SNICERS
Owner: KEMPES (A Kemper Insurance Company)
Owner Web: http://www.kempes.com
Dates: 2000, 1999, 1998
Location: Scottsdale, AZ
Role: Design, Production and on-going Support
Duration: 3 years
Type: Multi-user LAN WIN98/NT/2000 VFP 6.0 Word
SNICERS is a public entity insurance rating, policy issuance and endorsement system. This system is used by twelve insurance companies in the U.S. as part of their working relationship with KEMPES. SNICERS does complex state specific rating calculations of towns and cities in 48 states and involving over twenty different coverage lines. (Automobiles, Buildings, Property, Crime, General Liability, etc.) The system also contains a policy issuance module with over 700 client supplied form templates and thousands of fields. Many of these fields are automatically filled in with data from the rating system. Other required fields are filled in by the user through the form templates in Microsoft Word. The user entered data is stored in a database. The actual completed form is not saved to disk. When a particular form from a policy is needed the matching form template and stored data are combined to display or print the final form. The system was written in Visual FoxPro using OLE automation to control Word for the forms handling.
 
Project: MAIN FRAME TO LAN ACCOUNTING SYSTEM
Owner: Mobil Oil Corporation
Owner Web: http://www.mobil.com
Dates: 1993,1992
Location: Washington, DC
Role: Design and Production
Duration: 14 Months
Type: Multi-User Multiple Novell LANs - FoxPro 2.5
The Mariner accounting project is a PC-LAN enhancement to a main frame system. It processes information about the activities of Mobil's world wide fleets and maps the data into the general ledger on the network. The system then formats and transfers the data to the main frame in Dallas. It receives transactions from Dallas and records them in the general ledger. The total system consisted of 1,400 programs and 250 database tables.