• Cognos installations and upgrades including multiserver distributed environments and custom portal branding.• Requirements gathering, analysis, design and implementation.• Kimball compliant Datawarehouse design and development on Microsoft SQL Server and Oracle platforms using SSIS and Cognos Datamanager ETL tools.• Relational, DMR and dimensional modeling in framework manager / transformer• Relational and dimensional report authoring inc. dashboards and scorecards• Provision of customized training in Query, Analysis and Report studiosPrincipal sectors and projects include:Assurance and Pensions: Salesforce.com integration using Virtual View Manager; Self Invested Pension Plans; Pensions Regulator data quality compliance; Box management.Transport: CRM / IP Telephony; Vessel capacity scorecarding; Ticketing Datamart.Daries: Metrics Studio fuel usage and reconciliation scorecarding.Education: Student Attendance / Attrition; Finance.Local Authorities: Finance reports; CRM; CRM Complaints; Barrachd Absence Management / HR solution.

Large finance project for Greene King breweries, Suffolk, using DMR and Transformer multidimensional models, including P&L Trial Balance reports. Created an AP invoice reconciliation model and reports.

• DB administration and integration of approx 10 different SQl Server source systems (Retail, Supply Chain, HR, Finance ...) plus Oracle photograpic process control systems.• Justified the business case for a Datawarehouse / BI development project• Designed an expandable datawarehouse in accordance with Kimball methodology using SQL Server SSIS as ETL tool.• Conducted a BI tool trial (Oracle BIEE, Business Objects XI, Cognos 8, Microsoft SQL Server BI Stack)• Implemented Cognos 8 Framework Manager Model, Transformer OLAP model, and dimensional reporting solution.

• Development of a client / server RPC application written in C to return query results over TCP/IP to Windows clients from Digital Alpha servers. • Design, development, implementation and commissioning of a dual fibre FDDI ring / Ethernet industrial instrumentation LAN for British steel Teesside. • Design and implementation of a bespoke Visual Basic / SQL Server database application for British Steel Port Talbot.

Software development of bespoke chemical analyser instrumentation systems for a nuclear fuel reprocessing plant. Analysis,and design using Yourdon methodology implemented on System Architect CASE tool, development in Pascal running on OS9 (ROMable UNIX like Operating System)

Operation and maintenance of Texas Instruments data collection and navigation system mainframes onboard Seismic Survey ships.