Darren Harvey Word CV

Document technical information

Format docx
Size 110.9 kB
First found May 22, 2018

Document content analysis

Category Also themed
not defined
no text concepts found





Resume / CV
Business Intelligence Solution Designer Portfolio Manager
Darren Harvey MCITP, MCTS, MCSE
Personal Profile
UK Security Clearance: Clear + Scotland Disclosure
Office - +44 (0) 208 1 333 153
Mobile - + 44 7830 130 600
Mail - [email protected]
Full Name - Darren Harvey
Date of Birth - 28/05/1977
Nationality - British
Location - UK – South
Professional Summary
 A practiced solutions architect, development consultant and team lead of management information business intelligence
initiatives, enterprise data warehouse development, analytics, trending and forecasting systems and information visualization
solutions specifically specialising in the use of High Visual and Trending Data Mining to add serious value to enterprise data..
 Following a proven set of conventions and appropriate methodologies, can prove best practice analysis, management and
development of multiple enterprise deliveries.
 Completed 56 high profile Business Intelligence and information related implementation projects, with references and portfolio.
 Master of building rapport with extensive people skills and a great capacity to succeed in challenging situations.
 Excellent listening, leadership and client handling and customer facing interpersonal skills.
 Results focused with strategic foresight and clarity, exceptional documentation and conclusive work streams.
 Distinctive ideas generator with problem solving, business analysis, design and process acumen.
 Technically resourceful with an array of skills in design, engineering, data management and IT to an advanced level.
 Ability to plan, co-ordinate and mentor, within timescales and expectations.
 Prince2 Practitioner, Scrum Alliance Certified Scrum Master and Agile development team leader
Skills Summary
 Enterprise Architecture, Data Architecture, Systems Architecture. Business analysis and database Consultation
 MCITP & MCTS Microsoft Accredited Business Intelligence Developer SQL Server Development Specialist (SQL 2005 - 2012) and MCTS
Microsoft Office SharePoint Services technical specialist (MOSS 2007- 2013). Application Development with ASP.Net 4/4.5 and MVC.
 Report and analytics creation expert in SharePoint Office 365 , Qlikview, Business Objects XI, SQL Server Reporting Services SSRS,
Performance Point, Powerview, Powerpivot, Cognos 8, Crystal Reports, Oracle Reporting, Access Reporting, .NET charting and
reporting, Tableau, Flash Report Generation, PHP development , PowerPoint
 Data modeller and designer of relational data warehouses and information applications in SQL Server 2008 R2/2012, Oracle,
Teradata and MySQL utilizing Erwin, ERStudio and/or Visio, Strong T-SQL programmer and practitioner of Kimball, Inmon and
Lindstetd methodologies.
 ETL / ELT Development expert in SSIS, SAP Data Services, Informatica PowerCenter, Talend. Well-equipped in C# Programming.
 OLAP data warehouse specialist and Semantic Business Intelligence development expertise through SQL Server Multidimensional
and Tabular Analysis Services / 2005/2008/2012 SSAS, Cognos, Business Objects Universes, Oracle Discoverer/Hyperion and
developer of additional bespoke systems. Strong scripter of DAX, MDX and DMX.
12 Years
Systems Analysts, Design and implementation
Building, motivating, nurturing development technicians in Business
Intelligence and Data Warehouse development
Planning, Control, Change Management, Budget Planning,
Resource & timeline management
Network infrastructure, Server/Hardware configuration and security
Business Analysis / Design within BI and Data
Ability to design processes procedures and documentation.
Understand and negotiate, plan and prioritize.
13 years
MIS/Business Intelligence Development
Database/Mart development, Reporting design, MI Analysis and
Business Objects, Oracle and SQL Server deployment
Advanced SQL Server, Business Objects Crystal Reports, Access,
Excel Development
Dimensional modelling, Data warehousing design and Business
Programming, testing and implementation
13 years
Project Management of data related projects
Performance/Visualization Information, MI and
Data Analysis
Data Architecture
Application Development
12 Years
13 years
10 years
9 years
7 years
Industry Exposure
Media, Television and Online Web Analytics
Energy, Utilities
Insurance, Financial & Large Call-Centres
Investment Banking
Stock Exchanges, Trading Systems
Capital Markets Banking, Loans, Hedging and
Clearing, BACS and Payment processing
Banking and ATM processing
Supply Chain, Retail Transactional processing.
Health & Leisure (Fitness/Sports) Membership Retail
Travel industry airline, hotel, car and rail booking
Global Language and Currency Data Warehousing
Chapter: Personal Profile
Team development, Mentoring and training.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:-
On-site Experience
December 2013 - Date
Data Warehousing Technology Specialist, Business Analyst
Department For Education (Government), London, UK
The DfE is the UK government department with responsibility for infant, primary and secondary education. The Schools Performance
Data Program is a group of projects to update the schools performance tables and cross government data warehouse
Required Responsibilities:
 To gather requirements, needs analysis, and act as a technically focused consultant working as part of the DfE relaying guidelines
