Darren Harvey Personal Details
Full Name - Darren Harvey Date of Birth - 28/05/1977 Nationality - British Location - UK – Dorset / London Status - married 4 dependants
07830130600
MCITP MCTS Business Intelligence
Office - +44 1929 477285 Mobile - +44 7830 130600 Mail - darren.harvey@rvprojects.co.uk Web – www.bay-it.co.uk www.rvprojects.co.uk
Professional Summary
A practiced development consultant and team lead of management information business intelligence initiatives, enterprise data warehouse development, 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 21 high profile Business Intelligence and information related implementation projects. Prince2 Practitioner and Agile development team leader Extensive people skills with great capacity to succeed in challenging situations political and technical. Excellent client handling and customer facing and interpersonal skills. Ability to prioritize, budget and manage heavy workloads for development initiatives within solo or team projects. 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.
Skills Summary
Report and analysis creation expertise in Excel, Business Objects XI Web Intelligence, SQL Server Reporting Services SSRS, PerformancePoint 2007, Crystal Reports, Oracle Reporting, Access Reporting, .NET charting and reporting, Flash Report Generation, PHP development , PowerPoint Microsoft Office, Windows and SQL Server Development Specialist, qualified as a MCITP & MCTS Microsoft Accredited Business Intelligence Developer Data modeler and designer of data warehouses and information applications in SQL Server 2000/2005 and Oracle systems utilizing Erwin, ERStudio and/or Visio, practicing Kimball, Inmon and Lindstetd methodologies ETL / ELT Development expertise in SSIS, BO Data Integrator, Informatica PowerCenter, Ab Initio, Data Man OLAP and Semantic Business Intelligence development expertise through SQL Server Analysis Services / 2005/2008 SSAS, MDX, DMX, Oracle, Business Objects and additional bespoke systems 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 Ability to design processes, procedures and documentation. Understand and negotiate, plan and prioritize. 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 modeling, Data warehousing design and Business Intelligence Programming, testing and implementation 4 Years 4 Years 4 years 8 years 8 years 8 years 6 years 5 years
Team development, Mentoring and training. Project Management of data related projects Systems Analysts, Design and implementation Business Analysis / Design within BI and Data Warehousing MIS/Business Intelligence Development Performance/Visualization Information, MI and Data Analysis Data Architecture Application Development
Industry Exposure
Chapter: Personal Details Media, Television and Online Web Analytics Travel industry airline, hotel, car and rail booking 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 Global Language and Currency Data Warehousing considerations.
1
Darren Harvey On-site Experience
07830130600
MCITP MCTS Business Intelligence
Jan 2009 – Date P&O Ferries, Dover, UK Business Intelligence Project Development Specialist 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. Required Responsibilities: Design and develop a integrated ODS, Data warehouse, OLAP and business intelligence solution. Co build and deploy the solution. To provide consultation on Agile development methods, Data and ETL testing, infrastructure implementation and training of operational teams. To provide technical and commercial expertise in the use of MS SQL Server 2008, SSIS, SSAS and Cognos 8.4. Mar 2008 – Jan 2009 Bristish Sky Broadcasting Plc (BSKyB) - Isleworth, London UK Business Intelligence Team Lead – Scrum Master (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. Required Responsibilities: To act a solution expert and product stream manager to a series of business intelligence and web analytics data requirements. To facilitate feasibilty analsysis, 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 programme. 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 2007) Implementation of a BI TV Channel (Not external). Implementation of MOSS 2007 and development of the site to meet the business units’ communication requirements. Web site estate tagging analysis and third party co-ordination (Omniture). Design and development of a Web Analytics Data Warehouse combining very large datasets from Hitbox, Google, Adservers, 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, Agile Development, BI Project Management, Visual Sciences, Customer Behaviour, Recruitment, Budget and Team Management. Nov2007 – Sep 2008 Vantis Business Services Plc, - London UK Microsoft Business Intelligence Specialist – London, United Kingdom (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). Responsibilities: To identify business value from a data mining and modeling initiative, defining MI objectives, KPI definitions and questions to be asked of the data warehouse. To design and build a dimensional data warehouse for all billing, work in progress and client data (Kimball method, SQL Server 2005/2008). To build an analytical platform within an OLAP database and construct KPI and mining displays (SSAS, Performance Point 2007, MDX, DMX) To build all ETL processes and manage mapping, modeling and deployment. (SSIS, Visio) To install user interfaces to view canned month reports, executive dashboards, scorecards and analytical platforms (Excel 2007, PerformancePoint, 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, best practices and conventions. Mar 2007 – Jan 2008 GMAC ResCap Continental Europe - Den Haag, Netherlands/ Wiesbaden, Germany / Barcelona, Spain) MIS Specialist (SSIS SSAS) (10 Months – Europe Based)
2
Chapter: On-site Experience
Darren Harvey
07830130600
MCITP MCTS Business Intelligence
GMAC ResCap 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. This required an experienced ETL developer to train, mentor and install development methodologies within the IM development team. 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 Captial Markets (Real Time SSAS OLAP Cubes feeding Business Objects Universe and Web Intelligence Reports). Ensured robust processes and procedures were in place with conventions, best practices and SOX compliance. Additional Endevours: Emergency Hedge fund and Pool Tracker data process development for the Dutch GMAC Subsiderary. Role Dimensions: SQL Server 2005, SSIS/SSAS Integration Services Package design and development, Business Objects, Banking, Hedging, Capital Funding, Data Warehouse mapping and modeling, ETL best practices and conventions.
Nov 2006 - Feb 2007 Liverpool Victoria / ABC Insurance - Bournemouth/Croydon, United Kingdom Business Intelligence Business Analyst (3 Month Contract - Consulting) 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. 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.
May 2006 - Feb 2007 Lloyds TSB Insurance - Bournemouth/Newport, United Kingdom Business Intelligence (MIS) Team Lead/Designer/Consultant (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-centers 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 provide consultation of best practices and provide cost effective solutions for improvement. To dissect undocumented processes and improve the relationships between customers and MI department. To identify quick win opportunities and offer tactical and strategic plans and development to meet the high demand and deadlines placed upon department. Implementation of data collection and transformation methods developed using DTS / SSIS from telephony, Marketing, HR and sales systems. 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 Endevours: 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 displays. Key Relationships: Insurance Sales Managers, Marketing Campaign Managers, Operations, Call Centre Staff
3
Chapter: On-site Experience
Darren Harvey
07830130600
MCITP MCTS Business Intelligence
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 Fitness First Ltd, Poole, Dorset Automated Reports and Centralized MIS Developer (14 months on contract) 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 worldwide. Responsibilities To undertake requirements gathering, functional and technical specification creation. 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 utilising Inmon methodologies and a CRM focussed strategy. (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) Development of executive dashboards and estate level management reporting pack for mining customer retention patterns and marketing effectiveness Additional Endevours: Centralized BACS billing and reconciliation process implemented with estate sales ledger and basic CRM integration. Data Collection and performance reporting of the door security system and automated locker system. Concept member in club activity data collection and reporting. Role Dimensions: Retail, Sports & Leisure, BACS, Management Information, Business Intelligence, Project Management, Business Objects Enterprise XI, Web Intelligence, OLAP Modeling, Support, Application Implementation, DataWarehousing development and maintenance, SQL Server 2005 Business Intelligence Studio, ERwin, Multi Site Environment. Nov 2003 - Dec 2004 Barclays Bank Plc / Accenture (Enable), Knutsford, Cheshire MI Analyst Developer / Business Analyst (3 Month Contract + Extension x 4 + 3 Months with CCDT) 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 Endevours: Management of Third Party data co-ordination of extract delivery and program team consultation. Development and management of complex initiatives to provide tracking solutions for clearing processing errors (missing and returned cheques). To design and build an operational Workflow Management System/Task Tracker and MI reporting tool for the 100 user+ call centre. The system is to store, manage and report on all clearing issues and resolutions integrating intelligent relationship analysis with the Proof of deposit data warehouse and PoD Strategic MI system.
Role Dimensions: Banking and Finance, Clearing, Management Information, Business Intelligence, Project Reporting, Data Analysis, Support, Consultation, Implementation, Hummingbird, Data-Model development and maintenance, TeraData Data warehousing, SQL Server 2k, T-SQL, Transactions. Jun 2003 - Nov 2003
4
Chapter: On-site Experience
Darren Harvey
07830130600
MCITP MCTS Business Intelligence
TNS, Welwyn, United Kingdom MIS Analyst Developer (6 Month Contract) (Online Reporting - MIS restructure and update) 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. Role Dimensions: Very Large Databases, Data Analysis, Data warehousing, T-SQL, MIS, Crystal Reports /Enterprise, Banking ATM's, POS, and Transactions. Jan 2001 - Jun 2003 TQ3 Travel Solutions, Camden, United Kingdom MIS Analyst Developer / Business Analyst (Permanent) 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. Role Dimensions: Data Analysis, Data warehousing, Data mining, SQL, MIS, OLAP, Crystal Reports, International travel. Multinational Sales Support/Access Developer Responsibilities: Development, analysis and requirement gathering to advised on improvements to the present system of creating reports, proposals and tenders for bids with global corporations. Nov 1998 - Dec 2000 Sailing, travelling and working in Australia and New Zealand with Aerospace Industries returning to UK in 2000.
Education
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; interviewing technique and meeting management - (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 Continued:
Advanced range of technical knowledge and awareness, through: Application development experience in reporting tools, business intelligence platforms, online ecommerce tools and booking tools. Using Eclipse, Macromedia Studio suite Dreamweaver, Visual Studio 2005, .NET, VB.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.) Very capable user and designer with image and illustration software - Adobe Photoshop 9 CS2, Fireworks, Flash Expert in MS Product Suite MS Project, Visio, Macromedia Suite. A keen parent, sports enthusiast, and boat owner; interested in aviation and often endulges in golf, squash, snow sports and water sports. In the past embarked on many various demanding activities; traveled extensively; Grasped many international diplomatic, social and language skills.
5
Chapter: Education