Solutions Architect at Scorecard Systems
Warrington, United Kingdom
Solutions Architect at Scorecard Systems
Warrington, United Kingdom
Business Intelligence and Data Warehousing professional with 10+ years of experience in putting data to work in smarter ways.
I have worked across the whole spectrum of BI from Business Analysis and Reporting to Data Modelling and Database Design, as well as Staff Management and Development.
Data Warehousing:
¬ Metadata, Data Cleansing, Integration (SSIS), SQL based ETL
Database Platforms:
¬ Teradata, Netezza, SQL Server, Postgres, MySQL
Data Modelling:
¬ Dimensional Data Marts, Data Integration, Requirements Analysis
Reporting:
> Report Automation, Executive Dashboards, Operational Reports & Alerts
Analysis:
¬ Demographics, Segmentation, Forecasting and Modelling
BI Tools:
¬ Business Objects, Reporting Services (SSRS), Crystal Reports, BRIO
(Privately Held; 11-50 employees; Telecommunications industry)
August 2008 — Present (4 months)
(Public Company; 10,001 or more employees; BARC; Banking industry)
December 2007 — August 2008 (9 months)
Solutions architecture and functional design of Teradata Data Warehouse applications.
(Privately Held; 501-1000 employees; Financial Services industry)
August 2006 — October 2007 (1 year 3 months)
Manage customer marketing database. Import and reconcile new data purchases. Provide reporting and analysis for marketing activity.
(Public Company; 501-1000 employees; Telecommunications industry)
April 2004 — July 2006 (2 years 4 months)
- Customer churn prediction model
- Financial data mart for fiscal reporting
- Customer lifetime value forecast
- Customer segmentation (by lifetime value)
- Tariff optimisation analysis (best plan advice)
(Public Company; 10,001 or more employees; Telecommunications industry)
March 1998 — April 2004 (6 years 2 months)
- Sales Territory Redistribution (O2 Corporate Sales)
- Corporate Customer Ownership Process
- Corporate Customer Reporting system
- 3rd Party Revenue Sharing System