and expectations to third party development contractors.
 To offer technology expertise in tool selection, data platform optimisation for a Microsoft SQL Server 2012 solution.
 To manage and maintain expectations with external third party contractors.
 To act as a champion for the use of a canonical data exchange model.
 Document data architecture and data quality cleansing requirements, Master Data Management (MDM) and Data Consolidation
 Attribute Dictionary and Mapping Documents.
 Requirements Documentation and Accompanying Walkthrough presentations and project updates
Role Dimensions:
Government, Management Consulting, Data Architecture, Data Warehousing, Requirements Gathering and Documentation, MDM,
Master data, Stake Holder and Third Party management
August 2013 – December 2013
Data Warehousing Technology Specialist, ETL and Reports Lead
Financial Times, London, UK
The Financial Times is a prestigious and well respected international media provider and newspaper. With a reputation for providing
business and financial news in a pink paper the company is moving clearly to a digital format with FT.com and pushing for
international growth and flexible subscription services. This role is to design and build a financial and newspaper data warehouse and
reporting solution for BI purposed.
Required Responsibilities:
 To gather requirements, needs analysis, and design a series of tactical provisions and overall solution strategy for group level BI.
 To offer technology expertise in tool selection, data platform optimisation.
 Build and deliver a Business Intelligence Solution for the Business and Customer Subscriptions on Microsoft SQL 2012 using SSAS OLAP
 To design a working deployment to Amazon Web Services and to sit upon Redshift.
 To deliver a suite of metrics and subscription statistical, operational and financial reports. Reverse engineering current obsolete suite
and creating a flexible reconciled mechanism to enhance and elaborate on detail and new regulatory and revenue based
 To understand international constraints, resolve risks and issues and delivery according to budget and timelines.
 To shape requirements and offer analysis and write business cases, stakeholder management and working with multiple off shore
Solutions Synopsis:
 MS SQL Server 2012 SSIS, SSAS, SSRS and AWS – Solution Still In Progress
 The project is delivered in 6 two week sprints, with a very clean delivery scrum team, regular stand ups, kanban and showcases.
Multiple releases and complex deployment under tight deadlines.
May 2013 – July 2013
Executive KPI Consultant – Short assignment
Bupa, London, UK
Bupa Healthcare is an international provider of insurance, private healthcare, hospitals and pharmaceuticals. Over the last 10 years
the Bupa operation has expanded globally and evolved into a variety of products to fit each market. The Business is made of of 6 core
entities each having their own operational capability with Bupa Corporate providing overall IT support for all groups. This role was to
provide a design for a Business Executive IT dashboard to show how IT value is being achieved and monitored. The target audience is
the board level and the technology varied.
Section: On-site Experience
Role Dimensions:
Media, News, Rich Presentation, International Data Warehousing, OLAP Development, Amazon Web Services, Solutions Architecture,
Systems Design, ETL, Team Leading/mentoring.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:Required Responsibilities:
 To gather requirements, needs analysis, and design a series of tactical provisions and overall solution strategy for group level BI.
 To offer technology expertise in tool selection, data platform optimisation.
 To co-ordinate workshops and interviews to define the complete set of metrics and business definitions and come up with a set of
tangible business measures to evolve an enhanced level of business decisions.
Solutions Synopsis:
 A solution was presented to marry to the short, mid and long term strategies of the groups. IT value being very difficult to define was
