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
Categories
Analytics Content Management demand-side Full-Stack Innovation

Multilingual Workflow Application

(IAEA : 8/03-10/03)

To more efficiently track internal publishing, the IT section created a custom workflow application in October of 2003. The application serves approximately 50 people all the way from editors to translators to printers to distributors.

Results

  • Worked with multi-lingual users to implement v2.0 of a translation workflow application
  • Gathered requirements after leading focus group sessions with users speaking Chinese, French, Russian, English, Spanish, Arabic
  • Migrated v1.0 data store from MS Access to SQL Server
Categories
demand-side supply-side

Leading Students

(ASIST : 09/02-04/03)

President, Webmaster, Liason: all different hats I wore while reviving the chapter. In the previous year, almost had nothing been done and the chapter was almost defunct.

Results

  • Led chapter as President to 400% growth in membership