I currently lead the Data Warehouse team as well as manage the BI program to develop Genworth's Enterprise Data Warehouse (EDW) and BI Solution utilising SAS, Informatica, Tableau and Essbase toolsets. My key achievements to date have been:• Leading the Data Warehouse team of 6 people (4 Informatica ETL developers; a solution architect and a tester).• Driving the direction and scope of the BI program to deliver: o A foundational EDW star-schema based upon the business-defined master data list. o A suite of business-driven data marts. o Automated reconciliation to the Financial General Ledger data. o The enhancement and automation of over 30 key enterprise reports.• Successfully proposing and introducing Tableau software as the enterprise-wide data visualisation and reporting tool – including the following: o Writing and presenting the business case. o All facets of vendor management, including software evaluation, contract negotiation and software deployment. o Designing and documenting the software architecture and governance model.• Increasing the delivery pace of the BI program by introducing Agile principles to the projects (formerly run using Waterfall methodology).• Introducing controlled access to the EDW via a SAS security model using SAS Management Console.• Migrating the data dictionary of the enterprise master data list from an Excel spreadsheet to Informatica Business Glossary software, making it available via the intranet.• Providing business and architectural expertise into the BI program.• Managing all facets of the BI program including: o Writing business cases and reports. o Defining the budget and capacity required to deliver the program’s objectives. o Developing and maintaining project plans. o Managing risks, issues and actual financials. o Building and managing relationships with key BI stakeholders and external vendors o Reporting to a steering committee of senior leadership team members.

I was approached by a director of AXA Insurance UK to design and implement a completely new SAS data warehouse for pricing and underwriting. For 3 years I recruited and managed a team to undertake this project. Used by 150+ Actuaries, Data Analysts and Underwriters, key to delivering a successful data warehouse was to understand the varied and complex business requirements of the users. The data warehouse extracted and conformed data from over 40 different sources and was used for pricing analysis, pricing optimisation modelling, customer marketing analysis and claim reserving. My statistical and analytical background placed me in a strong position to understand these requirements. Built on an Inmon model, the data warehouse had:• Foundation marts supporting technically proficient users wishing to analyse the data using data mining techniques• Aggregate summary marts designed to answer specific business questions aimed at the non-technical users• SAS user project areas for ad-hoc analyses of the data, hierarchically structured to encourage sharing of programs, macros, data and formats

Upon the successful delivery of the suite of BI reports (see previous role), Direct Line Group again invited me to undertake another project. The project was to design and develop a SAS data mart for pricing optimization as part of the existing data warehouse. Understanding the business objectives of the Pricing Optimization team was key to the success of the project and led to implementing model scoring into the data mart and developing BI reports to assess model performance.

After the successful completion of the data warehouse project (see previous role) with Direct Line Group, they invited me to undertake a new project of designing a suite of BI reports to sit on top of the data warehouse. The suite contained reports such as weekly and monthly conversion packs, as well as some more peculiar and interesting reports such as:• Spill & Recapture Report: graphs & tables monitoring the churn of customers between the group's brands.• Rate Raider Report: using statistical techniques such as fitting an exponential distribution to the data to detect rate raider and other spurious quotes hitting the group's brand websites.

Direct Line Group hired me as a SAS Developer to be part of a team that designed and implemented a SAS data warehouse from scratch for insurance pricing and underwriting. The data warehouse was used by 200+ Actuaries and Data Analysts for pricing analysis. The data warehouse delivered standardised data marts for the Group's 20+ insurance brands and products. Key to handling the immense number of different data extracts was designing the main components of the transformation stage to be metadata driven.

During this 6 month contract in the BI team, I was responsible for developing new BI reports for the Finance Department. The reports manipulated data stored in a SAS data warehouse developed in DI Studio to produce Excel and HTML based tables and charts.

I was hired as a Statistical Consultant for a 6 month contract to manage a project to develop GARCH and ARIMA time series models. The models were built using SAS/ETS to forecast future values of a wide spectrum of economic factors. These factors were incorporated into a logistic regression model to predict the number of mortgage defaults.

I worked on 2 separate roles at Direct Line Insurance. The statistical role involved building mailing campaign targeting models using logistic regression. The models replaced the previous mailing technique of “carpet-bombing” and delivered a significant increase in mailing performance. The SAS BI role was to design and develop a BI Solution for pricing and underwriting. This project involved meeting with the Actuaries and Underwriters to understand their requirements, determining the facts, dimensions and calculated metrics of the dimensional model, and finally implementing with SAS. The solution used Cognos as the reporting layer.

Virgin Media hired me for a 9 month contract to develop a BI solution for the Business Analysis, Marketing & Finance Departments to report on a number of metrics monitoring the Virgin Media website. After meeting with the various departments to understand their varied needs, I designed and implemented a number of SAS data marts to sit on top of their Oracle data warehouse. The reporting layer was a suite of static Excel and HTML based reports developed using SAS.

Working as part of the SAS Institute Technical Support help-line, my primary task was to show customers techniques for analysing statistical data. My specialist areas of SAS software were Enterprise Miner, STAT, ETS, IML, QC and OR modules. In addition to that role, I taught 1-3 day public SAS courses at the SAS Institute on topics such as Base SAS, Macro, Logistic Regression, Categorical Modeling and ANOVA. Working for SAS Institute Technical Support help-line gave me the opportunity to become grounded in all areas of SAS while at the same time gaining insight into the way clients were using SAS and the types of problems they were facing. The role was key to developing SAS problem solving skills that would become invaluable in every role that I have had since.