proposed to be measured using project change, infrastructure expense and personally costs. A design of a dashboard to be built
upon the corporate BI platform and a working version delivered in MS Excel for Monthly and Quarterly publication. A further cloud
based solution was provided to show key metrics and performance indicators in High Visualisation upon IPads and Wall screens.
Role Dimensions:
Healthcare, Rich Presentation, Executive dashboards, YellowfinBI, International politics, International Data Warehousing, KPI Definition,
Data Design, IT Value Consultation.
March 2013 - May 2013
Business Intelligence Enterprise Data Warehouse Design and
Grafton Group Plc, Oxford, UK
Delivery Consultant – Short Assignment
Grafton Group is a holding company for nearly 100 subsidiary companies in the UK, Ireland and across Europe (Hirebase, Plumbase,
Woodies), principally centred on the building, construction and mining trade. As a modernisation and branding exercise at a
corporate level the Business Intelligence solution was in need of improvements and centralisation. This role was to spend some time
identifying opportunities for quick enhancements and design an enterprise strategy for the next 18 months. A BI Solution was to be
delivered according to a set of options, budgets and ERP possibilities that would cope with the variety of source systems across the 90
plus businesses.
Required Responsibilities:
 To gather requirements, needs analysis, and design a series of tactical provisions and overall solution strategy for group level BI.
 To offer technology expertise in tool selection, data platform optimisation.
 To design, plan and manage a delivery of a working concept of a Business Intelligence Solution principally on Microsoft SQL 2012
using Integration Services, PowerViews, Power Pivot and Reporting Services. Emphasis on Accurate data and Visualisations using
 To understand international constraints, resolve risks and issues and delivery according to budget and timelines.
 To shape requirements and offer analysis and write business cases.
Solutions Synopsis:
 Three projects defined – Upgrading the current Diver BI provision for the 13 Irish subsidiaries; Build a SQL Server data warehouse and
BI platform for the UK; Build addition interfaces in SSIS to Navision and Kerridge 8
 Installation and development of Relational Data Warehouse to feed SQL Server Analysis Services Cubes showing all aspects of
financial reporting and analysis, via Multidimensional and Tabular models to visualise in Power Views, YellowfinBI Cloud Score Cards
and Alteryx Analytics.
Role Dimensions:
Retail, Supply Chain, Rich Presentation, Stakeholder management, YellowfinBI, Complex Corporate Entities, International Data
Warehousing, Solutions Architecture, Systems Design, ETL, Team Leading/mentoring.
Section: On-site Experience
November 2012 – March 2013
Business Intelligence/ETL Solution Designer
Clear Channel Media, London
Clear Channel UK is part of Clear Channel International (CCI) which works with advertisers to create inspiring out-of-home advertising
campaigns in 30 countries across Europe and the Asia-Pacific region. The company has a growing portfolio, which is currently made
up of over half a million displays, which span traditional and digital formats on roadside billboards, street furniture and in retail, point of
sale, airport, transit and lifestyle environments. It employs over 5,000 people and, in 2010, its revenue was $1,508m. Clear Channel are
to embark on an ambitious global data centralization project consolidation AX financial data, Sales and Operational Panel data,
presenting within a rich application platform online and on multiple media.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:Required Responsibilities:
 To provide and overall solution design for the infrastructure, development method and data model.
 To build and develop a real time analytics platform feeding off an AX 2012 ERP implementation, using SSAS and Change Data
 To understand international constraints, resolve risks and issues and delivery according to budget and timelines.
 To shape requirements and offer analysis and co-ordinate expertise for new thinking analytics, rich visualisation and advanced
data mining.
Solutions Synopsis:
 The strategic solution pulled together already established resources in terms of developers and infrastructure, implementing a new
configuration of the virtual server estate and purchasing new physical database servers installed with SQL Server 2012.
 Data Collection processes in real time and overnight from 16 countries designed and configured in SSIS 2012.
 OLAP technology exploited to get ‘what if’ and ‘deep dive’ analysis
 A high visualisation online platform installed for web reporting via iPad, mobile device and wall screens, in addition to standard
office access, via SharePoint, Power Views and Reporting Services.
Role Dimensions:
Media, Advertising, Rich Presentation, Multi-Lingual, Off Shore Resource Management, International Data Warehousing, Solutions
Architecture, Systems Design, ETL, Team Leading/mentoring.
August 2012 – November 2012
BI Solution Designer/SSAS (Analysis Services) Trainer
LV=, Bournemouth
With over 5,500 employees working in 17 offices across the UK, we are the UK's largest friendly society and a leading financial mutual,
with more than five million members and customers. LV= provide life, car and house insurance via web and broker channels. The BI
team is well established and undergoing a transformation into Microsoft technologies to save on cost and improve service.
Required Responsibilities:
 To provide designs, training and architectural support on exploitation of Analysis Services and cube analysis technology.
 Assist and direct the design of re-engineering of established MI reporting, moving from a very complicated Excel provision to SSRS
via SSAS platform.
 To communicate table structure, data collection processes and view in Oracle PL SQL and Data Warehousing.
 To show how SharePoint 2010 can be a working platform for internal BI and MI provision.
 To take care of MDX scripting and complicated development.
