Month: May 2006

Categories
Backend demand-side Innovation Troubleshooting

Web-Based Document Management

(IAEA : 4/06-4/06)

We were charged with building an application to allow the customer to perform three essential tasks

  • upload documents (as PDFs) to the web
  • manage those same documents via a web-based interface
  • Apply business rules to the documents based on embedded properties (e.g. PDF XMP metadata)

The first version of the system has already allowed the customer to publish and manage 10 years worth of documents. The next 40 years of documents were to be uploaded as the customer’s schedule allowed.

Results

  • Delivered a Java-based document management system for managing 50 years of PDFs on-time after assuming project leadership when the Project Manager fell ill
  • Delivered a user-friendly custom solution for publishing PDFs directly to the web via the enterprise document management system
  • Managed the project to completion when the original Project Manager had to excuse himself during a crucial phase of the project
Categories
Analytics Database demand-side Frontend

Web-Based Data Warehousing Tool

(IAEA : 3/06-4/06)

The customer had been using static reports in the form of data cubes embedded in a VB 6.0 application. When he asked for a web-based way to view the information more dynamically, we chose OWC PivotTables as the way to go.

To realize the customer’s request, I created several cubes under MS Analysis Services and hooked them to PivotTables embedded in a web-page.

Results

  • Implemented a web-based, SQL Server-driven data warehousing solution for sales reporting using OLAP technology
  • Successfully upgraded customer’s reports one-for-one and gave customer greater insight on sales data
  • Created OLAP tools to pull and aggregate sales data on a daily basis