Spreadsheet Control Projects

Any experienced developers out there looking for a role on a spreadsheet control project?

I have sniffs of a couple of roles here in sunny Geneva and also one in Luxembourg.

All for large financial institutions, all trading/banking, all looking at similar stuff.

  • Assess the current spreadsheet mess
  • propose solutions on a workbook by workbook basis, (either leave as is, tidy up, or migrate basically.)
  • Potentially assist/do or lead that work

Rates are market rate, between 3-600 quid depending on skill and experience. All are full time, on site, you’ll have to sort out your own travel and accom if you don’t live local to the roles. All are 3 months to start, with a good chance of an extension if you know what you are doing.

You’ll need:

  • good Excel skills and experience (min 5 yrs prob)
  • good VBA (min 3 yrs approx)
  • some none spreadsheet development experience (either relational db or .net or java or other lang)
  • full SDLC experience
  • Good financial services experience
  • Good analysis experience

If you are interested and think you meet the requirements then drop me a line with your CV and I will pass it on to the powers that be.



(send your cv to info@codematic.net)(dont send spam or viagra or ED offers – thnx)

6 Responses to “Spreadsheet Control Projects”

  1. A Dashing Blade Says:

    Surely not CSFB yet again attempting to remove spreaddy’s from the trading floor?

  2. Simon Says:

    not quite
    not this time anyway
    Are people still trying to do that?

  3. Marcus from London Says:

    You bet they are. In a prior role at an unnamed IB, the trader’s P&L and risk were calculated nightly in s/s which had circa 500,000 formulae.

    Nice to see you’re keeping busy BTW. I’m happily tied up for the time being.

  4. Simon Says:

    I meant are people still trying to get rid of s/s?
    thats so 1990. In more recent decades we have come to acknowledge the important part s/s play in the arsenal of enterprise IT tools. not all of though I guess…

  5. Marcus from London Says:

    Well then, yes and no.

    One aspect of the project I’m currently on involves removing the s/s element from collecting, validating and calculating data. This is being migrated to a ‘supported’, ‘production’ environment. (SQL Server, .Net etal).
    However, s/s are still being used as a user interface to that data via static reports, pivots and UserForms.

    At a prior gig, an unnamed IB was spending a lot of money (£m with 3 digits in it) in a regulator inspired project to remove the calculation portion of the traders s/s to servers while the s/s themselves remained intact.

  6. Cuspa Technologies Says:

    We’ve heard of a few so called spreadsheet eradication initiatives as well, but none that have been successful. Having said that there are

    (a) business process and activities that should be in controlled environments,

    (b) and other business processes that can exist in semi-structured environments that can involve spreadsheets (perhaps with critical data in managed storage)

    (c) and then there are applications in which spreadsheets are the best tool for the job.

    I think the key is to give managers the capability to see, in real time, what spreadsheets are being used for. In this regard we might have some tools that can help, but I’ll keep the blog pure (:-) and email some suggestions.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: