Tag: SQL Server

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
Uncategorized

All the Meetings on Atomic Energy

(IAEA : 1/03-3/03)

The website had been created in the days pre-Perl/CGI and used a proprietary way method for generating dynamic web-pages using tags. I was tasked with changing the way the search functionality worked which meant getting down-and-dirty with the code. I added new functionality to the website’s search; which has since been retired.

Results

  • improved search functionality