Resume for Darren Harvey MCITP, MCTS | Business Intelligence Solution Designer | )44 7830130600 Continued:-
Personal Details
Full Name - Darren HarveyDate of Birth - 28/05/1977
Nationality - British
Location - UK – Dorset
Status - Divorce 4 dependants / UK Security Clearance: EXPIRED
Office -+ 44 1202 313619
Mobile - + 44 7830 130 600
Mail -
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.· Following a proven set of conventions and appropriate methodologies, can prove best practice analysis, management and development of multiple enterprise deliveries.
· Completed 50 high profile Business Intelligence and information related implementation projects.
· Master of building rapport with extensive people skills and a great capacity to succeed in challenging situations political and technical.
· 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
· MCITP & MCTS Microsoft Accredited Business Intelligence Developer SQL Server Development Specialist (SQL 2005,SQL 2008 R2,2012) and MCTS Microsoft Office SharePoint Services technical specialist (MOSS 2007/2010/2013). Application Development with ASP.Net 4/4.5 and MVC 3.· Report and analysis creation expert in SharePoint, 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, Flash Report Generation, PHP development , PowerPoint
· Data modeller and designer of relational data warehouses and information applications in SQL Server 2000/2005/2008, Oracle 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, BO Data Integrator, Informatica PowerCenter, Ab Initio, Data Man. Well-equipped in C# Programming.
· OLAP data warehouse specialist and Semantic Business Intelligence development expertise through SQL Server Analysis Services / 2005/2008 SSAS, Cognos, Business Objects Universes, Oracle Discoverer/Hyperion and developer of additional bespoke systems. Strong scripter of MDX and DMX.
Team development, Mentoring and training. / Building, motivating, nurturing development technicians in Business Intelligence and Data Warehouse development / 7 Years
Project Management of data related projects / Planning, Control, Change Management, Budget Planning, Resource & timeline management / 8 Years
Systems Analysts, Design and implementation / Network infrastructure, Server/Hardware configuration and security / 11 years
Business Analysis / Design within BI and Data Warehousing / Ability to design processes procedures and documentation. Understand and negotiate, plan and prioritize. / 11 years
MIS/Business Intelligence Development / Database/Mart development, Reporting design, MI Analysis and Business Objects, Oracle and SQL Server deployment / 11 years
Performance/Visualization Information, MI and Data Analysis / Advanced SQL Server, Business Objects Crystal Reports, Access, Excel Development / 10 years
Data Architecture / Dimensional modelling, Data warehousing design and Business Intelligence / 9 years
Application Development / Programming, testing and implementation / 7 years
Industry Exposure
· Energy, Utilities· Investment Banking
· Media, Television and Online Web Analytics
· Stock Exchanges, Trading Systems
· Processes and ticketing transactional processing,
· Capital Markets Banking, Loans, Hedging and Mortgages
· Insurance, Financial & Large Call-Centres. / · Clearing, BACS and Payment processing.
· Banking and ATM processing.
· Retail and Point Of Sale Transactional processing.
· Health & Leisure (Fitness/Sports) Membership Retail
· Travel industry airline, hotel, car and rail booking
· Global Language and Currency Data Warehousing considerations
On-site Experience
July 2010 – October 2012
/Solution Designer/Architect (BI)
Clear Channel Media, London
Clear Channel UK is part ofClear Channel International (CCI)whichworks with advertisers to createinspiring out-of-home advertising campaignsin 30 countries across Europeand theAsia-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 onroadside billboards, street furniture andin retail,point of sale,airport, transitandlifestyle environments. It employs over 5,000 peopleand, 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.Required Responsibilities:
· To provide and overall solution design for the infrastructure, development method and data model.· To offer technology expertise in fields of Business Intelligence principally on Microsoft SQL server 2008 R2 suite, 2012 SSIS, SSAS and SSRS and ASP.Net and Strategy Companion.
· 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 viz online platform installed for web reporting via iPad, mobile device and wall screens, in addition to standard office access.
Role Dimensions:
Media, Advertising, Rich Presentation, Multi-Lingual, International Data Warehousing, Solutions Architecture, Systems Design, ETL, Team Leading/mentoring.August 2012 – November 2012
/Solution Designer/Trainer (BI)
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 ServicesJuly 2010 – October 2012
/Business Intelligence Solution Designer/Architect Team Lead
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.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
(6 month Contract)
HSBC International Banking, London
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 project.· 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.December 2009 – February 2010
/Business Intelligence Consultant
(3 month Contract)
Future Entertainment S.a.r.l. (Virgin Media Group), Luxembourg
Future Entertainment manage the Premium, View on Demand and Pay Per View television content for the UK cable TV provider Virgin Media and their 10 million customers, from a base in Luxembourg. 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 television performance monitoring with client estate and financial reporting.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:
Television, Media, Marketing, OLAP Design, ETL Development, SQL Server Consultation.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 compliment 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 transactions.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 environment.
· 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: