Categories
Backend demand-side Frontend Full-Stack SOA Troubleshooting

(Executive) Enterprise Dashboarding

(Yahoo! : 5/07-7/07)

An external consultant to the team had been brought in to develop an überdashboard to aggregate data from another project. The learning curve was steep and the consultant wasn’t familiar with the base data so his dashboard had some major shortcomings.

Results

  • Jumped in two weeks before release date, took ownership, and still delivered a web-based, executives’ dashboard solution for experience monitoring without the benefits of system documentation or tests
  • Reduced 74% page load-time through refactoring backend, improving database queries, introducing pagination for an 80 KLOC (LAMPerl) data warehousing web app
  • Discovered and remedied major data quality issues before going live
  • Radically improved the look and usability of the tool
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
Troubleshooting

Learning Languages

(Siemens : 02/01-03/01)

My first internship after my first semester of programming.

Supervisor, first day: “So, you know Visual Basic?”

Me: “Ummm, no. I?ve only worked with Modula2.”

Him: “Ok, well, grab yourself a book and we’ll reimburse you for it.”

… all in German.

In any case, the code was delivered a month later on-time and to-spec.

Results

  • Delivered software for reducing the time needed for Key Account Management by 65%