Image of self in Comic Book effect, via Apple's Photo Booth application.

Code || VBA, .NET, SQL


Updates
2012-01-19 New F# Modules

The code base now includes a few F# modules created as part of my learning the language using Project Euler projects. One is a basic class for calculating standard deviation and variance, while the other contains methods for calculating speicalized series, e.g., ....more
2011-11-29 Thread Type Selection

Below are criteria to use when selecting a threading type, from a user claws in a stack overflow discussion It looks as threads in three different categories depending on the target ....more
2010-12-07 A LinkedIn Question

I regularly read and respond to relevant questions on LinkedIn, and below is an Access Db question I thought worthy of responding to.

Question:

Is it possible to get a Database job (MS Access) where i can work from home? ....more
2010-11-08 Recent Additions

Linked below is code using both C# and VBA, implementing variety of ideas, a threaded execution array, COM automation with C#/VBA, a VBA function, usuable as a worksheet function for array calculation, and WinForm code to retrieve information from the Outloo ....more
2010-09-25 How Do I Learn to Program

A short article appeared on 37 Signals, How Do I Learn to Program that I responded to:

For myself, it started with something like passion, ....more
2010-08-27 Exposing C# to VBA via COM

I recently toyed with creating a C# project that can be used to expose methods to VBA via COM automation. The project implements one form for printing, but otherwise has no UI. Included is a text file showing how to access and execute the methods via ....more
read all...

About This Site

Initially designed to share VBA code and resources, it has expanded to include work in SQL (T-SQL) and .NET (C#/VB.NET/ASP.NET/F#).

About Me

My current resume is focused on VBA for both Excel and Access, as well as .NET and SQL, within the financial technology environment, and I have programmed for a coterie of large investment banks and corporations on a variety of issues:

  • Market/IT Risk @ UBS Investment Bank
  • Trade management @ Deutsche Bank
  • Billing / Data quality @ NCR
  • Forensic accounting @ Deloitte
  • Server delivery cost reporting @ UBS
  • BCP @ Credit Suisse
  • Compensation review @ AIG
  • MS Office conversions @ ABN AMRO
  • IT management @ JP Morgan Chase
  • Project analysis @ Deutsche Bank

Other Sites of Mine

I also maintain a wiki for Access and Excel VBA code, VBA @ WikiDot, a newer site based and focused on .NET using ASP.NET and VB.NET, CodeDotNet, along with this and other sites. For personal development I am documenting learning F#, LearningF#, via Project Euler.