Following acquisition of eBecs.

Following acquisition of Ascribe by EMISResponsible for:Modelling, architecture, design, and development of BI and data warehousing for national and international healthcare clients utilising SQL Server and related Microsoft technology.Client-facing requirements gathering, and analysis.Hands-on technical leadership of development teamsKnowledge-sharing and training of client staff on and off-site.Maintenance and development of EMIS' ETL Framework.Achievements:Delivery of first phase of substantial multi-year contract with high-profile NHS trust, replacing 10 year-old legacy data warehouse system.Delivery of innovative, message-based, real-time dashboard solution for a wide variety of clinical and management staff at a key Australian hospital, currently being rolled out state-wide.Providing mentoring, support, trouble-shooting and hands-on development on a wide range of other projects within the NHS, including a substantial Azure project - one of the first in the NHS.

Responsible for:BI team maintaining, developing and delivering BI to one of the largest divisions of MITIE, with nearly 1000 users.Managing Cognos reporting utilising Framework Manager.Upgrading to Cognos 10.2 rationalising security and licensing.Designing and implementing a migration away from Cognos Data Manager to SSISAchievements:Identified £100, 000+ savings in Cognos licensing.Delivering self-service reporting to finance teams – a considerable enhancement over the accuracy and timeliness of their existing management reports.

Responsible for:Technical leadership and mentoring for MITIE Group BI team.Analysis of business requirements.Data modelling, database design and implementation for SQL Server and SSASArchitecture, design, and implementation of ETL utilising SSIS and CognosReport and data visualisation design and implementation using SSRS and MDXSupporting pre-sales exercises for MITIE sales teamsProviding advice and internal consultancy to BI colleagues working in other areas of the MITIE businessAchievements:Analysis, architecture, design and build of data models, ETL and cube for 'MiWorld'; client-facing BI portal for MITIE's most important clients, including Vodafone and Rolls-Royce.Successfully met all deadlines for 'MiWorld' implementation, with positive client feedback.Four-fold improvement in the performance of Cognos Data Manager-driven ETL process, with associated benefits to resource utilization and robustness.Design and implementation of agile software lifecycle processes eg build and release, utilising Subversion, Team Foundation Server, and Visual Studio 2010.Support of sales activities within very short deadlines.Analysis, design and build of internal property management database system.

Clarity IntegrationResponsible for:Providing Business Intelligence (BI) and Data Migration (DM) consultancy to a wide range of businesses, including Three, Cable & Wireless and Centrica.Analysis, design and modelling of BI systems.Delivering elements of Clarity BI Methodology.Supporting Business Development Manager and Managing Director in pre-sales engagements and preparing bidsDeveloping functionality for ClearView RM BI toolset.Technical architecture of million pound data integration project.Delivering software components for external BI and DM projects.Achievements:Consultancy, technical architecture, development, build and deployment of Microsoft software for Scandinavian bank data migration/integration.Initial design and modelling of ClearView FE - pre-packaged Microsoft BI solution for further education colleges, successfully deployed at over a dozen colleges.Development of Microsoft BI solution to Lifetime Health & Fitness - rapidly growing, nationwide training organisation.Database performance tuning recommendations for Centrica and Cable & Wireless.Development of software libraries in C# and VB.NET for ClearView BI toolset.Analysis and modelling of requirements for Three mobile network operator.

Responsible for:Providing technical leadership and mentoring for the Reporting Software Development Team of Nokia Music.Architecture, and design, including dimensional modelling of all database reporting systems.Leading project to replace existing legacy financial reporting system with one based on SQL Server 2005 and data warehousing.Analysis of complex BI reporting requirements from a Europe-wide Sales and Marketing group and internal Finance team.Achievements:Analyzed and designed hardware and software architecture for 2005 data warehouse.Lead upgrade and development of 1 TB data warehouse and 'Report Browser' from SQL Server 2000 to 2005, resulting in substantial improvements in performance and usability.Moved team to greater use of agile methods using Team Foundation Server and Visual Studio Team Edition for Database Professionals ('Data Dude')Provided training and support to data analysis personnel performing ad hoc T-SQL querying of data warehouse.Upgraded existing batch-driven financial reporting infrastructure to Windows 2003 and SQL Server 2005, achieving performance improvements.

Responsible for:Development of data warehouse and on-going support of legacy reporting systems for Europe's top white-label music download service.Delivery of 1000s of reports to 100s of recipients including many blue-chip clients (Virgin EMI, SonyBMG, MSN) daily, weekly and monthly.Administration and maintenance of databases including scheduled jobs, backups, performance tuning and troubleshooting.Achievements:Performed dimensional modelling and physical design for data warehouse. Designed and wrote ETL using DTS.Achieved tight deadlines for report delivery every month whilst committed to support and development activities.Created individual, complex, bespoke financial reports for major blue-chip stakeholders including Sony, Universal Music, and MSN.Led development and managed roll-out of web-based interactive reporting tool using Analysis Services, MDX, T-SQL, Reporting Services, ASP.NET and VB.NET using data warehouse data. 'Report Browser' had over 300 registered users, including SonyBMG, Warner Music, Wanadoo and Tiscali.Managed small team delivering a 1 TB data warehouse based on SQL Server 2000 extracting 140 million records every day.

Responsible for:Development of reporting system based on SQL Server 2000, including Analysis Services and ProClarity for on-line life and pensions financial quotation serviceAdministration and maintenance of SQL Server databases including scheduled jobs, backups, and performance tuning.Administration and maintenance of IIS and COM+ servers.Supporting developers using SQL Server in application development.24/7 on-call cover for all production servers as part of production support team.Achievements:Data warehouse development which delivered daily on-line reporting using DTS, Analysis Services, MDX, VB6 and ProClarity. Analysis of business requirements for data warehouse reporting across the business - finance, sales and marketing, and operations.Analysis and design of software architecture for data warehouse.Modelling and physical design of data warehouse.Integration of Analysis Services with ProClarity Analytics 5.0 client for slice-and-dice ad hoc reporting.Operational support of OLTP databases and other servers to over a million quotes a month.Key part of development team which successfully delivered new Annuities quotation service on Assureweb platform.

Responsible for:Managing information flows between Gloucestershire Royal NHS Trust and the main commissioning body. Production of regular and ad hoc business information for seniormanagement.Achievements:Development of BI reporting from legacy mainframe systems via SQL Server 7.0 - DTS, OLAP Services - and Cognos Powerplay.