Responsibilities:
• Design authority for datawarehouse solution based on AS400 source system.
• Design and implement Cognos installation and configuration, including security model and language.
• Development of framework manager models and configuration control/release processes.
• Development of SQL server ETL (SSIS) and SSAS OLAP cubes to support BI solution.
• Performance tuning database and Cognos solution, DR provision and data integrity strategy.
Achievements:
• Delivery of Cognos BI suite to tight deadline.
• Redesign of third party solution to provide cost savings

Responsibilities:
• Provide consultancy services to the defence industry fulfilling a business intelligence role
• Integration of Cognos 8 into complex technology stack including Websphere AS, LDAP, Siteminder and Oracle.
• Team lead a group of Cognos 8 report developers, technical guidance, best practice and design authority.
• Configuration, deployment and release management of Cognos 8 deliverables.
• Provide advice on training, support and deployment issues.
• Design and develop meta data models.
• Design and build Oracle star schemas using Oracle Designer and TOAD.
Achievements:
• Delivery of Cognos report suites and meta models to 3 month deadline.
• Delivery of Cognos development framework to support future development projects.
• Production of full design documentation and test plans.

Responsibilities:
• Provide consultancy services to the defence industry fulfilling a data architect role
• Provide technical documentation to support multi-million £ data migration projects
• Project manage evaluation and implementation of Cognos 8 into existing product suite
• Development of proof of concept business intelligence solution incorporating a SQL Server datamart and Cognos 8 dashboard solution.
• Provide UML and data modelling and design support to data architecture team
Achievements:
• Introduction of business intelligence technology into the business and achieved successful implementation
• Designed and delivered product data dictionary to support SOA project

Responsibilities:
• Managed data team consisting of up to eight permanent and contract resource
• Administration and maintenance of all SQL Server databases and delivery of corporate data strategy
• Provision of data related bid material and client presentation of capabilities
• Evaluation of business intelligence capability and implementation of Cognos Reportnet toolset
• Development of complex KPI solutions using Cognos Metrics Manager.
• Development of complex interfaces to support application integration.
Achievements:
• Built up data capability from team of two to respected department within business
• Business intelligence offerings instrumental in a number of bid wins
• Introduction of data availability SLAs and vast improvement in stability and availability of data

Responsibilities:
• Gather requirements and design database solutions to support the delivery
• Design and develop ETL routines to populate datamarts and datawarehouses using SQL Server DTS
• Design and build Analysis Services OLAP databases
• Development of complex dashboards and metrics to support performance management reporting
Achievements:
• Design and development of scalable datawarehouse reducing build times from two weeks to thirty minutes
• Development of dashboard technology providing intuitive reporting environments
• Produced OLAP cubes allowing millions £s of aged debt to be recovered

Responsibilities:
• Manage activities of four man reporting team
• Build and design ETL routines to support report delivery
• Design and build SQL Server datamarts and Analysis Services OLAP solutions
Achievements:
• Introduction of Cognos Impromptu to provide reporting toolset
• Delivery of large scale ETL project to timescale using Datastage software

Responsibilities:
• Lead a team of four analysts in cleansing data in preparation of loading into a database
• Test data once loaded into database
Achievements:
• Started as analyst, promoted to team leader within 3 months of starting