Business Intelligence Consultant at Bank of America
London, United Kingdom
- Current
-
- Business Intelligence Consultant at Bank of America
- Past
-
- Business Intelligence Consultant at Catlin
- Business Intelligence Consultant at Company Net
- Business Intelligence Consultant at Bank of America
- Business Intelligence Consultant at Virgin Holidays
- Global Development Manager at Capco
- Managing Consultant at Anite
- Product Marketing Manager at FileNET
- Principle Consultant at Racal
- Product Manager at Canon
- Education
-
- Nottingham University
- Nottingham University
- Recommended
-
9 people have recommended Dr. John - Connections
-
321
connections
- Industry
- Financial Services
- Websites
Dr. John Tunnicliffe’s Summary
Experienced system designer with hands-on experience of implementing business intelligence solutions based on the latest Microsoft SQL Server OLAP technologies, delivered to the end-user through SharePoint 2007 portals.
Dr. John Tunnicliffe’s Specialties:
Business analysis, design and development of business intelligence, data warehouse and reporting systems. Also web-based software; content/document management consultant, knowledge management consultant.
Dr. John Tunnicliffe’s Experience
-
Business Intelligence Consultant
Bank of America
(Public Company; 10,001 or more employees; BAC; Banking industry)
October 2008 — Present (10 months)
Continuation of the design and implementation of a new global KPI reporting solution based on the Microsoft Business Intelligence suite delivered to the end-user via a SharePoint 2007 portal.
-
Business Intelligence Consultant
Catlin
(Public Company; 501-1000 employees; Insurance industry)
July 2008 — October 2008 (4 months)
Working with the data warehouse team to implement a GAAP-based P&L reporting solution. Currently responsible for cube design and deployment but will soon be rolling out PerformancePoint planning module.
-
Business Intelligence Consultant
Company Net
(Privately Held; 11-50 employees; Internet industry)
January 2008 — June 2008 (6 months)
Company-Net are building a new version of the RedOwl business performance management application for roll-out across the Bank of Scotland (HBOS).
John is designing the real-time OLAP dimensional model that underpins the analytical reporting along with an innovative SSAS security architecture that provides dynamic dimensional security.
John is leading a team of programmers to build the forecasting and planning elements of the product which uses data mining techniques to predict future demand.
Analytic reports are being built using AJAX-based components such as Dundas Charts using Visual Studio 2008 and the .NET framework v3.5. Much use has been made of CodeSmith and the .netTiers application framework whilst the Analysis Services (SSAS) interface had been built using MDX and ADOMD.NET. -
Business Intelligence Consultant
Bank of America
(Public Company; 10,001 or more employees; BAC; Banking industry)
October 2007 — January 2008 (4 months)
Design and implementation of a new global KPI reporting solution based on the Microsoft Business Intelligence suite delivered to the end-user via a SharePoint 2007 portal. The work has encompassed:
• design and development of a SQL database to hold the relevant business metrics including developing T-SQL stored procedures and functions
• design and development of an OLAP cube using Analysis Services (SSAS)
• developing Integration Services (SSIS) packages to download Excel files from SharePoint 2007 and extract data from the files using Aspose.Cells
• developing reports that use MDX to query the OLAP cube for deployment via Reporting Services (SSRS)
• customizing the SharePoint 2007 portal
• developing C# assemblies to automate tasks -
Business Intelligence Consultant
Virgin Holidays
(Privately Held; 501-1000 employees; Leisure, Travel & Tourism industry)
August 2007 — September 2007 (2 months)
Upgrading Virgin Holidays’ existing BI system to support two new back-end source systems (Oracle Financials & TravelBox) which will ultimately replace the aging VMS-based ATOP system. This involved data analysis, design of physical database schemas and the development of SQL scripts and SSIS packages.
-
Global Development Manager
Capco
(Privately Held; 501-1000 employees; Financial Services industry)
April 1999 — June 2007 (8 years 3 months)
Design and implementation of all business intelligence, management reporting and web-based business applications throughout Capco worldwide.
-
Managing Consultant
Anite
(Public Company; 1001-5000 employees; Information Technology and Services industry)
1995 — 1999 (4 years)
-
Product Marketing Manager
FileNET
(Public Company; 501-1000 employees; Computer Software industry)
1991 — 1995 (4 years)
-
Principle Consultant
Racal
(Public Company; 5001-10,000 employees; Computer Software industry)
1989 — 1993 (4 years)
-
Product Manager
Canon
(Public Company; 5001-10,000 employees; Computer Hardware industry)
1988 — 1991 (3 years)
Dr. John Tunnicliffe’s Education
-
Nottingham University
PhD , Chemistry , 1981 — 1984
For some obscure reason I wanted to play with toxic, carcinogenic chemicals for three years before I got a proper job.
-
Nottingham University
BSc Hons , Chemistry , 1978 — 1981
Hellish good fun!
- Activities and Societies:
- Chairman, Debating Union 1981
Additional Information
Dr. John Tunnicliffe’s Websites:
Dr. John Tunnicliffe’s Honors:
Leader of two ‘Innovation Award’ winning projects
1: Automated sales proposal production for BOC won a 'Business Innovation Award’
2: Linklaters Blue Flag was awarded the prestigious ‘Innovation Award’ by The Lawyer magazine.
