Solution Development: Portfolio

McData, Inc.

Interactive Web Site and Application

Dynamic database-backed internet presence for a major SAN/NAS systems provider interacting with both customers and partners: • Uses PHP scripting for dynamic display of information. • Back-end database is Oracle. • Database design normalized with foreign keys to insure data integrity. • Every page checks access level and redirects to a log-in/registration page if required. • Incorporates a publicly-accessible web site for marketing purposes. • Features a limited-access extranet for access by corporate partners and customers. • Used configuration management system to allow development from three sites. • Provides technical documentation for the web application using the DocBook documentation system, allowing easy generation of documentation in HTML, PDF, and Word format.

Microsoft Project Marketing Team

Project 2000 Digital Dashboard Demo

Demonstrates how to display Project Central groupware data for convenient viewing in users' e-mail programs: • Uses pre-release version of Project 2000 for Microsoft KM (Knowlege Management) worldwide seminar presentation. • Leverages the Outlook Today HTML page to display customized information. • Integrates into the Microsoft Digital Dashboard framework. • Uses JavaScript to manipulate element display dynamically. • Uses JavaScript in DHTML to access data, write to the HTML stream inline, and manipulate ActiveX objects. • Includes a white paper showing developers how to integrate the technology into their applications.

Paccar Inc.

Project 98-Outlook Today Groupware Integration

Shows Microsoft Project tasks and projects in Outlook Today to keep more than 100 project team members apprised of their tasks when they check their e-mail: • Leverages the Outlook Today HTML page to display customized information. • Uses ADO to query the Project98 database for the currently logged-on user's projects and tasks. • Uses a SQL Server 7.0 datastore with stored procedures for data access. • Uses server-based components to allow instaneous application deployment to client machines. • Uses DHTML to access data, write to the HTML stream inline, and manipulate ActiveX objects.

Elliott Bay Consulting

Online Personality Profile Test

Provides a method for automated personality testing for customers of a human-resources consulting firm: • Uses ADO to access data store through ODBC connection • Uses CSS positioning for personality profile results chart • Uses ASP to write CSS positioning statements into HTML stream • Uses DHTML for form validation. • Captures credit card information to integrate with Commerce Server. • Netscape/IE compatible methods used • Antialiased chart graphics

Microsoft Project Marketing Team

Office 2000 Outlook-Project Integration Demo

Demonstrates integration of technologies in Office 2000 with Project 98's existing functionality for use by the Microsoft Project 98 Marketing Team: • Takes advantage of the Outlook Today HTML page to display customized information • Uses ADO to query the Project98 database for the currently logged-on user's projects and tasks. • Uses Data Access Pages to display project/task data in standard HTML elements • Uses Office Web Controls to display projects/task data in the Spreadsheet, Chart, and Pivot Table controls • Uses DHTML to access data through ADO, write to the HTML stream inline, and manipulate ActiveX objects. • Uses Office Server Extensions to create web-based discussions and • Uses triggers to automatically create file system objects that allow for OSE to use as the basis of discussions and subscriptions. • Uses InstallShield scripting to create the Project98 schema with MSDE (Microsoft Data Engine) and populate configuration tables.

Microsoft AMO

Advance Marketing Operations Processor

Imports data from legacy database and sends email notifications of upcoming tasks for Microsoft Advance Marketing Operations team collaboration application: • Uses xp_sendmail extended stored procedure to send notification messages • Uses scheduled tasks • Used sp_OA* extended stored procedures for instantiation of ActiveX objects from SQL Server environment • Uses a combination of VB-based logic code and SQL Server-based parameterized stored procedures • Uses RDO for efficient invocation of parameterized stored procedures • Used LOC (lines of code) method to accurately estimate the number of bugs in and the amount of time required to debug this inherited project

Amtrak Northeast Corridor Human Resources

Amtrak Employee Training System (ETS)

Access-based database system for tracking employee training for the Northeast corridor branch of Amtrak: Amtrak Employee Training System (ETS) Access-based database system for tracking employee training for Amtrak Northeast corridor branch Access-based database system for tracking employee training for Amtrak Northeast corridor branch: • Multiform wizard-like interface with switchboard entry point • Uses a custom reports selection form which breaks up reports into categories and allows user to pick one or multiple reports for batch previewing or printing • Uses custom menus and toolbars • Used Access source code control extensions in conjunction with Visual SourceSafe to easily manage versioning on this project • Uses Office Assistant object model to unobtrusively offer additional help to users • Uses InstallShield for installation