 Lead consultant on a financial Global Reporting project in Germany for Allianz Insurance, using a Rules Engine, Oracle and SAP to do ETL of financial ledgers from all EU offices of subsidiary (Euler Hermes) to group central SAP FI.
 Alongside assisting the programme manager to run the project, I advise on technical design and architecture, planning, risks, change control and directly manage 3 other Microgen consultants. I also assist the internal development team with technical ETL expertise.
 In addition, I have specific responsibility for managing Belgium business as part of the project, which has allowed me to assimilate some basic knowledge of the insurance industry (eg. difference between treaty and facultative reinsurance, coinsurance, value policies, viatical settlements).

 Various pre-sales work, architecture design and requirements analysis in Business Intelligence and Data Warehousing for clients

 Reporting to Group MIS Director for Europe
 Hired to analyse shortcomings of the group’s current BI solution, research immediate problems and implement short-term solutions, while researching a longer term replacement system, including analysis and selection of shortlist of vendors. Recommendations and costs presented to senior management for a new BI solution for 500 staff across 26 countries.
 Designed and built a prototype datawarehouse and management reporting solution in SQL Server 2005 to demonstrate to VP’s. Data sourced from several AS400 DB2 source systems using SSIS and reports provided in MS Reporting Services running on IIS in Windows 2003 Server. Activities undertaken cover requirements gathering, design, data modelling, systems analysis, ETL, design, project planning, SSIS, SSAS, SSRS and writing views and stored procedures in TSQL. Rewrote 20 Crystal Reports into Reporting Services.

 Reporting to MD, Company founder/owner.
 Short-term contract to install and configure SQL Server 2005 and upgrade 3 servers from SQL Server 2000 to SQL Server 2005, setup mirroring, performance tuning and re-write DTS packages as SSIS projects. Advise MD and Director of IT on best practice and train permanent DBA’s on SQL 2005.

 Reporting jointly to company owner/CEO and Director of IT. Daily reporting via VOIP and MSN.
 A work-from-home project to design, build and implement a data warehouse in SQL Server 2005 from a SQL Server 2000 OLTP e-commerce back-end, including data-cleansing and ETL.
 Analysis and reporting on global retail web transactions, including page/session data, product analysis, geographic analysis, customer analysis, upsells etc.
 Full life-cycle project including business analysis, requirements gathering, specification, design, test, build and documentation. Coding in TSQL, Data Modelling, SSIS, SSAS, SSRS.

 Reporting to the FD in Europe and VP for IT in the US, I was hired to design and develop 2 new data warehouses and enterprise reporting system, one for EU operations and one for US operations.
 Leading an on-site team of 5 SQL analysts/developers plus off-site team of 3 (1 in US, 2 in Canada)
 Responsibility for training technical staff on SQL Server 2000 and business users on the new warehouse and reports
 All ETL processes from various data sources (eg. AS400 DB2) designed & written in TSQL & DTS
 Responsibility for maintaining and updating approx. 100 regular management reports (Access & Excel based) and developing them in TSQL and MS Reporting Services for the new warehouse
 Working with senior management and the business owners to analyse operational & financial data, using TSQL, Access and Excel to drive improvements in the organisation
 Technologies: SQL Server 2000, Access, Excel, VBA, IIS, HTML, ASP, .NET

 Reporting to Global Head of HR and managing a team of 3
 Full technical responsibility for a new global enterprise BI system, interfacing to Peoplesoft and based on a data warehouse design. The system was to be accessible worldwide and from board level down, but needed a robust security design to restrict access to extremely sensitive data
 A 50/50 technical/management role to deliver a system that would allow managers to globally analyse compensation market data and compare and contrast it with the bank’s own
 Business Objects had been chosen as the reporting tool and I was required to quickly learn this product inside-out (Designer, Reporter, Supervisor & WebIntelligence), purchase it, test it, install and configure it, then roll-out and train the first 20 power users in various countries
 Full life-cycle project from analysis through to post-live maintenance, including hands-on development of both the back-end (PL/SQL, stored procedures) and a front-end web portal
 Significant ETL of data from other data sources and then analysing and reporting on that data using PL/SQL and Business Objects.
 Responsibilities included planning and delivering a world-wide roll-out plan, covering implementation, testing, documentation and the training of both the users and support staff
 Key business and technology contact for all aspects of the system including liaison with software suppliers, external consultants, network and server managers globally
 Further responsibility for maintaining and supporting the users of a business critical Access and Excel system and planning the migration of its data, business logic and users to the new system.
 The project involved regular, sometimes lengthy, overseas visits and often required remote working and unsocial hours due to the many time-zones involved
 Technologies: Oracle 8.16, PL/SQL, Business Objects 4.5-5.1, VB6, VBA, IIS, ASP, HTML
 Due to the project’s success (the system being adopted as part of the core ‘run-the-bank’ systems) UBS offered me a permanent role.

 Reporting to European MD, this was a hands-on role leading a mutli-skilled team on a Y2K projects for investment banking clients
 One of the biggest challenges presented was at Chase Manhattan, when the software we were using proved inadequate for the task. We rapidly designed and developed a new solution using VB6. My success resulted in Chase Manhattan requesting my help to manage their Y2K desktop project for Asia as it had run into serious problems.
 Technologies: VB, MS Access, SQL Server 2000, Crystal Reports.
 Viasoft offered me a permanent role and one of my team was recruited by Chase Manhattan.

 FICS develops software for financial companies and all software development was managed through a company-wide SQL Server 7 database.
 My prime responsibility was the management of the SQL Server 7 database and the development of enhanced front-end functionality using Visual Basic 5.
 I had additional work analysing, developing and documenting back-office Access 97 databases, with extensive use of VBA (eg timesheets, HR). I was offered a permanent role.

 This was a Y2K project to fully analyse a legacy database, including existing and new user requirements and then to build a compliant version in Access 97 with VBA. This included design, specification, build, documentation, user training and migration of the data.