Weinhaldenstr 37B Mobile: +41 76 390 2721
CH-8645 Tel:+41-55 214 2721
Jona Fax: +41-55 214 2724
Switzerland Email: firstname.lastname@example.org
A highly skilled senior IT consultant with an impressive track record of solutions development in international
corporate environments. Extensive experience in the harnessing of new technologies to achieve strategic
commercial aims. Strong European business perspective, with the mobility to locate within the UK and Europe.
March 2011- date IT Consultant at Helvetia Insurance, Basel.
Application developer on a project to complete a MS Access application for a pension planning tool.
Technologies employed: MS Access 2010 front-end to a SQL/Server 2008 database back-end.
June 2010 – March 2011 IT Consultant at Bank Morgan Stanley AG, Zurich,
Application designer and developer on a project to upgrade monthly regulatory reporting for investment
bank BMSAG, working inside Swiss banking secrecy laws. The project migrated the current solution
based on MS Access and manual procedures to a more robust and secure platform based ON MS SQL
Server. This phase addressed statutory reporting for the Swiss regulatory authorities. Information is
consolidated from various sources, including databases on Informix and Sybase. A follow-on project
developed a solution to automate data feeds to regulatory reporting for Financial Controllers. Prepared a
preliminary design for an application to report the requirements for accounts in segregated markets.
Reverse engineered an application to print customer confirmations in preparation for migration from VB6
to C#. Involved in support activities for the confirms application, including performance analysis of the
application's Sybase database. Technologies employed: MS SQL/Server 2005, SQL Server
IntegrationServices and SQL/Server Reporting Services, Autosys job scheduler and VB6. Shell scripting,
PERL and awk on Solaris platform for data extracts from Informix, Sybase and MS SQL Server.
July 2009-Oct 2009 IT Consultant for ITPS AG, Kreuzlingen.
ITPS provides professional services to a number of companies, primarily related to MS SQL/Server.
Performed a DBA role for ITPS’ customers, primarily in the banking sector. Responsibilities included
day-to-day supervision of MS SQL server installations, activities related to compliance and introduction
of the company’s backup application. Some development work in C# for a customer’s asset
management system. Platform: Wintel: MS SQL/Server 2000 and 2005. C#, T-SQL and batch scripting
July 2008-June 2009 IT Consultant for IBM Banking Competency Center (BCC), Prilly.
The BCC provides services to a number of banks in French Switzerland. Initially member of a team to
assist the BCC to prepare for audit readiness on the hosted customer servers. Activities included an
assessment of MS SQL server, MS Windows and MS IIS installations for compliance with IBM’s security
policies, together with support for other team members. On completion, performed a DBA role
responsible for backup and operation of the MS SQL Server instances, together with ongoing
responsibility for compliance. As part of the compliance effort, responsible for the implementation of a
backup and monitoring solution. Platform: Wintel: MS SQL/Server 2000 and 2005, T-SQL, VBScript and
May 2007-March 2008 IT Consultant for DWS Holding & Service GmbH, Frankfurt.
Designed and developed an application to create Excel templates for Asset Management reports. The
template application also provides a multi-threaded generation facility for the templates. The whole is
Page 1 of 4
integrated into an existing application framework. Additional tasks include maintenance of the existing
reporting application. Platform: C# (Winforms) with SyncFusion and Aspose components and Excel
automation, SQL/Server 2000, Windows XP and Visual Source Safe.
July 2006-April 2007 IT Consultant for Dresdner Kleinwort, London.
Member of a team to support a sub-ledger application to reconcile information coming from the front and
back offices, and make accounting postings from the consolidated information for the investment bank.
Primarily tasked with specifying, developing, documenting and implementing changes based on client’s
work requests. Platform: MS Windows 2003; Finarc’s Financial Studio package; SQL/Server 2000 with
T-SQL, DTS, stored procedures, user defined types (UDTs), user defined functions (UDFs), table and
view definitions; Visual Source Safe 6.0.
Dec 2005-July 2006 IT Consultant for Dresdner Kleinwort Wasserstein, Frankfurt.
Member of a team to implement a sub-ledger application to reconcile information coming from the front
and back offices, and make accounting postings from the consolidated information for the investment
bank. Primarily tasked with specifying, developing, documenting and implementing changes based on
client’s work requests. Platform: MS Windows 2003; Finarc’s Financial Studio package; SQL/Server
2000 with T-SQL, DTS, stored procedures, user defined types (UDTs), user defined functions (UDFs)
table and view definitions; Visual Source Safe 6.0 and some vbScript and batch job scripting.
April 2004 - Dec 2005 IT Consultant for Accenture.
Member of a team to design and develop data load routines for a major (ca. GBP 5 billion) project for the
UK’s National Health Service. Worked on both primary (Torex Synergy) and secondary (iSoft iPM) care
applications, on file validation, Audit and reconciliation and reporting components. Additional tasks
involved database performance monitoring and tuning. Recommended changes to improve the
performance of the vendor’s software. Platform: MS Windows 2003; SQL/Server 2000 T-SQL, stored
procedures and DTS; C# 2003; XML and XSL; vbScript.
April 2003 – April 2004 IT Consultant for ActivAD GmbH
Designed, developed and implemented web-based tool to conduct and manage SMS-based
competitions. Platform: MS Windows 2003; ASP/IIS with SQL/Server using T-SQL and stored
procedures, with web service components in C#.Net 2003.
1996 – April 2003 IT Consultant for Dow Europe GmbH
Offering contract-based web application and desktop database development services, primarily to
European arm of global chemicals and plastics manufacturer Dow (annual sales $27,609 million, with
33% in Europe).
Additional development projects delivered alongside Accenture BV, Dow’s outsourced development
Designed, developed and managed delivery of multiple pan-European desktop and web development
Oracle, SQL/Server, MS Excel VBA and MSWord VBA. Typical small project value $30-$50K.
Delivered pricing application to two European business units over 12 month period. Significant
commercial impact included formalisation and control of price negotiation, and improvements in pricing
data quality. The application includes an automated upload to SAP/R2. Technology used: MSIE,
Page 2 of 4
Designed and developed major application to facilitate price and manufacturing forecasting and
planning. Delivered to 3 of Dow’s 15 business units over a 3-year period. Technology used: MSIE,
Delivered key application to enable the production of highly commercially sensitive information
determining customer profitability, by allocating costs to sales, based on activity. Used globally across
multiple Dow business units by individuals responsible for the financial analysis of business
performance. Extensive consolidation and "Slice and Dice" functionality. Used Business Objects with
MS Access database and reporting components in MS Excel.
Developed distributed financial forecasting application with global reach, used by several Dow business
units in the four administration sites around the world. Used MS Access with Oracle 8i database to
collect financial forecast, actual and plan information and allow comparison at various consolidation and
Produced sales and purchase reporting application to present unit price information for performance
analysis and market price comparisons. Used Business Objects for data extraction and MS Access for
data consolidation, loading and reporting, with SQL Server database. Export functionality to MS Excel.
1994 - 1996 Project Leader at Dow Europe SA, Switzerland
Project leader for site workstation rollout
Project leader for accounting application decommission.
Facilitated Project Planning workshops.
Project Estimator for Europe.
1990 - 1994 Internal Auditor at Dow International Service Center NV, Belgium
Led and participated in Internal EDP audits.
Developed audit support software (IBM 370/MVS, Dyl/280, TSO/ISPF)
1983 - 1990 Project Leader/Developer at Dow Europe SA, Switzerland
Technical project lead on multiple development projects in IBM CICS Cobol and ADABAS/NATURAL
Extensive Data Modelling (IEW) and database design.
Provided technical and methodology consultancy for development group.
Pre 1983 Analyst Programmer
Excellent early IT experience as Analyst Programmer on IBM and ICL Cobol projects in UK companies.
Culminated in Technical Project Leader role on multiple key projects for CAP-Gemini in Zurich,
Education & Professional Memberships
Chartered Engineer (CEng)
Chartered IT Professional (CITP)
Member - British Computer Society (BCS)
Member - Association of Computing Machinery (ACM)
BA (Hons) Computing Science 1972 - University of Essex, U.K
English (Mother Tongue), German, French
Date of Birth: 13 December 1950
Page 3 of 4
Nationality: British/Swiss Dual National
References Available on Request
Page 4 of 4