Project - Matteronline.com
Introduction
The primary goal of this project was to allow for closed loop management of investigation assignments from the time the client placed an order until the field investigator completed the investigation and delivered the evidence to the client.
With this new system in place Pinkerton's private investigation division would be able to meet the growing demand for investigations in the high-tech intellectual property rights world wide.
My Role
In this full-time contract position, I had the following roles and duties:
- Lead Developer
- Requirements Gathering
- Set and manage development timeline
- Identify and document change request
- UI Designer
- Application Prototyping
- Database designer - designed the db schema
- Lead Programmer - wrote 95% of all code
- Manage other programmers
- Database programmer - wrote all of the SQL, storeprocedures and triggers
- Database optimization - analyzed database performance and refined design to performance requirements.
- Release Management - worked with System Admin to cordinate application release.
Summary
| Start Date: |
April, 2000 |
| Release Date |
November 30, 2000 |
| Months to Complete: |
8 |
| Final Status: |
Released
|
| Current Status: |
Unknown |
| Lines of Code: |
21,000 apprx. |
| Developers: |
3 (1 full time, 2 part time) |
| Other Staff: |
1 Documentation/ Trainer
1 System Admin
1 Project Lead
3 Testers
1 Executive Sponsor |
| Budget: |
Unknown, but estimated at approximently $ 500,000 |
| URL: |
http://www.matteronline.com (at time of release, current location is unknown)
|
| Platform: |
Windows NT, IIS |
Database:
|
Microsoft SQL Server 7
|
| Programming Language: |
ASP
VBScript
JavaScript
|
Tools Used:
|
Microsoft Interdev 4.0
Microsoft SourceSafe
Visio |
| Markup Language: |
HTML
|
Features
- 100% Secured website using SSL on all pages due to the sensitive nature of the data
- 4 user interfaces (see User Guides)
- Event driven email notifications
- Work Flow Tracking
- Upload and process Execl and CVS files - rows where parsed and inputed in to the database.
- Digital photo & document storage via web browser
- Reporting
- Client order Status
- Order Assigment status
- Work load by Office and Agent
- Investigator - New Assignment
- Investigator - Pending Assignment
- Investigator - Next task due
- and many more see User Guides ....
- Web Data Entry for
- Addresses
- Inventory
- Digital files
- Work Flow
- Personal Data
- The Investigators Data entry screen was designed to accomidate dymanic data entry needs. The data entry fields that where displayed depended on which contract the investigators where working on.
- and much more...
|
