|
| 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 |
|
|
| |
|
|
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. |
|
|
|
| |
|
|
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. |
| |
|
|
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. |
|
|
|
| |
| 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. |
|
|
|
| |
| 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 |
|
|
|
| |
| 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. |
|
|
|
| |
| 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. |
|
|
|
| |
| 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. |
| |
|
|
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. |
| |
|
|
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. |
|
|
|
| |
| 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. |
| |