Wayne Wilcox Email & Phone Number

Birmingham, West Midlands, GB

Ipsley Church Lane, Redditch, Worcestershire, GB

Bicester, GB

• After contracting at Unipart Automotive for 2 years became permanent
• Leading projects from BI perspective involving PDA data, processing of said data using the existing conformed dimensions for use by internal and external users
• Both front and back end development work including Microsoft SQL Server Integration Services, IBM Cognos Framework Manager and IBM Cognos Report Studio using a Production environment in Cognos 8.4 and a development.
• Training of other technical resource from basic understanding of data warehousing to unsupervised requirements gathering and proficient report authoring
• Support business users as the company was sold from Unipart Group to H2 Equity Partners (adding security to the cubes, the relational data structures and the folder structures and user capabilities in Cognos Connection)
• Monitoring server performance and overnight data loads using RDP to predict, diagnose and fix issues as they arose.

Oxford, Oxfordshire, GB

Returning to continue contracting as a technical report writing resource in Cognos BI (8.4.1) using Cognos Report Studio and Cognos Framework Manager over multi-dimensional data sources to develop analytics, reporting and dashboards for finance and business users including training permanent members of staff in relational and dimensional report writing.

A founder of the company, responsible for the BI consulting architecture practice at Teme Ltd, a new initiative bringing the highest quality IT Architects, Programme / Project Managers and Business Analysts to SME and corporate clients.

Short term contract to use IBM Cognos Data Manager to extract data from an Oracle database into a newly created conformed Data Warehouse following the Kimball methodology on a SQL Server 2008 back end. At the same time training permanent members of staff in IBM Cognos 10 Data Manager, Framework Manager and Report Studio.

Oxford, Oxfordshire, GB

Five month contract as a technical report writing resource in Cognos BI (8.4.1) using Cognos Report Studio and Cognos Framework Manager over multi-dimensional data sources to develop analytics, reporting and dashboards for finance and business users including training permanent members of staff in relational and dimensional report writing.

Amsterdam, NL

• Four month contract to get projects delivered for the MoD in the UK based on an IBM Cognos 8.4.0 environment, including:
• Developing, testing and tuning of 40+ IBM Cognos Report Studio reports with multiple pages / versions depending on the report output and prompts entered including HTML and JavaScript in reports for a more user-friendly.
• Reporting on the IBM Cognos Metric Studio package data creating dashboards and reports available to the users through IBM Cognos 8 Go! Office;
• Reporting on the audit log of trended report analysis and report failure rate;
• Supporting the onsite EDW development team with issues with their current environment / infrastructure.

Chertsey, Surrey, GB

A catering company, working in the IT Department. For the last six years this was as a Data Warehouse developer responsible for the construction of a conformed Data Warehouse environment using the Cognos toolset following the Kimball methodology using a SQL Server 2000 back end with about 400 Gb of production data and over 200 Cognos users.90% of the data.