Technical architect of Cognos design for SAP implementation, Cognos environment upgrade and 2014 update.Recruited and managed 3 Cognos Teams (10 developers): SAP Change, BAU and Offshore. Delivered 6 reporting streams for SAPand data warehouse, 3 new environments on x64 10.2.1 structure and 2014 rework of 5 legacy streams, while maintaining BAU throughout. SAP Team: 3 Cognos, 1 ETL developero Upgraded data warehouse and all reporting streams for SAP.o Standardised all streams by delivering a single, conformed warehouse and 5 conformed powercubes.o Delivered 6 streams (HR, P&L, Balance Sheet, Order Intake, Order Book, and Operational Report) to support new SAP business processes. o Delivered combined company scorecard on new data warehouse in 8 weeks. Previous attempts had taken 18 months.o Rolled out transaction drill down functionality to every data set staged.UK BAU Team: 2 junior Cognos developers, 2 ETL developerso User count grew from 100 UK users to 200 users in UK, Ireland, US, KL and Australia.o Completed 2014 reporting updates. All 5 reporting streams updated to match new business organisation.o Upgraded all environments to Cognos 10.2.1 FP1 and x64. Moved all Cognos servers from physical machines to VMs in data centre, ahead of SAP implementation. Upgrade allowed single sign on for users in all offices, working on 3 different global networks.o Updated security profiles to match Cognos licensing model, considerably reducing effort for quarterly user audit.o Continued business led prioritisation model adopted in Summer 2013 for all BAU changes. Offshore BAU Team: 1 Cognos developer, 1 ETL developer, in Kuala Lumpur o Handled BAU data quality monitoring, BI platform support.o Created full exception reporting suite which captured all spurious data at point of load, allowing business to analyse, correct and reload.

Led team of 5, consisting of 2 ETL developers and 3 Cognos developers (2 junior developers in UK, 1 offshore)Worked with infrastructure team to correctly size and specify hardware for new UAT and Prod environments to handle increased user demand for the next 2 years using VM servers.Managed 5 reporting streams, covering P&L, Balance sheet, HR, Order book, Operational Report.Responsible for both support of the live reporting streams and delivering all new content development.Implemented new security and support procedure to reduce UK user wait times to meet 2 hour SLA.Trained both junior developers to support all live systems, reliably meeting 2 day SLA for all user issues.Designed and managed a new process providing separate business owners full visibility of the BI team’s workload, resulting in a fully prioritised and agreed work plan, reducing the competing demands on the team.

Acted as single point of support for all month end reporting issues for 12 months, including 2012 year end.Solely accountable for delivering P&L reporting to newly acquired subsidiary, NetReveal, running the project broadly along Agile principles.Supported new team lead by developing internal processes to give improved consistency in reporting design.As both stakeholder manager and developer, was responsible for all end user engagement including requirements capture, issues and risk management, milestone reporting, UAT and training.Moved all 4 independent projects onto a single FM model platform, allowing the team lead to better understand project interdependencies on data warehouse tables and begin task simplifying and streamlining ETL process.Delivered complete front to back reporting system using SQL Server, Datamanager, PowerPlay and Cognos 10. Created UAT environment and introduced UAT procedure for the existing team of 6 Cognos developers.Updated Datamanager ETL processes to include error reporting, balance checks and exception handling.

5 month career break for travelling around South America and South East Asia.

Cognos 8.4 environment, TM1 Cubes & Oracle Datasource, MDX ReportingRequested to move full time to the Balance Sheet Substantiation (BSS) project when development on OCL development was completed and project entered production.Responsible for my own stream of Cognos development and interactive Balance Sheet Sign off tool, allowing users to view, verify and and sign off data in the TM1 cube.Integrated 3 Cognos reports with in house UBS system for writing back data to Oracle database and TM1 cube.

Cognos 8.4 environment, TM1 Cubes & Oracle Datasource, MDX ReportingRequested to split time equally between TRACS and the Operation Cash Ladder (OCL) project.9 man project to develop an almost real time view reporting system of the bank’s cash intra-day trading position. Worked with one other Cognos developer to develop a highly customisable ‘1 screen fits all’ dashboard.Published 113 bespoke report views for users, all driven from a single report to reduce administration by 95%.Worked closely with TM1 developer to reduce portal run times by 40% using different cube design and javascript.Responsible for installing and supporting production environment, including bespoke IBM WebSSO software (developed on TRACS project).

Cognos 8.4 environment, TM1 Cubes & Oracle Datasource, MDX ReportingLead in house developer for the first large IBM project implementing both TM1 and Cognos; an integrated balance sheet reporting implementation for up to 1000 users. Worked closely with UBS users and IBM onsite consultants to match TM1 & Cognos features to requirements.Decided and successfully implemented strategy for security, server administration and reporting design.Responsible for ensuring best practice report design was applied to all current and future production content.Created and ran 3 hour training course for new key business users.Designed and installed Cognos 8.4.1 UAT, production and business continuity server environments.Worked closely with TM1 developer to design and implement TM1 cube data security for reporting.Created dashboard and report suite to automate sections of a manually produced daily management pack.Documented and completed handover of all reporting to a Cognos developer placed with the business.Responsible for server administration for UAT and production systems, including assessment of software patches and subsequent install where appropriate.

DART is a large Cognos 8.4 project running on Essbase cubes and Oracle database.Current responsibilities:Supporting curent production reporting system & security model.Delivering user training for Anaylsis Studio and Report Studio Express.Introducting new reporting streams.Managing a team of 3 offshore developers to deliver new reports, dashboards & commentary system.

GTB MIS is a new Cognos reporting project running on the same platform as DART for GTB Sales.Current responsibilities:Train 3 new offshore team members to produce consistent Cognos reports in MDX.Oversee technical delivery of all Cognos reporting.Advise on project direction for Cognos content, Essbase cube design and security set up.DART is a large, mature Cognos 8.4 project running on Essbase cubes and Oracle database.Current responsibilities:Supporting curent production reporting system & security model. Delivers over 100 report pages per day.Managing a team of 3 offshore developers to deliver new reports, dashboards & commentary system and support exisiting content.

Working to deliver DART project using Cognos 8.4 & Essbase reporting solution for Deutsche Bank as a senior developer.

Worked on several different dashboard and reporting projects and proof of concepts for Deutsche Bank in both London and New York.

Delivered reporting & dashboard suite in Cognos 8.2 for Johnson & Johnson.

Technical Sales Engineer

Technical Sales Role - providing CNC tooling and manufacturing consumables

Left to join sister company as key account manager