Solutions Synopsis:
 All the business data is collected into an Oracle data warehouse, with solid tight Kimball methodology processes.
 Business views were derived to transform the data into a respectable format to make the most of the Analysis Services.
 Reporting Services is configured and very interesting and new ways of creating reports were shown to connect to the cubes and
replicate legacy BI with new capabilities.
Role Dimensions:
Insurance, Training, Solutions Architecture, Systems Design, Oracle Data Warehousing, Analysis Services, Reporting Services
Section: On-site Experience
July 2010 – October 2012
Business Intelligence Solution Designer/Architect
British Gas Centrica, London / Oxford / Leicester
British Gas is the UK’s primary energy provider. The Company is currently divided into sub companies to separate business from
residential electricity and gas supply. All new technology projects are handled for both arenas by IS and Business Intelligence functions
by the Application Design and Development team. All new BI projects are allocated to one of the lead architect/designers of
Business Intelligence solutions. These projects range from small tactical changes to nationwide corporate flag ship systems.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:Required Responsibilities:
 To provide designs and architectural support on numerous high profile projects.
 To offer technology expertise in fields of Business Intelligence principally on Microsoft SQL server 2008 R2 suite, Sharepoint 2010 and
SAP BW and Business Objects XIR3.
 To take on a position of design authority and delivery manager (scrum master) to numerous projects.
 To manage development team, infrastructure and quality.
 To deliver a viable strategic MI/BI solution to the nationwide SMART meter rollout
 To deliver a centralised Business Data Warehouse with central MI functions.
 To deliver a portfolio of MI advances and small projects understanding the requirements and converting the standing or required
process into a supported solution.
 To shape requirements and offer analysis and co-ordinate expertise for new thinking analytics and advanced data mining.
Solutions Synopsis:
 All strategic solutions are designed for a SAP BW using BODS and Business Objects delivery with the majority of development carried
out by off shore and in house development teams.
 All data warehouse, tactical and immediate solution designed and delivered using MS SQL Server 2008R2, SSIS, SSAS, SSRS and
Sharepoint 2010 with Performance Point, Power Pivot, Report Builder 3 and Excel and Visio services.
 The SMART Meter BI program is to be built within phases initially upon MS SQL Server and Teradata.
 The BRITE Debt Management BI Design.
 The EIDA Smart Metering data cleansing and editing system.
 The Online Consumption Hub database.
 MI and Data Transfer tool s and applications developed for User interfaces both internal and Customer facing, MVC3 Silverlight,
Adobe Flex.
Role Dimensions:
Utilities, Energy, Data Warehousing, Solutions Architecture, Systems Design, Large Data Consolidation, ETL, Team Leading/mentoring.
February 2010 – July 2010
Senior SQL Server Development Consultant
HSBC International Banking, London
(6 month Contract)
All financial institutions in the UK are required by law to deliver and have on hand at any time a complete suite of reports on what is
the state of current liquidity. The reports are required by the Financial Services Authority and must consolidate all areas of the business.
HSBC has two area requiring consolidation its Retail Bank business and the Global Markets and Investments.
Required Responsibilities:
 To build a team of top rate specialists capable of a demanding complex requirement and extremely high stress and high profile
 To offer design and development advice in consolidating over 100 data sources and feeds using SSIS.
 To provide expertise in development practices, development team coordination and Microsoft database development delivery.
 To deliver a complex data consolidation layer feeding into Liquidity Program before strict deadline and without defects.
 To define mapping and metrics for 72 key required measures for FSA and Basel III.
Solution Synopsis:
 The solution is built upon Microsoft SQL Server 2008, with 500 + SSIS ETL packages, collating market data feeds, source system data,
market data, ratings data and currencies. The data is initially house in a stage database and SQL procedure transform the data
into a data warehouse financial system (FinArch) . The final results are synchronised with Liquidity program and the batch is run daily
and according to bank testing, quality and production support requirements.
Role Dimensions:
Investment Banking, Data Warehouse, Finance, Asset Classes, Data Consolidation, ETL, Team Leading/mentoring.
Required Responsibilities:
 To collate and confirm requirements, orchestrate a release plan and manage expectations and missing resources.
 Design and plan a solution with Microsoft SQL server 2008 business intelligence products to meet requirements for the management
information and customer relationship management.
 To develop the solution, providing automated data transfer, regular reports and an advance OLAP analytical environment.
 To conclusively document the solution and manage testing and deployment.
