DMSwebIntranet-facing ASP.NET MVC web app backed by a SQL Server database Intensive Development September 2017-May 2018, with updates June 2018-April 2019
Demonstration video coming soon...
DMS is a department at Intel that manages a large library of architectural drawings in digital form, indexing them and checking them out to customers. Starting from another developer's initial work, I developed "DMSweb" and ancillary software to automate and streamline the process.
Indexing Documents – Developed an extract/transform/load (ETL) process, eliminating cumbersome & inconsistent manual updates.
- Used Autodesk's API for the .NET Framework to extract titles and related info directly from drawing files in the AutoCAD proprietary format.
- Parsed filenames that had been encoded according to the Intel file-naming standard, in order to associate applicable metadata.
- Developed a database schema to store all data and relationships.
- On the front end, the document index (formerly a spreadsheet) is now available in the customer's web browser, tagged with searchable metadata fields, and updated automatically (and often).
Selecting & Requesting Documents – Developed two separate interfaces for this (with some shared features), for two types of customer:
- For customers requesting digital files in native format, confidentiality rules require a formal request/update/check-out process. After entering some metadata, these customers can use the search interface to find documents, and request them with a few mouse clicks. This replaced the former error-prone process of emailing spreadsheets back and forth.
- Customers who merely need PDFs, for which there is no formal check-out process, can use the same search features and download PDFs directly via their browser without needing human assistance at all.
Fulfilling Requests – Developed an interface for the DMS department itself, for managing document requests.
- The web app helps the DMS team to prioritize, track and fulfill those requests, and to manage staff workloads.
- Customers can now monitor the progress and status of their requests in real time, without initiating a distracting email exchange.
- The team can extract and report data about request volume, trends, etc.
Bonus Capabilities resulting from having everything in a database for the first time:
- Display useful reference/lookup tables & edit the data.
- Track team performance metrics.
- Tabulate data for use by other automated tools.