Solution Synopsis:
 The solution is built upon Microsoft SQL Server 2008, with SSIS ETL packages, a SSAS OLAP cube and numerous interactive reports
upon Reporting Services combining legacy large CRM system data with disparate file data. A working Performance Point solution
was set up for score carding and KPI alerts. A full report suite for estate, product and account management is in production.
Role Dimensions:
Investment and Asset management, Hedge Funds, Credit and Regulatory Risk, OLAP Design, ETL Development, SQL Server
Section: On-site Experience
December 2009 – February 2010
Business Intelligence Consultant
Man Investments, Pfaffikon, Switzerland
(3 month Contract)
Man is one of the world’s largest independent alternative asset managers, Man is characterised by its global scale, strong financial
position and substantial surplus regulatory capital. For each area of the business Operations, Commercial Development, Marketing
and Customer Fulfilment a clean and mature investment has been initialised in a consolidated flexible business intelligence solution, to
combine investment performance monitoring with client estate and financial reporting.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:June 2009 – November 2009
Business Intelligence / SSAS Consultant (5 month Contract)
The London Stock Exchange Group, London, UK
Baikal is a new start-up company owned by the LSE group providing a new raft of pan European trading products specifically in the
provision of a Smart order router, a Dark Pool Trading market and a strategic crossing application. The company has gone live this year
as a broker service with an expectation to begin trading combined newly purchased market Turquoise early next year. To
complement the products a full BI suite is to be implemented within short notice and having to remain flexible during early stages of
trading. It must be tested according to rigorous standard and offer full recollection and analysis of the company references and
Required Responsibilities:
 To design and plan a solution with Microsoft SQL server 2008 business intelligence products to meet requirements for the
management information, surveillance and well-formed market checks.
 To develop the solution, providing automated data transfer, regular financial reports and an advance OLAP analytical
 To provide consultation and training and ensure tight quality assurance requirements for service delivery are met.
 To conclusively document the solution and manage testing and deployment.
Solution Synopsis:
 The solution collected multiple overnight and real time feeds from trading systems (Tradelect, Smarts and Fidessa) and disparate
updatable sources such as rates, fees and references from a Teradata system, CSV files and streamed messaging, via an integrated
modular SSIS solutions fired via ControlM. The data was stored in a staging data store that transformed into a dimensional data
warehouse and complimentary OLAP database and cube. A series of dynamic connections and required views were set up with
Performance point and the majority of canned reports were delivered using reporting services; however the heavy brunt of the
analysis made available through live connection with Excel to a cloned presentation OLAP cube. The solution used complex ETL
processes allowing for simpler MDX and a faster cube processing time. The solution was design to be highly available and fully
recoverable using very large data sets.
Role Dimensions:
Stocks, Equities, Instruments, Markets, Currencies, OLAP Design, ETL Development, SQL Server Consultation.
Apr 2009 – June 2009
Migration and CMS Database Developer
RTE, Dublin, Ireland
(3 month Contract)
RTE are the combined state Radio and TV broadcaster and commercially driven media corporation for Ireland. With a very prominent
web publishing estate, teletext service and television production capabilities, the corporation owns numerous data driven
applications and editorial management systems. During early 2009 a number of enhancement projects were initiated delivering new
products within minimum cost and resources.
Required Responsibilities:
 To advise, design and administer solutions for an Audio Visual Editorial Content Management System
 To conduct a considerably large migration from SQL 2000 and DTS processing to SQL Server 2008 and SSIS.
 To provide consultation on Microsoft SQL Server 2008 product suite and best practices in database development, administration
and management, making best use of available resources and installing maximum efficiency to support IPTV implementation.
 To update legacy XML data handling processes with higher performance methods.
 To advise on user application development for CMS, Live Statistics, News Reels, Live Data Feeds and Web Analytics.
Role Dimensions:
Media, Content Management, Database Development, MS SQL Server 2008, SSIS, Mirroring, XQuery, ASP .NET 3.5, C#
Jan 2009 – Apr 2009
Business Intelligence ETL Project Development Specialist
P&O Ferries, Dover, UK
(4 month Contract)
P&O are the UK’s primary passenger and freight shipping provider. A current project is underway to modernise the management
systems of the company, this extends to a business intelligence initiative to be built in MS SQL Server 2008, Analysis Services and
Cognos 8.4.
Role Dimensions:
Business Intelligence Development, Data Warehouse design and modelling, MS Analysis Services 2008, MDX, SSIS, Cognos 8.4, ASP.NET
2, C#
Mar 2008 – Jan 2009
Business Intelligence Team Lead – Scrum Master
British Sky Broadcasting Plc (BSKyB) -London UK
(10 Month Contract)
Sky TV is a subscription television service in the UK and the Republic of Ireland. It produces TV content, and owns several TV channels.
40 % equity is owned by News Corporation. Other products provided by Sky are Telephone, Broadband, Gaming and Email services.
The Online Business Unit during 2008 is redeveloping the Sky.com, Sky News and Sky Sports web portal estate aimed at being the third
most used home page in the UK.
Section: On-site Experience
Required Responsibilities:
 Design and develop an integrated ODS, Data warehouse, OLAP and business intelligence solution.
 To provide consultation on Agile development methods, Data and ETL development and testing
 To provide technical and commercial expertise in the use of MS SQL Server 2008, SSIS, SSAS and Cognos 8.4. B
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:Required Responsibilities:
 To act a solution expert and product stream manager to a series of business intelligence and web analytics data requirements.
 To facilitate feasibility analysis, gain detail to the requirements and to plan delivery of development.
 To design and manage agile development of multiple streams according to a capital expenditure budget reporting to
 To recruit and manage a team of skilled developers and analysts and build resources and toolkit.
 Design and develop a series of media rich data viewing applications and reports (Crystal Excelsius, Business Objects, PHP, MOSS
 Implementation of an Insight TV Channel (Not external).
 Implementation of MOSS 2007 and development of the site to meet the business units’ communication requirements.
 Large web estate tagging analysis, implementation and third party co-ordination (Omniture).
 Design and development of a Web Analytics Data Warehouse combining very large datasets from Hitbox, Google, Ad servers,
SkyView, Broadband traffic , the CRM system and Single Access Sign on databases.
 Design and co-ordination of the warehouse data into the high spec DiscoverOnPremise mining tool.
Role Dimensions:
Media, Web Analytics, Scrum Master, Agile Development, BI Project Management, MOSS 2007, Omniture, Oracle 11i, Oracle
Warehouse Builder, PHP, Flash
Nov2007 – Sep 2008
Microsoft Business Intelligence Specialist
Vantis Business Services Plc - London UK
(10 Months)
Vantis Plc is one of the AIM listed UK top accounting, tax and business advisory group on an aggressive growth initiative. The business
data is coordinated through a billing engine (Practice Engine), a CRM application (Interaction) and ERP solution (Navision).
Required Responsibilities:
 To identify business value from a data mining and modelling initiative, defining MI objectives, KPI’s
 To design and build a dimensional data warehouse for all billing, time and client data (Kimball method, SQL Server 2005/2008).
 To build an an OLAP database and construct KPI and mining displays (SSAS, Performance Point 2007, MDX, DMX)
 To build all ETL processes and manage mapping, modelling and deployment. (SSIS, Visio)
 To install user interfaces to view canned month reports, executive dashboards, scorecards and analytical platforms (Excel 2007,
Performance Point, SharePoint 2007, Reporting Services)
Role Dimensions:
SQL Server 2005 Database development, ETL SSIS Integration Services Package design and development, SSAS, Performance Point
2007, Time Billing, Data Warehousing mapping and modelling, Navision.
Mar 2007 – Jan 2008
ETL Specialist (SSIS)
GMAC RFC (Residential Capital) Continental Europe - Den Haag, Netherlands/
(10 Months – Europe Based)
Wiesbaden, Germany / Barcelona, Spain
GMAC Residential Funding Corporation is a subsidiary of GMAC Financial Services and provides innovative capital solutions to
businesses in a variety of markets and residential mortgages to the US, UK and Central Europe. During 2007 the Central European
Capital markets group embarked on numerous data initiatives driven by crucial sales and estate management, having obtained a
net income of €2.5 billion in the company’s first two years of operation.
Required Responsibilities:
 To train and mentor three small development teams based in Germany, Spain and The Netherlands in ETL development best
practices and methodologies, using MS SQL Server 2005 Integration Services (SSIS) acting as lead developer.
 To install practices and documentation procedures, enhancing the ETL design capabilities of the technical architects.
 To set up full testing, QA and deployment procedures with release control and User Acceptance.
 Delivered numerous highly complex SSIS packages for population of a Mortgage model Data Warehouse designed for hedging
and estate data analysis across Central Europe Capital Markets, building Dashboards to present information with interactive
 Ensured robust processes and procedures were in place with conventions, best practices and SOX compliance.
Additional Endeavours:
Emergency Hedge fund and Pool Tracker data process development for the Dutch GMAC Subsidiary.
Nov 2006 - Feb 2007
Business Intelligence Business Analyst
LVE, Liverpool Victoria Insurance - Bournemouth/Croydon, UK
(4 Month Contract)
LVE is an insurance brand providing mainstream insurance services. The company was due to start a major marketing campaign in
the UK as LVE during 2007. With a new Sales and Quote system being delivered in early 2007 understanding of the BI requirement and
a plan of implementation was to be documented to modernize the Liverpool Victoria BI Technology.
Section: On-site Experience
Role Dimensions:
SQL Server 2005, SSIS Integration Services Package design and development, Banking, Hedging, Capital Funding, Data Warehouse
mapping and modelling, ETL best practices and conventions.
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:Required Responsibilities:
 To offer options in the design and specification of an Oracle 10 g Enterprise Business Intelligence and Data Warehousing platform
to be implemented via an Indian third party vendor.
 Requirements Gathering, Specification documentation creation, workshop management, vendor management.
Role Dimensions:
Insurance, Business Analysis, Project Management, Requirements Analysis, Data Warehousing, Offshore Development Management
May 2006 - Feb 2007
Business Intelligence (MIS) Team Lead/Designer/Consultant
Lloyds TSB Insurance - Bournemouth/Newport, UK
(11 Months)
Direct Insurance is a primary insurance provider to the UK with products offered in Home, Motor, Life and Financial insurances. Business
is operated through numerous call-centres and an extensively web portfolio. The company operates a mature MI and data provision
department, based upon a highly restrictive environment, providing information to all levels from board pulse reports to call centre
staff daily sales statements and third party insurers.
Required Responsibilities:
 To design and present a specification for a Business Intelligence and Data Warehousing platform to be implemented as a part of a
complete modernization program during 2007.
 To dissect undocumented processes and improve the relationships between customers and MI department.
 To identify quick win opportunities and offer tactical and strategic plans for development.
 Implementation of data collection and transformation (DTS / SSIS) from multiple departments
 Design and development of an insurance model reporting data warehouse. (SQL Server, SSAS 2005, MDX)
 Implementation of customizable and scalable report scheduling tool for rapid multi report deployment, online analytical querying
and distribution hierarchy management to provide commission and incentive payment system with KPI Monitors, score-carding
and staff tracking statements.
Additional Endeavours:
 Redevelopment and automation of the manual KPI based sales and staff payment system.
 Implemented an additional Business Intelligence tool/component to provide multi user OLAP analysis, combining live and historic
data and promoting alternative angles to mine the data (SSAS).
 Provision of a rich animated suite of customizable Flash based reports both high and low brow, for wall screens and plasma
Role Dimensions:
Project Management, Business Intelligence Consultation, Implementation, Data Analysis, Database & application development T-SQL,
MIS, MS SQL Server, SSIS, VBA, Scheduler, Flash Animated Reporting.
Feb 2005 - April 2006
Automated Reports and Centralized MIS Developer
Fitness First Ltd, Poole, Dorset
(6 months Contract + 8 Months Extension)
Fitness First Plc was purchased from the FTSE by a capitalist investment company in 2002 and then sold to BCP in late 2005. Fitness First
has the largest estate of health and leisure clubs in the world and has the second largest stake in the global fitness market. As part of
a regeneration program in 2004 a bespoke point of sale transactional processing system was rolled out to every Fitness First Club
Required Responsibilities
 Designed and implemented a complex ETL process to collect data from 300 + sites (DTS / SSIS), later to enhance the process to a
Pan-Europe real time centralisation process. (SSIS, XML, MSMQ)
 Designed and developed a customer activity and retail data warehouse. (SQL Server 2005)
 Development of a suite of club system based on demand reports to provide local immediate performance tracking and vital
business statistics to enhance operational capability. (Crystal Reports)
 Implementation of a business intelligence platform for high-level dashboards, Analysis Cubes for trend analysis and detail
accounting. (SSAS 2005, Business Objects Enterprise XI R2, Web Intelligence)
Nov 2003 - Dec 2004
MI Analyst Developer / Business Analyst
Barclays Bank Plc / Accenture (Enable), Knutsford Cheshire
(3 Month Contract + Extension x 5)
Barclays Bank is one of the 'Big 4' UK clearing banks, of which is responsible for the processing and clearing of £3 Billion worth of
cheques every year via it's vendors. The Proof of Deposit Rollout program was an extremely high profile series of projects to restructure
the clearing process through all of Barclays' 1700 branches across the UK.
Required Responsibilities
 To capture and analyze detailed user requirements and feasibility for tactical and strategic MIS solution, identify sources; manage
third party suppliers and Barclays Data Warehousing Services.
 To explore solution and design, implement and administer tactical MIS utilizing the Barclays intranet/web/networked reporting
portals (Business Objects, Hummingbird BI Query) and implement for 1700 branches, with very large data flow and be accountable
for the £3 Billion of voucher clearing that occurs on each year.
 Delivery of a suite of tactical business intelligence dashboards with analytical commentary and KPI tracking - Daily and Weekly
Dashboards (Crystal Reports, Business Objects and MS Excel) and rollout program analysis and program reporting (PowerPoint
commentary and Ad-hoc SQL querying).
Additional Endeavours:
 Development and management of complex initiatives to provide tracking solutions for clearing processing errors (missing and
Section: On-site Experience
Role Dimensions:
Retail, Sports & Leisure, Automated Payment Systems, Management Information, Business Intelligence, Project Management, Business
Objects Enterprise XI R2, OLAP, Data-Warehousing development and maintenance, SQL Server 2005, Erwin
Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | 44 7830130600 Continued:returned cheques).To design and build an operational Workflow Management System/Task Tracker and MI reporting tool for the
100 user+ call centre.
Jun 2003 - Nov 2003
MIS Analyst Developer
TNS, Welwyn, United Kingdom
(6 Month Contract)
TNS is a leading provider of secure communication networks for the transaction industry. With the HQ in Reston, Virginia, TNS has
offices in 11 countries worldwide, with a communications and data centre in Sheffield and Banking ATM, POS and Cell-phone Pre Pay
specialist data centre.
Required Responsibilities:
 Delivery of solution to implement and administer Crystal Reports/Enterprise 9 with appropriate customizing of the packaged online
reporting application and construction of the hardware to enable online reporting.
 Design of a multitude of complex Crystal Reports with associated SQL stored procedures, highly presentable.
Jan 2001 - Jun 2003
MIS Analyst Developer / Business Analyst
TQ3 Travel Solutions, Camden, United Kingdom
TQ3, now BTI is a Global Business Travel Management Company. At the time was the third largest business travel management
company in the world. The company turnover in its second year netted €7 Billion and has grown to 1600 offices and 17,000 employees
based across 60 countries.
Required Responsibilities:
 To work up to being the principle contact for all MIS development and management of development & delivery of MIS &
database solutions across 60 countries, including Online Booking Tools, CRM applications and Business Intelligence.
Nov 1998 - Dec 2000
Sailing, travelling and working in Australia and New Zealand with Aerospace Industries returning to UK in 2000.
Sept. 1995 - Nov. 1998
Kingston University (Kingston-upon-Thames, England)
Courses Studied:
Technology Foundation Course & B.Sc. degree in Aeronautical Engineering
Modules: - Thermodynamics, Electronics and Avionics, Automotive Engineering, Mechanical Engineering, Aerospace Design,
Manufacturing and Processing, Materials Technology, Mathematics, Business and Marketing, Computing and IT.
Training: Extracurricular language courses; Editor of the University Weekly Newspaper; business management, interviewing technique
and meeting management training- (NUS training).
Sept. 1988 - July 1995
St Peters School and Sixth Form (Bournemouth, England)
Qualifications obtained:
A Level - Art & Design, General Studies. AS level - Mathematics
GCSE - Mathematics, Physics, Chemistry, Biology, English Language, Art & Design, Business Studies, French, Religious Studies,
Geography, English Literature
Skills Summary
Section: Education
 Application development using Eclipse, Macromedia Studio suite Dreamweaver, Visual Studio, .NET, ASP.NET, HTML, XML, PHP,
JavaScript and Web page design fundamentals.
 Knowledge of hardware, network architecture and technical processes of information delivery with databases, connectivity,
security and internet/intranet based systems. (Clustering, Database Connectivity, Web servers IIS, Apache, Terminal Services, File
Transfer, etc.)
 Expert in MS Product Suite MS Project, Visio, Macromedia Suite.
 A keen parent, sports enthusiast, and boat owner; interested in aviation and often indulges in golf, squash, snow sports and water
sports. In the past embarked on many various demanding activities; travelled extensively; Grasped many international diplomatic,
social and language skills.
Third Time Ltd | CV for Darren Harvey – Senior Business Intelligence Specialist | All Rights Reserved

Report this document